Conversion calculation from events

2 replies
76 views

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?

This topic has been closed for replies.

S

saulblumAnswer

Klaviyo Employee

Check out the Query Metrics Aggregate call:

https://developers.klaviyo.com/en/docs/using_the_query_metric_aggregates_endpoint#conversions

S

saulblumAnswer

Klaviyo Employee

Check out the Query Metrics Aggregate call:

https://developers.klaviyo.com/en/docs/using_the_query_metric_aggregates_endpoint#conversions

D

devidsAuthor

Contributor I

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...

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials