Generating or Updating Conversions with a CSV upload : Helpdesk

Generating or Updating Conversions with a CSV upload

This feature will let you generate or update conversions with a CSV upload. Click here for the advanced instructions

You can find it in the Reporting > Imports. Here is how it works.


IMPORTANT

- The file must match the provided formatting exactly. Inclusion of spaces or reordering the columns will result in an error message

- The max file row limit for .csv is 15,000 rows. For larger files - please split into multiple csv files(each file less than the 15k row limit) before importing.


Step 1

Go to this section and click the "Import" button on the right side of the screen


Step 2

Once you click the import button it will bring up this screen, please follow the steps below to make sure you format the import correctly.


Step 3

Formatting the Import
There are three types of operations you can do:
1) Update Payout/Revenue + Sale Amount
2) Update Conversion Status

3) Add Conversions using Transaction ID or Offer ID + Affiliate ID

1) Updating payout/revenue and amount

All columns must be in the same order and formatted as shown below. If you have no data for the columns, use "0" (with the exception of adv_event_id which may be used in place of event_id; adv_event_id requires the specific Advertiser level event ID).  For more details, click here.


If you have a list of conversion IDs

conversion_id, payout, revenue, sale_amount


If you have a list of transaction IDs

transaction_id, event_id, payout, revenue, sale_amount


2) Adding Conversions using Transaction ID

All columns must be in the same order and formatted as shown below. If you have no data for the columns, use "0" (with the exception of adv_event_id which may be used in place of event_id; adv_event_id requires the specific Advertiser level event ID).  For more details, click here.


If you have a list of transaction IDs and wish to create a conversion that uses the default revenue & payout.

transaction_id, event_id, sale_amount


If you wish to add clickless conversions using default or custom payout, revenue, sale amount

offer_id, affiliate_id, event_id, payout, revenue, sale_amount

.



3) Updating Conversion Status

All columns must be in the same order and formatted as shown below. If you have no data for the columns, use "0" (with the exception of adv_event_id which may be used in place of event_id; adv_event_id requires the specific Advertiser level event ID).  For more details, click here. It is important to note that when these status' are updated from rejected to active and vice versa that the conversion will change the original payout and revenue associated to it.



If you have a list of conversion IDs:

conversion_id, status


if you have a list of transaction IDs:

transaction_id, event_id, status

The excel sheets should look something like this:



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.