Facebook Graph Api Insights Filtering Param Usage

Question

For filtering param, This page demo-ed IN and CONTAIN,

https://developers.facebook.com/docs/marketing-api/insights/v2.4#filtering

curl -G \
-d "filtering=[{'field':'adgroup.delivery_info','operator':'IN','value':['archived']}]" \
-d "access_token=<ACCESS_TOKEN>" \
"https://graph.facebook.com/<API_VERSION>/act_<AD_ACCOUNT_ID>/insights"

curl -G \
-d "filtering=[{'field':'adcampaign.name','operator':'CONTAIN','value':'18-25'}]" \
-d "access_token=<ACCESS_TOKEN>" \
"https://graph.facebook.com/<API_VERSION>/act_<AD_ACCOUNT_ID>/insights"

But the information is very limited. Where can I find more info about the usage of filtering? e.g. How it should be if I want to filter out all items with blank (ad campaign) names? Or only the items with some attr (any type, e.g. dict or array) not empty (undefined).

Answer 1

Docs are not very rich, but it's possible.

Docs says it only works for /insight route, but its working for /adsets too

Use filtering query param like this :

curl -G \
-d 'access_token=<ACCESS_TOKEN>' \
-d 'filtering=[{field:"ad.impressions",operator:"GREATER_THAN",value:0},]' \
'https://graph.facebook.com/v14.0/act_<ACCOUNT_ID>/insights'

Use filtering parameter only to retrieve insights for ad objects with data. The field value specified in filtering uses DOT notation to denote the fields under the object. Please note that filtering with STARTS_WITH and CONTAIN does not change the summary data. In this case, use the IN operator.

Add more filters like this (note its and AND operator between each filter):

-d 'filtering=[{field:"ad.impressions",operator:"GREATER_THAN",value:0},{field:"ad.spend",operator:"GREATER_THAN",value:100}]' 

Here are two little "explanations" from official docs :

Ref 1

Ref 2

Answer 2

Perhaps here you can find which fields are filterable and which operators are supported.

https://developers.facebook.com/docs/marketing-api/ad-rules/overview/evaluation-spec

Description in section Metadata filters supported by Trigger and Schedule Based rules