Marketo data warehouse table groups

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Table: LEAD

dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
lead_city
Display name City
Description Lead city
Field type dimension
Data type string.geo.city
lead_company
Display name Company name
Description Lead company name
Field type dimension
Data type string.text.value
lead_country
Display name Country
Description Lead country
Field type dimension
Data type string.geo.country
lead_created_at_date
Display name Created at date
Description Lead created at date
Field type dimension
Data type string.time.date
lead_created_at_time
Display name Created at time
Description Lead created at time
Field type dimension
Data type string.time.datetime
lead_department
Display name Department
Description Lead department
Field type dimension
Data type string.text.value
lead_do_not_call
Display name Do not call status
Description Lead do not call status
Field type dimension
Data type bool
lead_do_not_call_reason
Display name Do not call reason
Description Lead do not call reason
Field type dimension
Data type string.text.value
lead_email_address
Display name Email address
Description Lead email address
Field type dimension
Data type string.text.email
lead_first_name
Display name First name
Description Lead first name
Field type dimension
Data type string.text.value
lead_id
Display name Lead ID
Description Unique lead identifier
Field type dimension
Data type int.number.value
lead_industry
Display name Industry
Description Lead industry
Field type dimension
Data type string.text.value
lead_job_title
Display name Job title
Description Lead job title
Field type dimension
Data type string.text.value
lead_last_name
Display name Last name
Description Lead last name
Field type dimension
Data type string.text.value
lead_main_phone
Display name Main phone
Description Lead main phone
Field type dimension
Data type string.text.phone
lead_mobile_phone_number
Display name Mobile phone number
Description Lead mobile phone number
Field type dimension
Data type string.text.phone
lead_number_of_employees
Display name Number of employees
Description Lead company number of employees
Field type dimension
Data type int.number.value
lead_phone_number
Display name Phone number
Description Lead phone phone
Field type dimension
Data type string.text.phone
lead_postal_code
Display name Postal code
Description Lead postal code
Field type dimension
Data type string.geo.zip
lead_priority
Display name Priority
Description Lead priority
Field type dimension
Data type string.text.value
lead_rating
Display name Rating
Description Lead rating
Field type dimension
Data type string.text.value
lead_relative_score
Display name Relative score
Description Lead relative score
Field type dimension
Data type int.number.value
lead_role
Display name Role
Description Lead role
Field type dimension
Data type string.text.value
lead_score
Display name Score
Description Score of the lead
Field type dimension
Data type int.number.value
lead_site
Display name Site
Description Lead site
Field type dimension
Data type string.text.url
lead_source
Display name Source
Description Lead source
Field type dimension
Data type string.text.value
lead_state
Display name State
Description Lead state
Field type dimension
Data type string.geo.region
lead_status
Display name Status
Description Lead status
Field type dimension
Data type string.text.value
lead_unsubscribed
Display name Unsubscribed status
Description Lead unsubscribed status
Field type dimension
Data type bool
lead_unsubscribed_reason
Display name Unsubscribed reason
Description Lead unsubscribed reason
Field type dimension
Data type string.text.value
lead_updated_at_date
Display name Updated at date
Description Lead updated at date
Field type dimension
Data type string.time.date
lead_updated_at_time
Display name Updated at time
Description Lead updated at time
Field type dimension
Data type string.time.datetime
lead_urgency
Display name Urgency
Description Lead urgency
Field type dimension
Data type string.text.value
lead_website
Display name Website
Description Lead website
Field type dimension
Data type string.text.url

Table: EMAIL_CAMPAIGN

campaign_computed_url
Display name Campaign URL
Description URL to asset in Marketo Engage
Field type dimension
Data type string.text.url
campaign_created_at_date
Display name Campaign created at date
Description Date the campaign was created
Field type dimension
Data type string.time.date
campaign_created_at_time
Display name Campaign created at time
Description Date and time the campaign was created
Field type dimension
Data type string.time.datetime
campaign_description
Display name Campaign description
Description Description of the campaign
Field type dimension
Data type string.text.value
campaign_flow_id
Display name Campaign flow ID
Description ID of the smart campaign's child flow
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_is_active
Display name Campaign is active
Description Whether smart campaign is active
Field type dimension
Data type bool
campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_parent_program_id
Display name Campaign parent program ID
Description Parent program ID. Present if smart campaign is under program or nested folder
Field type dimension
Data type string.text.value
campaign_recurrence_day_of_month
Display name Campaign recurrence day of month
Description Day of the month to recur
Field type dimension
Data type string.text.value
campaign_recurrence_day_of_week
Display name Campaign recurrence day of week
Description Day of the week to recur
Field type dimension
Data type string.text.value
campaign_recurrence_end_at_date
Display name Campaign end date
Description Date after which no further runs will be automatically scheduled
Field type dimension
Data type string.time.date
campaign_recurrence_end_at_time
Display name Campaign end time
Description Datetime after which no further runs will be automatically scheduled
Field type dimension
Data type string.time.datetime
campaign_recurrence_interval
Display name Campaign recurrence type
Description Number of interval units between recurrences
Field type dimension
Data type string.text.value
campaign_recurrence_interval_type
Display name Campaign recurrence type
Description Recurrence interval (Daily, Weekly, Monthly)
Field type dimension
Data type string.text.value
campaign_recurrence_start_at_date
Display name Campaign start date
Description Date of the first scheduled campaign to run
Field type dimension
Data type string.time.date
campaign_recurrence_start_at_time
Display name Campaign start time
Description Datetime of the first scheduled campaign to run
Field type dimension
Data type string.time.datetime
campaign_recurrence_weekday_mask
Display name Campaign recurrence weekdays
Description String array of empty or one or more of Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday
Field type dimension
Data type string.text.json
campaign_recurrence_weekday_only
Display name Campaign recurrence weekdays only
Description Only run smart campaign on weekdays
Field type dimension
Data type bool
campaign_smart_list_id
Display name Campaign smart list ID
Description ID of the smart campaign's child smart list
Field type dimension
Data type string.text.value
campaign_status
Display name Campaign status
Description Status of smart campaign (Inactive, Single Run, Invalid, Recurring Run, Active, Requested, Never Run)
Field type dimension
Data type string.text.value
campaign_type
Display name Campaign type
Description Type of the smart campaign. Batch: has at least one filter and no triggers. Trigger: has at least one trigger. Default: has no smart list rules
Field type dimension
Data type string.text.value
campaign_updated_at_date
Display name Campaign updated at date
Description Date the campaign was most recently updated
Field type dimension
Data type string.time.date
campaign_updated_at_time
Display name Campaign updated at time
Description Date and time the campaign was most recently updated
Field type dimension
Data type string.time.datetime
dataSourceName
Display name 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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
email_bounced_hard_count
Display name Email hard bounce
Description Number of emails permanently rejected
Field type metric
Data type int.number.value
email_bounced_soft_count
Display name Email soft bounce
Description Number of emails temporarily rejected
Field type metric
Data type int.number.value
email_bounced_total_count
Display name Email total bounces
Description Number of emails bounced, whether temporarily or permanently
Field type metric
Data type int.number.value
email_cc_fields
Display name Email CC fields
Description The email CC fields
Field type dimension
Data type string.text.json
email_clicks_count
Display name Email clicks
Description Total amount of times a link in the email was clicked
Field type metric
Data type int.number.value
email_clicks_unique
Display name Email clicks (unique)
Description Number of people who clicked a link in the email at least once
Field type metric
Data type int.number.value
email_created_at_date
Display name Email created at date
Description Date the email was created
Field type dimension
Data type string.time.date
email_created_at_time
Display name Email created at time
Description Date and time the email was created
Field type dimension
Data type string.time.datetime
email_delivered_count
Display name Email delivered
Description Number of emails delivered to recipient
Field type metric
Data type int.number.value
email_description
Display name Email description
Description Description of the email
Field type dimension
Data type string.text.value
email_folder_name
Display name Email folder name
Description Name of the parent folder
Field type dimension
Data type string.text.value
email_from_email
Display name Email from address
Description From-address of the email
Field type dimension
Data type string.text.value
email_from_name
Display name Email from name
Description From-name of the email
Field type dimension
Data type string.text.value
email_id
Display name Email ID
Description ID of the email
Field type dimension
Data type int.number.value
email_name
Display name Email name
Description Name of the email
Field type dimension
Data type string.text.value
email_opens_count
Display name Email opens
Description Total amount of times the email was opened
Field type metric
Data type int.number.value
email_opens_count_unique
Display name Email opens (unique)
Description Number of people who opened the email at least once
Field type metric
Data type int.number.value
email_operational
Display name Email is operational
Description Whether the email is operational. Operational emails bypass unsubscribe status
Field type dimension
Data type bool
email_pending_count
Display name Email pending
Description Number of emails sent but still in the process of being delivered or retried
Field type metric
Data type int.number.value
email_pre_header
Display name Email pre-header
Description The email preheader text
Field type dimension
Data type string.text.value
email_reply_email
Display name Email reply-to
Description Reply-To address of the email
Field type dimension
Data type string.text.value
email_sends_count
Display name Email sent
Description Total number of emails sent
Field type metric
Data type int.number.value
email_status
Display name Email status
Description Status filter for draft or approved versions
Field type dimension
Data type string.text.value
email_subject
Display name Email subject
Description Subject line of the email
Field type dimension
Data type string.text.value
email_template_id
Display name Email template ID
Description ID of the parent template
Field type dimension
Data type string.text.value
email_unsubscribes_count
Display name Email unsubscribes
Description Number of people unsubscribing to an email
Field type metric
Data type int.number.value
email_updated_at_date
Display name Email updated at date
Description Date the email was most recently updated
Field type dimension
Data type string.time.date
email_updated_at_time
Display name Email updated at time
Description Date and time the email was most recently updated
Field type dimension
Data type string.time.datetime
email_url
Display name Email URL
Description URL of the email in the Marketo UI
Field type dimension
Data type string.text.url