Hi Google Ads Support Team,
For AUDIENCE_PERFORMANCE_REPORT
<https://developers.google.com/adwords/api/docs/appendix/reports/audience-performance-report>
we have two download jobs depend on Google Adwords API and we are currently
work on migrate to Google Ads API.
The two download jobs one for performance and one for structure, and the
AWQL attached as below:
Performance report:
select
Date
,AccountCurrencyCode
,Id
,CampaignId
,CampaignName
,Device
,Impressions
,Clicks
,Cost
,UserListName
,BidModifier
,AdGroupId
>From AUDIENCE_PERFORMANCE_REPORT
WHERE Date>='2022-03-01' and Date<='2022-03-05'
Structure Report:
select
Date
, AccountCurrencyCode
, AccountDescriptiveName
, AccountTimeZone
, AdGroupId
, BaseAdGroupId
, BaseCampaignId
, BiddingStrategyId
, BiddingStrategyName
, BiddingStrategyType
, BidModifier
, CampaignId
, CampaignName
, CampaignStatus
, CpcBid
, CpcBidSource
, CpmBid
, CpmBidSource
, Criteria
, CriteriaDestinationUrl
, CriterionAttachmentLevel
, CustomerDescriptiveName
, ExternalCustomerId
, FinalAppUrls
, FinalMobileUrls
, FinalUrls
, Id
, IsRestrict
, Status
, TrackingUrlTemplate
, UrlCustomParameters
, UserListName
>From AUDIENCE_PERFORMANCE_REPORT
WHERE Date>='2022-03-01' and Date<='2022-03-05'
Base on Google Ads wiki there have two resources(ad_group_audience_view and
campaign_audience_view) mapped with Google
Adwords AUDIENCE_PERFORMANCE_REPORT. these two resources identify the
audience setup on ad group and campaign level. to get the same download
data as Google Adwords API we need query these two resources at the same
time and union the data download from ad_group_audience_view and
campaign_audience_view. but we found there have some data issues when
compare the download data from Adwords API and Ads API, detail list as
below:
let's take structure data on account:9379591500 as example:
we only could download three campaigns(6627375281,6622894038,6631463241)
data from Google Ads API campaign_audience_view and empty data from
ad_group_audience_view ,but could download 8
campaigns(6620508936,6616615373,6631463241,6613942486,6622894038,6627375281,6616561829,6724550877)
from Google Adwords API.
Google Ads API call detail
campaign_audience_view:
Request
-------
MethodName: google.ads.googleads.v9.services.GoogleAdsService/SearchStream
Endpoint: googleads.googleapis.com:443
Headers: {developer-token=REDACTED, login-customer-id=5749847778,
x-goog-api-client=gl-java/1.8.0_252 gccl/task ':google-ads:jar' property
'archiveVersion' gapic/task ':google-ads:jar' property 'archiveVersion'
gax/2.6.1 grpc/task ':google-ads:jar' property 'archiveVersion'}
Body: customer_id: "9379591500"
query: "SELECT segments.date, customer.currency_code,
customer.descriptive_name, customer.time_zone, campaign.base_campaign,
campaign.bidding_strategy, campaign.name, campaign.status FROM
campaign_audience_view where segments.date = \'2022-03-05\' "
Response
--------
Headers:
Metadata(content-disposition=attachment,content-type=application/grpc,date=Mon,
07 Mar 2022 06:44:55 GMT,alt-svc=h3=":443"; ma=2592000,h3-29=":443";
ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443";
ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43")
Body: results {
customer {
resource_name: "customers/9379591500"
descriptive_name: "US_Vertical_Null_Exact_30"
currency_code: "USD"
time_zone: "America/Los_Angeles"
}
campaign {
resource_name: "customers/9379591500/campaigns/6622894038"
status: ENABLED
base_campaign: "customers/9379591500/campaigns/6622894038"
name: "US Default Campaign (10-01-2019 01:00:29 16831706) abcId:
1141736"
bidding_strategy: "customers/9379591500/biddingStrategies/7970171881"
}
campaign_audience_view {
resource_name:
"customers/9379591500/campaignAudienceViews/6622894038~622524040998"
}
segments {
date: "2022-03-05"
}
}
results {
customer {
resource_name: "customers/9379591500"
descriptive_name: "US_Vertical_Null_Exact_30"
currency_code: "USD"
time_zone: "America/Los_Angeles"
}
campaign {
resource_name: "customers/9379591500/campaigns/6622894038"
status: ENABLED
base_campaign: "customers/9379591500/campaigns/6622894038"
... TRUNCATED. See README.md to configure/disable log truncation.
Failure message: null
Status: Status{code=OK, description=null, cause=null}.
ad_group_audience_view :
Request
-------
MethodName: google.ads.googleads.v9.services.GoogleAdsService/SearchStream
Endpoint: googleads.googleapis.com:443
Headers: {developer-token=REDACTED, login-customer-id=5749847778,
x-goog-api-client=gl-java/1.8.0_252 gccl/task ':google-ads:jar' property
'archiveVersion' gapic/task ':google-ads:jar' property 'archiveVersion'
gax/2.6.1 grpc/task ':google-ads:jar' property 'archiveVersion'}
Body: customer_id: "9379591500"
query: "SELECT segments.date, customer.currency_code,
customer.descriptive_name, customer.time_zone, ad_group.id,
ad_group.base_ad_group, ad_group.campaign,
ad_group_criterion.effective_cpm_bid_micros,
ad_group_criterion.effective_cpc_bid_source,
ad_group_criterion.effective_cpm_bid_source, customer.id,
ad_group_criterion.final_mobile_urls, ad_group_criterion.final_urls,
ad_group_criterion.criterion_id,
ad_group.targeting_setting.target_restrictions,
ad_group.tracking_url_template, ad_group.url_custom_parameters,
ad_group_criterion.status FROM ad_group_audience_view where segments.date
= \'2022-03-05\' "
Response
--------
Headers:
Metadata(content-type=application/grpc,request-id=0ddmYGmzn1Xn-IiPDx3mVQ,date=Mon,
07 Mar 2022 06:46:44 GMT,alt-svc=h3=":443"; ma=2592000,h3-29=":443";
ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443";
ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43")
Body: null
Failure message: null
Status: Status{code=OK, description=null, cause=null}.
Could you please help identify the root cause?
Thanks
Hao
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/8d04439a-6542-4a8a-9c23-513f432aa6a6n%40googlegroups.com.
