SalesForce Fields

Suggest Edits

Dimensions (33)

Account

NinjaCat System ID: sales_force:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Age

API Name: age

NinjaCat System ID: sales_force:DIM_age

Data Type: text

Close Date

API Name: close_date

NinjaCat System ID: sales_force:DIM_close_date

Data Type: date

Company Account

API Name: company_acct

NinjaCat System ID: sales_force:DIM_company_acct

Data Type: text

Converted Date

API Name: converted_date

NinjaCat System ID: sales_force:DIM_converted_date

Data Type: date

Currency

NinjaCat System ID: sales_force:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: sales_force:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: created_date

NinjaCat System ID: sales_force:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: sales_force:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: sales_force:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

External Id

NinjaCat System ID: sales_force:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Full Name

API Name: full_name

NinjaCat System ID: sales_force:DIM_full_name

Data Type: text

Last Update

API Name: last_update

NinjaCat System ID: sales_force:DIM_last_update

Data Type: date

Lead First Name

API Name: first_name

NinjaCat System ID: sales_force:DIM_first_name

Data Type: text

Lead Last Name

API Name: last_name

NinjaCat System ID: sales_force:DIM_last_name

Data Type: text

Lead Owner

API Name: lead_owner

NinjaCat System ID: sales_force:DIM_lead_owner

Data Type: text

Lead Source

API Name: lead_source

NinjaCat System ID: sales_force:DIM_lead_source

Data Type: text

Month Of Year

NinjaCat System ID: sales_force:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: sales_force:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Next Step

API Name: next_step

NinjaCat System ID: sales_force:DIM_next_step

Data Type: text

Opportunity Account Name

API Name: account_name

NinjaCat System ID: sales_force:DIM_account_name

Data Type: text

Opportunity Name

API Name: opportunity_name

NinjaCat System ID: sales_force:DIM_opportunity_name

Data Type: text

Opportunity Owner

API Name: opp_owner

NinjaCat System ID: sales_force:DIM_opp_owner

Data Type: text

Probability

API Name: probability

NinjaCat System ID: sales_force:DIM_probability

Data Type: text

Quarter

NinjaCat System ID: sales_force:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Rollup Description

API Name: rollup_description

NinjaCat System ID: sales_force:DIM_rollup_description

Data Type: text

Row

NinjaCat System ID: sales_force:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

Stage Name

API Name: stage_name

NinjaCat System ID: sales_force:DIM_stage_name

Data Type: text

Status

API Name: status

NinjaCat System ID: sales_force:DIM_status

Data Type: text

Aggregates To: DIM_STATUS

System Account ID

NinjaCat System ID: sales_force:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Type

API Name: type

NinjaCat System ID: sales_force:DIM_type

Data Type: text

Week Of Year

NinjaCat System ID: sales_force:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: sales_force:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (9)

Amount

API Name: amount

NinjaCat System ID: sales_force:MET_amount

Data Type: decimal

Display As: currency

Closed

API Name: closed

NinjaCat System ID: sales_force:MET_closed

Data Type: integer

Conversions

API Name: conversions

NinjaCat System ID: sales_force:MET_conversions

Data Type: integer

Aggregates To: MET_CONVERSIONS

Conversion Value

API Name: conversionValue

NinjaCat System ID: sales_force:MET_conversionValue

Data Type: decimal

Display As: currency

Aggregates To: MET_CONVERSION_VALUE

Count (Unique Dimensions)

NinjaCat System ID: sales_force:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

Leads

API Name: leads

NinjaCat System ID: sales_force:MET_leads

Data Type: integer

Aggregates To: MET_LEADS

Lost

API Name: lost

NinjaCat System ID: sales_force:MET_lost

Data Type: integer

Opportunities

API Name: opportunities

NinjaCat System ID: sales_force:MET_opportunities

Data Type: integer

Won

API Name: won

NinjaCat System ID: sales_force:MET_won

Data Type: integer

Updated 6 months ago