Thanks for all your suggestions and kind words!
The casinos use an application provided by Microgaming which holds all the player data you are all looking for, plus all the confidential data that can’t be provided. Ideally, if we could arrange an affiliate login which would give limited access to this application. However, the security issue will be a major concern and I’m not sure that we can overcome that one easily. The application works on a query basis and we could look at the possibility of building a separate query for affiliates but this is may be a very large project and will take time.
I would like to make a suggestion that will be a lot less complicated to implement so please let me know what you think of this idea:
Update the drill down details of the earnings report:
The earnings report currently gives you the following details on the drill down:
Banner Tag
Account
Date Opened
Purchase Amount
Net Profit
% Share
Earnings
We can look into adding more columns to this player drill down on the earnings report, such as:
Cashouts
Average bet size
Number of purchases
First Played
Last Played
Purchase Method
Promotion
Total Bets
Visits
Purchase Sum
Purchase Qty
Cash In Sum
Cash In Qty
We can also add to the favorite games report the following:
A top six game groups table with number of bets
A top ten games table with number of bets
And a detailed table by player account number showing:
GameType
Game
Total Bets
This is all pending my management approval :tounge2: but how does that look?
Thanks!
Best regards,
Lloyd