Hi Oksana,
Thank you for getting back to us.
Please be informed that I have removed your response from the forums as it contains the PII information.
By reviewing your concern, I understand that you are getting issues with the “phoneCalls'' field while adding the segments.ad_network_type in the GAQL query. Could you kindly provide us the UI screenshot of the Google Ads account and highlight the fields that you want to retrieve via the API?
You can send the details via Reply privately to the author option, or direct private reply to this email.
Please find your message with redacted information:
1. "query":"SELECT
customer.id, customer.descriptive_name,
campaign.id,
campaign.name, segments.ad_network_type, segments.date, metrics.impressions, metrics.clicks, metrics.phone_impressions, metrics.phone_calls FROM campaign WHERE segments.date>='2023-09-14' AND segments.date<='2023-09-14' AND
campaign.id IN (XXXXXXXXXX) ORDER BY segments.date DESC”
Result:
{
"campaign": {
"resourceName": "customers\/XXXXXXXXXX\/campaigns\/XXXXXXXXXX",
"id": "XXXXXXXXXXX",
"name": "Discovery - Inventory Expansion"
},
"customer": {
"resourceName": "customers\/XXXXXXXXXX",
"id": "XXXXXXXXXX",
"descriptiveName": "Palmetto57 Nissan"
},
"metrics": {
"clicks": "3",
"impressions": "226",
"phoneCalls": "0",
"phoneImpressions": "0"
},
"segments": {
"adNetworkType": "MIXED",
"date": "2023-09-14"
}
}
2. "query":"SELECT
customer.id, customer.descriptive_name,
campaign.id,
campaign.name, segments.date, metrics.impressions, metrics.clicks, metrics.phone_impressions, metrics.phone_calls FROM campaign WHERE segments.date>='2023-09-14' AND segments.date<='2023-09-14' AND
campaign.id IN (XXXXXXXXXX) ORDER BY segments.date DESC” (only segments.ad_network_type was removed)
Result:
{
"campaign": {
"resourceName": "customers\/XXXXXXXXXX\/campaigns\/XXXXXXXXXXX",
"id": "XXXXXXXXXXXXX",
"name": "Discovery - Inventory Expansion"
},
"customer": {
"resourceName": "customers\/XXXXXXXXXX",
"id": "XXXXXXXXXXX",
"descriptiveName": "Palmetto57 Nissan"
},
"metrics": {
"clicks": "3",
"impressions": "226",
"phoneCalls": "2",
"phoneImpressions": "0"
},
"segments": {
"date": "2023-09-14"
}
}
My question is why do we get "phoneCalls": “0” having segments.ad_network_type in query? Expected result is "phoneCalls": “2”.
Note we didn’t observe similar issues for other accounts we pull Google Ads API reports data for.
Please help to understand what is wrong here.