API Connectors

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

Apsis One Connector Reference

3 metrics34 dimensions
Fields

The Apsis One connector exposes 37 fields (3 metrics, 34 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Apsis One Fields

The Apsis One connector includes 37 fields.

ID Type Name Description
abuse_section TEXT Abuse Section Discriminator of the abuse (Only for ABUSE events).
account_id TEXT Account ID The account ID
activity_name TEXT Activity Name The name of the email activity
address TEXT Address Primary email address attribute of the targeted profile (from the same data section as the event)
bounce_code TEXT Bounce Code Bounce code (Only for BOUNCED events).
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
date DATE Date Date of the events
day_of_month TEXT Day of month Day of the month
device TEXT Device Device type (Only for CLICKED and OPENED events).
event_count NUMERIC Event Count Count of current event type
event_time TIMESTAMP Event Time Time of the event reported by the event source. This feature was introduced at the beginning of 2020 so events prior to that may have event_time equal to 0. The value of 0 is also possible when the event source did not specify the event time. The dates in 1970 are possible when the event source specified the event time as 0 since they're interpreted as Unix epoch.
event_type TEXT Event Type Type of the event
event_uniqueness_id NUMERIC (Internal) Event Uniqueness Id (Internal) Custom field to count unique events
TEXT Link Id ID of the link (Only for CLICKED events).
TEXT Link Title Title given to the link in the email template (Only for CLICKED events).
TEXT Link Url URL of the link target (Only for CLICKED events).
location TEXT Location Only for CLICKED and OPENED events.
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
sender TEXT Sender Email sender name
source TEXT Source The name of the Windsor connector returning the row
subject TEXT Subject Email subject
today DATE Today Today's date
unique_event_count NUMERIC Unique Event Count Unique count of current event type
unsubscribe_topic TEXT Unsubscribe Topic Discriminator of the unsubscribed topic (Only for UNSUBSCRIBED events).
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