Windsor brings all your Customer.io data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Customer.io Field Reference

Fields

ID	Type	Name	Description	Report
campaigns__actions	OBJECT	campaigns.actions	campaigns.actions	campaigns
campaigns__active	BOOLEAN	campaigns.active	campaigns.active	campaigns
campaigns__created	NUMERIC	campaigns.created	campaigns.created	campaigns
campaigns__created_by	TEXT	campaigns.created_by	campaigns.created_by	campaigns
campaigns__date_attribute	TEXT	campaigns.date_attribute	campaigns.date_attribute	campaigns
campaigns__deduplicate_id	TEXT	campaigns.deduplicate_id	campaigns.deduplicate_id	campaigns
campaigns__event_name	TEXT	campaigns.event_name	campaigns.event_name	campaigns
campaigns__first_started	NUMERIC	campaigns.first_started	campaigns.first_started	campaigns
campaigns__frequency	TEXT	campaigns.frequency	campaigns.frequency	campaigns
campaigns__id	NUMERIC	campaigns.id	campaigns.id	campaigns
campaigns__msg_templates	OBJECT	campaigns.msg_templates	campaigns.msg_templates	campaigns
campaigns__name	TEXT	campaigns.name	campaigns.name	campaigns
campaigns__start_hour	NUMERIC	campaigns.start_hour	campaigns.start_hour	campaigns
campaigns__start_minutes	NUMERIC	campaigns.start_minutes	campaigns.start_minutes	campaigns
campaigns__state	TEXT	campaigns.state	campaigns.state	campaigns
campaigns__tags	OBJECT	campaigns.tags	campaigns.tags	campaigns
campaigns__timezone	TEXT	campaigns.timezone	campaigns.timezone	campaigns
campaigns__trigger_segment_ids	OBJECT	campaigns.trigger_segment_ids	campaigns.trigger_segment_ids	campaigns
campaigns__type	TEXT	campaigns.type	campaigns.type	campaigns
campaigns__updated	NUMERIC	campaigns.updated	campaigns.updated	campaigns
campaigns__use_customer_timezone	BOOLEAN	campaigns.use_customer_timezone	campaigns.use_customer_timezone	campaigns
campaigns_actions__bcc	TEXT	campaigns_actions.bcc	campaigns_actions.bcc	campaigns_actions
campaigns_actions__body	TEXT	campaigns_actions.body	campaigns_actions.body	campaigns_actions
campaigns_actions__campaign_id	NUMERIC	campaigns_actions.campaign_id	campaigns_actions.campaign_id	campaigns_actions
campaigns_actions__created	NUMERIC	campaigns_actions.created	campaigns_actions.created	campaigns_actions
campaigns_actions__deduplicate_id	TEXT	campaigns_actions.deduplicate_id	campaigns_actions.deduplicate_id	campaigns_actions
campaigns_actions__editor	TEXT	campaigns_actions.editor	campaigns_actions.editor	campaigns_actions
campaigns_actions__fake_bcc	BOOLEAN	campaigns_actions.fake_bcc	campaigns_actions.fake_bcc	campaigns_actions
campaigns_actions__from	TEXT	campaigns_actions.from	campaigns_actions.from	campaigns_actions
campaigns_actions__from_id	TEXT	campaigns_actions.from_id	campaigns_actions.from_id	campaigns_actions
campaigns_actions__headers	TEXT	campaigns_actions.headers	campaigns_actions.headers	campaigns_actions
campaigns_actions__id	TEXT	campaigns_actions.id	campaigns_actions.id	campaigns_actions
campaigns_actions__language	TEXT	campaigns_actions.language	campaigns_actions.language	campaigns_actions
campaigns_actions__layout	TEXT	campaigns_actions.layout	campaigns_actions.layout	campaigns_actions
campaigns_actions__name	TEXT	campaigns_actions.name	campaigns_actions.name	campaigns_actions
campaigns_actions__parent_action_id	NUMERIC	campaigns_actions.parent_action_id	campaigns_actions.parent_action_id	campaigns_actions
campaigns_actions__preheader_text	TEXT	campaigns_actions.preheader_text	campaigns_actions.preheader_text	campaigns_actions
campaigns_actions__preprocessor	TEXT	campaigns_actions.preprocessor	campaigns_actions.preprocessor	campaigns_actions
campaigns_actions__recipient	TEXT	campaigns_actions.recipient	campaigns_actions.recipient	campaigns_actions
campaigns_actions__recipient_environment_id	NUMERIC	campaigns_actions.recipient_environment_id	campaigns_actions.recipient_environment_id	campaigns_actions
campaigns_actions__reply_to	TEXT	campaigns_actions.reply_to	campaigns_actions.reply_to	campaigns_actions
campaigns_actions__reply_to_id	TEXT	campaigns_actions.reply_to_id	campaigns_actions.reply_to_id	campaigns_actions
campaigns_actions__request_method	TEXT	campaigns_actions.request_method	campaigns_actions.request_method	campaigns_actions
campaigns_actions__sending_state	TEXT	campaigns_actions.sending_state	campaigns_actions.sending_state	campaigns_actions
campaigns_actions__subject	TEXT	campaigns_actions.subject	campaigns_actions.subject	campaigns_actions
campaigns_actions__type	TEXT	campaigns_actions.type	campaigns_actions.type	campaigns_actions
campaigns_actions__updated	NUMERIC	campaigns_actions.updated	campaigns_actions.updated	campaigns_actions
campaigns_actions__url	TEXT	campaigns_actions.url	campaigns_actions.url	campaigns_actions
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
newsletters__content_ids	OBJECT	newsletters.content_ids	newsletters.content_ids	newsletters
newsletters__created	NUMERIC	newsletters.created	newsletters.created	newsletters
newsletters__deduplicate_id	TEXT	newsletters.deduplicate_id	newsletters.deduplicate_id	newsletters
newsletters__id	NUMERIC	newsletters.id	newsletters.id	newsletters
newsletters__name	TEXT	newsletters.name	newsletters.name	newsletters
newsletters__sent_at	OBJECT	newsletters.sent_at	newsletters.sent_at	newsletters
newsletters__tags	OBJECT	newsletters.tags	newsletters.tags	newsletters
newsletters__type	TEXT	newsletters.type	newsletters.type	newsletters
newsletters__updated	NUMERIC	newsletters.updated	newsletters.updated	newsletters
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date