Windsor brings all your MailerLite data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
MailerLite Field Reference
Fields
Id | Type | Name | Description | Report |
---|---|---|---|---|
automations__broken | BOOLEAN | automations.broken | automations.broken | automations |
automations__complete | BOOLEAN | automations.complete | automations.complete | automations |
automations__created_at | TEXT | automations.created_at | automations.created_at | automations |
automations__emails_count | NUMERIC | automations.emails_count | automations.emails_count | automations |
automations__enabled | BOOLEAN | automations.enabled | automations.enabled | automations |
automations__first_email_screenshot_url | TEXT | automations.first_email_screenshot_url | automations.first_email_screenshot_url | automations |
automations__has_banned_content | BOOLEAN | automations.has_banned_content | automations.has_banned_content | automations |
automations__id | TEXT | automations.id | automations.id | automations |
automations__name | TEXT | automations.name | automations.name | automations |
automations__qualified_subscribers_count | NUMERIC | automations.qualified_subscribers_count | automations.qualified_subscribers_count | automations |
automations__stats | OBJECT | automations.stats | automations.stats | automations |
automations__steps | OBJECT | automations.steps | automations.steps | automations |
automations__trigger_data | OBJECT | automations.trigger_data | automations.trigger_data | automations |
automations__triggers | OBJECT | automations.triggers | automations.triggers | automations |
automations__warnings | OBJECT | automations.warnings | automations.warnings | automations |
campaigns__account_id | TEXT | campaigns.account_id | campaigns.account_id | campaigns |
campaigns__can_be_scheduled | BOOLEAN | campaigns.can_be_scheduled | campaigns.can_be_scheduled | campaigns |
campaigns__created_at | TEXT | campaigns.created_at | campaigns.created_at | campaigns |
campaigns__default_email_id | TEXT | campaigns.default_email_id | campaigns.default_email_id | campaigns |
campaigns__delivery_schedule | TEXT | campaigns.delivery_schedule | campaigns.delivery_schedule | campaigns |
campaigns__emails | OBJECT | campaigns.emails | campaigns.emails | campaigns |
campaigns__filter | OBJECT | campaigns.filter | campaigns.filter | campaigns |
campaigns__filter_for_humans | OBJECT | campaigns.filter_for_humans | campaigns.filter_for_humans | campaigns |
campaigns__finished_at | TEXT | campaigns.finished_at | campaigns.finished_at | campaigns |
campaigns__has_winner | TEXT | campaigns.has_winner | campaigns.has_winner | campaigns |
campaigns__id | TEXT | campaigns.id | campaigns.id | campaigns |
campaigns__initial_created_at | TEXT | campaigns.initial_created_at | campaigns.initial_created_at | campaigns |
campaigns__is_currently_sending_out | BOOLEAN | campaigns.is_currently_sending_out | campaigns.is_currently_sending_out | campaigns |
campaigns__is_stopped | BOOLEAN | campaigns.is_stopped | campaigns.is_stopped | campaigns |
campaigns__language_id | TEXT | campaigns.language_id | campaigns.language_id | campaigns |
campaigns__missing_data | OBJECT | campaigns.missing_data | campaigns.missing_data | campaigns |
campaigns__name | TEXT | campaigns.name | campaigns.name | campaigns |
campaigns__queued_at | TEXT | campaigns.queued_at | campaigns.queued_at | campaigns |
campaigns__scheduled_for | TEXT | campaigns.scheduled_for | campaigns.scheduled_for | campaigns |
campaigns__settings | OBJECT | campaigns.settings | campaigns.settings | campaigns |
campaigns__started_at | TEXT | campaigns.started_at | campaigns.started_at | campaigns |
campaigns__stats | OBJECT | campaigns.stats | campaigns.stats | campaigns |
campaigns__status | TEXT | campaigns.status | campaigns.status | campaigns |
campaigns__stopped_at | TEXT | campaigns.stopped_at | campaigns.stopped_at | campaigns |
campaigns__type | TEXT | campaigns.type | campaigns.type | campaigns |
campaigns__type_for_humans | TEXT | campaigns.type_for_humans | campaigns.type_for_humans | campaigns |
campaigns__updated_at | TEXT | campaigns.updated_at | campaigns.updated_at | campaigns |
campaigns__used_in_automations | BOOLEAN | campaigns.used_in_automations | campaigns.used_in_automations | campaigns |
campaigns__uses_ecommerce | BOOLEAN | campaigns.uses_ecommerce | campaigns.uses_ecommerce | campaigns |
campaigns__uses_survey | BOOLEAN | campaigns.uses_survey | campaigns.uses_survey | campaigns |
campaigns__warnings | OBJECT | campaigns.warnings | campaigns.warnings | campaigns |
campaigns__winner_selected_manually_at | TEXT | campaigns.winner_selected_manually_at | campaigns.winner_selected_manually_at | campaigns |
campaigns__winner_sending_time_for_humans | TEXT | campaigns.winner_sending_time_for_humans | campaigns.winner_sending_time_for_humans | campaigns |
campaigns__winner_version_for_human | TEXT | campaigns.winner_version_for_human | campaigns.winner_version_for_human | campaigns |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
forms_embedded__active | BOOLEAN | forms_embedded.active | forms_embedded.active | forms_embedded |
forms_embedded__can | OBJECT | forms_embedded.can | forms_embedded.can | forms_embedded |
forms_embedded__conversion_rate | OBJECT | forms_embedded.conversion_rate | forms_embedded.conversion_rate | forms_embedded |
forms_embedded__conversions_count | NUMERIC | forms_embedded.conversions_count | forms_embedded.conversions_count | forms_embedded |
forms_embedded__created_at | TEXT | forms_embedded.created_at | forms_embedded.created_at | forms_embedded |
forms_embedded__double_optin | BOOLEAN | forms_embedded.double_optin | forms_embedded.double_optin | forms_embedded |
forms_embedded__groups | OBJECT | forms_embedded.groups | forms_embedded.groups | forms_embedded |
forms_embedded__has_content | BOOLEAN | forms_embedded.has_content | forms_embedded.has_content | forms_embedded |
forms_embedded__has_missing_groups | BOOLEAN | forms_embedded.has_missing_groups | forms_embedded.has_missing_groups | forms_embedded |
forms_embedded__id | TEXT | forms_embedded.id | forms_embedded.id | forms_embedded |
forms_embedded__is_broken | BOOLEAN | forms_embedded.is_broken | forms_embedded.is_broken | forms_embedded |
forms_embedded__last_registration_at | TEXT | forms_embedded.last_registration_at | forms_embedded.last_registration_at | forms_embedded |
forms_embedded__name | TEXT | forms_embedded.name | forms_embedded.name | forms_embedded |
forms_embedded__opens_count | NUMERIC | forms_embedded.opens_count | forms_embedded.opens_count | forms_embedded |
forms_embedded__screenshot_url | TEXT | forms_embedded.screenshot_url | forms_embedded.screenshot_url | forms_embedded |
forms_embedded__settings | OBJECT | forms_embedded.settings | forms_embedded.settings | forms_embedded |
forms_embedded__slug | TEXT | forms_embedded.slug | forms_embedded.slug | forms_embedded |
forms_embedded__type | TEXT | forms_embedded.type | forms_embedded.type | forms_embedded |
forms_embedded__used_in_automations | BOOLEAN | forms_embedded.used_in_automations | forms_embedded.used_in_automations | forms_embedded |
forms_embedded__warnings | OBJECT | forms_embedded.warnings | forms_embedded.warnings | forms_embedded |
forms_popup__active | BOOLEAN | forms_popup.active | forms_popup.active | forms_popup |
forms_popup__can | OBJECT | forms_popup.can | forms_popup.can | forms_popup |
forms_popup__conversion_rate | OBJECT | forms_popup.conversion_rate | forms_popup.conversion_rate | forms_popup |
forms_popup__conversions_count | NUMERIC | forms_popup.conversions_count | forms_popup.conversions_count | forms_popup |
forms_popup__created_at | TEXT | forms_popup.created_at | forms_popup.created_at | forms_popup |
forms_popup__double_optin | BOOLEAN | forms_popup.double_optin | forms_popup.double_optin | forms_popup |
forms_popup__groups | OBJECT | forms_popup.groups | forms_popup.groups | forms_popup |
forms_popup__has_content | BOOLEAN | forms_popup.has_content | forms_popup.has_content | forms_popup |
forms_popup__has_missing_groups | BOOLEAN | forms_popup.has_missing_groups | forms_popup.has_missing_groups | forms_popup |
forms_popup__id | TEXT | forms_popup.id | forms_popup.id | forms_popup |
forms_popup__is_broken | BOOLEAN | forms_popup.is_broken | forms_popup.is_broken | forms_popup |
forms_popup__last_registration_at | TEXT | forms_popup.last_registration_at | forms_popup.last_registration_at | forms_popup |
forms_popup__name | TEXT | forms_popup.name | forms_popup.name | forms_popup |
forms_popup__opens_count | NUMERIC | forms_popup.opens_count | forms_popup.opens_count | forms_popup |
forms_popup__screenshot_url | TEXT | forms_popup.screenshot_url | forms_popup.screenshot_url | forms_popup |
forms_popup__settings | OBJECT | forms_popup.settings | forms_popup.settings | forms_popup |
forms_popup__slug | TEXT | forms_popup.slug | forms_popup.slug | forms_popup |
forms_popup__type | TEXT | forms_popup.type | forms_popup.type | forms_popup |
forms_popup__used_in_automations | BOOLEAN | forms_popup.used_in_automations | forms_popup.used_in_automations | forms_popup |
forms_popup__warnings | OBJECT | forms_popup.warnings | forms_popup.warnings | forms_popup |
forms_promotion__active | BOOLEAN | forms_promotion.active | forms_promotion.active | forms_promotion |
forms_promotion__can | OBJECT | forms_promotion.can | forms_promotion.can | forms_promotion |
forms_promotion__conversion_rate | OBJECT | forms_promotion.conversion_rate | forms_promotion.conversion_rate | forms_promotion |
forms_promotion__conversions_count | NUMERIC | forms_promotion.conversions_count | forms_promotion.conversions_count | forms_promotion |
forms_promotion__created_at | TEXT | forms_promotion.created_at | forms_promotion.created_at | forms_promotion |
forms_promotion__double_optin | TEXT | forms_promotion.double_optin | forms_promotion.double_optin | forms_promotion |
forms_promotion__groups | OBJECT | forms_promotion.groups | forms_promotion.groups | forms_promotion |
forms_promotion__has_content | BOOLEAN | forms_promotion.has_content | forms_promotion.has_content | forms_promotion |
forms_promotion__has_missing_groups | BOOLEAN | forms_promotion.has_missing_groups | forms_promotion.has_missing_groups | forms_promotion |
forms_promotion__id | TEXT | forms_promotion.id | forms_promotion.id | forms_promotion |
forms_promotion__is_broken | BOOLEAN | forms_promotion.is_broken | forms_promotion.is_broken | forms_promotion |
forms_promotion__last_registration_at | TEXT | forms_promotion.last_registration_at | forms_promotion.last_registration_at | forms_promotion |
forms_promotion__name | TEXT | forms_promotion.name | forms_promotion.name | forms_promotion |
forms_promotion__opens_count | NUMERIC | forms_promotion.opens_count | forms_promotion.opens_count | forms_promotion |
forms_promotion__screenshot_url | TEXT | forms_promotion.screenshot_url | forms_promotion.screenshot_url | forms_promotion |
forms_promotion__settings | OBJECT | forms_promotion.settings | forms_promotion.settings | forms_promotion |
forms_promotion__slug | TEXT | forms_promotion.slug | forms_promotion.slug | forms_promotion |
forms_promotion__type | TEXT | forms_promotion.type | forms_promotion.type | forms_promotion |
forms_promotion__used_in_automations | BOOLEAN | forms_promotion.used_in_automations | forms_promotion.used_in_automations | forms_promotion |
forms_promotion__warnings | OBJECT | forms_promotion.warnings | forms_promotion.warnings | forms_promotion |
segments__click_rate | OBJECT | segments.click_rate | segments.click_rate | segments |
segments__created_at | TEXT | segments.created_at | segments.created_at | segments |
segments__id | TEXT | segments.id | segments.id | segments |
segments__name | TEXT | segments.name | segments.name | segments |
segments__open_rate | OBJECT | segments.open_rate | segments.open_rate | segments |
segments__total | NUMERIC | segments.total | segments.total | segments |
source | TEXT | Source | The name of the Windsor connector returning the row | |
subscribers__click_rate | NUMERIC | subscribers.click_rate | subscribers.click_rate | subscribers |
subscribers__clicks_count | NUMERIC | subscribers.clicks_count | subscribers.clicks_count | subscribers |
subscribers__created_at | TEXT | subscribers.created_at | subscribers.created_at | subscribers |
subscribers__email | TEXT | subscribers.email | subscribers.email | subscribers |
subscribers__fields | OBJECT | subscribers.fields | subscribers.fields | subscribers |
subscribers__id | TEXT | subscribers.id | subscribers.id | subscribers |
subscribers__ip_address | TEXT | subscribers.ip_address | subscribers.ip_address | subscribers |
subscribers__open_rate | NUMERIC | subscribers.open_rate | subscribers.open_rate | subscribers |
subscribers__opens_count | NUMERIC | subscribers.opens_count | subscribers.opens_count | subscribers |
subscribers__opted_in_at | TEXT | subscribers.opted_in_at | subscribers.opted_in_at | subscribers |
subscribers__optin_ip | TEXT | subscribers.optin_ip | subscribers.optin_ip | subscribers |
subscribers__sent | NUMERIC | subscribers.sent | subscribers.sent | subscribers |
subscribers__source | TEXT | subscribers.source | subscribers.source | subscribers |
subscribers__status | TEXT | subscribers.status | subscribers.status | subscribers |
subscribers__subscribed_at | TEXT | subscribers.subscribed_at | subscribers.subscribed_at | subscribers |
subscribers__unsubscribed_at | TEXT | subscribers.unsubscribed_at | subscribers.unsubscribed_at | subscribers |
subscribers__updated_at | TEXT | subscribers.updated_at | subscribers.updated_at | subscribers |
timezones__id | TEXT | timezones.id | timezones.id | timezones |
timezones__name | TEXT | timezones.name | timezones.name | timezones |
timezones__name_for_humans | TEXT | timezones.name_for_humans | timezones.name_for_humans | timezones |
timezones__offset | NUMERIC | timezones.offset | timezones.offset | timezones |
timezones__offset_name | TEXT | timezones.offset_name | timezones.offset_name | timezones |
today | DATE | Today | Today's date |