Ahrefs

Ahrefs

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 Ahrefs to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Requires an Ahrefs Lite plan or higher. Create an API key in Account settings > API keys. Syncs use your account's API units. Health scores are free. Issues and pages each cost 50 units per request. Each sync imports the latest crawl, with a sample of up to 100 pages. Page data requires verified project ownership.

Configuration

OptionDescription
API key
Type: password
Required: True
Site Audit project ID
Type: text
Required: True

Linking Ahrefs to PostHog

  1. Go to the Data pipeline page in PostHog
  2. Click New source and select Ahrefs
  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_health_scores

Health score and crawl totals for the selected Site Audit project.

Full refresh——
site_audit_issues

Issue summaries from the latest crawl of the selected Site Audit project.

Full refresh——
site_audit_pages

The first 100 crawled URLs, ordered by URL. Requires verified project ownership.

Full refresh——