|
Overview
The Explore Analytics page provides tooling to explore and visualize the data entered and created within OneStrata, like information about a campaign's budget or the unique identification number of a specific Order. The results of a query can be saved and shared, internally or externally.
Explore Analytics Tabs
There are two tabs on the Explore Analytics page:
- OneStrata (OneStrata Analytics)
- Adazzle (Adazzle Analytics)
About OneStrata Analytics
OneStrata Analytics is a gated feature and not enabled by default. If OneStrata Analytics is not enabled, the OneStrata tab is not available. To enable this feature, contact your OneStrata representative. |
The OneStrata tab enables users to query information across the entire OneStrata platform and build customized visualizations, reports, and dashboards that can be shared internally and externally.
To access OneStrata Analytics:
- Open the Explore Analytics page. By default, the Explore Analytics page opens on the OneStrata tab.
About Adazzle Analytics
Adazzle Analytics is a gated feature and not enabled by default. If Adazzle Analytics is not enabled, the Adazzle tab is not available. To enable this feature, contact your OneStrata representative. |
Available for enterprises that previously used Adazzle, the Adazzle tab enables users to query certain historic Adazzle data from within the OneStrata platform. For information on the tables that are available in Adazzle Analytics, see Adazzle Analytics Tables.
To access Adazzle Analytics:
- Open the Explore Analytics page. By default, the Explore Analytics page opens on the OneStrata tab.
- Click the Adazzle tab to open Adazzle Analytics.
Analytics Terms and Concepts
This section contains information about terms and concepts related to analytics in OneStrata.
Types of Folders
Reports and dashboards are saved and organized into folders. There are four types of folders:
- Favorites
- My Folder
- Group
- Shared
| Folder Name | Description |
|---|---|
| Favorites | A user-created collection of bookmarked reports and dashboards. To add a report or dashboard to your Favorites folder, click the heart icon next to the title of the report or a dashboard. |
My Folder | A personal, non-sharable folder for individual users. |
| Group | A shared folder that can be viewed and edited—depending on individual user permissions—by users within the same OneStrata enterprise. |
Shared | A folder for FreeWheel-managed, predefined reports. For more information, see About Predefined Reports. |
About Dimensions, Measures, and Tables
Queries are requests for information, and the fields in a query specify what type of information to return. There are two types of fields, dimensions and measures. Related fields are grouped into tables.
| Term | Description | |
|---|---|---|
| Dimension |
| |
| Measure |
| |
| Table |
|
About Calculated Fields
Calculated fields are user-created metrics and dimensions that are derived from one or more existing fields, including other calculated fields. In the query results data table, located in the Data section, calculated fields appear as green columns. |
A calculated field is restricted by the query that it is added to:
- A calculated field depends on the results of the query; a calculated field can only be derived from other fields in the query.
- A calculated field exists as long as the query does. In other words, if the query is not saved, the calculated field is not saved either.
- A calculated field is only viewable and editable by the user that created it, unless the query that contains the calculated field is saved to the Group folder, a folder shared by users across the same OneStrata enterprise.
Like in Excel, calculated fields can be created by using basic mathematical operators—addition (+), subtraction (-), multiplication (*), division (/)—or built-in formulas.
For example, a calculated field might be created by taking the Clicks delivered and dividing it by the Number of Units ordered, in order to examine delivery pacing: Delivery Pacing = Clicks / Number of Units.
See also: |
Calculated Field Format Options
All rounding is half-up rounding, where half-way values are always rounded up. For example, when rounding to the nearest integer, any value less than 1.5 is rounded down to 1, and any value equal to or greater than 1.5 is rounded up to 2. |
Calculated fields can be displayed in a variety of formatting options:
| Format Option | Description |
|---|---|
| Default formatting | Displays values as they are formatted in the OneStrata data warehouse. |
| ID | Displays numeric values as integers, with any non-integer values rounded to the nearest integer. |
| Decimals | Displays numeric values with a comma that separates every three digits and a period that separates the decimal fraction, if any decimal places are included. There are five decimal place options:
|
| U.S. Dollars | Displays numeric values like in the Decimals option, but with the U.S. dollar symbol ($) in front. There are two decimal place options:
|
| British Pounds | Displays numeric values like in the Decimals option, but with the British pound symbol (£) in front. There are two decimal place options:
|
| Euros | Displays numeric values like in the Decimals option, but with the euro symbol (€) in front. There are two decimal place options:
|
| Percent | Displays numeric values like in the Decimals option, but with the percent symbol (%) at the back. There are five decimal place options:
|
| Custom | Displays numeric values as specified by the user-entered Custom format formula. |
Explore Analytics Page Reference
Data Format Options
The results of a query or a report can be sent in many different formats. The format options depend on whether the results are sent as an email or to an Amazon S3 bucket.
|
Advanced Delivery Options
When a query or report is shared, the Advanced options section provide additional customization options.
|
Adazzle Analytics Tables
The following tables are available in Adazzle Analytics:
|