Linking TrustRadius as a source

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

Learn more
PostHog Wizard hedgehog

The TrustRadius connector syncs product scores, review quotes, traffic reports, visitor insights, and intent data into the PostHog Data Warehouse.

Prerequisites

Get an API key from your TrustRadius Client Success Manager. Your API license must include access to the tables you select. The visitor insights reports require the matching license for TrustRadius's legacy visitor insights API.

Adding a data source

  1. In PostHog, go to the Sources tab of the data pipeline section.
  2. Click + New source and click Link next to this source.
  3. Enter your credentials (see Configuration below) and click Next.
  4. Select the tables you want to sync, choose a sync method and frequency, then click Import.

Once the syncs are complete, you can start querying this data in PostHog.

Select TrustRadius and enter your API key. No product IDs are required: the connector discovers them from your vendor profile for traffic reports.

Sync modes

Each table can be synced in one of several modes, depending on what the source supports:

  • Webhook (when available) – the source pushes changes to PostHog in real time. Fastest freshness, lowest ongoing cost, and the only mode that reliably captures updates and deletes.
  • Incremental – only new or updated rows are synced on each run, using a cursor field (such as an updated_at timestamp). Cheaper than a full refresh, but deletes aren't captured.
  • Append only – new rows are appended using a cursor field; existing rows are never updated. Ideal for immutable, append-only tables like event logs.
  • Full refresh – the whole table is reloaded on every sync. Use it when a table has no reliable cursor or when you need deletions reflected.

See sync methods for a full explanation of how each mode works and how to choose between them.

The products, product_scores, trustquotes, and tags tables support full refresh only.

The traffic_products, visitor_insights_companies, visitor_insights_pages, and intent tables support full refresh or incremental sync on date. They do not support append-only sync. Incremental runs read recent dates again, with a default two-day overlap, to merge changes to existing daily rows.

For the three report tables, a full refresh or first incremental sync reads the last 365 days. Intent has a shorter window: the API serves at most 45 days, and the connector reads completed days starting 44 days ago. Use incremental sync to retain imported intent history; a full refresh only includes the available window.

Configuration

OptionTypeRequired
API keypasswordYes

Supported tables

TableDescriptionSync methodIncremental fieldPrimary key
products

Published products listed under the vendor profile.

Full refresh——
product_scores

Product scores and review counts for products licensed for the API.

Full refresh——
trustquotes

Quotes from product reviews, with reviewer details and assigned tags.

Full refresh——
tags

Tags and tag groups used to classify TrustQuotes.

Full refresh——
traffic_products

Daily page views, visits and visitors for product pages and their categories on TrustRadius.

Incremental, Full refreshdate—
visitor_insights_companies

Daily visit counts and company details for identified companies that research your products.

Incremental, Full refreshdate—
visitor_insights_pages

Daily page visits by identified companies that research your products, per page.

Incremental, Full refreshdate—
intent

One row per identified account and day, with the account's research activities on TrustRadius.

Incremental, Full refreshdate—

The products table lists published products under your vendor profile. product_scores contains scores and review counts for licensed products. trustquotes contains review quotes, including anonymous quotes, and tags contains their tags and tag groups.

The traffic_products table contains daily product-page traffic. The visitor insights tables contain daily company-level visits (visitor_insights_companies) and visits per page (visitor_insights_pages). Each intent row represents an account on a day, with its research activities.

Troubleshooting

  • If TrustRadius rejects the API key, check it with your Client Success Manager.
  • If a table returns a permissions error, ask your Client Success Manager to verify your API license and access to that dataset.
  • If an intent sync reports that a day's data is incomplete, the API returned its more flag. The connector already requests one day at a time, and the API provides no continuation request for the remaining rows.

If your sync is failing or data looks wrong, see the Data warehouse troubleshooting guide. If that doesn't help, contact support – we're happy to help.

Still have questions?

Was this page useful?