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.

Select Convertiser from the list of available integrations.

Enter the Collect name, e.g., "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.

Select both accesses and click the Save button.

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

Come back to WitCloud and click Authorize.

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

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

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.

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.

A data synchronization schedule will be created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

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 Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| ip | NULLABLE | STRING |
| tracking_id | NULLABLE | STRING |
| offer | NULLABLE | STRING |
| offer_details | NULLABLE | RECORD |
| ├─ offer_details.id | NULLABLE | STRING |
| ├─ offer_details.title | NULLABLE | STRING |
| ├─ offer_details.status | NULLABLE | STRING |
| ├─ offer_details.status_name | NULLABLE | STRING |
| ├─ offer_details.url | NULLABLE | STRING |
| goal | NULLABLE | STRING |
| goal_details | NULLABLE | RECORD |
| ├─ goal_details.id | NULLABLE | STRING |
| ├─ goal_details.title | NULLABLE | STRING |
| ├─ goal_details.status | NULLABLE | STRING |
| ├─ goal_details.status_name | NULLABLE | STRING |
| ├─ goal_details.multiple_conversions | NULLABLE | BOOLEAN |
| ├─ goal_details.auto_approve_conversions | NULLABLE | BOOLEAN |
| ├─ goal_details.conversion_hold_period | NULLABLE | INTEGER |
| ├─ goal_details.disable_automatic_approval | NULLABLE | BOOLEAN |
| ├─ goal_details.payout_type | NULLABLE | STRING |
| ├─ goal_details.payout | NULLABLE | STRING |
| ├─ goal_details.revenue | NULLABLE | STRING |
| ├─ goal_details.tracking_code | NULLABLE | STRING |
| ├─ goal_details.is_flexible_commissions | NULLABLE | BOOLEAN |
| ├─ goal_details.flexible_commissions_model | NULLABLE | STRING |
| ├─ goal_details.url | NULLABLE | STRING |
| currency | NULLABLE | STRING |
| currency_details | NULLABLE | RECORD |
| ├─ currency_details.currency | NULLABLE | STRING |
| ├─ currency_details.currency_name | NULLABLE | STRING |
| ├─ currency_details.is_default | NULLABLE | BOOLEAN |
| website | NULLABLE | STRING |
| website_details | NULLABLE | RECORD |
| ├─ website_details.id | NULLABLE | STRING |
| ├─ website_details.url | NULLABLE | STRING |
| ├─ website_details.description | NULLABLE | STRING |
| ├─ website_details.categories | REPEATED | INTEGER |
| ├─ website_details.categories_details | REPEATED | RECORD |
| │ ├─ website_details.categories_details.id | NULLABLE | INTEGER |
| │ ├─ website_details.categories_details.category | NULLABLE | STRING |
| │ ├─ website_details.categories_details.category_name | NULLABLE | STRING |
| ├─ website_details.target_audience | NULLABLE | STRING |
| ├─ website_details.target_audience_name | NULLABLE | STRING |
| ├─ website_details.status | NULLABLE | STRING |
| ├─ website_details.status_name | NULLABLE | STRING |
| ├─ website_details.created_at | NULLABLE | TIMESTAMP |
| ├─ website_details.traffic_type | NULLABLE | STRING |
| ├─ website_details.traffic_type_details | NULLABLE | RECORD |
| │ ├─ website_details.traffic_type_details.name | NULLABLE | STRING |
| │ ├─ website_details.traffic_type_details.name_display | NULLABLE | STRING |
| ├─ website_details.child_traffic_type | NULLABLE | STRING |
| ├─ website_details.child_traffic_type_details | NULLABLE | RECORD |
| │ ├─ website_details.child_traffic_type_details.name | NULLABLE | STRING |
| │ ├─ website_details.child_traffic_type_details.name_display | NULLABLE | STRING |
| is_refunded | NULLABLE | BOOLEAN |
| is_paid | NULLABLE | BOOLEAN |
| is_unmanaged | NULLABLE | BOOLEAN |
| status | NULLABLE | STRING |
| status_name | NULLABLE | STRING |
| status_message | NULLABLE | STRING |
| source | NULLABLE | STRING |
| source_name | NULLABLE | STRING |
| sale_amount | NULLABLE | STRING |
| base_sale_amount | NULLABLE | STRING |
| advertiser_expense | NULLABLE | STRING |
| base_advertiser_expense | NULLABLE | STRING |
| publisher_income | NULLABLE | FLOAT |
| base_publisher_income | NULLABLE | FLOAT |
| network_income | NULLABLE | FLOAT |
| base_network_income | NULLABLE | FLOAT |
| hold_until | NULLABLE | TIMESTAMP |
| created_at | NULLABLE | TIMESTAMP |
| processed_at | NULLABLE | TIMESTAMP |
| _version | NULLABLE | INTEGER |
Data schema for convertiser_cpc
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| offer_id | NULLABLE | STRING |
| cpc_clicks | NULLABLE | INTEGER |
| cpc_advertiser_expense | NULLABLE | FLOAT |
| pe_transactions | NULLABLE | INTEGER |
| pe_amount | NULLABLE | FLOAT |
| pe_mean_amount | NULLABLE | FLOAT |
| pe_conversion_rate | NULLABLE | FLOAT |
| pe_cos | NULLABLE | FLOAT |
| pe_roas | NULLABLE | FLOAT |
| offer_title | NULLABLE | STRING |
| currency | NULLABLE | STRING |
