how to get data in excell for campaigns

Hi there ​@Bojan! 

You can hover over the bars to view the values, but the chart itself does not appear to offer a direct Excel export. The standard campaign analytics export provides campaign-level results, not the hourly chart breakdown.

For a more detailed report, you could export the relevant engagement events, such as Opened Email, along with send or recipient activity, then combine them in Excel and group the timestamps by hour. Just keep in mind that report timestamps use your account’s local time.

Alternatively, although more technical, you can use Klaviyo’s Metrics API to pull this data. Use the Query Metric Aggregates endpoint to retrieve metrics such as Received Email, Opened Email, and Clicked Email, then group the results by hour. Use the campaign message ID as the $message_send_cohort dimension, set the interval to hour, and use your account’s timezone so the results line up with the chart as closely as possible: Query Metric Aggregates.

I hope this helps! 

 

Temi@Klaviyo