Connector Improvement: Google Ads
AnsweredAdd Asset level to standard extract as support for Responsive Search Ads
Bonus: Reflect this in the dbt packages google_ads and ad_reporting
-
Official comment
Hi Nicolas,
Thanks for this request. Asset-level reporting for Responsive Search Ads is a common need. I'll explain how you can get this data today while we work on making it easier out of the box.
Our Google Ads connector already supports the `ad_group_ad_asset_view` resource as a custom report. This is the Google Ads API resource that provides per-asset performance metrics for each headline and description in your RSAs, along with a performance label that ranks each asset against others of the same type.
You may already be aware of this. If so, I'd love to know why having this as a prebuilt report is important for your use case. That will help me decide how to prioritize the addition of a new prebuilt report.
If you weren't aware, here's how to set this up as a custom report:
- Go to your Google Ads connection in the Fivetran dashboard
- Click Edit Connection, then click + Add Report
- Give the table a name (e.g., `rsa_asset_stats`)
- Select `ad_group_ad_asset_view` as the Report Name
- Select the fields you need. A good starting set would be:
- `ad_group_ad.ad.type` (the ad type, so you can filter to just RSAs)
- `ad_group_ad_asset_view.field_type` (tells you if the asset is a HEADLINE or DESCRIPTION)
- `ad_group_ad_asset_view.performance_label`
- `ad_group_ad_asset_view.asset`
- `ad_group_ad_asset_view.ad_group_ad`
- `metrics.impressions`, `metrics.clicks`, `metrics.cost_micros`, `metrics.conversions`
- `segments.date` - Save and sync
The `ad_group_ad_asset_view` resource returns asset data for App Ads and Demand Gen campaigns in addition to RSAs. To isolate just your RSA data, filter on the `ad_type` column (that's how `ad_group_ad.ad.type` will appear in your destination) where the value is `RESPONSIVE_SEARCH_AD`.
You may also want to look at `ad_group_ad_asset_combination_view`, which shows how different combinations of headlines and descriptions performed together. That one is RSA-only, but more ad types will be included in the future (source).
On your broader ask: I've added items to the backlog to (1) create a prebuilt report for RSA asset performance so this works out of the box without custom report configuration, and (2) add asset-level models to the dbt google_ads and ad_reporting packages. I can't commit to a specific timeline yet, but wanted you to know these are tracked.
Best,
Luke
Please sign in to leave a comment.
Comments
1 comment