Skip to main content
Solved

Query Metric Aggregates filter by $source

  • September 25, 2023
  • 3 replies
  • 111 views

Forum|alt.badge.img+1

Hello There

Is it possible to use the "Query Metric Aggregates" for "Subscribed to List" but also filter by $source?

I would like to retrieve all unique profiles that have originated from the integration between Klaviyo and Shopify.

The query would look like this:

 

 

Thanks in advance

Best answer by Brian Turcotte

Hi @neemias.santos!

My apologies for the delay here! At this time, $Source is not an eligible attribute to group or filter by. The doc you correctly referenced on our Supported attributes lists all of the eligible attributes, so custom properties are also not eligible at this time. 

 

I have already forwarded this as a product request to our API team, and I will update the thread if anything changes.

 

Best,

Brian

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

3 replies

Brian Turcotte
Forum|alt.badge.img+37

Hi @neemias.santos!

I’m going to check on this with Engineering and then I’ll update the thread ASAP!

 

Best,

Brian


Forum|alt.badge.img+1
  • Author
  • Contributor I
  • 1 reply
  • September 26, 2023

@Brian Turcotte could you also check if is possible by any custom property?

I’ve added a custom property and I’d like to know what is the revenue for all profiles with a specific custom property.

I ready all docs related to Query Metric Aggregates but could not find a clue.
Links:
https://developers.klaviyo.com/en/docs/using_the_query_metric_aggregates_endpoint#revenue
https://developers.klaviyo.com/en/reference/query_metric_aggregates
https://developers.klaviyo.com/en/docs/supported_metrics_and_attributes


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

Hi @neemias.santos!

My apologies for the delay here! At this time, $Source is not an eligible attribute to group or filter by. The doc you correctly referenced on our Supported attributes lists all of the eligible attributes, so custom properties are also not eligible at this time. 

 

I have already forwarded this as a product request to our API team, and I will update the thread if anything changes.

 

Best,

Brian