Advice Local Fields

Suggest Edits

Dimensions (16)

Account

NinjaCat System ID: advice_local:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Address

API Name: address

NinjaCat System ID: advice_local:DIM_address

Data Type: text

Channel

API Name: channel

NinjaCat System ID: advice_local:DIM_channel

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

City

API Name: city

NinjaCat System ID: advice_local:DIM_city

Data Type: text

Aggregates To: DIM_CITY

Country

API Name: country

NinjaCat System ID: advice_local:DIM_country

Data Type: text

Display As: country

Aggregates To: DIM_COUNTRIES,DIM_COUNTRY

Currency

NinjaCat System ID: advice_local:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: advice_local:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

External Id

NinjaCat System ID: advice_local:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Name

API Name: name

NinjaCat System ID: advice_local:DIM_name

Data Type: text

Phone

API Name: phone

NinjaCat System ID: advice_local:DIM_phone

Data Type: text

Row

NinjaCat System ID: advice_local:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

State

API Name: state

NinjaCat System ID: advice_local:DIM_state

Data Type: text

Aggregates To: DIM_STATE_PROVINCE,DIM_STATE

Street

API Name: street

NinjaCat System ID: advice_local:DIM_street

Data Type: text

System Account ID

NinjaCat System ID: advice_local:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Website

API Name: website

NinjaCat System ID: advice_local:DIM_website

Data Type: text

Zipcode

API Name: zipcode

NinjaCat System ID: advice_local:DIM_zipcode

Data Type: text

Aggregates To: DIM_POSTAL_CODE

Metrics (5)

Address Percent

API Name: AddressPercent

NinjaCat System ID: advice_local:MET_AddressPercent

Data Type: decimal

Display As: percent

Count (Unique Dimensions)

NinjaCat System ID: advice_local:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

Name Percentage

API Name: NamePercent

NinjaCat System ID: advice_local:MET_NamePercent

Data Type: decimal

Display As: percent

NAP Score

NinjaCat System ID: advice_local:MET_NAPScore

Data Type: decimal

Display As: float

Formula: (((advice_local:MET_NamePercent + advice_local:MET_AddressPercent + advice_local:MET_PhonePercent) * 100) / 3)

Phone Percent

API Name: PhonePercent

NinjaCat System ID: advice_local:MET_PhonePercent

Data Type: decimal

Display As: percent

Updated 6 months ago