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 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
>> <(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 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
>> <(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: "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
>>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"Google Ads API and AdWords 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/872c74b2-4702-4386-846d-954239a5a516n%40googlegroups.com.
