Use * syntax for faster search

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Section

Column

width	50%

Panel

borderColor	#c8c8c8
borderWidth	1
borderStyle	solid

Table of Contents

maxLevel	2
indent	20px
style	none

Column

width	50%

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
Dimensions-Measures-Tables
Dimensions-Measures-Tables
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

A Shared Block

shared-block-key	Dimension

A field that represents an attribute. For example, the Start Date of a campaign or the External Link Status of an Ad Placement.

Measure

A Shared Block

shared-block-key	Measure

A field that represents quantitive information and that can be used in a calculation. For example, Client Net Amount (CC) or Impressions.

Table

A Shared Block

shared-block-key	Table

A group of related fields. For example, the Flight Period table contains attributes related to flight periods, like their start and end dates.

Anchor
Folder-Types
Folder-Types
Types of Folders

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 Enterprise.
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.

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).
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: Edit: Click to edit a report Save: Click to save a query or report Send: Click to send a query or report Save and schedule: Click to save a query as a report and then schedule the newly created report Schedule: Click to schedule a report
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.

Anchor
Field-Picker-Reference
Field-Picker-Reference
Field Selection Reference

Section

Column

width	45%

Column

width	45%

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.

Analytics Page Reference

Anchor
Data-Format-Options
Data-Format-Options
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.

Table Filter

totalrow	,,,,
hidelabels	false
ddSeparator	‚‚
sparkName	Sparkline
hidePane	Filtration panel
sparkline	false
default	,,
isFirstTimeEnter	true
cell-width	250,250,250
hideColumns	false
customNoTableMsg	false
disabled	false
enabledInEditor	false
globalFilter	false
id	1710427485045_1582190482
order	0,1,2
hideControls	false
inverse	false,false,false
column	Data Format is Available if Delivery Format is Email,Data Format is Available if Delivery Format is Amazon S3,Inline or Attachment
disableSave	false
separator	Point (.)
labels	Data Format is Available if Delivery Format is Email‚Data Format is Available if Delivery Format is Amazon S3‚Inline or Attachment
ddOperator	OR,OR,OR
datepattern	dd M yy
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND

Data Format	Description	Data Format is Available if Delivery Format is Email	Data Format is Available if Delivery Format is Amazon S3	Inline or Attachment
Data Table	The data table is sent in the body of the email, in HTML format.	Yes	No	Inline
Visualization	The visualization is sent in the body of the email, as a PNG file.	Yes	No	Inline
CSV	The data table is sent as a CSV (comma-separated value) file attachment.	Yes	Yes	Attachment
XSLX	The data table is sent as an Excel file attachment.	Yes	Yes	Attachment
JSON — Simple	The data table is sent as a JSON file attachment.	Yes	Yes	Attachment
Text	The data table is sent as a tab-separated text file attachment.	Yes	Yes	Attachment
HTML	The data table is sent as an HTML file attachment.	Yes	Yes	Attachment

Anchor
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

totalrow	,,,,
hidelabels	false
ddSeparator	‚‚
sparkName	Sparkline
hidePane	Filtration panel
sparkline	false
default	,,
isFirstTimeEnter	true
cell-width	250,250,250
hideColumns	false
customNoTableMsg	false
disabled	false
enabledInEditor	false
globalFilter	false
id	1710427508573_675877114
order	0,1,2
hideControls	false
inverse	false,false,false
column	Data Format,Advanced Delivery Option is Available if Delivery Format is Email,Advanced Delivery Option is Available if Delivery Format is Amazon S3
disableSave	false
separator	Point (.)
labels	Data Format‚Advanced Delivery Option is Available if Delivery Format is Email‚Advanced Delivery Option is Available if Delivery Format is Amazon S3
ddOperator	AND,OR,OR
datepattern	dd M yy
updateSelectOptions	false
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND

Advanced Delivery Option	Description	Data Format	Advanced Delivery Option is Available if Delivery Format is Email	Advanced Delivery Option is Available if Delivery Format is Amazon S3
Limit	Select the size of the delivery: Results in Table: The data in the query results data table, which has a general limit of 5,000 rows, is sent in a single delivery. All Results: All results of the query, without a row limit, are sent in as many deliveries as necessary. However, if the delivery format is Email, there is a 15 MB limit for file attachments and a 20 MB limit for inline content. Deliveries above this limit are not sent.	Data Table	Yes	No
		Visualization	Yes	No
		CSV	Yes	Yes
		XSLX	Yes	Yes
		JSON — Simple	Yes	Yes
		Text	Yes	Yes
		HTML	Yes	Yes
Email options Option is only available if Delivery Format is Email	Include links: Select this option to include a link to the OneStrata query, report, or dashboard, in the body of the email.	Data Table	Yes	No
		Visualization	Yes	No
		CSV	Yes	No
		XSLX	Yes	No
		JSON — Simple	Yes	No
		Text	Yes	No
		HTML	Yes	No
Format options	Select or unselect additional formatting option(s): Apply visualization options: Select this option to include any user-defined visualization settings, like custom column labels. Formatted data values: Select this option to include any existing special formatting, like the rounding of long numbers.	Data Table	Yes	No
		Visualization	No	No
		CSV	Yes	Yes
		XSLX	Yes	Yes
		JSON — Simple	Yes	Yes
		Text	Yes	Yes
		HTML	Yes	Yes
Table resolution Option is only available if Data Format is Visualization	Select the width of the visualization: Normal: 800 pixels Wide: 1680 pixels	Visualization	Yes	No
Send this schedule if Option is only available when scheduling a recurring delivery	Select the send condition of a recurring delivery: there are results: Send the delivery only if there are results that match one or more user-defined filters. there are no results: Send the delivery only if there are no results that match one or more user-defined filters. there are either results or no results: Send the delivery if there are either results or no results that match one or more user-defined filters. Optional - and results changed since last run: Send the delivery only if the query results have changed since the last delivery was sent.	Data Table	Yes	No
		Visualization	No	No
		CSV	Yes	Yes
		XSLX	Yes	Yes
		JSON — Simple	Yes	Yes
		Text	Yes	Yes
		HTML	Yes	Yes
Timezone Option is only available when scheduling a recurring delivery	Select the time zone that a recurring delivery is sent in.	Data Table	Yes	No
		Visualization	Yes	No
		CSV	Yes	Yes
		XSLX	Yes	Yes
		JSON — Simple	Yes	Yes
		Text	Yes	Yes
		HTML	Yes	Yes

...

Content

Space Tools

Versions Compared

Old Version 5

New Version 6

Key

Table of Contents

Overview

Terms and Concepts

Anchor
Dimensions-Measures-Tables
Dimensions-Measures-Tables
Dimensions, Measures, and Tables

Anchor
Folder-Types
Folder-Types
Types of Folders

Access the Analytics Page

Analytics Page UI Reference

Analytics Page UI Elements

Anchor
Field-Picker-Reference
Field-Picker-Reference
Field Selection Reference

Analytics Page Reference

Anchor
Data-Format-Options
Data-Format-Options
Data Format Options

Anchor
Advanced-Delivery-Options
Advanced-Delivery-Options
Advanced Delivery Options

Content

Space Tools

Page History

Versions Compared

Old Version 5

New Version 6

Key

Table of Contents

Overview

Terms and Concepts

AnchorDimensions-Measures-TablesDimensions-Measures-TablesDimensions, Measures, and Tables

AnchorFolder-TypesFolder-TypesTypes of Folders

Access the Analytics Page

Analytics Page UI Reference

Analytics Page UI Elements

AnchorField-Picker-ReferenceField-Picker-ReferenceField Selection Reference

Analytics Page Reference

AnchorData-Format-OptionsData-Format-OptionsData Format Options

AnchorAdvanced-Delivery-OptionsAdvanced-Delivery-OptionsAdvanced Delivery Options

Anchor
Dimensions-Measures-Tables
Dimensions-Measures-Tables
Dimensions, Measures, and Tables

Anchor
Folder-Types
Folder-Types
Types of Folders

Anchor
Field-Picker-Reference
Field-Picker-Reference
Field Selection Reference

Anchor
Data-Format-Options
Data-Format-Options
Data Format Options

Anchor
Advanced-Delivery-Options
Advanced-Delivery-Options
Advanced Delivery Options