Documentation
Ask campaign questions in plain English with Query Agent. Translate natural language into SQL, inspect the data, and get fast answers for ad hoc analysis.
Query Agent lets you ask campaign questions in everyday language and get a structured answer back in seconds. Instead of navigating a report builder, you type the question you care about and ad:personam translates it into SQL, retrieves the relevant data, and explains the result.
This makes Query Agent ideal for quick, ad hoc analysis. It is the fastest reporting tool when you already know what you want to ask and want an answer without configuring a full report first.
How Query Agent Works
Query Agent takes a natural-language question, translates it into a data query, runs it against your allowed campaign data, and returns three things in the interface:
- Generated SQL — so you can see how the question was interpreted
- A result table — showing the rows returned by the query
- A written answer — summarising the result in plain language
This combination is helpful for both speed and transparency. You get a readable answer, but you can still inspect the supporting query and data when needed.
Example Questions to Ask
Query Agent works well for questions such as:
- What was my top-performing domain last week?
- Compare CTR across my campaigns this month.
- Which line items have the lowest viewability?
- Show me daily spend for the last 30 days.
These are direct questions with a clear analytical target, which is exactly where Query Agent performs best.
Best Use Cases for Query Agent
- Quick spot checks when you want one answer fast
- Ad hoc investigation for a specific metric, segment, domain, or time period
- Natural-language access to reporting data for users who do not want to build SQL manually
- Follow-up clarification during a short conversation about the same question thread
When Query Agent Is the Right Tool
Choose Query Agent when you already have a question in mind and need speed more than guidance.
It is especially effective for:
- checking a KPI or trend
- identifying a top or bottom performer
- comparing campaigns, Line Items, or periods
- validating a hypothesis before doing deeper optimisation work
When to Use Another Reporting Tool
Use Insight Agent when you want a guided optimisation workflow with a report-specific starting point, flexible date range on the first run, and Multi-Turn Follow-Up.
Use AI Reports when you want a more polished one-shot narrative for stakeholder sharing.
Use DSP Reports Service when you need exportable CSV output and more control over dimensions and metrics.
Related Articles
- Insight Agent — guided campaign analysis with follow-up chat
- AI Reports — analyst-style narrative reporting in one click
- DSP Reports Service — detailed CSV-based analytics reporting
- Reporting Overview — compare all reporting tools available on ad:personam