Linking MailerLite as a source
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Contents
The MailerLite connector pulls your MailerLite email marketing data into the PostHog data warehouse.
Adding a data source
- Go to the sources tab of the data pipeline section in PostHog.
- Click + New source and then click Link next to MailerLite.
- You need a MailerLite API key, which you can create in your MailerLite integrations settings.
- Back in PostHog, enter the key in the
API keyfield and click Next. - Select the tables you want to sync, set the sync method and frequency, then click Import.
Once the syncs are complete, you can start using MailerLite data in PostHog.
Available tables
| Table | Description | Sync method |
|---|---|---|
subscribers | Subscribers in your account | Full refresh |
campaigns | Email campaigns | Full refresh |
groups | Subscriber groups | Full refresh |
segments | Subscriber segments | Full refresh |
fields | Custom subscriber field definitions | Full refresh |
automations | Automation workflows | Full refresh |
forms_popup | Pop-up forms | Full refresh |
forms_embedded | Embedded forms | Full refresh |
forms_promotion | Promotion forms | Full refresh |
webhooks | Configured webhooks | Full refresh |
Incremental tables sync only new or updated records on each run. Full refresh tables reload all data on each sync.
Sync limitations
The MailerLite API exposes no server-side timestamp filter on any list endpoint, so every table is full-refresh only.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
subscribers | A subscriber (contact) in the MailerLite account, including status and custom fields. | Webhook, Full refresh | — | — |
campaigns | An email campaign in MailerLite, including its type, status, and delivery settings. | Full refresh | — | — |
groups | A group (segment-like collection) of subscribers in MailerLite. | Full refresh | — | — |
segments | A dynamic segment of subscribers in MailerLite defined by filter conditions. | Full refresh | — | — |
fields | A custom field definition used to store extra data on subscribers. | Full refresh | — | — |
automations | An automation (workflow) in MailerLite that triggers emails based on subscriber events. | Full refresh | — | — |
forms_popup | A pop-up subscription form in MailerLite used to capture new subscribers. | Full refresh | — | — |
forms_embedded | An embedded subscription form in MailerLite used to capture new subscribers. | Full refresh | — | — |
forms_promotion | A promotion form in MailerLite used to display promotional content to visitors. | Full refresh | — | — |
webhooks | A webhook subscription in MailerLite that delivers event notifications to an external URL. | Full refresh | — | — |
campaign_subscriber_activity | One row per recipient of a sent MailerLite campaign, with that recipient's opens and clicks. | Full refresh | — | — |
group_subscribers | Active subscribers in each MailerLite group, one row per group and subscriber. | Full refresh | — | — |
segment_subscribers | Active subscribers that match each MailerLite segment, one row per segment and subscriber. | Full refresh | — | — |
automation_activity | A subscriber's run through a MailerLite automation, whether active, completed, canceled or failed. | Full refresh | — | — |
ecommerce_shops | An external shop connected to the MailerLite account through the E-commerce API. | Full refresh | — | — |
ecommerce_orders | An order placed in a connected shop, one row per shop and order. | Full refresh | — | — |
ecommerce_products | A product synced from a connected shop, one row per shop and product. | Full refresh | — | — |
ecommerce_categories | A product category synced from a connected shop, one row per shop and category. | Full refresh | — | — |