Listrak Fields

Suggest Edits

Dimensions (27)

Account

NinjaCat System ID: listrak:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Body Html

API Name: bodyHtml

NinjaCat System ID: listrak:DIM_bodyHtml

Data Type: text

Body Text

API Name: bodyText

NinjaCat System ID: listrak:DIM_bodyText

Data Type: text

Campaign

API Name: campaignName

NinjaCat System ID: listrak:DIM_campaign

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Campaign Group

NinjaCat System ID: listrak:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

Currency

NinjaCat System ID: listrak:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: listrak:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date Sent

API Name: sendDate

NinjaCat System ID: listrak:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: listrak:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: listrak:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

External Id

NinjaCat System ID: listrak:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

From Email

API Name: fromEmail

NinjaCat System ID: listrak:DIM_fromEmail

Data Type: text

From Name

API Name: fromName

NinjaCat System ID: listrak:DIM_fromName

Data Type: text

Google Analytics Campaign Content

API Name: googleAnalyticsCampaignContent

NinjaCat System ID: listrak:DIM_googleAnalyticsCampaignContent

Data Type: text

Google Analytics Campaign Name

API Name: googleAnalyticsCampaignName

NinjaCat System ID: listrak:DIM_googleAnalyticsCampaignName

Data Type: text

List Name

API Name: listName

NinjaCat System ID: listrak:DIM_listName

Data Type: text

Message

NinjaCat System ID: listrak:DIM_message

Data Type: text

Display As: listrak_message

Message Subject

API Name: subject

NinjaCat System ID: listrak:DIM_messageSubject

Data Type: text

Month Of Year

NinjaCat System ID: listrak:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: listrak:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Quarter

NinjaCat System ID: listrak:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Reply Email

API Name: replyEmail

NinjaCat System ID: listrak:DIM_replyEmail

Data Type: text

Row

NinjaCat System ID: listrak:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

System Account ID

NinjaCat System ID: listrak:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

To Name

API Name: toName

NinjaCat System ID: listrak:DIM_toName

Data Type: text

Week Of Year

NinjaCat System ID: listrak:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: listrak:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (19)

Average Order

API Name: summary.averageOrderValue

NinjaCat System ID: listrak:MET_averageOrderValue

Data Type: decimal

Display As: currency

Bounces

API Name: summary.bounceCount

NinjaCat System ID: listrak:MET_bounceCount

Data Type: integer

Click %

NinjaCat System ID: listrak:MET_Click_PCT

Data Type: decimal

Display As: percent

Formula: (listrak:MET_clickCount / listrak:MET_Delivered)

Clicks

API Name: summary.clickCount

NinjaCat System ID: listrak:MET_clickCount

Data Type: integer

Aggregates To: MET_CLICKS

Conversion Rate

NinjaCat System ID: listrak:MET_Conversion_Rate

Data Type: decimal

Display As: percent

Formula: (listrak:MET_conversionCount / listrak:MET_visitCount)

Conversions

API Name: summary.conversionCount

NinjaCat System ID: listrak:MET_conversionCount

Data Type: integer

Count (Unique Dimensions)

NinjaCat System ID: listrak:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

CTOR

NinjaCat System ID: listrak:MET_CTOR

Data Type: decimal

Display As: percent

Formula: (listrak:MET_clickCount / listrak:MET_openCount)

Delivered

NinjaCat System ID: listrak:MET_Delivered

Data Type: integer

Formula: (listrak:MET_sentCount - listrak:MET_bounceCount)

Open %

NinjaCat System ID: listrak:MET_Open_PCT

Data Type: decimal

Display As: percent

Formula: (listrak:MET_openCount / listrak:MET_Delivered)

Opens

API Name: summary.openCount

NinjaCat System ID: listrak:MET_openCount

Data Type: integer

Aggregates To: MET_OPENS

Pass Alongs

API Name: summary.passAlongCount

NinjaCat System ID: listrak:MET_passAlongCount

Data Type: integer

Read %

NinjaCat System ID: listrak:MET_Read_PCT

Data Type: decimal

Display As: percent

Formula: (listrak:MET_readCount / listrak:MET_Delivered)

Reads

API Name: summary.readCount

NinjaCat System ID: listrak:MET_readCount

Data Type: integer

Revenue

API Name: summary.revenue

NinjaCat System ID: listrak:MET_revenue

Data Type: decimal

Display As: currency

Sends

API Name: summary.sentCount

NinjaCat System ID: listrak:MET_sentCount

Data Type: integer

Aggregates To: MET_SENT

Unsubscribe %

NinjaCat System ID: listrak:MET_Unsubscribe_PCT

Data Type: decimal

Display As: percent

Formula: (listrak:MET_unsubscribeCount / listrak:MET_Delivered)

Unsubscribes

API Name: summary.unsubscribeCount

NinjaCat System ID: listrak:MET_unsubscribeCount

Data Type: integer

Aggregates To: MET_UNSUBSCRIBED

Visits

API Name: summary.visitCount

NinjaCat System ID: listrak:MET_visitCount

Data Type: integer

Updated 6 months ago