Connect Hawk DSP to AI, Sheets, Databases & BI Tools
Windsor.ai's Hawk DSP connector extracts your Hawk DSP data and syncs it to AI assistants like ChatGPT, Claude and Gemini, spreadsheets like Google Sheets and Excel, data warehouses like BigQuery, Snowflake and PostgreSQL, and BI tools like Looker Studio, Power BI and Tableau. Setup takes a few minutes in the browser, no coding required, and you can start for free, no credit card required.
How to connect Hawk DSP to Windsor.ai
- Create your free Windsor.ai account or log in.
- Select Hawk DSP and grant Windsor.ai access to your Hawk DSP data.
- Pick the fields and date range you need and preview the data.
- Choose a destination and start syncing your Hawk DSP data.
Hawk DSP fields
Windsor.ai's Hawk DSP connector offers 41 fields, organized in 2 tables such as Accounts, Campaigns. Here are 30 of them:
-
Date (
date): The date of the report metrics. -
Account Name (
account_name): Account name in Windsor.ai. -
Campaign (
campaign): The name of the campaign (Hawk order). -
Clicks (
clicks): The number of times the ad was clicked. -
Impressions (
impressions): The number of times the ad was shown. -
Spend (
spend): Media cost in USD. -
CTR (
ctr): Click-through rate (clicks divided by impressions). -
CPC (
cpc): Average cost per click (USD spend divided by clicks). -
CPM (
cpm): Cost per thousand impressions (USD). -
Conversions (
conversions): The number of conversions attributed to the campaign. -
Account ID (
account_id): Account ID in Windsor.ai. -
Advertiser ID (
advertiser_id): The identifier of the advertiser. -
Data fetched at (
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... -
Campaign ID (
campaign_id): The unique identifier of the campaign (Hawk order). -
Data Source (
datasource): The name of the Windsor connector returning the row -
Currency (
currency): The order's currency, the unit of Spend (Local Currency). Spend, CPC and CPM are in USD. -
Day of month (
day_of_month): Day of the month -
Media Plan ID (
media_plan_id): The identifier of the media plan the campaign belongs to. -
Month (
month): Number of the month -
Spend (Local Currency) (
spend_local): Media cost in the order's local currency (see Currency). -
Now (
now): Current timestamp -
Store Visits (
store_visits): The number of in-store visits generated by the campaign. -
Source (
source): The name of the Windsor connector returning the row -
VCR (
vcr): Video completion rate (completes divided by starts). -
Today (
today): Today's date -
Video Completes (
video_completes): The number of completed video views. -
Week (
week): Week (Sun-Sat). -
Video First Quartile (
video_first_quartile): Video views reaching 25% completion. -
Day of week and day number (
week_day): Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. -
Video Midpoint (
video_midpoint): Video views reaching 50% completion.
Use Hawk DSP data in ChatGPT and Claude
Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Hawk DSP is connected to Windsor.ai, you can ask questions about your Hawk DSP data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.
- How to connect your data to ChatGPT
- How to connect your data to Claude
- How to connect Windsor MCP to any MCP client
Available destinations for your Hawk DSP data
AI assistants
ChatGPT, Claude, Copilot, Manus, Gemini, Gemini Enterprise, Perplexity, Cursor, Grok, Google Antigravity, Lovable, n8n, Base44, Mistral, Kimi, DeepSeek, AI Insights (any MCP client)
Spreadsheets
Google Sheets, Excel, Airtable
Databases & warehouses
BigQuery, Snowflake, MySQL, PostgreSQL, Supabase, Azure SQL, Redshift, Databricks, Microsoft Fabric, Windsor.ai Cloud Database, Cache Data Store
BI & dashboards
Data Studio, Power BI Desktop: Native, Power BI Desktop: Web, Tableau
File storage
Amazon S3 Storage, Azure Blob Storage
Code
Python/R Code