Marketo fields

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

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

28 metrics168 dimensionsCustom fields

ACTIVITIES

activity_id
Field label Activity ID
Description Unique activity identifier
Field type dimension
Data type int.number.value
activity_lead_id
Field label Activity lead ID
Description Unique activity lead identifier
Field type dimension
Data type int.number.value
activity_type_id
Field label Activity type ID (Activity)
Description Unique activity type identifier for the activity
Field type dimension
Data type int.number.value
activity_campaign_id
Field label Activity campaign ID
Description Uniquer identifier of the activity campaign
Field type dimension
Data type int.number.value
activity_created_at_date
Field label Activity date
Description Date when activity was created
Field type dimension
Data type string.time.date
activity_created_at_time
Field label Activity time
Description Date and time when activity was created
Field type dimension
Data type string.time.datetime
activity_primary_attribute_id
Field label Activity primary attribute ID
Description Identifier of the primary activity attribute
Field type dimension
Data type int.number.value
activity_primary_attribute_value
Field label Activity primary attribute value
Description Value of the primary activity attribute
Field type dimension
Data type string.text.value
activity_count
Field label Activities
Description Number of activities
Field type metric
Data type int.number.value

ACTIVITY TYPES

activity_type_type_id
Field label Activity type ID
Description Unique activity type identifier
Field type dimension
Data type int.number.value
activity_type_name
Field label Activity type name
Description Name of the activity type
Field type dimension
Data type string.text.value
activity_type_description
Field label Activity type description
Description Description of the activity type
Field type dimension
Data type string.text.value
activity_type_primary_attribute
Field label Activity type primary attribute
Description Primary attribute of the activity type
Field type dimension
Data type string.text.json

CAMPAIGNS

campaign_id
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_description
Field label Campaign description
Description Description of the campaign
Field type dimension
Data type string.text.value
campaign_type
Field label 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_is_active
Field label Campaign is active
Description Whether smart campaign is active
Field type dimension
Data type bool
campaign_recurrence_start_at_date
Field label 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
Field label Campaign start time
Description Datetime of the first scheduled campaign to run
Field type dimension
Data type string.time.datetime
campaign_recurrence_end_at_date
Field label 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
Field label 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_type
Field label Campaign recurrence type
Description Recurrence interval (Daily, Weekly, Monthly)
Field type dimension
Data type string.text.value
campaign_recurrence_interval
Field label Campaign recurrence type
Description Number of interval units between recurrences
Field type dimension
Data type string.text.value
campaign_recurrence_weekday_only
Field label Campaign recurrence weekdays only
Description Only run smart campaign on weekdays
Field type dimension
Data type bool
campaign_recurrence_weekday_mask
Field label 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_day_of_month
Field label 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
Field label Campaign recurrence day of week
Description Day of the week to recur
Field type dimension
Data type string.text.value
campaign_recurrence_week_of_month
Field label Campaign recurrence week of month
Description Week of the month to recur (1-4)
Field type dimension
Data type string.text.value
campaign_qualification_rule_type
Field label Campaign qualification type
Description Type of qualification rule (once, any, interval)
Field type dimension
Data type string.text.value
campaign_qualification_rule_interval
Field label Campaign qualification interval
Description Interval of qualification rule
Field type dimension
Data type string.text.value
campaign_qualification_rule_unit
Field label Campaign qualification unit
Description Unit of measure of qualification rule (hour, day, week, month)
Field type dimension
Data type string.text.value
campaign_max_members
Field label Campaign max members
Description Smart campaign membership limit
Field type dimension
Data type string.text.value
campaign_is_communication_limit_enabled
Field label Campaign communication limit enabled
Description Whether smart campaign communication limit is enabled (i.e. block non-operational emails)
Field type dimension
Data type bool
campaign_smart_list_id
Field label Campaign smart list ID
Description ID of the smart campaign's child smart list
Field type dimension
Data type string.text.value
campaign_flow_id
Field label Campaign flow ID
Description ID of the smart campaign's child flow
Field type dimension
Data type string.text.value
campaign_parent_program_id
Field label 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_workspace
Field label Campaign workspace
Description Name of the smart campaign workspace
Field type dimension
Data type string.text.value
campaign_computed_url
Field label Campaign URL
Description URL to asset in Marketo Engage
Field type dimension
Data type string.text.url
campaign_status
Field label 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_created_at_date
Field label Campaign created at date
Description Date the campaign was created
Field type dimension
Data type string.time.date
campaign_created_at_time
Field label Campaign created at time
Description Date and time the campaign was created
Field type dimension
Data type string.time.datetime
campaign_updated_at_date
Field label Campaign updated at date
Description Date the campaign was most recently updated
Field type dimension
Data type string.time.date
campaign_updated_at_time
Field label Campaign updated at time
Description Date and time the campaign was most recently updated
Field type dimension
Data type string.time.datetime

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

EMAILS

email_id
Field label Email ID
Description ID of the email
Field type dimension
Data type int.number.value
email_name
Field label Email name
Description Name of the email
Field type dimension
Data type string.text.value
email_description
Field label Email description
Description Description of the email
Field type dimension
Data type string.text.value
email_template_id
Field label Email template ID
Description ID of the parent template
Field type dimension
Data type string.text.value
email_folder_name
Field label Email folder name
Description Name of the parent folder
Field type dimension
Data type string.text.value
email_subject
Field label Email subject
Description Subject line of the email
Field type dimension
Data type string.text.value
email_status
Field label Email status
Description Status filter for draft or approved versions
Field type dimension
Data type string.text.value
email_workspace
Field label Email workspace
Description Name of the workspace
Field type dimension
Data type string.text.value
email_pre_header
Field label Email pre-header
Description The email preheader text
Field type dimension
Data type string.text.value
email_cc_fields
Field label Email CC fields
Description The email CC fields
Field type dimension
Data type string.text.json
email_operational
Field label Email is operational
Description Whether the email is operational. Operational emails bypass unsubscribe status
Field type dimension
Data type bool
email_text_only
Field label Email is text only
Description Setting to include text-only version of email when sent
Field type dimension
Data type bool
email_open_tracking_disabled
Field label Email open tracking disabled
Description Whether Open Tracking is disabled for email. Returns TRUE if tracking is disabled and FALSE if tracking is enabled
Field type dimension
Data type bool
email_web_view
Field label Email has View as Webpage
Description Whether "View as Webpage" function is enabled for the email
Field type dimension
Data type bool
email_url
Field label Email URL
Description URL of the email in the Marketo UI
Field type dimension
Data type string.text.url
email_from_name
Field label Email from name
Description From-name of the email
Field type dimension
Data type string.text.value
email_from_email
Field label Email from address
Description From-address of the email
Field type dimension
Data type string.text.value
email_reply_email
Field label Email reply-to
Description Reply-To address of the email
Field type dimension
Data type string.text.value
email_created_at_date
Field label Email created at date
Description Date the email was created
Field type dimension
Data type string.time.date
email_created_at_time
Field label Email created at time
Description Date and time the email was created
Field type dimension
Data type string.time.datetime
email_updated_at_date
Field label Email updated at date
Description Date the email was most recently updated
Field type dimension
Data type string.time.date
email_updated_at_time
Field label Email updated at time
Description Date and time the email was most recently updated
Field type dimension
Data type string.time.datetime
email_sends_count
Field label Email sent
Description Total number of emails sent
Field type metric
Data type int.number.value
email_delivered_count
Field label Email delivered
Description Number of emails delivered to recipient
Field type metric
Data type int.number.value
email_delivered_rate
Field label Email delivery rate
Description Email delivery rate. Delivered / Sent
Field type metric
Data type float.number.ratio
email_opens_count
Field label Email opens
Description Total amount of times the email was opened
Field type metric
Data type int.number.value
email_opens_count_unique
Field label Email opens (unique)
Description Number of people who opened the email at least once
Field type metric
Data type int.number.value
email_opens_rate
Field label Email open rate
Description Emails opens / emails sent
Field type metric
Data type float.number.ratio
email_clicks_count
Field label 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
Field label 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_pending_count
Field label 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_bounced_soft_count
Field label Email soft bounce
Description Number of emails temporarily rejected
Field type metric
Data type int.number.value
email_bounced_hard_count
Field label Email hard bounce
Description Number of emails permanently rejected
Field type metric
Data type int.number.value
email_bounced_total_count
Field label Email total bounces
Description Number of emails bounced, whether temporarily or permanently
Field type metric
Data type int.number.value
email_bounced_rate
Field label Email bounce rate
Description Email bounce rate. Email bounced / Email sent
Field type metric
Data type float.number.ratio
email_unsubscribes_count
Field label Email unsubscribes
Description Number of people unsubscribing to an email
Field type metric
Data type int.number.value
email_unsubscribes_rate
Field label Email unsubscribe rate
Description Email unsubscribe rate. Email unsubscribes / Email sent
Field type metric
Data type float.number.ratio

LEADS

lead_id
Field label Lead ID
Description Unique lead identifier
Field type dimension
Data type int.number.value
lead_company
Field label Company name
Description Lead company name
Field type dimension
Data type string.text.value
lead_score
Field label Score
Description Score of the lead
Field type dimension
Data type int.number.value
lead_source
Field label Source
Description Lead source
Field type dimension
Data type string.text.value
lead_status
Field label Status
Description Lead status
Field type dimension
Data type string.text.value
lead_rating
Field label Rating
Description Lead rating
Field type dimension
Data type string.text.value
lead_relative_score
Field label Relative score
Description Lead relative score
Field type dimension
Data type int.number.value
lead_priority
Field label Priority
Description Lead priority
Field type dimension
Data type string.text.value
lead_urgency
Field label Urgency
Description Lead urgency
Field type dimension
Data type string.text.value
lead_created_at_date
Field label Created at date
Description Lead created at date
Field type dimension
Data type string.time.date
lead_created_at_time
Field label Created at time
Description Lead created at time
Field type dimension
Data type string.time.datetime
lead_updated_at_date
Field label Updated at date
Description Lead updated at date
Field type dimension
Data type string.time.date
lead_updated_at_time
Field label Updated at time
Description Lead updated at time
Field type dimension
Data type string.time.datetime
lead_first_name
Field label First name
Description Lead first name
Field type dimension
Data type string.text.value
lead_last_name
Field label Last name
Description Lead last name
Field type dimension
Data type string.text.value
lead_role
Field label Role
Description Lead role
Field type dimension
Data type string.text.value
lead_job_title
Field label Job title
Description Lead job title
Field type dimension
Data type string.text.value
lead_email_address
Field label Email address
Description Lead email address
Field type dimension
Data type string.text.email
lead_main_phone
Field label Main phone
Description Lead main phone
Field type dimension
Data type string.text.phone
lead_phone_number
Field label Phone number
Description Lead phone phone
Field type dimension
Data type string.text.phone
lead_mobile_phone_number
Field label Mobile phone number
Description Lead mobile phone number
Field type dimension
Data type string.text.phone
lead_site
Field label Site
Description Lead site
Field type dimension
Data type string.text.url
lead_department
Field label Department
Description Lead department
Field type dimension
Data type string.text.value
lead_industry
Field label Industry
Description Lead industry
Field type dimension
Data type string.text.value
lead_number_of_employees
Field label Number of employees
Description Lead company number of employees
Field type dimension
Data type int.number.value
lead_country
Field label Country
Description Lead country
Field type dimension
Data type string.geo.country
lead_city
Field label City
Description Lead city
Field type dimension
Data type string.geo.city
lead_state
Field label State
Description Lead state
Field type dimension
Data type string.geo.region
lead_postal_code
Field label Postal code
Description Lead postal code
Field type dimension
Data type string.geo.zip
lead_website
Field label Website
Description Lead website
Field type dimension
Data type string.text.url
lead_unsubscribed
Field label Unsubscribed status
Description Lead unsubscribed status
Field type dimension
Data type bool
lead_unsubscribed_reason
Field label Unsubscribed reason
Description Lead unsubscribed reason
Field type dimension
Data type string.text.value
lead_do_not_call
Field label Do not call status
Description Lead do not call status
Field type dimension
Data type bool
lead_do_not_call_reason
Field label Do not call reason
Description Lead do not call reason
Field type dimension
Data type string.text.value
lead_deleted_at_date
Field label Deleted at date
Description Lead deleted at date
Field type dimension
Data type string.time.date
lead_deleted_at_time
Field label Deleted at time
Description Lead deleted at time
Field type dimension
Data type string.time.datetime
leads_count
Field label Leads
Description Leads
Field type metric
Data type int.number.value
leads_count_over_50_score
Field label Leads (score >50)
Description Leads (score >50)
Field type metric
Data type int.number.value
leads_count_over_70_score
Field label Leads (score >70)
Description Leads (score >70)
Field type metric
Data type int.number.value
leads_count_over_90_score
Field label Leads (score >90)
Description Leads (score >90)
Field type metric
Data type int.number.value
leads_average_score
Field label Average score
Description Average score
Field type metric
Data type float.number.value

PROGRAM MEMBERS

program_member_lead_id
Field label Program member lead ID
Description Unique identifier of a lead record
Field type dimension
Data type int.number.value
program_member_program_id
Field label Program member program ID
Description The ID of target program
Field type dimension
Data type int.number.value
program_member_created_at_time
Field label Program member created at time
Description Date and time the program member was created
Field type dimension
Data type string.time.datetime
program_member_created_at_date
Field label Program member created at date
Description Date the program member was created
Field type dimension
Data type string.time.date
program_member_updated_at_time
Field label Program member updated at time
Description Date and time the program member was updated
Field type dimension
Data type string.time.datetime
program_member_updated_at_date
Field label Program member updated at date
Description Date the program member was updated
Field type dimension
Data type string.time.date
program_member_membership_time
Field label Program member membership time
Description Date and time the lead first became a member of the program
Field type dimension
Data type string.time.datetime
program_member_membership_date
Field label Program member membership date
Description Date the lead first became a member of the program
Field type dimension
Data type string.time.date
program_member_reached_success_time
Field label Program member reached success time
Description Date and time the program member has reached success criteria for program
Field type dimension
Data type string.time.datetime
program_member_reached_success_date
Field label Program member reached success date
Description Date and time the program member has reached success criteria for program
Field type dimension
Data type string.time.date
program_member_reached_success
Field label Program member reached success
Description Boolean indicating if program member has reached success criteria for program
Field type dimension
Data type bool
program_member_is_exhausted
Field label Program member is exhausted
Description Boolean indicating if program member has exhausted content
Field type dimension
Data type bool
program_member_acquired_by_program
Field label Program member acquired by program
Description Boolean indicating if program member is acquired by the program
Field type dimension
Data type bool
program_member_nurture_cadence
Field label Program member nurture cadence
Description Nurture cadence of the program member
Field type dimension
Data type string.text.value
program_member_status_name
Field label Program member status
Description Status name of the program member
Field type dimension
Data type string.text.value
program_member_status_reason
Field label Program member status reason
Description Status reason of the program member
Field type dimension
Data type string.text.value
program_member_track_name
Field label Program member track
Description Track name of the program member
Field type dimension
Data type string.text.value
program_member_registration_code
Field label Program member registration code
Description Registration code of the program member
Field type dimension
Data type string.text.value
program_member_registration_likelihood
Field label Program member registration likelihood
Description Registration likelihood of the program member
Field type dimension
Data type int.number.value
program_member_webinar_url
Field label Program member webinar URL
Description Webinar URL of the program member
Field type dimension
Data type string.text.url
program_member_waitlist_priority
Field label Program member waitlist priority
Description Waitlist priority of the program member
Field type dimension
Data type int.number.value
program_member_deleted_at_time
Field label Program member deleted at time
Description Date and time the program member was deleted
Field type dimension
Data type string.time.datetime
program_member_deleted_at_date
Field label Program member deleted at date
Description Date the program member was deleted
Field type dimension
Data type string.time.date

PROGRAMS

program_id
Field label Program ID
Description Unique program identifier
Field type dimension
Data type int.number.value
program_name
Field label Program name
Description Name of the program
Field type dimension
Data type string.text.value
program_description
Field label Program description
Description Description of the program
Field type dimension
Data type string.text.value
program_created_at_time
Field label Program created at time
Description Date and time the program was created
Field type dimension
Data type string.time.datetime
program_created_at_date
Field label Program created at date
Description Date the program was created
Field type dimension
Data type string.time.date
program_updated_at_time
Field label Program updated at time
Description Date and time the program was updated
Field type dimension
Data type string.time.datetime
program_updated_at_date
Field label Program updated at date
Description Date the program was updated
Field type dimension
Data type string.time.date
program_start_time
Field label Program start time
Description Start date and time of program. Applicable to event, email and webinar type programs
Field type dimension
Data type string.time.datetime
program_start_date
Field label Program start date
Description Start date of program. Applicable to event, email and webinar type programs
Field type dimension
Data type string.time.date
program_end_time
Field label Program end time
Description End date and time of program. Applicable to event, email and webinar type programs
Field type dimension
Data type string.time.datetime
program_end_date
Field label Program end date
Description End date of program. Applicable to event, email and webinar type programs
Field type dimension
Data type string.time.date
program_url
Field label Program URL
Description Url of the asset in the Marketo UI
Field type dimension
Data type string.text.url
program_type
Field label Program type
Description Type of the program (default, event, webinar or nurture)
Field type dimension
Data type string.text.value
program_channel
Field label Program channel
Description Channel of the program
Field type dimension
Data type string.text.value
program_tags
Field label Program tags
Description List of associated program tags
Field type dimension
Data type string.text.json
program_status
Field label Program status
Description Status of the program (locked, unlocked, on, off). Only valid for Email and engagement program types
Field type dimension
Data type string.text.value
program_workspace
Field label Program workspace
Description Name of the program workspace
Field type dimension
Data type string.text.value
program_costs
Field label Program costs
Description Lists of associated period costs
Field type dimension
Data type string.text.json
program_total_members
Field label Program total members
Description Total members in the program
Field type metric
Data type int.number.value
program_new_names
Field label Program new names
Description Amount of leads acquired by the program
Field type metric
Data type int.number.value
program_new_name_percentage
Field label Program new name (%)
Description Percentage of new members to total members of the program
Field type metric
Data type float.number.percentage
program_successes
Field label Program successes
Description Amount of program members reached success
Field type metric
Data type int.number.value
program_success_percentage
Field label Program success (%)
Description Percentage of members reached success to total members of the program
Field type metric
Data type float.number.percentage
program_total_cost
Field label Program total cost
Description Total cost of the program
Field type metric
Data type float.currency.value
program_cost_per_member
Field label Program cost per member
Description Cost per member of the program
Field type metric
Data type float.number.ratio

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
Description Year, e.g. 2017
Field type dimension
Data type string.time.year
yearOfWeek
Field label Year of week (Sun-Sat)
Description Year of week for US-style Sunday-Saturday weeks, e.g. 2017
Field type dimension
Data type string.time.year
yearOfWeekIso
Field label Year of week (Mon-Sun)
Description Year of week for ISO standard Monday-Sunday weeks, e.g. 2017
Field type dimension
Data type string.time.year
yearMonth
Field label Year & month
Description Year and month, e.g. 2017|06
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Description Month, e.g. 6
Field type dimension
Data type string.time.month
yearWeek
Field label Year & week (Sun-Sat)
Description Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweek
yearWeekIso
Field label Year & week (Mon-Sun)
Description Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Description US week number, e.g. 51
Field type dimension
Data type string.time.week
weekIso
Field label Week (Mon-Sun)
Description ISO week number, e.g. 51
Field type dimension
Data type string.time.weekiso
dayOfMonth
Field label Day of month
Description Day of month, e.g. 2
Field type dimension
Data type string.time.dayofmonth
dayOfWeekName
Field label Day of week (Sun-Sat)
Description Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday
Field type dimension
Data type string.time.dayofweek
dayOfWeekNameIso
Field label Day of week (Mon-Sun)
Description Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
hour
Field label Hour
Description Hour in a 24-hour clock, e.g. 18
Field type dimension
Data type string.time.hour