Dedoose Articles

Article: Importing and Analyzing Twitter Data with Dedoose!


Dedoose is an amazing tool you can use for analyzing all types of data, and today we will import and do some basic analytics with Twitter data! Check out this step by step guide to import your twitter data!

First, download your twitter archive:

  1. Click the Profile button on the top right
  2. Click Analytics

    How to get to your Twitter Analytics

  3. Click Tweets
  4. Select your range on the top right
  5. Click Export data

    "Click "Export Data" to Export Your Twitter Data"

    Twitter will only let you export 3 months at a time, but you can export these 3 month bundles separately and just join them together in Excel for analysis across a longer span of time! Now that we have those data in Excel we can jump right into Dedoose, however we suggest making a few changes to the file to before importing. First, let’s open that Excel file:

Rename your Tweet IDs. (Note: Our examples have dummy data filled in

  • Tweet ID’s are long and can be hard remember, let’s fix that:
    1. Go to the “Tweet id” column in your Excel file
    2. Rename the first case to “Tweet 1”
    3. Click and hold the bottom right corner of that cell and...
    4. Drag it down the full column until you reach the bottom of your Excel data
    5. You will see it automatically apply step (2) to every row in the column creating a consecutive number identification for the rows

Your column will go from this:

Renaming Confusing Tweet ID's

To this:

Friendlier "Tweet ID's"

Add some dummy cases to the Permalink column (Column C)

  • This will make it easier for you to jump into Twitter and view a specific tweet

    Adding Some Dummy Cases to the Permalink Column

    Delete the promoted content fields (Column W through Column AP) if you do not have any promoted Tweets

  • Unless you have promoted content and would like to analyze that as well, these columns should be deleted as they will contain no data

Convert the engagement rate column (Column G) to percentages

  • This step will make your engagement rates digestible, as having a list of un-rounded decimals can be hard to work with:

  • Insert a column next to Column G

  • Title it “Engagement Rate Percents” or something akin to that

    Title Column H “Engagement Rate Percents”

  • Click in the first blank cell for your newly created column
  • Type the following into it: =ROUNDDOWN(G2*100,1)

    Type the following Newley Created Column: =ROUNDDOWN(G2*100,1)

    NOTE: This is assuming your original engagement rate column is still G, if not then replace G with the appropriate column
  • Hit Enter

    Rounded Engagement Rate Percents

  • You will see a rounded down percentage derived from the first cell in your engagement rate column
  • Click on the cell that has the % value so it is highlighted green
  • Click and hold the bottom right corner of the cell

    Setting up Excel to Display Engagement Rate Percents

  • Drag it down the entire column until you reach the bottom of your Excel sheet
  • You will see it automatically apply step (d) to the entire column

    Engagement Rate Percents Chart

  • Delete any other columns you do not want to include and save the file

Import it into Dedoose!

Now let’s run some basic analysis on your Twitter data, but first click the Analyze tab!

Codes x Descriptor: Find what tweets performed the best.

  1. Click Descriptor Charts
  2. Click Codes x Descriptor
  3. In the Fields drop down menu, select Engagement Rate Percents
  4. You will now be able to see the distribution of codes across your percentages
  5. Which of your tweets got the highest engagement rate?
  6. Select another field, which of your tweets got the most retweets?

In our example below, 7 tweets got engagement rates percentages of 203% - 235% (Don’t worry these are dummy numbers we added)

Tweet Engagement Chart

Clicking on the chart shows us those 7 tweets:

Chart Selection Reviewer Example

Descriptor x Descriptor x Code: Analyzing by multiple metrics.

  1. Click Descriptor Charts
  2. Click Descriptor x Descriptor x Code
  3. Select your fields of interest
  4. For example, how many retweets did you get as your engagement rate grew?

    Descriptor x Descriptor x Code Showing Codes per Tweet

    If you decide to code your data (For example fun vs sharing news or content, @someone vs not @someone, or whatever themes or patterns you can think of!) You will be able to see just how your tweets performed across any lines.Here are a few more charts you can take advantage of if you decide to code your tweets:

Code Application: Have a subset of your tweets you want to see patterns for? Find it here

  1. Click Code Charts
  2. Click Code Application
  3. You will see a distribution of your codes per tweet

    Warmer colors will indicate codes that most often appear together

    Code Co-Occurrence: Find what themes or codes appear most often together in your tweets.

  4. Click Code Charts

  5. Click Code Co-Occurrence
  6. Warmer colors will indicate codes that most often appear together

    Code Co-Occurence Example

    Want more content like this? We are all ears, let us know!