Day of the month Day of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY | | Type | DAY | | Data Type | dimension |
|
Day of the week Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY_OF_WEEK | | Type | DAY_OF_WEEK | | Data Type | dimension |
|
Hour of the day Hour of the day | | Field ID | _NORMALIZED_DATE_FIELD_HOUR | | Type | HOUR | | Data Type | dimension |
|
Month of the year Month of the year | | Field ID | _NORMALIZED_DATE_FIELD_MONTH | | Type | MONTH | | Data Type | dimension |
|
Month and day Month and day | | Field ID | _NORMALIZED_DATE_FIELD_MONTH_DAY | | Type | MONTH_DAY | | Data Type | dimension |
|
Quarter of the year Quarter of the year | | Field ID | _NORMALIZED_DATE_FIELD_QUARTER | | Type | QUARTER | | Data Type | dimension |
|
Week of the year Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK | | Type | WEEK | | Data Type | dimension |
|
Week of the year (start Sunday) Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY | | Type | WEEK | | Data Type | dimension |
|
Year Year such as 2017. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR | | Type | YEAR | | Data Type | dimension |
|
Year month Year and month. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH | | Type | YEAR_MONTH | | Data Type | dimension |
|
Date Year, month, and day. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Year month day hour Year, month, day, and hour. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR | | Type | YEAR_MONTH_DAY_HOUR | | Data Type | dimension |
|
Year Quarter Year and quarter. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_QUARTER | | Type | YEAR_QUARTER | | Data Type | dimension |
|
Year week Year and week. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_WEEK | | Type | YEAR_WEEK | | Data Type | dimension |
|
Automation Created At | | Field ID | automation__created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Automation Enabled | | Field ID | automation__enabled | | Type | TEXT | | Data Type | dimension |
|
Automation ID | | Field ID | automation__id | | Type | TEXT | | Data Type | dimension |
|
Automation Name | | Field ID | automation__name | | Type | TEXT | | Data Type | dimension |
|
Automation Step Complete | | Field ID | automation__step__complete | | Type | BOOLEAN | | Data Type | dimension |
|
Automation Step Created At | | Field ID | automation__step__created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Automation Step Description | | Field ID | automation__step__description | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Account ID | | Field ID | automation__step__email__account_id | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Created At | | Field ID | automation__step__email__created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Automation Step Email Emailable ID | | Field ID | automation__step__email__emailable_id | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Emailable Type | | Field ID | automation__step__email__emailable_type | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email From | | Field ID | automation__step__email__from | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email From Name | | Field ID | automation__step__email__from_name | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email ID (Inner) | | Field ID | automation__step__email__id | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Is Designed | | Field ID | automation__step__email__is_designed | | Type | BOOLEAN | | Data Type | dimension |
|
Automation Step Email Is Winner | | Field ID | automation__step__email__is_winner | | Type | BOOLEAN | | Data Type | dimension |
|
Automation Step Email Language ID | | Field ID | automation__step__email__language_id | | Type | NUMBER | | Data Type | dimension |
|
Automation Step Email Name | | Field ID | automation__step__email__name | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Plain Text | | Field ID | automation__step__email__plain_text | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Preview URL | | Field ID | automation__step__email__preview_url | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Screenshot URL | | Field ID | automation__step__email__screenshot_url | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Send After | | Field ID | automation__step__email__send_after | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Automation Step Email Click Rate | | Field ID | automation__step__email__stats__click_rate__float | | Type | PERCENT | | Data Type | metric |
|
Automation Step Email Clicks Count | | Field ID | automation__step__email__stats__clicks_count | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Forwards Count | | Field ID | automation__step__email__stats__forwards_count | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Hard Bounce Rate | | Field ID | automation__step__email__stats__hard_bounce_rate__float | | Type | PERCENT | | Data Type | metric |
|
Automation Step Email Hard Bounces Count | | Field ID | automation__step__email__stats__hard_bounces_count | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Open Rate | | Field ID | automation__step__email__stats__open_rate__float | | Type | PERCENT | | Data Type | metric |
|
Automation Step Email Opens Count | | Field ID | automation__step__email__stats__opens_count | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Sent | | Field ID | automation__step__email__stats__sent | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Soft Bounce Rate | | Field ID | automation__step__email__stats__soft_bounce_rate__float | | Type | PERCENT | | Data Type | metric |
|
Automation Step Email Soft Bounces Count | | Field ID | automation__step__email__stats__soft_bounces_count | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Spam Count | | Field ID | automation__step__email__stats__spam_count | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Spam Rate | | Field ID | automation__step__email__stats__spam_rate__float | | Type | PERCENT | | Data Type | metric |
|
Automation Step Email Unique Clicks Count | | Field ID | automation__step__email__stats__unique_clicks_count | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Unique Opens Count | | Field ID | automation__step__email__stats__unique_opens_count | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Unsubscribe Rate | | Field ID | automation__step__email__stats__unsubscribe_rate__float | | Type | PERCENT | | Data Type | metric |
|
Automation Step Email Unsubscribes Count | | Field ID | automation__step__email__stats__unsubscribes_count | | Type | NUMBER | | Data Type | metric |
|
Automation Step Email Subject | | Field ID | automation__step__email__subject | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Track Opens | | Field ID | automation__step__email__track_opens | | Type | BOOLEAN | | Data Type | dimension |
|
Automation Step Email Type | | Field ID | automation__step__email__type | | Type | TEXT | | Data Type | dimension |
|
Automation Step Email Updated At | | Field ID | automation__step__email__updated_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Automation Step Email ID | | Field ID | automation__step__email_id | | Type | TEXT | | Data Type | dimension |
|
Automation Step From | | Field ID | automation__step__from | | Type | TEXT | | Data Type | dimension |
|
Automation Step From Name | | Field ID | automation__step__from_name | | Type | TEXT | | Data Type | dimension |
|
Automation Step Google Analytics | | Field ID | automation__step__google_analytics | | Type | TEXT | | Data Type | dimension |
|
Automation Step ID | | Field ID | automation__step__id | | Type | TEXT | | Data Type | dimension |
|
Automation Step Name | | Field ID | automation__step__name | | Type | TEXT | | Data Type | dimension |
|
Automation Step Parent ID | | Field ID | automation__step__parent_id | | Type | TEXT | | Data Type | dimension |
|
Automation Step Subject | | Field ID | automation__step__subject | | Type | TEXT | | Data Type | dimension |
|
Automation Step Track Opens | | Field ID | automation__step__track_opens | | Type | BOOLEAN | | Data Type | dimension |
|
Automation Step Tracking Was Disabled | | Field ID | automation__step__tracking_was_disabled | | Type | BOOLEAN | | Data Type | dimension |
|
Automation Step Type | | Field ID | automation__step__type | | Type | TEXT | | Data Type | dimension |
|
Automation Step Unit | | Field ID | automation__step__unit | | Type | TEXT | | Data Type | dimension |
|
Automation Step Updated At | | Field ID | automation__step__updated_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Automation Step Value | | Field ID | automation__step__value | | Type | TEXT | | Data Type | dimension |
|
Automation Trigger Repeatable | | Field ID | automation__trigger_data__repeatable | | Type | BOOLEAN | | Data Type | dimension |
|
Automation Trigger Track Ecommerce | | Field ID | automation__trigger_data__track_ecommerce | | Type | BOOLEAN | | Data Type | dimension |
|
Automation Trigger Valid | | Field ID | automation__trigger_data__valid | | Type | BOOLEAN | | Data Type | dimension |
|
Automation Updated At | | Field ID | automation__updated_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Account ID | | Field ID | campaign__account_id | | Type | TEXT | | Data Type | dimension |
|
Campaign Can Be Scheduled | | Field ID | campaign__can_be_scheduled | | Type | BOOLEAN | | Data Type | dimension |
|
Campaign Created At | | Field ID | campaign__created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Delivery Schedule | | Field ID | campaign__delivery_schedule | | Type | TEXT | | Data Type | dimension |
|
Campaign Finished At | | Field ID | campaign__finished_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Has Winner | | Field ID | campaign__has_winner | | Type | TEXT | | Data Type | dimension |
|
Campaign ID | | Field ID | campaign__id | | Type | TEXT | | Data Type | dimension |
|
Campaign Initial Created At | | Field ID | campaign__initial_created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Is Currently Sending Out | | Field ID | campaign__is_currently_sending_out | | Type | BOOLEAN | | Data Type | dimension |
|
Campaign Is Stopped | | Field ID | campaign__is_stopped | | Type | BOOLEAN | | Data Type | dimension |
|
Campaign Name | | Field ID | campaign__name | | Type | TEXT | | Data Type | dimension |
|
Campaign Queued At | | Field ID | campaign__queued_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Scheduled For | | Field ID | campaign__scheduled_for | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Settings Ecommerce Tracking | | Field ID | campaign__settings__ecommerce_tracking | | Type | BOOLEAN | | Data Type | dimension |
|
Campaign Settings Track Opens | | Field ID | campaign__settings__track_opens | | Type | BOOLEAN | | Data Type | dimension |
|
Campaign Settings Use Google Analytics | | Field ID | campaign__settings__use_google_analytics | | Type | BOOLEAN | | Data Type | dimension |
|
Campaign Started At | | Field ID | campaign__started_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Click Rate | | Field ID | campaign__stats__click_rate__float | | Type | PERCENT | | Data Type | metric |
|
Campaign Click To Open Rate | | Field ID | campaign__stats__click_to_open_rate__float | | Type | PERCENT | | Data Type | metric |
|
Campaign Clicks Count | | Field ID | campaign__stats__clicks_count | | Type | NUMBER | | Data Type | metric |
|
Campaign Forwards Count | | Field ID | campaign__stats__forwards_count | | Type | NUMBER | | Data Type | metric |
|
Campaign Hard Bounce Rate | | Field ID | campaign__stats__hard_bounce_rate__float | | Type | PERCENT | | Data Type | metric |
|
Campaign Hard Bounces Count | | Field ID | campaign__stats__hard_bounces_count | | Type | NUMBER | | Data Type | metric |
|
Campaign Open Rate | | Field ID | campaign__stats__open_rate__float | | Type | PERCENT | | Data Type | metric |
|
Campaign Opens Count | | Field ID | campaign__stats__opens_count | | Type | NUMBER | | Data Type | metric |
|
Campaign Sent | | Field ID | campaign__stats__sent | | Type | NUMBER | | Data Type | metric |
|
Campaign Soft Bounce Rate | | Field ID | campaign__stats__soft_bounce_rate__float | | Type | PERCENT | | Data Type | metric |
|
Campaign Soft Bounces Count | | Field ID | campaign__stats__soft_bounces_count | | Type | NUMBER | | Data Type | metric |
|
Campaign Spam Count | | Field ID | campaign__stats__spam_count | | Type | NUMBER | | Data Type | metric |
|
Campaign Spam Rate | | Field ID | campaign__stats__spam_rate__float | | Type | PERCENT | | Data Type | metric |
|
Campaign Unique Clicks Count | | Field ID | campaign__stats__unique_clicks_count | | Type | NUMBER | | Data Type | metric |
|
Campaign Unique Opens Count | | Field ID | campaign__stats__unique_opens_count | | Type | NUMBER | | Data Type | metric |
|
Campaign Unsubscribe Rate | | Field ID | campaign__stats__unsubscribe_rate__float | | Type | PERCENT | | Data Type | metric |
|
Campaign Unsubscribes Count | | Field ID | campaign__stats__unsubscribes_count | | Type | NUMBER | | Data Type | metric |
|
Campaign Status | | Field ID | campaign__status | | Type | TEXT | | Data Type | dimension |
|
Campaign Stopped At | | Field ID | campaign__stopped_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Type | | Field ID | campaign__type | | Type | TEXT | | Data Type | dimension |
|
Campaign Type For Humans | | Field ID | campaign__type_for_humans | | Type | TEXT | | Data Type | dimension |
|
Campaign Updated At | | Field ID | campaign__updated_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Used In Automations | | Field ID | campaign__used_in_automations | | Type | BOOLEAN | | Data Type | dimension |
|
Campaign Uses Ecommerce | | Field ID | campaign__uses_ecommerce | | Type | BOOLEAN | | Data Type | dimension |
|
Campaign Uses Survey | | Field ID | campaign__uses_survey | | Type | BOOLEAN | | Data Type | dimension |
|
Campaign Winner Selected Manually At | | Field ID | campaign__winner_selected_manually_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Campaign Winner Sending Time | | Field ID | campaign__winner_sending_time_for_humans | | Type | TEXT | | Data Type | dimension |
|
Campaign Winner Version | | Field ID | campaign__winner_version_for_human | | Type | TEXT | | Data Type | dimension |
|
Campaign Language ISO639 | | Field ID | campaign_language__iso639 | | Type | TEXT | | Data Type | dimension |
|
Campaign Language | | Field ID | campaign_language__name | | Type | TEXT | | Data Type | dimension |
|
Campaign Language Short Code | | Field ID | campaign_language__shortCode | | Type | TEXT | | Data Type | dimension |
|
Field ID | | Field ID | field__id | | Type | TEXT | | Data Type | dimension |
|
Field Key | | Field ID | field__key | | Type | TEXT | | Data Type | dimension |
|
Field Name | | Field ID | field__name | | Type | TEXT | | Data Type | dimension |
|
Field Type | | Field ID | field__type | | Type | TEXT | | Data Type | dimension |
|
Form Active | | Field ID | form__active | | Type | BOOLEAN | | Data Type | dimension |
|
Form Can Update | | Field ID | form__can__update | | Type | BOOLEAN | | Data Type | dimension |
|
Form Conversion Rate | | Field ID | form__conversion_rate__float | | Type | PERCENT | | Data Type | metric |
|
Form Conversions Count | | Field ID | form__conversions_count | | Type | NUMBER | | Data Type | metric |
|
Form Created At | | Field ID | form__created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Form Double Opt-in | | Field ID | form__double_optin | | Type | BOOLEAN | | Data Type | dimension |
|
Form Has Content | | Field ID | form__has_content | | Type | BOOLEAN | | Data Type | dimension |
|
Form ID | | Field ID | form__id | | Type | TEXT | | Data Type | dimension |
|
Form Is Broken | | Field ID | form__is_broken | | Type | BOOLEAN | | Data Type | dimension |
|
Form Last Registration At | | Field ID | form__last_registration_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Form Name | | Field ID | form__name | | Type | TEXT | | Data Type | dimension |
|
Form Opens Count | | Field ID | form__opens_count | | Type | NUMBER | | Data Type | metric |
|
Form Screenshot URL | | Field ID | form__screenshot_url | | Type | TEXT | | Data Type | dimension |
|
Form Slug | | Field ID | form__slug | | Type | TEXT | | Data Type | dimension |
|
Form Type | | Field ID | form__type | | Type | TEXT | | Data Type | dimension |
|
Form Updated At | | Field ID | form__updated_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Form Used In Automations | | Field ID | form__used_in_automations | | Type | BOOLEAN | | Data Type | dimension |
|
Group Active Count | | Field ID | group__active_count | | Type | NUMBER | | Data Type | metric |
|
Group Bounced Count | | Field ID | group__bounced_count | | Type | NUMBER | | Data Type | metric |
|
Group Click Rate | | Field ID | group__click_rate__float | | Type | PERCENT | | Data Type | metric |
|
Group Clicks Count | | Field ID | group__clicks_count | | Type | NUMBER | | Data Type | metric |
|
Group Created At | | Field ID | group__created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Group ID | | Field ID | group__id | | Type | TEXT | | Data Type | dimension |
|
Group Junk Count | | Field ID | group__junk_count | | Type | NUMBER | | Data Type | metric |
|
Group Name | | Field ID | group__name | | Type | TEXT | | Data Type | dimension |
|
Group Open Rate | | Field ID | group__open_rate__float | | Type | PERCENT | | Data Type | metric |
|
Group Opens Count | | Field ID | group__opens_count | | Type | NUMBER | | Data Type | metric |
|
Group Sent Count | | Field ID | group__sent_count | | Type | NUMBER | | Data Type | metric |
|
Group Unconfirmed Count | | Field ID | group__unconfirmed_count | | Type | NUMBER | | Data Type | metric |
|
Group Unsubscribed Count | | Field ID | group__unsubscribed_count | | Type | NUMBER | | Data Type | metric |
|
Segment Click Rate | | Field ID | segment__click_rate__float | | Type | PERCENT | | Data Type | metric |
|
Segment Created At | | Field ID | segment__created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Segment ID | | Field ID | segment__id | | Type | TEXT | | Data Type | dimension |
|
Segment Name | | Field ID | segment__name | | Type | TEXT | | Data Type | dimension |
|
Segment Open Rate | | Field ID | segment__open_rate__float | | Type | PERCENT | | Data Type | metric |
|
Segment Total | | Field ID | segment__total | | Type | NUMBER | | Data Type | metric |
|
Subscriber Click Rate | | Field ID | subscriber__click_rate | | Type | PERCENT | | Data Type | metric |
|
Subscriber Clicks Count | | Field ID | subscriber__clicks_count | | Type | NUMBER | | Data Type | metric |
|
Subscriber Created At | | Field ID | subscriber__created_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Subscriber Email | | Field ID | subscriber__email | | Type | TEXT | | Data Type | dimension |
|
Subscriber City | | Field ID | subscriber__fields__city | | Type | TEXT | | Data Type | dimension |
|
Subscriber Company | | Field ID | subscriber__fields__company | | Type | TEXT | | Data Type | dimension |
|
Subscriber Country | | Field ID | subscriber__fields__country | | Type | TEXT | | Data Type | dimension |
|
Subscriber Last Name | | Field ID | subscriber__fields__last_name | | Type | TEXT | | Data Type | dimension |
|
Subscriber First Name | | Field ID | subscriber__fields__name | | Type | TEXT | | Data Type | dimension |
|
Subscriber Phone | | Field ID | subscriber__fields__phone | | Type | TEXT | | Data Type | dimension |
|
Subscriber State | | Field ID | subscriber__fields__state | | Type | TEXT | | Data Type | dimension |
|
Subscriber ZIP | | Field ID | subscriber__fields__z_i_p | | Type | TEXT | | Data Type | dimension |
|
Subscriber ID | | Field ID | subscriber__id | | Type | TEXT | | Data Type | dimension |
|
Subscriber IP Address | | Field ID | subscriber__ip_address | | Type | TEXT | | Data Type | dimension |
|
Subscriber Open Rate | | Field ID | subscriber__open_rate | | Type | PERCENT | | Data Type | metric |
|
Subscriber Opens Count | | Field ID | subscriber__opens_count | | Type | NUMBER | | Data Type | metric |
|
Subscriber Opted In At | | Field ID | subscriber__opted_in_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Subscriber Opt-in IP | | Field ID | subscriber__optin_ip | | Type | TEXT | | Data Type | dimension |
|
Subscriber Sent Count | | Field ID | subscriber__sent | | Type | NUMBER | | Data Type | metric |
|
Subscriber Source | | Field ID | subscriber__source | | Type | TEXT | | Data Type | dimension |
|
Subscriber Status | | Field ID | subscriber__status | | Type | TEXT | | Data Type | dimension |
|
Subscriber Subscribed At | | Field ID | subscriber__subscribed_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Subscriber Unsubscribed At | | Field ID | subscriber__unsubscribed_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Subscriber Updated At | | Field ID | subscriber__updated_at | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Timezone ID | | Field ID | timezone__id | | Type | TEXT | | Data Type | dimension |
|
Timezone Name | | Field ID | timezone__name | | Type | TEXT | | Data Type | dimension |
|
Timezone Name For Humans | | Field ID | timezone__name_for_humans | | Type | TEXT | | Data Type | dimension |
|
Timezone Offset | | Field ID | timezone__offset | | Type | NUMBER | | Data Type | dimension |
|
Timezone Offset Name | | Field ID | timezone__offset_name | | Type | TEXT | | Data Type | dimension |
|
.svg){kind=logo}