How to import my Auction Insights data in my dashboard?

Through the Auction Insights report, Google Ads allows you to compare your performance with other advertisers who are participating in the same auctions that you are.

Unfortunately, the Auction Insights data is not available through the Google Ads' API used in DashThis.

However, with the Google Sheets integration, it is very easy to pull any kind of data into your DashThis reports.

 
You simply need to export your Auction Insights data into a Google Sheets file by clicking on "Download" at the top right of your screen in Google Ads, and by choosing "Google Sheets".

Auction insights - DashThis Adwords Demo - Google Ads 2020-12-03 at 10.49.03 AM

 

You'll end up with a file looking just like this one:

Image-2020-12-03-at-10.54.48-AM

 

The last step you need to take is to slightly rearrange your spreadsheet so that it can be imported in DashThis. 
Simply remove the top 2 rows and insert a date column in your file. Your spreadsheet should now look like this:

Campaign auction insight report - Google Sheets 2020-12-03 at 10.57.42 AM

 

Now get back into your DashThis account to connect your Google Sheets file, and build your Auction Insights report. Learn how.