This comprehensive guide walks through the process of integrating your Affelios program with the Playbook online sportsbook and casino platform. The integration enables automatic data synchronization and seamless affiliate tracking for your gambling business.
Prerequisites
Before starting the integration process, ensure you have the following:- Active Affelios subscription - Any plan (Flex, Pro, or Enterprise)
- Live Brand on Playbook - Your brand must be operating on the Playbook Sportsbook and Casino platform
- HTTP CSV Endpoints - Registration and Transaction endpoints provided by Playbook
- Whitelisted IP Addresses - Playbook must whitelist required Affelios IP addresses for your brand
- Admin Access - Full administrative privileges to your Affelios account
The integration process requires coordination with Playbook support to whitelist Affelios IP addresses. Contact us via Intercom or email support@affelios.com to obtain the required IP addresses before proceeding.
Integration Benefits
Key Features
The Affelios-Playbook integration provides powerful features to streamline your affiliate program management and boost performance in the gambling industry.
Automated Data Import
Automated Data Import
Seamless Data Management:
- Daily automatic import of player registrations and transactions
- Real-time commission calculations based on actual gaming revenue
- Automated deduction handling for payment fees and taxes
- No manual data entry required
Multi-Product Tracking
Multi-Product Tracking
Comprehensive Revenue Tracking:
- Separate tracking for Sports, Casino, Live Casino, and Virtual Sports
- Individual product revenue and wagering tracking
- Detailed commission breakdowns by product type
- Flexible commission plans per product category
Advanced Attribution
Advanced Attribution
Precise Player Attribution:
- 30-day cookie tracking with btag parameter
- Automatic ClickKey generation for proper attribution
- Player registration and transaction linking
- Anonymous transaction prevention
Step-by-Step Integration Guide
Step 1: Create a Brand in Affelios
1
Access Brand Creation
Navigate to your Affelios dashboard and go to the “Brands” section in the left-hand navigation menu.
2
Create New Brand
Click “Create Brand” and fill in the required information for your Playbook casino website.
3
Configure Brand Settings
Set up your brand with the proper tracking parameters and commission settings.
If you already have a brand set up, you can skip to Step 2. If you need help creating a brand, follow our Brand Creation Guide.
Brand Configuration Example
For a brand called “BetTest.com”, use these settings:Brand Step 1 - Basic Information
| Field | Example | Description |
|---|---|---|
| Name | Bet Test | Display name shown to affiliates and in reports |
| Industry | Gambling | Used to categorize and filter brands |
| External ID | bettest | Unique value used externally (best practice) |
| Landing Page URL | https://bettest.com?btag=[ClickKey] | Playbook supports 30-day cookie tracking with btag parameter |
Brand Step 2 - Advanced Settings
| Field | Example | Description |
|---|---|---|
| Auto-Approve Commissions | Enabled | Recommended to avoid data delays |
| Allow Anonymous Transactions | Disabled | Important: Keep disabled for Playbook brands |
| Deposit Fees | 3% | Payment fees deducted from Net Revenue |
| Tax Rate Deduction | 21% | Point of Consumption Taxes |
| Net Revenue Deduction | 15% | Platform and Game Costs |
Step 2: Configure Playbook Integration Settings
1
Access Integration Settings
Navigate to the “Brands” page and click the three dots next to your brand, then select “Integration Settings”.
2
Select CSV HTTP Integration
Choose “Csv Http” from the available integration methods for Playbook.
3
Configure HTTP Connection
Enter the CSV endpoint details provided by your Playbook account manager.
You must obtain the CSV endpoint details from your Playbook account manager before proceeding. Contact them if you don’t have these details.
Step 3: Set Up HTTP Connection Settings
HTTP Connection Configuration
Configure the connection settings using the details provided by Playbook:
| Field | Example | Description |
|---|---|---|
| Protocol | HTTPS | Enable HTTPS for secure data transfer |
| HTTP Hostname | documents-api.prod.bettest-multi.tup-cloud.com | Hostname containing your unique brand identifier |
| Username (Basic Auth) | - | Not required for Playbook |
| Password (Basic Auth) | - | Not required for Playbook |
| Registration Filename Template | affiliate-documents/bettest/accounts/[YEAR]-[MONTH]-[DAY] | Path to Registrations file with date tokens |
| Transactions Filename Template | affiliate-documents/bettest/sales/[YEAR]-[MONTH]-[DAY] | Path to Transactions file with date tokens |
The filename templates use automatic token replacement: [YEAR] (e.g., 2030), [MONTH] (e.g., 12), [DAY] (e.g., 31). Affelios will request the previous day’s data each morning.
Step 4: Configure Field Mapping
After establishing a valid connection, you’ll need to map the CSV fields to Affelios fields.Customer Field Mapping
Registration Data Mapping
Map the available fields from the Registrations CSV to Affelios fields:
| Affelios Field | Description | External Field Example |
|---|---|---|
| Registration Date | The date the player registered | ACCOUNT_OPENING_DATE |
| External Customer ID | The Playbook ID for the player | PLAYER_ID |
| Click Key | Unique value generated by Affelios | BTAG |
| Customer Username | Anonymized username from Playbook | USERNAME |
| Country Code | 2-letter country code of the player | PLAYER_COUNTRY |
Transaction Field Mapping
Playbook returns aggregated totals for Deposits, Wagering, and Revenue split by Product. You’ll need to create multiple product maps:Default Map (Deposits)
Default Map (Deposits)
Required for Deposit Tracking:
All other fields should be left blank for the Default Map.
| 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 | Sum total of Deposits | DEPOSITS |
Sports Product Map
Sports Product Map
Sports Betting Revenue:
| 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 | Sum total of Sports Revenue | SPORTSBOOK_REVENUE |
| Wagering | Sum total of Sports Stake | SPORTSBOOK_STAKE |
Virtual Sports Product Map
Virtual Sports Product Map
Virtual Sports Revenue:
| 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 | Sum total of Virtual Sports Revenue | VIRTUAL_SPORTS_revenue |
| Wagering | Sum total of Virtual Sports Stake | VIRTUAL_SPORTS_stake |
Casino Product Map
Casino Product Map
Casino Revenue:
| 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 | Sum total of Casino Revenue | CASINO_revenue |
| Wagering | Sum total of Casino Stake | CASINO_stake |
Live Casino Product Map
Live Casino Product Map
Live Casino Revenue:
| 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 | Sum total of Live Casino Revenue | LIVE_CASINO_REVENUE |
| Wagering | Sum total of Live Casino Stake | LIVE_CASINO_stake |
Step 5: Enable Daily Import
1
Configure Import Settings
Toggle the import setting to “Enabled” and set the import time to “03:00 AM”.
2
Save Integration
Click “Save Integration” to complete the setup process.
3
Verify Connection
Affelios will automatically test the connection and validate the field mappings.
Affelios will now automatically request data from your Playbook endpoints each morning at 3 AM and import data into your affiliate program according to your integration settings.
Data Import Management
Automatic Import Features
Once enabled, data import happens automatically and keeps your affiliate program synchronized with Playbook data.
Import Process
Daily Data Retrieval
Daily Data Retrieval
Automated Process:
- Affelios requests previous day’s data from Playbook each morning at 3 AM
- Both registration and transaction data are imported
- Data is processed and mapped according to your configuration
- Commissions are calculated automatically
Data Validation
Data Validation
Quality Assurance:
- Connection validation before each import
- Field mapping verification
- Data format validation
- Error logging and reporting
Import Monitoring
Import Monitoring
Track Performance:
- View import logs in Settings > Imports
- Retry failed import attempts
- Reimport historical data by date range
- Monitor import success rates
Managing Imports
1
Monitor Import Status
Check the import logs in your Affelios dashboard to ensure data is being imported successfully.
2
Review Data Quality
Verify that player registrations and transactions are being processed correctly.
3
Handle Import Errors
Use the retry functionality for any failed imports or contact support if issues persist.
4
Historical Data
Reimport historical data if needed using the date range selector in the imports section.
Commission Management
Automated Commission Processing
The Playbook integration automatically processes commissions based on your configured settings and product mappings.
Commission Calculation
Revenue-Based Commissions
Revenue-Based Commissions
Gaming Revenue Tracking:
- Commissions calculated on Gross Gaming Revenue (GGR)
- Separate tracking for each product category
- Automatic deduction handling for fees and taxes
- Real-time commission updates
Deduction Management
Deduction Management
Automated Deductions:
- Deposit fees (e.g., 3% payment processing fees)
- Tax rate deductions (e.g., 21% Point of Consumption taxes)
- Net revenue deductions (e.g., 15% platform costs)
- Transparent deduction reporting
Product-Specific Rates
Product-Specific Rates
Flexible Commission Plans:
- Different rates for Sports, Casino, Live Casino, Virtual Sports
- Customizable commission structures per product
- Tiered commission plans based on performance
- Automatic commission approval (recommended)
Troubleshooting
Common Issues
Here are solutions to common problems you might encounter during the Playbook integration process.
Connection Issues
Connection Issues
Cannot Connect to Playbook:
- Verify that Playbook has whitelisted the required Affelios IP addresses
- Check that your HTTP hostname is correct and contains your brand identifier
- Ensure your Playbook account is active and accessible
- Contact Playbook support to verify endpoint availability
Data Import Problems
Data Import Problems
Data Not Importing:
- Check that your filename templates are correct
- Verify that Playbook is generating the expected CSV files
- Ensure your brand is properly configured in Playbook
- Review import logs for specific error messages
Field Mapping Issues
Field Mapping Issues
Incorrect Data Mapping:
- Verify that CSV field names match your mapping configuration
- Check that all required fields are properly mapped
- Ensure product maps are created for each revenue type
- Test with a small sample of data first
Commission Calculation Problems
Commission Calculation Problems
Commissions Not Calculating:
- Verify that your commission plans are properly configured
- Check that product mappings include revenue fields
- Ensure auto-approve commissions is enabled
- Review deduction settings and percentages
Getting Help
1
Check Import Logs
Review the import logs in Settings > Imports for specific error messages and details.
2
Contact Playbook Support
Reach out to your Playbook account manager for endpoint or data-related issues.
3
Contact Affelios Support
Contact Affelios support via Intercom or email for integration-specific problems.
4
Provide Details
Include information about error messages, import logs, and steps you’ve already tried.
Best Practices
Optimization Tips
Follow these best practices to ensure your Playbook integration runs smoothly and effectively.
Data Management
Data Management
Keep Your Data Clean:
- Regularly monitor import logs for any issues
- Ensure Playbook is generating consistent CSV formats
- Verify that all required fields are being populated
- Keep historical data for reporting and analysis
Commission Planning
Commission Planning
Optimize Your Commission Structure:
- Set competitive commission rates for the gambling industry
- Consider different rates for different product categories
- Monitor affiliate performance and adjust rates accordingly
- Provide clear commission information to affiliates
Integration Monitoring
Integration Monitoring
Stay on Top of Performance:
- Set up alerts for failed imports
- Regularly review commission calculations
- Monitor data quality and consistency
- Keep backup records of important transactions
Affiliate Support
Affiliate Support
Support Your Affiliates:
- Provide clear information about your gambling products
- Share performance insights and marketing tips
- Respond promptly to affiliate questions
- Recognize top-performing affiliates
Next Steps
Your Integration is Complete!
Congratulations! Your Playbook platform is now successfully integrated with Affelios. Your affiliates can begin marketing your gambling products immediately.
What Happens Next
1
Data Synchronization
Affelios will automatically import player registrations and transactions from Playbook each day.
2
Commission Processing
Commissions will be calculated and processed automatically based on your configured settings.
3
Affiliate Onboarding
Start inviting affiliates to join your program or promote it to attract new partners.
4
Performance Monitoring
Use the Affelios dashboard to monitor clicks, conversions, and commission payouts.
5
Program Optimization
Continuously optimize your program based on performance data and affiliate feedback.
Additional Resources
Further Reading
- ⚙️ Program setup: Setup Guide - Complete program configuration and brand management
- 💰 Commission management: Commission Plans - Advanced commission strategies and configuration
- 👥 Affiliate onboarding: Affiliate Onboarding Guide - Guide for your new affiliates
- 📊 Analytics & reporting: Reporting & Analytics - Understanding your program performance
- 🧩 Other integrations: Shopify Integration - Connect with e-commerce platforms
- 👩💻 API access: Developer Overview - Advanced integration options and API documentation
Need additional help? Our support team is available to assist with any questions or issues you might have with your Playbook integration. Contact us via Intercom or email support@affelios.com.