Linking DataForSEO as a source
This source is currently in alpha. The interface and available tables may change.
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.
The DataForSEO connector syncs domain rank overview, historical rank overview, ranked keywords, and more into the PostHog data warehouse, so you can analyze them alongside your product data.
Prerequisites
Credentials that can read the data you want to sync. PostHog only reads data, so read access is enough.
Adding a data source
- In PostHog, go to the Sources tab of the data pipeline section.
- Click + New source and click Link next to this source.
- Enter your credentials (see Configuration below) and click Next.
- Select the tables you want to sync, choose a sync method and frequency, then click Import.
Once the syncs are complete, you can start querying this data in PostHog.
Enter your DataForSEO API credentials and the domains you want to track to pull SEO metrics like Google rankings, keywords, competitors, and backlinks.
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.
You'll be asked for:
- API login: for example
you@example.com. - API password
- Target domains (comma-separated): for example
example.com, posthog.com.
Sync modes
Each table can be synced in one of several modes, depending on what the source supports:
- Webhook (when available) – the source pushes changes to PostHog in real time. Fastest freshness, lowest ongoing cost, and the only mode that reliably captures updates and deletes.
- Incremental – only new or updated rows are synced on each run, using a cursor field (such as an
updated_attimestamp). Cheaper than a full refresh, but deletes aren't captured. - Append only – new rows are appended using a cursor field; existing rows are never updated. Ideal for immutable, append-only tables like event logs.
- Full refresh – the whole table is reloaded on every sync. Use it when a table has no reliable cursor or when you need deletions reflected.
See sync methods for a full explanation of how each mode works and how to choose between them.
All DataForSEO tables are full refresh. Each sync replaces the contents of the table.
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 |
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 |
Troubleshooting
- If the connection fails with an authorization error, the API password is wrong, expired, or has been revoked. Create a new one, then reconnect the source.
- If a table syncs no rows, the credential may not have access to that data. Check its permissions, then reconnect the source.
If your sync is failing or data looks wrong, see the Data warehouse troubleshooting guide. If that doesn't help, contact support – we're happy to help.