So what is the best way to export data from Google Analytics to a Google Sheet. Well today
Ahmad is going to show us three ways of doing so. All and more coming up. Hey there measuregeeks,
Julian here. Back with another video for you today. We have Ahmad from Siavak.com back
on a channel to show us three ways to export data from Google analytics into a Google Sheet.
Why would you do so? In google sheets you can work with this data even more. Use the
built in functionalities of Google Sheets, combine it with other data forms, transform
it, do your analysis there or even then connect it to your data visualization tools like Google
data studio to show this data to others. So Google Sheets is a really cool tool to do
more data analysis on our data. But first we need to get it out from Google analytics
to the sheet. How do we do this? Well today Ahmad is gonna show us three ways of doing
so and gonna show us what the differences really are. Where we could make it a little
bit more convenient. And he is also gonna dive into a data sampling. So as always we've
got lots to cover. So I'm Ahmad, take it away. Thanks Julian. Hello and welcome to another
measureschool tutorial. This is Ahmad. And in this video I'm going to show you how to
extract data from your Google Analytics account into a spreadsheet. You spend a lot of time,
money, and resources to track quality data into your Google Analytics account. And there
are several reasons you might want to get your data out of Google Analytics and import
it into a CSV file spreadsheet like Microsoft Excel or a Google Sheet. You might want to
merge your data with other data sources like user data from your CRM, cost data from advertising
platforms like Google ads and Facebook ads, campaign data from e-mail marketing tool,
or product profitability data from your shopping cart so you can do further analysis on your
data. And finally to create better looking charts and visualizations to share with others.
Today I'm going to briefly demonstrate and compare three different methods of extracting
data from Google analytics into a Google Sheet, manual exports from Google Analytics interface,
Google Analytics add on for Google Sheets and supermetrics. OK. So let's start with
the first method manual export. In short you used google analytics interface to adjust
their reports the way you wanted to be exported and then you used a built in functionality
in G.A. to download a CSV or excel file but directly export your data into a spreadsheet.
Let's see how it's done. First you log in into your Google Analytics account and navigate
to the report that you want to export. Then you need to adjust a report in the exact way
that you wanted to be exported. You can adjust the date, you can apply segment,
you can add a secondary dimension or apply a table filter.
Once you're happy with your reports, just click export and choose the way you want your
data to be exported. You can download your report data as a file in a CSV or Microsoft
Excel format. Or you can directly export it into a Google
Sheet. That's it your data is extracted and ready. The benefits of this method is that
it's quick and easy. There is nothing to learn. There is no software
to install and it's completely free. But there are also some issues. First of all the data
set is a static. If you need to create reports on a daily or weekly basis you need to follow
the exact same steps manually each time. The other problem is that the format of the data
set isn't the best for working with data. First we have this additional summary rows
at the top. Second ,we have the time series data table
at the bottom which corresponds to the data put this time to his chart in Google Analytics.
And finally we have total rows at the bottom of the table.
So if we want to work with this dataset we first need to remove these extra rows and
data sets. Or we need to copy and paste the main table into another spreadsheet. Another
issue with this method is that it only exports visible rows from your Google Analytics reports.
So if for example we have our report set to only show 10 rows at a time only the rows
that are visible here will be exported to the Google Sheet. If you want more rows to
be extracted you need to increase the number of rows shown in this report. And as you can
see the maximum is five thousand so you cannot export more than 5000 rows of data at a time.
If you have more data you have to export multiple times page by page. So to recap. This manual
export feature is quick and free but it's only good for ad hoc analysis. And when you're
working with a small dataset. Next I'm going to show you how to do this process automatically
and with more flexibility.