Analytics

Build a report from a dataset

Pick a dataset, then slice your marketing data by any metric, dimension, and filter to build a report, chart it, export it, and pin it to a dashboard, without writing SQL.

Reports are where you answer "show me X by Y" about your marketing. You start from a dataset, pick what to measure, choose how to break it down, then chart it or export it, all without writing a line of SQL.

Dashboards answer the same questions every week. But the ad-hoc question, "why did cost jump on mobile last week?", doesn't fit a fixed tile. You need a free-form slice you can shape on the spot. A report is that slice, built on a dataset you've already connected, and you make it by clicking.

Before you begin

You'll need:

  • A Buron workspace (a free trial is fine).
  • At least one source connected. Either your Google Ads account, which powers the Google Ads datasets, or the Buron pixel installed and/or a CRM connected, which fill the Warehouse datasets.

A report reads from data you've already connected. It doesn't capture anything on its own, so if nothing's connected yet, start with the pixel or your Google Ads account.

Step 1: Pick a dataset

Open Datasets. The gallery lists every dataset you can start from. A dataset is a starting lens on one source, like "Campaigns & Ad Groups" on Google Ads or "Conversions" from the warehouse.

To find one:

  • Click a card across the top to filter by theme. The groups are Cross-channel, Campaigns, Search, Creative & assets, Placements, and Attribution.
  • Or type in the search box to filter by name.

Each dataset shows its Name with a one-line description, and its Data source (Google Ads or Warehouse). Click any card to open it in the builder.

Step 2: Choose what to measure and break it down

The builder has three regions. The left sidebar is the field picker, where you choose your fields. Everything you pick shows up on the right.

Fields come in two kinds:

  • Metrics are what you measure, like impressions, clicks, cost, conversions, and revenue. Click one to add it. Selected metrics turn blue, and the Metrics header shows a count.
  • Dimensions are how you slice, like campaign, channel, or device. They're grouped under headers such as Attributes and Segments (or themed names like Campaign and Time). Click one to add it.

To break results out over time, use the Date entry. It folds day, week, month, quarter, and year into one row, and you pick a single granularity at a time. Choosing one swaps the others out.

A few things that help when a dataset has a lot of fields:

  • Type in Search fields... to jump to one by name.
  • Flip Show selected fields to hide everything you haven't picked.
  • Hover the info icon next to a field to read what it means.
  • Switch the whole dataset from the dropdown at the top of the picker, without leaving the builder.

Step 3: Filter and set a date range

To filter on any field, open its menu and choose Filter. The filter lands as a chip in the bar across the top of the right panel, where you set its value. A funnel icon appears on the field's row while the filter is active. To remove it, open the menu again and choose Remove filter.

For warehouse datasets, a Date chip sits in the same bar. It reads All time until you pick a range. Click the × to clear it back to all time, which drops the date filter entirely.

When your report is ready, click Run (the play button on the right). It stays disabled until the report can run, and shows a spinner while it loads.

If you open the builder from a link that already carries a complete report, it runs once on its own. After that, every run is manual, so click Run to refresh.

Step 4: Chart it and read the results

The chart panel sits in the middle of the right side, under a strip labeled Visualization. Use the chart-type dropdown to switch how results draw:

  • Line
  • Bar
  • Area
  • Donut
  • Table

Below the chart is the results panel. The Results tab shows the rows, with a row count like "1,240 rows" once a report runs. The second tab shows the exact query Buron generated for you. It reads GAQL for Google Ads datasets and SQL for Warehouse datasets, so you can see what ran without writing it. You can drag the divider between the chart and the results to resize them.

Step 5: Export the results

Once you have results, the Export button gives you two ways out:

  • Copy puts the table on your clipboard as tab-separated text, ready to paste straight into Google Sheets or Excel. You'll see a "Copied to clipboard" toast.
  • Download CSV saves a .csv file.

Step 6: Save the report and add it to a dashboard

Click Save to keep the report. Give it a name (Buron suggests one), and it's stored for your team and appears in Reports. Reopen it any time from there to refresh it with the latest data.

To put a report on a dashboard, start from the dashboard's Add tile flow. That opens the builder, and the save button becomes Add to dashboard: saving attaches the report as a tile and drops you back on the dashboard. See Dashboards for the full flow.

What you can pull in

A report reads from the sources you've connected. There are two today:

  • Google Ads reads your live account through GAQL. It works as soon as your Google Ads account is connected, with no warehouse needed. Datasets include Campaigns & Ad Groups, Keywords, Search Terms, Search Ads, Placements, PMax Placements, and Asset Performance.
  • Warehouse is your team's analytics store, fed by the Buron pixel (events, sessions, and touchpoints) and your connected CRM (deals, revenue, and funnel stages), joined for attribution. The Cross-channel performance and Conversions datasets read from here, so they need the pixel and/or a CRM connected.

You choose the source by choosing a dataset. Each dataset is tied to one.

Where to see it

  • Datasets, the gallery you start from and the builder.
  • Reports, every report you've saved.

Frequently asked questions

Do I need to know SQL? No. You build the report by clicking metrics, dimensions, and filters. If you're curious, the results panel has a GAQL or SQL tab that shows the exact query Buron generated, but you never have to write it.

What sources can I use? Two today: Google Ads (read live, as soon as your account is connected) and Warehouse (your pixel and CRM data, joined for attribution). You pick the source by choosing a dataset, and each dataset is tied to one.

Why is a field greyed out? Some fields can't be combined with what you've already picked, like two grains that don't aggregate together. Hover the greyed-out field and Buron tells you why.

Can I export the results? Yes. Use Export to Copy the table (it pastes straight into Google Sheets or Excel) or Download CSV.

How do I come back to a report I built? Click Save to keep it. Saved reports live in Reports, where you can reopen any one to refresh it with the latest data.

My Warehouse datasets are empty. Those datasets read from the pixel and your CRM. Install the Buron pixel and connect a CRM, and the Cross-channel and Conversions datasets fill in once data syncs.

Next steps

Was this page helpful?

On this page