By integrating TMR’s Google Ads Connector with Google Sheets, you can centralize key metrics and generate custom campaign reports with encrypted security. Before connecting your Google Ads data to Google Sheets, ensure you have the following permissions:
Required permissions
- You require a Google Ads or a manager account with Read Only access. If you’ve already connected to Google Ads but can’t see your ad account, grant the manager account access again.
- For help, see the guide on how to grant access to a Google Ads account or manage your accounts.
Once you confirm these prerequisites, follow the steps below to connect Google Ads data to Google Sheets via TMR.
Step 1: Install and Launch Two Minute Reports
Here’s a step-by-step tutorial on how to install TMR in Google Sheets: How to install TMR in Google Sheets?
Once done, you can connect your Google Ads account with Two Minute Reports to access your campaign performance insights.
Step 2: Create a new Connection to your Google Ads account
| A Connection is a link between the data source and the Connector. For example, you must use the Google Ads Connector to create a new Connection with your Google Ads account to get your ads data. |
- Click Menu at the top left of the sidebar to navigate to the Connections section. Next, click Add to create a new Connection.
The “Adding new connection” dialog box appears. Here, you can perform three key steps to access your client’s Google Ads accounts.
- Selecting the Google Ads Connector
- Authentication
- Enabling respective accounts with Google Ads Connector
Select Google Ads connector from the list of options. Next, authorize the Connection by specifying your login credentials.
- Once you’ve successfully authenticated, you’ll see a screen displaying your Account name, ID, Connection name, and Status, as shown below:
- Enable the toggle for the ad accounts you want to run queries. Please note that you cannot extract data from disabled accounts.
| Once you’ve enabled the associated accounts, you can hit “Refresh Connections” to ensure the connected accounts are reflected in the TMR sidebar. |
And that’s it. You can now extract Google Ads KPIs in Google Sheets to gain actionable campaign insights.
Step 3: Fetching Google Ads data to Google Sheets
You must create a new query by navigating to the Data Queries section to pull specific Google Ads performance data.
Click Add and choose the respective Google Ads accounts to analyze campaign performance. You can manage “n” number of clients’ Google Ads accounts under one roof. Simply select one or more accounts to extract actionable campaign insights.
Alternatively, navigate to the Clients section. Add your client and map their corresponding Google Ads account.
Click on “Manage Clients” and map the necessary account details. Once done, click “Save & Close” to save your client’s details for future reference.
Next, add the required Google Ads metrics and dimensions you want to analyze. Once done, select the date range for which you want to measure campaign performance.
Next, you have to configure your data reporting by choosing how to customize it.
It would be best to customize your data reporting by selecting the relevant fields and choosing whether to sort them in ascending or descending order. You can also apply custom filters to display only the necessary information.
Once you finish the above steps, click Run Query to visualize the output.
Now, you can use different Google Sheet features, such as pivot table and VLOOKUP(), to extract critical insights and build charts to visualize your Google Ads campaigns.
| Pro TMR Tip: Run all your queries directly from the Extensions menu on your Google Sheets. Go to Extensions > Two Minute Reports > choose your desired quick action. |
Step 4: (Optional) Get automatic data updates via Schedule Refresh
Once you create a report in Google Sheets, you can schedule automatic updates to get updated data. This feature is convenient for sending emails or refreshing your spreadsheets with live data and using them as a dashboard.
Under the email section, you can enter the recipient’s email ID and save the new schedule.
You can also choose to specify the reporting format. You can insert the sheet content in the email body, attach the selected sheet as a PDF or Excel, or attach the spreadsheet as an Excel file.
Two Minute Reports’ Schedule Refresh feature has further capabilities. Continue reading about this feature: “How to Refresh Data Automatically in Google Sheets.”
We hope you found this guide helpful. If you have any questions, please contact our support team at support@twominutereports.com.