In Trackier, you can upload new conversion data and bulk edit the existing conversions as per your requirement. Also, this helps you to migrate from any of your existing platform to Trackier very easily and efficiently.
We have divided this into 3 use cases, you can check which suits you best according to your requirement.
- Edit the existing conversion
- Adding new conversion
- Migrating conversion data from different platforms.
TABLE OF CONTENTS
|
Get ready with the correct CSV
** Only those postbacks can be fired to Publisher from System which is not fired previously. Please remove the unwanted column while uploading it. |
Fields are Required in CSV.
Not Required, remove the column from CSV.CSV Columns Required In different Cases
| Column Name | Edit Existing Conversions | Adding New Conversion | Migrating Conversions ( only for New User) |
|---|---|---|---|
( 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 click id then you can use that click id. |  |
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 sale/reg 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-campaign/ publisher-specific payout will be considered) | If Required (If not uploaded then-campaign/ publisher-specific payout will be considered) |
| Revenue | If Required | If Required (If not uploaded then-campaign/ publisher-specific payout will be considered) | If Required (If not uploaded then-campaign/ 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 is) | If Required | If Required | If Required |
| p1 (publisher click id) | If Required ( if you are planning to fire postback system should have publisher click id or you need to upload it. ) | If Required ( if you are planning to fire postback system should have publisher click id or you need to upload it. ) | If Required ( if you are planning to fire postback 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 |
|
Values Supported
| Column Name | Value Supported |
|---|---|
| approved | pending | rejected | cancelled | |
Created_Date | Date format must be (YYYY-MM-DD) |
| Geo |
|
| p2-p10 | Open the Publisher parameter to store any value required passed in the tracking link. |
| goal_value | Use the same goal value as created in the campaign. |
|
Go To the CSV upload option in the panel.
- Once you are ready with CSV, then go to Automation > Data Import > Advertiser 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.
If you wish to fire publisher postbacks for the uploaded conversions, make sure to tick the 'Send Postback for Approved conversions' checkbox.
- 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 supports 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 delete the manually uploaded data. 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.
- You can also create new conversions by manually uploading the transaction ID's in the panel for any specific campaign and specific publisher.
Manually Upload Data
- You can manually upload the conversion data by adding details such as campaign name, publisher name, date, goals, sales value, Txn Id etc.
