What I want to create is a dashboard for clients. I’ve already worked out how to pull the Flow information I want. But Campaigns are evading me. I want a weekly aggregated list of Campaign stats. Eg.
Week Ending: April 12, 2025
Campaign Recipients
Campaign Opens
Campaign Clicks
Campaign Placed Order Total Sum
Campaign Spam
Campaign Unsubscribes
Etc.
Working with ChatGPT and we’re really struggling. Also struggling to find resources I can have ChatGPT use to create Apps Script that works. (I’m wanting to dump all the data into a Google Sheet and then draw that into Looker.) Alternatively, I’m looking for the single best third party connector that delivers a LOT of granular information. I just find them all lacking in this departmet.
Solved
Struggling with Creating an API-based Looker Dashboard
+2Best answer by saulblum
Does the reporting API do what you need?
https://developers.klaviyo.com/en/reference/reporting_api_overview
Specifically, Query Campaign Values:
Hi :)
I’m also looking into this at the moment. After testing third party connectors we’ve also concluded that we need our own setup to get data in the way we want.
I am at the beginning of the project, but feel free to reach out to share experiences. The goal for us is a connection from Klaviyo to Big Query and from there to Looker Studio.
However, we are most likely having similar considerations about how to pull and structure the data.
I will be looking into it more after the Easter holidays.
/Mathilde
Does the reporting API do what you need?
https://developers.klaviyo.com/en/reference/reporting_api_overview
Specifically, Query Campaign Values:
Log in to the Community
Use your Klaviyo credentials
Log in with Klaviyo
Use your Klaviyo credentials
Log in with KlaviyoEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.