Re: Campaign Performance Report Missing Data
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.
On Friday, 4 March 2022 at 12:39:15 UTC+5:30 hal...@ebay.com wrote:
> 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
>
> On Friday, March 4, 2022 at 3:07:14 PM UTC+8 Hao Long wrote:
>
>> 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 datecount(1)
>> Adwords API2022-03-0137297
>> Ads API2022-03-0111179
>> Adwords API2022-03-0237297
>> Ads API2022-03-0210927
>> Adwords API2022-03-0337297
>> Ads API2022-03-038058
>>
>>
>> 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
>> <(574)%20984-7778>, 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
Re: Campaign Performance Report Missing Data
Hi Google Support Team,
Could you please help looking into this thread?
Thanks
Hao
On Friday, March 4, 2022 at 3:09:15 PM UTC+8 Hao Long wrote:
> 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
>
> On Friday, March 4, 2022 at 3:07:14 PM UTC+8 Hao Long wrote:
>
>> 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 datecount(1)
>> Adwords API2022-03-0137297
>> Ads API2022-03-0111179
>> Adwords API2022-03-0237297
>> Ads API2022-03-0210927
>> Adwords API2022-03-0337297
>> Ads API2022-03-038058
>>
>>
>> 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
>> <(574)%20984-7778>, 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 segmen
