Overview
A bulk upload of new orders allows uploading of orders into the basic commissioning system. Orders that are bulk uploaded should never have been uploaded via a pixel (they are mutually exclusive).
We recommend pixel over bulk upload whenever possible, but know that may not be appropriate for everyone. Feel free to implement the method that you feel is appropriate for your needs and conditions. The basic commissioning system will process your rules in the exact same way.
No Personally Identifiable Information (PII) may be passed through the batch file. PII includes but is not limited to information which can be used to distinguish or trace an individual's identity, such as their name, social security number, email address, phone number, or physical address.
NOTE: For mobile device report filtering to work, the click ID must be captured and supplied.
Bulk Upload: Basic New Transactions Orders Explained
| Field | Description | Data Type / Length | Example | Required |
|---|---|---|---|---|
| PID | Unique ID assigned by Ascend to each program. NOTE: If you are unsure what this value is, please contact customer support. |
Integer | 893 | YES |
| AFFILIATEID | Unique ID assigned by Ascend to each publisher. This value is passed to advertiser's website as a URL parameter named "subid". | Integer | 43545 | YES |
| AMOUNT | This value is the original transaction's amount and will be used to calculate the publisher's earned commission. This value is only required if the transaction is a "SALE" based offer. If this is a "LEAD" based offer, please use "0.00" as a place holder. NOTE: Do not include dollar signs ($) or commas (,) in this field. |
Decimal | 23.34 | YES |
| OID | A unique ID (Order ID), supplied by the advertiser, which identifies the transaction. Allowed Characters: Alpha-Numerics (A-Za-z0-9), dashes(-), underscores(_) |
Character (50) | FT-13543422 | YES |
| DATETIME | The date and time when the transaction happened. NOTE: All times must be sent and will be reported in Eastern Time. Times are representative of Daylight Savings Time. |
YYYY-MM-DD HH:MM:SS | 2000-01-01 23:59:59 | YES |
| TYPE | Please use one of the following values: 1 - Sale Based Transactions (percentage of sale) 2 - Lead Based Transactions (Flat dollar payout) |
Integer | 1 | YES |
| CLICKID | Unique ID assigned by Ascend to each click record generated from a creative. This value is passed to the advertiser's website as the placeholder clid in the creative destination URL. This will need to be captured and stored so it can later be passed back in your bulk upload. Usage: The most recent click ID associated with the transaction's customer. Additional Info: See Basic Tracking - Click ID Capture and Storage for more information. |
Integer | 7823432 | YES |
| GOOGLECLICKID | Case-sensitive unique ID assigned by Google Ads each time a search ad is shown. This value is passed to the advertiser's website upon click as the placeholder gclid. This can be captured and stored so it can later be passed back in your bulk upload, where we will associate them with Ascend Network's Click IDs. Usage: The most recent Google click ID associated with the transaction's customer. |
Character (100) | TeSter-123 | NO |
| PROMOCODE | A single or pipe-separated list of promotional codes tied to a personalized coupon. It is used to ensure credit is given to the owner of the personalized creative, rather than someone who may have used it without permission. If a list is provided, the first valid code will be used. If a valid code is not provided, the sale will be attributed as normal. This is an optional parameter and the feature requires additional setup by your account manager. | Integer | MYPROMOCODE | NO |
Rules
- The upload file must be in CSV (comma separated value) format.
- The first line of the file must be the header, with the required fields above. The fields are case sensitive and the order of the fields does not matter.
- No Personally Identifiable Information (PII) should be uploaded. PII includes but is not limited to information which can be used to distinguish or trace an individual's identity, such as their name, social security number, email address, phone number, or physical address.