Semrush

Semrush

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

Connect Semrush to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Requires an SEO Business subscription and a project with Site Audit enabled. Find your v3 API key under API keys in your Semrush profile. Syncs use your account's API units: 100 units per table request. Retries can use more units. Connection validation also uses 100 units.

Configuration

OptionTypeRequired
API key (v3)passwordYes
Project IDtextYes

Linking Semrush to PostHog

  1. Go to the Data pipeline page in PostHog
  2. Click New source and select Semrush
  3. Fill in the required configuration fields
  4. Click Next, select the tables you want to sync, and then press Import

Supported tables

TableDescriptionSync methodIncremental fieldPrimary key
site_audit

Summary of the latest Site Audit for the configured Semrush project.

Full refresh——
site_audit_snapshots

Completed audit IDs and completion dates for the configured Semrush project.

Full refresh——
site_audit_issue_descriptions

Issue descriptions for Site Audit reports.

Full refresh——