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
Send your Income Access data to
Income Access Connector Reference
59 metrics41 dimensions
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 | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The Account ID | |
| account_name | TEXT | Account Name | The Account Name | |
| 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 | |
| date | DATE | Date | The Date | |
| 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 |