Are you tired of copy/pasting Google Ads data into Google Sheets for client reporting or to compare it with data from other marketing channels? Well, then you’ve arrived at the right place! The KPIBees Google Sheet Add-on enables you to automatically import all your Google Ads data to Google Sheets with just a few clicks! No coding or technical knowledge needed. You’re literally 2 minutes way to create your Google Ads reports!
With the KPIBees Google Sheet Add-on, you can create Google Ads queries and bring them in your selected spreadsheet cell. You can automate refresh times of your queries so that the data is always fresh when you’re viewing the spreadsheet!
STEP 2
STEP 3
Open any Google Sheet and go the Add-ons toolbar. Find KPIBees add-on and clicks on Launch.
STEP 4
Click on the Google Ads connector and grant access to your Google Ads account(s).
STEP 5
The query can be named anyway you want. You need to select the email account that you want to use. KPIBees will fetch all the Google Ads Customer accounts that are shared with the provided email address. If you have access to a Google Ads Manager account, all the regular accounts which are shared with that account are possible to select.
STEP 6
Then you need to select the Report type and Fields that you want your Google Ads report to contain. Please not that not all Fields are compatible with a selected Report Type. You can also add sorting to your output and filter the data based on Field values.
STEP 7
Finally, you just click on Create Query and the result of the query will be brought to your selected spreadsheet cell! You can edit or refresh the query whenever you want.
STEP 8
There’s also the possibility to schedule your Google Ads queries. Alongside the refresh, you can receive an email or a slack notifications, where your Google Ads marketing reports are sent in PDF, Excel, TSV or Webpage formats.
Google Spreadsheets
