Analyzing AI citations

PostHog runs a set of tracked prompts against AI answer engines once a day and records, per prompt and engine, whether the answer cited the project's own domain. Every citation question reduces to an aggregation over that record, optionally joined to two other sources: Google Search Console (a data warehouse source) and the project's own web traffic (the sessions and events tables).

This skill covers the citation record, the prompt set tools, the joins, and the HogQL papercuts that make the first query fail.

Tools