Site Impact Fields

Suggest Edits

Dimensions (31)

Account

NinjaCat System ID: site_impact:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Associated User

API Name: Associated_x0020_User

NinjaCat System ID: site_impact:DIM_Associated_x0020_User

Data Type: text

Browser

API Name: Browser

NinjaCat System ID: site_impact:DIM_Browser

Data Type: text

Campaign Group

NinjaCat System ID: site_impact:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign ID

API Name: Campaign_x0020_ID

NinjaCat System ID: site_impact:DIM_Campaign_x0020_ID

Data Type: text

Campaign Name

API Name: Campaign_x0020_Name

NinjaCat System ID: site_impact:DIM_Campaign_x0020_Name

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Currency

NinjaCat System ID: site_impact:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Custom Field 1

API Name: CustomField1

NinjaCat System ID: site_impact:DIM_CustomField1

Data Type: text

Custom Field 2

API Name: CustomField2

NinjaCat System ID: site_impact:DIM_CustomField2

Data Type: text

Custom Field 3

API Name: CustomField3

NinjaCat System ID: site_impact:DIM_CustomField3

Data Type: text

Custom Field 4

API Name: CustomField4

NinjaCat System ID: site_impact:DIM_CustomField4

Data Type: text

Custom Field 5

API Name: CustomField5

NinjaCat System ID: site_impact:DIM_CustomField5

Data Type: text

Custom Field 6

API Name: CustomField6

NinjaCat System ID: site_impact:DIM_CustomField6

Data Type: text

Custom Field 7

API Name: CustomField7

NinjaCat System ID: site_impact:DIM_CustomField7

Data Type: text

Custom Field 8

API Name: CustomField8

NinjaCat System ID: site_impact:DIM_CustomField8

Data Type: text

Custom Field 9

API Name: CustomField9

NinjaCat System ID: site_impact:DIM_CustomField9

Data Type: text

Data Source

NinjaCat System ID: site_impact:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: Broadcast_x0020_Date

NinjaCat System ID: site_impact:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: site_impact:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: site_impact:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

Device

API Name: Device

NinjaCat System ID: site_impact:DIM_Device

Data Type: text

Aggregates To: DIM_DEVICE_TYPE

External Id

NinjaCat System ID: site_impact:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Link ID

API Name: LinkId

NinjaCat System ID: site_impact:DIM_LinkId

Data Type: text

Month Of Year

NinjaCat System ID: site_impact:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: site_impact:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Quarter

NinjaCat System ID: site_impact:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: site_impact:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

System Account ID

NinjaCat System ID: site_impact:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

URL

API Name: Link

NinjaCat System ID: site_impact:DIM_Link

Data Type: text

Week Of Year

NinjaCat System ID: site_impact:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: site_impact:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (7)

Click %

NinjaCat System ID: site_impact:MET_ClickRate

Data Type: decimal

Display As: percent

Formula: (site_impact:MET_Clicks / site_impact:MET_List_x0020_Size)

Clicks

API Name: Clicks

NinjaCat System ID: site_impact:MET_Clicks

Data Type: integer

Aggregates To: MET_CLICKS

Clicks / Opens

NinjaCat System ID: site_impact:MET_ClickToOpens

Data Type: decimal

Display As: percent

Formula: (site_impact:MET_Clicks / site_impact:MET_Opens)

Count (Unique Dimensions)

NinjaCat System ID: site_impact:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

List Size

API Name: List_x0020_Size

NinjaCat System ID: site_impact:MET_List_x0020_Size

Data Type: integer

Open %

NinjaCat System ID: site_impact:MET_OpenRate

Data Type: decimal

Display As: percent

Formula: (site_impact:MET_Opens / site_impact:MET_List_x0020_Size)

Opens

API Name: Opens

NinjaCat System ID: site_impact:MET_Opens

Data Type: integer

Aggregates To: MET_OPENS

Updated 6 months ago