I'm fetching report for specific ad Ids. But when I fetch from the adwords
API (current situation in production) I get different result in terms of ad
reports than I'm getting on the new Google Ads API.
I used the migration page to migrate my query from AWQL to GAQL :
https://developers.google.com/google-ads/api/docs/migration/reports but I'm
unable to get it to work.
My AWQL quer is:
SELECT
Id,
Headline,
AdGroupName,
AdGroupId,
CampaignId,
AdGroupId,
Impressions,
Cost,
Date,
DayOfWeek,
Clicks,
Ctr,
Conversions,
CostPerConversion
FROM AD_PERFORMANCE_REPORT
WHERE AdGroupStatus IN [ENABLED]
AND Id IN [425030385055,425030242723,424967919984,425068875116]
DURING 20200301,20200331
My GAQL query is:
SELECT
customer.id,
customer.descriptive_name,
customer.currency_code,
campaign.id,
campaign.name,
ad_group.id,
ad_group.name,
ad_group.status,
ad_group_ad.ad.id,
ad_group_ad.ad.name,
ad_group_ad.ad.final_urls,
ad_group_ad.ad.text_ad.headline,
segments.date,
segments.day_of_week,
metrics.impressions,
metrics.ctr,
metrics.clicks,
metrics.conversions,
metrics.cost_per_conversion
FROM ad_group_ad
WHERE segments.date BETWEEN '20200301' AND '20200331'
AND ad_group_ad.status = 'ENABLED'
AND ad_group_ad.ad.id = '425030385055' AND ad_group_ad.ad.id =
'425030242723' AND ad_group_ad.ad.id = '424967919984' AND ad_group_ad.ad.id
= '425068875116'
The Adwords Query DOES return reports where the Google Ads Query does NOT
return report for these Ids.
When removing the ad Ids it does return reports in this format:
{
"customer": {
"resourceName": "customers/12345678",
"id": "12345678",
"descriptiveName": "-",
"currencyCode": "EUR"
},
"campaign": {
"resourceName": "customers/12345678/campaigns/9589685408",
"id": "9589685408",
"name": "Test Optimize Campaign II"
},
"adGroup": {
"resourceName": "customers/12345678/adGroups/100868095818",
"id": "100868095818",
"name": "Ad group 2",
"status": "ENABLED"
},
"metrics": {
"clicks": "5",
"conversions": 0,
"ctr": 0.00181422351233672,
"impressions": "2756"
},
"adGroupAd": {
"resourceName":
"customers/12345678/adGroupAds/100868095818~427121490686",
"ad": {
"id": "427121490686",
"finalUrls": [
"https://test.nl";
],
"name": "---",
"resourceName": "customers/12345678/ads/427121490686"
}
},
"segments": {
"date": "2020-03-26",
"dayOfWeek": "THURSDAY"
}
},
in the adgroupad ad id it doesn't fetch any reports for those Ad Ids AT
all..
This is very weird and I would like to know why or what I'm doing wrong. :D
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/5cf2f443-7e98-43ad-a915-203917257fbd%40googlegroups.com.
