Income Access Connector Reference

59 metrics41 dimensions

Fields

The Income Access connector exposes 100 fields (59 metrics, 41 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Income Access Fields

Income Access Player Accounts fields

The Player Accounts report of the Income Access connector includes 79 fields.

Income Access Player Accounts fields (%_commission to poker_tournament)

ID	Type	Name	Description
%_commission	PERCENT	% Commission	Total revenue share commission generated by the player across all products during the period
acid	TEXT	ACID	IA ACID tagged to the player
affiliate_id	TEXT	Affiliate ID	Affiliate ID number
average_revenue	NUMERIC	Average Revenue	Average revenue generated by the player during the period
bonus	NUMERIC	Bonus	total bonuses granted to the player during the period
casino_bets	NUMERIC	Casino Bets	Total bets placed under casino during the period
casino_commission	NUMERIC	Casino Commission	Total affiliate revenue share commission generated for casino during the period
casino_net_revenue	NUMERIC	Casino Net Revenue	Total net reevenue generated by the player during the period under casino
casino_points	NUMERIC	Casino Points	Total amount of points generated by the player under casino during the period
casino_revenue	NUMERIC	Casino Revenue	Total gross revenue generated by the player during the period under casino
casino_tournament	NUMERIC	Casino Tournament	Total amount of tournament fees generated by the player under casino during the period
casino_wagers	NUMERIC	Casino Wagers	Total wagers placed under casino during the period
chargebacks	NUMERIC	Chargebacks	total chargebacks performed by the player during the period
commadminfee	NUMERIC	commadminfee	Total commission admin fee deducted from the affiliate commission
costs	NUMERIC	Costs	Total amount of costs incurred by the player (calculated as Bonus + Chargebacks)
cpa_commission	NUMERIC	CPA Commission	Total amount of CPA commission generated by the player across all products during the period
cpa_count	NUMERIC	CPA count	Total number of CPAs triggered by the player during the period
cpa_date	DATE	CPA Date	Date the CPA was triggered for this player
creative_id	TEXT	Creative ID	Creative ID associated to the player
creative_name	TEXT	Creative Name	Name of the creative corresponding to the Creative ID
currency_symbol	TEXT	Currency Symbol	3 character currency code
deposits	NUMERIC	Deposits	Total deposits made by the player during the period
external_aff_id	TEXT	External Aff ID	Alternate affiliate identifier
first_deposit	DATE	First Deposit	Player first deposit date as calculated by Income Access
gross_revenue	NUMERIC	Gross revenue	Total gross revenue generated by the player. This may take into account certain percentage deductions for taxes and fees
merchant	TEXT	Merchant	Merchant Name
merchantid	TEXT	MerchantID	ID number of the merchant represented in IA
net_points	NUMERIC	Net Points	Total amount of points/other data generated by the playerduring the period
net_revenue	NUMERIC	Net revenue	Net revenue generated by the player during the period (calculated as Total Gross - Total bonuses - Chargebacks)
new	NUMERIC	New	New active player count
player_id	TEXT	Player ID	player ID/CID
player_name	TEXT	Player Name	Secondary player identifier
playercountry	COUNTRY	playercountry	Player country
playercurrency	TEXT	playercurrency	Player Currency or other account info
poker_bets	NUMERIC	Poker Bets	Total bets placed under poker during the period
poker_commission	NUMERIC	Poker Commission	Total affiliate revenue share commission generated for poker during the period
poker_net_revenue	NUMERIC	Poker Net Revenue	Total net revenue generated by the player during the period under poker
poker_points	NUMERIC	Poker Points	Total amount of points generated by the player under poker during the period
poker_revenue	NUMERIC	Poker Revenue	Total gross revenue generated by the player during the period under poker
poker_tournament	NUMERIC	Poker Tournament	Total amount of tournament fees generated by the player under poker during the period

Income Access Player Accounts fields (poker_wagers to username)

ID	Type	Name	Description
poker_wagers	NUMERIC	Poker Wagers	Total wagers placed under poker during the period
prod7_bets	NUMERIC	Prod7 Bets	Total bets placed under Live Casino during the period
prod7_commission	NUMERIC	Prod7 Commission	Total affiliate revenue share commission generated for Live Casino during the period
prod7_net_revenue	NUMERIC	Prod7 Net Revenue	Total net revenue generated by the player during the period under Live Casino
prod7_points	NUMERIC	Prod7 Points	Total amount of points generated by the player under Live Casino during the period
prod7_revenue	NUMERIC	Prod7 Revenue	Total gross revenue generated by the player during the period under Live Casino
prod7_tournament	NUMERIC	Prod7 Tournament	Total amount of tournament fees generated by the player under Live Casino during the period
prod7_wagers	NUMERIC	Prod7 Wagers	Total wagers placed under Live Casino during the period
prod8_bets	NUMERIC	Prod8 Bets	Total bets placed under Virtual Sports during the period
prod8_commission	NUMERIC	Prod8 Commission	Total affiliate revenue share commission generated for Virtual Sports during the period
prod8_net_revenue	NUMERIC	Prod8 Net Revenue	Total net revenue generated by the player during the period under Virtual Sports
prod8_points	NUMERIC	Prod8 Points	Total amount of points generated by the player under Virtual Sports during the period
prod8_revenue	NUMERIC	Prod8 Revenue	Total gross revenue generated by the player during the period under Virtual Sports
prod8_tournament	NUMERIC	Prod8 Tournament	Total amount of tournament fees generated by the player under Virtual Sports during the period
prod8_wagers	NUMERIC	Prod8 Wagers	Total wagers placed under Virtual Sports during the period
product_1_bets	NUMERIC	Product 1 Bets	Total bets placed under product 1 during the period
product_1_commission	NUMERIC	Product 1 Commission	Total affiliate revenue share commission generated for product 1 during the period
product_1_net_revenue	NUMERIC	Product 1 Net Revenue	Total net revenue generated by the player during the period under product 1
product_1_points	NUMERIC	Product 1 Points	Total amount of points generated by the player under product 1 during the period
product_1_revenue	NUMERIC	Product 1 Revenue	Total gross revenue generated by the player during the period under product 1
product_1_tournament	NUMERIC	Product 1 Tournament	Total amount of tournament fees generated by the player under product 1 during the period
product_1_wagers	NUMERIC	Product 1 Wagers	Total wagers placed under product 1 during the period
referafriend	TEXT	referafriend	Additional player account info
registration_date	DATE	Registration Date	Player registration date
rowid	TEXT	rowid	row id number
site_id	TEXT	Site ID	Affiliate Site ID tagged to the player
sportsbook_bets	NUMERIC	Sportsbook Bets	Total bets placed under sportsbook during the period
sportsbook_commission	NUMERIC	Sportsbook Commission	Total affiliate revenue share commission generated for sportsbook during the period
sportsbook_net_revenue	NUMERIC	Sportsbook Net Revenue	Total net revenue generated by the player during the period under sportsbook
sportsbook_points	NUMERIC	Sportsbook Points	Total amount of points generated by the player under sportsbook during the period
sportsbook_revenue	NUMERIC	Sportsbook Revenue	Total gross revenue generated by the player during the period under sportsbook
sportsbook_tournament	NUMERIC	Sportsbook Tournament	Total amount of tournament fees generated by the player under sportsbook during the period
sportsbook_wagers	NUMERIC	Sportsbook Wagers	Total wagers placed under sportsbook during the period
stake	NUMERIC	stake	Total amount staked/wagered by the player during the period
total_bets_hands	NUMERIC	Total Bets/Hands	Total number of bets/hands made by the player during the period
total_commission_value	NUMERIC	Total Commission Value	Total combined revenue share and CPA commission generated by the player
total_records	NUMERIC	Total Records	Total records in the report
type	TEXT	Type	Creative type
username	TEXT	Username	Affiliate Username

Income Access other fields

The Income Access connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The Account ID
account_name	TEXT	Account Name	The Account Name
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
date	DATE	Date	The Date
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