1. Knowledge Base
  2. Solution home
  3. Trackier Performance
  4. Data Import

How to upload bulk campaigns?

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



TABLE OF CONTENTS


We have divided this into 3 use cases, you can check which suits you 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.


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 the earlier Platform then you can add those camp IDs.

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 the campaign ID, 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).


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



  • Go To the CSV upload option in the panel.
  • Once you are ready with CSV, then go to Automation > Data Import > Campaign CSV.



  • Map the CSV column with drop down value
  • Click upload CSV and you find the option to map the column name, make sure it matches and click on Upload.



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


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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article