Data & Tools

Custom Reports

Build custom queries and reports on your connected data sources.

Custom ReportsComing Soon

Overview

Custom Reports gives you full flexibility to build custom queries and visualizations against your marketing data. Select metrics, define formulas, choose visualization types, and save reports for repeated use.

Key Features

  • Schema-Driven Builder: Browse available metrics and dimensions from a structured schema
  • Custom Formulas: Create calculated metrics using formulas (e.g., custom ROAS definitions)
  • Visualization Picker: Choose from tables, bar charts, line charts, pie charts, and more
  • AI Report Chat: Describe what you want in natural language and let AI build the report for you
  • Save & Reuse: Save report configurations and re-run them with different date ranges
  • Dynamic Rendering: Reports update in real-time as you adjust parameters

How It Works

The report builder connects to your Adverfly data warehouse. Select dimensions (campaign, channel, date), metrics (spend, revenue, conversions), and optionally define custom formulas. Choose a visualization type and the report renders instantly.

Use Cases

  • Custom KPIs: Track non-standard metrics specific to your business
  • Ad-Hoc Analysis: Answer one-off questions about your data without exporting
  • Executive Dashboards: Build focused reports for leadership reviews
  • AI-Powered Queries: Ask questions like "Show me ROAS by channel for the last 30 days" and get instant reports

Getting Started

  1. Open Custom Reports from the sidebar
  2. Click "Create New Report"
  3. Select your metrics, dimensions, and visualization type
  4. Or use Report Chat to describe what you want in natural language
  5. Save the report for future use