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:

Column Optional/required Description
conversion_id Optional The unique conversion id of a conversation recorded by vNative Tracking System
click_id Optional The click id generated when user open any link
campaign_id required (If creating new conversion) The unique conversion id of a conversation recorded by vNative Tracking System
publisher_id required (If creating new conversion) The Publisher Id whose conversion is to be attributed
goal_id Optional The Goal ID if the Conversion is a Goal Conversion
txn_id Optional Unique Transaction Ids for multiple conversions on one click
sub1 to sub5 Optional extra parameter passed by the advertiser
sale_amount Optional The sale amount for CPS Campaign
payout_currency Optional the 3-digit currency code
payout Optional The payout value in the specified Currency
revenue Optional The revenue value in the specified Currency
method Optional The method of recording conversion acquisition or pixel
ipaddr Optional The IP address from which conversion is recorded
status Optional The status of conversion pending, approved, rejected etc
created Optional The date time in YMD HH:MM:SS format
type Optional Type conversion
referer Optional The URL where the conversion occurred

 

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: 25