Import
The Import tool helps you handle a massive number of conversions efficiently. It eliminates the need for manual creation and saves you significant time, while still ensuring a reliable and transparent process.
You can also track and analyze your CSV conversion imports with full transparency using the Import log. It gives you clear visibility into every file you upload, so you can quickly evaluate results, spot issues, and resolve them efficiently.
⚠️ Be careful when working with the import option. Make sure you upload the file correctly. If you uploaded the list of conversions in the wrong way, you’ll have to edit the whole list manually.
To work with the import feature, you are to have special permissions. Read about it here.
Step 1. File creation
Create the file with all the data about the conversions you need. You must enter each data type in a separate column:
Save the file.
⚠️ The requirements you should take into account:
The file must have .CSV format.
The data in the file must have the semicolon ( ; ) or a comma ( , ) separator.
The whole process of file creation might look like that:
Step 2. Scenario selecting
In Statistics > Conversions, click Import.
Select the needed scenario.
Fill in the required and optional fields. Each scenario has its own required fields. You must fill all of them to import your file.
Scenario: Import conversions
Required fields:
Offer ID: internal offer ID.
Affiliate ID: ordinal Affiliate ID can be taken from the list of affiliates in the Affiliates section on your instance.
Conversion ID: action ID passed to you by your Advertiser via postback or any other ID you need to register the conversion under. Conversion ID can be a conversion ID in the advertiser's system, a conversion ID from the tracking platform you used in the past or another value.
⚠️ When you import conversions without click ID, you will see "0" in the Time to conversion column of Conversion slice in Statistics.
Optional fields:
Click ID: click ID which conversion was made on.
Goal: goal value that exists in your instance and is set in the payouts' settings of the offer.
IP: IP the conversion belongs to.
⚠️ If you make an import using click ids, the IP a click is made from, and the one you have in your file must be the same. Otherwise, the import won’t take place. If you do not use the click id value in your import, you can use any IP you need.
Status: conversion status.
⚠️ You must write the status with digital values (Approved - 1, Pending - 2, Declined - 3, Hold - 5).
🔎 You can also import new conversions for offers with the status Paused.
Comment: note (use UTF-8 file encoding only).
Created at: date of a conversion creation (YYYY-MM-DD format). If you don't mention any date in the file, the system imports the conversions for the day when the import takes place.
Sum: a sum the advertiser pays for conversion. Use this field when a percent type of payment in the offer's settings takes place. Once you import the sum, the system calculates conversion revenue and payout based on the amount of sum in the file.
⚠️ Don't use the sum for a fixed type of payment. Once the offer has fixed type of payments, the system automatically assigns conversion revenue and payout based on the payouts' settings (GEO, Device, Goal, etc.)
Custom field 1 - Custom field 7: custom fields.
⚠️ When importing conversions without Click ID and IP, and with certain goal values, the system considers the first payout set up in the offer, regardless of goals in the import file. In the case of the CPS or RPS/CPA type of payments, the system shows the numbers dependent on the Afprice value as 0.
Promocodes: the promocode of the conversion.
Scenario: Import registered
Required field:
Click ID
🔎 A conversion id in the advertiser's system, conversion ID from the tracking platform you used in the past, a click ID, or another value can be used as a conversion ID.
Find the description of all the fields in the section above.
Scenario: Update
Required fields:
Offer
Conversion ID
Status
Click ID
Affiliate ID
⚠️ Keep in mind the following:
If the conversion has a click ID and conversion ID, it's mandatory to specify these values when importing.
You are to specify the Goal field in the file that you upload to Affise, if you want to update conversions with a goal value different from the default one - 1. Otherwise, the system creates new conversions.
🔎 You can update conversions with click ID and without offer ID.
Find the description of all the fields in the section above.
Scenario: Mixed mode
You can add new conversions and change the conversion's status of the conversions at a time.
Required fields:
Affiliate ID
Offer ID
Optional parameters you can include:
Goal ID
Status
Sum
Comment
IP
For example, you need to change the statuses of three existed conversions for clicks that have never been registered (1) and add two new conversions (2):
The required fields are Offer ID and Affiliate ID.
Step 3. File importing
Optional. Select the Import with headers checkbox, if you have a header (name) for each type of data in the first row of the file. The system carries out the import from the second row.
Click Choose file and pick up the needed file. A matching window appears. It might look like that:
Match values in the .CSV file (the From your file column) and types of data on Affise (the In our system column). The system takes the data from columns one by one.
Click the Approve column button to confirm the matching.
Optional. If you want the system to ignore the values in the column, click the Exclude column button.
Review the matching. If you want to change the arrangement, click the Back to edit mode button.
Optional. If you want to send affiliate postbacks for imported conversions, select the correspondent checkbox.
Click the Create ... new rows button to import conversions.
Conversions import can take some time if it involves a big amount of data. You can check logs to see if the import was successful.
Import log
Import logs provide clear visibility into key details of each import. It shows who initiated the process and when it was performed, as well as the total number of rows in the file. You can also track the current status of the import and view any error messages if the import was unsuccessful.
Import logs not only let you confirm that an import occurred, but also allow you to see the exact row in the file containing the data that triggered the creation or update of a conversion.
🔎 Import conversion logs are stored for one year.
To find the import log, go to Statistics > Conversions > Import Log.
Here you can view the following columns:
Status: current status (Uploaded, Processing, Finished, Failed).
User: the user initiated the import.
Total rows: total number of rows in the file.
Import ID: the ID of the import.
Created at: when the import was performed.
You can click Details and View all rows to access more in-depth information about each import.
You can also check any conversion back to its source import using Click ID, Action ID, and Conversion ID. Click Details to get details about each row.
Please contact the Affise Customer Support team regarding all raised questions via the e-mail: [email protected].