This add-on is an extension that allows you to:<\/p>\n
- \n
- Import data from the Google Analytics API into a spreadsheet<\/li>\n
- Create custom reports<\/li>\n
- Query and report data<\/li>\n
- Filter the data you want to extract<\/li>\n
- Schedule automated updates for your reports<\/li>\n<\/ul>\n
Google Sheets add-ons allow you to turbocharge the way you use spreadsheets.\u00a0 This particular add-on is developed by Google, which means it runs seamlessly with Google products, is intuitive to use, and of course, free! Let\u2019s get you started with a basic primer on how to use the\u00a0GA4 Reports Builder add-on<\/a>\u00a0<\/span>to improve the way you report and share your website data.<\/p>\n
How to access the GA4 Reports Builder<\/span>\u00a0Add-on<\/span><\/h4>\n
It’s really simple to get add-ons for Sheets. The quickest way to get this add-on is to\u00a0click this link<\/a> that will take you directly to the Google Workspace Marketplace. <\/span>Simply click the\u00a0<\/span>Install\u00a0<\/b>button 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\/2024\/11\/GA4_Reports_Builder.webp” alt=”GA4 Reports Builder” title_text=”GA4_Reports_Builder” _builder_version=”4.27.2″ _module_preset=”default” 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
- \n
- Open a spreadsheet<\/span>
<\/span><\/li>\n- Click the add-ons button in the navigation menu<\/span>
<\/span><\/li>\n- Click the Get add-ons button<\/span>
<\/span><\/li>\n- A window will pop up for you to browse<\/span>
<\/span><\/li>\n- Type \u201cGA4 Reports Builder\u201d in the search box. There are a lot of add-ons for Google Analytics, but the one you are looking for should be #1.<\/span>
<\/span><\/li>\n- Click the Free button to get the add-on<\/span><\/li>\n<\/ol>\n
You are now ready to use the add-on to connect Google Analytics to Google Sheets.<\/span><\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/11\/GA4_Reports_Builder_GWM.webp” alt=”GA4 Reports Builder – GWM search” title_text=”GA4_Reports_Builder_GWM” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Options in the main toolbar<\/h4>\n
To begin using the GA4 R add-on, Click Add-ons \u2192 Google Analytics. When you hover over the Google Analytics button, you will see three options:<\/p>\n
- \n
- Create a new report:\u00a0<\/strong>creating reports is not necessary, but it\u2019s a good step for users who are new to the add-on. If you click this option, a sidebar will appear on the right side of the sheet to help you automatically create a new report. As you become a more advanced user, you might just create these reports yourself.<\/li>\n
- Run reports:<\/strong>\u00a0when you select this option, the add-on will run all of the reports you have created. You can choose to have the output data go into the current sheet you are on or a new sheet of your choice. If there are reports you don\u2019t want to run, get around the add-on by simply deleting the name of the report. Because of the way the add-on is designed, it won\u2019t be able to run reports without names.<\/li>\n
- Schedule reports:<\/strong>\u00a0ever a fan of automation, scheduling reports is one of my favorite ways to improve workflows. You can schedule your reports to run hourly, daily, weekly, or monthly from the sidebar that appears when you select this option.<\/li>\n<\/ul>\n
Let\u2019s create a report<\/h4>\n
For this tutorial, we will start by creating a new report. Select this option to make the sidebar for this feature appear. To run reports, you need to be the owner of the analytics account, and ideally, have some basic knowledge of Google Analytics terminology. Although this add-on is meant to make using Analytics easier, you will still need to have some basic knowledge. Fortunately, using this add-on will give you a greater understanding of your Analytics data, and you can use the\u00a0<\/span>Google Analytics Academy<\/a>\u00a0for free if you need to brush up on your skills.<\/p>\n
<\/p>\n
- \n
- Name your report:<\/strong>\u00a0<\/span>Ours is Sample Report 1<\/li>\n
- Select a view:\u00a0<\/strong>Choose your Account name, Property name, and the View from the drop-down options. Most of you will probably just have one analytics account, but if you are managing multiple websites, you will need to be sure to choose the correct values.<\/li>\n
- \u00a0Choose configuration options:\u00a0<\/strong>Here you will customize the reports. This tool is great because it can help novice users learn what sort of metrics will be most valuable for providing insights into their traffic.<\/li>\n
- When you are finished choosing the conditions for your first report click\u00a0Create Report\u00a0<\/strong>and the add-on will create a report template for you. You can continue to create new reports, and they will be displayed sequentially on the same sheet.<\/li>\n<\/ol>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/connect-Google-Analytics-to-Google-Sheets-3.png” alt=”connect Google Analytics to Google Sheets 3″ title_text=”connect Google Analytics to Google Sheets 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/connect-Google-Analytics-to-Google-Sheets-4.png” alt=”connect Google Analytics to Google Sheets 4″ title_text=”connect Google Analytics to Google Sheets 4″ _builder_version=”4.16″ _module_preset=”default” 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
Run Reports<\/h4>\n
Now that we have created some reports using the toolbar, let\u2019s use the add-on to run some reports. Select the second options from the menu by clicking\u00a0Add-ons\u00a0\u2192\u00a0\u00a0Google Analytics\u00a0\u2192\u00a0Run Reports. <\/span><\/strong>That\u2019s all you need to do! The add-on will begin to work automatically and will create a new sheet for each report. So, my sheets are titled Sample Report 1,\u00a0Sample Report 2, and Sample Report 3. After you set up your report, you can choose the third option and schedule your reports<\/strong> to run automatically. Use your Google sharing settings to share the results with the whole team.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-3.25.53-PM.png” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Google Analytics is one of the most popular and powerful tools for analyzing your website traffic. But you need somewhere to analyze that data effectively. This is especially true when your business is growing and you’re experimenting with different online marketing strategies; you may need to analyze hundreds of different metrics at regular intervals. When […]<\/p>\n","protected":false},"author":39,"featured_media":43903,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"How to use Google Analytics add-on for Google Sheets<\/span>\n\nGoogle add-ons is a feature of Google Sheets that allows you to turbocharge the way you use spreadsheets. Most of the add-ons that we feature on the blog are 3rd party developers. Offering features like task automation or software integration. This add-on is developed by Google, which means it runs seamlessly with Google products, is intuitive to use, and of course, free! Let's get you started with a basic primer on how to use the Google Analytics add-on<\/a> to improve the way you report and share your website data!\n
How to Access the <\/span>Google Analytics Add-on<\/span><\/h4>\nIt is really simple to get add-ons for Sheets! The fastest way to get this add-on is to click this link<\/a> that will take you directly to the web store. <\/span>Simply 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.08.24-PM-1-1024x628.png\")
\n\nAlternatively, you can get the add-on by following these steps:<\/span>\n- \n \t
- Open a spreadsheet<\/span>\n<\/span><\/li>\n \t
- Click the add-ons button in the navigation menu<\/span>\n<\/span><\/li>\n \t
- Click the Get add-ons button<\/span>\n<\/span><\/li>\n \t
- A window will pop up for you to browse<\/span>\n<\/span><\/li>\n \t
- Type \u201cGoogle Analytics\u201d in the search box. There are a lot of add-ons for Google Analytics, but the one you are looking for should be #1.<\/span>\n<\/span><\/li>\n \t
- Click the Free button to get the add-on<\/span><\/li>\n<\/ol>\nYou are ready to start using Google Analytics!<\/span>\n\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-2.19.40-PM-1024x696.webp\")
\nOptions in The Main Toolbar<\/h4>\nTo begin using the Google Analytics add-on, Click Add-ons \u2192 Google Analytics. When you hover over the Google Analytics button, you will see three options:<\/span>\n
- \n \t
- Create a new report: <\/strong>creating reports is not necessary, but it's a good step for users who are new to the add-on. If you click this option, a sidebar will appear on the right side of the sheet to help you automatically create a new report. As you become a more advanced user, you might just create these reports yourself.<\/li>\n \t
- Run reports:<\/strong> when you select this option, the add-on will run all of the reports you have created. You can choose to have the output data go into the current sheet you are on or a new sheet of your choice. If there are reports you don't want to run, get around the add-on by simply deleting the name of the report. Because of the way the add-on is designed, it won't be able to run reports without names.<\/li>\n \t
- Schedule reports:<\/strong> ever a fan of automation, scheduling reports is one of my favorite ways to improve workflows. You can schedule your reports to run hourly, daily, weekly, or monthly from the sidebar that appears when you select this option.<\/li>\n<\/ul>\n \n
Let's Create a Report<\/h4>\nFor this tutorial, we will start by creating a new report. Select this option to make the sidebar for this feature appear. To run reports, you need to be the owner of the analytics account, and ideally, have some basic knowledge of Google Analytics terminology. Although this add-on is meant to make using Analytics easier, you will still need to have some basic knowledge. Fortunately, using this add-on will give you a greater understanding of your Analytics data, and you can use the Google Analytics Academy<\/a> for free if you need to brush up on your skills.\n
- \n \t
- Name your report:<\/strong> Ours is Sample Report 1<\/li>\n \t
- Select a view: <\/strong>Choose your Account name, Property name, and the View from the drop-down options. Most of you will probably just have one analytics account, but if you are managing multiple websites, you will need to be sure to choose the correct values.<\/li>\n \t
- Choose configuration options: <\/strong>Here you will customize the reports. This tool is great because it can help novice users learn what sort of metrics will be most valuable for providing insights into their traffic.<\/li>\n \t
- When you are finished choosing the conditions for your first report click Create Report <\/strong>and the add-on will create a report template for you. You can continue to create new reports, and they will be displayed sequentially on the same sheet.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-3.02.26-PM-1024x524.webp\")
\n\n![\"use](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-3.20.07-PM-1024x509.webp\")
\n\n \nRun Reports<\/h4>\nNow that we have created some reports using the toolbar, let's use the add-on to run some reports. Select the second options from the menu by clicking Add-ons \u2192 Google Analytics <\/strong>\u2192 Run Reports<\/strong>. That's all you need to do! The add-on will begin to work automatically and will create a new sheet for each report. So, my sheets are titled \"Sample Report 1, Sample Report 2, Sample Report 3\". After you set up your report, you can choose the third option and schedule your reports to run automatically. Use your Google sharing settings to share the results with the whole team!<\/span><\/strong>\n\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Screen-Shot-2018-09-03-at-3.25.53-PM-1024x564.webp\")
","_et_gb_content_width":"","footnotes":""},"categories":[30],"tags":[45,28],"class_list":["post-9853","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\/pt\/wp-json\/wp\/v2\/posts\/9853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=9853"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9853\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/43903"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=9853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=9853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=9853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} - Select a view: <\/strong>Choose your Account name, Property name, and the View from the drop-down options. Most of you will probably just have one analytics account, but if you are managing multiple websites, you will need to be sure to choose the correct values.<\/li>\n \t
- Run reports:<\/strong> when you select this option, the add-on will run all of the reports you have created. You can choose to have the output data go into the current sheet you are on or a new sheet of your choice. If there are reports you don't want to run, get around the add-on by simply deleting the name of the report. Because of the way the add-on is designed, it won't be able to run reports without names.<\/li>\n \t
- Click the add-ons button in the navigation menu<\/span>\n<\/span><\/li>\n \t
- Select a view:\u00a0<\/strong>Choose your Account name, Property name, and the View from the drop-down options. Most of you will probably just have one analytics account, but if you are managing multiple websites, you will need to be sure to choose the correct values.<\/li>\n
- Run reports:<\/strong>\u00a0when you select this option, the add-on will run all of the reports you have created. You can choose to have the output data go into the current sheet you are on or a new sheet of your choice. If there are reports you don\u2019t want to run, get around the add-on by simply deleting the name of the report. Because of the way the add-on is designed, it won\u2019t be able to run reports without names.<\/li>\n
- Click the add-ons button in the navigation menu<\/span>
- Open a spreadsheet<\/span>