Skip to main content
Solved

Query Metric Aggregate by list


Forum|alt.badge.img+4

Hi I would like to get metric data by list and segements ID, please guide me to do.

Best, 
Sanitman

Best answer by Brian Turcotte

Hi @santiagosanti!

I actually answered this question in another thread here:

 

Essentially, as of now you can only filter by List, not segment. Here is a list of the supported metrics and attributes by which this endpoint can be filtered:

 

Also, if you haven’t seen it, here’s the complete, expanded guide on how to use this endpoint effectively:

 

Best,

Brian

View original
Did this topic or the replies in the thread help you find an answer to your question?

5 replies

Brian Turcotte
Forum|alt.badge.img+37
  • Klaviyo Alum
  • 1393 replies
  • Answer
  • August 2, 2023

Hi @santiagosanti!

I actually answered this question in another thread here:

 

Essentially, as of now you can only filter by List, not segment. Here is a list of the supported metrics and attributes by which this endpoint can be filtered:

 

Also, if you haven’t seen it, here’s the complete, expanded guide on how to use this endpoint effectively:

 

Best,

Brian


Forum|alt.badge.img+4
  • Author
  • Active Contributor II
  • 25 replies
  • August 16, 2023

Hi @Brian Turcotte 

When I request with List I am getting empty data only. I am not sure why any metrics values is not aggreagted to list.

Can you guide me to get the list name / ID(ID would be better) and the amount of subscribers in the list?

Thank you for your response.

Best, 
Santi


Brian Turcotte
Forum|alt.badge.img+37

Hi @santiagosanti!

To get the List ID, you can either make a call to the Get Lists endpoint, which returns all lists in an account is filterable by ID, or, you can go into your Klaviyo account and find the list manually, and extra the List ID from the URL:

 

As per your second question, to find the number of profiles in a List, you can make a call to Get List and locate the “profile count” metric in the response:

 

 

Best,

Brian


Forum|alt.badge.img+4
  • Author
  • Active Contributor II
  • 25 replies
  • September 22, 2023

Hi @Brian Turcotte,

I'm currently working on obtaining the "Subscribed to List" metric with a specific List ID. My objective is to correlate metrics with list data, which requires me to access metrics filtered by List ID. I'm already familiar with using the Query Metric Aggregates Endpoint to retrieve metrics by Flow ID ($flow) and Campaign ID ($message).

Could you please guide me on how to retrieve metrics specifically by List ID? Your assistance is greatly appreciated.

Thank you for your response.

Best, Santi


Forum|alt.badge.img+4
  • Author
  • Active Contributor II
  • 25 replies
  • October 2, 2023

created new question, 

As this was unanswered for 10 days.