Windsor brings all your lemlist data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
lemlist Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| activities___id | TEXT | activities._id | activities._id | activities |
| activities__campaignId | TEXT | activities.campaignId | activities.campaignId | activities |
| activities__campaignName | TEXT | activities.campaignName | activities.campaignName | activities |
| activities__companyName | TEXT | activities.companyName | activities.companyName | activities |
| activities__createdAt | TEXT | activities.createdAt | activities.createdAt | activities |
| activities__createdBy | TEXT | activities.createdBy | activities.createdBy | activities |
| activities__email | TEXT | activities.email | activities.email | activities |
| activities__emailTemplateId | TEXT | activities.emailTemplateId | activities.emailTemplateId | activities |
| activities__emailTemplateName | TEXT | activities.emailTemplateName | activities.emailTemplateName | activities |
| activities__extra | OBJECT | activities.extra | activities.extra | activities |
| activities__firstName | TEXT | activities.firstName | activities.firstName | activities |
| activities__icebreaker | TEXT | activities.icebreaker | activities.icebreaker | activities |
| activities__isFirst | BOOLEAN | activities.isFirst | activities.isFirst | activities |
| activities__lastName | TEXT | activities.lastName | activities.lastName | activities |
| activities__leadEmail | TEXT | activities.leadEmail | activities.leadEmail | activities |
| activities__leadFirstName | TEXT | activities.leadFirstName | activities.leadFirstName | activities |
| activities__leadId | TEXT | activities.leadId | activities.leadId | activities |
| activities__leadLastName | TEXT | activities.leadLastName | activities.leadLastName | activities |
| activities__linkedinUrl | TEXT | activities.linkedinUrl | activities.linkedinUrl | activities |
| activities__phone | TEXT | activities.phone | activities.phone | activities |
| activities__picture | TEXT | activities.picture | activities.picture | activities |
| activities__sequenceId | TEXT | activities.sequenceId | activities.sequenceId | activities |
| activities__sequenceStep | NUMERIC | activities.sequenceStep | activities.sequenceStep | activities |
| activities__teamId | TEXT | activities.teamId | activities.teamId | activities |
| activities__type | TEXT | activities.type | activities.type | activities |
| campaigns___id | TEXT | campaigns._id | campaigns._id | campaigns |
| campaigns__labels | OBJECT | campaigns.labels | campaigns.labels | campaigns |
| campaigns__name | TEXT | campaigns.name | campaigns.name | campaigns |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| team___id | TEXT | team._id | team._id | team |
| team___updatedAt | TEXT | team._updatedAt | team._updatedAt | team |
| team__apiKey | TEXT | team.apiKey | team.apiKey | team |
| team__beta | OBJECT | team.beta | team.beta | team |
| team__billing | OBJECT | team.billing | team.billing | team |
| team__campaignCron | OBJECT | team.campaignCron | team.campaignCron | team |
| team__createdAt | TEXT | team.createdAt | team.createdAt | team |
| team__createdBy | TEXT | team.createdBy | team.createdBy | team |
| team__ctdCheck | OBJECT | team.ctdCheck | team.ctdCheck | team |
| team__dataIntegrityChecksCron | OBJECT | team.dataIntegrityChecksCron | team.dataIntegrityChecksCron | team |
| team__linkedinLastScannedAt | TEXT | team.linkedinLastScannedAt | team.linkedinLastScannedAt | team |
| team__name | TEXT | team.name | team.name | team |
| team__revenueVisualization | OBJECT | team.revenueVisualization | team.revenueVisualization | team |
| team__sequencesSafeCheckCron | OBJECT | team.sequencesSafeCheckCron | team.sequencesSafeCheckCron | team |
| team__userIds | OBJECT | team.userIds | team.userIds | team |
| today | DATE | Today | Today's date | |
| unsubscribes___id | TEXT | unsubscribes._id | unsubscribes._id | unsubscribes |
| unsubscribes__email | TEXT | unsubscribes.email | unsubscribes.email | unsubscribes |