Windsor brings all your Income Access data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Income Access Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| %_commission | PERCENT | % Commission | Total revenue share commission generated by the player across all products during the period | Player Accounts |
| account_id | TEXT | Account ID | The Account ID | |
| account_name | TEXT | Account Name | The Account Name | |
| acid | TEXT | ACID | IA ACID tagged to the player | Player Accounts |
| affiliate_id | TEXT | Affiliate ID | Affiliate ID number | Player Accounts |
| average_revenue | NUMERIC | Average Revenue | Average revenue generated by the player during the period | Player Accounts |
| bonus | NUMERIC | Bonus | total bonuses granted to the player during the period | Player Accounts |
| casino_bets | NUMERIC | Casino Bets | Total bets placed under casino during the period | Player Accounts |
| casino_commission | NUMERIC | Casino Commission | Total affiliate revenue share commission generated for casino during the period | Player Accounts |
| casino_net_revenue | NUMERIC | Casino Net Revenue | Total net reevenue generated by the player during the period under casino | Player Accounts |
| casino_points | NUMERIC | Casino Points | Total amount of points generated by the player under casino during the period | Player Accounts |
| casino_revenue | NUMERIC | Casino Revenue | Total gross revenue generated by the player during the period under casino | Player Accounts |
| casino_tournament | NUMERIC | Casino Tournament | Total amount of tournament fees generated by the player under casino during the period | Player Accounts |
| casino_wagers | NUMERIC | Casino Wagers | Total wagers placed under casino during the period | Player Accounts |
| chargebacks | NUMERIC | Chargebacks | total chargebacks performed by the player during the period | Player Accounts |
| commadminfee | NUMERIC | commadminfee | Total commission admin fee deducted from the affiliate commission | Player Accounts |
| costs | NUMERIC | Costs | Total amount of costs incurred by the player (calculated as Bonus + Chargebacks) | Player Accounts |
| cpa_commission | NUMERIC | CPA Commission | Total amount of CPA commission generated by the player across all products during the period | Player Accounts |
| cpa_count | NUMERIC | CPA count | Total number of CPAs triggered by the player during the period | Player Accounts |
| cpa_date | DATE | CPA Date | Date the CPA was triggered for this player | Player Accounts |
| creative_id | TEXT | Creative ID | Creative ID associated to the player | Player Accounts |
| creative_name | TEXT | Creative Name | Name of the creative corresponding to the Creative ID | Player Accounts |
| currency_symbol | TEXT | Currency Symbol | 3 character currency code | Player Accounts |
| 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 | |
| deposits | NUMERIC | Deposits | Total deposits made by the player during the period | Player Accounts |
| external_aff_id | TEXT | External Aff ID | Alternate affiliate identifier | Player Accounts |
| first_deposit | DATE | First Deposit | Player first deposit date as calculated by Income Access | Player Accounts |
| gross_revenue | NUMERIC | Gross revenue | Total gross revenue generated by the player. This may take into account certain percentage deductions for taxes and fees | Player Accounts |
| merchant | TEXT | Merchant | Merchant Name | Player Accounts |
| merchantid | TEXT | MerchantID | ID number of the merchant represented in IA | Player Accounts |
| month | TEXT | Month | Number of the month | |
| net_points | NUMERIC | Net Points | Total amount of points/other data generated by the playerduring the period | Player Accounts |
| net_revenue | NUMERIC | Net revenue | Net revenue generated by the player during the period (calculated as Total Gross - Total bonuses - Chargebacks) | Player Accounts |
| new | NUMERIC | New | New active player count | Player Accounts |
| player_id | TEXT | Player ID | player ID/CID | Player Accounts |
| player_name | TEXT | Player Name | Secondary player identifier | Player Accounts |
| playercountry | COUNTRY | playercountry | Player country | Player Accounts |
| playercurrency | TEXT | playercurrency | Player Currency or other account info | Player Accounts |
| poker_bets | NUMERIC | Poker Bets | Total bets placed under poker during the period | Player Accounts |
| poker_commission | NUMERIC | Poker Commission | Total affiliate revenue share commission generated for poker during the period | Player Accounts |
| poker_net_revenue | NUMERIC | Poker Net Revenue | Total net revenue generated by the player during the period under poker | Player Accounts |
| poker_points | NUMERIC | Poker Points | Total amount of points generated by the player under poker during the period | Player Accounts |
| poker_revenue | NUMERIC | Poker Revenue | Total gross revenue generated by the player during the period under poker | Player Accounts |
| poker_tournament | NUMERIC | Poker Tournament | Total amount of tournament fees generated by the player under poker during the period | Player Accounts |
| poker_wagers | NUMERIC | Poker Wagers | Total wagers placed under poker during the period | Player Accounts |
| prod7_bets | NUMERIC | Prod7 Bets | Total bets placed under Live Casino during the period | Player Accounts |
| prod7_commission | NUMERIC | Prod7 Commission | Total affiliate revenue share commission generated for Live Casino during the period | Player Accounts |
| prod7_net_revenue | NUMERIC | Prod7 Net Revenue | Total net revenue generated by the player during the period under Live Casino | Player Accounts |
| prod7_points | NUMERIC | Prod7 Points | Total amount of points generated by the player under Live Casino during the period | Player Accounts |
| prod7_revenue | NUMERIC | Prod7 Revenue | Total gross revenue generated by the player during the period under Live Casino | Player Accounts |
| prod7_tournament | NUMERIC | Prod7 Tournament | Total amount of tournament fees generated by the player under Live Casino during the period | Player Accounts |
| prod7_wagers | NUMERIC | Prod7 Wagers | Total wagers placed under Live Casino during the period | Player Accounts |
| prod8_bets | NUMERIC | Prod8 Bets | Total bets placed under Virtual Sports during the period | Player Accounts |
| prod8_commission | NUMERIC | Prod8 Commission | Total affiliate revenue share commission generated for Virtual Sports during the period | Player Accounts |
| prod8_net_revenue | NUMERIC | Prod8 Net Revenue | Total net revenue generated by the player during the period under Virtual Sports | Player Accounts |
| prod8_points | NUMERIC | Prod8 Points | Total amount of points generated by the player under Virtual Sports during the period | Player Accounts |
| prod8_revenue | NUMERIC | Prod8 Revenue | Total gross revenue generated by the player during the period under Virtual Sports | Player Accounts |
| prod8_tournament | NUMERIC | Prod8 Tournament | Total amount of tournament fees generated by the player under Virtual Sports during the period | Player Accounts |
| prod8_wagers | NUMERIC | Prod8 Wagers | Total wagers placed under Virtual Sports during the period | Player Accounts |
| product_1_bets | NUMERIC | Product 1 Bets | Total bets placed under product 1 during the period | Player Accounts |
| product_1_commission | NUMERIC | Product 1 Commission | Total affiliate revenue share commission generated for product 1 during the period | Player Accounts |
| product_1_net_revenue | NUMERIC | Product 1 Net Revenue | Total net revenue generated by the player during the period under product 1 | Player Accounts |
| product_1_points | NUMERIC | Product 1 Points | Total amount of points generated by the player under product 1 during the period | Player Accounts |
| product_1_revenue | NUMERIC | Product 1 Revenue | Total gross revenue generated by the player during the period under product 1 | Player Accounts |
| product_1_tournament | NUMERIC | Product 1 Tournament | Total amount of tournament fees generated by the player under product 1 during the period | Player Accounts |
| product_1_wagers | NUMERIC | Product 1 Wagers | Total wagers placed under product 1 during the period | Player Accounts |
| referafriend | TEXT | referafriend | Additional player account info | Player Accounts |
| registration_date | DATE | Registration Date | Player registration date | Player Accounts |
| rowid | TEXT | rowid | row id number | Player Accounts |
| site_id | TEXT | Site ID | Affiliate Site ID tagged to the player | Player Accounts |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| sportsbook_bets | NUMERIC | Sportsbook Bets | Total bets placed under sportsbook during the period | Player Accounts |
| sportsbook_commission | NUMERIC | Sportsbook Commission | Total affiliate revenue share commission generated for sportsbook during the period | Player Accounts |
| sportsbook_net_revenue | NUMERIC | Sportsbook Net Revenue | Total net revenue generated by the player during the period under sportsbook | Player Accounts |
| sportsbook_points | NUMERIC | Sportsbook Points | Total amount of points generated by the player under sportsbook during the period | Player Accounts |
| sportsbook_revenue | NUMERIC | Sportsbook Revenue | Total gross revenue generated by the player during the period under sportsbook | Player Accounts |
| sportsbook_tournament | NUMERIC | Sportsbook Tournament | Total amount of tournament fees generated by the player under sportsbook during the period | Player Accounts |
| sportsbook_wagers | NUMERIC | Sportsbook Wagers | Total wagers placed under sportsbook during the period | Player Accounts |
| stake | NUMERIC | stake | Total amount staked/wagered by the player during the period | Player Accounts |
| today | DATE | Today | Today's date | |
| total_bets_hands | NUMERIC | Total Bets/Hands | Total number of bets/hands made by the player during the period | Player Accounts |
| total_commission_value | NUMERIC | Total Commission Value | Total combined revenue share and CPA commission generated by the player | Player Accounts |
| total_records | NUMERIC | Total Records | Total records in the report | Player Accounts |
| type | TEXT | Type | Creative type | Player Accounts |
| username | TEXT | Username | Affiliate Username | Player Accounts |
| 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_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 |