Questions? Feedback? powered by Olark live chat software

Union Metrics Help

Have questions? We've got answers!

Understanding the Tracker CSV Export

All Trackers can be exported into CSV spreadsheets. To download a spreadsheet of your collected tweet data, click on the “Export” button in the top right corner of your Tracker.

Screen_Shot_2017-07-03_at_2_14_30_PM.png

Clicking the “Export” button will generate a spreadsheet for the date range you are currently viewing in your Tracker. You can isolate a specific date or range of dates using the calendar dropdown in your left nav, then click the export button to get a spreadsheet of data for that specific time frame.  You will see the date range to be exported before generating your spreadsheet. 

export-options.gif

You can export a .csv file you can open using any Excel-type program by selecting the "Analytics export".  A "Tailored audience export" generates a report you can upload to Twitter for targeted marketing campaigns.  More information about tailored audience exports can be found here. You can select which sets of Tracker data to export by checking or unchecking the summary, trends, tweets, and contributors checkboxes.  Suite customers also can export full sentiment and language reports. Once processed, your spreadsheet will be listed along with all other previous exports. 

You can also export CSV files of all hashtags or URLS in a Tracker. Click the list icon next to the Top Hashtags or Top URLs section of your Tracker, then click the “export” button in the top right corner to get a spreadsheet of all URLs, including the number of tweets, retweets, impressions, and contributors.

Summary: These are the top-level numbers you see at the top of your Tracker.

  • Reach: This is the reach calculated based on all tweets included in this spreadsheet. 
  • Exposure: This is the total number of impressions generated by tweets in this spreadsheet.
  • Tweets: The number of tweets in this report.
  • Contributors: The number of unique accounts which have contributed a tweet.  
  • Tweet_Type: This is a breakdown of the kind of tweets collected. Of the total number of tweets collected, the tweet_type counts indicate how many of these tweets are regular tweets (they were composed by the sender), replies, or retweets.  

Trends: This section breaks down the summary analytics by day.  If you isolate a specific day to export, the summary will be hour-by-hour. 

  • Period: The specific day or hour this row addresses.
  • Reach: The reach calculation for just this day or hour.
  • Exposure: The total number of impressions.
  • Tweets: The number of tweets collected.
  • Contributors: The number of unique accounts which tweeted.

 Tweets: The rows in this section list each tweet collected by the Tracker and include the following data:

  • Id: The Twitter identification number of this specific tweet.
  • Screen_Name: The @account name of the account that sent the tweet.
  • Text: The text of the tweet.
  • Time: The timestamp of when this tweet was sent, in UTC.
  • Type: This tweet can be a regular tweet, a retweet, or a reply.
  • Retweeted_Id: If this tweet is a retweet, the id number of the tweet that is retweeted is listed here.
  • Retweeted_Screen_Name: if this tweet is a retweet, the @account name of the account that is retweeted will be listed here.
  • Reply_To_Id: If this tweet is a reply, the id number of the tweet that is being replied to is listed here.  
  • Reply_To_Screen_Name: If this tweet is a reply, the account that is being replied to is listed here.
  • Deliveries: This is the initial number of accounts to which a tweet is delivered.  This is equivalent to the follower count of this account at the time of sending this tweet.
  • Total_Impressions: The total number of impressions earned, including impressions from retweets and replies.
  • Retweets: The number of retweets this tweet received.
  • Retweet_Impressions: The number of impressions retweets of this tweet have generated.
  • Replies: The number of replies this tweet received.
  • Reply_Impressions: The number of impressions replies from this tweet have generated.
  • Tweet_URL: A URL directly to this tweet.
  • User_URL: A URL directly to the account which has sent this tweet.  
  • User_Bio_Location: The location this account has listed as their home. 
  • Actual_Impressions: If this is an authenticated account Tracker, the number of physical views a tweet has received on Twitter. 
  • Total_Engagements: If this is an authenticated account Tracker, the total number of physical clicks or engagements a tweet has received. 
  • Likes: If this is an authenticated account Tracker, the number of likes a tweet received. 

Contributors: This section lists all accounts which have been collected in your Tracker

  • Screen_Name: The @username of the account.
  • Tweets: The number of tweets collected from this account.
  • Impressions: The total number of impressions counted from this accounts tweets.
  • Retweets: The number of retweets of this account collected.
  • RT_Rate: This is the number of retweets received per tweet sent.  (retweets/tweets)
  • Total_Exposure: The number of impressions a tweet earned including impressions from the original tweet, all replies, and all retweets.
  • Amplification_Multiplier: How far that contributor's tweets spread due to the impressions generated by retweets and replies. This is defined as ((total exposure - impressions) / impressions) 
  • User_URL: A URL directly to the @account.
  • Id: Twitter's user ID for this account.
  • profile_name: The user's profile name. 
  • profile_verified: If this account has been verified by Twitter. 
  • profile_description: The bio/description information entered by the user.  
  • profile_url: The URL a user has listed as their website. 
  • profile_created_at: The date this Twitter account was created.
  • profile_language: The language setting of this user. 
  • profile_location: The location this account has listed as their home.
  • profile_time_zone: The local time-zone of this Twitter account.
  • profile_tweet_count: The total number of tweets this account has ever sent. 
  • profile_follower_count: The number of followers of this account. 
  • profile_following_count: The number of accounts this Twitter account follows. 
  • profile_likes_count: The total number of likes this account has ever received.
  • profile_listed_count: The number of Twitter lists on which this account appears. 

Languages:  This is a breakdown of the language of each tweet collected.

  • Languages: The primary language of a tweet.
  • Tweets: The number of tweets determined to be of this language. 
  • Retweets: The number of retweets determined to be of this language. 
  • Replies: The number of replies determined to be of this language. 
  • Dir. Impressions: The number of impressions created by these tweets. 
  • Amp. Impressions: The total number of impressions generated by these tweets, including from replies and retweets. 

Sentiment: This is a breakdown of your Tracker's sentiment analysis. 

  • Average_Rollup_Score: The average of the daily sentiment score (listed below) for the timeframe this export covers.
  • Average_Sentiment_Score: More granular than the rollup score, this is the average of every sentiment score taken in this report. 
  • Previous_Average_Sentiment_Score: This is the average sentiment score of the time-frame previous to this export.  For example: if this export covers June, the previous_average_sentiment_score would be for tweets analyzed in May. 
  • Sentiment over time: This table would show 
    • Period: The day or hour this row analyzes. Note some hours will be blank if no tweets of discernible sentiment were analyzed.  
    • Average_Sentiment_Score: The average score of tweet sentiment.
    • Sentiment_Percentage_Very_Negative: The percent of tweets analyzed that were deemed very negative.
    • Sentiment_Percentage_Negative: The percent of tweets analyzed that were deemed negative.
    • Sentiment_Percentage_Neutral: Tweets with neither a positive nor negative sentiment. 
    • Sentiment_Percentage_Positive:  The percent of tweets analyzed that were deemed positive.
    • Sentiment_Percentage_Very_Positive:  The percent of tweets analyzed that were deemed very positive. 
  • Sentiment by topic:  a list of the major topics that are skewing positive or negative in your Tracker.
    • Topic: The topic of discussion.
    • Type: The topic can be a username, a hashtag, or a URL.
    • Tweet_Count: The number of tweets about this topic.
    • Average_Sentiment_Score: The average sentiment score of tweets about this topic.
  • Sentiment tweets: This is a list of notable tweets which have been analyzed for sentiment.  You'll notice the far right column ranks these tweets from very_negative to very_positive.

CSV FAQs

Can I download a CSV of just a specific day or time frame?

Absolutely! Just pick the dates you want to isolate in your Tracker and then click the “export” button. This will allow you to print a CSV spreadsheet of just tweets from this time period.  

I added up the total_impressions column and it is much higher than the reported exposure for the Tracker.

Make sure to use the deliveries column when summing impressions, and not the total_impressions column. The deliveries column tells us the number of impressions a tweet generated directly (i.e. this would be the follower count of the account tweeting) and the total_impressions column includes additional impressions that a tweet would have gained from retweets. Since this spreadsheet lists all tweets and also their retweets on individual lines, there is some duplication in the total_impressions column, as impressions for a retweet would appear on the row for the retweet itself, as well as in the total_impressions number for the original tweet that has been retweeted. 

How do I get a CSV of one specific user’s tweets?

You can gather all tweets for an account, or any other search term from a Tracker using the Tracker's search bar. Enter the term you would like to search for, and the search results page will include an "Export" link which will allow you to generate a spreadsheet of all tweets that contain this term.  

Can I get a CSV of all tweets for a specific search term?

Yes! Use your Tracker’s search box (located at the top of the tweets section) to search for any term. The search results page will have an “Export” button in the top right

Curious? See our sample CSV attached! 

Have more questions? Submit a request

Comments