Hi,
Running into an issue that I cannot seem to find any documentation on, so any help would be very welcome!
I’m trying to use the Klaviyo Metrics API (documented here). I’m able to successfully execute some queries in my terminal, and I’m ultimately pulling this information into google sheets to run various client reports for their Klaviyo data. Ultimately, I want to pull aggregate metrics by date such as “Active on Site”, “Bounced Email”, “Clicked Email”, “Marked Email as Spam”, etc. The more granular the data, the better, but we’ll see what kind of limits I run into with Google Sheets.
The problem
While I can successfully execute general queries for all metrics (from this page on their documentation for instance), I cannot execute ANY queries where “metric_id” is a required value. Furthermore, there doesn’t appear to be any documentation on metric_id, or what values are actually valid.
Example
This page hints that i can pull events for a specific metric. The first field they ask for is “metric_id” for which their “example value” and their “default value” returns an error for. this value is simply METRIC_ID, which I wouldn’t expect to return anything helpful.
My two part question
Am I on the right track? Will querying their api for events from a specific metric get me what I want here? If so, is there a resource that explains how I can get metric_id’s for various metrics on my Klaviyo accounts? If not, which API should I be digging into to get these types of metrics surfaced?
Any help would be amazing. Thank you!
Taylor