In Trackier, you can upload new Payout data and bulk edit the existing Payouts as per your requirement. Proceeding ahead with the below article, we will explore detailed insights regarding the payout CSV bulk update.

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


Note


Get ready with the correct CSV




CSV Columns Required In different Cases


Column NameAdding New PayoutEdit Existing Payout

Campaign_ID


Publisher_ID

goal_valueIf Required  (* default - attributed to default goal)
If Required
Currency
If Required
Payout
Revenue
GeoIf Required
RegionIf Required



Values Supported


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)
goal_valueUse 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 geo and goal_value.
  • 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.



Go To the CSV upload option in the panel.


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




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.





Waiting for CSV to get uploaded


  • Once uploaded, it takes 1 min to 4 hours for the data to get processed depending on CSV size. 
  • If you upload stats for today, it will be processed the next day in the report section.
  • CSV upload system support up to 50,000 rows, if there are more than 50,000 rows we recommend splitting the file in two different parts and uploading them.
  • Keep a check on the log to review the status for completion or error.


You can now delete the manually uploaded data as well. You will have a window of "90 days" to delete the manuallu uploaded files post which you won't be able to do it yourself.


If you need any further assistance , feel free to reach out to us at support@trackier.com