Changelog entries from before the 25.10.7 release may be incomplete.

This page records changes to the OneStrata Analytics and Data Warehouse data dictionaries.

ReleasePlatformChange TypeView NameDescription
25.10.7AnalyticsAddedCampaign

Added 2 fields

  • External Id
  • Group External Id
25.10.7Data WarehouseAddedCAMPAIGN

Added 2 fields

  • EXTERNAL_ID
  • GROUP_EXTERNAL_ID
25.5.20AnalyticsAdded

Delivery

Added 3 fields to the Delivery view:

  • Billable Cost
  • Payable Cost
  • Currency
25.5.20Data WarehouseAdded

DELIVERY

Added 3 fields to the DELIVERY view:

  • BILLABLE_COST
  • PAYABLE_COST
  • CURRENCY
25.4.22Data WarehouseAdded

ORDER_DETAIL

Added 11 fields to the ORDER_DETAIL view:

  • CLIENT_GROSS_RATE_AC
  • CLIENT_GROSS_RATE_CC
  • CLIENT_NET_RATE_AC
  • CLIENT_NET_RATE_CC
  • CLIENT_NET_RATE_VC
  • VENDOR_GROSS_RATE_AC
  • VENDOR_GROSS_RATE_CC
  • VENDOR_GROSS_RATE_VC
  • VENDOR_NET_RATE_AC 
  • VENDOR_NET_RATE_CC
  • VENDOR_NET_RATE_VC
25.4.22AnalyticsAddedAd Unit

Added conversion rates to the Ad Unit View:

  • If a conversion rate has been used in a least one committed Schedule grid line, it is available in the Ad Unit > Media Line Custom Fields group.
25.2.25AnalyticsAdded

Ad Unit,

Cost Category,

Order

Added 27 fields to the Ad Unit view:

  • Media Line Acquisitions
  • Media Line Actions

  • Media Line Add To Carts

  • Media Line Clicks

  • Media Line Completed Views

  • Media Line Content Views

  • Media Line Conversions

  • Media Line Engagements

  • Media Line Impressions

  • Media Line Landing Page Views

  • Media Line Lands

  • Media Line Leads

  • Media Line Lifts

  • Media Line Likes

  • Media Line Link Clicks

  • Media Line Messages

  • Media Line Number Of Units

  • Media Line Purchases

  • Media Line Reads

  • Media Line Sent In Mails

  • Media Line Swipe Ups

  • Media Line Unique Reach

  • Media Line Viewable Completed Views

  • Media Line Viewable Impressions

  • Media Line Viewable Views

  • Media Line Views

  • Media Line Visits

Added 1 field to the Cost Category view:

  • Channel Group

Added 6 fields to the Order view

  • External Link Id
  • External Link Is Active (Yes / No)
  • External Link Status
  • External Link System Group
  • External Link System Type
  • External Link Type
25.2.25AnalyticsRemoved

Supplier

Removed 1 field from the Supplier view:

  • Media
25.2.25Data WarehouseAdded

COST_CATEGORY,

MEDIA_LINE_METRICS,

ORDER_DETAIL

Added 1 field to the COST_CATEGORY view:

  • CHANNEL_GROUP

Added the MEDIA_LINE_METRICS view, with 32 fields:

  • _ACTIVE_FROM
  • _ACTIVE_TO
  • _IS_ACTIVE
  • ACQUISITIONS
  • ACTIONS
  • ADD_TO_CARTS
  • CLICKS
  • COMPLETED_VIEWS
  • CONTENT_VIEWS
  • CONVERSIONS
  • ENGAGEMENTS
  • IMPRESSIONS
  • LANDING_PAGE_VIEWS
  • LANDS
  • LEADS
  • LIFTS
  • LIKES
  • LINK_CLICKS
  • MEDIA_LINE_KEY
  • MEDIA_LINE_METRICS_KEY
  • MESSAGES
  • NUMBER_OF_UNITS
  • ORDER_KEY
  • PURCHASES
  • READS
  • SENT_IN_MAILS
  • SWIPE_UPS
  • UNIQUE_REACH
  • VIEWABLE_COMPLETED_VIEWS
  • VIEWABLE_IMPRESSIONS
  • VIEWABLE_VIEWS
  • VIEWS
  • VISITS

Added 6 fields to the ORDER_DETAIL view:

  • EXTERNAL_LINK_ID
  • EXTERNAL_LINK_IS_ACTIVE
  • EXTERNAL_LINK_SYSTEM_GROUP
  • EXTERNAL_LINK_SYSTEM_TYPE
  • EXTERNAL_LINK_STATUS
  • EXTERNAL_LINK_TYPE
25.2.25Data WarehouseMoved

AD_UNIT,

MEDIA_LINE_METRICS

  • Moved NUMBER_OF_UNITS from the AD_UNIT view to the MEDIA_LINE_METRICS view
25.1.14AnalyticsRemoved

Campaign,

Order

Removed 1 field from the Campaign view:

  • Budget Currency Name

Removed 1 field from the Order view:

  • Approval External Reference
25.1.14Data WarehouseAdded

DELIVERY

Added 1 field to the DELIVERY view:

  • DELIVERY_SOURCE
25.1.14Data WarehouseRemoved

CAMPAIGN,

ORDER_DETAIL

Removed 1 field from the CAMPAIGN view:

  • BUDGET_CURRENCY_NAME

Removed 1 field from the ORDER_DETAIL view:

  • APPROVAL_EXTERNAL_REFERENCE