Introduction

Datasources and destinations

Fields listing for MailerLite

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

54 metrics137 dimensions

191 fields

All fields
FieldDetails
Automation Created At
Field IDautomation__created_at
DimensionYEAR_MONTH_DAY_SECOND
Automation Enabled
Field IDautomation__enabled
DimensionTEXT
Automation ID
Field IDautomation__id
DimensionTEXT
Automation Name
Field IDautomation__name
DimensionTEXT
Automation Step Complete
Field IDautomation__step__complete
DimensionBOOLEAN
Automation Step Created At
Field IDautomation__step__created_at
DimensionYEAR_MONTH_DAY_SECOND
Automation Step Description
Field IDautomation__step__description
DimensionTEXT
Automation Step Email Account ID
Field IDautomation__step__email__account_id
DimensionTEXT
Automation Step Email Click Rate
Field IDautomation__step__email__stats__click_rate__float
MetricPERCENT
Automation Step Email Clicks Count
Field IDautomation__step__email__stats__clicks_count
MetricNUMBER
Automation Step Email Created At
Field IDautomation__step__email__created_at
DimensionYEAR_MONTH_DAY_SECOND
Automation Step Email Emailable ID
Field IDautomation__step__email__emailable_id
DimensionTEXT
Automation Step Email Emailable Type
Field IDautomation__step__email__emailable_type
DimensionTEXT
Automation Step Email Forwards Count
Field IDautomation__step__email__stats__forwards_count
MetricNUMBER
Automation Step Email From
Field IDautomation__step__email__from
DimensionTEXT
Automation Step Email From Name
Field IDautomation__step__email__from_name
DimensionTEXT
Automation Step Email Hard Bounce Rate
Field IDautomation__step__email__stats__hard_bounce_rate__float
MetricPERCENT
Automation Step Email Hard Bounces Count
Field IDautomation__step__email__stats__hard_bounces_count
MetricNUMBER
Automation Step Email ID
Field IDautomation__step__email_id
DimensionTEXT
Automation Step Email ID (Inner)
Field IDautomation__step__email__id
DimensionTEXT
Automation Step Email Is Designed
Field IDautomation__step__email__is_designed
DimensionBOOLEAN
Automation Step Email Is Winner
Field IDautomation__step__email__is_winner
DimensionBOOLEAN
Automation Step Email Language ID
Field IDautomation__step__email__language_id
DimensionNUMBER
Automation Step Email Name
Field IDautomation__step__email__name
DimensionTEXT
Automation Step Email Open Rate
Field IDautomation__step__email__stats__open_rate__float
MetricPERCENT
Automation Step Email Opens Count
Field IDautomation__step__email__stats__opens_count
MetricNUMBER
Automation Step Email Plain Text
Field IDautomation__step__email__plain_text
DimensionTEXT
Automation Step Email Preview URL
Field IDautomation__step__email__preview_url
DimensionTEXT
Automation Step Email Screenshot URL
Field IDautomation__step__email__screenshot_url
DimensionTEXT
Automation Step Email Send After
Field IDautomation__step__email__send_after
DimensionYEAR_MONTH_DAY_SECOND
Automation Step Email Sent
Field IDautomation__step__email__stats__sent
MetricNUMBER
Automation Step Email Soft Bounce Rate
Field IDautomation__step__email__stats__soft_bounce_rate__float
MetricPERCENT
Automation Step Email Soft Bounces Count
Field IDautomation__step__email__stats__soft_bounces_count
MetricNUMBER
Automation Step Email Spam Count
Field IDautomation__step__email__stats__spam_count
MetricNUMBER
Automation Step Email Spam Rate
Field IDautomation__step__email__stats__spam_rate__float
MetricPERCENT
Automation Step Email Subject
Field IDautomation__step__email__subject
DimensionTEXT
Automation Step Email Track Opens
Field IDautomation__step__email__track_opens
DimensionBOOLEAN
Automation Step Email Type
Field IDautomation__step__email__type
DimensionTEXT
Automation Step Email Unique Clicks Count
Field IDautomation__step__email__stats__unique_clicks_count
MetricNUMBER
Automation Step Email Unique Opens Count
Field IDautomation__step__email__stats__unique_opens_count
MetricNUMBER
Automation Step Email Unsubscribe Rate
Field IDautomation__step__email__stats__unsubscribe_rate__float
MetricPERCENT
Automation Step Email Unsubscribes Count
Field IDautomation__step__email__stats__unsubscribes_count
MetricNUMBER
Automation Step Email Updated At
Field IDautomation__step__email__updated_at
DimensionYEAR_MONTH_DAY_SECOND
Automation Step From
Field IDautomation__step__from
DimensionTEXT
Automation Step From Name
Field IDautomation__step__from_name
DimensionTEXT
Automation Step Google Analytics
Field IDautomation__step__google_analytics
DimensionTEXT
Automation Step ID
Field IDautomation__step__id
DimensionTEXT
Automation Step Name
Field IDautomation__step__name
DimensionTEXT
Automation Step Parent ID
Field IDautomation__step__parent_id
DimensionTEXT
Automation Step Subject
Field IDautomation__step__subject
DimensionTEXT
Automation Step Track Opens
Field IDautomation__step__track_opens
DimensionBOOLEAN
Automation Step Tracking Was Disabled
Field IDautomation__step__tracking_was_disabled
DimensionBOOLEAN
Automation Step Type
Field IDautomation__step__type
DimensionTEXT
Automation Step Unit
Field IDautomation__step__unit
DimensionTEXT
Automation Step Updated At
Field IDautomation__step__updated_at
DimensionYEAR_MONTH_DAY_SECOND
Automation Step Value
Field IDautomation__step__value
DimensionTEXT
Automation Trigger Repeatable
Field IDautomation__trigger_data__repeatable
DimensionBOOLEAN
Automation Trigger Track Ecommerce
Field IDautomation__trigger_data__track_ecommerce
DimensionBOOLEAN
Automation Trigger Valid
Field IDautomation__trigger_data__valid
DimensionBOOLEAN
Automation Updated At
Field IDautomation__updated_at
DimensionYEAR_MONTH_DAY_SECOND
Campaign Account ID
Field IDcampaign__account_id
DimensionTEXT
Campaign Can Be Scheduled
Field IDcampaign__can_be_scheduled
DimensionBOOLEAN
Campaign Click Rate
Field IDcampaign__stats__click_rate__float
MetricPERCENT
Campaign Click To Open Rate
Field IDcampaign__stats__click_to_open_rate__float
MetricPERCENT
Campaign Clicks Count
Field IDcampaign__stats__clicks_count
MetricNUMBER
Campaign Created At
Field IDcampaign__created_at
DimensionYEAR_MONTH_DAY_SECOND
Campaign Delivery Schedule
Field IDcampaign__delivery_schedule
DimensionTEXT
Campaign Finished At
Field IDcampaign__finished_at
DimensionYEAR_MONTH_DAY_SECOND
Campaign Forwards Count
Field IDcampaign__stats__forwards_count
MetricNUMBER
Campaign Hard Bounce Rate
Field IDcampaign__stats__hard_bounce_rate__float
MetricPERCENT
Campaign Hard Bounces Count
Field IDcampaign__stats__hard_bounces_count
MetricNUMBER
Campaign Has Winner
Field IDcampaign__has_winner
DimensionTEXT
Campaign ID
Field IDcampaign__id
DimensionTEXT
Campaign Initial Created At
Field IDcampaign__initial_created_at
DimensionYEAR_MONTH_DAY_SECOND
Campaign Is Currently Sending Out
Field IDcampaign__is_currently_sending_out
DimensionBOOLEAN
Campaign Is Stopped
Field IDcampaign__is_stopped
DimensionBOOLEAN
Campaign Language
Field IDcampaign_language__name
DimensionTEXT
Campaign Language ISO639
Field IDcampaign_language__iso639
DimensionTEXT
Campaign Language Short Code
Field IDcampaign_language__shortCode
DimensionTEXT
Campaign Name
Field IDcampaign__name
DimensionTEXT
Campaign Open Rate
Field IDcampaign__stats__open_rate__float
MetricPERCENT
Campaign Opens Count
Field IDcampaign__stats__opens_count
MetricNUMBER
Campaign Queued At
Field IDcampaign__queued_at
DimensionYEAR_MONTH_DAY_SECOND
Campaign Scheduled For
Field IDcampaign__scheduled_for
DimensionYEAR_MONTH_DAY_SECOND
Campaign Sent
Field IDcampaign__stats__sent
MetricNUMBER
Campaign Settings Ecommerce Tracking
Field IDcampaign__settings__ecommerce_tracking
DimensionBOOLEAN
Campaign Settings Track Opens
Field IDcampaign__settings__track_opens
DimensionBOOLEAN
Campaign Settings Use Google Analytics
Field IDcampaign__settings__use_google_analytics
DimensionBOOLEAN
Campaign Soft Bounce Rate
Field IDcampaign__stats__soft_bounce_rate__float
MetricPERCENT
Campaign Soft Bounces Count
Field IDcampaign__stats__soft_bounces_count
MetricNUMBER
Campaign Spam Count
Field IDcampaign__stats__spam_count
MetricNUMBER
Campaign Spam Rate
Field IDcampaign__stats__spam_rate__float
MetricPERCENT
Campaign Started At
Field IDcampaign__started_at
DimensionYEAR_MONTH_DAY_SECOND
Campaign Status
Field IDcampaign__status
DimensionTEXT
Campaign Stopped At
Field IDcampaign__stopped_at
DimensionYEAR_MONTH_DAY_SECOND
Campaign Type
Field IDcampaign__type
DimensionTEXT
Campaign Type For Humans
Field IDcampaign__type_for_humans
DimensionTEXT
Campaign Unique Clicks Count
Field IDcampaign__stats__unique_clicks_count
MetricNUMBER
Campaign Unique Opens Count
Field IDcampaign__stats__unique_opens_count
MetricNUMBER
Campaign Unsubscribe Rate
Field IDcampaign__stats__unsubscribe_rate__float
MetricPERCENT
Campaign Unsubscribes Count
Field IDcampaign__stats__unsubscribes_count
MetricNUMBER
Campaign Updated At
Field IDcampaign__updated_at
DimensionYEAR_MONTH_DAY_SECOND
Campaign Used In Automations
Field IDcampaign__used_in_automations
DimensionBOOLEAN
Campaign Uses Ecommerce
Field IDcampaign__uses_ecommerce
DimensionBOOLEAN
Campaign Uses Survey
Field IDcampaign__uses_survey
DimensionBOOLEAN
Campaign Winner Selected Manually At
Field IDcampaign__winner_selected_manually_at
DimensionYEAR_MONTH_DAY_SECOND
Campaign Winner Sending Time
Field IDcampaign__winner_sending_time_for_humans
DimensionTEXT
Campaign Winner Version
Field IDcampaign__winner_version_for_human
DimensionTEXT
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Field ID
Field IDfield__id
DimensionTEXT
Field Key
Field IDfield__key
DimensionTEXT
Field Name
Field IDfield__name
DimensionTEXT
Field Type
Field IDfield__type
DimensionTEXT
Form Active
Field IDform__active
DimensionBOOLEAN
Form Can Update
Field IDform__can__update
DimensionBOOLEAN
Form Conversion Rate
Field IDform__conversion_rate__float
MetricPERCENT
Form Conversions Count
Field IDform__conversions_count
MetricNUMBER
Form Created At
Field IDform__created_at
DimensionYEAR_MONTH_DAY_SECOND
Form Double Opt-in
Field IDform__double_optin
DimensionBOOLEAN
Form Has Content
Field IDform__has_content
DimensionBOOLEAN
Form ID
Field IDform__id
DimensionTEXT
Form Is Broken
Field IDform__is_broken
DimensionBOOLEAN
Form Last Registration At
Field IDform__last_registration_at
DimensionYEAR_MONTH_DAY_SECOND
Form Name
Field IDform__name
DimensionTEXT
Form Opens Count
Field IDform__opens_count
MetricNUMBER
Form Screenshot URL
Field IDform__screenshot_url
DimensionTEXT
Form Slug
Field IDform__slug
DimensionTEXT
Form Type
Field IDform__type
DimensionTEXT
Form Updated At
Field IDform__updated_at
DimensionYEAR_MONTH_DAY_SECOND
Form Used In Automations
Field IDform__used_in_automations
DimensionBOOLEAN
Group Active Count
Field IDgroup__active_count
MetricNUMBER
Group Bounced Count
Field IDgroup__bounced_count
MetricNUMBER
Group Click Rate
Field IDgroup__click_rate__float
MetricPERCENT
Group Clicks Count
Field IDgroup__clicks_count
MetricNUMBER
Group Created At
Field IDgroup__created_at
DimensionYEAR_MONTH_DAY_SECOND
Group ID
Field IDgroup__id
DimensionTEXT
Group Junk Count
Field IDgroup__junk_count
MetricNUMBER
Group Name
Field IDgroup__name
DimensionTEXT
Group Open Rate
Field IDgroup__open_rate__float
MetricPERCENT
Group Opens Count
Field IDgroup__opens_count
MetricNUMBER
Group Sent Count
Field IDgroup__sent_count
MetricNUMBER
Group Unconfirmed Count
Field IDgroup__unconfirmed_count
MetricNUMBER
Group Unsubscribed Count
Field IDgroup__unsubscribed_count
MetricNUMBER
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Segment Click Rate
Field IDsegment__click_rate__float
MetricPERCENT
Segment Created At
Field IDsegment__created_at
DimensionYEAR_MONTH_DAY_SECOND
Segment ID
Field IDsegment__id
DimensionTEXT
Segment Name
Field IDsegment__name
DimensionTEXT
Segment Open Rate
Field IDsegment__open_rate__float
MetricPERCENT
Segment Total
Field IDsegment__total
MetricNUMBER
Subscriber City
Field IDsubscriber__fields__city
DimensionTEXT
Subscriber Click Rate
Field IDsubscriber__click_rate
MetricPERCENT
Subscriber Clicks Count
Field IDsubscriber__clicks_count
MetricNUMBER
Subscriber Company
Field IDsubscriber__fields__company
DimensionTEXT
Subscriber Country
Field IDsubscriber__fields__country
DimensionTEXT
Subscriber Created At
Field IDsubscriber__created_at
DimensionYEAR_MONTH_DAY_SECOND
Subscriber Email
Field IDsubscriber__email
DimensionTEXT
Subscriber First Name
Field IDsubscriber__fields__name
DimensionTEXT
Subscriber ID
Field IDsubscriber__id
DimensionTEXT
Subscriber IP Address
Field IDsubscriber__ip_address
DimensionTEXT
Subscriber Last Name
Field IDsubscriber__fields__last_name
DimensionTEXT
Subscriber Open Rate
Field IDsubscriber__open_rate
MetricPERCENT
Subscriber Opens Count
Field IDsubscriber__opens_count
MetricNUMBER
Subscriber Opt-in IP
Field IDsubscriber__optin_ip
DimensionTEXT
Subscriber Opted In At
Field IDsubscriber__opted_in_at
DimensionYEAR_MONTH_DAY_SECOND
Subscriber Phone
Field IDsubscriber__fields__phone
DimensionTEXT
Subscriber Sent Count
Field IDsubscriber__sent
MetricNUMBER
Subscriber Source
Field IDsubscriber__source
DimensionTEXT
Subscriber State
Field IDsubscriber__fields__state
DimensionTEXT
Subscriber Status
Field IDsubscriber__status
DimensionTEXT
Subscriber Subscribed At
Field IDsubscriber__subscribed_at
DimensionYEAR_MONTH_DAY_SECOND
Subscriber Unsubscribed At
Field IDsubscriber__unsubscribed_at
DimensionYEAR_MONTH_DAY_SECOND
Subscriber Updated At
Field IDsubscriber__updated_at
DimensionYEAR_MONTH_DAY_SECOND
Subscriber ZIP
Field IDsubscriber__fields__z_i_p
DimensionTEXT
Timezone ID
Field IDtimezone__id
DimensionTEXT
Timezone Name
Field IDtimezone__name
DimensionTEXT
Timezone Name For Humans
Field IDtimezone__name_for_humans
DimensionTEXT
Timezone Offset
Field IDtimezone__offset
DimensionNUMBER
Timezone Offset Name
Field IDtimezone__offset_name
DimensionTEXT
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
AI

ChatGPT

Ask ChatGPT about your Marketing data.
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.