Google is always improving it’s already stellar products. We here at Sheetgo are of course huge fans of Google Sheets, and we are always recommending our favorite Sheets add-ons. Most of the add-ons in the add-ons store are created by 3rd party developers, but there are a few that are made by Google to connect your Sheets with other Google apps and services. I always get super excited when Google launches a new add-on—you know that it is going be intuitive to use, well-designed, and the kind of solution that easily integrates with and improves your workflow.
Google has just launched its Beta version of the new add-on for Google Ads, formerly known as Google Adwords. There are already many free and paid Sheets add-ons and templates you can use to coordinate your Ads efforts, so I was excited to see what Google has created for us Ads and Sheets devotees!
It’s An Awesome Reporting Tool
With this add-on, you can quickly generate reports from multiple ad accounts into one spreadsheet. Choose from a variety of metrics to report on and easily filter data using the convenient sidebar, see a high-level overview of all of the reports you have generated, and easily refresh and update the data. As always when working with Google Sheets, you can easily share to colleagues to view or comment on using Google unique sharing features.
Who is This Add-on For?
Because of how customizable this report generator is, it is perfect for any sized company running anything from single to complex campaigns, or agencies managing campaigns for multiple clients. The fact that you can pull data from multiple accounts and push them into single reports gives you access to so many insights! Although this add-on is still in Beta mode, there are a lot of great features to use. Savvy marketers should definitely keep an eye on this add-on, using tools like this can surely help you show where you are seeing success in your campaigns and where you can improve. Use this add-on to create reports to share with your team or your clients.
What Features Are Included in This Beta Version?
Excellent Time Range Customization: You can select to generate reports from specific days, weeks, etc…even from all time or custom ranges. You can also choose to compare multiple time periods in the same report.
Choose to Create Report Categories Such as:
- Ad Groups
- Search keywords
- Negative keywords
- Targeted location
- Search teams
Add in a Variety of Segments into Your Report Such as
- Day of the week
- Click type
- Conversion action
- Conversion category
- Network (with search partners)
- Conversion source
- Conversion action
- Top vs. Other
- Search terms match type
- Days to conversion
- Days to conversion or adjustment
- Conversion adjustment
- Ad event type
What Can We Expect In The Future?
This add-on was just released this summer so we can expect a lot of improvements. One aspect that some users have complained about is the lack of an option for automatic updates. For now, users need to manually refresh and sync data to their spreadsheets. Many add-ons, including Sheetgo, do offer this feature so it would make sense for Google to add this in an update in the near future. But until then, manual refreshes are not a huge hassle!
There do seem to be a few bugs as well. Some users have reported issues with the add-on running very slow, and others have mentioned issues with different currencies. Google is very responsive to the bugs and is listening to users. So be sure to report anything that seems off to the Google community—this will help Google to improve it faster!
How to Access The Google Ads Add-on
It is really simple to get add-ons for Sheets! The fastest way to get this add-on planning is to click this link that will take you directly to the web store.
Simply click the Free button and the add-on will be added to your Google Sheets account.
Alternatively, you can get the add-on by following these steps:
1. Open a spreadsheet
2. Click the add-ons button in the navigation menu
3. Click the Get add-ons button
4. A window will pop up for you to browse
5. Type “Google Ads” in the search box. There are a lot of add-ons that are designed to work with Google Ads, but Google’s version should be at the top.
6. Click the Free button to get the add-on
You are ready to start using Google Ads add-on for Sheets!