OneStrata DW/A Changelog

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.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

Release	Platform	Change Type	View Name	Description
25.10.7	Analytics	Added	Campaign	Added 2 fields External Id Group External Id
25.10.7	Data Warehouse	Added	CAMPAIGN	Added 2 fields EXTERNAL_ID GROUP_EXTERNAL_ID
25.5.20	Analytics	Added	Delivery	Added 3 fields to the Delivery view: Billable Cost Payable Cost Currency
25.5.20	Data Warehouse	Added	DELIVERY	Added 3 fields to the DELIVERY view: BILLABLE_COST PAYABLE_COST CURRENCY
25.4.22	Data Warehouse	Added	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.22	Analytics	Added	Ad 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.25	Analytics	Added	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.25	Analytics	Removed	Supplier	Removed 1 field from the Supplier view: Media
25.2.25	Data Warehouse	Added	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.25	Data Warehouse	Moved	AD_UNIT, MEDIA_LINE_METRICS	Moved NUMBER_OF_UNITS from the AD_UNIT view to the MEDIA_LINE_METRICS view
25.1.14	Analytics	Removed	Campaign, Order	Removed 1 field from the Campaign view: Budget Currency Name Removed 1 field from the Order view: Approval External Reference
25.1.14	Data Warehouse	Added	DELIVERY	Added 1 field to the DELIVERY view: DELIVERY_SOURCE
25.1.14	Data Warehouse	Removed	CAMPAIGN, ORDER_DETAIL	Removed 1 field from the CAMPAIGN view: BUDGET_CURRENCY_NAME Removed 1 field from the ORDER_DETAIL view: APPROVAL_EXTERNAL_REFERENCE

Content

Space Tools

Provide feedback on this article