In Trackier, you can upload new campaigns data and bulk edit the existing campaigns. Also, this helps you to migrate from any of your existing platform to Trackier very easily and efficiently. 


We have divided this in 3 use cases, you can check which suits best according to your requirement.

  • Edit the existing campaign.
  • Adding new campaign.
  • Migrating campaign data from a different platform.


Note


Please remove the unwanted column while uploading it.


Step 1

Get ready with the correct CSV




Note

Fields are Required in CSV.

  Not Required, remove the column from CSV.

* default -  represent value system will consider If you don't upload CSV with that field.

Please remove the unwanted column while uploading it.



CSV Columns Required In different Cases


Column NameEdit Existing CampaignAdding New CampaignMigrating Campaign ( only for New User)

Campaign_ID

 

The system will automatically assign IDs in continuation.If you want to keep the same id as earlier Platform then you can add those camp id.

Advertiser_ID

Status

If Required *( default - Active ) *( default - Active )
VisibilityIf Required *( default - Private)
*( default - Private)
TitleIf Required
Tracking URLIf Required
Preview URLIf RequiredIf RequiredIf Required
Geo_CoverageIf Required *( default - ALL) *( default - ALL)
CurrencyIf Required *( default - Panel currency) *( default - Panel currency)
PayoutIf RequiredIf Required (If not uploaded then it will be added as 0.)If Required  (If not uploaded then it will be added as 0.)
RevenueIf RequiredIf Required (If not uploaded then it will be added as 0.)If Required (If not uploaded then it will be added as 0.)
ObjectiveIf Required
DescriptionIf RequiredIf RequiredIf Required
External Offer IDIf RequiredIf RequiredIf Required



Tip

  • Editing: In this, any column you add in CSV along with campaign ID, those campaign will be edited or updated.
  • Adding New Campaign: In this, there is no need to add campaign id as the system will assign them ID automatically in sequence.
  • Migration: You can add 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).


Value Supported


Column NameValue Supported

Status

approved | pending | paused | deleted

Visibility

private | permission | public

Objective

CPA | CPI | CPS | CPL | CPC
Geo
  • Country ISO Code (ex: US, DE) for reference click here.
  • Use ALL if no specific Geo mentioned,
  • Use comma separated for multiple Geo's. (US,DE,MX)
CurrencyUse 3 letter Currency Code (ex: USD, INR, BRL, AED) for references click here.


Note

  • 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 column from CSV, so that there is no chance of error.



Step 2

Go To the CSV upload option in the panel.


Once you are ready with CSV, then go to Automation > Data Import > Campaign CSV.



Step 3

Map the CSV column with drop down value


Click upload CSV and you find the option to map column name, make sure it matches and click on Upload.



Step 4

Wait for CSV to get uploaded


  • Once uploaded, it takes 1 min to 4 hours for the data to get processed depends on CSV size. 
  • Once processed, the data will be reflected in 5 minutes.
  • CSV upload system support 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.