Hawk DSP Connector Reference

The Hawk DSP connector exposes 41 fields (15 metrics, 26 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Hawk DSP Fields

Hawk DSP Campaigns fields

The Campaigns report of the Hawk DSP connector includes 21 fields.

ID	Type	Name	Description
advertiser_id	TEXT	Advertiser ID	The identifier of the advertiser.
campaign	TEXT	Campaign	The name of the campaign (Hawk order).
campaign_id	TEXT	Campaign ID	The unique identifier of the campaign (Hawk order).
clicks	NUMERIC	Clicks	The number of times the ad was clicked.
conversions	NUMERIC	Conversions	The number of conversions attributed to the campaign.
cpc	NUMERIC	CPC	Average cost per click (USD spend divided by clicks).
cpm	NUMERIC	CPM	Cost per thousand impressions (USD).
ctr	PERCENT	CTR	Click-through rate (clicks divided by impressions).
currency	TEXT	Currency	The order's currency, the unit of Spend (Local Currency). Spend, CPC and CPM are in USD.
date	DATE	Date	The date of the report metrics.
impressions	NUMERIC	Impressions	The number of times the ad was shown.
media_plan_id	TEXT	Media Plan ID	The identifier of the media plan the campaign belongs to.
spend	NUMERIC	Spend	Media cost in USD.
spend_local	NUMERIC	Spend (Local Currency)	Media cost in the order's local currency (see Currency).
store_visits	NUMERIC	Store Visits	The number of in-store visits generated by the campaign.
vcr	PERCENT	VCR	Video completion rate (completes divided by starts).
video_completes	NUMERIC	Video Completes	The number of completed video views.
video_first_quartile	NUMERIC	Video First Quartile	Video views reaching 25% completion.
video_midpoint	NUMERIC	Video Midpoint	Video views reaching 50% completion.
video_starts	NUMERIC	Video Starts	The number of video starts.
video_third_quartile	NUMERIC	Video Third Quartile	Video views reaching 75% completion.

Hawk DSP other fields

The Hawk DSP connector has 20 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	Account ID in Windsor.ai.
account_name	TEXT	Account Name	Account name in Windsor.ai.
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
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