Struggling with Creating an API-based Looker Dashboard

Question

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.

saulblum · Accepted Answer

Does the reporting API do what you need?https://developers.klaviyo.com/en/reference/reporting_api_overviewSpecifically, Query Campaign Values:

Mathilde · Answer

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

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials