Book the exclusive demo launch to experience the OWOX BI analytics

How to build a report in OWOX BI Smart Data

Note:The Smart Data reports are available only for the Reports & Attribution and Enterprise subscription plans.

With Smart Data, get visualized reports on your raw data from Google BigQuery and export the reports to Google Data Studio and Google Sheets.

You just need to decide what metrics and dimensions you want to see in the report, then select the desired type of report and data range. Based on your choices, OWOX BI will generate an SQL request to the right data in BigQuery and provide you with a visualized report in the OWOX BI interface.

You can get a report using one of these three ways:

  1. Build a report in an easy-to-use report builder
  2. Input the query for the report manually, inputting it in natural language
  3. Select a ready-made report from suggested templates on the Smart Data main page

The data you can build the reports on

For the reports, you need data collected to the BigQuery tables having certain data schema:

Before using this BigQuery data in OWOX BI Smart Data, you need to bring the sources you need together in a Smart Data source set.

Read here, how the data source sets work and how to get your data to Google BigQuery.

How to get a report in the report builder

The report builder is a fast and convenient way to get a report in OWOX BI. We recommend using the builder to make your first reports.

Note, that you can't create attribution data reports and ROPO reports with the builder — you need to use the query input field only to build them.

Here’s how it works.

  1. On the Smart Data main page, click Create custom report:New_constructor_en_1.png
    Note that the "Report builder" tab is no longer present above the query input field. Also, note that Google BigQuery access information is now above the query input field.
  2. On the empty report screen, select metrics and dimensions you want to see in the report:New_constructor_en_2.pngMetrics and dimensions are grouped by type, so it’d be easier for you to find the ones you need. Alternatively, you can use the search field above the list.
  3. In the report part of the screen, you can select the Sessions date range and Grouping for the report:New_constructor_en_3.png
  4. Once you’ve selected the metrics, dimensions, and the date range, click Create report.
  5. That’s it. Your report is ready:New_constructor_en_4.png

Using the tool panel above the report, you can adjust and export it:New_constructor_en_6.png

  • Alter the applied metrics and dimensions. To do it, click Edit report: the metrics/dimensions sidebar will open
  • Change the Sessions date range and Grouping. Just change them as you like and the report will update automatically
  • But note that if you have metrics/dimensions sidebar open at that moment, you need to click Update report for the changes to take effect
  • Select how the report is visualized in the diagram
  • Rename (by clicking on the report name) the report and save it to favorites or to a separate report set
  • Export the report to Google Data Studio, Google Sheets, or as a .csv table

How does the text query input work

Using the query input field you can build a new report or find an existing report template. Just start typing in the metric or a dimension, then select one of the suggested queries:Smart_Data_search_en.png

You can edit the selected query: change, add or remove metrics and dimensions, select data range, slice, and additional parameters.

After confirming the query, you'll get to the report page. You can use the report builder to adjust it as you see fit: alter metrics and dimensions, the date range and grouping.

Note, that you can't edit attribution data reports and ROPO reports with the builder — you need to use the query input field only to build them.


Read also: The reports you can get with OWOX BI Smart Data

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.