Issue Filtering "metric-aggregates"

Question

Hello, I am trying to filter metric-aggregates endpoint to fetch metrics per campaign using the “Campaign Name” filter, but when tried the `Invalid filter supplied` error pops up. This seems to happen with all filters with a space between multiple words. Here is the request:

{   
    "data":
        {
            "type" : "metric-aggregate",
            "attributes" : 
                { "interval" : "month",
                  "metric_id" : "TGxjH2",
                  "measurements" : ["count"],
                  "filter": [ "greater-or-equal(datetime,2022-01-01T11:00:00Z)", 
                            "less-than(datetime,2023-01-01T11:00:00Z)", 
                            "equals(Campaign Name,'test')"]
                }
        }
}

Brian Turcotte · Accepted Answer

Hi @aleksa.gavrilovic!Sorry for the delay in getting back, it seems that someone accidentally marked a Best Answer prematurely!I think I see what’s going on here - the Campaign Name parameter is actually not a filter, but rather a dimension to be used under the “by” attribute. Per our documentation on this endpoint, thefilterheader can only apply to date-related fields:filter: list of filters for specific fields, must include time range using ISO 8601 format ("YYYY-MM-DDTHH:MM:SS.mmmmmm")The time range can be filtered by providing agreater-or-equalfilter on the datetime field, such as"greater-or-equal(datetime,2021-07-01T00:00:00)"and aless-thanfilter on the same datetime field, such as"less-than(datetime,2022-07-01T00:00:00)"The time range may span a maximum of one year. Time range dates may be set to a maximum of 5 years prior to the current dateFilter the list of supported aggregate dimensions using the common filter syntax, such as"equals(URL,\"https://www.klaviyo.com/\")"The “Campaign Name” parameter is only for use under the “by” attribute, which groups the response by aggregated function:by: optional attributes used to group by the aggregation functionWhen usingbyattributes, an emptydimensionsresponse is expected when the counts for the events do not have the associated dimension requested by the setbyattribute. For example, a query including"by": ["$flow"]will return an empty dimensions response for counts of metrics not associated with a$flowI hope this helps to clarify, and thanks for using the Community!- Brian

aleksa.gavrilovic · Answer

​Hi, @Brian Turcotte thanks for the fast reply!I’ve tried all of the available string functions but still get the same error. As I said this happens with all filters that have multiple words separated by a space (e.g. Client Type, Message Name etc.), but works fine with URL e.g. Could it be that I’m using the system incorrectly?Here is the error that I’m getting in all of the cases I stated above:​

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials