Guides
Shape Help Center

Grade Us Fields

Suggest Edits

Dimensions (29)

Account

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

Category

API Name: category
NinjaCat System ID: grade_us:DIM_category
Data Type: text

Currency

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

Data Source

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

date

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

Day Of Month

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

Day Of Week

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

Email Address

API Name: email_address
NinjaCat System ID: grade_us:DIM_email_address
Data Type: text

External Id

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

Full Name

API Name: fullname
NinjaCat System ID: grade_us:DIM_fullname
Data Type: text

ID

API Name: id
NinjaCat System ID: grade_us:DIM_id
Data Type: text

Image URL

API Name: image_url
NinjaCat System ID: grade_us:DIM_image_url
Data Type: text

IP Address

API Name: ip_address
NinjaCat System ID: grade_us:DIM_ip_address
Data Type: text

Is Claimed

API Name: is_claimed
NinjaCat System ID: grade_us:DIM_is_claimed
Data Type: text

Is Closed

API Name: is_closed
NinjaCat System ID: grade_us:DIM_is_closed
Data Type: text

Is Listed

API Name: is_listed
NinjaCat System ID: grade_us:DIM_is_listed
Data Type: text

Is Monitored

API Name: is_monitored
NinjaCat System ID: grade_us:DIM_is_monitored
Data Type: text

Is Streamed

API Name: streamed
NinjaCat System ID: grade_us:DIM_streamed
Data Type: text

Is Verified

API Name: is_verified
NinjaCat System ID: grade_us:DIM_is_verified
Data Type: text

Month Of Year

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

Network

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

Response Notes

API Name: response_notes
NinjaCat System ID: grade_us:DIM_response_notes
Data Type: text

Response Status

API Name: response_status
NinjaCat System ID: grade_us:DIM_response_status
Data Type: text

Row

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

Snippet

API Name: snippet
NinjaCat System ID: grade_us:DIM_snippet
Data Type: text

System Account ID

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

URL

API Name: url
NinjaCat System ID: grade_us:DIM_url
Data Type: text

Week Of Year

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

Year

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

Metrics (6)

Aggregate Rating

API Name: aggregate_rating
NinjaCat System ID: grade_us:MET_aggregate_rating
Data Type: decimal
Display As: float

Check-ins Count

API Name: checkins_count
NinjaCat System ID: grade_us:MET_checkins_count
Data Type: integer

Count

API Name: count
NinjaCat System ID: grade_us:MET_count
Data Type: integer
Aggregates To: MET_COUNT

Count (Unique Dimensions)

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

Review Rating

API Name: rating
NinjaCat System ID: grade_us:MET_rating
Data Type: decimal
Display As: float

Reviews Count

API Name: reviews_count
NinjaCat System ID: grade_us:MET_reviews_count
Data Type: integer

Updated 6 months ago