# Awin

# 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:

image alt text

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.

image alt text

Select "Awin" from the list of available modules

image alt text

# 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.

image alt text

# 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

image alt text

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

image alt text

To do this, press the Click here to authorize button

image alt text

Paste the token and click on Finish button.

image alt text

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.

image alt text

# Setting the module in the schedule

Your Awin module is already created in WitCloud 📊. The last step is to establish a schedule and include our module in it. You can read about how to do it here link (opens new window)

Last updated: 4/29/2021, 9:47:17 AM