Talroo Fields

Dimensions (17)

Account

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

Campaign Group

NinjaCat System ID: talroo:DIM_CampaignGroup
Data Type: text
Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign ID

API Name: campaignId
NinjaCat System ID: talroo:DIM_campaignId
Data Type: text
Aggregates To: DIM_CAMPAIGN_ID

Campaign Name

API Name: campaignName
NinjaCat System ID: talroo:DIM_name
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Currency

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

Data Source

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

Date

API Name: clickDate
NinjaCat System ID: talroo:DIM_clickDate
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

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

Day Of Week

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

External Id

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

Month Of Year

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

Network

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

Quarter

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

Row

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

System Account ID

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

Week Of Year

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

Year

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

Metrics (6)

Clicks

API Name: clicks
NinjaCat System ID: talroo:MET_clicks
Data Type: integer
Aggregates To: MET_CLICKS

Conversions 1

API Name: conversions1
NinjaCat System ID: talroo:MET_conversions1
Data Type: integer

Conversions 2

API Name: conversions2
NinjaCat System ID: talroo:MET_conversions2
Data Type: integer

Conversions 3

API Name: conversions3
NinjaCat System ID: talroo:MET_conversions3
Data Type: integer

Count (Unique Dimensions)

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

Spend

API Name: spendCents
NinjaCat System ID: talroo:MET_spendCents
Data Type: decimal
Display As: currency
Aggregates To: MET_COST