Query Metric Aggregates filter by $source

Forum|Forum|2 years ago
September 25, 2023
3 replies
153 views

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

This topic has been closed for replies.

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

Brian Turcotte

Klaviyo Alum

Hi @neemias.santos!

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

Best,

Brian

N

neemias.santosAuthor

Contributor I

@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 TurcotteAnswer

Klaviyo Alum

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

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials