Guides
Shape Help Center
Start typing to search…

Twitter Organic Fields

Dimensions (16)

Account

NinjaCat System ID: twitter_organic:DIM_ACCOUNT
Data Type: text
Aggregates To: DIM_ACCOUNT

Currency

NinjaCat System ID: twitter_organic:DIM_CURRENCY
Data Type: text
Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: twitter_organic:DIM_DATA_SOURCE
Data Type: text
Aggregates To: DIM_DATA_SOURCE

Date

API Name: date
NinjaCat System ID: twitter_organic:DIM_DATE
Data Type: date
Aggregates To: DIM_DATE

Day of Month

NinjaCat System ID: twitter_organic:DIM_DAY_OF_MONTH
Data Type: integer
Aggregates To: DIM_DAY_OF_MONTH

Day of Week

NinjaCat System ID: twitter_organic:DIM_DAY_OF_WEEK
Data Type: text
Display As: day_of_week
Aggregates To: DIM_DAY_OF_WEEK

External Id

NinjaCat System ID: twitter_organic:DIM_EXTERNAL_ID
Data Type: text
Aggregates To: DIM_EXTERNAL_ID

Formatted Tweet

API Name: FormattedTWEET
NinjaCat System ID: twitter_organic:DIM_FORMATTED_TWEET
Data Type: text
Display As: twitter_organic_tweet

Month of Year

NinjaCat System ID: twitter_organic:DIM_MONTH_OF_YEAR
Data Type: text
Display As: date_month_of_year
Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: twitter_organic:DIM_NETWORK
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK

Quarter

NinjaCat System ID: twitter_organic:DIM_QUARTER
Data Type: text
Display As: quarter
Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: twitter_organic:DIM_ROW
Data Type: text
Aggregates To: DIM_ROW

System Account ID

NinjaCat System ID: twitter_organic:DIM_ACCOUNT_ID
Data Type: text
Aggregates To: DIM_ACCOUNT_ID

Tweet

API Name: tweet
NinjaCat System ID: twitter_organic:DIM_TWEET
Data Type: text

Week of Year

NinjaCat System ID: twitter_organic:DIM_WEEK_OF_YEAR
Data Type: text
Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: twitter_organic:DIM_YEAR
Data Type: text
Aggregates To: DIM_YEAR

Metrics (7)

Count (Unique Dimensions)

NinjaCat System ID: twitter_organic:MET_COUNT_NC
Data Type: integer
Aggregates To: MET_COUNT_NC

Followers

API Name: followers_count
NinjaCat System ID: twitter_organic:MET_followers_count
Data Type: integer

Followers Sum

API Name: followers_count
NinjaCat System ID: twitter_organic:MET_followers_count_sum
Data Type: integer

Friends

API Name: friends_count
NinjaCat System ID: twitter_organic:MET_friends_count
Data Type: integer

Likes

API Name: likes
NinjaCat System ID: twitter_organic:MET_likes
Data Type: integer
Aggregates To: MET_LIKES

Retweets

API Name: retweets
NinjaCat System ID: twitter_organic:MET_retweets
Data Type: integer
Aggregates To: MET_RETWEETS

Tweets

API Name: tweets
NinjaCat System ID: twitter_organic:MET_tweets
Data Type: integer

Updated about 5 hours ago