API Connectors

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

Daisycon Connector Reference

27 metrics29 dimensions
Fields

The Daisycon connector fetches affiliate data on a transaction level.

Sample URL:

https://connectors.windsor.ai/daisycon?api_key=<APIKEY>&date_preset=last_7d&fields=account_id,account_name,advertiserid,click_raw,click_unique,clickout_amount,clickout_raw,clickout_unique,cpc_amount,cpc_raw,cpc_unique,currency_code,date,transaction_amount,transaction_approved,transaction_approved_amount,transaction_approved_parts,transaction_approved_program_amount,transaction_disapproved,transaction_disapproved_amount,transaction_disapproved_parts,transaction_disapproved_program_amount,transaction_open,transaction_open_amount,transaction_open_parts,transaction_open_program_amount,transaction_parts,transaction_program_amount,transaction_unique,transactionrevenue

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


Daisycon Fields

Daisycon Advertiser fields

The Advertiser report of the Daisycon connector includes 30 fields.

ID Type Name Description
account_id TEXT Account ID Your Daisycon Advertiser ID
account_name TEXT Account Name Your Daisycon Advertiser name
advertiserid TEXT Advertiser ID Daisycon Ads advertiser ID
click_raw NUMERIC Click Raw Click raw
click_unique NUMERIC Click Unique Click unique
clickout_amount NUMERIC Clickout Amount Clickout amount
clickout_raw NUMERIC Clickout Raw Clickout Raw
clickout_unique NUMERIC Clickout Unique Clickout Unique
cpc_amount NUMERIC CPC Amount Cpc amount
cpc_raw NUMERIC CPC Raw Cpc raw
cpc_unique NUMERIC CPC Unique Cpc unique
currency_code TEXT Currency Code Currency code
date DATE Date date
transaction_amount NUMERIC Transaction Amount Transaction amount
transaction_approved NUMERIC Transaction Approved Transaction Approved
transaction_approved_amount NUMERIC Transaction Approved Amount Transaction approved amount
transaction_approved_parts NUMERIC Transaction Approved Parts Transaction approved parts
transaction_approved_program_amount NUMERIC Transaction Approved Program Amount Transaction approved program amount
transaction_disapproved NUMERIC Transaction Disapproved Transaction Disapproved
transaction_disapproved_amount NUMERIC Transaction Disapproved Amount Transaction disapproved amount
transaction_disapproved_parts NUMERIC Transaction Disapproved Parts Transaction Disapproved parts
transaction_disapproved_program_amount NUMERIC Transaction Disapproved Program Amount Transaction disapproved program amount
transaction_open NUMERIC Transaction Open Transaction open
transaction_open_amount NUMERIC Transaction Open Amount Transaction open amount
transaction_open_parts NUMERIC Transaction Open Parts Transaction open parts
transaction_open_program_amount NUMERIC Transaction Open Program Amount Transaction open program amount
transaction_parts NUMERIC Transaction Parts Transaction parts
transaction_program_amount NUMERIC Transaction Program Amount Transaction amount
transaction_unique NUMERIC Transaction Unique Transaction unique
transactionrevenue NUMERIC Transaction Revenue Transaction revenue

Daisycon Transactions fields

The Transactions report of the Daisycon connector includes 8 fields.

ID Type Name Description
commission NUMERIC Commission Advertiser commission for the transaction part
compensation_code TEXT Compensation Code Compensation code applied to the transaction part
program_id TEXT Program ID ID of the program the transaction belongs to
program_name TEXT Program Name Name of the program the transaction belongs to
revenue NUMERIC Revenue Order value of the transaction part
transaction_id TEXT Transaction ID Daisycon transaction ID
transaction_part_id TEXT Transaction Part ID ID of the transaction part
transaction_status TEXT Transaction Status Transaction part status (approved, disapproved, open)

Daisycon other fields

The Daisycon 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