Use * syntax for faster search
Page History
Section | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Overview
The 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.
Terms and Concepts
This section contains information about terms and concepts related to analytics in OneStrata.
Anchor |
---|
|
|
|
|
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 |
|
Anchor About-Calculated-Fields About-Calculated-Fields
About Calculated Fields
About-Calculated-Fields | |
About-Calculated-Fields |
A Shared Block | ||
---|---|---|
| ||
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.
Info |
---|
See also: |
Anchor | ||||
---|---|---|---|---|
|
Info |
---|
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. |
AnchorFolder-Types Folder-Types
Types of Folders
Folder-Types | |
Folder-Types |
Reports and dashboard 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 Enterpriseenterprise. |
Shared | Currently not available. |
Access the Analytics Page
Access the Analytics page from the top navigation bar under Reports, or from the Welcome home page under the Reports section.
Analytics Page UI Reference
Build and run queries on the Analytics page, create reports and dashboards, or open existing reports and dashboards.
Anchor Analytics-Page-UI-Elements Analytics-Page-UI-Elements
Analytics Page UI Elements
Analytics-Page-UI-Elements | |
Analytics-Page-UI-Elements |
The Analytics page contains the following elements:
Element | Description | |
---|---|---|
1 | Field Selection section | The Field Selection section contains information about fields that can be added to a query and fields that have been added to a query. For more information, see Field Selection Reference. |
2 | Filters section | Displays any filters that have been applied to a query and filter options. By default, the Filters section is collapsed. |
3 | Visualization section | Displays the visualization created from a query and visualization options. By default, the Visualization section is collapsed. |
4 | Data section | Displays the fields added to a query. After a query is run, the Data section displays the results of the query as a data table (the query results data table).. Click the Add calculation button to add a calculated field to a query. |
5 | Run button | Click to run a query. |
6 | Explore actions gear icon | Click to view and select actions related to the current query or report. Options include:
|
7 | Toggle Navigation folder icon | Click to view a list of available folders. Select a folder to view any reports or dashboards saved within the folder. |
AnchorField-Picker-Reference Field-Picker-Reference
Field Selection Reference
Field-Picker-Reference | |
Field-Picker-Reference |
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Field Selection UI Elements
The Field Selection contains the following elements:
Element | Description | |
---|---|---|
a | Collapse / Expand icon | Click to collapse or expand the Field Selection. |
b | Find a Field search bar | Search for fields that match specific terms and criteria. |
c | All Fields / In Use tabs | Click to switch between the All Fields tab and the In Use tab. |
d | All Fields tab | A list of all available fields, grouped by table. |
e | In Use tab | A list of currently selected fields, grouped by table. |
Anchor | ||||
---|---|---|---|---|
|
Info |
---|
Depending on the type of field, not all icons are available. |
The Field Selection icons appear when hovering over a field in the Field Selection, and provide additional options and information about the field:
Icon | Description |
---|---|
Pivot data icon | Click to pivot on the field. The Pivot data icon is gray when the field being hovered over is not pivoted, and bold when the field is pivoted. |
Filter by field icon | Click to filter by the field. The Filter by field icon is gray when the field being hovered over is not filtered on, and bold when the field is filtered on. |
Info icon | Click to view more information about a field:
|
More icon | Click to see additional actions related to the field. |
Analytics Page Reference
Anchor | ||||
---|---|---|---|---|
|
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.
Table Filter | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
AnchorAdvanced-Delivery-Options Advanced-Delivery-Options
Advanced Delivery Options
Advanced-Delivery-Options | |
Advanced-Delivery-Options |
When a query or report is shared, the Advanced options section provide additional customization options.
Table Filter | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
...