Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Daisycon Connector Reference
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 | 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 | 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 |