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 original
Check 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...
Reply
Log in to the Community
Use your Klaviyo credentials
Log in with Klaviyo
Use your Klaviyo credentials
Log in with KlaviyoEnter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.