Using https://developers.klaviyo.com/en/reference/get_events how do I recreate the numbers in the conversion summary? Or is this coming from shopify’s data?
Best answer by saulblum
View originalUsing https://developers.klaviyo.com/en/reference/get_events how do I recreate the numbers in the conversion summary? Or is this coming from shopify’s data?
Best answer by saulblum
View originalCheck out the Query Metrics Aggregate call:
https://developers.klaviyo.com/en/docs/using_the_query_metric_aggregates_endpoint#conversions
Check out the Query Metrics Aggregate call:
https://developers.klaviyo.com/en/docs/using_the_query_metric_aggregates_endpoint#conversions
Yeah u pointed me in the right direction but damn its so complicated…
select top 10 o.*
from klaviyo_data m
join klaviyo_data o on o.type='event' and o.relationships.metric.data.id=m.id
where m.type='metric' and m.attributes.name='Placed Order' and m.attributes.integration.name='Shopify'
why dont u just put the string “Placed Order” into the event properties...
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.