Integration of Convertiser with BigQuery

Connect Convertiser to Google BigQuery in WitCloud and collect your affiliate conversions and CPC report data to analyze the performance of your affiliate marketing.

Updated

Introduction

This module integrates with the Convertiser API, enabling you to collect your affiliate conversions and CPC report data and store them in Google Cloud BigQuery. Analyze them next to the rest of your data in WitCloud and optimize the performance of your affiliate marketing.

Configuration guide

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

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

Module setup

Go to Integrations in the menu > click Add integration.

Integrations list with the Add integration button

Select Convertiser from the list of available integrations.

Integration catalog with Convertiser selected

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

Collect name field filled in with the example name Convertiser PL

Authorization

If you have previously authorized the Convertiser module and do not require additional permissions, you can skip this step and select the existing authorization from the Select Convertiser authorization list.

Navigate to the API Credentials page by this link and click the Add token button.

Convertiser API tokens page with the Add token button

Select both accesses and click the Save button.

New token form with both accesses selected and the Save button

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

Generated API token in the Convertiser token list

Come back to WitCloud and click Authorize.

Authorize button next to the Select Convertiser authorization field

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

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

In the Select currency field, choose the currency in which you want your data to be retrieved.

Currency drop-down open with currency codes

Optionally, click Show advanced settings. The Tables to collect field lets you narrow down the tables you want to collect; all tables are selected by default and at least one is required.

Advanced settings open with the Tables to collect field

Click Next.

Historical data and scheduling

In the Historical Data field, 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 Convertiser data will now be synchronized with BigQuery.

Data schema

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

Data schema for convertiser_conversions
Field NameModeType
idNULLABLESTRING
ipNULLABLESTRING
tracking_idNULLABLESTRING
offerNULLABLESTRING
offer_detailsNULLABLERECORD
├─ offer_details.idNULLABLESTRING
├─ offer_details.titleNULLABLESTRING
├─ offer_details.statusNULLABLESTRING
├─ offer_details.status_nameNULLABLESTRING
├─ offer_details.urlNULLABLESTRING
goalNULLABLESTRING
goal_detailsNULLABLERECORD
├─ goal_details.idNULLABLESTRING
├─ goal_details.titleNULLABLESTRING
├─ goal_details.statusNULLABLESTRING
├─ goal_details.status_nameNULLABLESTRING
├─ goal_details.multiple_conversionsNULLABLEBOOLEAN
├─ goal_details.auto_approve_conversionsNULLABLEBOOLEAN
├─ goal_details.conversion_hold_periodNULLABLEINTEGER
├─ goal_details.disable_automatic_approvalNULLABLEBOOLEAN
├─ goal_details.payout_typeNULLABLESTRING
├─ goal_details.payoutNULLABLESTRING
├─ goal_details.revenueNULLABLESTRING
├─ goal_details.tracking_codeNULLABLESTRING
├─ goal_details.is_flexible_commissionsNULLABLEBOOLEAN
├─ goal_details.flexible_commissions_modelNULLABLESTRING
├─ goal_details.urlNULLABLESTRING
currencyNULLABLESTRING
currency_detailsNULLABLERECORD
├─ currency_details.currencyNULLABLESTRING
├─ currency_details.currency_nameNULLABLESTRING
├─ currency_details.is_defaultNULLABLEBOOLEAN
websiteNULLABLESTRING
website_detailsNULLABLERECORD
├─ website_details.idNULLABLESTRING
├─ website_details.urlNULLABLESTRING
├─ website_details.descriptionNULLABLESTRING
├─ website_details.categoriesREPEATEDINTEGER
├─ website_details.categories_detailsREPEATEDRECORD
│ ├─ website_details.categories_details.idNULLABLEINTEGER
│ ├─ website_details.categories_details.categoryNULLABLESTRING
│ ├─ website_details.categories_details.category_nameNULLABLESTRING
├─ website_details.target_audienceNULLABLESTRING
├─ website_details.target_audience_nameNULLABLESTRING
├─ website_details.statusNULLABLESTRING
├─ website_details.status_nameNULLABLESTRING
├─ website_details.created_atNULLABLETIMESTAMP
├─ website_details.traffic_typeNULLABLESTRING
├─ website_details.traffic_type_detailsNULLABLERECORD
│ ├─ website_details.traffic_type_details.nameNULLABLESTRING
│ ├─ website_details.traffic_type_details.name_displayNULLABLESTRING
├─ website_details.child_traffic_typeNULLABLESTRING
├─ website_details.child_traffic_type_detailsNULLABLERECORD
│ ├─ website_details.child_traffic_type_details.nameNULLABLESTRING
│ ├─ website_details.child_traffic_type_details.name_displayNULLABLESTRING
is_refundedNULLABLEBOOLEAN
is_paidNULLABLEBOOLEAN
is_unmanagedNULLABLEBOOLEAN
statusNULLABLESTRING
status_nameNULLABLESTRING
status_messageNULLABLESTRING
sourceNULLABLESTRING
source_nameNULLABLESTRING
sale_amountNULLABLESTRING
base_sale_amountNULLABLESTRING
advertiser_expenseNULLABLESTRING
base_advertiser_expenseNULLABLESTRING
publisher_incomeNULLABLEFLOAT
base_publisher_incomeNULLABLEFLOAT
network_incomeNULLABLEFLOAT
base_network_incomeNULLABLEFLOAT
hold_untilNULLABLETIMESTAMP
created_atNULLABLETIMESTAMP
processed_atNULLABLETIMESTAMP
_versionNULLABLEINTEGER
Data schema for convertiser_cpc
Field NameModeType
dateNULLABLEDATE
offer_idNULLABLESTRING
cpc_clicksNULLABLEINTEGER
cpc_advertiser_expenseNULLABLEFLOAT
pe_transactionsNULLABLEINTEGER
pe_amountNULLABLEFLOAT
pe_mean_amountNULLABLEFLOAT
pe_conversion_rateNULLABLEFLOAT
pe_cosNULLABLEFLOAT
pe_roasNULLABLEFLOAT
offer_titleNULLABLESTRING
currencyNULLABLESTRING