Connectif Connector Reference

The Connectif connector exposes 35 fields (13 metrics, 22 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Connectif Fields

Connectif EmailCampaigns fields

The EmailCampaigns report of the Connectif connector includes 20 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The id of the Connectif Data Explorer report the account was created with.
account_name	TEXT	Account Name	The Connectif store name.
campaign	TEXT	Campaign	The name of the email.
date	DATE	Date	The start of the week the metrics are grouped into.
email_click_through_rate	PERCENT	Email Click Through Rate	Unique clicks divided by emails sent.
email_click_to_open_rate	PERCENT	Email Click To Open Rate	Unique clicks divided by unique opens.
email_conversion_rate	PERCENT	Email Conversion Rate	Purchases attributed to email divided by emails sent.
email_open_rate	PERCENT	Email Open Rate	Unique opens divided by emails sent.
email_unsubscribe_rate	PERCENT	Email Unsubscribe Rate	Unsubscribes divided by emails sent.
emails_sent	NUMERIC	Emails Sent	The number of emails sent.
month	TEXT	Month	The month the metrics are grouped into.
purchases_attributed	NUMERIC	Purchases Attributed To Email	The number of purchases attributed to email.
total_clicks	NUMERIC	Total Clicks	The total number of email clicks.
total_opens	NUMERIC	Total Opens	The total number of email opens.
total_purchase_amount	NUMERIC	Total Purchase Amount	The total amount of purchases attributed to email.
unique_clicks	NUMERIC	Unique Clicks	The number of unique email clicks.
unique_opens	NUMERIC	Unique Opens	The number of unique email opens.
unsubscribes	NUMERIC	Unsubscribes	The number of unsubscribes.
week	TEXT	Week	The ISO week the metrics are grouped into.
year	TEXT	Year	The year the metrics are grouped into.

Connectif other fields

The Connectif connector has 15 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	TIMESTAMP	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
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
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_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