Tradedoubler

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

Introduction

The tradedoubler module allows you to automatically collect your tradedoubler data.

An example of operation

1. We configure the module in the platform by granting access to the Tradedoubler account.
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

Two tables appear in your dataset:

1. td_advertiser_statistics

Expand for the data schema

Field name	Type	Mode
date	TIMESTAMP	NULLABLE
impressions	INTEGER	NULLABLE
impressionsCommission	RECORD	NULLABLE
impressionsCommission.publisherCommission	FLOAT	NULLABLE
impressionsCommission.tdCommission	FLOAT	NULLABLE
clicks	INTEGER	NULLABLE
clicksCommission	RECORD	NULLABLE
clicksCommission.publisherCommission	FLOAT	NULLABLE
clicksCommission.tdCommission	FLOAT	NULLABLE
uniqueVisitors	INTEGER	NULLABLE
uvCommission	RECORD	NULLABLE
uvCommission.publisherCommission	FLOAT	NULLABLE
uvCommission.tdCommission	FLOAT	NULLABLE
leads	INTEGER	NULLABLE
leadsCommission	RECORD	NULLABLE
leadsCommission.publisherCommission	FLOAT	NULLABLE
leadsCommission.tdCommission	FLOAT	NULLABLE
ileads	INTEGER	NULLABLE
ileadsCommission	RECORD	NULLABLE
ileadsCommission.publisherCommission	FLOAT	NULLABLE
ileadsCommission.tdCommission	FLOAT	NULLABLE
sales	INTEGER	NULLABLE
salesCommission	RECORD	NULLABLE
salesCommission.publisherCommission	FLOAT	NULLABLE
salesCommission.tdCommission	FLOAT	NULLABLE
isales	INTEGER	NULLABLE
isalesCommission	RECORD	NULLABLE
isalesCommission.publisherCommission	FLOAT	NULLABLE
isalesCommission.tdCommission	FLOAT	NULLABLE
commission	RECORD	NULLABLE
commission.publisherCommission	FLOAT	NULLABLE
commission.tdCommission	FLOAT	NULLABLE
orderValue	FLOAT	NULLABLE
ctr	FLOAT	NULLABLE
cr	FLOAT	NULLABLE
lr	FLOAT	NULLABLE
epc	FLOAT	NULLABLE
adId	STRING	NULLABLE
adName	STRING	NULLABLE
adCategoryId	STRING	NULLABLE
adCategoryName	STRING	NULLABLE

1. td_advertiser_transactions

Expand for the data schema

Field name	Type	Mode	Policy tags	Description
transactionId	STRING	NULLABLE
programId	STRING	NULLABLE
programName	STRING	NULLABLE
sourceName	STRING	NULLABLE
sourceId	STRING	NULLABLE
adId	STRING	NULLABLE
eventId	STRING	NULLABLE
eventName	STRING	NULLABLE
eventTypeId	STRING	NULLABLE
status	STRING	NULLABLE
timeofLastClick	TIMESTAMP	NULLABLE
timeofCreate	TIMESTAMP	NULLABLE
timeofTransaction	TIMESTAMP	NULLABLE
timeofLastModified	TIMESTAMP	NULLABLE
leadNumber	STRING	NULLABLE
orderNumber	STRING	NULLABLE
orderValue	FLOAT	NULLABLE
commission	FLOAT	NULLABLE
tdCommission	FLOAT	NULLABLE
paid	BOOLEAN	NULLABLE
productInfo	RECORD	REPEATED
productInfo.productID	STRING	NULLABLE
productInfo.productName	STRING	NULLABLE
productInfo.quantity	INTEGER	NULLABLE
productInfo.productValue	FLOAT	NULLABLE
productInfo.productGroup	INTEGER	NULLABLE
voucherCode	STRING	NULLABLE
productsApi	RECORD	NULLABLE
productsApi.productId	STRING	NULLABLE
productsApi.productName	STRING	NULLABLE
crossDevice	STRING	NULLABLE
pendingRule	STRING	NULLABLE
deviceObject	RECORD	NULLABLE
deviceObject.deviceType	STRING	NULLABLE
deviceObject.operatingSystem	STRING	NULLABLE
deviceObject.browser	STRING	NULLABLE
modified	BOOLEAN	NULLABLE

Configuration

Before you start

To use our module you will need to create a client in Tradedoubler which provides a ClientId and ClientSecret. You can create your client using this tool at the following URL

Link (opens new window)

Start creating the module

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

Select Tradedoubler from the list of available modules.

Initial settings

In the first step, we have two fields to set.

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

Report currency code - currency in which you want to download reports.

Authorization with Tradedoubler

In the next step, we need to grant WitCloud access to Tradedoubler. It is necessary for WitCloud to be able to download data.

To do this, press the Click here to authorize button.

And fill out the Tradedobuler authorize form.

After proper authorization fill Tradedoubler form.

1. Select your account from the list.
2. Select your Tradedoubler program.
3. Click '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.