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