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