Daisycon Field Reference

Sample

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</blockquote


Fields

IDTypeNameDescription
account_idTEXTAccount IDYour Daisycon Advertiser ID
account_nameTEXTAccount NameYour Daisycon Advertiser name
advertiseridTEXTAdvertiser IDDaisycon Ads advertiser ID
click_rawNUMERICClick RawClick raw
click_uniqueNUMERICClick UniqueClick unique
clickout_amountNUMERICClickout AmountClickout amount
clickout_rawNUMERICClickout RawClickout Raw
clickout_uniqueNUMERICClickout UniqueClickout Unique
cpc_amountNUMERICCPC AmountCpc amount
cpc_rawNUMERICCPC RawCpc raw
cpc_uniqueNUMERICCPC UniqueCpc unique
currency_codeTEXTCurrency CodeCurrency code
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDatedate
day_of_monthTEXTDay of monthDay of the month
monthTEXTMonthNumber of the month
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
transaction_amountNUMERICTransaction AmountTransaction amount
transaction_approvedNUMERICTransaction ApprovedTransaction Approved
transaction_approved_amountNUMERICTransaction Approved AmountTransaction approved amount
transaction_approved_partsNUMERICTransaction Approved PartsTransaction approved parts
transaction_approved_program_amountNUMERICTransaction Approved Program AmountTransaction approved program amount
transaction_disapprovedNUMERICTransaction DisapprovedTransaction Disapproved
transaction_disapproved_amountNUMERICTransaction Disapproved AmountTransaction disapproved amount
transaction_disapproved_partsNUMERICTransaction Disapproved PartsTransaction Disapproved parts
transaction_disapproved_program_amountNUMERICTransaction Disapproved Program AmountTransaction disapproved program amount
transaction_openNUMERICTransaction OpenTransaction open
transaction_open_amountNUMERICTransaction Open AmountTransaction open amount
transaction_open_partsNUMERICTransaction Open PartsTransaction open parts
transaction_open_program_amountNUMERICTransaction Open Program AmountTransaction open program amount
transaction_partsNUMERICTransaction PartsTransaction parts
transaction_program_amountNUMERICTransaction Program AmountTransaction amount
transaction_uniqueNUMERICTransaction UniqueTransaction unique
transactionrevenueNUMERICTransaction RevenueTransaction revenue
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20