Skip to main content
Solved

used coupon in report


Forum|alt.badge.img+3

Hi,

I would like to get a good insight in which couponcodes are used by customer, prefarably linked to an order.

How can I do that? Report? Segment?

Any suggestions?

Appreciate your help.

Best answer by David To

Hey @Ruud - The Bulb Farmers,

For a number of our native integrations such as Shopify, you can accomplish this through several methods: 

  1. Grouping the Placed Order metric data in it’s chart view using “By Discount Code”

     

  2. Filtering the Placed Order metric data by “Discount codes equal X”

     

  3. Running a single metric deep dive report on the Placed Order metric by either grouping or filtering by discount code

Since Shopware would have a custom integration with Klaviyo, this would all hinge on how the Placed Order metric is being passed to Klaviyo. If your custom Placed Order event is using the same format as what we suggest in our Integrate a platform without a pre-built Klaviyo integration Developer Portal, you should be able to use the same methods mentioned. 

Else, I would suggest exploring if you have the capability to generate a similar report within your Shopware’s backend. 

David

 

View original
Did this topic or the replies in the thread help you find an answer to your question?

11 replies

Mailbox Manny
Partner - Silver
Forum|alt.badge.img+38
  • Partner - Silver
  • 417 replies
  • October 17, 2022

Hi @Ruud - The Bulb Farmers, if you’re using Shopify you can do that in the Sales By Discount report in your Shopify Reporting section:

 

https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/sales-report#sales-by-discount


Forum|alt.badge.img+3

Thanks Manny, but we are using Shopware. Any suggestions?


alex.hong
Forum|alt.badge.img+58
  • Klaviyo Alum
  • 1552 replies
  • October 18, 2022

Hi @Ruud - The Bulb Farmers ,

Unfortunately, Klaviyo doesn't have a native integration with Shopware 6 but you can utilize a third party integration in order to connect your Shopware platform with Klaviyo. I have included some resources below that explores a few options with syncing Shopware to Klaviyo.

Klaviyo + Shopware Integration

Helpful Links

Review Your Integrations
How Information Is Exchanged Between Klaviyo and Apps
Integration FAQ


Forum|alt.badge.img+3

Thanks Alex.

We have already connection between Klaviyo and Shopware.

 

My question is which setting to use to make a (custom) report including the used coupons. Any suggestions?

 

Or maybe define a segment including customers which have used a coupon?


alex.hong
Forum|alt.badge.img+58
  • Klaviyo Alum
  • 1552 replies
  • October 19, 2022

Hi there @Ruud - The Bulb Farmers ,

If you upload the coupon codes from Shopware into Klaviyo, you could use a conditional that is based on who uses a coupon. 

 We don’t sync or support Coupons through the plugin so if you do have a list of codes, then manual upload would be the way to go.

Reference.


Forum|alt.badge.img+3

Thanks for the feedback. 
 

My question is whether it is possible to reflect in a report which customers/orders used which couponcodes.

Appreciate your feedback.


David To
Klaviyo Employee
Forum|alt.badge.img+60
  • Klaviyo Employee
  • 2456 replies
  • Answer
  • November 8, 2022

Hey @Ruud - The Bulb Farmers,

For a number of our native integrations such as Shopify, you can accomplish this through several methods: 

  1. Grouping the Placed Order metric data in it’s chart view using “By Discount Code”

     

  2. Filtering the Placed Order metric data by “Discount codes equal X”

     

  3. Running a single metric deep dive report on the Placed Order metric by either grouping or filtering by discount code

Since Shopware would have a custom integration with Klaviyo, this would all hinge on how the Placed Order metric is being passed to Klaviyo. If your custom Placed Order event is using the same format as what we suggest in our Integrate a platform without a pre-built Klaviyo integration Developer Portal, you should be able to use the same methods mentioned. 

Else, I would suggest exploring if you have the capability to generate a similar report within your Shopware’s backend. 

David

 


Forum|alt.badge.img+3

Thanks David.

We use Shopware and cannot find the property ‘Discount codes’ in the selection box for the filter/group (as is possible with Shopify).  However we can find it at profiles, but it is seperate from properties etc.. Any suggestion how we can make that visible in the drop-down?

 



p.s. we use Shopware cLoud and they do not supprt any report with discount codes as you suggested.

 


Murray Finlayson
Contributor IV
Forum|alt.badge.img+5

If you use dynamic, unique codes, forget about ever trying to generate any reports.

It is technically possible. But as Klaviyo does not let you filter coupons by their prefix, you literally have to select every single unique code, one by one. In some countries, it’s used as a form of torture. It’s brutal!


Taylor Tarpley
Community Manager
Forum|alt.badge.img+60
  • Community Manager
  • 2148 replies
  • April 19, 2024

Hi @Murray Finlayson

 

Thanks for sharing this feedback with us! I have logged it with our product team! 

 

-Taylor 


Vesna EGarden
Active Contributor I
Forum|alt.badge.img+4
  • Active Contributor I
  • 10 replies
  • June 12, 2024
Murray Finlayson wrote:

If you use dynamic, unique codes, forget about ever trying to generate any reports.

It is technically possible. But as Klaviyo does not let you filter coupons by their prefix, you literally have to select every single unique code, one by one. In some countries, it’s used as a form of torture. It’s brutal!

Totally agree. It is a nightmare but I think easy to solve by Klaviyo. Like also constantly updating discount codes for combinations in Shopify which could be set in Klaviyo at first and then just cloned with combinations. Please dear Klaviyo friends, solve this!  Thank you