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.
In this tutorial, we’re going make use of our basic Google Analytics reporting skills in a real world example - creating a customized report in Excel that checks in our new landing page.
Build a Landing Page Report in Excel
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 Excel spreadsheet. Then, open the Blockspring plugin and navigate to Google Analytics > Analytics Report in the Blockspring Console.
Now, customize your report by adding a date range 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 New Sheet" button to run the report, and it'll populate a new tab with your data.
You've learned how to use your basic Google Analytics reporting skills to create a Landing Page report in Excel, 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.
- 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.