How to connect Twitter and Twitter Ads to DashThis via CSV or Google Sheet

 

Twitter has recently shut down our access to their API, along with many other companies in our industry. Unfortunately, this means that DashThis cannot natively pull data from Twitter and display it in your widgets for the time being. We apologize for any inconvenience this situation may cause on your side. We understand how disruptive it can be to have an unexpected change like this. Nevertheless, we want to keep you updated about the situation and provide alternative options to help you continue reporting on your most important KPIs. Our official announcement may be found HERE.



The first option is via our CSV preset template available under our CSV feature.

Important: This option is only available with Twitter. 



Screenshot 2023-04-25 at 3.00.10 PM

This method only takes 5 easy steps:

  1. Download your Twitter Analytics data
    1. Go to your Twitter Page, and go to the Twitter Analytics “Tweets” section.
    2. While looking at your tweets results, select the time frame you wish to export your data.
    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.
  2. Get your CSV file ready
    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.
  3. Import your CSV data into DashThis
    1. Go to your CSV Files Manager and select the new Twitter Analytics template.
    2. Upload your CSV file in this template.
    3. At this stage, if any error is displayed during the upload, please read our Help Center article to identify the source of your error.

  4. Create a new dashboard with Twitter 
    1. Click on + New dashboard at the top left-hand corner

      Screenshot 2023-04-25 at 3.08.25 PM

    2. Select the CSV integration in the list.
    3. Select the Twitter Analytics CSV Template.
    4. Click on ADD it now
    5. 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
    6. Add your CSV data source to your dashboard and finish the creation process.

  5. Create widgets and display data
    1. Go into 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 into your widgets.

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

 



The second option is via Google Sheets! This is a great tool to use when you want to add your own custom data to your dashboards or to display data from integrations that may not be supported yet by DashThis like for example Twitter Insights and Twitter Ads. Please note that there are some requirements and specifications in order to successfully add your Google Sheet to DashThis.

For more on how to use this method, please visit our dedicated help article on How to create a dashboard with Google Sheets. 

 




For Twitter Ads, we recommend that you import your data via CSV or Google Sheets.

 


 





If you have any questions about Twitter or Twitter Ads, please contact our Support Team