How to find what search campaigns from Google Ads API in bigquery have AIMax setting enabled

[Tessa Beijloos]

Hi there — I’m working with the Google Ads API export in BigQuery and need to distinguish, within Search campaigns, which ones are AI Max, DSA (Dynamic Search Ads), and which are standard Search campaigns.

I’m querying the campaigns table:

SELECT * FROM `myproject.my_dataset.ads_Campaign_xxx`

but I don’t see a field/flag that clearly indicates AI Max or DSA status.

• Which column(s) or join(s) should I use in the BigQuery export to identify AI Max and DSA campaigns within Search Campaigns?
• If this requires another table (e.g., settings or subtypes), which one and which fields?

Thanks for the guidance!

[Google Ads API Forum Advisor]

Hi,

 

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

 

I understand that you are trying to use the "BigQuery Data Transfer Service" for Google Ads reporting. Kindly note that BigQuery related concerns are out of scope for the Google Ads API support team as our team specializes in Google Ads API related concerns and technical implementations. So, I would recommend you reach out to the GCP Product support team, as they are better equipped to assist you on this.

 

Please feel free to get back to us if you have any queries related to the Google Ads API.

 

 

Thanks,
 

Google Ads API Team

Feedback
How was our support today?

               
[2025-11-04 04:16:26Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01vSaGz:ref" (ADR-00338359)