# Tradedoubler
# Introduction
The tradedoubler module allows you to automatically collect your tradedoubler data.
# An example of operation
- We configure the module in the platform by granting access to the Tradedoubler account.
- We set the module on the schedule - the data will be collected and stored in witcloud dataset.
- After the table is processed, you can use other reporting modules or combine it with analytics.
# Data schema
Two tables appear in your dataset:
- 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 |
- 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
# 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.
- Select your account from the list.
- Select your Tradedoubler program.
- Click 'Finish' button.
# 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).