In this article we'll guide you through the process of configuring Affelios to integrate it with your Playbook Sportsbook and Casino platform.
Prerequisites
An active Affelios software subscription
A live Brand operating on the Playbook Sportsbook and Casino platform
An HTTP CSV Registrations endpoint provided by Playbook
An HTTP CSV Transactions endpoint provided by Playbook
Playbook to have whitelisted the required Affelios IP addresses for your brand (please contact us via Intercom or send an email to [email protected] to obtain these)
Create a Brand in Affelios
To get started you'll first need a Brand in Affelios that represents your Playbook casino website.
For example, if your brand was called Bettest.com your brand would have the following configuration:
Create Brand Step 1
Field | Example | Description |
Name | Bet Test | A display name that will be shown to affiliates and in your reports. |
Industry | Gambling | Used to categorise and filter brands. |
External ID | bettest | A unique value used externally. This is not explicitly required by Playbook, however its best practice to choose a unique value. |
Landing Page URL | https://bettest.com?btag=[ClickKey] | Playbook supports a 30-day cookie that is set by passing the |
Create Brand Step 2 - Configure
Field | Example | Description |
Logo | - | Displayed to affiliates and in reports for easy identification. |
Description |
| Displayed on the dynamically generated affiliate website to promote your brand. |
Auto-Approve commissions |
| It's recommend to enable this setting to avoid any data delays or manual intervention in approving commission for affiliates. |
Allow Anonymous Transactions |
| It's important to keep this setting disabled for Playbook brands. Enabling it could result in transactions being created for players that are not known to Affelios. |
Automated Deductions |
|
|
Deposit Fees |
| This is a percentage calculated against Deposits to represent Payment Fees deducted as a negative value in the Net Revenue calculation. |
Tax Rate Deduction |
| A value calculated from the Gross Gaming Revenue to represent Point of Consumption Taxes and deducted in the Net Revenue calculation. |
Net Revenue Deduction |
| A value calculated from the Gross Gaming Revenue to represent Platform and Game Costs and deducted in the Net Revenue calculation. |
Create Brand Step 3 - Set Commission Plan
In this next step you simply need to select a Default Commission Plan that will be made available to any new affiliates promoting this brand that do not have a custom override.
Playbook Integration Settings
Now that we have created our Bet Test brand, we can go ahead a configure the Playbook integration.
Navigate to the Brands page and click the three dots on the Bet Test brand, before clicking Integration Settings as shown below:
This should show you a list of available integration methods for your brand, for Playbook please select Csv Http as shown below:
Csv Http Settings
In the next section you will need the csv endpoint details as provided to you by your Playbook account manager. If you do not have these please contact your AM to obtain them.
Http Connection Settings
Once you have these details to hand complete the first section as shown below. Affelios will request the previous days data from Playbook each day, using a filename template that is compatible with the Playbook http endpoint.
Field | Example | Description |
Protocol |
| Toggle the https toggle to enable HTTPS |
HTTP Hostname |
| Enter the host name provided by Playbook here ensuring that it contains your unique brand identifier. |
Username (Basic Auth) | - | Not required |
Password (Basic Auth) | - | Not required |
Registration Filename Template |
| Enter the path to the Registrations file provided by Playbook. The following tokens will be automatically replaced: [YEAR] eg. 2030, [MONTH] eg. 12, [DAY] eg. 31 |
Transactions Filename Template |
| Enter the path to the Transactions file provided by Playbook. The following tokens will be automatically replaced: [YEAR] eg. 2030, [MONTH] eg. 12, [DAY] eg. 31 |
After you have configured the settings shown above, click Next Step and Affelios will automatically connect to your Playbook feed and attempt to retrieve the previous days csv files to validate the connection and allow you to map data fields.
Customer Field Mapping
Once you have a valid connection Affelios will present the available fields in the Registrations csv field allow you to specify which fields map to the correct fields in Affelios. These fields may be changed at any point if required, giving you the flexibility to reconfigure at any time.
Simply click on the corresponding External Field Name to match to each Affelios field as shown in this example below:
Affelios Field | Description | External Field Example |
Registration Date | The date which the player registered. | ACCOUNT_OPENING_DATE |
External Customer ID | The Playbook ID for the player. | PLAYER_ID |
Click Key | The unique value generated by Affelios and passed to your Brand website. | BTAG |
Customer Username | The anonymised username from Playbook. | USERNAME |
Country Code | 2-letter country code of the player. | PLAYER_COUNTRY |
Transaction Field Mapping
For each given day Playbook returns an aggregated total of Deposits, Wagering and Revenue for each referred Player that is split based on the Product that was being played.
In Affelios we support the ability to map these values to individual Products which requires a specific Transaction Field Mapping configuration which can be setup as follows:
Default Map
The Default Map will map each Playbook transaction directly to the Brand with no specific Product. This is required for the tracking of Deposits, configure your Default Map with the follow three fields only:
Affelios Field | Description | External Field Example |
External Customer Id | The Playbook Player ID | PLAYER_ID |
Transaction Date | The Date of the transaction. | TRANSACTION_DATE |
Deposits | The sum total of Deposits for the Transaction Date | DEPOSITS |
All other fields other than the ones specified above should be left blank.
Sports Product Map
In order to Map the revenue fields from Playbook, we must create corresponding Products within Affelios. We can do this easily by clicking the "Add Product Map" located top right of the Transaction Field Map card.
You should see a new tab is created and a "New Product" button is visible as shown below:
Click the button and create a Product called "Sports".
Next configure the Sports Map with the following fields:
Affelios Field | Description | External Field Example |
External Customer Id | The Playbook Player ID | PLAYER_ID |
Transaction Date | The Date of the transaction. | TRANSACTION_DATE |
Gross Revenue | The sum total of Sports Revenue for the Transaction Date | SPORTSBOOK_REVENUE |
Wagering | The sum total of Sports Stake for the Transaction Date | SPORTSBOOK_STAKE |
Virtual Sports Product Map
Similarly to the Sports Product Map, we also need to create a mapping for Virtual Sports. Click "Add Product Map" and proceed to create a new product called "Virtual Sports".
Once created, select Virtual Sports and then configure the mapping as follows:
Affelios Field | Description | External Field Example |
External Customer Id | The Playbook Player ID | PLAYER_ID |
Transaction Date | The Date of the transaction. | TRANSACTION_DATE |
Gross Revenue | The sum total of Virtual Sports Revenue for the Transaction Date | VIRTUAL_SPORTS_revenue |
Wagering | The sum total of Virtual Sports Stake for the Transaction Date | VIRTUAL_SPORTS_stake |
Casino Product Map
Next we need to map Casino revenue.
Click "Add Product Map" and proceed to create a new product called "Casino".
Once created, select Casino and then configure the mapping as follows:
Affelios Field | Description | External Field Example |
External Customer Id | The Playbook Player ID | PLAYER_ID |
Transaction Date | The Date of the transaction. | TRANSACTION_DATE |
Gross Revenue | The sum total of Casino Revenue for the Transaction Date | CASINO_revenue |
Wagering | The sum total of Casino Stake for the Transaction Date | CASINO_stake |
Live Casino Product Map
Next we need to map Live Casino revenue.
Click "Add Product Map" and proceed to create a new product called "Live Casino".
Once created, select Casino and then configure the mapping as follows:
Affelios Field | Description | External Field Example |
External Customer Id | The Playbook Player ID | PLAYER_ID |
Transaction Date | The Date of the transaction. | TRANSACTION_DATE |
Gross Revenue | The sum total of Live Casino Revenue for the Transaction Date | LIVE_CASINO_REVENUE |
Wagering | The sum total of Live Casino Stake for the Transaction Date | LIVE_CASINO_stake |
Configure Daily Import
Now that the mapping configuration is set, all thats left is to enable imports.
Click the Toggle to enable imports and then select the Import Time and set it to 03:00 AM.
Once set, click "Save Integration" to complete the process.
Affelios will now automatically request data from your Playbook endpoints each morning at 3AM and import data into your affiliate program according to your integration settings.
A log of all imports can be accessed from Settings > Imports where you can also retry any failed import attempts, or reimport old historical data based on a date range.