Interactive-Website-Performance-Report

A screenshot of nine pages with charts and tables from the report template

Interactive Monthly Website’s Performance Report Template

Overview

It is an open-source report template that helps a digital team analyse the website’s performance over a given month in comparison to the previous period and the same period last year, and highlight important findings to the top management.

It takes data from your site using Google Analytics and displays it in Google Data Studio (a free online tool for visualising a large amount of data), to find useful insights.

Google Data Studio can load data from all kinds of sources, for example, Google Analytics, Google Search Console, Google Ads, Google Sheets, BigQuery, Facebook Ads and a lot more.

Versions Ready to Use

Version 1.3

Google Analytics (Summary, Fundamental pages, Blog, Goals, Ecommerce) & Google Ads - designed for any website that uses Google Analytics, has a blog, Goals and Enhanced Ecommerce set up in Google Analytics and uses Google Ads to promote this website online.

Changelog:

Version 1.2

Changelog:

Version 1.1

Google Analytics (Summary, Fundamental pages, Goals, Ecommerce, Blog) - designed for any website that uses Google Analytics and has a blog, Goals and Enhanced Ecommerce set up in Google Analytics.

Changelog:

Version 1.0

Google Analytics (Summary, Fundamental pages, Goals, Ecommerce) - designed for any website that uses Google Analytics and has Goals and Enhanced Ecommerce set up in Google Analytics.

Changelog:

Instructions

Here are detailed step-by-step instructions for using this report to analyse a website you manage.

  1. Google Data Studio account
  2. Select a report
    • Click on a link to one of the reports above that you would like to use.
  3. Copy the report
    • Move your mouse cursor to the top edge of the report window. The top navigation bar will appear.
    • On the right-hand side, you will see an icon with two rectangles, one on top of another. Click on it to make a copy of the report.
    • In the pop-up window, select a new Data Source. You can use ‘Sample Google Analytics Data’ if you would like to just play with the report or click on a drop-down field below the heading ‘New Data Source’. Then, click the ‘Create New Data Source’ button at the bottom if you would like to use data from one of the sites that you manage. In the search box, type ‘Google Analytics’ and select it. Then, press the ‘Authorize’ button, and ‘Allow’ on the page that appears. Now select a Google Analytics account, then a property, and finally a view of the website for which you would like to use this report. Next, click the ‘Connect’ button in the top-right corner. Then, select the ‘Add to Report’ button in the top-right corner. Press the ‘Copy report’ button. You can find more information about this step in the Google Analytics data source tutorial at the Google Help Center.
    • Give it an appropriate name like ‘Website Performance Report for Company X - March 2019’ by clicking on the text ‘Website Performance Report…’ in the top-right corner.
  4. Edit the report
    • If you are not in ‘Edit mode’, move your mouse cursor to the top edge of the report window. The top navigation bar will appear. Then, click the grey button that says ‘Edit’. Now you can change anything in this report.
    • Go to ‘File’ (top navigation bar), select ‘Report Settings’, and select the date range for which you would like to show the data (to do this, you need to first select the report-level data source). Once done, it will be updated on all pages.
    • Remove the ‘Company’s Logo’ placeholder. Once removed, it should automatically disappear from all pages. Then, add your company’s or client’s logo by going to ‘Insert’ (top navigation bar), and then selecting ‘Image’. Upload the logo, resize it and place it in the top-left corner. Right-click on it and select ‘Make report-level’. The logo will appear on all pages in this report.
    • Replace ‘YourCompanyName’ in the footer with your company name.
    • Update the text field in the top-right corner so that it reflects the month and year from which the data was pulled.
    • Update information on the ‘Summary’ page.
    • If the report includes the ‘Blog’ page, you need to make the following changes: 1) In the section ‘Session by Authors,’ you need to edit the table and change the dimension ‘Brands’ to ‘Authors’, 2) In the section ‘Session by Content Categories,’ you need to edit the table and change the dimension ‘Product Categories’ to ‘Post Categories’ and 3) Select ‘Resources’ in the top navigation bar, and then choose ‘Manage Filters’. You will need to edit ‘Blog Pages’ and ‘Blog as a Starting Point’ filters by clicking the ‘EDIT’ buttons. Replace ‘/google+’ with the name of the directory that the blog posts contain in the URL. For example, if you post a URL that looks like www.example.com/blog/post-name/, enter in the field ‘/blog/’; if it looks like www.example.com/insights/post-name/, enter in the field ‘/insights/’.
  5. Optional improvements
    • Make page names in the top navigation bar clickable by adding links to them.
    • Make titles of pages on a website clickable by creating a calculated field like HYPERLINK(CONCAT(“//mydomain.com”, Page), Page Title).
    • Add any branding that you want (for example, your company logo, contact details, change the theme colours, etc.).
    • Add a Google Analytics tracking code to the report by creating a new Google Analytics account or just a property. Then copy the tracking ID into your Google Data Studio report, under ‘File’ (top navigation bar) > ‘Report Settings’ > ‘Google Analytics Tracking ID’ section. It allows you to analyse how your client uses the report to make it even better.
    • To enable this report to be embedded onto a page go to ‘File’ in the top navigation and select ‘Embed report’, then check the ‘Enable embedding’ checkbox and press the ‘Finished’ button.
  6. Check each page
    • Glance through each page to make sure you are happy with everything. For some sites, a few charts might not show data. Report an issue on GitHub, and I will try to help you out.
  7. Share the report
    • To share a link to the report with your client or your team, click on an icon of a person with the plus sign beside it in the top right-hand corner. Enter an email of a person that you would like to send an invitation to see this report. In the drop-down field on the right-hand side, select whether you would like to give that person an editor only viewer permission.
    • To save the report as a PDF and send a static version of it to the customer, go to ‘File’ (top navigation bar), select ‘Download as’ and select ‘PDF’.
  8. Navigate the report
    • To go to the next page use links in the top navigation or the “right” and “left” arrow on your keyboard.
  9. Using the report
    • In the ‘View’ mode, you can drill down into data shown in some charts, by right-clicking on it and selecting a ‘Drill down’ option. You can also drill down into a value specific value in charts, for example, traffic by hour on specific data of the week. To do it, select a value in a chart you would like to investigate in the chart, then by right-clicking on it and selecting a ‘Drill down’ option.
    • From version 1.3, you can click on data in all charts and most tables to show only data on this page that relate to the specific data

An Open-Source License

License: MIT license

If you are interested in making this Google Data Studio report template event better, feel free to contact me. It will be great to join forces with you on this amazing journey to help everyone easily prepare an interactive report template that shows the performance of any website.

Work in Progress

Version 1.4

Google Analytics (Basic pages, Blog, Goals, Ecommerce) & Google Ads & Google Search Console - designed for any website that uses Google Analytics, has a blog, Goals and Enhanced Ecommerce set up in Google Analytics, uses Google Ads to promote this website online and has Google Search Console account set up.

Changelog:

Contributing

Thank you for thinking about contributing to the Interactive Website Performance Report Template project! If you’re unsure of anything, know that you’re welcome to submit an issue or pull request on any topic. We appreciate any sort of contribution and don’t want a wall of rules to get in the way of that.

Google Data Studio Courses

  1. Free:

Helpful Resources

Credits

This report template couldn’t be prepared without amazing people who experimented with Google Data Studio previously and shared their work and knowledge with the community. I would like to thank all of them for doing so and inspiring the creation of this report by listing them below.

Google Analytics Reports

Multiple pages

Overview

SEO

Website Goals and page descriptions

Page Speed

AMP

Engagement

Acquisition

Behaviour

Ecommerce

Technology

Content

Conversion Funnel

Audience

A/B Tests

Google Search Console Reports

Social Media Reports

Cloudflare Report

Error Report

Glossary Page

A Guide to Designing a Report

Collections of Google Data Studio Report Templates

Other

Google Data Studio Bugs

Here is a list of bugs discovered when creating this report template. Hopefully, the Google Data team is going to fix them in the nearest future.

Google Data Studio Feature Requests

Here is a list of features that would make creating and managing reports in Google Data Studio much easier. Hopefully, the Google Data team is going to implement them in the nearest future.