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?
Solved
Conversion calculation from events
+1Best answer by saulblum
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
+1Check 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...
Log in to the Community
Use your Klaviyo credentials
Log in with Klaviyo
Use your Klaviyo credentials
Log in with KlaviyoEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.