Free Template: Automated Google Ads Performance Report for Google Sheets
The data that comes out of Google Ads is essential for tracking the performance of your marketing campaigns. But often that data can stay trapped in there, with manual exports to a spreadsheet being the only way to get it out.
That’s where Unito’s integration for Google Ads and Google Sheets comes in. It just takes a few minutes to set up, and then it automatically exports data from Google Ads to Google Sheets and keeps it all up to date whenever your data changes. You can use Google Sheets native reporting capabilities to turn that data into visuals, but you might not want to start from scratch every time.
With this template from Unito, it’s all done for you. Here’s how you can pair this purpose-built report with a Unito integration for up-to-date Google Ads data wherever you need it.
This free template allows you to get a big picture view of how your Google Ads campaigns are performing over a specified date range. This way you and your team can monitor budgets, track engagements, and identify trends. It includes:
- A high-level, aggregated view of your Google Ads campaign performance and spend
- Daily trends for Clicks, CTR, Conversions, and CPC
- A breakdown of campaign performance by ad network
- Top 10 campaigns by conversions
- Custom date range picker
How to use this template with Unito
This template uses data from the “Raw_Data” tab to generate charts and visualizations. While you could manually add your Google Ads data here, it’s a lot easier when your spreadsheet is kept up to date with Unito’s integration.
Here’s how to do it.
Step 1: Make a copy of the template
Get the template, hit File then Make a copy.
Step 2: Sign up for a 14-day trial with Unito
You’ll need a Unito account to keep data in sync between Google Ads and Google Sheets. You can start a free trial right here.
Step 3: Build a flow with Google Ads and Google Sheets
We’ve included steps below that’ll walk you through this process. You can also follow the rules and field mapping settings below.
Step-by-step instructions for setting up a Unito flow
This template is built to turn Google Ads data into a dynamic dashboard built right into a spreadsheet. It works best when you use Unito to feed that data into Google Sheets automatically.
Step 1: Connect Google Ads and Google Sheets to Unito and pick your blocks of work
You can connect both Google Ads and Google Sheets using your Google account. You’ll then need to choose the account that will sync information from. After that, you’ll want to:
- Authorize Google Ads and select the desired Account.
- Choose Campaign as a Resource.
- Select Campaign Name, Ad Network Type, and Date as Dimensions.
- Select Impressions, Clicks, Cost Micros, and Conversions as Metrics.
- Choose a predefined or custom Google Ads Date Range.
Install the Spreadsheet Sync Add-On for Google Sheets.
Step 2: Add rules (optional)
Rules let you customize how much information is synced from Google Ads to Google Sheets. You could filter out rows with Dimensions that don’t contain a specific value, or Metrics that are greater than a certain amount. You can also limit the number of rows you sync overall.
Step 3: Map your fields
Field mappings allow you to match columns in Google Ads with those in Google Sheets so your data always ends up in the right place.
Step 4: Launch your flow!
After mapping your fields, you’re good to go! Now just sit back and watch as rows from Google Ads are synced to your report in Sheets.