Request for Assistance in Retrieving Campaign Data, location details, landing page url and all metrics with via Google Ads API

[digitalreachpremium premium]

I am writing to request guidance on retrieving comprehensive campaign data using the Google Ads API. Specifically, I need to obtain campaign data along with associated location details, landing page URLs or destination URLs, and all relevant performance metrics (clicks, impressions, cost, etc.) in a single API call.

Your expertise on how to achieve this would be greatly appreciated. Please advise on the best approach, including any specific endpoints or configurations required.

Thank you for your assistance.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

I suggest you to use the below sample query to retrieve the campaign related data via the Google Ads API. 

SELECT campaign.final_url_suffix, metrics.clicks, metrics.impressions, metrics.cost_micros, campaign.id, campaign.name FROM campaign

Also, you can construct your own customized query using the campaign query builder. Before that, take a look at the Fields/Segments/Metrics that can be used with the campaign resource. You can use Query Validator to validate your query, then you can try making a request using the Method:customers.googleAds.search or Method:customers.googleAds.searchStream. I hope this helps.

 

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

Thanks,
 

Google Ads API Team

 

[digitalreachpremium premium]

Hi @adwords-api

I need location details with this columns, is this possible?

[Google Ads API Forum Advisor]

Hi,

I understand that you are not able to retrieve campaign.final_url_suffix from the campaign via Google Ads API. In order to further investigate, kindly provide us the uncropped UI screenshot of the Google Ads account and also highlight the fields and metrics that you require to retrieve via the API.

You can send the details via Reply privately to the author option, or direct private reply to this email.

[digitalreachpremium premium]

please leave it

i need Location(geo target location) according with this details

SELECT campaign.final_url_suffix, metrics.clicks, metrics.impressions, metrics.cost_micros, campaign.id, campaign.name FROM campaign

Is it possible?

[Google Ads API Forum Advisor]

Hi,

Yes, you can get the location along with the campaign details. Please refer to the below sample query.

SELECT campaign_criterion.location.geo_target_constant, campaign.name, campaign.final_url_suffix, campaign_criterion.bid_modifier, metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros FROM location_view

Also, you can construct your own customized query using the location_view query builder. Before that, take a look at the Fields/Segments/Metrics that can be used with the location_view resource.

Additionally, I suggest you to refer to the Query Cookbook documentation, this guide provides a set of Google Ads Query Language queries that demonstrate how to return the same data as screens in the Google Ads UI, as well as how to look up geo constants. You can use these queries as is or as starting points for constructing your own customized queries.

I hope this helps!

[digitalreachpremium premium]

campaign.final_url_suffix--> getting blank value while using this queryall other values are okay, can you help why this

[Google Ads API Forum Advisor]

Hi,

Note that campaign.final_url_suffix provides the suffix used to append query parameters to landing pages that are served with parallel tracking. Also, the API returns the data if that data is present in the UI.

If you need further assistance, provide us with the uncropped UI screenshot by highlighting the fields that you're trying to retrieve via the Google Ads API. 

You can send the details via Reply privately to the author option, or direct private reply to this email.

 

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

Thanks,
 

Google Ads API Team

[digitalreachpremium premium]

i have attached the sample data i need, please provide a solution how to retrieve URL information , i used same query you have provided

[Google Ads API Forum Advisor]

Hi,

In order to provide the exact query to retrieve URL information, please provide us with the uncropped screenshot of the Google Ads account by highlighting the field that you're trying to retrieve via the Google Ads API. 

[digitalreachpremium premium]

you mean the data from google ads platform?

[Google Ads API Forum Advisor]

Hi,

Yes, screenshot of the data from google ads platform that you're trying to retrieve via the Google Ads API. 

[digitalreachpremium premium]

These are the details i need ,

campaign_name
click
impressions
spend
state
final_url

[Google Ads API Forum Advisor]

Hi,

I suggest you to use the below sample query. 

SELECT campaign.name, metrics.clicks, metrics.impressions, metrics.cost_micros, campaign.final_url_suffix, location_view.resource_name FROM location_view

As informed earlier, you can construct your own customized query using the location_view query builder. Before that, take a look at the Fields/Segments/Metrics that can be used with the location_view resource.

The provided screenshots are the cropped one, So highly recommend you to check this Query Cookbook documentation, to know how the UI reports look like and how to retrieve that data via the API. 

[digitalreachpremium premium]

SELECT campaign.name, metrics.clicks, metrics.impressions, metrics.cost_micros, campaign.final_url_suffix, location_view.resource_name FROM location_view I have tried this query, but its not giving any values in   campaign.final_url_suffix column, all other columns are okey, why this happened?

[Google Ads API Forum Advisor]

Hi,

As informed earlier, note that campaign.final_url_suffix provides the suffix used to append query parameters to landing pages that are served with parallel tracking. If the suffix value is present in the UI then the API will return the values. The API is not giving any values for the campaign.final_url_suffix column means no value is there for that column in the UI. 

[digitalreachpremium premium]

is there any alternate way to get final_url (landing page url), geo target location columns together in a table

kindly provide the query

[Google Ads API Forum Advisor]

Hi,

Note that it is not possible to get the final_url (landing page url) and geo target location columns together in a same query via the Google Ads API.