Apsis One Connector Reference

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
link_id	TEXT	Link Id	ID of the link (Only for CLICKED events).
link_title	TEXT	Link Title	Title given to the link in the email template (Only for CLICKED events).
link_url	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