Release Status Released Availability Free
Status Page Taboola Status Page Default Historical Sync 1 year
Whitelist Tables/Columns Unsupported/Unsupported Default Replication Frequency 30 minutes
Full Table Endpoints 0 Incremental Endpoints 2
Destination Incompatibilities None

Connecting Taboola

Connecting Stitch to Taboola is a three-step process:

  1. Add Taboola as a Stitch data source
  2. Define the Historical Sync
  3. Define the Replication Frequency

Prerequisites

To complete the setup, you’ll need:

  1. Access to the Taboola API, and
  2. The following credentials:
    • Taboola Account ID,
    • Client ID, and
    • Client Secret

Reach out to your Taboola Account Manager for assistance. Once you receive this information, you can continue with the setup.

Add Taboola as a Stitch Data Source

  1. On the Stitch Dashboard page, click the Add an Integration button.
  2. Click the Taboola icon.

  3. Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Stitch Taboola” would create a schema called stitch_taboola in the data warehouse. This schema is where all the tables for this integration will be stored.

  4. Enter your Taboola credentials as follows:
    • Username - Enter your Taboola username. This user must have access to the Taboola API.
    • Password Enter your Taboola password.
    • Account ID - Enter your Taboola account ID.
    • Client ID - Enter your Taboola client ID.
    • Client Secret - Enter your Taboola client secret.

Define the Historical Sync

The Sync Historical Data setting will define the starting date for your Taboola integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to sync data beyond Taboola’s default setting of 1 year. For a detailed look at historical syncs, check out the Syncing Historical SaaS Data article.

Define the Replication Frequency

The Replication Frequency controls how often Stitch will attempt to replicate data from your Taboola integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.

Before setting the Replication Frequency, note that the more often Taboola is set to replicate, the higher the number of replicated rows.

Additionally, the number of rows Stitch replicates is impacted by:

  • The Replication Methods used by this integration’s tables. Refer to the Schema section for info on how specifc tables are replicated.

To help prevent overages, we recommend setting the integration to replicate less frequently. For example: every 6 hours instead of every 30 minutes.

After selecting a Replication Frequency, click Save Integration.

Taboola’s Intial Sync

After you finish setting up Taboola, you might see its Sync Status show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial sync for the integration. This may take some time to complete.


Taboola Schema

Stitch's Taboola integration includes these tables:


campaign

Replication Method: Incremental
Primary Key: id
Contains Nested Structures?: Yes

The campaign table contains info about the campaigns in your Taboola account.

Table Info & Attributes

campaign & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

NULL Dates

On occasion, Taboola’s API will push NULL for start_date and 999-12-31 for end_date. The Singer Tap powering Stitch’s Taboola integration will convert NULL dates to 999-12-31 for consistency.

campaign Attributes

This table includes the following attributes:

  • Campaign ID (id)

  • advertiser_id

  • name

  • tracking_code

  • cpc

  • daily_cap

  • spending_limit

  • spending_limit_model

  • country_targeting*

  • platform_targeting*

  • publisher_targeting*

  • start_date

  • end_date

  • approval_state

  • is_active

  • spent

  • status

campaign_performance

Replication Method: Incremental
Primary Key: campaign_id : date
Contains Nested Structures?: No

The campaign_performance table contains performance data for the campaigns in your Taboola account.

Table Info & Attributes

campaign_performance Attributes

This table includes the following attributes:

  • campaign_id

  • date

  • impressions

  • ctr

  • clicks

  • cpc

  • cpm

  • cpa_conversion_rate

  • cpa_actions_num

  • cpa

  • spent

  • currency



Questions? Feedback?

Did this article help? If you have questions or feedback, please reach out to us.