Windsor brings all your Twitter Organic data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, TableauPostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Twitter Organic Field Reference

Sample

 

https://connectors.windsor.ai/twitter_organic?api_key=[your API key]&date_preset=last_7d&fields=tweet_id,text,lang,like_count,date,source&_renderer=csv


Fields

IDTypeNameDescriptionReport
account_idTEXTAccount IDYour Twitter Organic account IDTweet
author_idTEXTAuthor IDUnique identifier of this user. This is returned as a string in order to avoid complications with languages and tools that cannot handle large integers.Tweet
clicksNUMERICClicksNumber of times a user clicks on a URL link or URL preview card in a Tweet organically. Tweet
conversation_idTEXTConversation IDThe Tweet ID of the original Tweet of the conversation (which includes direct replies, replies of replies).Tweet
created_atDATECreated atCreation time of the Tweet.Tweet
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe DateTweet
impression_countNUMERICImpression countNumber of times the Tweet has been viewed organically (not in Ad placement).Tweet
in_reply_to_user_idTEXTIn reply to user idIf this Tweet is a Reply, indicates the user ID of the parent Tweet's author. This is returned as a string in order to avoid complications with languages and tools that cannot handle large integers.Tweet
langTEXTLangLanguage of the Tweet, if detected by Twitter. Returned as a BCP47 language tag.Tweet
like_countNUMERICLike countNumber of likes the Tweet has received organically.Tweet
media_keyTEXTTweet media keyTweet media keyTweet
media_typeTEXTTweet media keyTweet media keyTweet
playback_0_countNUMERICQuartile video views 0The number of users who played through to less than the first quartile in a video from organic contexts. This reflects the number of quartile views across all Tweets in which the given video has been posted.Tweet
playback_100_countNUMERICQuartile video views 100The number of users who played through to fourth quartile in a video from organic contexts. This reflects the number of quartile views across all Tweets in which the given video has been posted.Tweet
playback_25_countNUMERICQuartile video views 25The number of users who played through to first quartile in a video from organic contexts. This reflects the number of quartile views across all Tweets in which the given video has been posted.Tweet
playback_50_countNUMERICQuartile video views 50The number of users who played through to second quartile in a video from organic contexts. This reflects the number of quartile views across all Tweets in which the given video has been posted.Tweet
playback_75_countNUMERICQuartile video views 75The number of users who played through to third quartile in a video from organic contexts. This reflects the number of quartile views across all Tweets in which the given video has been posted.Tweet
reply_countNUMERICReply countNumber of replies the Tweet has received organically.Tweet
reply_settingsTEXTReply settingsShows who can reply to this Tweet. Fields returned are `everyone`, `mentionedUsers`, and `following`.Tweet
retweet_countNUMERICRetweet countNumber of times the Tweet has been Retweeted organically.Tweet
sourceTEXTSourceThe name of the app the user Tweeted from.Tweet
textTEXTTextThe content of the Tweet.Tweet
todayDATETodayToday's date
tweet_idTEXTTweet IDUnique identifier of this Tweet. This is returned as a string in order to avoid complications with languages and tools that cannot handle large integers.Tweet
twitter_handleTEXTTwitter HandleYour Twitter handle linked to your Ad accountTweet
NUMERICUrl link clicksNumber of times a user clicks on a URL link or URL preview card in a Tweet organically. Tweet
user_profile_clicksNUMERICUser profile clicksNumber of times a user clicks the following portions of a Tweet organically - display name, user name, profile picture.Tweet
video_viewsNUMERICVideo viewsA count of how many times the video included in the Tweet has been viewed from organic contexts.Tweet