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

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

Twitter Ads is not a native integration in DashThis.  But by using the CSV import, and with little effort, you can access the same exact data and display it into your reports.

If you've never used the CSV import feature in DashThis, we recommend you to read this article to learn the basics.

 

1- Download your Twitter Ads data

2- Get your CSV file ready

3- Import your CSV data into DashThis

4- Create Twitter Ads widget

5- Display aggregated data

 

1- Download your Twitter Ads data

 

  1. Go to your Twitter Ads account.
  2. While looking at your campaigns results, select the time frame you wish to export your data from.

  3. Export your data in CSV, and leave the “Total” choice checked.





  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. 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 Twitter Ads campaigns. If you want to display the accurate aggregated data for all your campaigns (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 Ads template.
    2. Upload your CSV file in this template.



      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 Ads CSV Template.

        Screen Shot 2021-08-17 at 2.43.02 PM

      3. There, click on “Add it now!” to add your Twitter Ads 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 2.44.49 PM

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



      4- Create widgets with your Twitter Ads 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 Ads 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 Ads campaigns

       

      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. placement, campaign name, objective, 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 Result Rate metric would be Total Results divided by Total Impressions ; etc.)
      3. Follow the next steps.
      4. When creating a widget for an aggregated value (i.e. Result 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.