Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your lemlist data to
lemlist Connector Reference
16 metrics99 dimensions
The lemlist connector exposes 115 fields (16 metrics, 99 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
lemlist Fields
lemlist activities fields
The activities report of the lemlist connector includes 43 fields.
lemlist activities fields (activities___id to activities__sequencestep)
| ID | Type | Name | Description |
|---|---|---|---|
| activities___id | TEXT | activities._id | activities._id |
| activities__campaignId | TEXT | (Deprecated) activities.campaignId | Deprecated, use activities__campaignid instead. |
| activities__campaignid | TEXT | activities.campaignId | activities.campaignId |
| activities__campaignName | TEXT | (Deprecated) activities.campaignName | Deprecated, use activities__campaignname instead. |
| activities__campaignname | TEXT | activities.campaignName | activities.campaignName |
| activities__companyName | TEXT | (Deprecated) activities.companyName | Deprecated, use activities__companyname instead. |
| activities__companyname | TEXT | activities.companyName | activities.companyName |
| activities__createdAt | TEXT | (Deprecated) activities.createdAt | Deprecated, use activities__createdat instead. |
| activities__createdat | TEXT | activities.createdAt | activities.createdAt |
| activities__createdBy | TEXT | (Deprecated) activities.createdBy | Deprecated, use activities__createdby instead. |
| activities__createdby | TEXT | activities.createdBy | activities.createdBy |
| activities__email | TEXT | activities.email | activities.email |
| activities__emailTemplateId | TEXT | (Deprecated) activities.emailTemplateId | Deprecated, use activities__emailtemplateid instead. |
| activities__emailtemplateid | TEXT | activities.emailTemplateId | activities.emailTemplateId |
| activities__emailTemplateName | TEXT | (Deprecated) activities.emailTemplateName | Deprecated, use activities__emailtemplatename instead. |
| activities__emailtemplatename | TEXT | activities.emailTemplateName | activities.emailTemplateName |
| activities__extra | OBJECT | activities.extra | activities.extra |
| activities__firstName | TEXT | (Deprecated) activities.firstName | Deprecated, use activities__firstname instead. |
| activities__firstname | TEXT | activities.firstName | activities.firstName |
| activities__icebreaker | TEXT | activities.icebreaker | activities.icebreaker |
| activities__isFirst | BOOLEAN | (Deprecated) activities.isFirst | Deprecated, use activities__isfirst instead. |
| activities__isfirst | BOOLEAN | activities.isFirst | activities.isFirst |
| activities__lastName | TEXT | (Deprecated) activities.lastName | Deprecated, use activities__lastname instead. |
| activities__lastname | TEXT | activities.lastName | activities.lastName |
| activities__leadEmail | TEXT | (Deprecated) activities.leadEmail | Deprecated, use activities__leademail instead. |
| activities__leademail | TEXT | activities.leadEmail | activities.leadEmail |
| activities__leadFirstName | TEXT | (Deprecated) activities.leadFirstName | Deprecated, use activities__leadfirstname instead. |
| activities__leadfirstname | TEXT | activities.leadFirstName | activities.leadFirstName |
| activities__leadId | TEXT | (Deprecated) activities.leadId | Deprecated, use activities__leadid instead. |
| activities__leadid | TEXT | activities.leadId | activities.leadId |
| activities__leadLastName | TEXT | (Deprecated) activities.leadLastName | Deprecated, use activities__leadlastname instead. |
| activities__leadlastname | TEXT | activities.leadLastName | activities.leadLastName |
| activities__linkedinUrl | TEXT | (Deprecated) activities.linkedinUrl | Deprecated, use activities__linkedinurl instead. |
| activities__linkedinurl | TEXT | activities.linkedinUrl | activities.linkedinUrl |
| activities__phone | TEXT | activities.phone | activities.phone |
| activities__picture | TEXT | activities.picture | activities.picture |
| activities__sequenceId | TEXT | (Deprecated) activities.sequenceId | Deprecated, use activities__sequenceid instead. |
| activities__sequenceid | TEXT | activities.sequenceId | activities.sequenceId |
| activities__sequenceStep | NUMERIC | (Deprecated) activities.sequenceStep | Deprecated, use activities__sequencestep instead. |
| activities__sequencestep | NUMERIC | activities.sequenceStep | activities.sequenceStep |
lemlist activities fields (activities__teamId to activities__type)
| ID | Type | Name | Description |
|---|---|---|---|
| activities__teamId | TEXT | (Deprecated) activities.teamId | Deprecated, use activities__teamid instead. |
| activities__teamid | TEXT | activities.teamId | activities.teamId |
| activities__type | TEXT | activities.type | activities.type |
lemlist campaign_reports fields
The campaign_reports report of the lemlist connector includes 20 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| campaign_created_at | Campaign Created At | Creation date of the campaign. | |
| campaign_created_by | TEXT | Campaign Created By | Name of the user who created the campaign. |
| campaign_id | TEXT | Campaign ID | Unique identifier of the campaign. |
| campaign_labels | TEXT | Campaign Labels | Labels attached to the campaign. |
| campaign_name | TEXT | Campaign Name | Name of the campaign. |
| campaign_reports__click_rate | PERCENT | Click Rate | Emails clicked divided by emails sent. |
| campaign_reports__emails_clicked | NUMERIC | Emails Clicked | Number of emails with a link clicked. |
| campaign_reports__emails_interested | NUMERIC | Emails Interested | Number of email replies marked as interested. |
| campaign_reports__emails_opened | NUMERIC | Emails Opened | Number of emails opened. |
| campaign_reports__emails_replied | NUMERIC | Emails Replied | Number of email replies received. |
| campaign_reports__emails_sent | NUMERIC | Campaign Emails Sent | Number of emails sent by the campaign. |
| campaign_reports__interested | NUMERIC | Interested Leads | Number of leads marked as interested. |
| campaign_reports__linkedin_replied | NUMERIC | LinkedIn Replies | Number of LinkedIn replies received. |
| campaign_reports__linkedin_sent | NUMERIC | LinkedIn Messages Sent | Number of LinkedIn messages sent by the campaign. |
| campaign_reports__not_interested | NUMERIC | Not Interested Leads | Number of leads marked as not interested. |
| campaign_reports__open_rate | PERCENT | Open Rate | Emails opened divided by emails sent. |
| campaign_reports__reply_rate | PERCENT | Reply Rate | Emails replied divided by emails sent. |
| campaign_reports__reviewed_count | NUMERIC | Reviewed Leads | Number of reviewed leads in the campaign. |
| campaign_reports__total_count | NUMERIC | Campaign Total Leads | Total number of leads in the campaign. |
| campaign_state | TEXT | Campaign State | State of the campaign (e.g. running, paused, ended). |
lemlist campaigns fields
The campaigns report of the lemlist connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| campaigns___id | TEXT | campaigns._id | campaigns._id |
| campaigns__labels | OBJECT | campaigns.labels | campaigns.labels |
| campaigns__name | TEXT | campaigns.name | campaigns.name |
lemlist team fields
The team report of the lemlist connector includes 26 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| team___id | TEXT | team._id | team._id |
| team___updatedAt | TEXT | (Deprecated) team._updatedAt | Deprecated, use team___updatedat instead. |
| team___updatedat | TEXT | team._updatedAt | team._updatedAt |
| team__apiKey | TEXT | (Deprecated) team.apiKey | Deprecated, use team__apikey instead. |
| team__apikey | TEXT | team.apiKey | team.apiKey |
| team__beta | OBJECT | team.beta | team.beta |
| team__billing | OBJECT | team.billing | team.billing |
| team__campaignCron | OBJECT | (Deprecated) team.campaignCron | Deprecated, use team__campaigncron instead. |
| team__campaigncron | OBJECT | team.campaignCron | team.campaignCron |
| team__createdAt | TEXT | (Deprecated) team.createdAt | Deprecated, use team__createdat instead. |
| team__createdat | TEXT | team.createdAt | team.createdAt |
| team__createdBy | TEXT | (Deprecated) team.createdBy | Deprecated, use team__createdby instead. |
| team__createdby | TEXT | team.createdBy | team.createdBy |
| team__ctdCheck | OBJECT | (Deprecated) team.ctdCheck | Deprecated, use team__ctdcheck instead. |
| team__ctdcheck | OBJECT | team.ctdCheck | team.ctdCheck |
| team__dataIntegrityChecksCron | OBJECT | (Deprecated) team.dataIntegrityChecksCron | Deprecated, use team__dataintegritycheckscron instead. |
| team__dataintegritycheckscron | OBJECT | team.dataIntegrityChecksCron | team.dataIntegrityChecksCron |
| team__linkedinLastScannedAt | TEXT | (Deprecated) team.linkedinLastScannedAt | Deprecated, use team__linkedinlastscannedat instead. |
| team__linkedinlastscannedat | TEXT | team.linkedinLastScannedAt | team.linkedinLastScannedAt |
| team__name | TEXT | team.name | team.name |
| team__revenueVisualization | OBJECT | (Deprecated) team.revenueVisualization | Deprecated, use team__revenuevisualization instead. |
| team__revenuevisualization | OBJECT | team.revenueVisualization | team.revenueVisualization |
| team__sequencesSafeCheckCron | OBJECT | (Deprecated) team.sequencesSafeCheckCron | Deprecated, use team__sequencessafecheckcron instead. |
| team__sequencessafecheckcron | OBJECT | team.sequencesSafeCheckCron | team.sequencesSafeCheckCron |
| team__userIds | OBJECT | (Deprecated) team.userIds | Deprecated, use team__userids instead. |
| team__userids | OBJECT | team.userIds | team.userIds |
lemlist other fields
The lemlist connector has 23 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Account ID. | |
| account_name | TEXT | Account Name | Account name. | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| unsubscribes___id | TEXT | unsubscribes._id | unsubscribes._id | unsubscribes |
| unsubscribes__email | TEXT | unsubscribes.email | unsubscribes.email | unsubscribes |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |