ClickMagick Connector Reference

1 metrics55 dimensions

Fields

The ClickMagick connector exposes 56 fields (1 metrics, 55 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

ClickMagick Fields

ClickMagick Actions fields

The Actions report of the ClickMagick connector includes 13 fields.

ID	Type	Name	Description
action_device	TEXT	Action Device	Device type (desktop, mobile, tablet).
action_fbclid	TEXT	Action FBCLID	Facebook click identifier.
action_gclid	TEXT	Action GCLID	Google Ads click identifier.
action_id	TEXT	Action ID	Unique identifier of the action conversion.
action_ip	TEXT	Action IP Address	IP address of the visitor.
action_msclkid	TEXT	Action MSCLKID	Microsoft Ads click identifier.
action_project_id	TEXT	Action Project ID	Project that tracked the action.
action_project_name	TEXT	Action Project Name	Name of the project that tracked the action.
action_timestamp	TIMESTAMP	Action Timestamp	Timestamp of the action.
action_utm_campaign	TEXT	Action UTM Campaign	UTM campaign parameter.
action_utm_medium	TEXT	Action UTM Medium	UTM medium parameter.
action_utm_source	TEXT	Action UTM Source	UTM source parameter.
action_visitor_id	TEXT	Action Visitor ID	Unique visitor identifier.

ClickMagick Engagements fields

The Engagements report of the ClickMagick connector includes 10 fields.

ID	Type	Name	Description
engagement_device	TEXT	Engagement Device	Device type (desktop, mobile, tablet).
engagement_gclid	TEXT	Engagement GCLID	Google Ads click identifier.
engagement_id	TEXT	Engagement ID	Unique identifier of the engagement conversion.
engagement_project_id	TEXT	Engagement Project ID	Project that tracked the engagement.
engagement_project_name	TEXT	Engagement Project Name	Name of the project that tracked the engagement.
engagement_timestamp	TIMESTAMP	Engagement Timestamp	Timestamp of the engagement.
engagement_utm_campaign	TEXT	Engagement UTM Campaign	UTM campaign parameter.
engagement_utm_medium	TEXT	Engagement UTM Medium	UTM medium parameter.
engagement_utm_source	TEXT	Engagement UTM Source	UTM source parameter.
engagement_visitor_id	TEXT	Engagement Visitor ID	Unique visitor identifier.

ClickMagick Sales fields

The Sales report of the ClickMagick connector includes 12 fields.

ID	Type	Name	Description
sale_amount	NUMERIC	Sale Amount	Sale amount.
sale_device	TEXT	Sale Device	Device type (desktop, mobile, tablet).
sale_gclid	TEXT	Sale GCLID	Google Ads click identifier.
sale_id	TEXT	Sale ID	Unique identifier of the sale conversion.
sale_project_id	TEXT	Sale Project ID	Project that tracked the sale.
sale_project_name	TEXT	Sale Project Name	Name of the project that tracked the sale.
sale_shopify_order_id	TEXT	Shopify Order ID	Shopify order ID (last_click attribution only).
sale_timestamp	TIMESTAMP	Sale Timestamp	Timestamp of the sale.
sale_utm_campaign	TEXT	Sale UTM Campaign	UTM campaign parameter.
sale_utm_medium	TEXT	Sale UTM Medium	UTM medium parameter.
sale_utm_source	TEXT	Sale UTM Source	UTM source parameter.
sale_visitor_id	TEXT	Sale Visitor ID	Unique visitor identifier.

ClickMagick other fields

The ClickMagick connector has 21 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
account_id	TEXT	Account ID	The ClickMagick account identifier.	Account
account_name	TEXT	Account name	The ClickMagick account name.	Account
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 record.
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number 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	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