What is the Difference Between Raw and Fused Data?
In Fusion, there are two layers to your data within the warehouse. There is the Raw data and the Fused data and below we go over what each layer contains and the importance it plays in analyzing your data.
For each system you connect to your Fusion account, there are a set of objects and fields that we can see and read from the system. When we first start to pull out the data from each system, we are building this Raw dataset.
In this Raw dataset you'll find all records and all fields for the objects that are supported for the given system. For example, if we support reading Contact records from a given marketing system, then all contacts in that marketing system along with all of the fields tied to those records where values are present will get fed down into the Raw dataset. At this layer, the data is still siloed within each given system and no relationships have been made across the connected systems.
Once the Raw dataset has been created, the next layer is the Fused layer. This is where we do a few key processes:
- Find related records across each system and Fuse them together as one unique record (i.e. email@example.com in my CRM and firstname.lastname@example.org in my Marketing Automation system is seen as 1 record in this layer).
- Find the field data based on your mappings to build the Fused records dataset as well as
- Find the relationships and apply them to the Fused record so that we know what other records across each system should be seen as associated with the Fused record.
The last point is perhaps one of the most important aspects of the Fused dataset. The relationships allow an analyst to build complicated reports across their entire dataset with more flexibility than what is often afforded him or her within the systems where data originates.
Lets take a quick look at what this might look like once you feed in your Fused database into your favorite BI Tool. Below is a screen shot taken from Amazon QuickSight. In this example we are pointing out where the Fused Company records live and where the Raw Company records live for our Dynamics CRM.