Skip to main content

Rokt

info

API Documentation: Rokt Query API Documentation

The Rokt Query API provides access to campaign performance and transaction data for both advertisers and partners on the Rokt platform. This connector syncs account information, campaign metadata, and performance reports at multiple time granularities.

Source Setup Guide​

This connector uses OAuth 2.0 client credentials authentication:

  1. Sign in to Rokt One Platform
  2. Navigate to Profile Settings under your account icon
  3. Scroll to Generate Personal API Credentials
  4. Enter an app name and click Generate
  5. Copy both the App ID and App Secret (the secret is only shown once)
  6. In Extract, create a new Rokt source and enter your credentials
  7. Run a test connection to validate authentication
caution

Store your App Secret securely—it cannot be retrieved after the initial generation. If lost, you must generate new credentials.

Connection Setup Guide​

After connecting Rokt to a destination, configure the connection:

  • Connection Pull Schedule: How frequently data is extracted from the source.
  • Backfill (Days): How many days of historical data to retrieve on each run (default: 30 days).
  • Selected Account IDs: The Rokt accounts to sync data for. If not specified, you must select at least one account before running the connection.
  • Destination-specific settings: Settings such as dataset name or target schema (depends on destination).
  • Schema Migration Policy: How Extract handles schema changes from the source.

Connector Information​

info

Account Types​

Rokt supports two account types with different available streams:

  • Advertiser accounts: Access to campaigns and campaign_performance streams for ad spend and campaign metrics.
  • Partner accounts: Access to transaction_performance and transaction_summary streams for monetization data.

The accounts stream is available for all account types and does not require account selection.

Sync Behavior​

  • Reporting timezone: Data is pulled in the timezone configured in your Rokt account settings.
  • Currency: Monetary values use the currency configured in your Rokt account.
  • Dynamic fields: Available dimensions and metrics are loaded dynamically from Rokt's /help endpoints to match your account's configuration.
  • Report intervals: Performance reports are available at daily, weekly, monthly, and yearly granularity.

Rate Limits​

Rokt API requests are rate-limited. Extract handles rate limiting automatically with exponential backoff.

Schema ERD​

Explore the interactive entity relationship diagram for Rokt.

Open page

Data Streams​

accounts​

Loading ....

campaign_performance​

Loading ....

campaigns​

Loading ....

transaction_performance​

Loading ....

transaction_summary​

Loading ....