Financial data
Includes attributes related to deposits/purchases, payment methods, withdrawals and rewards.
Sample queries:
-
list my top 5 performing payment methods in the state of NJ for players of age between 20 and 40
-
Provide a list of first time depositors coming from acquisition source [Organic] in the past month
-
Show month on month total deposits and withdrawals for the current year group by month
Specific attributes supported natively:
- Deposits/purchases: Value, Payment method, State, Transaction date, Channel (mobile/web)
- Withdrawals: Value, Transaction date
- Rewards/Bonuses: Product, Category, Identifier, Value, Transaction date, Channel (mobile/web)
User acquisition data
Allows querying of data by affiliate tags, acquisition campaigns or promotional codes. Includes conversions, conversion rates, best performing sources, financial metrics, KPIs and more.
Sample queries:
-
List my top 5 acquisition sources by NGR for customers in NJ between the age of 20 and 40
-
Show me all my acquisition sources, their conversions, conversion rates and total deposits for customers who signed up last year
-
Show total deposits, GGR and bonuses issued for acquisition source [Organic] last quarter
Specific attributes supported natively:
Btag, Promotional code, Tracking code
Player custom attributes
Allows querying of up to eight (8) custom attributes at no additional charge. Four attributes provided are numeric based and another four are text based. Such attributes can be customised as needed and defined during the integration phase.
Example:
-
VIP level = CustomInt1
-
XP level = CustomInt2
-
Player label = CustomString1
Personal & Geographical data
Specific attributes supported natively:
Age/date of birth, city, zip code, state, country, gender, time zone
Sample queries:
-
show total customers from the state of PN between the age of 30 and 40 with total lifetime purchases greater than 1000
-
list total LTV by state for the current year
-
show number of customers, registration month, state for 2022. Group by state and month
KPIs & ratios
Predefined KPIs including LTV, NGR, GGR, Payout to wager ratio, bonus to deposit, bonus to wager, bonus to NGR, withdrawals to wagers, NGR to deposit ratio and any custom ratio derived from existing metrics.
Sample queries:
-
show total sports NGR, casino NGR, lottery NGR in 2022 group by month
-
which customers from NY have an average payout to wager ratio higher than 0.6 in 2023
-
list all customers who have not purchased a lottery ticket in the past 90 days and have a lifetime NGR greater than 2000
Product data
Includes customer preferences, channel (mobile/web), revenue, RTP, GGR, bets, winnings and more on a game level.
Sample queries:
-
show my best performing games by RTP in the state of NY
-
list the top 5 lottery games by bet volume in 2023 in the state of NY
-
list all lottery bets for customer 1016A. Include lottery game and group by lottery game
-
Give me a list of brands with no wagers this month
Specific game attributes supported natively:
- casino: game identifier, game type, supplier, bet value, payout value, transaction date, game session, free spins, channel (mobile/web)
- sportsbook: sport, league/tournament, event, live, bet type, event identifier, event date, bet value, payout value, odds, transaction date, cancellation, channel (mobile/web)
- lottery: name, category, draw date, bet type, bet value, payout value, transaction date, ticket count, channel (mobile/web)
- bingo: name, category, room, bet type, bet value, payout value, transaction date, channel (mobile/web)
- pari-mutuel: event, breed, racetrack country, race number, event date, event identifier, transaction date, bet value, payout value, bet type, channel (mobile/web)
- instant games: name, category, bet type, bet value, payout value, transaction date, channel (mobile/web)
- poker: tournament dataset, blinds, straddle, ante, bet, win, type, free rolls, jackpots, insurance, rebuys, rakes, channel (mobile/web)
Custom datasets
Additional datasets can be customised, consolidated and provided through Betintel according to the customers’ requirements. Such datasets may include additional verticals, affiliate specific datasets, game studio datasets and more.