Unified Marketing Schema (UMS)

We've all had the experience of downloading several spreadsheets and trying desperately to combine the data and metrics from different source systems.

It's unavoidable in today's world, but Daasity is here to help minimize it as much as we can!

That's where our Unified Schemas come into play. Unifying data from multiple systems for you, so you can get right to the results & outcomes.

Our Unified Marketing Schema does just that. It takes key metrics that are common across ad platforms and combines them into one table in your data warehouse.

This allows you to easily see your brand's overall spend and effectiveness, as well as vendor by vendor. 

Need a report for Monday morning meeting of last week's performance? This helps you get it, no downloading required.

What Data is ingested into UMS?

Attribute Source
Spend Ad platform integration API or Marketing BSD sheet
Clicks Ad platform integration API
Impressions Ad platform integration API
Vendor Reported Orders Ad platform integration API
Vendor Reported Revenue Ad platform integration API
Campaign

Ad platform integration API

Adset

Ad platform integration API

Ad ID

Ad platform integration API

Ad Description

Ad platform integration API

Ad URL Ad platform integration API
Vendor

Ad platform integration API or Marketing Spend and Channel Mapping BSD Sheets

Channel

Channel Mapping BSD Sheet

Sub-Channel Channel Mapping BSD Sheet
 Media Type Channel Mapping BSD Sheet
Property Ad platform integration API
Network type

Ad platform integration API

Attribution Window

Ad platform integration API

First Click Orders/Sales/Gross Margin

GA and Channel Mapping BSD Sheet, SKU Cost via Shopify or BSD Sheet, Sales via Order Source System

Last Click Orders/Sales/Gross Margin

GA and Channel Mapping BSD Sheet, SKU Cost via Shopify or BSD Sheet, Sales via Order Source System

New Customer Orders/Sales Determined if customer placing order already exists in your house file from any order source system

**Important Tip**

Not all ad platforms deliver the same information via their API connections, therefore some attributes above will be null for some vendors.

Using this information as well as GA data and channel mapping rules, the following metrics are calculated automatically.

Cost per Order (CPO The cost in marketing spend divided by total orders received.
Cost per Acquisition (CPA);  The cost in marketing spend divided by the total orders from NEW customers, as determined by Daasity's householding model. This can also be referred to as Cost per New Customer.
Return on Ad Spend (ROAS) The total revenue divided by the total marketing spend.

How To Find It

UMS happens behind the scenes in the code that powers your data model. You can find the data in the Marketing Performance Explore and Dashboard.

What Ad Platforms Are In UMS?

Check out the integrations page of our website for the latest and greatest info on data sources we extract from.

ERD (Entity Relationship Diagram)

More Info

Find more detailed technical information about transformation here.

Need to migrate to Daasity 2.0? Contact us for details at support@daasity.com