Twitter Organic: Tweets

Description

• Each record represents the daily performance of a tweet.

Supported Data Sources

• Twitter Organic

Columns

Type	Name	Description
DATETIME	date_day	Date of the report
INTEGER	organic_tweet_id	The unique ID of the tweet
DATETIME	created_timestamp	Date and time when the tweet was created
STRING	tweet_text	The full text of the tweet
STRING	account_id	ID of the associated account in Twitter
STRING	post_url	URL of the tweet
STRING	account_name	Name of the account in Twitter
INTEGER	user_id	The ID of the user in Twitter
STRING	user_name	The name of the user
STRING	source_relation	The source of the record, if the unioning functionality is being used.
INTEGER	app_clicks	Number of clicks on app install campaigns
INTEGER	card_engagements	Number of engagements on cards
INTEGER	carousel_swipes	Number of swipes on carousels
INTEGER	clicks	Number of clicks on tweet
INTEGER	engagements	Number of engagements on tweet
INTEGER	follows	Number of follows as a result of the tweet
INTEGER	impressions	Number of impressions on tweet
INTEGER	likes	Number of likes on tweet
INTEGER	poll_card_vote	Number of votes on poll cards
INTEGER	qualified_impressions	Number of qualified impressions on tweet
INTEGER	replies	Number of replies on tweet
INTEGER	retweets	Number of retweets on tweet
INTEGER	unfollows	Number of unfollows as a result of the tweet
INTEGER	url_clicks	Number of clicks on URLs in tweet
INTEGER	video_15_s_views	Number of 15-second views on video
INTEGER	video_3_s_100_pct_views	Total number of views where at least 3 seconds were played while 100% in view.
INTEGER	video_6_s_views	Number of 6-second views on video
INTEGER	video_content_starts	Number of times the video content started
INTEGER	video_cta_clicks	Number of clicks on tweet call-to-actions
INTEGER	video_total_views	Total number of views on video
INTEGER	video_views_100	Total number of views where at least 100% of the video was viewed.
INTEGER	video_views_25	Total number of views where at least 25% of the video was viewed.
INTEGER	video_views_50	Total number of views where at least 50% of the video was viewed.
INTEGER	video_views_75	Total number of views where at least 75% of the video was viewed.