Skip to content
Black BoxPersonalization

Understand

Ask a question the log can answer

A question becomes one of four SELECT statements over analytics_facts. The statement on the page is the statement that ran. Values stay beside it as parameters.

The only view

analytics_facts is built for this request from included beacons. A beacon is included when it has no crawler, headless, or rate mark. COUNT(*) counts those rows. GROUP BY collapses rows that share the selected column. The columns are day, event_name, path, device, source. Visitor keys, account ids, email, and user agent strings are not columns.

Four statements exist. A parameter is shown as $1 or $2 and compared with =. The question text is never pasted into the statement. With OPENAI_API_KEY set, gpt-4o-mini may only return a template id and those parameters. Without the key, the preset questions are the ones that run.

Questions

Reading the collection log.

Counts use included beacons only. OPENAI_API_KEY is unset, so only the preset questions run.

Why these picks

Reading path transitions…