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.
Add keywords to sync the search volume history and SERP snapshot tables, which are keyword-scoped rather than domain-scoped.
Note: DataForSEO bills per API request, so syncing these tables consumes account credits. The location and category lookup tables are free. The backlinks tables also need an active Backlinks API subscription.
Configuration
| Option | Type | Required |
|---|---|---|
API login | text | Yes |
API password | password | Yes |
Target domains (comma-separated) | text | Yes |
Keywords (comma-separated) | text | No |
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 |
relevant_pages | Landing pages of each target domain that rank in Google, with per-page estimated traffic, keyword counts, and position distribution. Full refresh. | Full refresh | — | target, page_address |
backlinks_referring_domains | Domains linking to each target domain, with domain rank, backlink and referring counts, spam score, and first-seen and lost dates (one row per referring domain). Requires an active DataForSEO Backlinks API subscription. Full refresh. | Full refresh | — | target, domain |
backlinks_history | Month-by-month history of each target domain's backlink profile since January 2019: rank, backlinks, referring domains, and crawl statistics. Requires an active DataForSEO Backlinks API subscription. Full refresh. | Full refresh | — | target, date |
backlinks_timeseries_summary | Monthly trend of each target domain's link profile since January 2019: backlinks, referring domains, pages, IPs, and subnets, with nofollow splits. Requires an active DataForSEO Backlinks API subscription. Full refresh. | Full refresh | — | target, date |
backlinks | Individual backlinks pointing at each target domain, with the linking page, anchor, rank, spam score, and first- and last-seen dates (one row per backlink). Only the highest-ranking backlinks are synced. Requires an active DataForSEO Backlinks API subscription. Full refresh. | Full refresh | — | target, url_from, url_to, item_type, anchor |
backlinks_anchors | Anchor text used to link to each target domain, with per-anchor backlink, referring domain, and spam score metrics (one row per anchor). Requires an active DataForSEO Backlinks API subscription. Full refresh. | Full refresh | — | target, anchor |
historical_search_volume | Monthly Google search volume history for each configured keyword (one row per keyword per month). Needs keywords configured on the source. Full refresh. | Full refresh | — | keyword, year, month |
serp_organic | A snapshot of the Google results page for each configured keyword, one row per SERP element with its type, rank, and URL. Covers the first page of results. Needs keywords configured on the source. Full refresh. | Full refresh | — | keyword, type, rank_absolute |
locations_and_languages | Reference table of every location DataForSEO Labs supports, with the languages available for each. Resolves the location_code and language_code carried on the other Labs tables. Full refresh. | Full refresh | — | location_code |
categories | Reference table of the DataForSEO Labs category taxonomy, with each category's parent code. Resolves the category codes carried on the other Labs tables. Full refresh. | Full refresh | — | category_code |