Google Analytics is really useful for identifying how much traffic your website's landing pages are receiving, and where it's coming from. It's easy to report on these results directly in your spreadsheet, and share them with your team.
In this tutorial, we’re going make use of our basic Google Analytics reporting skills in a real world example - creating a report in Google Sheets that checks in our new landing page. Then, we'll show you how to share this report with your team. You will go through the following two steps:
- Build a Landing Page report in Google Sheets
- Share your Landing Page report with your team
Once finished, you'll have a useful Google Analytics report you can share, and the skills you need to customize it for your specific needs.
Step 1: Build a Landing Page Report in Google Sheets
Let's say you've just create a new landing page on a website, and you want to keep track of how well the page is performing.
To get started, open a new Google Sheet. Then, open the Blockspring plugin and navigate to Analytics Report in the Blockspring Console.
Now, customize your report by adding a date range (we've done this through yesterday's date as of publication) and metrics of interest. We're using the metrics: Users, Sessions, Bounces - but it's common to check Pageviews, Exits, and others as well. Then, add the dimensions of Default Channel Grouping and Landing Page. Finally, for this scenario we'll add a filter (found under Optional Parameters) to look at just a single landing page - "/". You can always leave this filter out, and use a pivot table or lookup formula (like VLOOKUP) to do this after the report has been run.
Remember to click the "Insert into Sheet" button to run the report, and it'll populate a new tab with your data.
Step 2: Share your Landing Page report with your team
Now that you have a working Landing Page report, you'll may want to share the information with a coworker.
If you coworker wants to modify the report (for example, to update the date range the report is run over), click on "File -> Share..." in the top menu bar, and type their email address into the box. You'll want to give them the option to Edit the document.
If they've not done so yet, your coworker should get setup with Blockspring like we did in the previous tutorial. Then, they can change the values in cells (e.g. the Start Date and End Date cells) to get dynamic reports.
If they don't need a dynamic report, click on "File -> Download" in the top menu bar to see a list of file types like PDFs that you can use. Simply send this file to your coworker, and you're done!
You've learned how to use your basic Google Analytics reporting skills to create a Landing Page report in a Google Sheet, and how to share the results with your colleagues. Here are some ideas on what to do now:
- The Landing Page report is a good starting point to start other questions you might have. Trying customizing your landing page report with different metrics, or expanding the report to fit other use cases you care about by changing the dimensions.
- If you're okay with anyone with the link being able to see your data, try publishing your report as a webpage ("File -> Publish to web..."). You'll be able to share a non-interactive version of your report, which will update to reflect the data in your spreadsheet.
- Having to update the Start and End Dates each time you want to refresh your report could get tedious, especially when many reports using trailing periods (e.g. last 30 days). Can you think of a way to use built-in spreadsheet functionality to make this automatic? (Hint: the next tutorial will show you how!)
Ready to jump to our next lesson? We'll learn how to make a dynamic, trailing 30 day Bounce Rate report that will automatically refresh with the most up-to-date data.