To import affiliate program accounts from a CSV file and create reports out of them you need to go to the Settings page and use the “Bulk-connect from CSV” option which is available under the “Reports” section.
Create a CSV file (.csv extension) in which you can have 3, 4 or 5 values that must be separated by comma (,) delimiter symbols on every row, while every row represents one of your affiliate accounts that will be imported as a separate report in the system. Three of the values are mandatory (affiliate program name, username/API key, password/API ID) while the fourth value (account tags) and the fifth value (account currency) are optional. Tags can be used to provide quick filtering of your accounts in the system and viewing tailored reports based on them (e.g. “USA” tag can be used to filter or search programs only available in the USA). You can add one or more tag values to each of the rows while multiple tags must be separated by plus (+) symbols. If you choose to include the account currency values in your CSV file, make sure that you use their three-letter currency codes to list them. Lastly, note that accounts that will be using username/password authentication and API key/API ID authentication must be imported separately, also affiliate programs that support only API authentication will not be listed in the “Login credentials CSV” import screen and vice versa, so plan for this accordingly while preparing your CSV files.
Login credentials CSV format example:
CasinoLuck,username,password,tag1,eur
Slotland,username,password,tag1+tag2+tag3,usd
Fast Pay Affiliates,username,password,gbp
API credentials CSV format example:
Chilli Partners,api_key,api_id,tag1,btc
Revenue Network,api_key,api_id,eur
MioMedia,api_key,api_id,eur
Note that in the first example above the CasinoLuck account is set with 1 tag, the Slotland account is set with 3 different tags, while the Fast Pay Affiliates one has no tags and all three accounts will be imported with their relevant tag values accordingly.
Bulk-connect from CSV menu description:
CSV file name: The name of the CSV file that you have loaded.
Select reports start date: Select the month & year when the reports for your affiliate accounts should begin with after you import them.
Rows detected in the file: Shows the count of all rows with valid format in your loaded CSV file.
Already connected affiliate programs: Shows the count of affiliate programs for which you have already created reports in StatsDrone before.
Exact matches: Click on this section to review the accounts from your CSV that fully matched the affiliate program names in the system and select report currencies for each one.
Manual matching required: Click on this section to review the accounts from your CSV that only partially matched the affiliate program names in the system and adjust the matching if necessary by clicking on the drop-down fields and selecting the affiliate program that corresponds to your account.
Program Name, Username/Email, Password, Tags: This is a sample with the values from the first row of your CSV file that shows how each value will be processed by the system. Click on any of these fields in order to adjust them and make sure that each value corresponds correctly to each field.
Download List: Click this button to download a new CSV file containing the list of your affiliate accounts that did not find an exact match with the affiliate program names in the system which you can use as a reference in case you need to make adjustments to your list of accounts or perhaps send a request to us to add some affiliate programs that we might be missing.
Clear All Fields: Click this button to clear all manually matched affiliate program names, so you can start from scratch if you wish.
Import Accounts: Exact & Partial Matches: Click this button to finish the import process of all of your affiliate accounts with your current settings, both the ones that found exact or only partial matches with the affiliate program names in the system.
Import Accounts: Only Exact Matches: Click this button to finish the import process of only these affiliate accounts of yours that found perfect matches with the affiliate program names in the system.