Skip to main content

Community

Connector Improvement: Google Ads

Answered

Please sign in to leave a comment.

Comments

1 comment

  • 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:

    1. Go to your Google Ads connection in the Fivetran dashboard
    2. Click Edit Connection, then click + Add Report
    3. Give the table a name (e.g., `rsa_asset_stats`)
    4. Select `ad_group_ad_asset_view` as the Report Name
    5. 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`
    6. 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