Report setups, queries, and report blocks

This page explains the basic building blocks behind Keytiles Reports. Read this first if you want to understand the words used in the Report editor before creating your first setup.

Content of this page

The short version

  • A Report setup is the saved configuration of a report.
  • A Report instance is one generated result from that setup.
  • A query is one report block inside the setup.
  • A setup can contain multiple queries, so one generated report can contain multiple blocks.
  • Each query chooses what to measure, what data to include, how to break it down, and how to sort the rows.

Report setup

A Report setup answers the question: What report should Keytiles generate?

It contains setup-level information such as the report title, description, schedule, Integration settings, and the list of queries that make up the report content. You usually create the setup once, then reuse it many times.

Report instance

A Report instance is the generated result. If you generate the same setup every Monday, each Monday result is a separate instance.

This separation is useful because you can keep the setup stable while still generating new report results over time.

Query and report block

Inside a setup, a query defines one block in the generated report. You can think of a query as one table or section.

For example, one setup could contain:

  • One block showing total key events by week.
  • One block showing referrer performance by source type.
  • One block showing campaign performance by campaign name.

Each block can answer a different question, but all blocks are generated together as one report instance.

Query types

The query type decides what kind of report block you are building. The available types can grow over time, but the common idea is the same: choose the type that best matches the question you want to answer.

  • Event count is useful when you mainly want to count selected events.
  • Referrer performance is useful when you want to analyze where traffic or events came from.
  • Campaign performance is useful when you want to analyze campaign-related values such as campaign, medium, or content.

The Query mental model

When editing a query, work through the form in this order:

  1. Report block - name the block and choose its query type.
  2. Measure - choose the events that should become metrics.
  3. Include only - decide which data is allowed into the block.
  4. Break down by - choose how rows should be grouped.
  5. Rows and ordering - limit and sort the final rows.

For a practical walkthrough of these sections, continue with Design a report block.