# Tradedoubler

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

image alt text

Select "Tradedoubler" from the list of available modules

image alt text

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

image alt text

# 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

image alt text

And fill out the Tradedobuler authorize form.

image alt text

After proper authorization fill Tradedoubler form.

  1. Select your account from the list.
  2. Select your Tradedoubler program.
  3. Click 'Finish' button.

image alt text

# Setting the module in the schedule

Your Tradedoubler 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: 2/3/2021, 10:28:38 AM