Thanks Baker, According by the AWQL attached below in Adword API I have a thought: the data we requested in Adwords API are all on ad group level(cause campaign and ad group field included in returned fields) and we could also summary the data on campaign level.
Performance data feed: select Date, AccountCurrencyCode, Id, CampaignId, CampaignName, Device, Impressions, Clicks, Cost, UserListName, BidModifier, AdGroupId FROM AUDIENCE_PERFORMANCE_REPORT DURING LAST_7_DAYS Structure data feed: 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 DURING LAST_7_DAYS could you please help on below two questions? 1. could you please help confirm my thought? 2. for UserListName need you help guide how to fetch in Ads API, detail please refer below detail: Migration Query : SELECT segments.date, customer.currency_code, campaign.id, campaign.name, segments.device, metrics.impressions, metrics.clicks, metrics.cost_micros, user_list.name, ad_group.id, ad_group_criterion.criterion_id, ad_group_criterion.bid_modifier FROM ad_group_audience_view WHERE segments.date DURING LAST_7_DAYS Query Valid Tool Exception Message: Fix your query to address the errors below and re-submit. - 'user_list.name' is incompatible with 'segments.device'. - 'user_list.name' is incompatible with 'metrics.impressions'. - 'user_list.name' is incompatible with 'metrics.clicks'. - 'user_list.name' is incompatible with 'metrics.cost_micros'. Thanks Hao On Saturday, January 29, 2022 at 2:07:13 AM UTC+8 adsapi wrote: > Hi Hao, > > We do not have guidance on combining reports and there are breaking > changes from AdWords to the new API that affect the availability of the > exact report style you are used to. The Ads API is built to mirror the new > UI as much as possible. To assist you we will need a concrete example. > > Could you provide us privately with logs of request and response to the > API's with request ID > <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id> > of > the reports under consideration, combined with a full screen screenshot of > a UI report screen you are attempting to replicate so that we can see the > numbers that you are seeing and attempt to assist you? > > In the Ads API <https://developers.google.com/google-ads/api/docs/start>, > the request and response appears similar to the JSON Mappings in our REST > documentation > <https://developers.google.com/google-ads/api/rest/design/json-mappings?hl=en>. > > Our client libraries have loggers with logging instructions, to see these > instructions you can click on the client library you use in the sidebar of > our client library guide > <https://developers.google.com/google-ads/api/docs/client-libs?hl=en> and > click on "Logging". > > In the AdWords API > <https://developers.google.com/adwords/api/docs/guides/start> , then a > request looks like the 3rd section in request > <https://developers.google.com/adwords/api/docs/guides/call-structure#request> > and > a response looks similar to response > <https://developers.google.com/adwords/api/docs/guides/call-structure#response>. > > Logging instructions are in the read.me on Github of each client library > <https://developers.google.com/adwords/api/docs/clientlibraries>. > > The requested log can be generated when the log level is set to 'DEBUG'. > > Your first report appears to be a structure report and we do recommend > using ad_group_criterion > <https://developers.google.cn/google-ads/api/fields/v9/ad_group_criterion> > and campaign_criterion > <https://developers.google.cn/google-ads/api/fields/v9/campaign_criterion> > for > structure reports. > > Regards, > > [image: Google Logo] > Aryeh Baker > Google Ads API Team > > > > > > ref:_00D1U1174p._5004Q2VPd3f:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/d2335044-5669-4d52-81b8-130cb7a2ee43n%40googlegroups.com.