In Google Ads, the Auction Insights Report gives us deep insight into who is bidding against us and how they might be cutting into our precious impression share. Back in 2018, PPC Hero’s Rachael Law wrote about how to generate Auction Insight data in Data Studio and get it out to Excel for analysis. In this post, we’re going to expand on that technique, but stay in Data Studio for the graphs! We’ll also address how to talk to clients and stakeholders about how increased competition can impact performance.
Building a Competitor Report in Google Data Studio You can get up and running with Google Ads data in Google Data Studio in seconds. Here’s how to do that: Go to datastudio.google.com. (Agree to their terms of service if you’ve never been there before.) Click on + Create, then Data Costa Rica Phone Number Source. "" Search for the Google Ads connector and click on it. If you do this from the same login where you have access to Google Ads accounts, you’ll be able to see a list of MCCs, Sub-MCCs, and accounts. Drill down to the account you want to use until you reach the Overall Account Fields.
Click that, then press Connect. You’ll then see a list of fields dimensions and metrics – that are standard to every Google Ads data source. From here, click Explore. Think of Explore in Data Studio as a place to stage dashboard elements before you’re ready to make them into a permanent report. A table element will automatically populate, and you can drag and drop dimensions, metrics, and filters. Here I’ve added Auction Insights – Domain and Week as dimensions. I’ve also dragged in Impr. share and Overlap rate as metrics. Lastly, I’ve added Campaign and Search keyword as filters.