API Connectors

users-love-us medal soc2
Send your Connectif data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Connectif Connector Reference

13 metrics22 dimensions
Fields

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