hi everybody,how can i export or get in excell data from chart “Engagement over time”
I need to report performace hour by hour but getting from chart is a bit tricky.When i asked AI,it is showing me only data for hour when campaign is sent
Hi there
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
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
