Advertiser Batch Validations

Batch Validation

The Batch Validation file will allow you to auto approve, decline and amend transactions (which then turn into approved transactions) within the DCMnetwork System.

To automate this you can provide us with a HTTP URL which we need to grab transactions from, or you can provide us with FTP/SFTP details (we'd be happy to set these up for you).

To setup the automation we can pick up the batch validation file which you create on a 24 hour basis (2AM GST) or weekly basis (this occurs every Tuesday 2AM GST).

Or alternatively you can setup a Google Analytics daily report to be sent to conversions-no-reply@dcmnetwork.com.

The advertiser batch validation is done for the conversions that are present on DCMnetwork but couldn’t be found on Google analytics. Advertisers are responsible to review the batch validation file and accept, reject or amend the conversions. To change the status and/or to add the status note, select an option from the drop-down menu on the relevant excel column

Exported file from DCMnetwork should have the following:

* mandatory variables

 

 Field Name

 Description 

 Accepted Values

 Example 

a.  offer_id*  ID of the offer in your network Numeric ID of the offer in your network  1000
b.  date_time* Date and time for the conversion YYYY-MM-DD HH:MM:SS  2020-01-31 23:59:59
c.  transaction_id*   ID of the user session in your network  Transaction ID that corresponds to an existing conversion in your network  102b3t4hj545lbgl4v9833
d.  sub_id_1* Advertisers order reference    6478356
e.  currency Three-letter ISO currency abbreviation  Three-letter currency code  USD**
f.  cost* USD amount of total commission for this sale. Without shipping or VAT. Monetary value with up to two decimal places. 100.00
g.  sale_amount* USD amount of total sale which is important when offer payout or offer revenue is percentage of sale amount (used to set payout and revenue for CPS/RPS offers) Without shipping or VAT. Monetary value with up to two decimal places.  100.00
h. currency_conversion_cost Preferred currency amount of total commission for this sale. Without shipping or VAT.    
i. currency_conversion_sale_amount
Preferred Currency amount of total sale which is important when offer payout or offer revenue is percentage of sale amount (used to set payout and revenue for CPS/RPS offers) Without shipping or VAT.
   
j.  status*  Approval status of the conversion “accepted”, “declined”, or “amended”  accepted
k.  goal_id ID of the goal in the offer that you want to credit the conversion for Numeric ID of the goal in your network  10
l.  status note A reason for Declines and Amendments Order returned, Room upgraded  Order returned
m.  new sale price New sale amount for an adjustment only New Monetary value with up to two decimal places.  28.00

*Sale accepted mandatory columns

**In case of currency being other than USD, the exported file will have two additional columns for cost and sale_amount represented in that currency.

 

Sale Accepted Rules

The following columns must be provided for any sale to accepted by our system.

  • Offer ID
  • Transaction Date
  • Transaction ID
  • Order Reference 
  • Commission (USD or preferred currency)
  • Sale Amount (USD or preferred currency)
  • Status

All other columns are optional, however must be separated by a comma.

 

Sale Declined Rules

The following columns must be provided for any sale to be declined by our system.

  • Order Reference
  • Transaction Date
  • Status
  • Status Note

 

Sale Amendment Rules

You may want to amend a transaction, if the user has returned part of the order, you can do this via the "amended" status. Please ensure the following points are included:

  • The file must contain a new value in 'New Sale Price' for the whole transaction
  • Status will move from pending to approved

 

Unmatched commissions
Any unmatched commissions will be reported back to you. These will need to be confirmed by hand.

 

Status Note Reasons can be any of the following: 

  1. Amended
  2. Breach of programme T&Cs
  3. Order deemed illegitimate
  4. Transaction already tracked in your account
  5. Transaction occurred too long ago
  6. Violation of retailer's PPC terms
  7. Commission given to another marketing source
  8. Commission given to another publisher
  9. Credit check unsuccessful
  10. Customer cancelled order
  11. Customer payment not successful
  12. Customer returned order
  13. Part return - manual commission added
  14. Claim could not be found using information provided
  15. Commission not paid on product(s) purchased
  16. Not met terms & conditions: existing customer
  17. Not met terms & conditions: minimum wager not met
  18. Not met terms & conditions: upgrade sale
  19. Order reference in incorrect format
  20. Retailer in administration
  21. Retailer' affiliate program closed
  22. Unable to fulfil order
  23. Retailer issue - Unauthorised voucher code used

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.