Integration of Awin with BigQuery

Learn how to connect Awin to Google BigQuery using WitCloud. Automatically fetch campaign, transaction, and commission data, analyze it in real-time, and optimize your affiliate marketing efforts.

Updated

Introduction

This integration connects Awin to Google Cloud BigQuery. It collects your Awin transactions with their commission data, so you can analyze the results of your affiliate marketing next to the rest of your data in WitCloud.

Configuration guide

Follow the steps below to connect Awin with BigQuery. Once the setup is complete, your Awin data will be transferred to your BigQuery project.

Make sure you have admin access to your Awin account before starting the configuration.

Module setup

Go to Integrations in the menu and click Add integration.

Integrations list with the Add integration button

Select Awin from the list of available integrations.

Integration catalog with Awin selected

Enter the Collect name, e.g., "Awin PL".

Collect name field filled in with the example name Awin PL

Authorization

If you have previously authorized the Awin module and do not require additional permissions, you can skip this step and pick the existing authorization from the Select Awin authorization drop-down.

To connect to Awin you need to generate a token. Navigate to the API Credentials page by this link.

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.

Come back to WitCloud and click Authorize.

Authorize button next to the authorization token field

Paste the API token into the Access token field of the Authorize form and click Create.

Authorize pop-up with the Access token field filled with a placeholder value

Select the appropriate account from the Select account drop-down list.

Account drop-down open with two example Awin accounts

Select your country code in the Region field.

Region drop-down open with country codes

Optionally, click Show advanced settings. Tables to collect lets you filter the tables you want to collect; by default all of them are selected, and at least one table is required.

Advanced settings open with the Tables to collect field

Click Next.

Historical data and scheduling

In Historical Data, enter the number of days for which you want to fetch historical data. You can enter up to 365 days.

Historical Data field filled in with 365 days

A data synchronization schedule will be created automatically. More information on this topic can be found here.

Click Create to complete the configuration.

Data collection settings with the Create button

Done! Your Awin data will now be synchronized with BigQuery.

Data schema

Expand the tables below to view the full data schema collected from Awin.

Data schema for awin_transactions
Field NameModeType
idNULLABLEINTEGER
urlNULLABLESTRING
advertiserIdNULLABLEINTEGER
publisherIdNULLABLEINTEGER
commissionSharingPublisherIdNULLABLESTRING
commissionSharingSelectedRatePublisherIdNULLABLESTRING
campaignNULLABLESTRING
siteNameNULLABLESTRING
commissionStatusNULLABLESTRING
commissionAmountNULLABLERECORD
├─ commissionAmount.amountNULLABLEFLOAT
├─ commissionAmount.currencyNULLABLESTRING
saleAmountNULLABLERECORD
├─ saleAmount.amountNULLABLEFLOAT
├─ saleAmount.currencyNULLABLESTRING
ipHashNULLABLESTRING
customerCountryNULLABLESTRING
clickRefsNULLABLERECORD
├─ clickRefs.clickRefNULLABLESTRING
clickDateNULLABLETIMESTAMP
transactionDateNULLABLETIMESTAMP
validationDateNULLABLESTRING
typeNULLABLESTRING
declineReasonNULLABLESTRING
voucherCodeUsedNULLABLEBOOLEAN
voucherCodeNULLABLESTRING
lapseTimeNULLABLEINTEGER
amendedNULLABLEBOOLEAN
amendReasonNULLABLESTRING
oldSaleAmountNULLABLESTRING
oldCommissionAmountNULLABLESTRING
clickDeviceNULLABLESTRING
transactionDeviceNULLABLESTRING
publisherUrlNULLABLESTRING
advertiserCountryNULLABLESTRING
orderRefNULLABLESTRING
transactionPartsREPEATEDRECORD
├─ transactionParts.commissionGroupIdNULLABLEINTEGER
├─ transactionParts.amountNULLABLEFLOAT
├─ transactionParts.commissionAmountNULLABLEFLOAT
├─ transactionParts.advertiserCostNULLABLESTRING
├─ transactionParts.commissionGroupCodeNULLABLESTRING
├─ transactionParts.commissionGroupNameNULLABLESTRING
├─ transactionParts.trackedPartsREPEATEDRECORD
│ ├─ transactionParts.trackedParts.codeNULLABLESTRING
│ ├─ transactionParts.trackedParts.amountNULLABLEFLOAT
│ ├─ transactionParts.trackedParts.currencyNULLABLESTRING
paidToPublisherNULLABLEBOOLEAN
paymentIdNULLABLEINTEGER
transactionQueryIdNULLABLEINTEGER
originalSaleAmountNULLABLESTRING
advertiserCostNULLABLERECORD
├─ advertiserCost.amountNULLABLESTRING
├─ advertiserCost.currencyNULLABLESTRING
basketProductsNULLABLESTRING