Lesson 2.6.

Google Data Studio reports


  1. Templates Gallery.
  2. How to Use Templates.

New Try our Chrome plugin for quick export to Google Sheets.

You can export most of the TrueSocialMetrics reports to Google Sheets and import them to Google Data Studio to build beautiful customized visualizations and dashboards.

To make this easier for you we have built several Data Studio templates. Try using them as the basis for your dashboard and customize them along the way.


Templates gallery


Competitive Analysis for social media page - Google Data Studio template

Competitive Analysis

(multiple brands, one channel)

Data Source: To use this template export Competitive Metrics report

Cross-channel Competitive Analysis for social media page - Google Data Studio template

Competitive Analysis cross-channel

(multiple brands, cross-channel)

Data Source: To use this template export Competitive Cross-channel report


Content Analytics for social media page - Google Data Studio template

Content Analytics

(one brand, one channel)

Data Source: To use this template export All Posts report

Most effective social media channel and Content Analytics - Google Data Studio template

Most effective channel + Content Analytics

(one brand, cross-channel)

Data Source: To use this template export Metrics report and All Posts report for one channel


Most effective social media channel report - Google Data Studio template

Most effective social media channel #1

(one brand, cross-channel)

Data Source: To use this template export Metrics report

Most effective social media channel report - Google Data Studio template

Most effective social media channel #2

(one brand, cross-channel)

Data Source: To use this template export Metrics report


How to use templates


Follow the steps below to use these templates with your own data:

  • Step 1. Export data from your TrueSocialMetrics account.
    • Use our Chrome plugin to export with one click.
    • OR export each report manually directly from the report page.
  • Step 2. Open a Google Data Studio template and click 'Use template' button. Popup window will open.
  • Step 3. Add new Data Source to Google Data studio.
    • Click on drop-down selector named 'New Data source'.
    • Click on the link 'Create New Data source'.
    • Select 'Google Sheets' option in 'Connectors' list at the left side of the page.
    • In the list 'Spreadsheet' choose the spreadsheet your exported earlier from TrueSocialMetrics.
    • Click on 'Connect' button at the top rigth corner of the page.
    • Setup field types correctly to make the template work (here's the instruction).

Useful Tip: If you want to refresh data in your Data Studio report:
  1. Copy and paste new data in your connected spreadsheet (or use a Chrome plugin to do that for you).
  2. Then click “Refresh data” button in the top right corner of your Data Studio report in Edit mode.


How to setup field types in data sources


For templates to work it's very important to set up field types for data source correctly, so here's how to do it for each report:


Metrics report

Field type settings for Google Dats Studio source - Metrics report Data from Metrics report


All Posts report

Field type settings for Google Dats Studio source - All Posts report Data from All Posts report


Competitors Metric and Cross Channel reports

Field type settings for Google Dats Studio source - Competitors Metrics report Data from Competitors Metrics report