Introduction:
Implementing a bulk upload of affiliate programs into StatsDrone via a CSV file streamlines the process of managing multiple accounts, especially when you’re handling numerous programs with varying credentials and tags. This guide provides detailed instructions on how to prepare and upload your data efficiently.
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, usernames, and passwords.
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 username, and password, 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 | Username | Password | Tags (optional)
Pin-Up Partners | username | password | 50eur+cpa+40rs |
7StarsPartners | username | password | canada |
ReadyCasino Affiliates | username | password | 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 "Login 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.
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.