Campaign Performance Report Missing Data

[Hao Long]

Hi Google Support Team,

We are focus on Google API migration from Adwords API to Ads API, during the migration we found there have huge gap between Adwords and Ads API download data.

let's take Campaign Performance Report as example:

Download Query from Google Adwords API: 

SELECT
Date
, CampaignId
, AccountCurrencyCode
, AccountDescriptiveName
, AccountTimeZone
, AdvertisingChannelSubType
, AdvertisingChannelType
, Amount
, BaseCampaignId
, BiddingStrategyId
, BiddingStrategyName
, BiddingStrategyType
, BudgetId
, CampaignDesktopBidModifier
, CampaignGroupId
, CampaignMobileBidModifier
, CampaignName
, CampaignStatus
, CampaignTabletBidModifier
, CampaignTrialType
, CustomerDescriptiveName
, EndDate
, EnhancedCpcEnabled
, ExternalCustomerId
, FinalUrlSuffix
, HasRecommendedBudget
, IsBudgetExplicitlyShared
, LabelIds
, Labels
, MaximizeConversionValueTargetRoas
, Period
, RecommendedBudgetAmount
, ServingStatus
, StartDate
, TotalAmount
, TrackingUrlTemplate
, UrlCustomParameters
FROM CAMPAIGN_PERFORMANCE_REPORT
WHERE Date>='2022-03-01' and Date<='2022-03-03'

Download Query from Google Ads API:

 select segments.date, campaign.id, customer.currency_code, customer.descriptive_name, customer.time_zone, campaign.advertising_channel_sub_type, campaign.advertising_channel_type, campaign_budget.amount_micros, campaign.base_campaign, campaign.bidding_strategy, bidding_strategy.name, campaign.bidding_strategy_type, campaign.campaign_budget, campaign.name, campaign.status, campaign.experiment_type, customer.descriptive_name, campaign.end_date, customer.id, campaign.final_url_suffix, campaign_budget.has_recommended_budget, campaign_budget.explicitly_shared, campaign.maximize_conversion_value.target_roas, campaign_budget.period, campaign_budget.recommended_budget_amount_micros, campaign.serving_status, campaign.start_date, campaign_budget.total_amount_micros, campaign.tracking_url_template, campaign.url_custom_parameters from campaign  where segments.date between "2022-03-01" and "2022-03-03" and metrics.impressions >= 0

Data questions when compare with data download from Adwords API and Ads API：

1. the data volume have huge gap: as there have no metrics(click/impr/cost) in the query, we could recognize as download campaign structure from API. we downloaded 37297 records everyday from Adwords API but data download from Ads API have obviously drop down. could you please help check the root cause?

API             date            count(1)
Adwords API        2022-03-01        37297
Ads API            2022-03-01        11179
Adwords API        2022-03-02        37297
Ads API            2022-03-02        10927
Adwords API        2022-03-03        37297
Ads API            2022-03-03        8058

2. some campaign can download from Adwords API but can not download need you help further check. below attached two cases for your refer:

a. campaign : 37973571

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: "6496854847"
query: "select segments.date, campaign.id, customer.currency_code, customer.descriptive_name, customer.time_zone, campaign.advertising_channel_sub_type, campaign.advertising_channel_type, campaign_budget.amount_micros, campaign.base_campaign, campaign.bidding_strategy, bidding_strategy.name, campaign.bidding_strategy_type, campaign.campaign_budget, campaign.name, campaign.status, campaign.experiment_type, customer.descriptive_name, campaign.end_date, customer.id, campaign.final_url_suffix, campaign_budget.has_recommended_budget, campaign_budget.explicitly_shared, campaign.maximize_conversion_value.target_roas, campaign_budget.period, campaign_budget.recommended_budget_amount_micros, campaign.serving_status, campaign.start_date, campaign_budget.total_amount_micros, campaign.tracking_url_template, campaign.url_custom_parameters, metrics.impressions from campaign  where segments.date between \'2022-03-01\' and \'2022-03-03\' and metrics.impressions >= 0 and campaign.id = 37973571"


Response
--------
Headers: Metadata(content-type=application/grpc,request-id=obfj38V1yWwsNtlMAG_3IQ,date=Fri, 04 Mar 2022 03:21:02 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}.

b. campaign id: 13825244615

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: "1961796180"
query: "select segments.date, campaign.id, customer.currency_code, customer.descriptive_name, customer.time_zone, campaign.advertising_channel_sub_type, campaign.advertising_channel_type, campaign_budget.amount_micros, campaign.base_campaign, campaign.bidding_strategy, bidding_strategy.name, campaign.bidding_strategy_type, campaign.campaign_budget, campaign.name, campaign.status, campaign.experiment_type, customer.descriptive_name, campaign.end_date, customer.id, campaign.final_url_suffix, campaign_budget.has_recommended_budget, campaign_budget.explicitly_shared, campaign.maximize_conversion_value.target_roas, campaign_budget.period, campaign_budget.recommended_budget_amount_micros, campaign.serving_status, campaign.start_date, campaign_budget.total_amount_micros, campaign.tracking_url_template, campaign.url_custom_parameters, metrics.impressions from campaign  where segments.date between \'2022-03-01\' and \'2022-03-03\' and metrics.impressions >= 0 and campaign.id = 13825244615"


Response
--------
Headers: Metadata(content-type=application/grpc,request-id=MwJYfyP6u65sUk5OVFaaJg,date=Fri, 04 Mar 2022 03:22:59 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}.

Thanks

Hao

[Hao Long]

The same case happened on Ad group performance, Ad performance report. it should have the same root cause as Campaign Performance migration. we are waiting for your updates.

Thanks

Hao 

[Anita Gupta]

Hi All,

Could you please tell me what steps you have taken to migrate from Adwords API to Google Ads API? It is really urgent. Please help.

[Hao Long]

Hi Google Support Team,

Could you please help looking into this thread?

Thanks

Hao

[Google Ads API Forum Advisor]

Hi Hao/Anita,

Thanks for reaching out to the Google Ads API Support.

Item#1

Since you are comparing the total records downloaded from Adwords API and Ads API, with your GAQL against CID 6496854847, I get an empty response. Could you please provide us complete request and response logs with the request-id where the count for Google Ads API v10 is mismatching with AdWords API records via the Reply privately to author option? This is so that I can investigate your concern.

Item#2

I can see that the missing campaign was due to a query containing a segments.date field. Upon investigating our end, it appears that the query resulted in an empty response since segment fields were added in the query. This is because as per this guide, zero impressions are always excluded when segmenting a report, provided all metrics are zero. This is how segments work. 

2.a

Here’s the below GAQL query to get the campaign 37973571 against account 6496854847:

SELECT campaign.id, customer.currency_code, customer.descriptive_name, customer.time_zone, campaign.advertising_channel_sub_type, campaign.advertising_channel_type, campaign_budget.amount_micros, campaign.base_campaign, campaign.bidding_strategy, bidding_strategy.name, campaign.bidding_strategy_type, campaign.campaign_budget, campaign.name, campaign.status, campaign.experiment_type, campaign.end_date, customer.id, campaign.final_url_suffix, campaign_budget.has_recommended_budget, campaign_budget.explicitly_shared, campaign.maximize_conversion_value.target_roas, campaign_budget.period, campaign_budget.recommended_budget_amount_micros, campaign.serving_status, campaign.start_date, campaign_budget.total_amount_micros, campaign.tracking_url_template, campaign.url_custom_parameters, metrics.impressions FROM campaign WHERE segments.date BETWEEN '2022-03-01' and '2022-03-03' AND metrics.impressions >= 0 AND campaign.id IN ('37973571')

2. B

Here’s the below GAQL query to get the campaign 13825244615 against account 1961796180:

SELECT campaign.id, customer.currency_code, customer.descriptive_name, customer.time_zone, campaign.advertising_channel_sub_type, campaign.advertising_channel_type, campaign_budget.amount_micros, campaign.base_campaign, campaign.bidding_strategy, bidding_strategy.name, campaign.bidding_strategy_type, campaign.campaign_budget, campaign.name, campaign.status, campaign.experiment_type, campaign.end_date, customer.id, campaign.final_url_suffix, campaign_budget.has_recommended_budget, campaign_budget.explicitly_shared, campaign.maximize_conversion_value.target_roas, campaign_budget.period, campaign_budget.recommended_budget_amount_micros, campaign.serving_status, campaign.start_date, campaign_budget.total_amount_micros, campaign.tracking_url_template, campaign.url_custom_parameters, metrics.impressions FROM campaign WHERE segments.date BETWEEN '2022-03-01' and '2022-03-03' AND metrics.impressions >= 0 AND campaign.id IN ('13825244615')

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2XlPIE:ref