To set it up, you'll also want to copy these three 'Data Sources', which read your BigQuery tables:
- WQA Actions Count (reads the actions_count_data_studio table)
- WQA Actions (reads the actions_data_studio table)
- WQA Activity (reads the action_page_type_updates table.
- WQA Traffic Data (reads the agg_traffic table)
Read on for a detailed walkthrough, and happy chef'ing.
The goal of the Website Quality Audit's Data Studio report is to highlight:
1) What's new in a given month, in terms of action recommendations or content changes
2) What actions you're actively working on, or choosing not to work on
3) Your pulse of updates - how are actions moving through your pipeline?
The Data Studio report is not an exhaustive analytics report - it's a summary of what you + your team could be focusing on.
For actually taking action on your audit's recommendations, you'll want to use the Sheets workbook.
The Data Studio report is broken down into 4 pages out of the box. It uses filter on click heavily, so generally selecting a row on a table will filter the rest of the page for that segment.
It's your template to modify as needed - feel free to copy the template and hack it to your heart's content:
Page 1: Monthly Summary
Provides an overall look at the site’s traffic + conversions progress month-over-month.
Summarizes current statuses of action recommendations by site, and allows you to drill into specific actions by URL.
Page 2: Content Review
Displays month-over-month changes on the site across a few buckets:
- New pages
- Rising vs Falling Pages (high performers vs low performers)
- Meta description / title changes
- New top 20 keywords / backlinks
Page 3: Actions Review
Allows you to dive deep into action recommendations, to identify what you may want to work on.
You can segment actions by action type: technical, on-page, off-page, or architectural (aka internal linking) or priority (low / medium / high).
You can also segment by action status:
- Updated: action recommendation has changed since first review
- To schedule
- Final review: action recommendation has been recognized as fixed
- Not relevant: action not to be worked
The detail table at the bottom of the page displays specific URLs where a given action type / action is recommended.
Page 4: Activity Summary
Tells you how many actions / page types have been updated by your team in a given period.
Helpful to keep an eye on how tasks are moving through your work pipeline, and to identify any task buckets that are getting stale.
Copying the Data Studio Report Template
First, Copying the Data Sources
To copy the Data Studio report for this Recipe, first you'll want to copy the 4 data sources below + connect them to the appropriate table in your BigQuery warehouse.
Each data source is linked to from its header below. Once they're configured, you'll be ready to copy the report template.
Please reference this doc if you're not exactly sure how to copy a Data Studio data source.
Reads the actions_count_data_studio table.
Reads the actions_data_studio table.
Reads the action_page_type_updates table.
Reads the agg_traffic table.
Note that most teams only set these data source up once per Recipe, since each BigQuery table contains all of your sites' data. You can filter data for a single site at the report level.
Copying the Report Template
Once your data sources are set up in Data Studio, you're ready to copy the report template (direct link here).
If you're unfamiliar with how to copy reports in Data Studio, please check out this walkthrough video.
The report template by default contains data for *all* of your sites within a BigQuery project, so that you can toggle easily between sites.
If you would like to filter a report copy to display data from a *single* site (for example, to share with a client), you can set a filter on the report settings (File -> Report Settings).
Customizing your Data Studio Reporting
From the WQA, your BigQuery warehouse is now populated with crawl data from Deepcrawl, Google Analytics traffic + conversions, and Google Search Console keywords.
The data is yours for you to use however you see fit, which includes building your own Data Studio reporting.
Common reports folks have built in the past:
- Keyword reporting using GSC data
- Blended GA + GSC reporting
- Crawl summary reporting
To get ideas flowing, check out the BigQuery data summary, which contains notes on key BigQuery tables that you may want to build reporting around.