Skip to main content
Solved

how to break down results by message type in the Query Event api?


Forum|alt.badge.img+2

Hello,

i’m using the event query v2 api https://developers.klaviyo.com/en/reference/metric-export to get the shopify revenue metric and it works fine, i just wonder how to use the `by` parameter to break down the results by message type: campaign vs flow, something like this

 

 

Best answer by Taylor Tarpley

Hi there @ahmedk

 

Thanks for sharing your question with us! Happy to help! 

 

If you add additional parameters to your call in the ‘where’ section, you can filter the call to only pull the metrics from a specific flow and campaign. See below for what a call would look like for a specific campaign, the latter for what you insert in the ‘where’ section for data on flow revenue. 

 

Thanks for participating in the Community!

-Taylor

View original
Did this topic or the replies in the thread help you find an answer to your question?

2 replies

Taylor Tarpley
Community Manager
Forum|alt.badge.img+60
  • Community Manager
  • 2148 replies
  • Answer
  • July 15, 2022

Hi there @ahmedk

 

Thanks for sharing your question with us! Happy to help! 

 

If you add additional parameters to your call in the ‘where’ section, you can filter the call to only pull the metrics from a specific flow and campaign. See below for what a call would look like for a specific campaign, the latter for what you insert in the ‘where’ section for data on flow revenue. 

 

Thanks for participating in the Community!

-Taylor


Forum|alt.badge.img+2
  • Author
  • Contributor II
  • 3 replies
  • July 15, 2022

Hello @Taylor Tarpley , thanks so much for the reply. Actually, i was looking for a breakdown by message type instead of message id, is there a way to use the `by` column to break down by message type?