Conversion Data Import

If you have previous data pending in your previous tracking software or you have some offline conversion reports then you can add conversion manually with vNative CSV import feature. To import conversion data follow the below steps;

Step 1: Click on integrations,

Step 2: Click on CSV uploads,

Step 3: Click on Conversions and select the file from your computer and click on Upload.

Before clicking on upload button make sure the .csv file should be in the required format.

The example below shows how your file could look when updating the conversion.

campaign_id, publisher_id only required if click_id not present, If click id is present then these values are ignored. Even if one of the record in these columns is incorrect then that whole record wouldn’t be accepted. Please check the format carefully.

Your input file must be a comma-delimited CSV file containing the conversions you want to import. It must also:

  • Contain no more than 100,000 conversions
  • Match accepted value restrictions (case-sensitive)
  • Include headers for each column/field
  • Separate records using newline characters

Column name with * is required.

Column Name Description Accepted Values Example
click_id unique id of click generated Up to 24 characters 2320322sa2103qa
campaign_id* unique id of conversion tracked Up to 24 characters  8ad4d0032kd39223
publisher_id* Here you will add unique Id given Affiliate/Publisher Up to 255 characters  ds31323034ss
goal_id ID of the goal in the campaign that you want to credit the conversion for Up to 255 characters 43545302
txn_id URL to preview landing page Any URL
sub1, sub2, sub3, sub4 Extra parameter received for the conversion. any value Agency123
sale_amount Amount of total sale done, it’s very useful when you are offering the percentage of sale amount (used to set payout and revenue for CPS offers) Value with up to two decimal places. 100.02
sale_currency Three-letter ISO currency abbreviation  Currency unit defined by ISO USD
method It’s the method with which the conversion has been recorded pixel or aquisition pixel
ipaddr Advertiser IP address used to create conversion Valid IP addresses up to 15 characters (IPv6 not supported)
status Approval status of the conversion “pending”, “approved”, or “rejected” approved
created Date and time for the conversion  YYYY-MM-DD HH:MM:SS 2017-10-30 10:10:09
type Type of the campaign conversion, sales or installs conversion
referer Type of the referer Any value

An error prior to upload completion could be caused by one the following reasons:

  • File contains more than the maximum of 100,000 lines.
  • Headers contain invalid fields or are not formatted correctly.
  • File type is not valid. Make sure you’re uploading a comma-delimited CSV file.

Lines failing to update could be caused by one of the following issues:

  • Click session has expired or isn’t active.
  • Clickid is invalid or doesn’t match any recorded sessions in your network. Pixel-based sessions aren’t recorded until the Clickid is passed in an offer URL.
  • Data for a field is invalid or is formatted incorrectly.
  • Conversions already exist for the clickid. The upload won’t record duplicate clickids unless the Multiple Conversions campaign tracking setting is enabled.

Learn How to set up a campaign on vNative?

Create Your Account Now!

Get Started with 30 Days FREE Trial Account. No credit card required.

Get Started FREE