Campaign data discrepancy in Google Ads API and AdWords Report API

[duca...@gmail.com]

Hi team,

We are using both Google Ads API and AdWords Reporting API to fetch Campaign data, but looks some deleted campaigns are only returned from AdWords report API, not from Google Ads API.

This doesn't repro for all customers. It only show up for a few customers' account. 

Can you please let me know if this is expected? Does Google Ads and AdWords Report API have different retention days for deleted campaigns? Thanks！

Caihua. 

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out.

So our team can investigate, could you provide your customer ID and the following details :

For the AdWords API report  :

• complete report definition in XML or AWQL format including any date filters used

For the Google Ads API report, you may provide the following

• raw GAQL with the date filters
• complete request and response logs, with the request-id

You may then send the requested information via the Reply privately to author option.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2GJ6CU:ref

[Caihua Du]

Thanks Peter for reaching out. 

Would like to clarify that the discrepancy is between AdWords API (not the AdWords report API) and Google Ads API. Sorry for the confusion. 

Here is the request that we send over to Google Ads. We were expecting 14 campaigns to be returned back, but only 4 returned instead. Please note, due to log volumes we only have summary log instead of verbose log, so request id somehow didn't show up in the log. I guess the query and customer id should be sufficient for the investigation. 

Can you please help to check further here?

[2021-05-05 12:01:45Z] - Request made: Host: https://googleads.googleapis.com, Method: /google.ads.googleads.v6.services.GoogleAdsService/SearchStream, ClientCustomerID: 8610439045,  RequestID: , IsFault: False, FaultMessage: 

SELECT bidding_strategy.id, campaign_budget.amount_micros, campaign_budget.explicitly_shared, campaign_budget.delivery_method, campaign_budget.id, campaign.advertising_channel_type, campaign.advertising_channel_sub_type, campaign.ad_serving_optimization_status, campaign.bidding_strategy_type, campaign.dynamic_search_ads_setting.domain_name, campaign.dynamic_search_ads_setting.feeds, campaign.dynamic_search_ads_setting.language_code, campaign.dynamic_search_ads_setting.use_supplied_urls_only, campaign.end_date, campaign.geo_target_type_setting.positive_geo_target_type, campaign.geo_target_type_setting.negative_geo_target_type, campaign.id, campaign.manual_cpc.enhanced_cpc_enabled, campaign.real_time_bidding_setting.opt_in, campaign.name, campaign.network_settings.target_google_search, campaign.network_settings.target_partner_search_network, campaign.network_settings.target_search_network, campaign.network_settings.target_content_network, campaign.serving_status, campaign.shopping_setting.campaign_priority, campaign.shopping_setting.enable_local, campaign.shopping_setting.merchant_id, campaign.shopping_setting.sales_country, campaign.start_date, campaign.status, campaign.target_spend.cpc_bid_ceiling_micros, campaign.target_cpa.cpc_bid_ceiling_micros, campaign.target_cpa.target_cpa_micros, campaign.tracking_setting.tracking_url, campaign.tracking_url_template, campaign.url_custom_parameters, campaign.target_impression_share.cpc_bid_ceiling_micros, campaign.target_impression_share.location, campaign.target_impression_share.location_fraction_micros, campaign.final_url_suffix, campaign.target_roas.cpc_bid_ceiling_micros, campaign.target_roas.target_roas, campaign.maximize_conversion_value.target_roas, metrics.average_cpc, metrics.clicks, campaign.targeting_setting.target_restrictions

FROM campaign

WHERE campaign.id IN (10938201086, 10934699959, 10934938758, 10934600082, 10934911626, 10938575714, 10934350021, 10938357335, 10934656975, 10937963960, 10938215276, 10934447922, 10934087659, 10938063806)

AND campaign.status IN ('ENABLED', 'PAUSED', 'REMOVED')

AND campaign.advertising_channel_type IN ('SEARCH', 'DISPLAY', 'SHOPPING')

ORDER BY campaign.id ASC

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for providing further details to your concern. I am a colleague of Peter and let me continue the discussion for this concern.

Unfortunately, our team would not be able to proceed with the investigation without the API logs generated in Google Ads API. With this, we will request the complete request and response (fields with metrics) logs, with the request-id. Also, please provide the campaign IDs that were not returned in the response of Google Ads API.

Furthermore, since you've mentioned that the campaigns that were not returned by Google Ads API is deleted campaigns, then this means that it is no longer generating metrics and impressions. With this, these campaigns fall to the following conditions for not returning in the response:

• https://developers.google.com/google-ads/api/docs/reporting/zero-impressions#excluding_zero_impressions_by_segmenting
• https://developers.google.com/google-ads/api/docs/reporting/zero-impressions#rows_returned 

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2GJ6CU:ref