Salesforce metrics and dimensions

249 metrics469 dimensionsCustom fields

Search fields

ACCOUNTS

account_id

Field label	Account ID
Description	The account’s ID
Field type	dimension
Data type	string.text.value

account_number

Field label	Account number
Description	The account’s number
Field type	dimension
Data type	string.text.value

account_source

Field label	Account source
Description	The account’s source
Field type	dimension
Data type	string.text.value

account_billing_address

Field label	Account billing address
Description	The account’s billing address
Field type	dimension
Data type	string.text.value

account_billing_city

Field label	Account billing city
Description	The account’s billing city
Field type	dimension
Data type	string.geo.city

account_billing_country

Field label	Account billing country
Description	The account’s billing country
Field type	dimension
Data type	string.geo.country

account_billing_country_code

Field label	Account billing country code
Description	The account’s billing country code
Field type	dimension
Data type	string.geo.country.twolettercode

account_billing_geocode_accuracy

Field label	Account billing geocode accuracy
Description	The account’s billing geocode accuracy
Field type	dimension
Data type	string.text.value

account_billing_latitude

Field label	Account billing latitude
Description	The account’s billing latitude
Field type	dimension
Data type	string.geo.latitude

account_billing_longitude

Field label	Account billing longitude
Description	The account’s billing longitude
Field type	dimension
Data type	string.geo.longitude

account_billing_postal_code

Field label	Account billing postal code
Description	The account’s billing postal code
Field type	dimension
Data type	string.geo.zip

account_billing_state

Field label	Account billing state
Description	The account’s billing state
Field type	dimension
Data type	string.text.value

account_billing_state_code

Field label	Account billing state code
Description	The account’s billing state code
Field type	dimension
Data type	string.text.value

account_billing_street

Field label	Account billing street
Description	The account’s billing street
Field type	dimension
Data type	string.geo.street

account_created_by_id

Field label	Created by ID
Description	The account’s creator ID
Field type	dimension
Data type	string.text.value

account_created_date

Field label	Created date
Description	The account’s creation date
Field type	dimension
Data type	string.time.date

account_description

Field label	Account description
Description	The account’s description
Field type	dimension
Data type	string.text.value

account_fax

Field label	Account fax
Description	The account’s fax
Field type	dimension
Data type	string.text.value

account_industry

Field label	Industry
Description	An industry associated with this account
Field type	dimension
Data type	string.text.value

account_is_deleted

Field label	Is deleted
Description	Indicates whether the object has been moved to the recycle bin
Field type	dimension
Data type	bool

account_jigsaw

Field label	Jigsaw
Description	References the ID of a company in Data.com. If an account has a value in this field, it means that the account was imported from Data.com
Field type	dimension
Data type	string.text.value

account_jigsaw_company_id

Field label	Jigsaw company ID
Description	Company ID in Data.com
Field type	dimension
Data type	string.text.value

account_last_activity_date

Field label	Last activity date
Description	Due date of the most recent event logged against the record or most recently closed task associated with the record
Field type	dimension
Data type	string.time.date

account_last_modified_by_id

Field label	Last modified by ID
Description	Latest account’s modifier ID
Field type	dimension
Data type	string.text.value

account_last_modified_date

Field label	Last modified date
Description	Latest account modify date
Field type	dimension
Data type	string.time.date

account_last_referenced_date

Field label	Last referenced date
Description	The date when the current user last accessed this record, a record related to this record, or a list view
Field type	dimension
Data type	string.time.date

account_last_viewed_date

Field label	Last viewed date
Description	The date when the current user last viewed this record or list view. If this value is null, the user might have only accessed this record or list view, but not viewed it
Field type	dimension
Data type	string.time.date

account_master_record_id

Field label	Master record ID
Description	If this object was deleted as the result of a merge, this field contains the ID of the record that was kept
Field type	dimension
Data type	string.text.value

account_name

Field label	Account name
Description	The name of the associated person contact
Field type	dimension
Data type	string.text.value

account_owner_id

Field label	Operating owner ID
Description	The ID of the user who currently owns this account
Field type	dimension
Data type	string.text.value

account_ownership

Field label	Ownership
Description	Ownership type for the account
Field type	dimension
Data type	string.text.value

account_partner_id

Field label	Parent ID
Description	The account’s parent ID
Field type	dimension
Data type	string.text.value

account_phone

Field label	Phone number
Description	Phone number for this account
Field type	dimension
Data type	string.text.value

account_photo_url

Field label	Account photo URL
Description	Path to be combined with the URL of a Salesforce instance
Field type	dimension
Data type	string.text.url

account_rating

Field label	Rating
Description	The account’s prospect rating
Field type	dimension
Data type	string.text.value

account_record_type_id

Field label	Record type ID
Description	ID of the record type assigned to this object
Field type	dimension
Data type	string.text.value

account_shipping_address

Field label	Shipping address
Description	The compound form of the shipping address
Field type	dimension
Data type	string.text.value

account_shipping_city

Field label	Shipping city
Description	City of the shipping address for this account
Field type	dimension
Data type	string.geo.city

account_shipping_country

Field label	Shipping country
Description	Details of the shipping address for this account
Field type	dimension
Data type	string.geo.country

account_shipping_country_code

Field label	Shipping country code
Description	The ISO country code for the account’s shipping address
Field type	dimension
Data type	string.geo.country.twolettercode

account_shipping_geocode_accuracy

Field label	Shipping geocode accuracy
Description	Accuracy level of the geocode for the shipping address
Field type	dimension
Data type	string.text.value

account_shipping_latitude

Field label	Shipping latitude
Description	Used with shipping latitude to specify the precise geolocation of a shipping address
Field type	dimension
Data type	string.geo.latitude

account_shipping_longitude

Field label	Shipping longitude
Description	Used with shipping longitude to specify the precise geolocation of an address
Field type	dimension
Data type	string.geo.longitude

account_shipping_postal_code

Field label	Shipping postal code
Description	Shipping postal code for this account
Field type	dimension
Data type	string.geo.zip

account_shipping_state

Field label	Shipping state
Description	The ISO state code for the account’s shipping address
Field type	dimension
Data type	string.text.value

account_shipping_state_code

Field label	Shipping state code
Description	The ISO state code for the account’s shipping address
Field type	dimension
Data type	string.text.value

account_shipping_street

Field label	Shipping street
Description	The street address of the shipping address for this account
Field type	dimension
Data type	string.geo.street

account_sic

Field label	SIC code
Description	Standard Industrial Classification code of the company’s main business categorization
Field type	dimension
Data type	string.text.value

account_sic_desc

Field label	SIC description
Description	A brief description of an organization’s line of business, based on its SIC code
Field type	dimension
Data type	string.text.value

account_site

Field label	Site
Description	Name of the account’s location
Field type	dimension
Data type	string.text.value

account_currency_iso_code

Field label	Currency ISO code
Description	The ISO code of currency
Field type	dimension
Data type	string.currency.code

account_ticker_symbol

Field label	Ticker symbol
Description	The stock market symbol for this account
Field type	dimension
Data type	string.text.value

account_type

Field label	Account type
Description	Type of account
Field type	dimension
Data type	string.text.value

account_system_modstamp

Field label	System modstamp
Description	The account’s system modstamp
Field type	dimension
Data type	string.time.date

account_website

Field label	Website
Description	The website of this account
Field type	dimension
Data type	string.text.url

account_count

Field label	Accounts
Description	Total number of accounts
Field type	metric
Data type	int.number.value

account_number_of_employees

Field label	Number of Employees
Description	The account’s number of Employees
Field type	metric
Data type	int.number.value

account_annual_revenue

Field label	Annual revenue
Description	The account’s annual revenue
Field type	metric
Data type	float.currency.value

account_annual_revenue_eur

Field label	Annual revenue (EUR)
Description	The account’s annual revenue converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

account_annual_revenue_usd

Field label	Annual revenue (USD)
Description	The account’s annual revenue converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

account_annual_revenue_gbp

Field label	Annual revenue (GBP)
Description	The account’s annual revenue converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

CAMPAIGNS

campaign_id

Field label	Campaign ID
Description	Campaign unique ID
Field type	dimension
Data type	string.text.value

campaign_currency_iso_code

Field label	Currency ISO code
Description	Available only for organizations with the multicurrency feature enabled. Contains the ISO code for any currency allowed by the organization
Field type	dimension
Data type	string.currency.code

campaign_description

Field label	Campaign description
Description	Description of the campaign. Limit: 32 KB. Only the first 255 characters display in reports
Field type	dimension
Data type	string.text.value

campaign_end_date

Field label	End date
Description	Ending date for the campaign. Responses received after this date are still counted
Field type	dimension
Data type	string.time.date

campaign_is_active

Field label	Active
Description	Indicates whether this campaign is active (true) or not (false). Default value is false
Field type	dimension
Data type	bool

campaign_last_activity_date

Field label	Campaign last activity date
Description	Value is one of the following, whichever is the most recent: - Due date of the most recent event logged against the record. - Due date of the most recently closed task associated with the record
Field type	dimension
Data type	string.time.date

campaign_last_referenced_date

Field label	Campaign last referenced date
Description	The date for when the current user last viewed a record related to this record
Field type	dimension
Data type	string.time.date

campaign_last_viewed_date

Field label	Campaign last viewed date
Description	The date for when the current user last viewed this record. If this value is null, this record might only have been referenced (LastReferencedDate) and not viewed
Field type	dimension
Data type	string.time.date

campaign_name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

campaign_start_date

Field label	Start date
Description	Starting date for the campaign
Field type	dimension
Data type	string.time.date

campaign_status

Field label	Campaign status
Description	Status of the campaign, for example, Planned, In Progress
Field type	dimension
Data type	string.text.value

campaign_type

Field label	Campaign type
Description	Type of campaign, for example, Direct Mail or Referral Program
Field type	dimension
Data type	string.text.value

campaign_created_date

Field label	Campaign created date
Description	The date the campaign was created
Field type	dimension
Data type	string.time.date

campaign_last_modified_date

Field label	Campaign last modified date
Description	The date the campaign was last modified
Field type	dimension
Data type	string.time.date

campaign_count

Field label	Campaign count
Description	Total number of campaigns
Field type	metric
Data type	int.number.value

campaign_actual_cost

Field label	Actual cost
Description	Amount of money spent to run the campaign
Field type	metric
Data type	float.currency.value

campaign_actual_cost_eur

Field label	Actual cost (EUR)
Description	Amount of money spent to run the campaign converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_actual_cost_usd

Field label	Actual cost (USD)
Description	Amount of money spent to run the campaign converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_actual_cost_gbp

Field label	Actual cost (GBP)
Description	Amount of money spent to run the campaign converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_amount_all_opportunities

Field label	Amount all opportunities
Description	Amount of money in all opportunities associated with the campaign, including closed/won opportunities. Label is Value Opportunities in Campaign
Field type	metric
Data type	float.currency.value

campaign_amount_all_opportunities_eur

Field label	Amount all opportunities (EUR)
Description	Amount of money converted to EUR in all opportunities associated with the campaign, including closed/won opportunities. Label is Value Opportunities in Campaign
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_amount_all_opportunities_usd

Field label	Amount all opportunities (USD)
Description	Amount of money converted to USD in all opportunities associated with the campaign, including closed/won opportunities. Label is Value Opportunities in Campaign
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_amount_all_opportunities_gbp

Field label	Amount all opportunities (GBP)
Description	Amount of money converted to GBP in all opportunities associated with the campaign, including closed/won opportunities. Label is Value Opportunities in Campaign
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_amount_won_opportunities

Field label	Amount won opportunities
Description	Amount of money in closed or won opportunities associated with the campaign. Label is Value Won Opportunities in Campaign
Field type	metric
Data type	float.currency.value

campaign_amount_won_opportunities_eur

Field label	Amount won opportunities (EUR)
Description	Amount of money converted to EUR in closed or won opportunities associated with the campaign. Label is Value Won Opportunities in Campaign
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_amount_won_opportunities_usd

Field label	Amount won opportunities (USD)
Description	Amount of money converted to USD in closed or won opportunities associated with the campaign. Label is Value Won Opportunities in Campaign
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_amount_won_opportunities_gbp

Field label	Amount won opportunities (GBP)
Description	Amount of money converted to GBP in closed or won opportunities associated with the campaign. Label is Value Won Opportunities in Campaign
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_budgeted_cost

Field label	Budgeted cost
Description	Amount of money budgeted for the campaign
Field type	metric
Data type	float.currency.value

campaign_budgeted_cost_eur

Field label	Budgeted cost (EUR)
Description	Amount of money budgeted for the campaign converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_budgeted_cost_usd

Field label	Budgeted cost (USD)
Description	Amount of money budgeted for the campaign converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_budgeted_cost_gbp

Field label	Budgeted cost (GBP)
Description	Amount of money budgeted for the campaign converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_expected_response

Field label	Expected response
Description	Percentage of responses you expect to receive for the campaign
Field type	metric
Data type	float.number.percentage

campaign_expected_revenue

Field label	Expected revenue
Description	Amount of money you expect to generate from the campaign
Field type	metric
Data type	float.currency.value

campaign_expected_revenue_eur

Field label	Expected revenue (EUR)
Description	Amount of money you expect to generate from the campaign converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_expected_revenue_usd

Field label	Expected revenue (USD)
Description	Amount of money you expect to generate from the campaign converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_expected_revenue_gbp

Field label	Expected revenue (GBP)
Description	Amount of money you expect to generate from the campaign converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_actual_cost

Field label	Total Actual Cost in Hierarchy
Description	Calculated field for the total amount of money spent to run the campaigns in a campaign hierarchy
Field type	metric
Data type	float.currency.value

campaign_hierarchy_actual_cost_eur

Field label	Total Actual Cost in Hierarchy (EUR)
Description	Calculated field for the total amount of money spent to run the campaigns in a campaign hierarchy converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_actual_cost_usd

Field label	Total Actual Cost in Hierarchy (USD)
Description	Calculated field for the total amount of money spent to run the campaigns in a campaign hierarchy converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_actual_cost_gbp

Field label	Total Actual Cost in Hierarchy (GBP)
Description	Calculated field for the total amount of money spent to run the campaigns in a campaign hierarchy converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_budgeted_cost

Field label	Total Budgeted Cost in Hierarchy
Description	Calculated field for the total amount of money budgeted for the campaigns in a campaign hierarchy
Field type	metric
Data type	float.currency.value

campaign_hierarchy_budgeted_cost_eur

Field label	Total Budgeted Cost in Hierarchy (EUR)
Description	Calculated field for the total amount of money budgeted for the campaigns in a campaign hierarchy converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_budgeted_cost_usd

Field label	Total Budgeted Cost in Hierarchy (USD)
Description	Calculated field for the total amount of money budgeted for the campaigns in a campaign hierarchy converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_budgeted_cost_gbp

Field label	Total Budgeted Cost in Hierarchy (GBP)
Description	Calculated field for the total amount of money budgeted for the campaigns in a campaign hierarchy converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_expected_revenue

Field label	Total Expected Revenue in Hierarchy
Description	Calculated field for the total amount of money you expect to generate from the campaigns in a campaign hierarchy
Field type	metric
Data type	float.currency.value

campaign_hierarchy_expected_revenue_eur

Field label	Total Expected Revenue in Hierarchy (EUR)
Description	Calculated field for the total amount of money you expect to generate from the campaigns in a campaign hierarchy converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_expected_revenue_usd

Field label	Total Expected Revenue in Hierarchy (USD)
Description	Calculated field for the total amount of money you expect to generate from the campaigns in a campaign hierarchy converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_expected_revenue_gbp

Field label	Total Expected Revenue in Hierarchy (GBP)
Description	Calculated field for the total amount of money you expect to generate from the campaigns in a campaign hierarchy converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_hierarchy_number_sent

Field label	Total Num Sent in Hierarchy
Description	Calculated field for the total number of individuals targeted by the campaigns in a campaign hierarchy. For example, the number of email messagess sent
Field type	metric
Data type	int.number.value

campaign_number_of_contacts

Field label	Total Contacts
Description	Number of contacts associated with the campaign
Field type	metric
Data type	int.number.value

campaign_number_of_converted_leads

Field label	Converted Leads
Description	Number of leads that were converted to an account and contact due to the marketing efforts in the campaign
Field type	metric
Data type	int.number.value

campaign_number_of_leads

Field label	Leads in Campaign
Description	Number of leads associated with the campaign
Field type	metric
Data type	int.number.value

campaign_number_of_opportunities

Field label	Opportunities in Campaign
Description	Number of opportunities associated with the campaign
Field type	metric
Data type	int.number.value

campaign_number_of_responses

Field label	Responses in Campaign
Description	Number of contacts and unconverted leads with a Member Status equivalent to “Responded” for the campaign
Field type	metric
Data type	int.number.value

campaign_number_of_won_opportunities

Field label	Won Opportunities in Campaign
Description	Number of closed or won opportunities associated with the campaign
Field type	metric
Data type	int.number.value

campaign_number_sent

Field label	Num sent
Description	Number of individuals targeted by the campaign. For example, the number of emails sent
Field type	metric
Data type	int.number.value

campaign_total_amount_all_opportunities

Field label	Total Value Opportunities in Hierarchy
Description	Calculated field for total amount of all opportunities associated with the campaign hierarchy, including closed/won opportunities
Field type	metric
Data type	float.currency.value

campaign_total_amount_all_opportunities_eur

Field label	Total Value Opportunities in Hierarchy (EUR)
Description	Calculated field for total amount converted to EUR of all opportunities associated with the campaign hierarchy, including closed/won opportunities
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_total_amount_all_opportunities_usd

Field label	Total Value Opportunities in Hierarchy (USD)
Description	Calculated field for total amount converted to USD of all opportunities associated with the campaign hierarchy, including closed/won opportunities
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_total_amount_all_opportunities_gbp

Field label	Total Value Opportunities in Hierarchy (GBP)
Description	Calculated field for total amount converted to GBP of all opportunities associated with the campaign hierarchy, including closed/won opportunities
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_total_amount_all_won_opportunities

Field label	Total Value Won Opportunities in Hierarchy
Description	Calculated field for amount of all closed/won opportunities associated with the campaign hierarchy
Field type	metric
Data type	float.currency.value

campaign_total_amount_all_won_opportunities_eur

Field label	Total Value Won Opportunities in Hierarchy (EUR)
Description	Calculated field for amount of all closed/won opportunities associated with the campaign hierarchy converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_total_amount_all_won_opportunities_uds

Field label	Total Value Won Opportunities in Hierarchy (USD)
Description	Calculated field for amount of all closed/won opportunities associated with the campaign hierarchy converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_total_amount_all_won_opportunities_gbp

Field label	Total Value Won Opportunities in Hierarchy (GBP)
Description	Calculated field for amount of all closed/won opportunities associated with the campaign hierarchy converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

campaign_total_number_of_contacts

Field label	Total Contacts in Hierarchy
Description	Calculated field for number of contacts associated with the campaign hierarchy
Field type	metric
Data type	int.number.value

campaign_total_number_of_converted_leads

Field label	Total Converted Leads in Hierarchy
Description	Calculated field for the total number of leads associated with the campaign hierarchy that were converted into accounts, contacts, and opportunities
Field type	metric
Data type	int.number.value

campaign_total_number_of_leads

Field label	Total Leads in Hierarchy
Description	Calculated field for total number of leads associated with the campaign hierarchy. This number also includes converted leads
Field type	metric
Data type	int.number.value

campaign_total_number_of_opportunities

Field label	Total Opportunities in Hierarchy
Description	Calculated field for the total number of opportunities associated with the campaign hierarchy
Field type	metric
Data type	int.number.value

campaign_total_number_of_responses

Field label	Total Responses in Hierarchy
Description	Calculated field for number of contacts and unconverted leads that have a Member Status equivalent to “Responded” for the campaign hierarchy
Field type	metric
Data type	int.number.value

campaign_total_number_of_won_opportunities

Field label	Total Won Opportunities in Hierarchy
Description	Calculated field for the total number of won opportunities associated with the campaign hierarchy
Field type	metric
Data type	int.number.value

CLOSE DATE

year_closed

Field label	Closed year
Field type	dimension
Data type	string.time.year

yearOfWeek_closed

Field label	Closed year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

yearOfWeekIso_closed

Field label	Closed year of week (Mon-Sun) in ISO format
Field type	dimension
Data type	string.time.year

yearMonth_closed

Field label	Closed year & month
Field type	dimension
Data type	string.time.yearmonth

month_closed

Field label	Closed month
Field type	dimension
Data type	string.time.month

yearWeek_closed

Field label	Closed year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

yearWeekIso_closed

Field label	Closed year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

week_closed

Field label	Closed week (Sun-Sat)
Field type	dimension
Data type	string.time.week

weekIso_closed

Field label	Closed week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

dayOfMonth_closed

Field label	Closed day of month
Field type	dimension
Data type	string.time.dayofmonth

dayOfWeek_closed

Field label	Closed day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

dayOfWeekIso_closed

Field label	Closed day of week (Mon-Sun) in ISO format
Field type	dimension
Data type	string.time.dayofweekiso

date_closed

Field label	Closed date
Field type	dimension
Data type	string.time.date

CONTACTS

contact_account_name

Field label	Contact account name
Description	The account that the contact is linked to
Field type	dimension
Data type	string.text.value

contact_account_id

Field label	Account ID
Description	The ID of the account that the contact is linked to
Field type	dimension
Data type	string.text.value

contact_assistant

Field label	Assistant
Description	The contact’s assistant
Field type	dimension
Data type	string.text.value

contact_asst_phone

Field label	Asst. phone
Description	The assistant’s phone number
Field type	dimension
Data type	string.text.phone

contact_birthdate

Field label	Contact birth date
Description	The contact’s birthday
Field type	dimension
Data type	string.time.date

contact_division

Field label	Contact ID
Description	The contact’s ID
Field type	dimension
Data type	string.text.value

contact_owner

Field label	Contact owner
Description	The contact’s assigned owner
Field type	dimension
Data type	string.text.value

contact_created_by

Field label	Created by
Description	The user who created the contact
Field type	dimension
Data type	string.text.value

contact_custom_links

Field label	Contact created date
Description	The contact’s created date
Field type	dimension
Data type	string.time.date

contact_is_deleted

Field label	Deleted
Description	Is contact deleted
Field type	dimension
Data type	bool

contact_department

Field label	Department
Description	The associated business or organizational unit
Field type	dimension
Data type	string.text.value

contact_description

Field label	Contact description
Description	The contact’s description
Field type	dimension
Data type	string.text.value

contact_do_not_call

Field label	Do not call
Description	Do not call
Field type	dimension
Data type	bool

contact_email

Field label	Contact email
Description	The contact’s email address
Field type	dimension
Data type	string.text.value

email_bounced_date

Field label	Email bounced date
Description	Email bounced date
Field type	dimension
Data type	string.time.date

email_bounced_reason

Field label	Email bounced reason
Description	Email bounced reason
Field type	dimension
Data type	string.text.value

contact_email_opt_out

Field label	Email opt out
Description	Whether the contact wants to receive email or not
Field type	dimension
Data type	bool

contact_fax

Field label	Fax
Description	The contact’s fax number
Field type	dimension
Data type	string.text.phone

contact_fax_opt_out

Field label	Fax opt out
Description	Whether the contact wants to receive fax or not
Field type	dimension
Data type	bool

contact_first_name

Field label	Contact first name
Description	The contact’s first name, as displayed on the contact edit page
Field type	dimension
Data type	string.text.value

contact_home_phone

Field label	Home phone
Description	The contact’s home phone number
Field type	dimension
Data type	string.text.phone

contact_is_email_bounced

Field label	Is email bounced
Description	Is contact’s email bounced
Field type	dimension
Data type	bool

contact_last_activity

Field label	Contact last activity date
Description	Last activity date
Field type	dimension
Data type	string.time.date

contact_last_modified_by

Field label	Contact last modified by
Description	The user who last changed the contact fields
Field type	dimension
Data type	string.text.value

contact_last_modified_date

Field label	Contact last modified date
Description	Contact last modified date
Field type	dimension
Data type	string.time.date

contact_last_referenced_date

Field label	Contact last referenced date
Description	Last referenced date
Field type	dimension
Data type	string.time.date

contact_last_viewed_date

Field label	Contact last viewed date
Description	Contact last viewed date
Field type	dimension
Data type	string.time.date

contact_last_name

Field label	Contact last name
Description	The contact’s last name as displayed on the contact edit page
Field type	dimension
Data type	string.text.value

contact_lead_source

Field label	Contact lead source
Description	The record source: for example, Advertisement, Partner, or Web
Field type	dimension
Data type	string.text.value

contact_mailing_city

Field label	Mailing city
Description	The city in the mailing address
Field type	dimension
Data type	string.geo.city

contact_mailing_country

Field label	Mailing country
Description	The country in the mailing address
Field type	dimension
Data type	string.geo.country

contact_mailing_country_code

Field label	Mailing country code
Description	The country code in the mailing address
Field type	dimension
Data type	string.geo.country.twolettercode

contact_mailing_geocode_accuracy

Field label	Mailing geocode accuracy
Description	Mailing geocode accuracy
Field type	dimension
Data type	string.text.value

contact_mailing_latitude

Field label	Mailing latitude
Description	Mailing latitude
Field type	dimension
Data type	float.number.value

contact_mailing_longitude

Field label	Mailing longitude
Description	Mailing longitude
Field type	dimension
Data type	float.number.value

contact_mailing_state

Field label	Mailing state/province
Description	The state or province in the mailing address
Field type	dimension
Data type	string.geo.region

contact_mailing_state_code

Field label	Mailing state/province code
Description	The state or province code in the mailing address
Field type	dimension
Data type	string.text.value

contact_mailing_street

Field label	Mailing street
Description	The street in the mailing address
Field type	dimension
Data type	string.geo.street

contact_mailing_postal_code

Field label	Mailing zip/postal code
Description	The zip or postal code in the mailing address
Field type	dimension
Data type	string.geo.zip

contact_mobile

Field label	Contact mobile phone
Description	The contact’s mobile phone number
Field type	dimension
Data type	string.text.phone

contact_full_name

Field label	Contact full name
Description	The contact’s full name
Field type	dimension
Data type	string.text.value

contact_other_city

Field label	Other city
Description	The city in another address for the contact
Field type	dimension
Data type	string.geo.city

contact_other_country

Field label	Other country
Description	The country in another address for the contact
Field type	dimension
Data type	string.geo.country

contact_other_state

Field label	Other state/province
Description	The state or province in another address for the contact
Field type	dimension
Data type	string.geo.region

contact_other_street

Field label	Other street
Description	The street address in another address for the contact
Field type	dimension
Data type	string.geo.street

contact_other_postal_code

Field label	Other zip/postal code
Description	The zip or postal code in another address for the contact
Field type	dimension
Data type	string.geo.zip

contact_other_phone

Field label	Other phone
Description	Another phone number for the contact
Field type	dimension
Data type	string.text.phone

contact_phone

Field label	Contact phone
Description	The contact’s primary phone number
Field type	dimension
Data type	string.text.phone

contact_photo_url

Field label	Photo URL
Description	The contact’s photo URL
Field type	dimension
Data type	string.text.url

contact_reports_to

Field label	Reports to
Description	The name of the contact’s manager
Field type	dimension
Data type	string.text.value

contact_salutation

Field label	Salutation
Description	The title for addressing the contact, for example, Mr., Ms., or Dr
Field type	dimension
Data type	string.text.value

contact_title

Field label	Contact title
Description	The contact’s position within the organization
Field type	dimension
Data type	string.text.value

contact_count

Field label	Contact count
Description	Total number of contacts
Field type	metric
Data type	int.number.value

CONTRACT LINE ITEMS

contract_line_item_id

Field label	Contract item ID
Description	Contract item unique ID
Field type	dimension
Data type	string.text.value

contract_line_item_asset_id

Field label	Asset ID
Description	ID of the Asset associated with the contract line item
Field type	dimension
Data type	string.text.value

contract_line_item_description

Field label	Contract item description
Description	Description of the contract line item
Field type	dimension
Data type	string.text.value

contract_line_item_discount

Field label	Contract item discount
Description	The discount for the product as a percentage
Field type	dimension
Data type	float.number.percentage

contract_line_item_end_date

Field label	Contract item end date
Description	The last day the contract line item is in effect
Field type	dimension
Data type	string.time.date

contract_line_item_last_referenced_date

Field label	Contract item last referenced date
Description	The timestamp when the current user last accessed this record, a record related to this record, or a list view
Field type	dimension
Data type	string.time.date

contract_line_item_last_viewed_date

Field label	Contract item last viewed date
Description	The timestamp when the current user last viewed this record or list view. If this value is null, the user might have only accessed this record or list view last referenced date but not viewed it
Field type	dimension
Data type	string.time.date

contract_line_item_line_item_number

Field label	Line item number
Description	Automatically-generated number that identifies the contract line item
Field type	dimension
Data type	string.text.value

contract_line_item_list_price

Field label	Contract item list price
Description	Corresponds to the unit price on the pricebook entry that is associated with this line item, which can be in the standard pricebook or a custom pricebook. A client application can use this information to show whether the unit price or sales price of the line item differs from the pricebook entry list price
Field type	dimension
Data type	float.currency.value

contract_line_item_location_id

Field label	Location ID
Description	The location associated with the contract line item
Field type	dimension
Data type	string.text.value

contract_line_item_parent_contract_line_item_id

Field label	Parent contract line item ID
Description	The line item's parent line item, if it has one
Field type	dimension
Data type	string.text.value

contract_line_item_pricebook_entry_id

Field label	Pricebook entry ID
Description	ID of the associated pricebook entry
Field type	dimension
Data type	string.text.value

contract_line_item_product_id

Field label	Product ID
Description	The product related to the contract line item
Field type	dimension
Data type	string.text.value

contract_line_item_root_contract_line_item_id

Field label	Root contract line item ID
Description	The top-level line item in a contract line item hierarchy. Depending on where a line item lies in the hierarchy, its root could be the same as its parent
Field type	dimension
Data type	string.text.value

contract_line_item_service_contract_id

Field label	Service contract ID
Description	ID of the ServiceContract associated with the contract line item
Field type	dimension
Data type	string.text.value

contract_line_item_start_date

Field label	Contract item start date
Description	The first day the contract line item is in effect
Field type	dimension
Data type	string.time.date

contract_line_item_status

Field label	Contract item status
Description	Status of the contract line item
Field type	dimension
Data type	string.text.value

contract_line_item_created_date

Field label	Contract item created date
Description	The date the contract item was created
Field type	dimension
Data type	string.time.date

contract_line_item_last_modified_date

Field label	Contract item last modified date
Description	The date the contract item was last modified
Field type	dimension
Data type	string.time.date

contract_line_item_quantity

Field label	Contract item quantity
Description	Number of units of the contract line item product included in the associated service contract
Field type	metric
Data type	float.number.value

contract_line_item_subtotal

Field label	Contract item subtotal
Description	Contract line item's sales price multiplied by the quantity
Field type	metric
Data type	float.currency.value

contract_line_item_total_price

Field label	Contract item total price
Description	This field is available only for backward compatibility. It represents the total price of the ContractLineItem
Field type	metric
Data type	float.currency.value

contract_line_item_unit_price

Field label	Contract item unit price
Description	The unit price for the contract line item. In the user interface, this field s value is calculated by dividing the total price of the contract line item by the quantity listed for that line item. Label is Sales Price
Field type	metric
Data type	float.currency.value

CONTRACTS

contract_id

Field label	Contract ID
Description	Contract unique ID
Field type	dimension
Data type	string.text.value

contract_account_id

Field label	Account ID
Description	ID of the Account associated with this contract
Field type	dimension
Data type	string.text.value

contract_activated_by_id

Field label	Activated by ID
Description	ID of the User who activated this contract
Field type	dimension
Data type	string.text.value

contract_activated_date

Field label	Contract activated time
Description	Date and time when this contract was activated
Field type	dimension
Data type	string.time.datetime

contract_billing_address

Field label	Contract billing address
Description	The compound form of the billing address
Field type	dimension
Data type	string.text.value

contract_billing_city

Field label	Contract billing city
Description	Details for the billing address
Field type	dimension
Data type	string.geo.city

contract_billing_country

Field label	Contract billing country
Description	Details for the billing address of this account
Field type	dimension
Data type	string.geo.country

contract_billing_country_code

Field label	Contract billing country code
Description	The ISO country code for the contract's billing address
Field type	dimension
Data type	string.geo.country.twolettercode

contract_billing_geocode_accuracy

Field label	Contract billing geocode accuracy
Description	The accuracy of the geocode for the billing address
Field type	dimension
Data type	string.text.value

contract_billing_latitude

Field label	Contract billing latitude
Description	Used with longitude to specify the precise geolocation of a billing address
Field type	dimension
Data type	string.geo.latitude

contract_billing_longitude

Field label	Contract billing longitude
Description	Used with latitude to specify the precise geolocation of a billing address
Field type	dimension
Data type	string.geo.longitude

contract_billing_postal_code

Field label	Contract billing postal code
Description	Details for the billing address of this account
Field type	dimension
Data type	string.geo.zip

contract_billing_state

Field label	Contract billing state
Description	Details for the billing address
Field type	dimension
Data type	string.text.value

contract_billing_state_code

Field label	Contract billing state code
Description	The ISO state code for the contract's billing address
Field type	dimension
Data type	string.text.value

contract_billing_street

Field label	Contract billing street
Description	Street address for the billing address
Field type	dimension
Data type	string.geo.street

contract_company_signed_date

Field label	Company signed date
Description	Date on which the contract was signed by your organization
Field type	dimension
Data type	string.time.date

contract_company_signed_id

Field label	Company signed ID
Description	ID of the User who signed the contract
Field type	dimension
Data type	string.text.value

contract_number

Field label	Contract number
Description	Number of the contract
Field type	dimension
Data type	string.text.value

contract_customer_signed_date

Field label	Customer signed date
Description	Date on which the customer signed the contract
Field type	dimension
Data type	string.time.date

contract_customer_signed_id

Field label	Customer signed ID
Description	ID of the Contact who signed this contract
Field type	dimension
Data type	string.text.value

contract_customer_signed_title

Field label	Customer signed title
Description	Title of the customer who signed the contract
Field type	dimension
Data type	string.text.value

contract_description

Field label	Contract description
Description	Description of the contract
Field type	dimension
Data type	string.text.value

contract_end_date

Field label	Contract end date
Description	Calculated end date of the contract
Field type	dimension
Data type	string.time.date

contract_is_deleted

Field label	Contract is deleted
Description	Indicates whether the object has been moved to the Recycle Bin
Field type	dimension
Data type	bool

contract_last_activity_date

Field label	Contract last activity date
Description	Value is one of the following, whichever is the most recent: 1. Due date of the most recent event logged against the record; 2. Due date of the most recently closed task associated with the record
Field type	dimension
Data type	string.time.date

contract_last_approved_date

Field label	Last approved time
Description	Last date the contract was approved
Field type	dimension
Data type	string.time.datetime

contract_last_referenced_date

Field label	Last referenced time
Description	The timestamp when the current user last accessed this record, a record related to this record, or a list view
Field type	dimension
Data type	string.time.datetime

contract_last_viewed_date

Field label	Last viewed time
Description	The timestamp when the current user last viewed this record or list view. If this value is null, the user might have only accessed this record or list view last referenced date but not viewed it
Field type	dimension
Data type	string.time.datetime

contract_owner_expiration_notice

Field label	Owner expiration notice
Description	Number of days ahead of the contract end date 15, 30, 45, 60, 90, and 120. Used to notify the owner in advance that the contract is ending
Field type	dimension
Data type	string.text.value

contract_owner_id

Field label	Owner ID
Description	ID of the user who owns the contract
Field type	dimension
Data type	string.text.value

contract_pricebook_id

Field label	Pricebook ID
Description	ID of the pricebook, if any, associated with this contract
Field type	dimension
Data type	string.text.value

contract_record_type_id

Field label	Record type ID
Description	ID of the record type assigned to this object
Field type	dimension
Data type	string.text.value

contract_shipping_address

Field label	Contract shipping address
Description	The compound form of the shipping address
Field type	dimension
Data type	string.text.value

contract_shipping_city

Field label	Contract shipping city
Description	Details of the shipping address
Field type	dimension
Data type	string.geo.city

contract_shipping_country

Field label	Contract shipping country
Description	Details of the shipping address
Field type	dimension
Data type	string.geo.country

contract_shipping_country_code

Field label	Contract shipping country code
Description	The ISO country code for the contract's shipping address
Field type	dimension
Data type	string.geo.country.twolettercode

contract_shipping_latitude

Field label	Contract shipping latitude
Description	Used with longitude to specify the precise geolocation of a shipping address
Field type	dimension
Data type	string.geo.latitude

contract_shipping_longitude

Field label	Contract shipping longitude
Description	Used with latitude to specify the precise geolocation of an address
Field type	dimension
Data type	string.geo.longitude

contract_shipping_postal_code

Field label	Contract shipping postal code
Description	Details of the shipping address
Field type	dimension
Data type	string.geo.zip

contract_shipping_state

Field label	Contract shipping state
Description	Details of the shipping address
Field type	dimension
Data type	string.text.value

contract_shipping_state_code

Field label	Contract shipping state code
Description	The ISO state code for the contract's shipping address
Field type	dimension
Data type	string.text.value

contract_shipping_street

Field label	Contract shipping street
Description	The street address of the shipping address
Field type	dimension
Data type	string.geo.street

contract_special_terms

Field label	Special terms
Description	Special terms that apply to the contract
Field type	dimension
Data type	string.text.value

contract_start_date

Field label	Contract start date
Description	Start date for this contract
Field type	dimension
Data type	string.time.date

contract_status

Field label	Contract status
Description	The picklist of values that indicate order status
Field type	dimension
Data type	string.text.value

contract_status_code

Field label	Contract status code
Description	The status category for the contract
Field type	dimension
Data type	string.text.value

contract_created_date

Field label	Contract created date
Description	The date the contract was created
Field type	dimension
Data type	string.time.date

contract_last_modified_date

Field label	Contract last modified date
Description	The date the contract was last modified
Field type	dimension
Data type	string.time.date

contract_term

Field label	Contract term
Description	Number of months that the contract is valid
Field type	metric
Data type	int.number.value

DATASOURCE

dataSourceName

Field label	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value
Destinations	API, Data warehouse

system_metadata.data_source_logins

Field label	Data source logins
Description	The data source login accounts that were used to authenticate against the data source
Field type	dimension
Data type	string.text.json

system_metadata.data_source_login_owners

Field label	Data source login owners
Description	The Supermetrics users that created the data source login connections
Field type	dimension
Data type	string.text.json

LEADS

lead_id

Field label	Lead ID
Description	The unique identifier for the lead
Field type	dimension
Data type	string.text.value

lead_firstname

Field label	Lead first name
Description	The first name of the lead
Field type	dimension
Data type	string.text.value

lead_lastname

Field label	Lead last name
Description	The last name of the lead
Field type	dimension
Data type	string.text.value

lead_title

Field label	Lead title
Description	The title of the lead
Field type	dimension
Data type	string.text.value

lead_company

Field label	Company
Description	The company of the lead
Field type	dimension
Data type	string.text.value

lead_country

Field label	Lead country
Description	The country of the lead
Field type	dimension
Data type	string.text.value

lead_state

Field label	Lead state
Description	The state/province of the lead
Field type	dimension
Data type	string.text.value

lead_phone

Field label	Lead phone
Description	The phone number of the lead
Field type	dimension
Data type	string.text.phone

lead_mobile_phone

Field label	Lead mobile
Description	The mobile phone number of the lead
Field type	dimension
Data type	string.text.phone

lead_email

Field label	Lead email
Description	The email of the lead
Field type	dimension
Data type	string.text.email

lead_status

Field label	Lead status
Description	The status of the lead
Field type	dimension
Data type	string.text.value

lead_source

Field label	Lead source
Description	The source of lead
Field type	dimension
Data type	string.text.value

lead_owner_id

Field label	Lead owner ID
Description	The unique identifier for the lead owner
Field type	dimension
Data type	string.text.value

lead_owner_name

Field label	Lead owner name
Description	The name of the lead owner
Field type	dimension
Data type	string.text.value

lead_owner_email

Field label	Lead owner email
Description	The email of the lead owner
Field type	dimension
Data type	string.text.value

lead_owner_department

Field label	Lead owner department
Description	The department of the lead owner
Field type	dimension
Data type	string.text.value

lead_last_activity_date

Field label	Lead last activity date
Description	The last activity date of the lead
Field type	dimension
Data type	string.text.value

lead_is_deleted

Field label	Lead is deleted
Description	Whether or not the lead is deleted
Field type	dimension
Data type	bool

lead_is_converted

Field label	Lead is converted
Description	Whether or not the lead is converted
Field type	dimension
Data type	bool

lead_converted_account_id

Field label	Converted account ID
Description	ID of the account the lead was converted to
Field type	dimension
Data type	string.text.value

lead_converted_contact_id

Field label	Converted contact ID
Description	ID of the contact the lead was converted to
Field type	dimension
Data type	string.text.value

lead_converted_opportunity_id

Field label	Converted opportunity ID
Description	ID of the opportunity the lead was converted to
Field type	dimension
Data type	string.text.value

lead_converted_date

Field label	Converted date
Description	Date on which this lead was converted
Field type	dimension
Data type	string.time.date

lead_created_date

Field label	Lead created date
Description	The date when the lead was created
Field type	dimension
Data type	string.time.date

lead_last_modified_date

Field label	Lead last modified date
Description	The date when the lead was last modified
Field type	dimension
Data type	string.time.date

lead_count

Field label	Leads
Description	Total number of leads
Field type	metric
Data type	int.number.value

OPPORTUNITIES

opportunity_id

Field label	Opportunity ID
Description	The ID of the opportunity
Field type	dimension
Data type	string.text.value

opportunity_name

Field label	Opportunity name
Description	The name of the opportunity
Field type	dimension
Data type	string.text.value

opportunity_type

Field label	Opportunity type
Description	The type of the opportunity
Field type	dimension
Data type	string.text.value

opportunity_description

Field label	Opportunity description
Description	The description for the opportunity
Field type	dimension
Data type	string.text.value

opportunity_stage_name

Field label	Opportunity stage
Description	The stage of the opportunity
Field type	dimension
Data type	string.text.value

opportunity_close_date

Field label	Opportunity close date
Description	The close date of the opportunity
Field type	dimension
Data type	string.time.date

opportunity_next_step

Field label	Opportunity next step
Description	The next step for the opportunity
Field type	dimension
Data type	string.text.value

opportunity_lead_source

Field label	Opportunity lead source
Description	The lead source for the opportunity
Field type	dimension
Data type	string.text.value

opportunity_currency_iso_code

Field label	Currency
Description	Currency Iso code of fields with monetary values. Can be converted to the user’s currency when multicurrency feature enabled
Field type	dimension
Data type	string.currency.code

opportunity_is_closed

Field label	Is opportunity closed
Description	Whether or not the opportunity is closed
Field type	dimension
Data type	bool

opportunity_is_won

Field label	Is opportunity won
Description	Whether or not the opportunity is won
Field type	dimension
Data type	bool

opportunity_forecast_category

Field label	Forecast category
Description	The forecast category for the opportunity
Field type	dimension
Data type	string.text.value

opportunity_forecast_category_name

Field label	Forecast category name
Description	The forecast category name for the opportunity
Field type	dimension
Data type	string.text.value

opportunity_has_line_item

Field label	Has line item
Description	Whether or not the opportunity has a line item
Field type	dimension
Data type	bool

opportunity_created_date

Field label	Opportunity created date
Description	The date when the opportunity was created
Field type	dimension
Data type	string.time.date

opportunity_last_modified_date

Field label	Opportunity last modified date
Description	The date when the opportunity was last modified
Field type	dimension
Data type	string.time.date

opportunity_last_activity_date

Field label	Opportunity last activity date
Description	The date of the last activity for the opportunity
Field type	dimension
Data type	string.time.date

opportunity_fiscal_quarter

Field label	Fiscal quarter
Description	The fiscal quarter of the opportunity
Field type	dimension
Data type	string.time.quarter

opportunity_fiscal_year

Field label	Fiscal year
Description	The fiscal year of the opportunity
Field type	dimension
Data type	string.time.year

opportunity_fiscal

Field label	Fiscal period
Description	The fiscal period of the opportunity
Field type	dimension
Data type	string.text.value

opportunity_last_viewed_date

Field label	Opportunity last viewed date
Description	The date when the opportunity was last viewed
Field type	dimension
Data type	string.time.date

opportunity_last_referenced_date

Field label	Opportunity last referenced date
Description	The date when the opportunity was last referenced
Field type	dimension
Data type	string.time.date

opportunity_has_open_activity

Field label	Has open activity
Description	Whether or not the opportunity has open activity
Field type	dimension
Data type	bool

opportunity_has_overdue_task

Field label	Has overdue task
Description	Whether or not the opportunity has overdue tasks
Field type	dimension
Data type	bool

opportunity_probability

Field label	Probability (%)
Description	The probability for the opportunity
Field type	dimension
Data type	float.number.percentage

opportunity_owner

Field label	Opportunity owner
Description	Owner of the opportunity
Field type	dimension
Data type	string.text.value

opportunity_account_name

Field label	Opportunity account name
Description	Customer of the opportunity
Field type	dimension
Data type	string.text.value

opportunity_account_source

Field label	Opportunity account source
Description	Customer source of the opportunity
Field type	dimension
Data type	string.text.value

opportunity_account_phone

Field label	Opportunity account phone
Description	The phone number of the opportunity account
Field type	dimension
Data type	string.text.phone

opportunity_account_industry

Field label	Opportunity account industry
Description	The industry of the opportunity account
Field type	dimension
Data type	string.text.value

opportunity_account_employee_count

Field label	Opportunity account employee count
Description	The employee count of the opportunity account
Field type	dimension
Data type	int.number.value

opportunity_account_description

Field label	Opportunity account description
Description	The description of the opportunity account
Field type	dimension
Data type	string.text.value

opportunity_time_to_closed_weeks

Field label	Opportunity age (weeks)
Description	The age of the opportunity in weeks
Field type	dimension
Data type	string.text.value

opportunity_value_range

Field label	Opportunity value range
Description	The value range the opportunity falls in
Field type	dimension
Data type	string.text.value

opportunity_amount

Field label	Amount
Description	The value of the opportunity
Field type	metric
Data type	float.currency.value

opportunity_amount_closed_won

Field label	Amount won
Description	The value of the won opportunities
Field type	metric
Data type	float.currency.value

opportunity_amount_closed_lost

Field label	Amount lost
Description	The value of the lost opportunities
Field type	metric
Data type	float.currency.value

opportunity_amount_proposal

Field label	Amount in proposals
Description	The value of the proposed opportunities
Field type	metric
Data type	float.currency.value

opportunity_amount_hit_rate

Field label	Amount hit rate
Description	The amount hit rate for opportunities
Field type	metric
Data type	float.number.percentage

opportunity_count

Field label	Opportunity count
Description	Total amount of opportunities
Field type	metric
Data type	int.number.value

opportunity_deal_count

Field label	Deal count
Description	Total close count for won opportunities
Field type	metric
Data type	int.number.value

opportunity_hit_rate

Field label	Hit rate
Description	The win rate for opportunities
Field type	metric
Data type	float.number.percentage

opportunity_avg_amount

Field label	Avg. amount per opportunity
Description	Average value of an opportunity
Field type	metric
Data type	float.currency.value

opportunity_avg_per_closed

Field label	Avg. amount per closed opportunity
Description	Average value of an opportunity
Field type	metric
Data type	float.currency.value

opportunity_time_to_closed

Field label	Age (days)
Description	The time it took in days to close the opportunity
Field type	metric
Data type	int.number.value
Aggregation	Non-aggregatable metric

OPPORTUNITY FIELD HISTORY

opportunity_field_history_id

Field label	Opportunity field history ID
Description	ID of the opportunity field history
Field type	dimension
Data type	string.text.value

opportunity_field_history_data_type

Field label	Opportunity field history data type
Description	Data type of the field that was changed
Field type	dimension
Data type	string.text.value

opportunity_field_history_field

Field label	Opportunity field history name
Description	Name of the field that was changed
Field type	dimension
Data type	string.text.value

opportunity_field_history_is_deleted

Field label	Opportunity field history is deleted
Description	Indicates whether the object has been moved to the Recycle Bin or not
Field type	dimension
Data type	bool

opportunity_field_history_created_date

Field label	Opportunity field history created date
Description	The date when the opportunity field history was created
Field type	dimension
Data type	string.time.date

opportunity_field_history_new_value

Field label	Opportunity field history new value
Description	The new value of the field that was changed
Field type	metric
Data type	string.text.value

opportunity_field_history_old_value

Field label	Opportunity field history old value
Description	The old value of the field that was changed
Field type	metric
Data type	string.text.value

OPPORTUNITY HISTORY

opportunity_history_id

Field label	Opportunity history ID
Description	ID of the opportunity history
Field type	dimension
Data type	string.text.value

opportunity_history_close_date

Field label	Opportunity history close date
Description	Date when the opportunity is expected to close
Field type	dimension
Data type	string.time.date

opportunity_history_prev_close_date

Field label	Opportunity history previous close date
Description	The value in the opportunity’s Close Date field before the update of the opportunity. In records created before Winter ’21, the value is null
Field type	dimension
Data type	string.time.date

opportunity_history_forecast_category

Field label	Opportunity history forecast category
Description	Category that determines the column in which an opportunity is totaled in a forecast
Field type	dimension
Data type	string.text.value

opportunity_history_is_deleted

Field label	Opportunity history is deleted
Description	Indicates whether the object has been moved to the Recycle Bin or not
Field type	dimension
Data type	bool

opportunity_history_stage

Field label	Opportunity history stage name
Description	Name of the stage of the opportunity (for example, Prospect or Proposal)
Field type	dimension
Data type	string.text.value

opportunity_history_created_date

Field label	Opportunity history created date
Description	The date when the opportunity history was created
Field type	dimension
Data type	string.time.date

opportunity_history_amount

Field label	Opportunity history amount
Description	Estimated total sale amount
Field type	metric
Data type	float.currency.value

opportunity_history_prev_amount

Field label	Opportunity history previous amount
Description	The value in the opportunity’s Amount field before the update of the opportunity. In records created before Winter ’21, the value is null
Field type	metric
Data type	float.currency.value

opportunity_history_expected_revenue

Field label	Opportunity history expected revenue
Description	Calculated revenue based on the Amount and Probability fields
Field type	metric
Data type	float.currency.value

opportunity_history_probability

Field label	Opportunity history probability
Description	Percentage of estimated confidence in closing the opportunity
Field type	metric
Data type	int.number.percentage

OPPORTUNITY PRODUCTS

opportunity_line_item_id

Field label	Opportunity product ID
Description	The opportunity product's ID
Field type	dimension
Data type	string.text.value

opportunity_line_item_name

Field label	Opportunity product name
Description	The Opportunity product's name
Field type	dimension
Data type	string.text.value

opportunity_line_item_description

Field label	Opportunity product description
Description	The Opportunity product's description
Field type	dimension
Data type	string.text.value

opportunity_line_item_discount

Field label	Opportunity product discount
Description	The Opportunity product's discount
Field type	dimension
Data type	string.text.percentage

opportunity_line_item_created_date

Field label	Opportunity product created date
Description	The date when the opportunity product was created
Field type	dimension
Data type	string.time.date

opportunity_line_item_updated_date

Field label	Opportunity product updated date
Description	The date when the opportunity product was updated
Field type	dimension
Data type	string.time.date

product_id

Field label	Product ID
Description	The product's ID
Field type	dimension
Data type	string.text.value

product_name

Field label	Product name
Description	The product's name
Field type	dimension
Data type	string.text.value

product_code

Field label	Product code
Description	The product's code
Field type	dimension
Data type	string.text.value

product_description

Field label	Product description
Description	The product's description
Field type	dimension
Data type	string.text.value

product_quantity

Field label	Opportunity product quantity
Description	The quantity of the opportunity product
Field type	metric
Data type	float.number.value

opportunity_line_item_total_price

Field label	Opportunity product total price
Description	The total price of the opportunity product
Field type	metric
Data type	float.currency.value

opportunity_line_item_unit_price

Field label	Opportunity product unit price
Description	The unit price of the opportunity product
Field type	metric
Data type	float.currency.value

opportunity_line_item_list_price

Field label	Opportunity product list price
Description	The list price of the opportunity product
Field type	metric
Data type	float.currency.value

opportunity_line_item_subtotal

Field label	Opportunity product subtotal
Description	The subtotal of the opportunity product
Field type	metric
Data type	float.currency.value

OPPORTUNITY SPLITS

opportunity_split_id

Field label	Opportunity split ID
Description	The ID of the opportunity split
Field type	dimension
Data type	string.text.value

opportunity_split_owner_name

Field label	Opportunity split owner
Description	Owner of the opportunity split
Field type	dimension
Data type	string.text.value

opportunity_split_percentage

Field label	Opportunity split percentage
Description	Opportunity split percentage that this team member will receive
Field type	dimension
Data type	float.number.percentage

opportunity_split_created_date

Field label	Opportunity split created date
Description	The date when the opportunity split was created
Field type	dimension
Data type	string.time.date

opportunity_split_updated_date

Field label	Opportunity split updated date
Description	The date when the opportunity split was updated
Field type	dimension
Data type	string.time.date

opportunity_split_amount

Field label	Opportunity split amount
Description	The value of the opportunity split
Field type	metric
Data type	float.currency.value

ORDER ITEMS

order_item_id

Field label	Order item ID
Description	Order item unique ID
Field type	dimension
Data type	string.text.value

order_item_description

Field label	Order item description
Description	Text description of order item
Field type	dimension
Data type	string.text.value

order_item_end_date

Field label	Order item end date
Description	Last day the order product is available
Field type	dimension
Data type	string.time.date

order_item_line_number

Field label	Line number
Description	Used to organize lines on the order
Field type	dimension
Data type	int.number.value

order_item_order_delivery_group_id

Field label	Order delivery group ID
Description	The delivery group for the order product
Field type	dimension
Data type	string.text.value

order_item_order_id

Field label	Order ID
Description	ID of the order that this order product is a child of
Field type	dimension
Data type	string.text.value

order_item_order_item_number

Field label	Order item number
Description	Automatically generated number that identifies the order product
Field type	dimension
Data type	string.text.value

order_item_original_order_item_id

Field label	Original order item ID
Description	ID of the original order product being reduced
Field type	dimension
Data type	string.text.value

order_item_pricebook_entry_id

Field label	Pricebook entry ID
Description	ID of the associated Pricebook Entry
Field type	dimension
Data type	string.text.value

order_item_product_id

Field label	Product ID
Description	ID of the Product associated with this order item
Field type	dimension
Data type	string.text.value

order_item_quote_line_item_id

Field label	Quote line item ID
Description	ID of the associated quote line item
Field type	dimension
Data type	string.text.value

order_item_related_order_item_id

Field label	Related order item ID
Description	For change orders shows the original order product
Field type	dimension
Data type	string.text.value

order_item_service_date

Field label	Service date
Description	Start date for the order product
Field type	dimension
Data type	string.time.date

order_item_type

Field label	Order item type
Description	Describes what the order item represents
Field type	dimension
Data type	string.text.value

order_item_type_code

Field label	Order item type code
Description	Code for the order product
Field type	dimension
Data type	string.text.value

order_item_created_date

Field label	Order item created date
Description	The date the order item was created
Field type	dimension
Data type	string.time.date

order_item_modified_date

Field label	Order item last modified date
Description	The date the order item was last modified
Field type	dimension
Data type	string.time.date

order_item_unit_price

Field label	Unit price
Description	Unit price for the order product
Field type	metric
Data type	float.currency.value

order_item_unit_price_eur

Field label	Unit price (EUR)
Description	Unit price for the order product converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_unit_price_usd

Field label	Unit price (USD)
Description	Unit price for the order product converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_unit_price_gbp

Field label	Unit price (GBP)
Description	Unit price for the order product converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_gross_unit_price

Field label	Gross unit price
Description	Unit price including tax
Field type	metric
Data type	float.currency.value

order_item_gross_unit_price_eur

Field label	Gross unit price (EUR)
Description	Unit price including tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_gross_unit_price_usd

Field label	Gross unit price (USD)
Description	Unit price including tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_gross_unit_price_gbp

Field label	Gross unit price (GBP)
Description	Unit price including tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_list_price

Field label	List price
Description	List price for the order product
Field type	metric
Data type	float.currency.value

order_item_list_price_eur

Field label	List price (EUR)
Description	List price for the order product converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_list_price_usd

Field label	List price (USD)
Description	List price for the order product converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_list_price_gbp

Field label	List price (GBP)
Description	List price for the order product converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_quantity

Field label	Quantity
Description	Number of units of this order product
Field type	metric
Data type	float.number.value

order_item_available_quantity

Field label	Available quantity
Description	Amount of an order product that is available to be reduced
Field type	metric
Data type	float.number.value

order_item_adjusted_line_amount

Field label	Adjusted line amount
Description	Line amount following line adjustments excluding tax
Field type	metric
Data type	float.currency.value

order_item_adjusted_line_amount_eur

Field label	Adjusted line amount (EUR)
Description	Line amount following line adjustments excluding tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_adjusted_line_amount_usd

Field label	Adjusted line amount (USD)
Description	Line amount following line adjustments excluding tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_adjusted_line_amount_gbp

Field label	Adjusted line amount (GBP)
Description	Line amount following line adjustments excluding tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_adjusted_line_amt_with_tax

Field label	Adjusted line amount with tax
Description	Line amount following line adjustments including tax
Field type	metric
Data type	float.currency.value

order_item_adjusted_line_amt_with_tax_eur

Field label	Adjusted line amount with tax (EUR)
Description	Line amount following line adjustments including tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_adjusted_line_amt_with_tax_usd

Field label	Adjusted line amount with tax (USD)
Description	Line amount following line adjustments including tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_adjusted_line_amt_with_tax_gbp

Field label	Adjusted line amount with tax (GBP)
Description	Line amount following line adjustments including tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_rounded_line_amount

Field label	Rounded line amount
Description	The rounded line amount before tax and adjustments
Field type	metric
Data type	float.currency.value

order_item_rounded_line_amount_eur

Field label	Rounded line amount (EUR)
Description	The rounded line amount before tax and adjustments converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_rounded_line_amount_usd

Field label	Rounded line amount (USD)
Description	The rounded line amount before tax and adjustments converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_rounded_line_amount_gbp

Field label	Rounded line amount (GBP)
Description	The rounded line amount before tax and adjustments converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_rounded_line_amt_with_tax

Field label	Rounded line amount with tax
Description	The rounded line amount including tax
Field type	metric
Data type	float.currency.value

order_item_rounded_line_amt_with_tax_eur

Field label	Rounded line amount with tax (EUR)
Description	The rounded line amount including tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_rounded_line_amt_with_tax_usd

Field label	Rounded line amount with tax (USD)
Description	The rounded line amount including tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_rounded_line_amt_with_tax_gbp

Field label	Rounded line amount with tax (GBP)
Description	The rounded line amount including tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjusted_line_tax_amount

Field label	Total adjusted line tax amount
Description	Sum of line tax amount and line adjustment tax amounts
Field type	metric
Data type	float.currency.value

order_item_total_adjusted_line_tax_amount_eur

Field label	Total adjusted line tax amount (EUR)
Description	Sum of line tax amount and line adjustment tax amounts converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjusted_line_tax_amount_usd

Field label	Total adjusted line tax amount (USD)
Description	Sum of line tax amount and line adjustment tax amounts converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjusted_line_tax_amount_gbp

Field label	Total adjusted line tax amount (GBP)
Description	Sum of line tax amount and line adjustment tax amounts converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_amount

Field label	Total adjustment amount
Description	Roll up of all the order product's price adjustments
Field type	metric
Data type	float.currency.value

order_item_total_adjustment_amount_eur

Field label	Total adjustment amount (EUR)
Description	Roll up of all the order product's price adjustments converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_amount_usd

Field label	Total adjustment amount (USD)
Description	Roll up of all the order product's price adjustments converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_amount_gbp

Field label	Total adjustment amount (GBP)
Description	Roll up of all the order product's price adjustments converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_amt_with_tax

Field label	Total adjustment amount with tax
Description	Roll up of all the order product's price adjustments including tax
Field type	metric
Data type	float.currency.value

order_item_total_adjustment_amt_with_tax_eur

Field label	Total adjustment amount with tax (EUR)
Description	Roll up of all the order product's price adjustments including tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_amt_with_tax_usd

Field label	Total adjustment amount with tax (USD)
Description	Roll up of all the order product's price adjustments including tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_amt_with_tax_gbp

Field label	Total adjustment amount with tax (GBP)
Description	Roll up of all the order product's price adjustments including tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_dist_amount

Field label	Total adjustment distributed amount
Description	Roll up of all adjustments on the order
Field type	metric
Data type	float.currency.value

order_item_total_adjustment_dist_amount_eur

Field label	Total adjustment distributed amount (EUR)
Description	Roll up of all adjustments on the order converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_dist_amount_usd

Field label	Total adjustment distributed amount (USD)
Description	Roll up of all adjustments on the order converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_dist_amount_gbp

Field label	Total adjustment distributed amount (GBP)
Description	Roll up of all adjustments on the order converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_dist_tax_amount

Field label	Total adjustment distributed tax amount
Description	Roll up of all adjustment tax amounts on the order
Field type	metric
Data type	float.currency.value

order_item_total_adjustment_dist_tax_amount_eur

Field label	Total adjustment distributed tax amount (EUR)
Description	Roll up of all adjustment tax amounts on the order converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_dist_tax_amount_usd

Field label	Total adjustment distributed tax amount (USD)
Description	Roll up of all adjustment tax amounts on the order converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_dist_tax_amount_gbp

Field label	Total adjustment distributed tax amount (GBP)
Description	Roll up of all adjustment tax amounts on the order converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_dist_amt_with_tax

Field label	Total adjustment distributed amount with tax
Description	Roll up of all adjustment tax amounts on the order including tax
Field type	metric
Data type	float.currency.value

order_item_total_adjustment_dist_amt_with_tax_eur

Field label	Total adjustment distributed amount with tax (EUR)
Description	Roll up of all adjustment tax amounts on the order including tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_dist_amt_with_tax_usd

Field label	Total adjustment distributed amount with tax (USD)
Description	Roll up of all adjustment tax amounts on the order including tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_dist_amt_with_tax_gbp

Field label	Total adjustment distributed amount with tax (GBP)
Description	Roll up of all adjustment tax amounts on the order including tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_tax_amount

Field label	Total adjustment tax amount
Description	Sum of all the order product's tax adjustments
Field type	metric
Data type	float.currency.value

order_item_total_adjustment_tax_amount_eur

Field label	Total adjustment tax amount (EUR)
Description	Sum of all the order product's tax adjustments converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_tax_amount_usd

Field label	Total adjustment tax amount (USD)
Description	Sum of all the order product's tax adjustments converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_adjustment_tax_amount_gbp

Field label	Total adjustment tax amount (GBP)
Description	Sum of all the order product's tax adjustments converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_amt_with_tax

Field label	Total amount with tax
Description	Equals TotalPrice + TotalTaxAmount for the order item
Field type	metric
Data type	float.currency.value

order_item_total_amt_with_tax_eur

Field label	Total amount with tax (EUR)
Description	Equals TotalPrice + TotalTaxAmount for the order item converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_amt_with_tax_usd

Field label	Total amount with tax (USD)
Description	Equals TotalPrice + TotalTaxAmount for the order item converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_amt_with_tax_gbp

Field label	Total amount with tax (GBP)
Description	Equals TotalPrice + TotalTaxAmount for the order item converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_adjustment_amount

Field label	Total line adjustment amount
Description	The sum of line level adjustments for the order product
Field type	metric
Data type	float.currency.value

order_item_total_line_adjustment_amount_eur

Field label	Total line adjustment amount (EUR)
Description	The sum of line level adjustments for the order product converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_adjustment_amount_usd

Field label	Total line adjustment amount (USD)
Description	The sum of line level adjustments for the order product converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_adjustment_amount_gbp

Field label	Total line adjustment amount (GBP)
Description	The sum of line level adjustments for the order product converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_adjustment_amt_with_tax

Field label	Total line adjustment amount with tax
Description	The sum of line level adjustments for the order product including tax
Field type	metric
Data type	float.currency.value

order_item_total_line_adjustment_amt_with_tax_eur

Field label	Total line adjustment amount with tax (EUR)
Description	The sum of line level adjustments for the order product including tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_adjustment_amt_with_tax_usd

Field label	Total line adjustment amount with tax (USD)
Description	The sum of line level adjustments for the order product including tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_adjustment_amt_with_tax_gbp

Field label	Total line adjustment amount with tax (GBP)
Description	The sum of line level adjustments for the order product including tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_adjustment_tax_amount

Field label	Total line adjustment tax amount
Description	Total tax amount for adjustments made to the order product
Field type	metric
Data type	float.currency.value

order_item_total_line_adjustment_tax_amount_eur

Field label	Total line adjustment tax amount (EUR)
Description	Total tax amount for adjustments made to the order product converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_adjustment_tax_amount_usd

Field label	Total line adjustment tax amount (USD)
Description	Total tax amount for adjustments made to the order product converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_adjustment_tax_amount_gbp

Field label	Total line adjustment tax amount (GBP)
Description	Total tax amount for adjustments made to the order product converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_amount

Field label	Total line amount
Description	The total price of the order product before price adjustments inclusive of quantity
Field type	metric
Data type	float.currency.value

order_item_total_line_amount_eur

Field label	Total line amount (EUR)
Description	The total price of the order product before price adjustments inclusive of quantity converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_amount_usd

Field label	Total line amount (USD)
Description	The total price of the order product before price adjustments inclusive of quantity converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_amount_gbp

Field label	Total line amount (GBP)
Description	The total price of the order product before price adjustments inclusive of quantity converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_tax_amount

Field label	Total line tax amount
Description	Total tax amount for this order product excluding tax on adjustments
Field type	metric
Data type	float.currency.value

order_item_total_line_tax_amount_eur

Field label	Total line tax amount (EUR)
Description	Total tax amount for this order product excluding tax on adjustments converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_tax_amount_usd

Field label	Total line tax amount (USD)
Description	Total tax amount for this order product excluding tax on adjustments converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_line_tax_amount_gbp

Field label	Total line tax amount (GBP)
Description	Total tax amount for this order product excluding tax on adjustments converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_price

Field label	Total price
Description	Total price for this order product
Field type	metric
Data type	float.currency.value

order_item_total_price_eur

Field label	Total price (EUR)
Description	Total price for this order product converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_price_usd

Field label	Total price (USD)
Description	Total price for this order product converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_price_gbp

Field label	Total price (GBP)
Description	Total price for this order product converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_tax_amount

Field label	Total tax amount
Description	Sum of the order product's tax and any adjustments
Field type	metric
Data type	float.currency.value

order_item_total_tax_amount_eur

Field label	Total tax amount (EUR)
Description	Sum of the order product's tax and any adjustments converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_tax_amount_usd

Field label	Total tax amount (USD)
Description	Sum of the order product's tax and any adjustments converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_item_total_tax_amount_gbp

Field label	Total tax amount (GBP)
Description	Sum of the order product's tax and any adjustments converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

ORDERS

order_id

Field label	Order ID
Description	Order unique ID
Field type	dimension
Data type	string.text.value

order_number

Field label	Order number
Description	Order number assigned to this order, not the unique system generated ID assigned during creation
Field type	dimension
Data type	string.text.value

order_reference_number

Field label	Order reference number
Description	Order reference number assigned to this order
Field type	dimension
Data type	string.text.value

order_name

Field label	Order name
Description	Name for this order
Field type	dimension
Data type	string.text.value

order_description

Field label	Order description
Description	Description of the order
Field type	dimension
Data type	string.text.value

order_status

Field label	Order status
Description	Picklist of values that indicate order status. Each value is within one of two status categories defined in StatusCode
Field type	dimension
Data type	string.text.value

order_status_code

Field label	Order status code
Description	The status category for the order
Field type	dimension
Data type	string.text.value

order_type

Field label	Order type
Description	If you want to show more information about your order, you can add custom values to the Type picklist. By default the Type field doesn't perform any actions or show any values
Field type	dimension
Data type	string.text.value

order_ordered_date

Field label	Ordered time
Description	The date and time that the order was placed
Field type	dimension
Data type	string.time.datetime

order_end_date

Field label	End date
Description	Date at which the order ends
Field type	dimension
Data type	string.time.date

order_activated_date

Field label	Order activated time
Description	Date and time when the order was activated
Field type	dimension
Data type	string.time.datetime

order_billing_address

Field label	Order billing address
Description	Billing address
Field type	dimension
Data type	string.text.value

order_billing_city

Field label	Order billing city
Description	City for the billing address for this order
Field type	dimension
Data type	string.geo.city

order_billing_country

Field label	Order billing country
Description	Country for the billing address for this order
Field type	dimension
Data type	string.geo.country

order_billing_country_code

Field label	Order billing country code
Description	ISO country code for the billing address for this order
Field type	dimension
Data type	string.geo.country.twolettercode

order_billing_email_address

Field label	Order billing email address
Description	Email address for this order's billing address
Field type	dimension
Data type	string.text.email

order_billing_geocode_accuracy

Field label	Order billing geocode accuracy
Description	Accuracy level of the geocode of the address
Field type	dimension
Data type	string.text.value

order_billing_latitude

Field label	Order billing latitude
Description	Used with longitude to specify the precise geolocation of a billing address
Field type	dimension
Data type	string.geo.latitude

order_billing_longitude

Field label	Order billing longitude
Description	Used with latitude to specify the precise geolocation of a billing address
Field type	dimension
Data type	string.geo.longitude

order_billing_phone_number

Field label	Order billing phone number
Description	Phone number for this order's billing address
Field type	dimension
Data type	string.text.phone

order_billing_postal_code

Field label	Order billing postal code
Description	Postal code for the billing address for this order
Field type	dimension
Data type	string.geo.zip

order_billing_state

Field label	Order billing state
Description	State for the billing address for this order
Field type	dimension
Data type	string.text.value

order_billing_state_code

Field label	Order billing state code
Description	ISO state code for the order's billing address
Field type	dimension
Data type	string.text.value

order_billing_street

Field label	Order billing street
Description	Street address for the billing address
Field type	dimension
Data type	string.geo.street

order_bill_to_contact_id

Field label	Bill to contact ID
Description	ID of the contact that the order is billed to
Field type	dimension
Data type	string.text.value

order_company_authorized_by_id

Field label	Company authorized by ID
Description	ID of the user who authorized the account associated with the order
Field type	dimension
Data type	string.text.value

order_company_authorized_date

Field label	Company authorized date
Description	The date on which your organization authorized the order
Field type	dimension
Data type	string.time.date

order_contract_id

Field label	Contract ID
Description	ID of the contract associated with this order
Field type	dimension
Data type	string.text.value

order_currency_iso_code

Field label	Currency iso code
Description	Three letter ISO 4217 currency code
Field type	dimension
Data type	string.currency.code

order_customer_authorized_by_id

Field label	Customer authorized by ID
Description	ID of the contact who authorized the order
Field type	dimension
Data type	string.text.value

order_customer_authorized_date

Field label	Customer authorized date
Description	Date on which the contact authorized the order
Field type	dimension
Data type	string.time.date

order_effective_date

Field label	Effective date
Description	Date at which the order becomes effective
Field type	dimension
Data type	string.time.date

order_is_reduction_order

Field label	Is reduction order
Description	Determines whether an order is a reduction order
Field type	dimension
Data type	bool

order_last_referenced_date

Field label	Order last referenced time
Description	The timestamp when the current user last accessed this record, a record related to this record or a list view
Field type	dimension
Data type	string.time.datetime

order_last_viewed_date

Field label	Order last viewed time
Description	The timestamp when the current user last viewed this record or list view
Field type	dimension
Data type	string.time.datetime

order_original_order_id

Field label	Original order ID
Description	Optional ID of the original order that a reduction order is reducing, if the reduction order is reducing a single order
Field type	dimension
Data type	string.text.value

order_owner_id

Field label	Owner ID
Description	ID of the User or queue that owns this order
Field type	dimension
Data type	string.text.value

order_po_date

Field label	Po date
Description	Date of the purchase order
Field type	dimension
Data type	string.time.date

order_po_number

Field label	Po number
Description	Number identifying the purchase order
Field type	dimension
Data type	string.text.value

order_pricebook_id

Field label	Pricebook ID
Description	ID of the price book associated with this order
Field type	dimension
Data type	string.text.value

order_quote_id

Field label	Quote ID
Description	ID of the quote that's associated with this order
Field type	dimension
Data type	string.text.value

order_record_type_id

Field label	Record type ID
Description	ID of the record type assigned to this order
Field type	dimension
Data type	string.text.value

order_related_order_id

Field label	Related order ID
Description	The original order that a change order was created from
Field type	dimension
Data type	string.text.value

order_sales_channel_id

Field label	Sales channel ID
Description	Reference to a sales channel entity
Field type	dimension
Data type	string.text.value

order_shipping_address

Field label	Order shipping address
Description	Shipping address for the order
Field type	dimension
Data type	string.text.value

order_shipping_city

Field label	Order shipping city
Description	City of the shipping address
Field type	dimension
Data type	string.geo.city

order_shipping_country

Field label	Order shipping country
Description	Country of the shipping address
Field type	dimension
Data type	string.geo.country

order_shipping_country_code

Field label	Shipping country code
Description	ISO country code for the order's shipping address
Field type	dimension
Data type	string.geo.country.twolettercode

order_shipping_geocode_accuracy

Field label	Order shipping geocode accuracy
Description	Accuracy level of the geocode of the shipping address
Field type	dimension
Data type	string.text.value

order_shipping_latitude

Field label	Order shipping latitude
Description	Used with longitude to specify the precise geolocation of a shipping address
Field type	dimension
Data type	string.geo.latitude

order_shipping_longitude

Field label	Order shipping longitude
Description	Used with latitude to specify the precise geolocation of an address
Field type	dimension
Data type	string.geo.longitude

order_shipping_postal_code

Field label	Order shipping postal code
Description	Postal code of the shipping address
Field type	dimension
Data type	string.geo.zip

order_shipping_state

Field label	Order shipping state
Description	State of the shipping address
Field type	dimension
Data type	string.text.value

order_shipping_state_code

Field label	Order shipping state code
Description	ISO state code for the order's shipping address
Field type	dimension
Data type	string.text.value

order_shipping_street

Field label	Order shipping street
Description	Street address of the shipping address
Field type	dimension
Data type	string.geo.street

order_ship_to_contact_id

Field label	Ship to contact ID
Description	ID of the contact that the order is shipped to
Field type	dimension
Data type	string.text.value

order_tax_locale_type

Field label	Tax locale type
Description	The type of tax calculation that Salesforce uses for the order’s order items. VAT regions use gross tax, which includes tax in all sale amounts. US regions use net tax, which calculates tax separately from the initial sale amount and then adds the sale and tax amounts together in a total
Field type	dimension
Data type	string.text.value

order_created_date

Field label	Order created date
Description	The date the order was created
Field type	dimension
Data type	string.time.date

order_last_modified_date

Field label	Order last modified date
Description	The date the order was last modified
Field type	dimension
Data type	string.time.date

order_total_amount

Field label	Total amount
Description	The total amount for the order products associated with this order
Field type	metric
Data type	float.currency.value

order_total_amount_eur

Field label	Total amount (EUR)
Description	The total amount for the order products associated with this order converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_amount_usd

Field label	Total amount (USD)
Description	The total amount for the order products associated with this order converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_amount_gbp

Field label	Total amount (GBP)
Description	The total amount for the order products associated with this order converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_tax_amount

Field label	Total tax amount
Description	Roll up of all tax on the order. Includes delivery taxes price, adjustment taxes and product taxes
Field type	metric
Data type	float.currency.value

order_total_tax_amount_eur

Field label	Total tax amount (EUR)
Description	Roll up of all tax on the order. Includes delivery taxes price, adjustment taxes and product taxes converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_tax_amount_usd

Field label	Total tax amount (USD)
Description	Roll up of all tax on the order. Includes delivery taxes price, adjustment taxes and product taxes converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_tax_amount_gbp

Field label	Total tax amount (GBP)
Description	Roll up of all tax on the order. Includes delivery taxes price, adjustment taxes and product taxes converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adj_delivery_amt_with_tax

Field label	Total adjusted delivery amount with tax
Description	Sum of product line amounts, line adjustments, and tax. Order products with null Type fields aren’t included
Field type	metric
Data type	float.currency.value

order_total_adj_delivery_amt_with_tax_eur

Field label	Total adjusted delivery amount with tax (EUR)
Description	Sum of product line amounts, line adjustments, and tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adj_delivery_amt_with_tax_usd

Field label	Total adjusted delivery amount with tax (USD)
Description	Sum of product line amounts, line adjustments, and tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adj_delivery_amt_with_tax_gbp

Field label	Total adjusted delivery amount with tax (GBP)
Description	Sum of product line amounts, line adjustments, and tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adj_product_amt_with_tax

Field label	Total adjusted product amount with tax
Description	Sum of product line amounts, line adjustments, and tax. Order products with null Type fields aren't included
Field type	metric
Data type	float.currency.value

order_total_adj_product_amt_with_tax_eur

Field label	Total adjusted product amount with tax (EUR)
Description	Sum of product line amounts, line adjustments, and tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adj_product_amt_with_tax_usd

Field label	Total adjusted product amount with tax (USD)
Description	Sum of product line amounts, line adjustments, and tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adj_product_amt_with_tax_gbp

Field label	Total adjusted product amount with tax (GBP)
Description	Sum of product line amounts, line adjustments, and tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_delivery_amount

Field label	Total adjusted delivery amount
Description	Sum of delivery line amounts and delivery line adjustments. Order products with null Type fields aren't included
Field type	metric
Data type	float.currency.value

order_total_adjusted_delivery_amount_eur

Field label	Total adjusted delivery amount (EUR)
Description	Sum of delivery line amounts and delivery line adjustments converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_delivery_amount_usd

Field label	Total adjusted delivery amount (USD)
Description	Sum of delivery line amounts and delivery line adjustments converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_delivery_amount_gbp

Field label	Total adjusted delivery amount (GBP)
Description	Sum of delivery line amounts and delivery line adjustments converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_delivery_tax_amount

Field label	Total adjusted delivery tax amount
Description	Sum of delivery line tax amounts and delivery line tax adjustments
Field type	metric
Data type	float.currency.value

order_total_adjusted_delivery_tax_amount_eur

Field label	Total adjusted delivery tax amount (EUR)
Description	Sum of delivery line tax amounts and delivery line tax adjustments converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_delivery_tax_amount_usd

Field label	Total adjusted delivery tax amount (USD)
Description	Sum of delivery line tax amounts and delivery line tax adjustments converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_delivery_tax_amount_gbp

Field label	Total adjusted delivery tax amount (GBP)
Description	Sum of delivery line tax amounts and delivery line tax adjustments converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_product_amount

Field label	Total adjusted product amount
Description	Sum of product line amounts and line adjustments. Order products with null Type fields aren't included
Field type	metric
Data type	float.currency.value

order_total_adjusted_product_amount_eur

Field label	Total adjusted product amount (EUR)
Description	Sum of product line amounts and line adjustments converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_product_amount_usd

Field label	Total adjusted product amount (USD)
Description	Sum of product line amounts and line adjustments converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_product_amount_gbp

Field label	Total adjusted product amount (GBP)
Description	Sum of product line amounts and line adjustments converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_product_tax_amount

Field label	Total adjusted product tax amount
Description	Sum of line tax amounts and line tax adjustments. Order products with null Type fields aren't included
Field type	metric
Data type	float.currency.value

order_total_adjusted_product_tax_amount_eur

Field label	Total adjusted product tax amount (EUR)
Description	Sum of line tax amounts and line tax adjustments converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_product_tax_amount_usd

Field label	Total adjusted product tax amount (USD)
Description	Sum of line tax amounts and line tax adjustments converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_adjusted_product_tax_amount_gbp

Field label	Total adjusted product tax amount (GBP)
Description	Sum of line tax amounts and line tax adjustments converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_grand_total_amount

Field label	Grand total amount
Description	Sum of "Total amount" and "Total tax amount"
Field type	metric
Data type	float.currency.value

order_grand_total_amount_eur

Field label	Grand total amount (EUR)
Description	Sum of "Total amount" and "Total tax amount" converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_grand_total_amount_usd

Field label	Grand total amount (USD)
Description	Sum of "Total amount" and "Total tax amount" converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_grand_total_amount_gbp

Field label	Grand total amount (GBP)
Description	Sum of "Total amount" and "Total tax amount" converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_delivery_adj_dist_amount

Field label	Total delivery adjustment distributed amounts
Description	Roll up of the order's delivery adjustment distributed amounts
Field type	metric
Data type	float.currency.value

order_total_delivery_adj_dist_amount_eur

Field label	Total delivery adjustment distributed amounts (EUR)
Description	Roll up of the order's delivery adjustment distributed amounts converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_delivery_adj_dist_amount_usd

Field label	Total delivery adjustment distributed amounts (USD)
Description	Roll up of the order's delivery adjustment distributed amounts converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_delivery_adj_dist_amount_gbp

Field label	Total delivery adjustment distributed amounts (GBP)
Description	Roll up of the order's delivery adjustment distributed amounts converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_delivery_adj_dist_amt_with_tax

Field label	Total delivery adjustment distributed amounts with tax
Description	Roll up of the order's delivery adjustment distributed amounts and tax
Field type	metric
Data type	float.currency.value

order_total_delivery_adj_dist_amt_with_tax_eur

Field label	Total delivery adjustment distributed amounts with tax (EUR)
Description	Roll up of the order's delivery adjustment distributed amounts and tax converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_delivery_adj_dist_amt_with_tax_usd

Field label	Total delivery adjustment distributed amounts with tax (USD)
Description	Roll up of the order's delivery adjustment distributed amounts and tax converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_delivery_adj_dist_amt_with_tax_gbp

Field label	Total delivery adjustment distributed amounts with tax (GBP)
Description	Roll up of the order's delivery adjustment distributed amounts and tax converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_delivery_adj_dist_tax_amount

Field label	Total delivery adjustment distributed tax amounts
Description	Roll up of the order's delivery adjustment distributed tax amounts
Field type	metric
Data type	float.currency.value

order_total_delivery_adj_dist_tax_amount_eur

Field label	Total delivery adjustment distributed tax amounts (EUR)
Description	Roll up of the order's delivery adjustment distributed tax amounts converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_delivery_adj_dist_tax_amount_usd

Field label	Total delivery adjustment distributed tax amounts (USD)
Description	Roll up of the order's delivery adjustment distributed tax amounts converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_delivery_adj_dist_tax_amount_gbp

Field label	Total delivery adjustment distributed tax amounts (GBP)
Description	Roll up of the order's delivery adjustment distributed tax amounts converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_product_adj_dist_amount

Field label	Total product adjustment distributed amounts
Description	Roll up of the order's product adjustment distributed amounts. Order products with null Type fields aren't included
Field type	metric
Data type	float.currency.value

order_total_product_adj_dist_amount_eur

Field label	Total product adjustment distributed amounts (EUR)
Description	Roll up of the order's product adjustment distributed amounts converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_product_adj_dist_amount_usd

Field label	Total product adjustment distributed amounts (USD)
Description	Roll up of the order's product adjustment distributed amounts converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_product_adj_dist_amount_gbp

Field label	Total product adjustment distributed amounts (GBP)
Description	Roll up of the order's product adjustment distributed amounts converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_product_adj_dist_amt_with_tax

Field label	Total product adjustment distributed amounts with tax
Description	Roll up of the order's product adjustment distributed amounts. Order products with null Type fields aren't included
Field type	metric
Data type	float.currency.value

order_total_product_adj_dist_amt_with_tax_eur

Field label	Total product adjustment distributed amounts with tax (EUR)
Description	Roll up of the order's product adjustment distributed amounts converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_product_adj_dist_amt_with_tax_usd

Field label	Total product adjustment distributed amounts with tax (USD)
Description	Roll up of the order's product adjustment distributed amounts converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_product_adj_dist_amt_with_tax_gbp

Field label	Total product adjustment distributed amounts with tax (GBP)
Description	Roll up of the order's product adjustment distributed amounts converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_product_adj_dist_tax_amount

Field label	Total product adjustment distributed tax amount
Description	Roll up of the order's product adjustment distributed tax amounts. Order products with null Type fields aren't included
Field type	metric
Data type	float.currency.value

order_total_product_adj_dist_tax_amount_eur

Field label	Total product adjustment distributed tax amount (EUR)
Description	Roll up of the order's product adjustment distributed tax amounts converted to EUR
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_product_adj_dist_tax_amount_usd

Field label	Total product adjustment distributed tax amount (USD)
Description	Roll up of the order's product adjustment distributed tax amounts converted to USD
Field type	metric
Data type	float.currency.value
Services	Currency conversion

order_total_product_adj_dist_tax_amount_gbp

Field label	Total product adjustment distributed tax amount (GBP)
Description	Roll up of the order's product adjustment distributed tax amounts converted to GBP
Field type	metric
Data type	float.currency.value
Services	Currency conversion

ORGANIZATION

organization_name

Field label	Organization name
Field type	dimension
Data type	string.text.value

QUERY

system_metadata.query_date_range_start

Field label	Start date
Description	The start date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_date_range_end

Field label	End date
Description	The end date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_timezone

Field label	Timezone
Description	The timezone that is supplied to the query
Field type	dimension
Data type	string.time.timezone

system_metadata.query_filters

Field label	Filters
Description	All filters used in the query
Field type	dimension
Data type	string.text.json

system_metadata.query_date_start

Field label	Start
Description	When the query was started
Field type	dimension
Data type	string.time.datetime

system_metadata.query_date_end

Field label	End
Description	When the query completed
Field type	dimension
Data type	string.time.datetime

system_metadata.query_duration

Field label	Duration
Description	The duration in seconds of the query
Field type	dimension
Data type	int.duration.seconds

system_metadata.query_accounts

Field label	Accounts
Description	A list of accounts of which the data was pulled from
Field type	dimension
Data type	string.text.json

SERVICE CONTRACTS

service_contract_id

Field label	Service contract ID
Description	Service contract unique ID
Field type	dimension
Data type	string.text.value

service_contract_account_id

Field label	Account ID
Description	ID of the account associated with the service contract
Field type	dimension
Data type	string.text.value

service_contract_activation_date

Field label	Service contract activation time
Description	The initial day the service contract went into effect
Field type	dimension
Data type	string.time.datetime

service_contract_approval_status

Field label	Approval status
Description	Approval status of the service contract
Field type	dimension
Data type	string.text.value

service_contract_billing_address

Field label	Service contract billing address
Description	The compound form of the billing address
Field type	dimension
Data type	string.text.value

service_contract_billing_city

Field label	Service contract billing city
Description	Details for the billing address
Field type	dimension
Data type	string.geo.city

service_contract_billing_country

Field label	Service contract billing country
Description	Details for the billing address
Field type	dimension
Data type	string.geo.country

service_contract_billing_country_code

Field label	Service contract billing country code
Description	The ISO country code for the service contract's billing address
Field type	dimension
Data type	string.geo.country.twolettercode

service_contract_billing_latitude

Field label	Service contract billing latitude
Description	Used with longitude to specify the precise geolocation of a billing address
Field type	dimension
Data type	string.geo.latitude

service_contract_billing_longitude

Field label	Service contract billing longitude
Description	Used with latitude to specify the precise geolocation of a billing address
Field type	dimension
Data type	string.geo.longitude

service_contract_billing_postal_code

Field label	Service contract billing postal code
Description	Details for the billing address
Field type	dimension
Data type	string.geo.zip

service_contract_billing_state

Field label	Service contract billing state
Description	Details for the billing address
Field type	dimension
Data type	string.text.value

service_contract_billing_state_code

Field label	Service contract billing state code
Description	The ISO state code for the service contract's billing address
Field type	dimension
Data type	string.text.value

service_contract_billing_street

Field label	Service contract billing street
Description	Street address for the billing address
Field type	dimension
Data type	string.geo.street

service_contract_contact_id

Field label	Contact ID
Description	ID of the Contact associated with the service contract
Field type	dimension
Data type	string.text.value

service_contract_number

Field label	Contract number
Description	Unique number automatically assigned to the service contract
Field type	dimension
Data type	string.text.value

service_contract_description

Field label	Service Contract description
Description	Description of the service contract
Field type	dimension
Data type	string.text.value

service_contract_discount

Field label	Service contract discount
Description	Discount percentage applied to service contract
Field type	dimension
Data type	float.number.percentage

service_contract_end_date

Field label	Service contract end date
Description	The last day the service contract is in effect
Field type	dimension
Data type	string.time.date

service_contract_is_deleted

Field label	Service contract is deleted
Description	Indicates whether the object has been moved to the Recycle Bin
Field type	dimension
Data type	bool

service_contract_last_referenced_date

Field label	Service contract last referenced date
Description	The timestamp when the current user last accessed this record, a record related to this record, or a list view
Field type	dimension
Data type	string.time.date

service_contract_last_viewed_date

Field label	Service contract last viewed date
Description	The timestamp when the current user last viewed this record or list view. If this value is null, the user might have only accessed this record or list view last referenced date but not viewed it
Field type	dimension
Data type	string.time.date

service_contract_name

Field label	Service contract name
Description	Name of the service contract
Field type	dimension
Data type	string.text.value

service_contract_owner_id

Field label	Owner ID
Description	The ID of the user who currently owns the service contract
Field type	dimension
Data type	string.text.value

service_contract_parent_service_contract_id

Field label	Parent service contract ID
Description	The service contract's parent service contract, if it has one
Field type	dimension
Data type	string.text.value

service_contract_pricebook_id

Field label	Pricebook ID
Description	ID of the Pricebook associated with the service contract
Field type	dimension
Data type	string.text.value

service_contract_root_service_contract_id

Field label	Root service contract ID
Description	Read only The top-level service contract in a service contract hierarchy. Depending on where a service contract lies in the hierarchy, its root could be the same as its parent
Field type	dimension
Data type	string.text.value

service_contract_shipping_address

Field label	Service contract shipping address
Description	The compound form of the shipping address
Field type	dimension
Data type	string.text.value

service_contract_shipping_city

Field label	Service contract shipping city
Description	Details of the shipping address
Field type	dimension
Data type	string.geo.city

service_contract_shipping_country

Field label	Service contract shipping country
Description	Details of the shipping address
Field type	dimension
Data type	string.geo.country

service_contract_shipping_country_code

Field label	Service contract shipping country code
Description	The ISO country code for the service contract's shipping address
Field type	dimension
Data type	string.geo.country.twolettercode

service_contract_shipping_latitude

Field label	Service contract shipping latitude
Description	Used with longitude to specify the precise geolocation of a shipping address
Field type	dimension
Data type	string.geo.latitude

service_contract_shipping_longitude

Field label	Service contract shipping longitude
Description	Used with latitude to specify the precise geolocation of an address
Field type	dimension
Data type	string.geo.longitude

service_contract_shipping_postal_code

Field label	Service contract shipping postal code
Description	Details of the shipping address
Field type	dimension
Data type	string.geo.zip

service_contract_shipping_state

Field label	Service contract shipping state
Description	Details of the shipping address
Field type	dimension
Data type	string.text.value

service_contract_shipping_state_code

Field label	Service contract shipping state code
Description	The ISO state code for the service contract's shipping address
Field type	dimension
Data type	string.text.value

service_contract_shipping_street

Field label	Service contract shipping street
Description	The street address of the shipping address
Field type	dimension
Data type	string.geo.street

service_contract_special_terms

Field label	Special terms
Description	Any terms specifically agreed to and tracked in the service contract
Field type	dimension
Data type	string.text.value

service_contract_start_date

Field label	Service contract start date
Description	The first day the service contract is in effect
Field type	dimension
Data type	string.time.date

service_contract_status

Field label	Service contract status
Description	The status of the service contract, such as Inactive
Field type	dimension
Data type	string.text.value

service_contract_created_date

Field label	Service contract created date
Description	The date the service contract was created
Field type	dimension
Data type	string.time.date

service_contract_last_modified_date

Field label	Service contract last modified date
Description	The date the service contract was last modified
Field type	dimension
Data type	string.time.date

service_contract_grand_total

Field label	Service contract grand total
Description	Total price of the service contract plus shipping and taxes
Field type	metric
Data type	float.currency.value

service_contract_line_item_count

Field label	Line item count
Description	Number of ContractLineItem records associated with the service contract
Field type	metric
Data type	int.number.value

service_contract_subtotal

Field label	Service contract subtotal
Description	Total of the service contract line items products before discounts, taxes, and shipping are applied
Field type	metric
Data type	float.currency.value

service_contract_tax

Field label	Service contract tax
Description	Total taxes for the service contract
Field type	metric
Data type	float.currency.value

service_contract_term

Field label	Service contract term
Description	Number of months that the service contract is valid
Field type	metric
Data type	int.number.value

service_contract_total_price

Field label	Service contract total price
Description	Total of the contract line items products after discounts and before taxes and shipping
Field type	metric
Data type	float.currency.value

TASKS

task_id

Field label	Task ID
Description	The unique identifier for the task
Field type	dimension
Data type	string.text.value

task_subject

Field label	Task subject
Description	The subject of the task
Field type	dimension
Data type	string.text.value

task_is_closed

Field label	Task is completed
Description	Whether of not the task is completed
Field type	dimension
Data type	bool

task_who_id

Field label	Task name ID
Description	The unique identifier of the person who is associated with the task
Field type	dimension
Data type	string.text.value

task_what_id

Field label	Task related to ID
Description	Related To ID
Field type	dimension
Data type	string.text.value

task_activity_date

Field label	Task due date
Description	The date the task is due
Field type	dimension
Data type	string.time.date

task_status

Field label	Task status
Description	The status of the task
Field type	dimension
Data type	string.text.value

task_priority

Field label	Task priority
Description	The task priority
Field type	dimension
Data type	string.text.value

task_is_high_priority

Field label	Task is high priority
Description	Whether the task is high priority or not
Field type	dimension
Data type	bool

task_owner_id

Field label	Task assigned to ID
Description	The person to whom the task has been assigned
Field type	dimension
Data type	string.text.value

task_owner

Field label	Task owner
Description	The owner of the task
Field type	dimension
Data type	string.text.value

task_description

Field label	Task description
Description	The task description
Field type	dimension
Data type	string.text.value

task_type

Field label	Task type
Description	The type of the task
Field type	dimension
Data type	string.text.value

task_is_deleted

Field label	Task is deleted
Description	Whether the task is deleted or not
Field type	dimension
Data type	bool

task_account_id

Field label	Task account ID
Description	The account the task is associated with
Field type	dimension
Data type	string.text.value

task_created_date

Field label	Task created date
Description	The date the task was created
Field type	dimension
Data type	string.time.date

task_created_by_id

Field label	Task created by ID
Description	The unique identifier of the person who created the task
Field type	dimension
Data type	string.text.value

task_last_modified_date

Field label	Task last modified date
Description	The date when the task was last modified
Field type	dimension
Data type	string.time.date

task_last_modified_by_id

Field label	Task last modified by ID
Description	The unique identifier of the person who last modified the task
Field type	dimension
Data type	string.text.value

task_is_archived

Field label	Task is archived
Description	Whether the task is archived or not
Field type	dimension
Data type	bool

task_call_type

Field label	Task call type
Description	The call type of the task
Field type	dimension
Data type	string.text.value

task_call_disposition

Field label	Task call result
Description	The result of the task call
Field type	dimension
Data type	string.text.value

task_call_object

Field label	Task call object identifier
Description	The unique identifier of the call object
Field type	dimension
Data type	string.text.value

task_reminder_date_time

Field label	Task reminder date & time
Description	The date and time for the task reminder
Field type	dimension
Data type	string.time.datetime

task_is_reminder_set

Field label	Task has a reminder
Description	Whether or not the task has a reminder
Field type	dimension
Data type	bool

task_recurrence_activity_id

Field label	Task recurrence activity ID
Description	The unique identifier for the task's recurrence activity
Field type	dimension
Data type	string.text.value

task_is_recurrence

Field label	Task has recurring series of tasks
Description	Whether or not the original tasks has a series of recurring tasks
Field type	dimension
Data type	bool

task_recurrence_start_date_only

Field label	Task recurrence start date
Description	The date when the task recurrence starts
Field type	dimension
Data type	string.time.date

task_recurrence_end_date_only

Field label	Task recurrence end date
Description	The date when the task recurrence ends
Field type	dimension
Data type	string.time.date

task_recurrence_time_zone_sid_key

Field label	Task recurrence time zone
Description	The time zone for the task recurrence
Field type	dimension
Data type	string.text.value

task_recurrence_type

Field label	Task recurrence type
Description	The recurrence type for the task
Field type	dimension
Data type	string.text.value

task_recurrence_interval

Field label	Task recurrence interval
Description	The interval with which the task recurs
Field type	dimension
Data type	int.number.value

task_recurrence_day_of_week_mask

Field label	Task recurrence day of week
Description	The task recurrence day of week
Field type	dimension
Data type	int.number.value

task_recurrence_day_of_month

Field label	Task recurrence day of month
Description	The task recurrence day of month
Field type	dimension
Data type	int.number.value

task_recurrence_instance

Field label	Task recurrence instance
Description	The recurrence instance for the task
Field type	dimension
Data type	string.text.value

task_recurrence_month_of_year

Field label	Task recurrence month of year
Description	The task recurrence month of year
Field type	dimension
Data type	string.text.value

task_recurrence_regenerated_type

Field label	Repeat this task
Description	When to repeat this task
Field type	dimension
Data type	string.text.value

task_task_subtype

Field label	Task subtype
Description	The subtype of the task
Field type	dimension
Data type	string.text.value

task_call_duration_in_seconds

Field label	Task call duration
Description	The duration of the task call in seconds
Field type	metric
Data type	int.number.value

TIME

today

Field label	Today
Description	Today's date, e.g. 2017-01-31
Field type	dimension
Data type	string.time.date
Destinations	API, Data warehouse

year_created

Field label	Year
Field type	dimension
Data type	string.time.year

yearOfWeek_created

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

yearOfWeekIso_created

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

yearMonth_created

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

month_created

Field label	Month
Field type	dimension
Data type	string.time.month

yearWeek_created

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

yearWeekIso_created

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

week_created

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

weekIso_created

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

dayOfMonth_created

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

dayOfWeek_created

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

dayOfWeekIso_created

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

date_created

Field label	Date
Field type	dimension
Data type	string.time.date