All Collections
Other Automations
Bulk Upload Data
How to bulk upload conversion data?
How to bulk upload conversion data?
Updated over a week ago

At a glance: The knowledge about bulk upload conversions on the platform and the actions necessary to accomplish the same are presented in this article.


Overview

In Trackier, users have the ability to upload new conversion data and make bulk edits to existing conversions according to their specific needs. Furthermore, this feature allows for a smooth and efficient migration from any previously used platform to Trackier.


We have divided the bulk upload feature into 3 use cases; you can check which suits you best according to your requirements.

  • Edit the existing conversion

  • Adding new conversion

  • Migrating conversion data from different platforms.

Note

Pro Tip

  • If your advertiser does not support postback integration or if the campaign is running offline, then you can upload approved conversions via data import.

  • You can also send postbacks for all the approved conversions to your publishers through this feature.

  • While uploading the conversion csv, we need to select the checkbox to fire the postbacks to the publisher as per the requirement.

CSV field requirements for different use-cases

Column Name

Edit Existing Conversions

Adding New Conversion

Migrating Conversions ( only for New User)

Conversion_ID

( Generated On Trackier )

Click_id
(Trackier Click id got from Advertiser end, for those conversions which are not fired to us)

If Required

1. If you have a click ID, then you can use that click ID.
2. If not, then the system will generate a new click for conversion.

Publisher_ID

Campaign_ID

Status

If Required

Created_Date
(YYYY-MM-DD)

goal_value

If Required

If Required (* default - attributed to default goal)

If Required (* default - attributed to default goal)

txn_id
(Unique oder/lead id tracked on advertiser end)

If Required

If Required

If Required

Note

If Required (* default - "CSV Adjusted")

If Required (* default - "CSV Uploaded")

If Required (* default - "CSV Uploaded")

Currency

Payout

If Required

If Required (If not uploaded, then a campaign or publisher-specific payout will be considered)

If Required (If not uploaded, then a campaign or publisher-specific payout will be considered)

Revenue

If Required

If Required (If not uploaded, then a campaign or publisher-specific payout will be considered)

If Required (If not uploaded, then a campaign or publisher-specific payout will be considered)

Geo

If Required

If Required

If Required

City

If Required

If Required

If Required

ISP

If Required

If Required

If Required

Source
(sub-publisher ID)

If Required

If Required

If Required

p1
(publisher click ID)

If Required
( if you are planning to fire postback, the system should have publisher click ID, or you need to upload it. )

If Required
( if you are planning to fire postback, the system should have publisher click ID, or you need to upload it. )

If Required
( if you are planning to fire postback, the system should have publisher click ID, or you need to upload it. )

p2-p10
(publisher parameter)

If Required

If Required

If Required

sub1-sub10
( Advertiser sub ids)

If Required

If Required

If Required

Gaid

If Required

If Required

If Required

Idfa

If Required

If Required

If Required

Tip

  • Editing: If you want to edit any existing conversion, you need to have the conversion ID and any other column uploaded with it will be updated.

  • Adding New Conversion: If you got the click ID from the advertiser, you can use it; otherwise, remove the column, and our system will generate new unique conversion ID's and click IDs.

  • Migration: If you want to upload past conversions, make sure you have the same publisher ID and campaign ID on Trackier so that the uploaded conversion can be correctly attributed.

Supported values

Column Name

Value Supported

Status

approved | pending | rejected | cancelled

Created_Date

The date format must be (YYYY-MM-DD)

Geo

  • Country ISO Code (ex: US, DE): for reference, click here.

  • Use ALL if no specific geo is mentioned

  • Use a comma to separate multiple Geo's. (US,DE,MX)

p2-p10

Open the Publisher parameter to store any value required to be passed in the tracking link.

goal_value

Use the same goal value as created in the campaign.

Note

  • Please make sure you are using the correct spelling and code values that are supported for status, geo, and goal_value.

  • Don't put anything in the blank cells if no data is applicable.

  • Remove unwanted columns from the CSV so that there is no chance of error.


Steps to follow to upload conversions

Step 1: Go to the Data Import feature.

  • Once you are ready with CSV, go to the Automation section, click on Data Import, and select Conversion CSV to proceed further.

How to bulk upload conversion data?


Step 2: Map the CSV columns

  • Click on Choose File and upload CSV; just after that, you will find the option to map the CSV fields to conversion fields. Make sure the CSV fields match the conversion fields to successfully upload conversions on the panel.

  • Now, after mapping is completed, you have three other options, which are mentioned below, and you can select the one that best suits your requirements.

    1. Don't fire postbacks: Postbacks will not be fired to the publisher if you are selecting this option.

    2. Send postbacks for Approved and Pending conversions: This option will fire the conversions to the publisher for the approved as well as pending conversions. Conversions with any other status, apart from approved and pending, will not be sent to the publisher.

    3. Refire postbacks for Approved and Pending conversions: You can refire the postbacks for approved and pending conversions depending upon your requirement.

    How to bulk upload conversion data?


Step 3: Upload

  • Click on upload, and once uploaded, it takes one minute to four hours for the data to get processed, depending on the CSV size.

Note :

  • In the case of duplicate data, you will get a pop-up if you want to upload the same or remove the duplicate transactions.

    How to bulk upload conversion data?


  • If you want payouts to be applicable as per the date when the conversion occurred, you can select payout based on the backdate check box.

    How to bulk upload conversion data?
  • If you have uploaded stats for today, they will be processed the next day in the report section and not in real-time.

  • The CSV upload system supports up to 50,000 rows; if there are more than 50,000 rows, we recommend splitting the file into two different parts and uploading them.

  • Keep a check on the log to review the status for completion or error.

Note: If the payout or revenue is uploaded in percentage format, the system will not accept the upload and will display an error. Alternatively, the data may not be uploaded at all, given that the system exclusively accepts numerical values.


Manually Upload Data

  • You can manually upload the conversion data by adding details such as campaign name, publisher, date, goals, sales value, Txn ID, etc.

How to bulk upload conversion data?

Cancel Upload

There is an option for cancelling the CSV file while uploading it; it allows you to stop uploading the file on your panel in between.

For example, if you are uploading a CSV file with 500 conversions and you cancel the upload in between, it will cancel the conversion upload in between.

The data that is already uploaded will not be deleted. For example, if 500 conversions are getting uploaded and you cancel them in between at 240, then 240 conversions will be uploaded successfully, and the rest of the conversion data will not be uploaded.

How to bulk upload conversion data?

The data of cancelled and processed files will show only if the upload is cancelled when it is in a progress state, not pending (please refer to the screenshot below).

How to bulk upload conversion data?


Note :

You can delete manually uploaded data within 90 days of upload. If you want to delete the data after 90 days, please contact the Trackier Support team.

How to bulk upload conversion data?


We're thrilled to have put together a top-notch team of qualified experts who are available to handle any of your concerns and respond to any inquiries you may have. You can contact us at any time by sending an email to support Team or using the in-platform chat feature.

Did this answer your question?