Skip to main content

Google Ads Auction Insights

info

High-Level Information: This source ingests the Auction Insights report that Google Ads delivers on a schedule to Google Sheets in your Google Drive.

Source Setup Guide​

Step 1 - Schedule the Auction Insights report​

  1. Go to the Google Ads console.

  2. In the left menu, open Insights and reports and click Auction Insights.

  3. In the date picker, select "Last 7 days"

  4. In the report view, click the Download icon and choose Schedule.

  5. In the schedule popup, set the following:

    • Frequency: Daily
    • Format: Google Sheets
    • Recipient: your own email address
    • File name: any name you prefer
    • Folder: select a Google Drive folder
    • Segments: MUST add Day and Device
    • Deselect: MUST deselect Title and date range
    • Deselect: MUST deselect Totals

Step 2 - Connect the source in Extract​

  1. In Extract, create a Google Ads Auction Insights source.
  2. Choose an Authentication Type:
    • OAuth (default): Click Sign in with Google and authorize a Google account that can access the report folder.
    • Service Account: Extract uses its managed service account, singular-etl@singular-etl.iam.gserviceaccount.com. In Google Drive, open the report folder's Share dialog, add this email address, and grant Viewer access. See Google's folder-sharing instructions for details. You do not need to create a service account or upload a key. Keep your own email address as the scheduled report recipient in Google Ads.
  3. Paste the Google Drive folder URL where the scheduled report is saved.
  4. Enter a file pattern that matches the scheduled report name.
  5. Click Save.

Connection Setup Guide​

Once you connected Google Ads Auction Insights to a destination, you will also need to configure:

  • Connection Pull Schedule: Determines how frequently data is extracted from the source.
  • Backfill (Days): Specifies how far back we should search for updated files.
  • Destination specific settings: different settings such as "Dataset Name" or "Target Schema" (depending on your destination)
  • Schema Migration Policy: Controls how Extract will handle schema changes from the source.

Schema ERD​

Explore the interactive entity relationship diagram for Google Ads Auction Insights.

Open page

Data Streams​

auction_insights​

Loading ....