Introduction:
Implementing a bulk upload of affiliate programs into StatsDrone using API credentials is a secure and efficient method to manage multiple accounts, particularly when you’re handling numerous programs. This guide provides detailed instructions on how to prepare and upload your data using API credentials.
You Will Need:
Basic understanding of CSV file formats.
Knowledge of how to edit text files to conform to the required format.
Familiarity with your affiliate program details, such as program names, API keys, and API IDs.
CSV File Requirements:
File Format: Prepare a text file saved with a .CSV extension. Each row in the CSV file represents a separate affiliate account, and each column within a row should contain specific details about that account.
Mandatory Columns: Each row must include the affiliate program name, the associated API key, and API ID, separated by commas.
Optional Tags Column: You can add tags to further categorize your accounts. Tags should be separated by plus (+) symbols instead of spaces (e.g., USA+Gaming+2022).
Example of a CSV File Setup:
There should be no headers in the CSV file, but the format should follow:
Program Name | API Key | API ID | Tags (optional)
Pin-Up Partners | API Key | API ID | 50eur+cpa+40rs |
7StarsPartners | API Key | API ID | canada |
ReadyCasino Affiliates | API Key | API ID | UK+Welcome+Bonus |
Steps to Prepare and Upload Your CSV File:
Step 1: Create Your CSV File
Include the necessary details for each affiliate account as specified. Ensure no headers are present in the file, and spaces in tags are replaced with the plus (+) symbol.
Step 2: Access the Bulk Upload Feature
Navigate to the ‘Settings’ page within your StatsDrone account.
Scroll down to ‘CSV File Options’ and select “Bulk-connect from CSV”.
Step 3: Upload and Configure
Click on your account initials
Navigate to "Settings"
Click the "API credentials CSV" button
Click on the "Import Accounts: Only Exact Matches" button
This will only import accounts with Exact Matches. If you want to also include partial matches, skip this step.
Click on the "Import Accounts: Exact & Partial Matches" button
This step is for both Exact and Partial Matches, if you only want exact matches don't do this step.
Sometimes the bulk importer will not find an exact match for your programs, this is typically due to differences in how the program is named, or misspelling, or using a brand name instead of the program name.
To fix this, click on manual matching required
The program will show you the partially matched names, click the dropdown and select the appropriate account (in this case, Revenue Network was misspelled, and partial matched to Income Network, Revenue Network etc.)
You will see a success message, click on the home icon to view your accounts connected
You will see the message "This account is connected, but the statistics collection process has not been started yet"
Click on the sync stats button to fetch the data from your account
Common Issues when bulk importing
Multiple Brands/Same Program: Avoid bulk uploading programs with multiple brands under the same login credentials as it may lead to naming conflicts (e.g., copy 1, copy 2).
Different Software Versions: Programs may use different software versions - We recommend that these should be entered manually to ensure accurate data integration.
Some programs cannot be imported with their login credentials due to programs requiring 2FA. In this case we recommend connecting them via API credentials.
For some programs like SoftSwiss - you only need the API key, but you will have to enter the RS and CPA amounts as this is not something they support reporting on natively.
Conclusion:
Bulk uploading via CSV can significantly reduce the effort required to manage multiple affiliate programs in StatsDrone. By carefully preparing your CSV file and following the upload process, you can efficiently organise and manage your affiliate accounts, making full use of StatsDrone’s bulk account importing capabilities.