• Lesson 1. Getting Started
  • 1.1. Connecting social media Pages
  • 1.2. Account Settings
  • 1.3. Adding new Brands / Competitors
  • 1.4. Inviting Additional Users
  • 1.5. Setting up Economic Value
• Lesson 2. Best practices
  • 2.1. Analysis techniques
  • 2.2. How to evaluate Account Performance
  • 2.3. How to do a Content Health check-up
  • 2.4. How to do a Competitive Analysis
  • 2.5. How to analyze Campaigns
  • 2.6. Google Data Studio reports
• Lesson 3. Using reports
  • 3.1. Metrics
  • 3.2. All Posts
  • 3.3. Top Posts
  • 3.4. Time to Post
  • 3.5. Content Segmentation
  • 3.6. Cross-channel report
  • 3.7. Trend
  • 3.8. Industry Standard

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 (multiple brands, one channel)

Data Source: To use this template export Competitive Metrics report. Sample data source.

Competitive Analysis cross-channel (multiple brands, cross-channel)

Data Source: To use this template export Competitive Cross-channel report. Sample data source.

---

Content Analytics (one brand, one channel)

Data Source: To use this template export All Posts report. Sample data source.

Most effective channel + Content Analytics (one brand, cross-channel)

Data Source: To use this template export All Posts export section report. Sample data source.

---

Most effective social media channel #1 (one brand, cross-channel)

Data Source: To use this template export Metrics report. Sample data source.

Most effective social media channel #2 (one brand, cross-channel)

Data Source: To use this template export Metrics report. Sample data source.

---

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
• All Posts report
• Competitors Metrics and Cross Channel reports

Metrics report

Data from Metrics report

All Posts report

Data from All Posts report

Competitors Metric and Cross Channel reports

Data from Competitors Metrics report

---

• ← Previous Lesson
• Next Lesson →