Skip to main content

How to set up Auction Insights for AI

Send your Google Ads auction insights to TrueClicks with a scheduled Google Sheets report so the AI assistant can analyze your competitors.

Written by Michaela Mastella

TrueClicks can’t pull auction insights from Google Ads directly, because the Google Ads API doesn’t make that data available to us. To fill that gap, you set up a scheduled Auction insights report in Google Ads that writes to a Google Sheet, then link that sheet to TrueClicks. After that, the Auction Insights for AI check, the TrueClicks AI assistant, and the TrueClicks MCP can all use your competitor data.

It takes four parts: create the report in Google Ads, save it to a Google Sheet and share it with TrueClicks, schedule weekly updates to that sheet, and paste the sheet link into TrueClicks.

Before you start, you need:

  • Access to the Google Ads account or manager account (MCC) you want to report on

  • A Google account that can create Google Sheets

Notes:

  • Setting this up at manager account level works best. One report can then cover as many accounts as you want.

  • Your Google Ads interface language doesn’t matter. TrueClicks reads the report in all languages supported by Google Ads.


Part 1: Create the auction insights report in Google Ads

  1. In Google Ads, open your manager account or a single account and go to Insights and reports > Report editor.

  2. Scroll down to the predefined reports and open Competitive visibility.

  3. Select Auction insights: Search to create a new report.

    Note: Only Auction insights: Search is supported for now. Shopping auction insights won’t work.

  4. Drag the Campaign and Week dimensions into the report. Both are required.

  5. Set the date range to Last 30 days. Don’t use a custom date range. A custom range is fixed, so the report would keep sending the same old data.

  6. If you’re in a manager account, select the accounts you want to include.

  7. Check that all the default columns are still in the report, including Customer ID. Don’t remove any of them. TrueClicks uses Customer ID to match each row to the right account.

    Important: Removing default columns can break the import.

Part 2: Save the report to a Google Sheet and share it with TrueClicks

  1. Click Download and choose Google Sheets. Sign in with your Google account if asked.

  2. Give the spreadsheet a name you’ll recognize, for example TrueClicks_AuctionInsights.

  3. Open the spreadsheet in Google Sheets.

  4. Click Share and add the TrueClicks service account:
    ​

    trueclicks@trueclicks-app-sheets-access.iam.gserviceaccount.com

  5. Give it Viewer access and click Send.

Part 3: Schedule weekly updates to the sheet

Go back to the report in Google Ads.

  1. Click Schedule.

  2. Set the frequency to Weekly on Monday. Daily also works, but weekly is our recommendation.

  3. Set the format to Google Sheets, then sign in with your Google account when prompted.

  4. Turn on Automatically refresh report. This updates the same spreadsheet every week instead of creating a new file each time.

    Important: If Automatically refresh report is off, Google Ads creates a new spreadsheet every week, and TrueClicks keeps reading the old one.

  5. In the dropdown, choose Add a new tab to an existing sheet, select the spreadsheet you saved in Part 2 and enter the tab name from the sheet.

  6. Under Who do you want to share the report with?, add at least one recipient, such as yourself or a colleague. This field is required.

  7. Click Schedule.

Part 4: Link the spreadsheet in TrueClicks

  1. Copy the spreadsheet URL from your browser’s address bar.

  2. In TrueClicks, open the custom attributes for the account. You can do this from the rightmost column of the All accounts dashboard, or on the top right on the account page. See Introducing custom attributes for details.

  3. On the Custom Attributes tab, scroll to Additional.

  4. Paste the URL into Do you want to analyze Auction Insight data?
    ​

    ​

  5. Click Save & Close.

That’s it. TrueClicks picks up new data each time Google Ads refreshes the sheet.


Check that it works

Open the AI Assistant in TrueClicks, select the account, and ask about your competitors. For example:

Which competitors had the highest impression share in my search campaigns over the last 4 weeks, and how did that change week by week?

If the answer names real competitors from your auction insights, you’re set. From now on, TrueClicks picks up new data every time Google Ads refreshes the sheet.

Other prompts to try:

  • Who outranks us most often, and in which campaigns?

  • Did any new competitors show up in the last week?

Not getting competitor data? Check that the spreadsheet is shared with the TrueClicks service account (Part 2) and that the URL is saved in custom attributes (Part 4).


What TrueClicks shows from your data

The Auction Insight for AI check ignores competitors with a search impression share below 10%.

Tip: Managing several accounts? Set the spreadsheet URL in one account, then copy it to the rest with bulk edit for custom attributes. This only works for accounts included in your Google Ads report, so set up the report at the manager account level and select all the accounts you want to cover in step 6.

Did this answer your question?