Simpli.fi Fields

Dimensions (66)

Account

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

Ad

NinjaCat System ID: simplifi:DIM_Ad_Html
Data Type: text
Display As: simplifi_ad

Ad Id

API Name: Ad Id
NinjaCat System ID: simplifi:DIM_ad_id
Data Type: text
Aggregates To: DIM_AD_ID

Ad Image URL

API Name: Ad Image
NinjaCat System ID: simplifi:DIM_ad_image
Data Type: text

Ad Name

API Name: Ad
NinjaCat System ID: simplifi:DIM_ad
Data Type: text
Aggregates To: DIM_AD_NAME

Ad Size

API Name: Ad Size
NinjaCat System ID: simplifi:DIM_adSize
Data Type: text

Ad Target Url

API Name: Ad Target Url
NinjaCat System ID: simplifi:DIM_ad_target_url
Data Type: text

App Name

API Name: App Name
NinjaCat System ID: simplifi:DIM_appName
Data Type: text

App URL

API Name: App URL
NinjaCat System ID: simplifi:DIM_appUrl
Data Type: text

Campaign

API Name: Campaign
NinjaCat System ID: simplifi:DIM_campaign
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Campaign Custom Id

API Name: Campaign Custom Id
NinjaCat System ID: simplifi:DIM_campaign_custom_id
Data Type: text

Campaign Group

API Name: Campaign Group
NinjaCat System ID: simplifi:DIM_campaignGroup
Data Type: text

Campaign Group

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

Campaign Id

API Name: Campaign Id
NinjaCat System ID: simplifi:DIM_campaign_id
Data Type: text
Aggregates To: DIM_CAMPAIGN_ID

Campaign Name

API Name: Campaign Name
NinjaCat System ID: simplifi:DIM_campaignName
Data Type: text

Campaign Status

API Name: Campaign Status
NinjaCat System ID: simplifi:DIM_campaignStatus
Data Type: text
Aggregates To: DIM_CAMPAIGN_STATUS

Campaign Type

API Name: Campaign Campaign Type
NinjaCat System ID: simplifi:DIM_campaignType
Data Type: text
Aggregates To: DIM_CAMPAIGN_TYPE

City

API Name: Geography City
NinjaCat System ID: simplifi:DIM_city
Data Type: text
Aggregates To: DIM_CITY

Client Id

API Name: Client Id
NinjaCat System ID: simplifi:DIM_client_id
Data Type: text

Client Name

API Name: Client Name
NinjaCat System ID: simplifi:DIM_clientName
Data Type: text

Company Id

API Name: Company ID
NinjaCat System ID: simplifi:DIM_companyId
Data Type: text

Company Name

API Name: Company Name
NinjaCat System ID: simplifi:DIM_companyName
Data Type: text

Context

API Name: Context Context Name
NinjaCat System ID: simplifi:DIM_context
Data Type: text

Conversion Geo Fence Id

API Name: Geography Conversion Geo Fence ID
NinjaCat System ID: simplifi:DIM_conversionGeoFenceId
Data Type: text

Conversion Geo Fence Name

API Name: Geography Conversion Geo Fence Name
NinjaCat System ID: simplifi:DIM_conversionGeoFenceName
Data Type: text

Country

API Name: Geography Country
NinjaCat System ID: simplifi:DIM_country
Data Type: text
Display As: country
Aggregates To: DIM_COUNTRIES,DIM_COUNTRY

Currency

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

Daily Estimated Budget

API Name: Campaign Daily Estimated Budget
NinjaCat System ID: simplifi:DIM_dailyEstimatedBudget
Data Type: text

Data Provider

API Name: Companies Segment Data Provider
NinjaCat System ID: simplifi:DIM_dataProvider
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK

Data Source

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

date

API Name: Date
NinjaCat System ID: simplifi:DIM_date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

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

Day Of Week

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

Device Type

API Name: Details Device Name
NinjaCat System ID: simplifi:DIM_deviceType
Data Type: text
Aggregates To: DIM_DEVICE_TYPE

Domain

API Name: Domain
NinjaCat System ID: simplifi:DIM_domain
Data Type: text
Display As: url

Domain Reporting Name

API Name: Domain Reporting Name
NinjaCat System ID: simplifi:DIM_domainReportingName
Data Type: text

End Date

API Name: End Date
NinjaCat System ID: simplifi:DIM_endDate
Data Type: date
Aggregates To: DIM_END_DATE

External Id

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

Geo Fence

API Name: Geo Fence
NinjaCat System ID: simplifi:DIM_geoFence
Data Type: text

Geo Fence Id

API Name: Geography Geo Fence ID
NinjaCat System ID: simplifi:DIM_geoFenceId
Data Type: text

Hour

API Name: Time Event Hour
NinjaCat System ID: simplifi:DIM_hour
Data Type: integer
Aggregates To: DIM_HOUR_OF_DAY

Insights Details Category

API Name: Insights Details Category
NinjaCat System ID: simplifi:DIM_insightsDetailsCategory
Data Type: text

Insights Details Demographic

API Name: Insights Details Demographic
NinjaCat System ID: simplifi:DIM_insightsDetailsDemographic
Data Type: text

IP Address

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Details IP
NinjaCat System ID: simplifi:DIM_ip
Data Type: text

Keyword

API Name: Keyword
NinjaCat System ID: simplifi:DIM_keyword
Data Type: text
Aggregates To: DIM_KEYWORDS

Keyword Src

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Keyword Src
NinjaCat System ID: simplifi:DIM_keywordSrc
Data Type: text

Label

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Label
NinjaCat System ID: simplifi:DIM_label
Data Type: text

Label Src

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Label Src
NinjaCat System ID: simplifi:DIM_labelSrc
Data Type: text

Max Date

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Max Date
NinjaCat System ID: simplifi:DIM_maxDate
Data Type: date

Metro

API Name: Geography Metro
NinjaCat System ID: simplifi:DIM_metro
Data Type: text

Min Date

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Min Date
NinjaCat System ID: simplifi:DIM_minDate
Data Type: date

Month Of Year

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

Platform

API Name: Platform
NinjaCat System ID: simplifi:DIM_Platform
Data Type: text

Platform Id

API Name: Platform ID
NinjaCat System ID: simplifi:DIM_platformId
Data Type: text

Platform Name

API Name: Platform Name
NinjaCat System ID: simplifi:DIM_platformName
Data Type: text

Postal Code

API Name: Geography Postal Code
NinjaCat System ID: simplifi:DIM_postalCode
Data Type: text
Aggregates To: DIM_POSTAL_CODE

Quarter

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

Region

API Name: Geography Region
NinjaCat System ID: simplifi:DIM_region
Data Type: text

Row

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

Segment

API Name: Segment Segment Name
NinjaCat System ID: simplifi:DIM_segment
Data Type: text

Start Date

API Name: Start Date
NinjaCat System ID: simplifi:DIM_startDate
Data Type: date
Aggregates To: DIM_START_DATE

State

API Name: Geography State
NinjaCat System ID: simplifi:DIM_state
Data Type: text
Aggregates To: DIM_STATE_PROVINCE,DIM_STATE

System Account ID

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

Total Budget

API Name: total_budget
NinjaCat System ID: simplifi:DIM_totalBudget
Data Type: decimal
Display As: currency

Week Of Year

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

Year

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

Metrics (83)

100% Complete

API Name: Video Events Complete
NinjaCat System ID: simplifi:MET_Complete100
Data Type: integer
Aggregates To: MET_100%_COMPLETE

25% Complete

API Name: Video Events First Quartile
NinjaCat System ID: simplifi:MET_Complete25
Data Type: integer
Aggregates To: MET_25%_COMPLETE

50% Complete

API Name: Video Events Midpoint
NinjaCat System ID: simplifi:MET_Complete50
Data Type: integer
Aggregates To: MET_50%_COMPLETE

75% Complete

API Name: Video Events Third Quartile
NinjaCat System ID: simplifi:MET_Complete75
Data Type: integer
Aggregates To: MET_75%_COMPLETE

Ad Revenue

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Ad Revenue
NinjaCat System ID: simplifi:MET_adRevenue
Data Type: decimal
Display As: currency

Behavioral Cost

API Name: Behavioral Cost
NinjaCat System ID: simplifi:MET_behavioralCost
Data Type: decimal
Display As: currency

Campaign Conversion Rate

NinjaCat System ID: simplifi:MET_campaignConversionRate
Data Type: decimal
Display As: percent
Formula: (simplifi:MET_campaignConverters / simplifi:MET_campaignUsers)

Campaign Converters

API Name: User Counts Campaign Converters
NinjaCat System ID: simplifi:MET_campaignConverters
Data Type: integer

Campaign Days to Convert

API Name: Day Counts By User Campaign Days to Convert
NinjaCat System ID: simplifi:MET_campaignDaysToConvert
Data Type: decimal
Display As: float

Campaign Days to Convert (Calculated)

NinjaCat System ID: simplifi:MET_calcCampaignDaysToConvert
Data Type: decimal
Display As: float
Formula: (simplifi:MET_TotalDaysToCampConvertHidden / simplifi:MET_campaignConverters)

Campaign Users

API Name: User Counts Campaign Users
NinjaCat System ID: simplifi:MET_campaignUsers
Data Type: integer

Clicks

API Name: Clicks
NinjaCat System ID: simplifi:MET_clicks
Data Type: integer
Aggregates To: MET_CLICKS

Click-through Leads

API Name: Click Leads
NinjaCat System ID: simplifi:MET_clickLeads
Data Type: integer

Click-through Other

API Name: Click Other
NinjaCat System ID: simplifi:MET_clickOther
Data Type: integer

Click-through Sales

API Name: Click Sales
NinjaCat System ID: simplifi:MET_clickSales
Data Type: decimal
Display As: currency

Click-through Signups

API Name: Click Signups
NinjaCat System ID: simplifi:MET_clickSignups
Data Type: integer

Click-through Visits

API Name: Click Visits
NinjaCat System ID: simplifi:MET_clickVisits
Data Type: integer

CompleteRate

NinjaCat System ID: simplifi:MET_CompleteRate
Data Type: decimal
Display As: percent
Formula: (simplifi:MET_Complete100 / simplifi:MET_VideoStarts)

Contextual Cost

API Name: Contextual Cost
NinjaCat System ID: simplifi:MET_contextualCost
Data Type: decimal
Display As: currency

Cost / Conv.

NinjaCat System ID: simplifi:MET_AverageCPA
Data Type: decimal
Display As: currency
Aggregates To: MET_CPA
Formula: (simplifi:MET_totalSpend / simplifi:MET_weightedActions)

Count (Unique Dimensions)

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

CPC

NinjaCat System ID: simplifi:MET_AverageCpc
Data Type: decimal
Display As: currency
Aggregates To: MET_CPC
Formula: (simplifi:MET_totalSpend / simplifi:MET_clicks)

CPM

NinjaCat System ID: simplifi:MET_AverageCpm
Data Type: decimal
Display As: currency
Aggregates To: MET_CPM
Formula: (1000 * simplifi:MET_totalSpend / simplifi:MET_impressions)

CTR

NinjaCat System ID: simplifi:MET_Ctr
Data Type: decimal
Display As: percent
Aggregates To: MET_CTR
Formula: (simplifi:MET_clicks / simplifi:MET_impressions)

Daily Spend Target

API Name: Daily Spend Target
NinjaCat System ID: simplifi:MET_dailySpendTarget
Data Type: decimal
Display As: currency

Demographic Cost

API Name: Demographic Cost
NinjaCat System ID: simplifi:MET_demographicCost
Data Type: decimal
Display As: currency

Frequency

API Name: Frequency
NinjaCat System ID: simplifi:MET_frequency
Data Type: integer

Geo-Conversion Lift

NinjaCat System ID: simplifi:MET_geoConversionLift
Data Type: decimal
Display As: percent
Formula: (((simplifi:MET_campaignConverters / simplifi:MET_campaignUsers) - (simplifi:MET_naturalConverters / simplifi:MET_naturalUsers)) / (simplifi:MET_naturalConverters / simplifi:MET_naturalUsers))

Geofencing Average CPA

NinjaCat System ID: simplifi:MET_geofencingAverageCPA
Data Type: decimal
Display As: currency
Formula: (simplifi:MET_geofencingTotalSpend / simplifi:MET_geofencingWeightedActions)

Geofencing Average CPC

NinjaCat System ID: simplifi:MET_geofencingAverageCpc
Data Type: decimal
Display As: currency
Formula: (simplifi:MET_geofencingTotalSpend / simplifi:MET_geofencingClicks)

Geofencing Average CPM

NinjaCat System ID: simplifi:MET_geofencingAverageCpm
Data Type: decimal
Display As: currency
Formula: (1000 * simplifi:MET_geofencingTotalSpend / simplifi:MET_geofencingImpressions)

Geofencing Behavioral Cost

API Name: Behavioral Cost
NinjaCat System ID: simplifi:MET_geofencingBehavioralCost
Data Type: decimal
Display As: currency

Geofencing Clicks

API Name: Clicks
NinjaCat System ID: simplifi:MET_geofencingClicks
Data Type: integer

Geofencing Contextual Cost

API Name: Contextual Cost
NinjaCat System ID: simplifi:MET_geofencingContextualCost
Data Type: decimal
Display As: currency

Geofencing CTR

NinjaCat System ID: simplifi:MET_geofencingCtr
Data Type: decimal
Display As: percent
Formula: (simplifi:MET_geofencingClicks / simplifi:MET_geofencingImpressions)

Geofencing Daily Spend Target

API Name: Daily Spend Target
NinjaCat System ID: simplifi:MET_geofencingDailySpendTarget
Data Type: decimal
Display As: currency

Geofencing Demographic Cost

API Name: Demographic Cost
NinjaCat System ID: simplifi:MET_geofencingDemographicCost
Data Type: decimal
Display As: currency

Geofencing Geographic Cost

API Name: Geographic Cost
NinjaCat System ID: simplifi:MET_geofencingGeographicCost
Data Type: decimal
Display As: currency

Geofencing Impressions

API Name: Impressions
NinjaCat System ID: simplifi:MET_geofencingImpressions
Data Type: integer

Geofencing Media Cost

API Name: Media Cost
NinjaCat System ID: simplifi:MET_geofencingMediaCost
Data Type: decimal
Display As: currency

Geofencing Platform Cost

API Name: Platform Cost
NinjaCat System ID: simplifi:MET_geofencingPlatformCost
Data Type: decimal
Display As: currency

Geofencing Search Cost

API Name: Search Cost
NinjaCat System ID: simplifi:MET_geofencingSearchCost
Data Type: decimal
Display As: currency

Geofencing Segment Cost

API Name: Segment Cost
NinjaCat System ID: simplifi:MET_geofencingSegmentCost
Data Type: decimal
Display As: currency

Geofencing Total Budget

API Name: Total Budget
NinjaCat System ID: simplifi:MET_geofencingTotalBudget
Data Type: decimal
Display As: currency

Geofencing Total Spend

API Name: Total Spend
NinjaCat System ID: simplifi:MET_geofencingTotalSpend
Data Type: decimal
Display As: currency

Geofencing Weighted Actions

API Name: Weighted Actions
NinjaCat System ID: simplifi:MET_geofencingWeightedActions
Data Type: integer

Geographic Cost

API Name: Geographic Cost
NinjaCat System ID: simplifi:MET_geographicCost
Data Type: decimal
Display As: currency

Impressions

API Name: Impressions
NinjaCat System ID: simplifi:MET_impressions
Data Type: integer
Aggregates To: MET_IMPRESSIONS

Impressions Composition

API Name: Insights Details Impressions Composition
NinjaCat System ID: simplifi:MET_impressionComposition
Data Type: decimal
Display As: float

Impressions Index

API Name: Insights Details Impressions Index
NinjaCat System ID: simplifi:MET_impressionIndex
Data Type: decimal
Display As: float

Media Cost

API Name: Media Cost
NinjaCat System ID: simplifi:MET_mediaCost
Data Type: decimal
Display As: currency
Aggregates To: MET_MEDIA_COST

Natural Conversion Rate

NinjaCat System ID: simplifi:MET_naturalConversionRate
Data Type: decimal
Display As: percent
Formula: (simplifi:MET_naturalConverters / simplifi:MET_naturalUsers)

Natural Converters

API Name: User Counts Natural Converters
NinjaCat System ID: simplifi:MET_naturalConverters
Data Type: integer

Natural Days to Convert

API Name: Day Counts By User Natural Days to Convert
NinjaCat System ID: simplifi:MET_naturalDaysToConvert
Data Type: decimal
Display As: float

Natural Days to Convert (Calculated)

NinjaCat System ID: simplifi:MET_calcNaturalDaysToConvert
Data Type: decimal
Display As: float
Formula: (simplifi:MET_TotalDaysToNatConvertHidden / simplifi:MET_naturalConverters)

Natural Users

API Name: User Counts Natural Target Fence Users
NinjaCat System ID: simplifi:MET_naturalUsers
Data Type: integer

New Campaign Converters

API Name: User Counts New Campaign Converters
NinjaCat System ID: simplifi:MET_newCampaignConverters
Data Type: integer

New Natural Converters

API Name: User Counts New Natural Converters
NinjaCat System ID: simplifi:MET_newNaturalConverters
Data Type: integer

New User Conversion Lift

API Name: Lift New Conversion Lift
NinjaCat System ID: simplifi:MET_newUserConversionLift
Data Type: integer

Platform Cost

API Name: Platform Cost
NinjaCat System ID: simplifi:MET_platformCost
Data Type: decimal
Display As: currency

Reach

API Name: Reach
NinjaCat System ID: simplifi:MET_reach
Data Type: integer

Retail Markup

API Name: Retail Markup
NinjaCat System ID: simplifi:MET_retailMarkup
Data Type: decimal
Display As: currency

Search Cost

API Name: Search Cost
NinjaCat System ID: simplifi:MET_searchCost
Data Type: decimal
Display As: currency

Search Data Payout

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Search Data Payout
NinjaCat System ID: simplifi:MET_searchDataPayout
Data Type: decimal
Display As: currency

Segment Cost

API Name: Segment Cost
NinjaCat System ID: simplifi:MET_segmentCost
Data Type: decimal
Display As: currency

Subtotal

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Subtotal
NinjaCat System ID: simplifi:MET_subtotal
Data Type: decimal
Display As: currency

Third Party Markup

API Name: Third Party Markup
NinjaCat System ID: simplifi:MET_thirdPartyMarkup
Data Type: decimal
Display As: currency

Total Budget

Deprecated: 2024-12-10T16:30:56.774Z
API Name: Total Budget
NinjaCat System ID: simplifi:MET_totalBudget
Data Type: decimal
Display As: currency
Aggregates To: MET_TOTAL_BUDGET

Total Media Cost

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Total Media Cost
NinjaCat System ID: simplifi:MET_totalMediaCost
Data Type: decimal
Display As: currency

Total Retail Cost

API Name: Total Retail Cost
NinjaCat System ID: simplifi:MET_totalRetailCost
Data Type: decimal
Display As: currency

Total Spend

API Name: Total Spend
NinjaCat System ID: simplifi:MET_totalSpend
Data Type: decimal
Display As: currency
Aggregates To: MET_COST,MET_TOTAL_SPEND

Total Tech Fees

API Name: Total Tech Fees
NinjaCat System ID: simplifi:MET_totalTechFees
Data Type: decimal
Display As: currency

Total Thirdparty Cost

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Total Thirdparty Cost
NinjaCat System ID: simplifi:MET_totalThirdpartyCost
Data Type: decimal
Display As: currency

Total Visits

API Name: Conversions Total Visits
NinjaCat System ID: simplifi:MET_totalVisits
Data Type: integer

Unique User Count

API Name: Segment Details Max Unique Users
NinjaCat System ID: simplifi:MET_uniqueUserCount
Data Type: integer

Video Starts

API Name: Video Events Start
NinjaCat System ID: simplifi:MET_VideoStarts
Data Type: integer
Aggregates To: MET_VIDEO_STARTS

Viewability

API Name: Viewability
NinjaCat System ID: simplifi:MET_viewability
Data Type: decimal
Display As: percent

View-through Leads

API Name: View Leads
NinjaCat System ID: simplifi:MET_viewLeads
Data Type: integer

View-through Other

API Name: View Other
NinjaCat System ID: simplifi:MET_viewOther
Data Type: integer

View-through Sales

API Name: View Sales
NinjaCat System ID: simplifi:MET_viewSales
Data Type: decimal
Display As: currency

View-through Signups

API Name: View Signups
NinjaCat System ID: simplifi:MET_viewSignups
Data Type: integer

View-through Visits

API Name: View Visits
NinjaCat System ID: simplifi:MET_viewVisits
Data Type: integer

Weighted Actions

API Name: Weighted Actions
NinjaCat System ID: simplifi:MET_weightedActions
Data Type: integer
Aggregates To: MET_CONVERSIONS