There are also other options to make the data visually appealing and more accessible when you look at it at a quick glance. We could also change the background color, for example to blue, or change the font color, and so on. For this, select the header row and click on the Bold option. It’s also important to make this data visually appealing so that we can know at a quick glance what we’re looking at. For this, select the empty rows on the top, right-click and select Delete rows 1 – 6.

So, we will delete any cells that don’t belong to our data set.Īlso, we will get rid of any empty rows on the top of the sheet so that we have our first row as a header row. Preparation: Cleaning and Formatting Dataįirst up, let’s clean this data. Now that we have this sheet available with all our data, let’s look at how we can analyze this data. You can also export data from Google Analytics to Google Sheets using the Google Analytics add-on. You can install it as an add-on to your account and then pull the data directly from the API. This tool is then accessible under Add-ons in Google Sheets.

Now if you would like to automate the whole process, my top recommendation is a tool called Supermetrics. However, Google has an export function that we can use. We could do this manually, but that will be quite cumbersome. Now, for the next step you should copy this data into Google Sheets. Here, we can go to Conversions → E-commerce → Product Performance report and see that there is some useful data here that we can analyze. Note that this is demonstrated using Universal Analytics, but you can also pull other data from a Google Analytics 4 property. So I’ve logged into the Google Analytics demo account. Quick Way to do Data Analysis with Google SheetsĮxporting Data from Google Analytics to Google SheetsĪlright, before we start in Google Sheets, we actually need to have some data available.Preparation: Cleaning and Formatting Data.Exporting Data from Google Analytics to Google Sheets.An overview of what we’ll cover in this guide:

How to get data analysis on excel