Overview
In Trackier, you can upload new campaign data and bulk edit the existing campaigns. Also, this helps you migrate from any of your existing platforms to Trackier very easily and efficiently.
We have divided this into 3 use cases; you can check which suits you best according to your requirements.
Edit the existing campaign.
Adding new campaign.
Migrating campaign data from a different platform.
Note
Please remove the unwanted columns while uploading it.
This table shows which fields are mandatory (✅) and which are optional (❌).
CSV Columns Required in Different Cases
Column Name | Edit Existing Campaign | Adding New Campaign | Migrating Campaign ( only for New User) |
Campaign_ID | |  The system will automatically assign IDs in continuation. | If you want to keep the same id as the earlier Platform then you can add those camp IDs. |
Advertiser_ID |  |  |  |
Status | If Required |  *(default - Active) |  *(default - Active) |
Visibility | If Required |  *(default -Private) |  *(default - Private) |
Title | If Required |  |  |
Tracking URL | If Required |  |  |
Preview URL | If Required | If Required | If Required |
Geo_Coverage | If Required |  *(default - ALL) |  *(default - ALL) |
Currency | If Required |  *(default - Panel currency) |  *(default - Panel currency) |
Payout | If Required | If Required (If not uploaded then it will be added as 0.) | If Required (If not uploaded then it will be added as 0.) |
Revenue | If Required | If Required (If not uploaded then it will be added as 0.) | If Required (If not uploaded then it will be added as 0.) |
Objective | If Required |  |  |
Description | If Required | If Required | If Required |
External Offer ID | If Required | If Required | If Required |
Redirect type | If Required | If Required | If Required |
Track Multiple conversion | If Required | If Required | If Required |
Tips:
Editing: In this, any column you add in CSV along with the campaign ID, and that campaign will be edited or updated.
Adding New Campaign: In this, there is no need to add a campaign ID, as the system will assign them ID automatically in sequence.
Migration: You can add a campaign ID, and it will stay as it is so that you can upload conversion data as well; by keeping the same campaign ID, publisher ID and advertiser ID, you can upload conversion data easily.
This is only possible in the fresh account or new users
Values Supported in the CSV
Column Name | Value Supported |
Status | approved | pending | paused | deleted |
Visibility | private | permission | public |
Objective | CPA | CPI | CPS | CPL | CPC |
Geo |
|
Currency | Use 3 letter Currency Code (ex: USD, INR, BRL, AED) for references click here. |
Redirect type |
|
Track Multiple conversion |
|
Important Guidelines:
Please make sure you are using the correct spelling of values that are supported for status, visibility, objective, geo and currency.
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.
If revenue and payout values are in percentages, please ensure to enter them as decimals or absolute values in the CSV file.
For example, if the revenue is 100%, enter it as 1, and if the payout is 50%, enter it as 0.5.
Please do not enter the values in percentages.
Uploading CSV
Go to the CSV upload option in the panel.
Once you are ready with CSV, then go to the Automation section and click on Data Import. Here, select the option to upload the campaign CSV.
Map the CSV column with a drop-down value.
Click 'Upload CSV', and you will find the option to map the column name; make sure it matches and click on 'Upload'.
Once uploaded, it takes 1 minute to 4 hours for the data to get processed depending on CSV size.
Once processed, the data will be reflected in 5 minutes.
The CSV upload system supports up to 50 thousand rows; if there are more than 50,000 rows, we recommend that the file be split in two parts and uploaded separately.
Keep a check on the log to review the status for completion or error.
Note:
You can also delete the manually uploaded data. You will have a window of "90 days" to delete the manually uploaded files post which you won't be able to do it yourself.
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.
Note:
In the above scenario, the data that are already uploaded will not be deleted; for example, if 500 conversions are getting uploaded and you cancel it in between 240, then 240 conversions will be uploaded successfully and the next conversion data will be cancelled.
The data of cancelled and processed files will show only if the upload is cancelled when it is in a processing state, not pending (Please refer to the screenshot below).
Broaden your knowledge:
Need Instant Resolution?
We want to assure our customers that Trackier provides an in-house customer support team, available for instant query resolutions. You can reach out to us via email at support@trackier.com or directly engage with our in-house agents through our live chat feature.
