date_preset value error about facebook-ads-reporting-google-apps-script

[fredericharnois]

Hi @alexjs-dev

Glad this project can help out!

Could you give me more information as to what is being passed in FIELDS?

Also, just to be sure, in your actual code, are there backticks (`) around the URL?

Thanks!

[Alex-git-code]

Hi @fredericharnois ,

Thanks for your reply.
Yes i have backticks (`) around the URL, i don't know why are not displayed here.
Please see my code below(I will not display here the right value for token and ad account id for security reasons):

// ad account ID
const AD_ACCOUNT_ID = '102042577';

// ad, adset, campaign, account
const LEVEL = 'ad';

// https://developers.facebook.com/docs/marketing-api/insights/parameters#fields
const FIELDS = 'campaign_name, adset_name, ad_name, date_preset, reach, impressions, spend, cpm, inline_link_clicks, inline_link_click_ctr, cpc, conversions, conversion_values, cost_per_conversion, purchase_roas, actions';

// https://developers.facebook.com/docs/marketing-api/insights/parameters#param
const TIME_RANGE = 'yesterday';

// user access token linked to a Facebook app
const TOKEN = 'EAAZBMSK3S'

// number of days from 1 to 90
const TIME_INCREMENT = 1;

// https://developers.facebook.com/docs/marketing-api/insights/parameters#param
const FILTERING = [{'field':'action_type','operator':'IN','value':['offsite_conversion.fb_pixel_purchase', 'value' ,'link_click']}]

// DO NOT MODIFY ANYTHING BELOW //

function requestFacebookReport() {

// Builds the Facebook Ads Insights API URL
const facebookUrl = https://graph.facebook.com/v6.0/act_${AD_ACCOUNT_ID}/insights?level=${LEVEL}&fields=${FIELDS}&date_preset=${TIME_RANGE}&access_token=${TOKEN}&time_increment=${TIME_INCREMENT}&limit=5000;
const encodedFacebookUrl = encodeURI(facebookUrl);

const options = {
'method' : 'post'
};

// Fetches & parses the URL
const fetchRequest = UrlFetchApp.fetch(encodedFacebookUrl, options);
const results = JSON.parse(fetchRequest.getContentText());

// Caches the report run ID
const reportId = results.report_run_id;
const cache = CacheService.getScriptCache();
const cached = cache.get('campaign-report-id');

if (cached != null) {
cache.put('campaign-report-id', [], 1);
Utilities.sleep(1001);
cache.put('campaign-report-id', reportId, 21600);
} else {
cache.put('campaign-report-id', reportId, 21600);
};

Logger.log(cache.get('campaign-report-id'));
}

[Alex-git-code]

I discovered the error, i place date_preset as a field. Thanks anyway. i will close the issue

[pranvirsingh]

@Alex-git-code Can you please tell me what did you did exactly to make your code work?