> AI agents: this is one page from PostHog's docs. Full index of Markdown docs for LLMs: https://posthog.com/llms.txt

# Linking DataForSEO as a source

Canonical URL: https://posthog.com/docs/data-pipelines/sources/dataforseo

> **Cloud region:** This page uses US Cloud hosts. For an EU Cloud project, use `https://eu.posthog.com` instead of `https://us.posthog.com` or `https://app.posthog.com` (app host for links).

## On this page

- [Prerequisites](#prerequisites)
- [Adding a data source](#adding-a-data-source)
- [Sync modes](#sync-modes)
- [Configuration](#configuration)
- [Supported tables](#supported-tables)
- [Troubleshooting](#troubleshooting)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_9608fcca70)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_dark_a92b0e022d)

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.

`npx @posthog/wizard warehouse`

![PostHog Wizard hedgehog](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)

![](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)Let AI connect your sources for you

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

1.  In PostHog, go to the [Sources tab](https://app.posthog.com/data-management/sources) of the data pipeline section.
2.  Click **\+ New source** and click **Link** next to this source.
3.  Enter your credentials (see [Configuration](#configuration) below) and click **Next**.
4.  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](https://app.dataforseo.com/api-access).

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_at` timestamp). 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](https://posthog.com/docs/data-pipelines/sources.md#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](https://posthog.com/docs/data-warehouse/troubleshooting.md). If that doesn't help, [contact support](https://us.posthog.com/#panel=support%3Asupport%3Adata_warehouse%3A%3Atrue) – we're happy to help.