How to create Asset Combination Report with "Impressions", "Clicks", "CVs", "Costs" metrics for RSA?

178 views
Skip to first unread message

寺田将志

unread,
Nov 11, 2024, 4:20:18 PM11/11/24
to adwor...@googlegroups.com, DATA-DIG
About: Responsive Search Ads

Dimensions: Combination of “Headlines” and “Descriptions” that were actually served

Metrics: “Impressions”, “Clicks”, “CVs”, “Costs” metrics

We would like to extract metrics for each of Dimentions using Google Ads Query Language (GAQL).

(“Impressions” alone can be found in the “Combinations Report for Responsive Search Ads” on the ad management screen...
This time, we also want to see “Clicks”, “CVs”, and “Costs”!)

Please help us to achieve this task!!!

(It may not be possible to extract all at once, or there may be some merging process etc ...involved , OK!)

Google Ads API Forum Advisor

unread,
Nov 11, 2024, 8:22:50 PM11/11/24
to ma.t...@cartahd.com, data...@cartahd.com, adwor...@googlegroups.com

Hi,

Thank you for contacting the Google Ads API support team.

To assist you further on your required GAQL query, could you please provide the uncropped Google Ads UI screenshot(s) from where you want to retrieve that data via the Google Ads API?

The reason for asking this screenshot is that you can pull almost all the metrics and segments via the Google Ads API, which is available in the Google Ads UI.

Once we have a relevant screenshot, we can check the feasibility of pulling this data via the Google Ads API and assist you accordingly. 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vGjB1:ref" (ADR-00275070)

Thanks,
 
Google Logo Google Ads API Team


Matt Hamilton

unread,
Nov 11, 2024, 11:30:16 PM11/11/24
to adwor...@googlegroups.com
Thanks for the response, however this doesn't really help.

Let me provide you a little context... We have an app that currently pulls YouTube (Google) videos for channels of our clients.  We then scan these videos to determine which videos contain music of the artists we represent.

We are now enhancing the app to pull ads and ad insights and need access to the Google Ads API to do that.  We currently have 'Test' access and are seeking 'Basic' access to be able to pull ads and ad insights for the Ad accounts that our clients authorize our app to.

We do not have any Google ads of our own to show you a screenshot of.

I hope that helps,

Matt


--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/adwords-api/cw4Qe000000000000000000000000000000000000000000000SMSZ9100nqXDeVe4TWikMJWYw4JfnA%40sfdc.net.

Bharath Patil

unread,
Nov 11, 2024, 11:30:17 PM11/11/24
to ads...@forumsupport.google, ma.t...@cartahd.com, data...@cartahd.com, adwor...@googlegroups.com
Please see attached.
I have a CWGrowth account (817-509-1043) with which I want to manage the 501-942-0290 Cradlewise account.
Both are owned by the same company.
This is what I see when I go to the CWGrowth Account. It says Access Level is "Test Account". I need Basic account access. I have attached a PDF screenshot of both the CWGrowth and the Cradlewise account.

image.png

Regards
Bharath


--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/adwords-api/cw4Qe000000000000000000000000000000000000000000000SMSZ9100nqXDeVe4TWikMJWYw4JfnA%40sfdc.net.


--

[Founder, CTO] | Cradlewise
Cradlewise smart crib is one of TIME's Best Inventions of 2020
Overview - CWGrowth - Google Ads.pdf
Overview - Cradlewise - Google Ads - CW.pdf

Matt Hamilton

unread,
Nov 11, 2024, 11:30:17 PM11/11/24
to Google Ads API and AdWords API Forum
Thanks so much for the response.

We don't have any of our own Google ads to show screenshots of what we'd like access to specifically.

Let me provide a little more context... We currently have an app that pulls in social media posts for authorized accounts/clients that we work with.  We then scan those posts to determine which of their posts are using music of artists represented by SixtyFour Music.  We are successfully pulling YouTube (Google) posts for our clients' channels.  This does not need authorization for us to do

Now we are looking to enhance the app to pull ads from our clients.  So to pull YouTube ads, we are asking for access to the Google Ads API.  We currently have 'Test' access and are asking for 'Basic' access.  Once approved we will look to pull YouTube ads for our clients that authorize our app to do so.  We will then scan the ads to determine which of the ads use music of the artists we represent.  We will also look to access Ads insights.

Does this give you what you need?

Thanks for the help.

Matt

Google Ads API Forum Advisor

unread,
Nov 12, 2024, 1:36:54 AM11/12/24
to ma...@rappid.design, adwor...@googlegroups.com
Hi,

In order to apply for the basic access, fill out the basic access application form. If you have already applied and are waiting for the approval, I suggest you reach out to the Google Ads API Compliance team as they are better equipped to address your concerns.

Please note that our team can only assist with the technical queries or concerns related to the Google Ads API.
Message has been deleted

寺田将志

unread,
Nov 12, 2024, 7:23:02 AM11/12/24
to adwor...@googlegroups.com, Google×DataDigサービス
Thread lost to someone else, so I'm resending it.(TT)

How to create Asset Combination Report with "Impressions", "Clicks", "CVs", "Costs" metrics for RSA?


We would like to extract metrics for each of Dimentions using Google Ads Query Language (GAQL).

The relevant dimensions and metrics are
-------------------------------------------------------------
About: Responsive Search Ads

Dimensions: Combination of “Headlines” and “Descriptions” that were actually served

Metrics: “Impressions”, “Clicks”, “CVs”, “Costs” metrics
-------------------------------------------------------------

(“Impressions” alone can be found in the “Combinations Report for Responsive Search Ads” on the ad management screen...
This time, we also want to see “Clicks”, “CVs”, and “Costs”!)

Please help us to achieve this task!

(It may not be possible to extract all at once, or there may be some merging process etc ...involved , OK)

I've attached a capture of the output image we would like to see.
↓↓↓
image.png

Google Ads API Forum Advisor

unread,
Nov 12, 2024, 9:11:18 AM11/12/24
to ma.t...@cartahd.com, google_...@cartahd.com, adwor...@googlegroups.com
Hi,

We can use the AdGroupAdAssetCombinationView for Responsive Search Ads but the resource is only supported for the impressions metric. You may check the Fields/Segments/Metrics supported for the ad_group_ad_asset_combination_view. 

Bharath Patil

unread,
Nov 12, 2024, 9:36:58 AM11/12/24
to ma...@rappid.design, Google Ads API and AdWords API Forum
ok. Basically I got phished. Thanks. Bye for now


--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@googlegroups.com.

寺田将志

unread,
Nov 13, 2024, 8:04:00 AM11/13/24
to Google Ads API and AdWords API Forum
Thanks for the response.

>>>We can use the AdGroupAdAssetCombinationView for Responsive Search Ads but the resource is only supported for the impressions metric.

We have confirmed that the metrics supported by the AdGroupAdAssetCombinationView only support for the impressions metric.

So, am I correct in understanding that it is not currently possible to create an asset combination report that includes  “clicks”, “CVs”, and “cost” metrics for RSA??

----------------------------------------------------------------------------------------------------
Let me ask one more question.

How do I convert {AssetCombination.asset_combination_id_(low|high)} to a combination of asset_id or asset_resource_name?

example↓
・Resource :  AdGroupAdAssetCombinationView

Field : ad_group_ad_asset_combination_view.resource_name

・Returns : customers/8852570552/adGroupAdAssetCombinationViews/164479291666~706069896168~11719193477158959234~14179745279002823535

{AssetCombination.asset_combination_id_low} = 11719193477158959234
{AssetCombination.asset_combination_id_high} = 14179745279002823535

--> How do I convert {AssetCombination.asset_combination_id} to a combination of asset_id or asset_resource_name?
2024年11月12日火曜日 18:11:18 UTC+9 Google Ads API Forum Advisor:

Google Ads API Forum Advisor

unread,
Nov 13, 2024, 12:57:15 PM11/13/24
to ca0...@cartahd.com, adwor...@googlegroups.com
Hi,

Yes, that’s correct. In the UI, there is no data available for clicks, cost, or conversions only the impressions metric is present. Accordingly, the ad_group_ad_asset_combination_view report in the API also only supports the impressions metric. Since there’s no data available in the UI for these metrics, it cannot be retrieved from the API either. 

The 'AdGroupAdAssetCombinationView' does not provide direct access to 'asset_id' or 'asset_resource_name' because it does not include references to asset resources. Instead, you can use the 'ad_group_ad_asset_view' resource to retrieve 'asset.id' and 'asset.resource_name'. Here is a sample GAQL query to suit your requirements:
SELECT asset.id, ad_group_ad_asset_view.resource_name, asset.resource_name, asset.name, 
ad_group_ad.ad.type, ad_group.id FROM ad_group_ad_asset_view WHERE ad_group_ad.ad.type = 
'RESPONSIVE_SEARCH_AD' AND ad_group.id = {ad_group.id}
You can use the search or searchStream methods in making the API calls while retrieving the data. Additionally, you can utilize the Google Ads Query Builder and Query Validator to build and validate the queries for retrieving the data from the Google Ads API.

寺田将志

unread,
Nov 13, 2024, 5:14:13 PM11/13/24
to Google Ads API and AdWords API Forum
Thanks for the response. Very helpful!

But I would like more information.

I want to convert {AssetCombination.asset_combination_id} of "AdGroupAdAssetCombinationView" to  'asset.id' or 'asset.resource_name'. 
Do you know how to convert this?



2024年11月13日水曜日 21:57:15 UTC+9 Google Ads API Forum Advisor:

Google Ads API Forum Advisor

unread,
Nov 13, 2024, 9:24:32 PM11/13/24
to ca0...@cartahd.com, adwor...@googlegroups.com

Hi,

Since the two resources serve different purposes, it is not possible to convert the resource names from one to the other.

I hope it helps. 

Reply all
Reply to author
Forward
0 new messages