Creating the URL
The URL required for creating a partner data export file is build up as following:
https://export.net.[domain]/[magic_key]/adm-affiliateexport_[user_ID].[file_extension]?[filters]
Once you have filled in the export domain, the magic key, your user ID and the relevant file extension and you have applied filters, your URL should look more or less like this:
https://export.net.yourdomain.com/f0d58188-5420-1234-8485-0417a3a85886/adm-affiliateexport_123.csv?filter[a:advertiser_program_id]=456&filter[from_date]=01.06.2014&filter[to_date]=27.08.2014
Applying filters
For the partner data export file, following filters can be applied:
Filter description | Filter name | Compulsory | Format |
---|---|---|---|
Allows you to filter partners by registration date, from the date you fill in. | from_date | No | dd.mm.yyyy |
Allows you to filter partners by registration date, until the date you fill in. | to_date | No | dd.mm.yyyy |
Allows you to filter partners by advertiser program. | a:advertiser_program_id | No | MID, found in the advertiser center |
These filters are to be added to the URL as parameters. Use the the question mark (?) for the first parameter and the ampersand (&) for all further parameters. Add the word filter, the filter name, the equals sign (=) and the relevant values according to the format mentioned in the table.
Output
The file you export via the URL you’ve created will contain the following data:
Name | Explanation | Example |
---|---|---|
uid | The user ID of the partner. | 123 |
The email of the partner. | ||
first_name | The first name of the partner. | Joe |
last_name | The last name of the partner. | Fischer |
address | The address of the partner. | New Street 4 |
zipcode | The zip code of the partner. | 12345 |
city | The city in which the partner is registered. | London |
countrycode | The code of the country in which the partner is registered according to ISO 3 and 2, divided by underscore. | DEU_DE |
currencycode | The code of the currency of the country in which the partner is registered, according to ISO standards. | EUR |
phone | The phone number of the partner (optional) | 555-4985 5467 |
language | The language in which the partner uses the partner account. | ENG |
status | The status of the partner: 0 = waiting for confirmation, 1 = active, 2 = deactivated, -1 = deleted. | 1 |
user_vat | Whether the partner is obliged to pay value added tax. | TRUE |
company | The registered name of the company of the partner. | Max Profit Inc. |
registration_date | The time and date of the moment the partner registered for the platform in the following format: yyyy-mm-dd hh:mm:ss+miliseconds. | 2014-04-10 12:07:25+02 |
payout_limit | The height of the payout limit. NB: 0 implies the partner did not set a limit. | 0 |
newslettersettings | Whether the partner receives platform newsletters and notifications via email and the account inbox or only via the account inbox. | inbox |
entity_id | The ID of the entity to which the partner has been allocated. | 82 |
last_modification | The time and date of the moment the partner last modified data in the following format: yyyy-mm-dd hh:mm:ss+miliseconds. | 2018-01-29 17:05:35.404182+01 |
platform_id | The ID of the platform to which the partner is allocated. | 40 |
thirdpt_tracking_settings | Whether the partner has implemented third party tracking settings. | TRUE |
transfer_type | The method applied to transfer commission: sepa, iban or bank account. | 1 |
labels | The labels used to categorize the partners. | high traffic |
email_confirmed | Whether the partner has verified the registered email address. | TRUE |
registration_emailkey | The key used to verify the email address. | 3a20dc26-4923-467c-aa08-90e941bcf6b3 |