RevContent

Need help with something?

Talk to data expert

RevContent

RevContent is a native-advertising and content-recommendation network, similar to Taboola or Outbrain, that lets advertisers place sponsored content widgets across a network of publisher sites. Advertisers configure campaigns with bid, budget, and pacing controls, and target them by geography (country, region, DMA, zip code), device, language, and daypart. The Daton connector for RevContent replicates campaign configuration and lifetime stats, daily campaign performance, and publisher/placement-level ("widget") performance into your data warehouse.

Prerequisites

  • An active RevContent advertiser account with API access enabled.
  • A Client ID and Client Secret generated for API access on that account.

How to Obtain Your Credentials

  1. Ask your RevContent account representative to enable API access on your account — this is required before credentials become visible.
  2. Log in to your RevContent account and go to Account Settings.
  3. Scroll to the bottom of the page to the Stats API Credentials section. Your Client ID (client_id) and Client Secret (client_secret) are listed there.
  4. Copy both values — you'll enter them when you authenticate the Daton integration.

Steps to Integrate

  1. Integration Name — Enter a name to identify this Daton integration.
  2. Description (optional) — Enter a description to help identify the integration. You can change this at any time.
  3. Replication Frequency — Choose how often Daton should run replication jobs: 1h, 2h, 3h, 6h, 8h, 12h, or 24h. More frequent replication can affect billing.
  4. Replication Start Date — Select the date from which Daton should begin pulling historical data. All tables in this connector sync incrementally (new and updated records) based on this date. If you need data from before your selected start date, contact Daton support to request a one-time historical rollback.
  5. Lookback Window For Reports — Choose how many days of recent data Daton should re-pull on each sync to capture attribution changes: 1, 15, 30, or 45 days.
  6. Advanced Configuration — Optionally set:
    • Loading Mode: Append (insert new rows) or Upsert (update existing rows based on primary key).
    • Loading Nested Objects: Inherit from Warehouse Settings, Do not unnest, Upto one level, or Upto two levels — controls how nested fields like pixel and daypart_settings are flattened in the warehouse.
  7. Authenticate — Enter your Client ID and Client Secret to connect Daton to your RevContent account.
  8. Select Tables — Choose which of the available tables (campaigns, campaign_performance, widget_stats) to replicate.
  9. Configure Schema/Columns — Review and select the columns to include for each table in the destination schema.
  10. Submit — Complete the setup to start replication.

Supported Tables

Table Full Load Supported Description
campaigns No — incremental only
Campaign setup, targeting configuration, and lifetime stats
campaign_performance No — incremental only
Daily performance metrics by campaign
widget_stats No — incremental only
Daily performance metrics by publisher domain/placement (widget)

Table Schemas

campaigns

Primary key: id
Column Type Description
id STRING (Primary Key)
Unique campaign identifier
name STRING Campaign name
start_date DATETIME
Campaign start date
enabled STRING
Whether the campaign is enabled
status STRING
Current campaign status
bid_type STRING
Bidding strategy type
default_bid STRING
Default bid amount
min_bid STRING
Minimum bid amount
max_bid STRING
Maximum bid amount
budget STRING
Campaign budget
pacing STRING
Budget pacing setting
impressions STRING
Lifetime impressions
viewable_impressions STRING
Lifetime viewable impressions
clicks STRING Lifetime clicks
conversions STRING
Lifetime conversions
ctr STRING
Click-through rate
vctr STRING
Viewable click-through rate
avg_cpc STRING
Average cost per click
cost STRING Total spend
return STRING Total return
profit STRING Total profit
country_codes STRING
Targeted country codes
country_targeting STRING
Country targeting configuration
region_targeting STRING
Region targeting configuration
dma_targeting STRING
DMA (designated market area) targeting configuration
zipcode_targeting STRING
Zip code targeting configuration
created_at DATETIME
Record creation timestamp
updated_at DATETIME
Record last-updated timestamp
optimize STRING
Campaign optimization setting
language_targeting STRING
Language targeting configuration
device_targeting STRING
Device targeting configuration
utm_codes STRING
UTM tracking codes applied to the campaign
pixel RECORD (nested object)
Conversion tracking pixel details (id, name, amount, pixel)
daypart_settings RECORD (nested object)
Dayparting schedule (timezone, daypart_enabled)
os_targeting STRING
Operating system targeting configuration

campaign_performance

Primary key: id, date
Column Type Description
bid_type STRING
Bidding strategy type
id STRING (Primary Key)
Campaign identifier
date DATE (Primary Key)
Date of the performance record
impressions STRING
Impressions for the day
viewable_impressions STRING
Viewable impressions for the day
clicks STRING
Clicks for the day
conversions STRING
Conversions for the day
ctr STRING
Click-through rate
vctr STRING
Viewable click-through rate
avg_cpc STRING
Average cost per click
avg_vcpm STRING
Average viewable cost per thousand impressions
cost STRING
Spend for the day
cost_per_conv STRING
Cost per conversion
return STRING
Return for the day
profit STRING Profit for the day
created_at DATETIME
Record creation timestamp
updated_at DATETIME
Record last-updated timestamp

widget_stats

Primary key: report_date, boost_id, id
Column Type Description
report_date DATE (Primary Key)
Date of the performance record
boost_id STRING (Primary Key)
Identifier for the widget placement ("boost")
id STRING (Primary Key)
Campaign identifier
domain STRING
Publisher domain where the widget served
impressions STRING
Impressions for the day
viewable_impressions STRING
Viewable impressions for the day
clicks STRING
Clicks for the day
ctr STRING
Click-through rate
vctr STRING
Viewable click-through rate
avg_cpc STRING
Average cost per click
avg_vcpm STRING
Average viewable cost per thousand impressions
spend STRING
Spend for the day
conversions STRING
Conversions for the day
cost_per_conv STRING
Cost per conversion
profit STRING Profit for the day
placement_type STRING
Type of widget placement

Related Articles

Table of Contents

Prerequisites How to Obtain Your Credentials Steps to Integrate Supported Tables Table Schemas campaigns campaign_performance widget_stats