How to build a report in OWOX BI Smart Data

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 a human-friendly report builder
  2. Input the query for the report manually, using natural language
  3. Select a report from suggested templates on the Smart Data main page and edit it for your needs using the report builder or query input

You can switch between the Query input and Report builder modes via the corresponding tabs in Smart Data:

SD_report_method_en.png

All these methods interact with data in BigQuery in the same way, so a report made with the report builder can be easily edited in the query input mode, and vice versa.

The data you can build the reports on

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

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. If you a newcomer to OWOX BI Smart Data, we recommend using the builder to make your first reports.

Here’s how it works.

1. Go to Smart Data and click on the Report builder tab above the query input field:

SD_report_method_en.png
2. Select the source of the data you want to build a report upon: Smart Data or Attribution data. The source selected determines the sets of metrics and dimensions available:

SD_report_data_source_en.png

Smart Data: data in Google BigQuery tables you have connected or can connect to OWOX BI Smart Data:

Attribution model data: data in Google BigQuery tables, that contain the OWOX BI Attribution model calculation results. Using Attribution data as a source you can build:

3. After selecting the data source, choose metrics and dimensions you want to build a report upon. You can choose more than one value in each column. You can also quickly find the exact metric and dimension by filtering it by name:

SD_report_metrics_and_dimensions_select_en.png

4. In the Available reports section, you’ll see the reports you can build with the parameters chosen:

SD_report_template_select_en.png

5.Select a report that fits your need, then specify the Date Range within which the report will be built:

SD_additional_parameters_and_get_report_en.png

For some reports, you’ll need to additionally specify the report Slice (by days, weeks, or months) and the Attribution model for attribution reports.

6. When all report parameters are set up, click Get report. The Clear all button resets all settings.

The resulted report can be altered by changing the settings in the builder after clicking on the Edit field:

SD_report_builder_edit_en.png

Tip: After getting a report via report builder, you can switch to the Query input tab and edit the metrics and parameters staying within the context of the current report.

How does the text query input work

Query input is a standard way to get a report in Smart Data. To find the report you need, just start typing in the metric or a dimension, then select one of the suggested queries:

SD_query_input_autocomplete_en.png

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

To add a metric or a dimension to your report, just add "and" then type them in:

SD_query_input_add_dimension_en.png

We recommend using the query input method for searching metrics and dimensions in case you’re not sure how they’re called in OWOX BI.

Query input is also a convenient tool if you need to make quick edits in the report you’ve made in the builder, without getting out of the context of the report.

Query limits

The users with the Basic subscription plan can get up to 100 reports per month and can’t build reports that require data from CRM systems — the CRM data is unavailable for this plan.

As for Business and Enterprise plans, there are no restrictions to building reports in OWOX BI.

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

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

0 Comments

Please sign in to leave a comment.