Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| Hour | hour | dim | Hour in a 24-hour clock, e.g. 18 | |
| LEADS | Lead ID | lead_id | dim | Unique lead identifier |
| Company name | lead_company | dim | Lead company name | |
| Score | lead_score | dim | Score of the lead | |
| Source | lead_source | dim | Lead source | |
| Status | lead_status | dim | Lead status | |
| Rating | lead_rating | dim | Lead rating | |
| Relative score | lead_relative_score | dim | Lead relative score | |
| Priority | lead_priority | dim | Lead priority | |
| Urgency | lead_urgency | dim | Lead urgency | |
| Created at date | lead_created_at_date | dim | Lead created at date | |
| Created at time | lead_created_at_time | dim | Lead created at time | |
| Updated at date | lead_updated_at_date | dim | Lead updated at date | |
| Updated at time | lead_updated_at_time | dim | Lead updated at time | |
| First name | lead_first_name | dim | Lead first name | |
| Last name | lead_last_name | dim | Lead last name | |
| Role | lead_role | dim | Lead role | |
| Job title | lead_job_title | dim | Lead job title | |
| Email address | lead_email_address | dim | Lead email address | |
| Main phone | lead_main_phone | dim | Lead main phone | |
| Phone number | lead_phone_number | dim | Lead phone phone | |
| Mobile phone number | lead_mobile_phone_number | dim | Lead mobile phone number | |
| Site | lead_site | dim | Lead site | |
| Department | lead_department | dim | Lead department | |
| Industry | lead_industry | dim | Lead industry | |
| Number of employees | lead_number_of_employees | dim | Lead company number of employees | |
| Country | lead_country | dim | Lead country | |
| City | lead_city | dim | Lead city | |
| State | lead_state | dim | Lead state | |
| Postal code | lead_postal_code | dim | Lead postal code | |
| Website | lead_website | dim | Lead website | |
| Unsubscribed status | lead_unsubscribed | dim | Lead unsubscribed status | |
| Unsubscribed reason | lead_unsubscribed_reason | dim | Lead unsubscribed reason | |
| Do not call status | lead_do_not_call | dim | Lead do not call status | |
| Do not call reason | lead_do_not_call_reason | dim | Lead do not call reason | |
| Deleted at date | lead_deleted_at_date | dim | Lead deleted at date | |
| Deleted at time | lead_deleted_at_time | dim | Lead deleted at time | |
| ACTIVITIES | Activity ID | activity_id | dim | Unique activity identifier |
| Activity lead ID | activity_lead_id | dim | Unique activity lead identifier | |
| Activity type ID (Activity) | activity_type_id | dim | Unique activity type identifier for the activity | |
| Activity campaign ID | activity_campaign_id | dim | Uniquer identifier of the activity campaign | |
| Activity date | activity_created_at_date | dim | Date when activity was created | |
| Activity time | activity_created_at_time | dim | Date and time when activity was created | |
| Activity primary attribute ID | activity_primary_attribute_id | dim | Identifier of the primary activity attribute | |
| Activity primary attribute value | activity_primary_attribute_value | dim | Value of the primary activity attribute | |
| EMAILS | Email ID | email_id | dim | ID of the email |
| Email name | email_name | dim | Name of the email | |
| Email description | email_description | dim | Description of the email | |
| Email template ID | email_template_id | dim | ID of the parent template | |
| Email folder name | email_folder_name | dim | Name of the parent folder | |
| Email subject | email_subject | dim | Subject line of the email | |
| Email status | email_status | dim | Status filter for draft or approved versions | |
| Email workspace | email_workspace | dim | Name of the workspace | |
| Email pre-header | email_pre_header | dim | The email preheader text | |
| Email CC fields | email_cc_fields | dim | The email CC fields | |
| Email is operational | email_operational | dim | Whether the email is operational. Operational emails bypass unsubscribe status | |
| Email is text only | email_text_only | dim | Setting to include text-only version of email when sent | |
| Email open tracking disabled | email_open_tracking_disabled | dim | Whether Open Tracking is disabled for email. Returns TRUE if tracking is disabled and FALSE if tracking is enabled | |
| Email has View as Webpage | email_web_view | dim | Whether "View as Webpage" function is enabled for the email | |
| Email URL | email_url | dim | URL of the email in the Marketo UI | |
| Email from name | email_from_name | dim | From-name of the email | |
| Email from address | email_from_email | dim | From-address of the email | |
| Email reply-to | email_reply_email | dim | Reply-To address of the email | |
| Email created at date | email_created_at_date | dim | Date the email was created | |
| Email created at time | email_created_at_time | dim | Date and time the email was created | |
| Email updated at date | email_updated_at_date | dim | Date the email was most recently updated | |
| Email updated at time | email_updated_at_time | dim | Date and time the email was most recently updated | |
| CAMPAIGNS | Campaign ID | campaign_id | dim | ID of the campaign |
| Campaign name | campaign_name | dim | Name of the campaign | |
| Campaign description | campaign_description | dim | Description of the campaign | |
| Campaign type | campaign_type | dim | 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 | |
| Campaign is active | campaign_is_active | dim | Whether smart campaign is active | |
| Campaign start date | campaign_recurrence_start_at_date | dim | Date of the first scheduled campaign to run | |
| Campaign start time | campaign_recurrence_start_at_time | dim | Datetime of the first scheduled campaign to run | |
| Campaign end date | campaign_recurrence_end_at_date | dim | Date after which no further runs will be automatically scheduled | |
| Campaign end time | campaign_recurrence_end_at_time | dim | Datetime after which no further runs will be automatically scheduled | |
| Campaign recurrence type | campaign_recurrence_interval_type | dim | Recurrence interval (Daily, Weekly, Monthly) | |
| Campaign recurrence type | campaign_recurrence_interval | dim | Number of interval units between recurrences | |
| Campaign recurrence weekdays only | campaign_recurrence_weekday_only | dim | Only run smart campaign on weekdays | |
| Campaign recurrence weekdays | campaign_recurrence_weekday_mask | dim | String array of empty or one or more of Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday | |
| Campaign recurrence day of month | campaign_recurrence_day_of_month | dim | Day of the month to recur | |
| Campaign recurrence day of week | campaign_recurrence_day_of_week | dim | Day of the week to recur | |
| Campaign recurrence week of month | campaign_recurrence_week_of_month | dim | Week of the month to recur (1-4) | |
| Campaign qualification type | campaign_qualification_rule_type | dim | Type of qualification rule (once, any, interval) | |
| Campaign qualification interval | campaign_qualification_rule_interval | dim | Interval of qualification rule | |
| Campaign qualification unit | campaign_qualification_rule_unit | dim | Unit of measure of qualification rule (hour, day, week, month) | |
| Campaign max members | campaign_max_members | dim | Smart campaign membership limit | |
| Campaign communication limit enabled | campaign_is_communication_limit_enabled | dim | Whether smart campaign communication limit is enabled (i.e. block non-operational emails) | |
| Campaign smart list ID | campaign_smart_list_id | dim | ID of the smart campaign's child smart list | |
| Campaign flow ID | campaign_flow_id | dim | ID of the smart campaign's child flow | |
| Campaign parent program ID | campaign_parent_program_id | dim | Parent program ID. Present if smart campaign is under program or nested folder | |
| Campaign workspace | campaign_workspace | dim | Name of the smart campaign workspace | |
| Campaign URL | campaign_computed_url | dim | URL to asset in Marketo Engage | |
| Campaign status | campaign_status | dim | Status of smart campaign (Inactive, Single Run, Invalid, Recurring Run, Active, Requested, Never Run) | |
| Campaign created at date | campaign_created_at_date | dim | Date the campaign was created | |
| Campaign created at time | campaign_created_at_time | dim | Date and time the campaign was created | |
| Campaign updated at date | campaign_updated_at_date | dim | Date the campaign was most recently updated | |
| Campaign updated at time | campaign_updated_at_time | dim | Date and time the campaign was most recently updated | |
| ACTIVITY TYPES | Activity type ID | activity_type_type_id | dim | Unique activity type identifier |
| Activity type name | activity_type_name | dim | Name of the activity type | |
| Activity type description | activity_type_description | dim | Description of the activity type | |
| Activity type primary attribute | activity_type_primary_attribute | dim | Primary attribute of the activity type | |
| PROGRAMS | Program ID | program_id | dim | Unique program identifier |
| Program name | program_name | dim | Name of the program | |
| Program description | program_description | dim | Description of the program | |
| Program created at time | program_created_at_time | dim | Date and time the program was created | |
| Program created at date | program_created_at_date | dim | Date the program was created | |
| Program updated at time | program_updated_at_time | dim | Date and time the program was updated | |
| Program updated at date | program_updated_at_date | dim | Date the program was updated | |
| Program start time | program_start_time | dim | Start date and time of program. Applicable to event, email and webinar type programs | |
| Program start date | program_start_date | dim | Start date of program. Applicable to event, email and webinar type programs | |
| Program end time | program_end_time | dim | End date and time of program. Applicable to event, email and webinar type programs | |
| Program end date | program_end_date | dim | End date of program. Applicable to event, email and webinar type programs | |
| Program URL | program_url | dim | Url of the asset in the Marketo UI | |
| Program type | program_type | dim | Type of the program (default, event, webinar or nurture) | |
| Program channel | program_channel | dim | Channel of the program | |
| Program tags | program_tags | dim | List of associated program tags | |
| Program status | program_status | dim | Status of the program (locked, unlocked, on, off). Only valid for Email and engagement program types | |
| Program workspace | program_workspace | dim | Name of the program workspace | |
| Program costs | program_costs | dim | Lists of associated period costs | |
| PROGRAM MEMBERS | Program member lead ID | program_member_lead_id | dim | Unique identifier of a lead record |
| Program member program ID | program_member_program_id | dim | The ID of target program | |
| Program member created at time | program_member_created_at_time | dim | Date and time the program member was created | |
| Program member created at date | program_member_created_at_date | dim | Date the program member was created | |
| Program member updated at time | program_member_updated_at_time | dim | Date and time the program member was updated | |
| Program member updated at date | program_member_updated_at_date | dim | Date the program member was updated | |
| Program member membership time | program_member_membership_time | dim | Date and time the lead first became a member of the program | |
| Program member membership date | program_member_membership_date | dim | Date the lead first became a member of the program | |
| Program member reached success time | program_member_reached_success_time | dim | Date and time the program member has reached success criteria for program | |
| Program member reached success date | program_member_reached_success_date | dim | Date and time the program member has reached success criteria for program | |
| Program member reached success | program_member_reached_success | dim | Boolean indicating if program member has reached success criteria for program | |
| Program member is exhausted | program_member_is_exhausted | dim | Boolean indicating if program member has exhausted content | |
| Program member acquired by program | program_member_acquired_by_program | dim | Boolean indicating if program member is acquired by the program | |
| Program member nurture cadence | program_member_nurture_cadence | dim | Nurture cadence of the program member | |
| Program member status | program_member_status_name | dim | Status name of the program member | |
| Program member status reason | program_member_status_reason | dim | Status reason of the program member | |
| Program member track | program_member_track_name | dim | Track name of the program member | |
| Program member registration code | program_member_registration_code | dim | Registration code of the program member | |
| Program member registration likelihood | program_member_registration_likelihood | dim | Registration likelihood of the program member | |
| Program member webinar URL | program_member_webinar_url | dim | Webinar URL of the program member | |
| Program member waitlist priority | program_member_waitlist_priority | dim | Waitlist priority of the program member | |
| Program member deleted at time | program_member_deleted_at_time | dim | Date and time the program member was deleted | |
| Program member deleted at date | program_member_deleted_at_date | dim | Date the program member was deleted | |
| LEADS | Leads | leads_count | met | Leads |
| Leads (score >50) | leads_count_over_50_score | met | Leads (score >50) | |
| Leads (score >70) | leads_count_over_70_score | met | Leads (score >70) | |
| Leads (score >90) | leads_count_over_90_score | met | Leads (score >90) | |
| Average score | leads_average_score | met | Average score | |
| ACTIVITIES | Activities | activity_count | met | Number of activities |
| PROGRAMS | Program total members | program_total_members | met | Total members in the program |
| Program new names | program_new_names | met | Amount of leads acquired by the program | |
| Program new name (%) | program_new_name_percentage | met | Percentage of new members to total members of the program | |
| Program successes | program_successes | met | Amount of program members reached success | |
| Program success (%) | program_success_percentage | met | Percentage of members reached success to total members of the program | |
| Program total cost | program_total_cost | met | Total cost of the program | |
| Program cost per member | program_cost_per_member | met | Cost per member of the program | |
| EMAILS | Email sent | email_sends_count | met | Total number of emails sent |
| Email delivered | email_delivered_count | met | Number of emails delivered to recipient | |
| Email delivery rate | email_delivered_rate | met | Email delivery rate. Delivered / Sent | |
| Email opens | email_opens_count | met | Total amount of times the email was opened | |
| Email opens (unique) | email_opens_count_unique | met | Number of people who opened the email at least once | |
| Email open rate | email_opens_rate | met | Emails opens / emails sent | |
| Email clicks | email_clicks_count | met | Total amount of times a link in the email was clicked | |
| Email clicks (unique) | email_clicks_unique | met | Number of people who clicked a link in the email at least once | |
| Email pending | email_pending_count | met | Number of emails sent but still in the process of being delivered or retried | |
| Email soft bounce | email_bounced_soft_count | met | Number of emails temporarily rejected | |
| Email hard bounce | email_bounced_hard_count | met | Number of emails permanently rejected | |
| Email total bounces | email_bounced_total_count | met | Number of emails bounced, whether temporarily or permanently | |
| Email bounce rate | email_bounced_rate | met | Email bounce rate. Email bounced / Email sent | |
| Email unsubscribes | email_unsubscribes_count | met | Number of people unsubscribing to an email | |
| Email unsubscribe rate | email_unsubscribes_rate | met | Email unsubscribe rate. Email unsubscribes / Email sent |