Use * syntax for faster search

Versions Compared

Old Version 7

changes.mady.by.user Hub Admin

Saved on

compared with

New Version Current

changes.mady.by.user Hub Admin

Saved on

Key

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


Section


Column
width50%


Panel
borderColor#c8c8c8
borderWidth1
borderStylesolid

Table of Contents

Table of Contents
maxLevel2
indent20px
stylenone



Column
width50%




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.

Anchor
Analytics-Terms-Concepts
Analytics-Terms-Concepts
Analytics Terms and Concepts

This section contains information about terms and concepts related to analytics in OneStrata.

Anchor

Dimensions

About-

Measures-Tables

Fields

Dimensions

About-

Measures-Tables

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

TermDescription
Dimension


A Shared Block
shared-block-keyDimension

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

In the query results data table, located in the Data section, dimensions appear as blue columns.


Measure


A Shared Block
shared-block-keyMeasure

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

In the query results data table, located in the Data section, measures appear as orange-brown columns.


Table


A Shared Block
shared-block-keyTable

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


Anchor
About-Calculated-Fields
About-Calculated-Fields
About Calculated Fields

A Shared Block
shared-block-keyAbout-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.

Info

See also:

Anchor
Calculated-Field-Format-Options
Calculated-Field-Format-Options
Calculated Field Format Options

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 OptionDescription
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:

  • 0: The value is rounded to the nearest integer
  • 1: The value is rounded to the nearest tenth place
  • 2: The value is rounded to the nearest hundredth place 
  • 3: The value is rounded to the nearest thousandth place
  • 4: The value is rounded to the nearest ten thousandth place
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:

  • 0: The value is rounded to the nearest whole dollar
  • 2: The value is rounded to the nearest dollar and cents value
British Pounds

Displays numeric values like in the Decimals option, but with the British pound symbol (£) in front.

There are two decimal place options:

  • 0: The value is rounded to the nearest whole pound 
  • 2: The value is rounded to the nearest pound and pence value
Euros

Displays numeric values like in the Decimals option, but with the euro symbol (€) in front.

There are two decimal place options:

  • 0: The value is rounded to the nearest whole euro
  • 2: The value is rounded to the nearest euro and cents value
Percent

Displays numeric values like in the Decimals option, but with the percent symbol (%) at the back.

There are five decimal place options:

  • 0: The value is rounded to the nearest integer
  • 1: The value is rounded to the nearest tenth place
  • 2: The value is rounded to the nearest hundredth place 
  • 3: The value is rounded to the nearest thousandth place
  • 4: The value is rounded to the nearest ten thousandth place
Custom

Displays numeric values as specified by the user-entered Custom format formula.

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

Image Removed

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:

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-ReferenceField-Picker-ReferenceField Selection Reference Section
Column
width45%

Image Removed

Column
width45%

Image Removed

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,,,,
hidelabelsfalse
ddSeparator‚‚
sparkNameSparkline
hidePaneFiltration panel
sparklinefalse
default,,
isFirstTimeEntertrue
cell-width250,250,250
hideColumnsfalse
customNoTableMsgfalse
disabledfalse
enabledInEditorfalse
globalFilterfalse
id1710427485045_1582190482
order0,1,2
hideControlsfalse
inversefalse,false,false
columnData Format is Available if Delivery Format is Email,Data Format is Available if Delivery Format is Amazon S3,Inline or Attachment
disableSavefalse
separatorPoint (.)
labelsData Format is Available if Delivery Format is Email‚Data Format is Available if Delivery Format is Amazon S3‚Inline or Attachment
ddOperatorOR,OR,OR
datepatterndd M yy
updateSelectOptionsfalse
worklog365|5|8|y w d h m|y w d h m
isORAND


Data FormatDescriptionData Format is Available if Delivery Format is EmailData Format is Available if Delivery Format is Amazon S3Inline or Attachment
Data Table

The data table is sent in the body of the email, in HTML format.

Yes

NoInline
Visualization

The visualization is sent in the body of the email, as a PNG file.

Yes

NoInline
CSVThe data table is sent as a CSV (comma-separated value) file attachment.YesYesAttachment
XSLXThe data table is sent as an Excel file attachment.YesYesAttachment
JSON — SimpleThe data table is sent as a JSON file attachment.YesYesAttachment
TextThe data table is sent as a tab-separated text file attachment.YesYesAttachment
HTMLThe data table is sent as an HTML file attachment.YesYesAttachment


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,,,
hidelabelsfalse
ddSeparator,‚,
sparkNameSparkline
hidePaneFiltration panel
sparklinefalse
default,,
isFirstTimeEntertrue
cell-width250,250,250
hideColumnsfalse
customNoTableMsgfalse
disabledfalse
enabledInEditorfalse
globalFilterfalse
id1711392482021_1317977766
order1,2,0
hideControlsfalse
inversefalse,false,false
columnAvailable Data Formats if Delivery Format is Email,Available Data Formats if Delivery Format is Amazon S3
disableSavefalse
separatorPoint (.)
labelsAvailable Data Formats if Delivery Format is Email‚Available Data Formats if Delivery Format is Amazon S3‚Advanced Delivery Option
ddOperatorAND,AND
userfilterAdvanced Delivery Option
datepatterndd M yy
updateSelectOptionsfalse
worklog365|5|8|y w d h m|y w d h m
isORAND


Advanced Delivery OptionDescriptionAvailable Data Formats if Delivery Format is EmailAvailable Data Formats 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,

Visualization,

CSV,

XSLX,

JSON - Simple,

Text,

HTML

CSV,

XSLX,

JSON - Simple,

Text,

HTML


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,

Visualization,

CSV,

XSLX,

JSON - Simple,

Text,

HTML


N/A

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,

CSV,

XSLX,

JSON - Simple,

Text,

HTML


CSV,

XSLX,

JSON - Simple,

Text,

HTML


Table resolution

Option is only available if Data Format is Visualization

Select the width of the visualization:

  • Normal: 800 pixels

  • Wide: 1680 pixels

Visualization

N/A

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,

CSV,

XSLX,

JSON - Simple,

Text,

HTML


CSV,

XSLX,

JSON - Simple,

Text,

HTML


Timezone

Option is only available when scheduling a recurring delivery








Select the time zone that a recurring delivery is sent in.

By default, the selected time zone is the time zone of the OneStrata enterprise or user.





Data Table,

Visualization,

CSV,

XSLX,

JSON - Simple,

Text,

HTML


CSV,

XSLX,

JSON - Simple,

Text,

HTML





...