Skip to main content

5 Steps to Automate Your Google Analytics Reporting

If you love analytics and relay on google analytics for your website insights then without a doubt, you're looking for ways to make Google Analytics Reporting easier and faster: Automation it is.

Today, I'm going to guide you through how you automatically keep up-to-date with your latest Google Analytics Data directly with Google Spreadsheet. If you’re just getting started with Google Analytics or if you are Google Analytics Ninja looking for ways to Automate Your Google Analytics Reporting, this article is for you.

Setting Up Your Automated Google Analytics Report

Here’s how you can get set up with your website google analytics reporting with Google Spreadsheet. You don't need to click around in Google Analytics and export reports anymore, this 5 Steps will do everything for you.

Step 1:

install the “Google Analytics” addon for Google Sheets

Google Analytics Addon for Google Sheet

Step 2:

Open Google Spreadsheet, and Create a New Report in the “Add-ons” Dropdown

Create new report Via Google Sheet

Step 3:

When the pops up come in fill the form with appropriate info for your report, be sure to select the site you want Analytics on!

Input Analytics Report Info

Step 4:

Then click “Create Report.” Now in the info that pops up, copy your “Profile ID.” You’re going to need this!

Google Analytics Profile ID

Okay, now leave that spreadsheet be.

Then, open up this spreadsheet, and create a copy of it.

Make a copy of Template spreadsheet

Now in the spreadsheet copy you made, put in your Analytics code in line 4:

Input your analytics code here

Step 5:

Now it's time to Automate Your Google Analytics Reporting, go to Add-ons -> Google Analytics -> Run Report and you’re good!

You have a report that you can run whenever you want that gets your Top Referrers, Social Sources, Top Keywords, Top Campaigns, and more. Just click through the different sheets from the bottom of the Spreadsheet!

I know the guide may seem a bit overwhelming, but it is really easy, Just follow these five simple steps. It shouldn’t take you more than 10 minutes to set up, and you don’t need any experience in Google Spreadsheets to follow these steps.

Do you automate your Google Analytics reporting? let us know by your comment below.


  1. Great article as usual. Parvez, is there any tools for GA reporting automation?

    1. Thanks Buddy. You can automate analytics reporting by DataHero.


Post a Comment

Popular posts from this blog

The Philosophy Behind Link Building

Among Internet Marketer, there seems to have controversy when it comes to baclinks, link building strategies & it's importance. if you ask a group of online marketer, What is a backlink?, Why are backlinks So Useful?, How do search engines evaluate backlinks?, importance of backlinks in seo? link earning, etc you'll get different & vague answers from them.

To make you clear, in this post I'll write simple to understand definition of Philosophy Behind Link Building & to help you make sense of what's backlinks truly harmful for your website.

So, What is a Backlink?
A backlink is a clickable piece of text or an image that links one website, webpage, or files to another. As an example here is a link to the Local SEO Consultant at this website, which is surrounded by the anchor text "Local SEO Consultant", So, we’ve got the answer of most important question out of the way.

Backlinks are also knows as Internal Links, Inbound Links & Outbound Links.…

6 Lead Generation Strategies Using White Papers

It’s clear that white papers are a great way to open doors and make the sales process easier. At this point, you’re probably excited about using white papers. Once you have a quality white paper written, it`s time to use it to generate leads. Use these proven lead generation strategies to attract interest from qualified prospects.

Build an email list with your white paper.
Email marketing remains one of the most reliable ways to make sales. There`s just one problem: how do you get relevant prospects to sign up for your email list? There’s a simple solution: offer a free digital copy of your white paper to each person who signs up.

You can then reach out to each person who signs up for the white paper. Pro Tip: Experiment with different services such as the Hello Bar or SumoMe’s Scroll Box to increase the number of email signups on your website.

Introducing a new product to past customers.
How often have you heard the advice – which is absolutely true! – that selling to past customers th…

How To Improve your Online Retail Store’s Search Engine Optimization

You know the math right, According to the National Retail Federation’s annual consumer spending survey conducted by Prosper Insights & Analytics, consumers plan to spend an average of $935.58 during the holiday shopping season. Total spending includes gifts for others, self-spending, food, flowers, decorations and greeting cards for Christmas, Hanukkah and Kwanzaa. Total planned spending this year is second only to the record total spending in 2015, at $952.58.

NRF Expects online retail sales in November and December (excluding autos, gas and restaurants) to increase a solid 3.6 percent to $655.8 billion. Online sales are forecast to increase between 7 and 10 percent over last year to as much as $117 billion. Retailers are expected to hire between 640,000 and 690,000 seasonal workers this holiday season, in line with last year’s 675,300 holiday positions.
In our last article I talked about how November Replacing Black Friday & Cyber Monday for USA, UK & Canadian Shoppers.…