- \n
- Campaigns<\/li>\n
- Ad Groups<\/li>\n
- Ads<\/li>\n
- Search keywords<\/li>\n
- Negative keywords<\/li>\n
- Targeted location<\/li>\n
- Search teams<\/li>\n<\/ul>\n
Get reports from custom time ranges<\/strong>:<\/strong><\/p>\n
The add-on gives you the option to\u00a0generate reports from specific days, weeks, custom ranges \u2026 or even from all time!<\/p>\n
You can also choose to compare multiple time periods in the same report.<\/p>\n
Refresh reports quickly\u00a0<\/strong><\/p>\n
Save time and reduce errors by eliminating the need to download or copy and paste data into Google Sheets.<\/p>\n
Once you’ve created a report you can simply schedule regular updates.<\/p>\n
Add a variety of segments to your report such as:<\/strong><\/p>\n
- \n
- Day of the week<\/span><\/li>\n
- check_box_outline_blank<\/i><\/li>\n
- Day<\/span><\/li>\n
- Month<\/span><\/li>\n
- Quarter<\/span><\/li>\n
- Week<\/span><\/li>\n
- Year<\/span><\/li>\n
- Device<\/span><\/li>\n
- Click type<\/span><\/li>\n
- Conversion action<\/span><\/li>\n
- Conversion category<\/span><\/li>\n
- Network (with search partners)<\/span><\/li>\n
- Conversion source<\/span><\/li>\n
- Conversion action<\/span><\/li>\n
- Top vs. Other<\/span><\/li>\n
- Search terms match type<\/span><\/li>\n
- Days to conversion<\/span><\/li>\n
- Days to conversion or adjustment<\/span><\/li>\n
- Conversion adjustment<\/span><\/li>\n
- Ad event type<\/span><\/li>\n<\/ul>\n
How to get the Google Ads add-on<\/span>
<\/span><\/h4>\nIt’s really simple to get add-ons for Sheets. You can install the Google Ads add-on directly from Google by clicking this link<\/a>.<\/span><\/p>\n
Just click the\u00a0<\/span>Install<\/b>\u00a0button and the add-on will be added to your Google Sheets account.<\/span><\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/09\/google-ads-addon-marketplace.jpg” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Alternatively, you can get the add-on by following these steps:<\/span><\/p>\n
1. Open a spreadsheet<\/span>
<\/span>2. Click the add-ons button in the navigation menu<\/span>
<\/span>3. Click the Get add-ons button<\/span>
<\/span>4. A window will pop up for you to browse<\/span>
<\/span>5. Type \u201cGoogle Ads\u201d in the search box. There are a lot of add-ons that are designed to work with Google Ads, but Google\u2019s version should be at the top.<\/span>
<\/span>6. Click the button to get the add-on<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-13-at-11.46.56-AM.webp” alt=”Google Ads add-on” title_text=”google-ads” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to connect Google Ads to Google Sheets with the Google Ads add-on<\/h4>\n
Install the Google Ads add-on from the link we provided.<\/p>\n
Open a spreadsheet in Google Sheets. Check that you’re signed in to the same Google account that you use for your Google Ads account.<\/p>\n
Generate a new report:<\/strong><\/p>\n
From inside a new spreadsheet, go to menu > Add-ons. Hover your mouse over “Google Ads” then click “Create a new report”. Choose what date range, report type and filters you want to use.<\/p>\n
Update a report:<\/b><\/p>\n
From inside the report in Google Sheets that you want to update, go to menu > Add-ons. Hover your mouse over “Google Ads” then click “Refresh report”.<\/p>\n
Edit a report:<\/strong><\/p>\n
From inside the report in Google Sheets that you want to edit, go to menu > Add-ons. Hover your mouse over “Google Ads” then click “Edit a report”.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
That’s it! You’re ready to start using the Google Ads add-on for Google Sheets.\u00a0<\/span><\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Google Ads add-on: an awesome reporting tool\u2014and a huge timesaver Last year Google launched a new add-on for Google Ads (formerly known as Google Adwords) and this extension makes reporting significantly easier, pulling your data from Google Ads straight into a spreadsheet. Nothing beats Google Sheets for data analysis, presentation, reporting and collaboration. And if […]<\/p>\n","protected":false},"author":39,"featured_media":43899,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"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\u00a0our 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\u2014you know that it is going be intuitive to use, well-designed, and the kind of solution that easily integrates with and improves your workflow.\n\nGoogle 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!\n
It's An Awesome Reporting Tool<\/h6>\nWith 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.\n
Who is This Add-on For?<\/h6>\nBecause 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\u00a0single 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.\n
What Features Are Included in This Beta Version?<\/h6>\nExcellent Time Range <\/strong>Customization:\u00a0<\/strong>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.\n\nChoose to Create Report Categories Such as:<\/strong>\n
- \n \t
- Campaigns<\/li>\n \t
- Ad Groups<\/li>\n \t
- Ads<\/li>\n \t
- Search keywords<\/li>\n \t
- Negative keywords<\/li>\n \t
- Targeted location<\/li>\n \t
- Search teams<\/li>\n<\/ul>\nAdd in a Variety of Segments into Your Report Such as<\/strong>\n
- \n \t
- Day of the week<\/span><\/li>\n \t
- check_box_outline_blank<\/i><\/li>\n \t
- Day<\/span><\/li>\n \t
- Month<\/span><\/li>\n \t
- Quarter<\/span><\/li>\n \t
- Week<\/span><\/li>\n \t
- Year<\/span><\/li>\n \t
- Device<\/span><\/li>\n \t
- Click type<\/span><\/li>\n \t
- Conversion action<\/span><\/li>\n \t
- Conversion category<\/span><\/li>\n \t
- Network (with search partners)<\/span><\/li>\n \t
- Conversion source<\/span><\/li>\n \t
- Conversion action<\/span><\/li>\n \t
- Top vs. Other<\/span><\/li>\n \t
- Search terms match type<\/span><\/li>\n \t
- Days to conversion<\/span><\/li>\n \t
- Days to conversion or adjustment<\/span><\/li>\n \t
- Conversion adjustment<\/span><\/li>\n \t
- Ad event type<\/span><\/li>\n<\/ul>\n
What Can We Expect In The Future?<\/h6>\nThis 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<\/a>,\u00a0do\u00a0<\/em>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!\n\nThere 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\u2014this will help Google to improve it faster!\n
How to Access The Google Ads Add-on<\/span>\n<\/span><\/h2>\nIt is really simple to get add-ons for Sheets! The fastest way to get this add-on planning is to click this link<\/a> that will take you directly to the web store. <\/span>\n\nSimply click the <\/span>Free<\/b> button and the add-on will be added to your Google Sheets account.<\/span>\n\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-10-15-at-3.12.37-PM-1024x617.webp\")
<\/a>\n\nAlternatively, you can get the add-on by following these steps:<\/span>\n\n1. Open a spreadsheet<\/span>\n<\/span>2. Click the add-ons button in the navigation menu<\/span>\n<\/span>3. Click the Get add-ons button<\/span>\n<\/span>4. A window will pop up for you to browse<\/span>\n<\/span>5. Type \u201cGoogle Ads\u201d in the search box. There are a lot of add-ons that are designed to work with Google Ads, but Google\u2019s version should be at the top.<\/span>\n<\/span>6. Click the Free button to get the add-on<\/span>\n\nYou are ready to start using Google Ads add-on for Sheets!<\/span>\n\n![\"google](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-13-at-11.46.56-AM-1024x752.webp\")
","_et_gb_content_width":"","footnotes":""},"categories":[30],"tags":[45,28],"class_list":["post-10120","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-marketing-processes","tag-marketing","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/10120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=10120"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/10120\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/43899"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=10120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=10120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=10120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} - check_box_outline_blank<\/i><\/li>\n \t
- Day of the week<\/span><\/li>\n \t
- check_box_outline_blank<\/i><\/li>\n
- Day of the week<\/span><\/li>\n