Importing and Bulk Updating Conversions

You are here:
Estimated reading time: 2 min

This tool helps to Bulk Import conversions or Bulk Update Conversions in your vNative account, making it easier through CSV file uploads. CSV file has certain fixed column which needs to maintained and then uploaded to CSV Upload Section in Integrations.

Preparing CSV File

Your Input file must be a Comma Separated Value (CSV) file containing conversions you want to upload or update.

  • Contains up to 50,000 conversions
  • Fixed Header

The columns in CSV file are:

ColumnOptional/requiredDescription
conversion_idOptionalThe unique conversion id of a conversation recorded by vNative Tracking System
click_idOptionalThe click id generated when user open any link
campaign_idrequired (If creating new conversion)The unique conversion id of a conversation recorded by vNative Tracking System
publisher_idrequired (If creating new conversion)The Publisher Id whose conversion is to be attributed
goal_idOptionalThe Goal ID if the Conversion is a Goal Conversion
txn_idOptionalUnique Transaction Ids for multiple conversions on one click
sub1 to sub5Optionalextra parameter passed by the advertiser
sale_amountOptionalThe sale amount for CPS Campaign
payout_currencyOptionalthe 3-digit currency code
payoutOptionalThe payout value in the specified Currency
revenueOptionalThe revenue value in the specified Currency
methodOptionalThe method of recording conversion acquisition or pixel
ipaddrOptionalThe IP address from which conversion is recorded
statusOptionalThe status of conversion pending, approved, rejected, cancelled etc
createdOptionalThe date time in YMD HH:MM:SS format
typeOptionalType conversion
refererOptionalThe URL where the conversion occurred
Note: Cancelled conversion will not be visible to your publishers

Creating Conversions

Conversions can be imported in vNative with click_id or without click_id in CSV file, make sure that all the columns in the CSV file are fixed.

Sample File: Download

Once the file is ready, go to Integrations from Top right and select Conversion from CSV Uploads in the left menu.

Note: To rollback new conversions Import just delete the Import Job created from Integrations Page.

Updating Conversions

To Update a Conversion you need to have conversion id of that conversion, leave empty other columns if you don’t want them to get Updated.

Import Status

The vNative Platform Executes Import Task and Update record every 60 mins, so after upload the CSV file without any error check after 60 mins.

Once the Task is executed you can see status from last updated column

You can always check the status logs of the file being imported by clicking on the Import you have added.

API Conversion Import

vNative Platform allows you to import bulk conversions through API also.

API: Import Conversion

API: Get Conversion Logs

Tags:
Was this article helpful?
Dislike 0
Views: 48