Awin

• Introduction
  • An example of operation
  • Data schema
• Configuration
  • Start creating the module
  • Initial settings
  • Authorization with Awin
  • Setting the module in the schedule

Introduction

The Awin module enables automatic collection of data from your advertising system.

An example of operation

1. We configure the module in the platform by granting access to the Awin
2. We set the module on the schedule - the data will be collected and stored in witcloud dataset
3. After the table is processed, you can use other reporting modules or combine it with analytics

Data schema

After starting the module, new table will appear in the WitCloud dataset:

awin_transactions

Expand for the data schema

Field name	Type	Mode
id	INTEGER	NULLABLE
url	STRING	NULLABLE
advertiserId	INTEGER	NULLABLE
publisherId	INTEGER	NULLABLE
commissionSharingPublisherId	STRING	NULLABLE
commissionSharingSelectedRatePublisherId	STRING	NULLABLE
campaign	STRING	NULLABLE
siteName	STRING	NULLABLE
commissionStatus	STRING	NULLABLE
commissionAmount	RECORD	NULLABLE
commissionAmount. amount	FLOAT	NULLABLE
commissionAmount. currency	STRING	NULLABLE
saleAmount	RECORD	NULLABLE
saleAmount. amount	FLOAT	NULLABLE
saleAmount. currency	STRING	NULLABLE
ipHash	STRING	NULLABLE
customerCountry	STRING	NULLABLE
clickRefs	RECORD	NULLABLE
clickRefs. clickRef	STRING	NULLABLE
clickDate	TIMESTAMP	NULLABLE
transactionDate	TIMESTAMP	NULLABLE
validationDate	STRING	NULLABLE
type	STRING	NULLABLE
declineReason	STRING	NULLABLE
voucherCodeUsed	BOOLEAN	NULLABLE
voucherCode	STRING	NULLABLE
lapseTime	INTEGER	NULLABLE
amended	BOOLEAN	NULLABLE
amendReason	STRING	NULLABLE
oldSaleAmount	STRING	NULLABLE
oldCommissionAmount	STRING	NULLABLE
clickDevice	STRING	NULLABLE
transactionDevice	STRING	NULLABLE
publisherUrl	STRING	NULLABLE
advertiserCountry	STRING	NULLABLE
orderRef	STRING	NULLABLE
customParameters	STRING	NULLABLE
transactionParts	RECORD	REPEATED
transactionParts. commissionGroupId	INTEGER	NULLABLE
transactionParts. amount	FLOAT	NULLABLE
transactionParts. commissionAmount	FLOAT	NULLABLE
transactionParts. advertiserCost	STRING	NULLABLE
transactionParts. commissionGroupCode	STRING	NULLABLE
transactionParts. commissionGroupName	STRING	NULLABLE
transactionParts. trackedParts	RECORD	REPEATED
transactionParts.trackedParts. code	STRING	NULLABLE
transactionParts.trackedParts. amount	FLOAT	NULLABLE
transactionParts.trackedParts. currency	STRING	NULLABLE
paidToPublisher	BOOLEAN	NULLABLE
paymentId	INTEGER	NULLABLE
transactionQueryId	INTEGER	NULLABLE
originalSaleAmount	STRING	NULLABLE
advertiserCost	RECORD	NULLABLE
advertiserCost. amount	STRING	NULLABLE
advertiserCost. currency	STRING	NULLABLE
basketProducts	STRING	NULLABLE

Configuration

Start creating the module

From the menu on the left, select the Collect tab, then click the Add new data Collect button.

Select Awin from the list of available modules.

Initial settings

In the first step, we only have one field to fill.

Collect name - the name of our module. It will be visible under this name elsewhere on the platform.

Authorization with Awin

In the next step, we need to get the Awin API token. It is necessary for WitCloud to be able to collect data.

Navigate to API Credentials page by this link link (opens new window)

Fill in the password field and press the button Show my API tokens

Copy the API token. You will need it to complete the configuration of the module in WitCloud

To do this, press the Click here to authorize button

Paste the token and click on Finish button.

After proper authorization, complete the rest of the fields

Region - Select your country code

Account - Select your Awin account name

And click the Finish button.

Setting the module in the schedule

Your module is now created in WitCloud 📊. The final step is to determine the time range for which you need to retrieve historical data. The schedule for retrieving current data will be created automatically.

Enter the appropriate range and click the Finish button.