How to connect Twitter Analytics data into DashThis using CSV import?

By using the CSV import feature in DashThis, you can easily add your Twitter Analytics data into your dashboards with minimum manual work.

1- Download your Twitter Analytics data

2- Get your CSV file ready

3- Import your CSV data into DashThis

4- Create Twitter Analytics widget

5- Display aggregated data

 

1- Download your Twitter Analytics data

 

  1. Go to your Twitter Page, and go in the Twitter Analytics “Tweets” section.
  2. While looking at your tweets results, select the time frame you wish to export your data from.



  3. Export your data in CSV by choosing the “By Tweet” export type.



  4. Open your CSV file in a Google Sheet file. It will make the file formatting easier.

 

Here's an example of the file you should end up with.

 

2- Get your CSV file ready to use in DashThis

 

  1. Insert a new row on top of your file and enter your Customer ID.
    The Customer ID is used to identify the right data to display in your dashboard among all of your other CSV files. This is equivalent to the source name in native integrations.
  2. Review each cell of your “tweet text” column and make sure that the content is written on a single line.
    Line breaks will create errors when you try to upload your CSV data in DashThis.
  3. Remove the time written in your “time” column. Your file should only contain the date.
  4. Download your Google Sheet file into a CSV file on your computer.



Note: Your file now contains all the required information to display the data of each of your tweet. If you want to display the accurate aggregated data for all your tweets (especially for the % KPIs), go to this section.

 

3- Import your CSV data into DashThis

 

  1. Go in your CSV Files Manager and select the new Twitter Analytics template.
  2. Upload your CSV file in this template.

    Screen Shot 2021-08-17 at 3.16.09 PM

    At this stage, if any error is displayed during the upload, please read our Help Center article to identify the source of your error.

  3. Create a new dashboard in order to add your Twitter CSV data.
    1. Select the CSV integration in the list.
    2. Select the Twitter Analytics CSV Template.

      Screen Shot 2021-08-17 at 3.18.30 PM

    3. There, click on “Add it now!” to add your Twitter Analytics CSV data.
    1. Identify your CSV data source by giving it a name (i.e. Client ABC), and entering the exact same Customer ID you wrote earlier in your file to filter the right data.
      The Customer ID field is case-sensitive.

      Screen Shot 2021-08-17 at 3.18.37 PM

    2. Add your CSV data source in your dashboard and finish the creation process.

 

4- Create widgets with your Twitter Analytics CSV data

 

  1. Go in your dashboard and create widgets as you would do for any other integration.
  2. You will notice that your widgets are empty. This is normal. You need to complete the next step in order to see the data.
  3. Go back to the CSV Files Manager; select the Twitter Analytics CSV template; and click on “Resend” to push the data in your widgets.



    ** Note that if you add a new widget, you’ll have to hit Resend again **



5- Display the aggregated data of your Twitter tweets 

 

  1. Go back to your Google Sheets file. Here's an example of the file you should end up with.
  2. Add a Total line in your file with the same time period. 
    1. Under your dimensions columns, write TOTAL (i.e. tweet id, tweet text, tweet permalink, etc.).
      This will allow you to filter out the data when creating your widget in order to just display the aggregated data.
    2. Under your metrics columns, make your calculations in order to display accurate data (i.e. Total for the Impressions metric would be a Sum ; Total for the Engagement Rate metric would be Total Engagement divided by Total Impressions ; etc.)
  3. Follow the next steps.
  4. When creating a widget for an aggregated value (i.e. Engagement Rate), you must filter out your data to only show what is on the Total line.

 

 

If you need any help with one of those steps, you can contact us.