Within Ads Manager I can see applications submitted and appointments booked. When I try to grab all the metrics I need from Ads Manager using Facebook API, I can get all the ones I need EXCEPT applications submitted and appointments booked. I've tried everything I can think of, have searched with Google, used ChatGPT and Meta AI, to no avail.
Here's the code I have thus far that is the closest I have to working. It works with leads at least but still doesn't get me applications submitted and appointments scheduled, which are two of the most important metrics.
var urlAdAccountInsights = ".0/act_" + adAccountId +
"/insights?fields=campaign_name%2cimpressions%2cspend%2ccpc%2cctr%2ccpm%2cfrequency%2cclicks%2cinline_link_clicks%2cactions%2caction_values%2cconversion_values" +
"&date_preset=this_month&access_token=" + token;
var responseCampaignInsights = UrlFetchApp.fetch(urlAdAccountInsights);
var json = JSON.parse(responseCampaignInsights);
var data = json.data;
if (data.length > 0) {
var et = JSON.stringify(data);
var sub = et.substring(1, et.length - 1);
var campaignData = JSON.parse(sub);
var campaignName = campaignData.campaign_name;
var impressions = campaignData.impressions;
var spend = campaignData.spend;
var cpc = campaignData.cpc;
var cpm = campaignData.cpm;
var ctr = campaignData.ctr;
var frequency = campaignData.frequency;
var clicks = campaignData.clicks;
var linkclicks = campaignData.inline_link_clicks;
var leads = 0;
var applications = 0;
var appointments = 0;
if (campaignData.actions) {
campaignData.actions.forEach(action => {
if (action.action_type === "lead") {
leads = action.value;
} else if (action.action_type === "SubmitApplication") {
applications = action.value;
} else if (action.action_type === "schedule_total") {
appointments = action.value;
}
});
}
Logger.log(campaignData);