The Issues by Priority connector will show a distribution of onsite optimization issues by priority (high / medium / low / notice).

There are two ways of using this connector, which you must choose when selecting a Report Type setting up the data source.

  • Choosing Trend will return a list of the number of high, medium, low, and notice priority issues for each crawl date.

  • Choosing Comparison will show the number of high, medium, low, and notice priority issues for the most recent crawl, and the amount each has changed since the previous crawl.

If desired, you can create multiple data sources with this connector to use it in both Trend and Comparison modes in the same report.

Link to this connector

https://datastudio.google.com/datasources/create?connectorId=AKfycbz5BF8TXOX7qfCFH2S2UEb0IEnqM3jLGZum_09vkxk

Our favorite visualizations with this connector

Trend chart

Set the Report Type parameter to Trend when creating the data source.

Choose a line chart, then set the Dimension to Date and choose High Priority Issues, Medium Priority Issues, Low Priority Issues, and Notices as Metrics. Sort by Date ascending.

Callouts

Use this visualization to create the outside rectangle with the number of issues.

Set the report type parameter to Comparison when creating the data source.

Create a Scorecard with compact numbers and set the Metric to the issue type of your choice (e.g. High Priority Change or Medium Priority Change).

Change callout

Use this visualization to create the rounded rectangle with the change value in green (if going down) or red (if going up).

Just like above, set the report type parameter to Comparison when creating the data source.

Create a Scorecard with compact numbers and set the Metric to the issue type "Change" of your choice (e.g. High Priority Change or Medium Priority Change).

That will give you the data that you want, but it won't look right yet. Click the "Style" tab, and make the following changes:

  • Set the decimal precision to 0

  • Check "Hide Metric Name"

  • Set the label font size to 14px

  • Set the border radius to 40

  • Create conditional formatting rules as follows:

Did this answer your question?