Having trouble fetching asset group performance data

[Jay Wilner]

What Report resource, with metrics, do we use to fetch asset group level performance data, conversion data for Performance Max campaigns?

I have been successfully running reports using the 'asset_group_product_group_view' resource but i've found it only shows data for asset groups with product groups associated with them so i am missing data.

I've tried 'campaign_asset' and 'asset_set_asset' but the returned data is empty for any metrics.

====================================================

My query looks like this in the Google Ads query builder:

SELECT segments.date, asset_set_asset.asset, asset_set_asset.asset_set, asset_set_asset.resource_name, asset.text_asset.text, metrics.impressions, metrics.clicks, metrics.cost_micros FROM asset_set_asset WHERE segments.date > '2023-01-01' AND segments.date < '2023-04-01'

=======================================

I am using Google Ads Scripts to make the call and the AdsApp.report() method to create a Google Sheet report:

partial code below

function main() {

  let ss = SpreadsheetApp.openByUrl('xyz123'); 

  let segDate     = ' segments.date ';

  let assetSet    = ' asset_set_asset.asset_set ';
  let asset       = ' asset_set_asset.asset ';
  let assetRName   = ' asset_set_asset.resource_name ';

  ...

  ...

 let as = [segDate,asset,assetSet,assetRName,assetText,impr,clicks,cost,conv,value];
  let asQuery = ' SELECT ' + as.join(',') +
      ' FROM asset_set_asset ' +
      ' WHERE ' + dateYTD;

 ... 

  // call report function to pull data & push to named tabs in the sheet
...
  runReport(asQuery, ss.getSheetByName('raw_asset_set_asset'));
}

function runReport(q,sh) {
  const report = AdsApp.report(q);
  report.exportToSheet(sh);  
}

==================================================  

My Ads script runs without errors but no data is inserted in the sheet: https://imgur.com/X2SbTLc

I am able to successfully fetch data using this view: asset_group_product_group_view but i have found that data is missing data for asset groups that have no product groups.

Thanks in advance

Jay

[Oliver]

This data is not available for asset groups, neither in the UI or the API.  

Oliver

[Google Ads API Forum Advisor]

Hi Oliver,

Thank you for sharing your knowledge to the community.

@Jay,

Please do note that Google Ads API reports mirrors the reporting side of the Google Ads UI, so if the said report/data is now available on the UI side, then I'm afraid that this will not also available via API. In order for us to validate your use case, would you able to share to us a screenshot (un-cropped) of your Google Ads UI showing the data/entities that you want to pull via API?

Regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2kEJGF:ref

[Brandon Farber]

I am running into the exact same problem here. I found that I can retrieve metrics for  asset_group_product_group_view queries, but cannot retrieve metrics for the asset group as a whole.

I am effectively trying to recreate this page in the Google Ads UI: https://ads.google.com/aw/assetgroup?campaignId=X&ocid=X&ascid=X&assetGroupTableMode=true&euid=X&__u=X&uscid=X&__c=X&authuser=1

As we can see in the screenshot - we have a breakdown of all asset groups, segmented by date, and we have metrics (I'm looking at clicks, cost and impressions here but we would be fetching other similar/related metrics in the GAQL query issued). The problem is, I can't find the correct source (FROM clause) to fetch against. I've looked at:

1. ad_group_ad_asset_combination_view (only gives impressions for metrics so this isn't right)
   
2. ad_group_ad_asset_view (I get no results)
   
3. ad_group_asset (I get no results)
   
4. asset_set_asset (I get no results)
   
5. asset_group (metrics aren't available)

So circling back - what resource do we query to recreate the page I've linked above?

[Google Ads API Forum Advisor]

Hi Brandon,

Thank you for reaching out.

Regarding your concern, kindly note that the asset_group (https://developers.google.com/google-ads/api/fields/v13/asset_group) report is used to get asset group data. However, as you mentioned, the said report is one of the resources without metrics. Meaning, you can't get metrics by using this report. Having said that, in order for our team to replicate this on our end, can you please provide the uncropped Google Ads UI screenshot showing this?

You may then send the requested logs via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

[Brandon Farber]

I have sent you screenshots privately as requested, just following up here for posterity to note this. While we'd prefer our account data (i.e. what is reflected in the screenshots) is handled privately, I'm happy for you to publicly post the answer to my question for the benefit of others, as I've seen similar questions on this forum and the OP here obviously had the same question. Thanks!

[Google Ads API Forum Advisor]

Hi Brandon, 

Thank you for coming back to us and providing information. I hope you are doing well today.

With regards to your concern, you may use the asset_group_product_group_view report (https://developers.google.com/google-ads/api/fields/v13/asset_group_product_group_view_query_builder). It includes all of the resources, fields, segments, and metrics that are selectable. It also includes Attributed resource fields (asset_group, asset_group_listing_group_filter, campaign, customer).

You may try this and let us know how it goes. If you encounter any issues or errors, could you please provide us with the complete (request and response with request-id) logs with request ID generated as shown in the respective links. I ask this so our team further investigate or provide accurate recommendations on this.

If you haven't enabled logging yet, it can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. For REST interface requests, you can enable logging via the curl command by using the -i flag. This will cause the tool to include the HTTP response headers in the output.

Reference links: 

• Logging documentation - https://developers.google.com/google-ads/api/docs/best-practices/logging#client_library_logging
• Request - https://developers.google.com/google-ads/api/docs/concepts/field-service#request
• Response - https://developers.google.com/google-ads/api/docs/concepts/field-service#response
• Request-id - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id

Have a great day.

Regards,

[Brandon Farber]

Unfortunately, that is not the same page.  When I use that endpoint it replicates what I see in the Google Ads UI on the "Listing Groups" page (i.e. a URL like https://ads.google.com/aw/listinggroups?campaignId=X&ocid=X&ascid=X&euid=X&__u=X&uscid=X&__c=X&authuser=1). What I want to replicate is the "Asset Groups" page.

Specifically, for one day in question, the resource asset_group_product_group_view reflects $65.94 in spend on the "Listing Groups" page, however if I go to the "Asset Groups" page I can see we actually had $135.23 in spend on this day.

In short, that resource does not show me what I'm seeing on the "Asset Groups" page, it shows me what I see on the "Listing Groups" page, which is incomplete. I am sending you the log for the request I just ran showing the $65.94 returned, but as you can see in the screenshot I sent earlier today, I should be seeing $135.23 in spend for the day in question. Hopefully this can help answer what I'm after and what is not working as expected.

[Brandon Farber]

For the benefit of others who may come across this conversation - the support rep has confirmed the metrics we see broken down on the "Asset Groups" page is not currently available via the API, and a feature request has been submitted internally to make them available.

[Google Ads API Forum Advisor]

Hello Brandon,

Thank you for responding back to this thread and sharing the information.

I am confirming the shared details that getting the performance data metrics we see on the "Asset Groups" page is not currently available via the API. Our team has submitted a feature request for this and it will be subject for review. You may monitor our release notes and blog posts for future updates.

Links to the highlighted words above:

• release notes - https://developers.google.com/google-ads/api/docs/release-notes
• blog - https://ads-developers.googleblog.com/search/label/google_ads_api

[Johan Alpne]

Hello,

Metrics now seem to be available from asset_group however you can't segment it by date. Is there any workaround to get the asset_group metrics segmented by date?

Best regards,

Johan

[Oliver]

Hi Johan,

When you say "metrics now seem to be available" are you actually seeing data for metrics like clicks, coversions, etc.  or are you referring to the fact the fields exist?  The fields have always been there but no data was ever returned for them (except impressions).

Oliver

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

Kindly note that there is no workaround to retrieve the asset_group metrics segmented by date. I would recommend you please follow our Release Notes and Blog Post for future updates.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02kEJGF:ref"

Thanks,

 

Google Ads API Team