Guides
Shape Help Center

Change History Fields

Suggest Edits

Dimensions (19)

Account

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

Categories

API Name: categories
NinjaCat System ID: change_history:DIM_CATEGORIES
Data Type: text

Created By

API Name: created_by
NinjaCat System ID: change_history:DIM_CREATED_BY
Data Type: text

Currency

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

Data Source

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

Date

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

Day of Month

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

Day of Week

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

Details

API Name: description
NinjaCat System ID: change_history:DIM_DESCRIPTION
Data Type: text

External Id

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

Month of Year

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

Network

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

Private

API Name: is_private
NinjaCat System ID: change_history:DIM_PRIVATE
Data Type: text

Quarter

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

Row

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

Subject Line

API Name: subject
NinjaCat System ID: change_history:DIM_SUBJECT
Data Type: text

System Account ID

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

Week of Year

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

Year

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

Metrics (2)

Count

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

Count (Unique Dimensions)

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

Updated 6 days ago