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 for each campaign type. 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 these two reports to get all I need

• Keywordless Query Report (for Dynamic Search Ads landing pages): https://developers.google.com/adwords/api/docs/appendix/reports/keywordless-query-report
• Landing Page Report (for Shopping and (responsive) search ads landing pages): https://developers.google.com/adwords/api/docs/appendix/reports/landing-page-report

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

What I have tried:
I have set up a BigQuery Data Transfer (https://cloud.google.com/bigquery-transfer/docs/adwords-transfer). This contains a lot of reports but not the two reports 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.

I am developing a google ads script to run and create negative keywords, i get the performance using an SQLreport and when i try to create a negative keyword it does not work because when i try to return existing adgroups and initialize them, i get an empty result.

var adGroups = AdsApp.adGroups().get(); Logger.log('Total adGroups found : ' + adGroups.totalNumEntities()); 

This returns: Total AdGroups found : 0 -> but i have multiple running ads/adgroups in that sub-account.