Serpstat
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 Serpstat to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Create an API token on your Serpstat profile. API access requires the Team plan or higher. Syncs use your account's API units when Serpstat applies a charge. Serpstat lists these methods as free of API credit charges. Paginated tables include up to 500 records. Positions cover the last seven days for one project region.
Configuration
| Option | Description |
|---|---|
API tokenType: password Required: True | |
Project IDType: text Required: True | Copy the project ID from the URL of your Serpstat Rank Tracker report. |
Project region IDType: text Required: True | Use the region ID from the Serpstat getProjectRegions method. |
Linking Serpstat to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Serpstat
- 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 |
|---|---|---|---|---|
projects | Projects available to the Serpstat account. | Full refresh | — | project_id |
project_keywords | Keywords configured for the selected Rank Tracker project. | Full refresh | — | project_id, id |
project_regions | Search regions and their status for the selected Rank Tracker project. | Full refresh | — | project_id, id |
project_tags | Tags created in the selected Rank Tracker project. | Full refresh | — | project_id, tag_uuid |
project_positions | Keyword positions for the configured project region during the last seven days, grouped by keyword. | Full refresh | — | project_id, keyword_id |