Get Google Analytics data to Google Sheets

Easily automate and extract Google Analytics data to Google Sheets, simplifying data processing, visualization, integration with other sources, and collaboration with your team.

Why connect Google Analytics to Google Sheets

Generate real-time reports on website traffic

Generate real-time reports on website traffic

Gain insights into how users interact with your website by importing data including page views, site speed, and user behavior into Google Analytics. Utilize these metrics to understand peak traffic times and user location, helping you to focus your marketing efforts and improve website performance.

Formulate auto-updating user behavior predictions

Formulate auto-updating user behavior predictions

By fetching and analyzing historical data on user engagements, Google Analytics enables you to predict future user behavior. Make use of these predictions to strategize website modifications that could enhance user experience and, subsequently, engagement rates.

Blend Google Analytics data with Ad campaigns

Blend Google Analytics data with Ad campaigns

Import Google Analytics data into Google Ads to gain an overall picture of your ad campaign performance. Evaluate metrics like ad impressions, clicks, and conversions to assess campaign efficacy. Combine this data with website traffic and user behavior insights to gain a more holistic view of your online business performance.

Google Analytics to Google Sheets : what to export

Export all important Google Analytics Metrics and Dimensions for analysis in Google Sheets

Ecommerce

Ecommerce

Analyze revenue, transactions, and unique purchases to understand sales performance. Use ecommerce conversion rate to assess website effectiveness in generating transactions. Track avg. order value to identify opportunities for upselling. Study shopping stage to optimize the customer journey. Determine transaction ID to match purchases to users. Evaluate per session value to gauge revenue potential. Investigate product adds to cart to improve product visibility. Monitor product names to identify popular products to keep in stock.

Time

Time

Analyze your website's performance using Google Analytics timestamps to enhance your operations. Monitor the hourly trend and user activity, instead of just daily or weekly. Check which days or weeks receive higher traffic and when to boost online engagement. Concentrate on year-rounded statistics to improve campaigns and budgeting.

Session

Session

Analyze your website's performance using Google Analytics session metrics such as sessions, bounce rate, and average session duration. Identify single page sessions and bounces to monitor user engagement. Use session duration and unique dimension combinations to improve website content and user experience, leading to increased engagement and conversions.

User

User

Track the total number of users, including new visitors and returning visitors, to your website. Determine the percentage of new sessions and the number of first-time users. Calculate the average number of sessions per user and identify the days since their last visit. Find out the total number of 7-day and 30-day active users for each day. Assign a session index for each user to understand their behavior. Use these insights to enhance your operations and tailor your reports accordingly.

Traffic Sources

Traffic Sources

Analyze your website's traffic sources to identify where your visitors are coming from, including the source (referral), medium (type of referral), campaigns, keywords, and ad content. Use the insights to optimize your marketing strategies for higher conversion rates. Additionally, track organic searches, the full referring URL, social network, and referral path to enhance user engagement and retention by understanding their behavior.

Page Tracking

Page Tracking

Analyze landing pages, track pageviews and unique pageviews, calculate the average number of pages viewed per session, monitor users' time on site, and evaluate exit rates and page value. Utilize these insights to optimize website performance, increase user engagement, and drive conversion.

Goal Conversions

Goal Conversions

Analyze completed goals to improve conversion rates with Google Analytics. Use Goal Completion metrics to see how many users complete a requested goal number, and Goal Conversion Rates to find the percentage of sessions resulting in conversion to at least one goal. Use these insights to optimize website operations and increase conversions.

Adwords

Adwords

Evaluate the Adwords campaign's effectiveness by analyzing the derived cost, clicks, and impressions. Understand the cost per click, impression, and transaction for achieving better ROI. Measure the CTR's effectiveness and analyze match types to understand how keywords are performing. Optimize the campaign by adjusting budget or keywords to achieve better results.

Channel Grouping

Channel Grouping

Analyze the source of your website traffic using Channel Grouping. Sort your visitors by source - Organic, Referral, Direct, Social, Display, Email, and Other. Use this information to make informed decisions on which channels to focus on for better conversion rates and ROI.

Event Tracking

Event Tracking

Explore the number of actions taken on your website with Event Tracking. Analyze the Event Category, Event Action, Event Label, and Event Value for comprehensive insights. The Unique Events metric helps you track repeat event sessions, while Sessions with Event and Events / Session with Event tell you how visitors interact with your website. Use this data to improve user experience and increase conversions.

How to export Google Analytics to Google Sheets & automate it

Google SheetsGoogle Sheets
Step 1

Install Two Minute Reports (TMR) for Google Sheets

Open Google Sheets and install Two Minute Reports from the add-ons menu. No credit card required.

Step 2

Connect your Google Analytics with Two Minute Reports

Open TMR add-on and select Data Source from the menu button. Click Add and add your new Google Analytics data source

Step 3

Select the Google Analytics data you need

Open the Queries menu and create a new query. Select the Google Analytics data source you added along with the Google Analytics metrics and dimensions you want.

Step 4

Automate Schedules to Google Analytics export to Google Sheets

Create a new schedule to automatically fetch live data from Google Analytics at periodic intervals. You can even send emails, PDFs or Excel sheets on schedule.

Step 5

Skip steps and jump start Google Analytics with Templates

Instead of creating a report from scratch use our premade Google Analytics templates below and get started in no time

Start using these quick templates Now

GA Purchase Exploration Template
Looker Studio
Facebook Ads, Google Ads & analytics - complete side-by-side Analysis
Looker Studio
Traffic Dashboard with 12 Month Trend Chart and MoM Change%
Looker Studio

Automate Google Analytics to Google Sheets export & do more with Two Minute Reports

Two Minute Reports for Google Sheets has these features for you

Ease of Use

Ease of Use

Two Minute Reports is designed to be user-friendly and easy to navigate. With its intuitive interface, you can quickly generate reports and track your marketing campaigns without the need for extensive training or technical knowledge.

Battle tested by Millions of Users

Battle tested by Millions of Users

By working with BI platforms developed with Billions of Investment by Google - like Google Sheets and Looker Studio, Two Minute Reports provides robust capabilities and a secure infrastructure for your Reporting

Data Integration and more

Data Integration and more

Two Minute Reports integrates with Google Analytics and over 30+ Marketing platforms so that you can analyse and visualize your data in the BI platform of your choice.

Why use Two Minute Reports to import Google Analytics data to Google Sheets

Marketers know how critical it is for a business to correctly measure the performance of ad campaigns. Using standard Google Analytics tools, the in-line performance analytics are pretty straightforward. But things can change if you need to analyse custom metrics over an extended period. Generic Google Analytics dashboard tools are simply not intended for more detailed analysis that includes customizing filters and analysing the performance of multiple campaigns from multiple accounts. That is where Two Minute Reports steps in. Its Google Analytics to Google Sheets integration allows you to automate the process of extracting data from Ads on a custom schedule. You can merge data on multiple campaigns and ads in a single sheet, applying all the powerful tools Google provides. These include pivot tables, graph visualization, formulas, and team sharing capabilities.

Google Analytics

Google Analytics

88arrow
Google Sheets

Google Sheets

88arrow
fads

Manage, Share, Analyze

Do more with Google Sheets + Google Analytics

With Two Minute Reports, you can get Google Analytics data in Google Sheets and also merge it with other Advertising data from platforms like Google Analytics, Google Analytics 4. Not just that, you can also get data from different types of Mobile, Database, Advertising (PPC), Web Analytics, SEO, E-Commerce, Other sources, Social Media, Email, Customer relationship management Data Sources.

ga

Google Analytics

ga4

Google Analytics 4

Get Google Analytics data in other tools too

We also help get your Google Sheets to the following Tools

Looker Studio

Looker Studio

Two Minute Reports for Google Sheets helps you to get your Google Analytics data to Google Sheets. You can not just analyse data you do much more there. By running on top of Google Sheets, we support a range of customization options, including the ability to create custom formulas and functions, unlimited formatting and sharing capabilities, Google Sheets has a friendly interface that many of us are familiar with. Spreadsheets are easier to handle when you are looking at a lot of Data and you dont have to learn a new tool.

Connect other Ad Platform Data Sources with Google Sheets

You can combine data from other Ad data sources with your Google Analytics Reports

Image
Google Analytics

Google Analytics

Website analytics platform from Google for data-driven insights.

Google Analytics 4

Google Analytics 4

Web analytics platform providing insights for marketing optimization.

Connect other Marketing Channels with Google Sheets

You can combine Google Analytics data with not just Ad Platforms but also with other Platforms too

Mobile

Mobile

The category includes Data Sources like the Apple App Store and Google Playstore. That have information on apps that are provided to the data sources.

Database

Database

The category includes SQL based data sources connectors such as Cloud Firestore, MariaDB, MySQL, Postgre SQL.

Advertising (PPC)

Advertising (PPC)

This falls in the advertising category, more evidently Pay Per Click Connectors, for Facebook Ads, Google Ads, Snapchat Ads, LinkedIn Ads, TikTok Ads and Miicrosoft Ads

Web Analytics

Web Analytics

Data Sources like Google analytics, that analyzes the behaviour of visitors to a web site, falls in this category.