Migrating from a spreadsheet or another platform and want to save yourself from the manual labor of getting all of your affiliates into Trackdesk? Easily import all of your affiliates to Trackdesk in one fell swoop via CSV – here's how to do it.
This feature is only available for Starter plan and higher.
Prepare your CSV file
First, prepare the raw data for import. As with most data-based operations, the better the source, the better the result, so make sure your data is consistent and without errors. The bare minimum of information that needs to be present in the CSV is your affiliate's email and full name (or it can be separated in first name, middle name, last name etc. – you will be able to connect the data in one of the later steps). You can also include a Referral ID or password you want to create for your affiliates – don't worry if you don't have either one of them; the system can generate them automatically.
If you already have a file that has more columns present, you can just leave it as it is; the system will take only relevant data into account.
We also recommend using the first row of the CSV as a header indicating the data in each column, as it will make it easier to assign the data properly later on.
The system supports most major delimiters and encoding; although we do recommend using a comma and UTF-8.
Once you have your data prepared and ready to go, you can proceed onto the next step.
Upload your CSV file
Under "Affiliates", navigate to "Affiliate list" page from the main menu and click on the "Add new affiliate" button. You will see the following prompt with the "Import from CSV" option:
Select the CSV file you prepared in the previous step, or drag and drop it directly into the app:
Review the data before committing to the import
The system will parse the columns of your CSV and automatically assign them to specific parameters in Trackdesk database. Before committing to the import, you have to review how the data that will be imported.
Important: Make sure to thoroughly review the data from your CSV as it will appear in the system to avoid any complications!
In order to properly set up your affiliates in the system, the following parameters need to be created/imported:
Login email – This is the email your affiliates will use to log in to the system and where they will receive the invitation to register. For more detail about affiliate registration, see this article.
Full name – The name of the affiliate as it will be displayed in the system.
Referral ID / Affiliate ID – The ID of the affiliate; this ID is used by the affiliate when sending traffic to your website.
Password – The initial password created for the login.
The "Treat first line as header" is turned on by default and skips the first line in the CSV. Values in this row are treated as select options in the inputs below. If you want, you can turn this off, and the first line data will be imported as an affiliate.
In the column mapping section of the import, you can select which columns from your source file you want to assign to each parameter in the Trackdesk database.
For instance, you can put together the full name of your affiliate by ordering the columns from your source file. In the system, they will be unified into a single full name parameter.
After you review the data, you can click on the "Import" button, which will start importing the affiliates in the system and send out an invitation to sign up with Trackdesk via email if it succeeds. You can review the status of each import in the status column.
Get started with affiliate management on Trackdesk
Now that you have your affiliates imported into Trackdesk, you can start managing them and invite them to take part in one of your offers to start creating conversions. To learn more about all the options we have for affiliate management, refer to the Affiliates section on our wiki.