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 Customer.io data to
Customer.io Connector Reference
71 metrics77 dimensions
The Customer.io connector exposes 148 fields (71 metrics, 77 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Customer.io Fields
Customer.io broadcasts fields
The broadcasts report of the Customer.io connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| broadcasts__active | BOOLEAN | broadcasts.active | Whether the broadcast is active. |
| broadcasts__created | NUMERIC | broadcasts.created | Unix timestamp when the broadcast was created. |
| broadcasts__deduplicate_id | TEXT | broadcasts.deduplicate_id | The deduplicate id in the format id:timestamp. |
| broadcasts__id | TEXT | broadcasts.id | The identifier for the broadcast. |
| broadcasts__name | TEXT | broadcasts.name | The name of the broadcast. |
| broadcasts__type | TEXT | broadcasts.type | The type of broadcast. |
| broadcasts__updated | NUMERIC | broadcasts.updated | Unix timestamp when the broadcast was last updated. |
Customer.io broadcasts_metrics fields
The broadcasts_metrics report of the Customer.io connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| broadcasts_metrics__2xx | NUMERIC | broadcasts_metrics.2xx | The number of 2xx webhook responses messages per day. |
| broadcasts_metrics__3xx | NUMERIC | broadcasts_metrics.3xx | The number of 3xx webhook responses messages per day. |
| broadcasts_metrics__4xx | NUMERIC | broadcasts_metrics.4xx | The number of 4xx webhook responses messages per day. |
| broadcasts_metrics__5xx | NUMERIC | broadcasts_metrics.5xx | The number of 5xx webhook responses messages per day. |
| broadcasts_metrics__attempted | NUMERIC | broadcasts_metrics.attempted | The number of attempted messages per day. |
| broadcasts_metrics__bounced | NUMERIC | broadcasts_metrics.bounced | The number of bounced messages per day. |
| broadcasts_metrics__broadcast_id | TEXT | broadcasts_metrics.broadcast_id | The identifier for the broadcast. |
| broadcasts_metrics__clicked | NUMERIC | broadcasts_metrics.clicked | The number of clicked messages per day. |
| broadcasts_metrics__converted | NUMERIC | broadcasts_metrics.converted | The number of converted messages per day. |
| broadcasts_metrics__created | NUMERIC | broadcasts_metrics.created | The number of created messages per day. |
| broadcasts_metrics__deferred | NUMERIC | broadcasts_metrics.deferred | The number of deferred messages per day. |
| broadcasts_metrics__delivered | NUMERIC | broadcasts_metrics.delivered | The number of delivered messages per day. |
| broadcasts_metrics__drafted | NUMERIC | broadcasts_metrics.drafted | The number of drafted messages per day. |
| broadcasts_metrics__failed | NUMERIC | broadcasts_metrics.failed | The number of failed messages per day. |
| broadcasts_metrics__opened | NUMERIC | broadcasts_metrics.opened | The number of opened messages per day. |
| broadcasts_metrics__sent | NUMERIC | broadcasts_metrics.sent | The number of sent messages per day. |
| broadcasts_metrics__spammed | NUMERIC | broadcasts_metrics.spammed | The number of spam complaints messages per day. |
| broadcasts_metrics__suppressed | NUMERIC | broadcasts_metrics.suppressed | The number of suppressed messages per day. |
| broadcasts_metrics__topic_unsubscribed | NUMERIC | broadcasts_metrics.topic_unsubscribed | The number of topic unsubscribed messages per day. |
| broadcasts_metrics__undeliverable | NUMERIC | broadcasts_metrics.undeliverable | The number of undeliverable messages per day. |
| broadcasts_metrics__unsubscribed | NUMERIC | broadcasts_metrics.unsubscribed | The number of unsubscribed messages per day. |
Customer.io campaigns fields
The campaigns report of the Customer.io connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| campaigns__actions | OBJECT | campaigns.actions | campaigns.actions |
| campaigns__active | BOOLEAN | campaigns.active | campaigns.active |
| campaigns__created | NUMERIC | campaigns.created | campaigns.created |
| campaigns__created_by | TEXT | campaigns.created_by | campaigns.created_by |
| campaigns__date_attribute | TEXT | campaigns.date_attribute | campaigns.date_attribute |
| campaigns__deduplicate_id | TEXT | campaigns.deduplicate_id | campaigns.deduplicate_id |
| campaigns__event_name | TEXT | campaigns.event_name | campaigns.event_name |
| campaigns__first_started | NUMERIC | campaigns.first_started | campaigns.first_started |
| campaigns__frequency | TEXT | campaigns.frequency | campaigns.frequency |
| campaigns__id | TEXT | campaigns.id | campaigns.id |
| campaigns__msg_templates | OBJECT | campaigns.msg_templates | campaigns.msg_templates |
| campaigns__name | TEXT | campaigns.name | campaigns.name |
| campaigns__start_hour | NUMERIC | campaigns.start_hour | campaigns.start_hour |
| campaigns__start_minutes | NUMERIC | campaigns.start_minutes | campaigns.start_minutes |
| campaigns__state | TEXT | campaigns.state | campaigns.state |
| campaigns__tags | OBJECT | campaigns.tags | campaigns.tags |
| campaigns__timezone | TEXT | campaigns.timezone | campaigns.timezone |
| campaigns__trigger_segment_ids | OBJECT | campaigns.trigger_segment_ids | campaigns.trigger_segment_ids |
| campaigns__type | TEXT | campaigns.type | campaigns.type |
| campaigns__updated | NUMERIC | campaigns.updated | campaigns.updated |
| campaigns__use_customer_timezone | BOOLEAN | campaigns.use_customer_timezone | campaigns.use_customer_timezone |
Customer.io campaigns_actions fields
The campaigns_actions report of the Customer.io connector includes 27 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| campaigns_actions__bcc | TEXT | campaigns_actions.bcc | campaigns_actions.bcc |
| campaigns_actions__body | TEXT | campaigns_actions.body | campaigns_actions.body |
| campaigns_actions__campaign_id | TEXT | campaigns_actions.campaign_id | campaigns_actions.campaign_id |
| campaigns_actions__created | NUMERIC | campaigns_actions.created | campaigns_actions.created |
| campaigns_actions__deduplicate_id | TEXT | campaigns_actions.deduplicate_id | campaigns_actions.deduplicate_id |
| campaigns_actions__editor | TEXT | campaigns_actions.editor | campaigns_actions.editor |
| campaigns_actions__fake_bcc | BOOLEAN | campaigns_actions.fake_bcc | campaigns_actions.fake_bcc |
| campaigns_actions__from | TEXT | campaigns_actions.from | campaigns_actions.from |
| campaigns_actions__from_id | TEXT | campaigns_actions.from_id | campaigns_actions.from_id |
| campaigns_actions__headers | TEXT | campaigns_actions.headers | campaigns_actions.headers |
| campaigns_actions__id | TEXT | campaigns_actions.id | campaigns_actions.id |
| campaigns_actions__language | TEXT | campaigns_actions.language | campaigns_actions.language |
| campaigns_actions__layout | TEXT | campaigns_actions.layout | campaigns_actions.layout |
| campaigns_actions__name | TEXT | campaigns_actions.name | campaigns_actions.name |
| campaigns_actions__parent_action_id | TEXT | campaigns_actions.parent_action_id | campaigns_actions.parent_action_id |
| campaigns_actions__preheader_text | TEXT | campaigns_actions.preheader_text | campaigns_actions.preheader_text |
| campaigns_actions__preprocessor | TEXT | campaigns_actions.preprocessor | campaigns_actions.preprocessor |
| campaigns_actions__recipient | TEXT | campaigns_actions.recipient | campaigns_actions.recipient |
| campaigns_actions__recipient_environment_id | TEXT | campaigns_actions.recipient_environment_id | campaigns_actions.recipient_environment_id |
| campaigns_actions__reply_to | TEXT | campaigns_actions.reply_to | campaigns_actions.reply_to |
| campaigns_actions__reply_to_id | TEXT | campaigns_actions.reply_to_id | campaigns_actions.reply_to_id |
| campaigns_actions__request_method | TEXT | campaigns_actions.request_method | campaigns_actions.request_method |
| campaigns_actions__sending_state | TEXT | campaigns_actions.sending_state | campaigns_actions.sending_state |
| campaigns_actions__subject | TEXT | campaigns_actions.subject | campaigns_actions.subject |
| campaigns_actions__type | TEXT | campaigns_actions.type | campaigns_actions.type |
| campaigns_actions__updated | NUMERIC | campaigns_actions.updated | campaigns_actions.updated |
| campaigns_actions__url | TEXT | campaigns_actions.url | campaigns_actions.url |
Customer.io campaigns_metrics fields
The campaigns_metrics report of the Customer.io connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| campaigns_metrics__2xx | NUMERIC | campaigns_metrics.2xx | The number of 2xx webhook responses messages per day. |
| campaigns_metrics__3xx | NUMERIC | campaigns_metrics.3xx | The number of 3xx webhook responses messages per day. |
| campaigns_metrics__4xx | NUMERIC | campaigns_metrics.4xx | The number of 4xx webhook responses messages per day. |
| campaigns_metrics__5xx | NUMERIC | campaigns_metrics.5xx | The number of 5xx webhook responses messages per day. |
| campaigns_metrics__attempted | NUMERIC | campaigns_metrics.attempted | The number of attempted messages per day. |
| campaigns_metrics__bounced | NUMERIC | campaigns_metrics.bounced | The number of bounced messages per day. |
| campaigns_metrics__campaign_id | TEXT | campaigns_metrics.campaign_id | The identifier for the campaign. |
| campaigns_metrics__clicked | NUMERIC | campaigns_metrics.clicked | The number of clicked messages per day. |
| campaigns_metrics__converted | NUMERIC | campaigns_metrics.converted | The number of converted messages per day. |
| campaigns_metrics__created | NUMERIC | campaigns_metrics.created | The number of created messages per day. |
| campaigns_metrics__deferred | NUMERIC | campaigns_metrics.deferred | The number of deferred messages per day. |
| campaigns_metrics__delivered | NUMERIC | campaigns_metrics.delivered | The number of delivered messages per day. |
| campaigns_metrics__drafted | NUMERIC | campaigns_metrics.drafted | The number of drafted messages per day. |
| campaigns_metrics__failed | NUMERIC | campaigns_metrics.failed | The number of failed messages per day. |
| campaigns_metrics__opened | NUMERIC | campaigns_metrics.opened | The number of opened messages per day. |
| campaigns_metrics__sent | NUMERIC | campaigns_metrics.sent | The number of sent messages per day. |
| campaigns_metrics__spammed | NUMERIC | campaigns_metrics.spammed | The number of spam complaints messages per day. |
| campaigns_metrics__suppressed | NUMERIC | campaigns_metrics.suppressed | The number of suppressed messages per day. |
| campaigns_metrics__topic_unsubscribed | NUMERIC | campaigns_metrics.topic_unsubscribed | The number of topic unsubscribed messages per day. |
| campaigns_metrics__undeliverable | NUMERIC | campaigns_metrics.undeliverable | The number of undeliverable messages per day. |
| campaigns_metrics__unsubscribed | NUMERIC | campaigns_metrics.unsubscribed | The number of unsubscribed messages per day. |
Customer.io General fields
The General report of the Customer.io connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | The Customer.io account (workspace) identifier. |
| account_name | TEXT | Account Name | The Customer.io account (workspace) name. |
| date | DATE | Date | The day the metrics were recorded. |
Customer.io newsletters fields
The newsletters report of the Customer.io connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| newsletters__content_ids | OBJECT | newsletters.content_ids | newsletters.content_ids |
| newsletters__created | NUMERIC | newsletters.created | newsletters.created |
| newsletters__deduplicate_id | TEXT | newsletters.deduplicate_id | newsletters.deduplicate_id |
| newsletters__id | TEXT | newsletters.id | newsletters.id |
| newsletters__name | TEXT | newsletters.name | newsletters.name |
| newsletters__sent_at | OBJECT | newsletters.sent_at | newsletters.sent_at |
| newsletters__tags | OBJECT | newsletters.tags | newsletters.tags |
| newsletters__type | TEXT | newsletters.type | newsletters.type |
| newsletters__updated | NUMERIC | newsletters.updated | newsletters.updated |
Customer.io newsletters_metrics fields
The newsletters_metrics report of the Customer.io connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| newsletters_metrics__2xx | NUMERIC | newsletters_metrics.2xx | The number of 2xx webhook responses messages per day. |
| newsletters_metrics__3xx | NUMERIC | newsletters_metrics.3xx | The number of 3xx webhook responses messages per day. |
| newsletters_metrics__4xx | NUMERIC | newsletters_metrics.4xx | The number of 4xx webhook responses messages per day. |
| newsletters_metrics__5xx | NUMERIC | newsletters_metrics.5xx | The number of 5xx webhook responses messages per day. |
| newsletters_metrics__attempted | NUMERIC | newsletters_metrics.attempted | The number of attempted messages per day. |
| newsletters_metrics__bounced | NUMERIC | newsletters_metrics.bounced | The number of bounced messages per day. |
| newsletters_metrics__clicked | NUMERIC | newsletters_metrics.clicked | The number of clicked messages per day. |
| newsletters_metrics__converted | NUMERIC | newsletters_metrics.converted | The number of converted messages per day. |
| newsletters_metrics__created | NUMERIC | newsletters_metrics.created | The number of created messages per day. |
| newsletters_metrics__deferred | NUMERIC | newsletters_metrics.deferred | The number of deferred messages per day. |
| newsletters_metrics__delivered | NUMERIC | newsletters_metrics.delivered | The number of delivered messages per day. |
| newsletters_metrics__drafted | NUMERIC | newsletters_metrics.drafted | The number of drafted messages per day. |
| newsletters_metrics__failed | NUMERIC | newsletters_metrics.failed | The number of failed messages per day. |
| newsletters_metrics__newsletter_id | TEXT | newsletters_metrics.newsletter_id | The identifier for the newsletter. |
| newsletters_metrics__opened | NUMERIC | newsletters_metrics.opened | The number of opened messages per day. |
| newsletters_metrics__sent | NUMERIC | newsletters_metrics.sent | The number of sent messages per day. |
| newsletters_metrics__spammed | NUMERIC | newsletters_metrics.spammed | The number of spam complaints messages per day. |
| newsletters_metrics__suppressed | NUMERIC | newsletters_metrics.suppressed | The number of suppressed messages per day. |
| newsletters_metrics__topic_unsubscribed | NUMERIC | newsletters_metrics.topic_unsubscribed | The number of topic unsubscribed messages per day. |
| newsletters_metrics__undeliverable | NUMERIC | newsletters_metrics.undeliverable | The number of undeliverable messages per day. |
| newsletters_metrics__unsubscribed | NUMERIC | newsletters_metrics.unsubscribed | The number of unsubscribed messages per day. |
Customer.io other fields
The Customer.io connector has 18 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 |
|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 |