Transaction Queries

From Wiki

Jump to: navigation, search

Deutsch . Español . Français . Italiano . Nederlands . Polski . Português (Brasil) . Svenska .



A transaction query is a transaction manually added to the system by a publisher. The circumstances for this to occur would be when the publisher considers they may have an untracked sale, an incorrect commission or when they would like to dispute a declined transaction. Further examples:

  • Untracked

This can happen for a number of reasons; tracking may be down on your confirmation page or a user may block 3rd party cookies.

  • Incorrect

A publisher wishes to dispute the commission amount of a transaction.

  • Declined

A publisher would like a transaction re-validated as they believe it to be a valid transaction.

This guide provides details on how to validate transaction queries.

How it works

You will need to have the Transaction Queries functionality switched on by Awin in order to be able to use it.

Transaction queries added to the system will go into a separate validation screen, which will require you to validate the transaction as approved or declined.

You have 75 days in which to review any queried transaction. (Note: Declined transactions will not affect your AWIN Index).

  • Queried transactions left longer than 75 days will be automatically approved.

How to access Transaction Queries

You can view your transaction queries by:

  • 1. Selecting the option from the ‘To do’ list on the right side of the screen

If you have any outstanding transaction queries then you will see an item in your to-do list e.g. “You have 4 transaction queries waiting to be processed”. Clicking this link will take you to a validation area; similar to the validate pending sales area but with some notable differences.

  • 2. Accessing Validation -> ‘Validate Transaction Queries’ on the grey menu navigation bar near the top of the page


The two key differences to remember about the pending/validation screen are:

  • You can edit the transaction and commission amounts as well as alter the order reference.
  • You can search transactions by publisher ID or order reference using the input fields in the top left corner.

  • When you decline a transaction it will NOT affect your AWIN index. Please use the most appropriate decline reason from the drop down menu.

Batch Process Transaction Queries

You can process multiple transaction queries at once by uploading a file in CSV format. Transactions should be contained in a text file with each transaction on a new line.

Data File Specification

Field Name Type Description Example
ID Integer. Max 10 char. Uniquely identifies the transaction in awin system 09876543
Publisher ID Integer. Max 10 char. Uniquely identifies the publisher in awin system 45628
Publisher Name Text. Max 215 char Name of the publisher (optional) Example Affiliate
Enquiry Type Integer. Max 10 char Type of enquiry (optional) untracked
Sale Amount decimal (7,2) Sale value without currency symbol. You can change this value 10.21
Commission Amount decimal (7,2) Commission value without currency symbol. You can change this value 5.65
Sale Date Date
(yyyy-mm-dd HH:ii:ss)
Datetime of the conversion 2007-02-02 22:30:12
Order Reference Text. Max 50 char Order Reference that will be used in awin report. This could also contain extra information the publisher has chosen to add to identify the sale LX10501,
Description Text. Max 215 char Further information from the publisher to help process the query (optional) Commission received was 4.54GBP when it should have been 5.54GBP
Auto Validation n/a Auto-validation status (optional) n/a
Status text Will set the transaction status: "accepted" or "declined" accepted
Decline reason text Will set the decline reason for the transaction Invalid claim - Transaction has already been tracked
Duplicate yes/no Will set if the query was duplicate or not (optional) Yes
Enquiry ID Integer. Max: 10 char Unique enquiry ID set by the publisher (optional) 2017100401
Upload Date Date
(yyyy-mm-dd HH:ii:ss)
Datetime of the csv upload (optional) 2007-02-02 22:30:12


Due to new European legislation regarding how websites store information about you, AWIN is updating its privacy policy. You can see the new version of our policy here. If you would like to see the information we capture on this website, please click here for further details. In order to accept cookies on this site please click the 'I ACCEPT' button