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.
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:
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:
Data from Metrics report
Data from All Posts report
Data from Competitors Metrics report