Odoo CRM fields

  • Updated on Nov 25, 2025
  • Published on Nov 25, 2025
Prev Next

Supermetrics brings all your Odoo CRM data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

Early Access3 metrics52 dimensions

CONTACT INFORMATION

lead_contact
Field label Lead contact
Description The contact of the lead
Field type dimension
Data type string.text.value
lead_email
Field label Lead email
Description Email of the lead
Field type dimension
Data type string.text.email
lead_phone
Field label Lead phone
Description Lead phone number
Field type dimension
Data type string.text.phone
lead_company_name
Field label Lead company name
Description The name of the future partner company that will be created while converting the lead into opportunity
Field type dimension
Data type string.text.value
lead_street
Field label Lead street
Description The lead street
Field type dimension
Data type string.geo.street
lead_city
Field label Lead city
Description City of the lead
Field type dimension
Data type string.geo.city
lead_postal_code
Field label Lead postal code
Description Postal code of the lead
Field type dimension
Data type string.geo.zip
lead_country
Field label Lead country
Description Country of the lead
Field type dimension
Data type string.geo.country
lead_website
Field label Lead website
Description Website of the contact
Field type dimension
Data type string.text.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

LEAD

lead_id
Field label Lead ID
Description ID of the lead
Field type dimension
Data type string.text.value
lead_name
Field label Lead name
Description Name of the lead
Field type dimension
Data type string.text.value
lead_stage
Field label Lead stage
Description The stage of the lead (New, Qualified, Proposition, Won)
Field type dimension
Data type string.text.value
lead_salesperson
Field label Lead salesperson
Description Salesperson of the lead
Field type dimension
Data type string.text.value
lead_type
Field label Lead type
Description Lead type
Field type dimension
Data type string.text.value
lead_company_currency
Field label Lead company currency
Description The currency of the lead company
Field type dimension
Data type string.currency.code
lead_expected_revenue
Field label Lead expected revenue
Description The expected revenue of lead
Field type metric
Data type float.currency.value
lead_probability
Field label Lead probability
Description The lead probability
Field type metric
Data type float.number.percentage
leads
Field label Leads
Description Total amount of lead in the period
Field type metric
Data type int.number.value

MARKETING

lead_campaign
Field label Lead campaign
Description Campaign of the lead
Field type dimension
Data type string.text.value
lead_medium
Field label Lead medium
Description Method of delivery of the lead
Field type dimension
Data type string.text.value
lead_source
Field label Lead source
Description Source of the link (E.g Search Engine, another domain or name of email list)
Field type dimension
Data type string.text.value
lead_referred_by
Field label Lead referred by
Description Lead referred by
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

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
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime

TIMESTAMP

lead_created_date
Field label Lead created date
Description Lead created date
Field type dimension
Data type string.time.date
lead_modified_date
Field label Lead modified date
Description Lead modified date
Field type dimension
Data type string.time.date
lead_modified_datetime
Field label Lead modified datetime
Description Lead modified datetime
Field type dimension
Data type string.time.datetime
lead_update_date
Field label Lead updated date
Description Last stage update date of the lead
Field type dimension
Data type string.time.date
lead_update_datetime
Field label Lead updated datetime
Description Last stage update datetime of the lead
Field type dimension
Data type string.time.datetime
lead_expected_closing_date
Field label Lead expected closing date
Description Expected closing date of the lead
Field type dimension
Data type string.time.date
lead_expected_closing_datetime
Field label Lead expected closing datetime
Description Expected closing datetime of the lead
Field type dimension
Data type string.time.datetime