Is there a way to get a report of Landing Pages in Google Ads via BigQuery Data Transfer Service

[amraniy]

0

I am currently in the process of creating an overview of ad spent per landing page/destination url. We are using several campaign types: Shopping, (Responsive) Search Ads,Dynamic Search Ads

I am struggling to get a report per landingpage . We have multiple Customer Ids and I would need data for all Customer Ids. When looking at the Google Ads API documentation I think I would need this report

Ideally, the data would be uploaded to a BigQuery dataset already exist.

What I have tried: I have set up a BigQuery Data Transfer, This contains a lot of reports but not the one report listed above.

I have tried a Google Ads script, but my knowledge of that is too little to write a script that woudl give the same/similar results as the two reports listed above. Next to that I would need help getting this data in my BigQuery project.

thanks

[kvandres]

Good day @amraniy,

Welcome to Google Cloud Community!

You can try using Google Ads Script to export Landing pages to Bigquery. You can check this link to know how you can set it up: https://developers.google.com/google-ads/scripts-legacy/docs/solutions/adsmanagerapp-bigquery-export...

You can use the same source code that was given in the link and you just need to update some of the variables in it. 

BIGQUERY_PROJECT_ID:"Add your Project ID to link your Bigquery Project"
BIGQUERY_DATASET_ID:"Add your dataset ID to link the dataset"
TRUNCATE_EXISTING_TABLES: "set to true if you want to delete the existing data, otherwise set it to false if you want to append the data"
TRUNCATE_EXISTING_DATASET: "set to true if you want to delete the existing data, otherwise set it to false if you want to append the data"

 // In Lists of reports and fields to retrieve from Google Ads include "LANDING_PAGE_REPORT"

You can use this link for more information about exporting Google Ads Report in to Bigquery Single Account and Manager Account: https://developers.google.com/google-ads/scripts-legacy/docs/solutions/adsmanagerapp-bigquery-export...
https://developers.google.com/google-ads/scripts-legacy/docs/solutions/bigquery-exporter

You can also check this link that I found which may be helpful to you but please note that Google doesn't support this: https://stackoverflow.com/questions/64030490/is-there-a-way-to-get-a-report-of-landing-pages-in-goog...

Hope this helps!

[Snoshone07]

Hi @amraniy It sounds like you’re working on a complex but important task by trying to aggregate ad spend data per landing page across multiple customer accounts. Getting this level of granularity can be challenging, especially when working with multiple Google Ads accounts.

Here are a few suggestions that might help:

1. Custom Query via Google Ads API:

   • To get a report that includes ad spend per landing page (destination URL), you can use the Google Ads API. Specifically, you can write a custom query using the Google Ads Query Language (GAQL) that pulls metrics like Cost and Conversions at the landing_page_view level. This would allow you to filter and group your results by destination URL across all your customer accounts.

2. Google Ads Script:

   • If you’re more comfortable with Google Ads Scripts, you could write a script to pull this data per landing page. While it requires some JavaScript knowledge, it might be more flexible than trying to manipulate standard reports.

3. Automating the Process to BigQuery:

   • Once you have your custom report, you can use Google Cloud Functions or a scheduled job to automate the process of sending this data to BigQuery. This way, you’ll always have up-to-date data in your BigQuery dataset.

Additional Suggestion:

If managing all of this sounds overwhelming, you might want to consider using a tool like Windsor.ai. It allows you to connect multiple ad platforms, including Google Ads, and automatically sends the data to BigQuery, saving you the hassle of manually writing scripts or setting up complex queries.

I hope these suggestions help! Don’t hesitate to ask if you have any more questions or need further assistance.

Good luck with your project!