Connector name: Google Ads

Table name(s): campaign_history, ad_group_history - there may be more here depending on where this data is able to exist. I read that including ad_group data in the performance max reporting would break the report data. Ultimately I would like to be able to attribute experiment arm-level spend at the lowest grain possible (or within reason). Ideally, if we can attribute it at ad/keyword/asset id, for example, so we can map it back to engagement at that same grain. I would expect it to be able to be aggregated at the ad_group and campaign level as well.

Column(s) to add: experiment id, experiment arm; you already have base_campaign_id and id in campaign_history - maybe there is something similar that can be done

API documentation link: https://fivetran.com/docs/connectors/applications/google-ads

Additional details:

Fivetran’s Google Ads connector does not expose the dedicated experiment arm-level resource needed to report spend/engagement by Control vs Treatment for this Google's AI Max intra-campaign experiment structure.

Here is the documentation from Google in case you meant this above:
https://developers.google.com/google-ads/api/docs/campaigns/ai-max-for-search-campaigns/getting-started

https://developers.google.com/google-ads/api/docs/campaigns/ai-max-for-search-campaigns/ai-max-reporting

https://developers.google.com/google-ads/api/docs/campaigns/ai-max-for-search-campaigns/vertical-ads-controls
 

Thanks