Guys, I'm making a request to the FB Ads API to get my adsets list but I want to navigate between specific period of dates like the normal users interface on the Power Editor, this is my request query:
https: //graph.facebook.com/v2.9/2/adsets?fields=name,insights.fields(cpc,ctr,cpm,clicks,impressions,spend,reach)
I need some help does anyone know how to solve this, I need the specific sintaxis of the request.
Hi Erick!
Facebook Ads uses the time_range[since] and time_range[until] parameters to set date ranges. For example, if you want to see data for the past 60 days, you can utilize Klipfolio's date parameters your request query could look something like this:
https://graph.facebook.com/v2.9/act_<actId>/insights?level=adset&fields=adset_name,adset_id,cpc,ctr,cpm,clicks,impressions,spend,reach&time_range[since]={date.add(-60).format()}&time_range[until]={date.today}&limit=5000
If you want to select a specific time period via a date picker, you can set-up your date pickers. Take note of the variable names and ensure the output format is yyyy-MM-dd as this is the date format that Facebook Ads uses. In the query, input the start date variable for the [since]= value and the end date variable for the [until] value. For example:
...time_range[since]={props.startDate}&time_range[until]={props.endDate}...
You will also need to have these date pickers set to react on button press so add a button to the klip. Here is information on how to co-ordinate multiple user input controls via button press. This is necessary as both dates need to be sent to the query at the same time so the query can run successfully.
Once this is completed, any klip that is using this dynamic data source will update once you select the dates and press the submit button.
Hopefully this helps you.
Happy Dashboarding!
Adam
