Conversion calculation from events

Forum|Forum|2 years ago
February 29, 2024
2 replies
69 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.

Best answer by saulblum

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