Similarweb
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.
Connect Similarweb to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Sync estimated traffic, engagement and audience data for any set of domains. Generate an API key under API management in your Similarweb account settings. The API is a paid add-on, and your plan decides which countries, metrics and history are available.
Configuration
| Option | Description |
|---|---|
API keyType: password Required: True | |
DomainsType: text Required: True | Comma-separated list of domains to sync. Similarweb has no way to list the domains on your account, so every table is built from this list. At most 50. |
CountryType: text Required: False | Two-letter country code to report on, or |
GranularityType: select Required: True | Daily and weekly data need a plan that includes them. |
Start monthType: text Required: False | Earliest month to sync (YYYY-MM). Leave empty to sync only the most recent period. How far back you can go depends on your plan. |
Linking Similarweb to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Similarweb
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
visits | Estimated desktop and mobile web visits per period for each configured domain | Incremental, Full refresh | date | — |
page_views | Estimated desktop and mobile web page views per period for each configured domain | Incremental, Full refresh | date | — |
pages_per_visit | Average number of pages viewed per visit, per period, for each configured domain | Incremental, Full refresh | date | — |
average_visit_duration | Average visit duration in seconds, per period, for each configured domain | Incremental, Full refresh | date | — |
bounce_rate | Share of visits that ended without further interaction, per period, for each configured domain | Incremental, Full refresh | date | — |
global_rank | Monthly worldwide traffic rank for each configured domain | Incremental, Full refresh | date | — |
traffic_sources | Visits split by marketing channel and organic/paid, per period, for each configured domain | Incremental, Full refresh | date | — |
traffic_by_country | Traffic share and engagement per visitor country, aggregated over the synced window | Full refresh | — | — |