Table of Contents


Overview

This page contains a description of the predefined reports provided by OneStrata:

Order Detail Reports

There are three order detail reports that summarize order costs, by month and entity (Agency, Supplier, or Client):

  • Agency Summary (Order Detail Report - Summary by Agency by Month)
  • Supplier Summary (Order Detail Report - Summary by Supplier by Month)
  • Client Summary (Order Detail Report - Summary by Client by Month)

Columns 

The order detail reports have the following columns:

Predefined ReportField TypeColumn Name
Agency SummaryDimensionAgency Name
Supplier Summary

Dimension

Supplier Name

Client Summary

Dimension

Client Name

Agency Summary,

Supplier Summary,

Client Summary

DimensionMedia Name

Agency Summary,

Supplier Summary,

Client Summary

DimensionCampaign ID

Agency Summary,

Supplier Summary,

Client Summary

DimensionCampaign Name

Agency Summary,

Supplier Summary,

Client Summary

MeasureClient Gross Amount (CC)

Agency Summary,

Supplier Summary,

Client Summary

Measure

Client Net Amount (CC)

Agency Summary,

Supplier Summary,

Client Summary

Dimension

Year (pivot, ascending sort)

Agency Summary,

Supplier Summary,

Client Summary

Dimension

Month (pivot, ascending sort)

Filters 

All of the order detail reports can be filtered using the following dimensions:

  • Agency Name
  • Client Name
  • Media Name
  • Supplier Name
  • Campaign ID
  • Campaign Name
  • Campaign Created Date
  • Year

Order Summary Report

The Order Summary report is a general summary of order- and Cost Line-level details, across all campaigns.

Columns

The Order Summary report has the following columns:

Field TypeColumn Name
DimensionAgency Name

Dimension

Client Name

Dimension

Campaign ID

DimensionCampaign Name
DimensionOrder ID
DimensionEstimate External ID
DimensionSupplier Name
DimensionCost Line ID
DimensionCost Line Name
DimensionCost Line Start Date
DimensionCost Line End Date
DimensionCost Category Name
DimensionAd Unit Format Name
DimensionAd Unit Format Dimension
DimensionCost Line Rate Type
MeasureNumber of Units
MeasureClient Net Rate (CC)
MeasureClient Net Amount (CC)
MeasureClient Gross Amount (CC)
MeasureClient Total Amount (CC)

Filters

The Order Summary report can be filtered using the following dimensions:

  • Agency Name
  • Business Unit Name
  • Client Name
  • Campaign name
  • Campaign ID
  • Supplier Name
  • Campaign Start Date
  • Campaign End Date
  • Campaign Created Date