DataForSEO
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 DataForSEO to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Enter your DataForSEO API credentials and the domains you want to track to pull SEO metrics like Google rankings, keywords, competitors, and backlinks into the PostHog Data warehouse.
Find your API login and password on the DataForSEO API access page.
Note: DataForSEO bills per API request, so every sync consumes account credits. The backlinks summary table also requires an active Backlinks API subscription.
Configuration
| Option | Type | Required |
|---|---|---|
API login | text | Yes |
API password | password | Yes |
Target domains (comma-separated) | text | Yes |
Location | text | No |
Language | text | No |
Linking DataForSEO to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select DataForSEO
- 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 |
|---|---|---|---|---|
domain_rank_overview | Current organic and paid ranking distribution, estimated traffic value, and keyword counts per target domain (one row per target). Full refresh. | Full refresh | — | target |
historical_rank_overview | Monthly history of organic and paid ranking metrics per target domain since October 2020 (one row per target per month). Full refresh. | Full refresh | — | target, year, month |
ranked_keywords | Keywords each target domain ranks for in Google, with the ranked SERP element and keyword metrics like search volume and CPC. Full refresh. | Full refresh | — | target, keyword, item_type, rank_absolute |
competitors_domain | Competitor domains ranking for the same keywords as each target domain, with intersection counts and ranking metrics. Full refresh. | Full refresh | — | target, domain |
backlinks_summary | Backlink profile summary per target domain: rank, total backlinks, referring domains, IPs, and link attributes (one row per target). Requires an active DataForSEO Backlinks API subscription. Full refresh. | Full refresh | — | target |