Skip to main content
Solved

Campaign analytics by Shopify sales channel

  • August 18, 2022
  • 1 reply
  • 233 views

Forum|alt.badge.img+2

Hi,

 

We’ve run into an issue with analytics recently due to us now importing our offline store sales into Shopify. This is great for tracking how our EDMs influence instore purchasing as well as online, however it pools all attributed sales together in analytics. Is there any way to split metrics by sales channel in Klaviyo’s analytics? Or would you have any other suggestions about how we could go about reporting this data, even if it means exporting the data raw as a csv?

 

Cheers,

Ben

Best answer by Dov

Hi @benherro,

Thanks for sharing this question with us.

Since all of your sales data is being funneled into Shopify first, it sounds like the order data is being expressed in Klaviyo as Shopify “Placed Order” and “Ordered Product” metrics? If this is indeed the case, you can distinguish POS vs online data if you’re using Shopify POS - filtering using the source name in Klaviyo. Or you can use an integration like LightSpeed.

Also, passing order information to your Klaviyo account is possible using the API. That would create new, custom metrics in your account i.e. creating a metric for when an offline order is placed. This would use the Track API.

If you decide to move forward using a discrete metric for offline data vs online data (whether it’s using Lightspeed or the API), you can change the conversions metric for a given campaign or flow to give you an idea of who placed an order for which metric. You can find more information on achieving that for campaigns vs. flows here

Additionally, you can build a custom report for each metric if you wish to “dig deeper” into other information pertaining to that metric like clicks and opens and much more.

Exporting raw data from the analytics tab and separating it out manually is another viable solution. There’s a good community article (linking other resources to explore) on how to achieve that below:

 

I hope that’s helpful!

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

1 reply

Dov
Forum|alt.badge.img+61
  • Klaviyo Alum
  • 1493 replies
  • Answer
  • August 18, 2022

Hi @benherro,

Thanks for sharing this question with us.

Since all of your sales data is being funneled into Shopify first, it sounds like the order data is being expressed in Klaviyo as Shopify “Placed Order” and “Ordered Product” metrics? If this is indeed the case, you can distinguish POS vs online data if you’re using Shopify POS - filtering using the source name in Klaviyo. Or you can use an integration like LightSpeed.

Also, passing order information to your Klaviyo account is possible using the API. That would create new, custom metrics in your account i.e. creating a metric for when an offline order is placed. This would use the Track API.

If you decide to move forward using a discrete metric for offline data vs online data (whether it’s using Lightspeed or the API), you can change the conversions metric for a given campaign or flow to give you an idea of who placed an order for which metric. You can find more information on achieving that for campaigns vs. flows here

Additionally, you can build a custom report for each metric if you wish to “dig deeper” into other information pertaining to that metric like clicks and opens and much more.

Exporting raw data from the analytics tab and separating it out manually is another viable solution. There’s a good community article (linking other resources to explore) on how to achieve that below:

 

I hope that’s helpful!