Writesonic
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 Writesonic to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Connect Writesonic to pull your GEO (generative engine optimization) data — brand visibility, rank, and mentions across AI platforms like ChatGPT and Perplexity — into the PostHog Data warehouse.
You'll need:
- A Writesonic API key with GEO API access (revealed in your account's API dashboard; requires a plan with API access)
- The site URL of the tracked website, exactly as configured in Writesonic (e.g.
https://example.com) - Optionally, a project ID to disambiguate when the same site is tracked in multiple projects
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Site URL | text | Yes |
Project ID (optional) | text | No |
Linking Writesonic to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Writesonic
- 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 |
|---|---|---|---|---|
performance_summary | Only syncs the last 365 days on initial sync | Incremental, Full refresh | date | date, website_id |
performance_prompts | Only syncs the last 365 days on initial sync | Incremental, Full refresh | date | date, prompt_id |
performance_answers | Only syncs the last 365 days on initial sync | Incremental, Full refresh | date | date, response_id |
content_citations | Only syncs the last 365 days on initial sync | Incremental, Full refresh | date | date, citation_id |
content_keywords | Only syncs the last 365 days on initial sync | Incremental, Full refresh | date | date, id |
topics | The topics configured for the tracked site. Prompts are grouped under topics. | Full refresh | — | topic_id |
platforms | The AI platforms/models (e.g. ChatGPT, Perplexity, Google AI Overviews) enabled for the tracked site. | Full refresh | — | platform_id |
websites | All websites associated with the tracked site: your own properties and every tracked competitor. | Full refresh | — | website_id |
prompts | All prompts (queries) configured for the tracked site, with their topic, country, and status. | Full refresh | — | prompt_id |