Review Push Fields

Dimensions (16)

Account

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

Currency

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

Data Source

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

Date

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

Day Of Month

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

Day Of Week

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

External Id

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

Month Of Year

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

Network

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

Quarter

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

Review

API Name: review_text
NinjaCat System ID: review_push:DIM_review_text
Data Type: text

Review Source

API Name: review_source
NinjaCat System ID: review_push:DIM_review_source
Data Type: text

Row

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

System Account ID

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

Week Of Year

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

Year

NinjaCat System ID: review_push:DIM_Year
Data Type: text
Aggregates To: DIM_YEAR

Metrics (7)

Average Rating

NinjaCat System ID: review_push:MET_avg_rating
Data Type: integer
Formula: review_push:MET_rating / review_push:MET_total_reviews

Count (Unique Dimensions)

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

Negative Reviews

API Name: negative_reviews
NinjaCat System ID: review_push:MET_negative_reviews
Data Type: integer

Neutral Reviews

API Name: neutral_reviews
NinjaCat System ID: review_push:MET_neutral_reviews
Data Type: integer

Positive Reviews

API Name: positive_reviews
NinjaCat System ID: review_push:MET_positive_reviews
Data Type: integer

Rating

API Name: rating
NinjaCat System ID: review_push:MET_rating
Data Type: integer
Aggregates To: MET_RATING

Total Reviews

API Name: total_reviews
NinjaCat System ID: review_push:MET_total_reviews
Data Type: integer