API Connectors

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

Aimwel Connector Reference

10 metrics31 dimensions
Fields

https://connectors.windsor.ai/aimwel?api_key=[your API key]&date_preset=last_7d&fields= campaign_type,apply_clicks,spent,impressions,date

The Aimwel connector exposes 41 fields (10 metrics, 31 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Aimwel Fields

Aimwel Monthly Budget fields

The Monthly Budget report of the Aimwel connector includes 5 fields.

ID Type Name Description
monthly_budget_brand TEXT Brand (Monthly Budget) Brand (Monthly Budget)
monthly_budget_budget NUMERIC Budget (Monthly Budget) Budget (Monthly Budget)
monthly_budget_campaign_group_id TEXT Campaign Group Id (Monthly Budget) Campaign Group Id (Monthly Budget)
monthly_budget_campaign_group_max_budget NUMERIC Campaign Group Max Budget (Monthly Budget) Campaign Group Max Budget (Monthly Budget)
monthly_budget_channel TEXT Channel (Monthly Budget) Channel (Monthly Budget)

Aimwel Performance fields

The Performance report of the Aimwel connector includes 18 fields.

ID Type Name Description
apply_clicks NUMERIC Apply Clicks Apply Clicks
brand TEXT Brand Brand
campaign_group_id TEXT Campaign Group ID Campaign Group ID
campaign_type TEXT (Deprecated) Campaign type Campaign Type
channel TEXT Channel Channel
clicks NUMERIC Clicks Clicks
cpa NUMERIC CPA CPA
cpac NUMERIC CPAC CPAC
date DATE Date The Date
day_date_timezone DATE Day Date Timezone The date in date format.
f_applies NUMERIC F Applies F Applies
is_corrected TEXT Is Corrected Is Corrected
job_id TEXT Job ID Job ID
job_title TEXT Job Title Job Title
job_views NUMERIC Job Views Job Views
spent NUMERIC Spent Spent
spent_uncorrected NUMERIC Spent Uncorrected Spent Uncorrected
timestamp_day TIMESTAMP Timestamp Day The date in timestamp format.

Aimwel other fields

The Aimwel connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description
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