Data Management
Understanding Kwanzoo’s
TotalConnect
Total Connect is a data upload method that allows you to upload any flat file into the system and into the Kwanzoo lead and account-based data model.
TotalConnect is used when you need to upload data from a source and no API connector exists.
Onboarding Messy Marketing Data
For many brands and agencies, consolidating data, automating reports, and creating marketing dashboards is exhausting. However, Kwanzoo offers tools that can help you gain greater marketing efficiencies and a deeper understanding of customer behavior.
But there is an even bigger opportunity. With the correct training, tools, technologies and processes our GTM platform can help advance your organization's use of data to become an insights-focused business — one of few that uses data, marketing analytics, and insights in a closed, and continuously optimized loop.
Today, there are a number of available data platforms on the market, such as those outlined by Forrester Wave™.
However, as you scale the use of your data across the enterprise, the real challenge quickly becomes one of agile data management and available data connectors.
List of Services
-
Extract, Transform, Load (ETL)List Item 1
Extract, transform, and load are three database operations responsible for moving your data into a common database. Extraction reads the data in the original database; transformation changes the format, so it’s ready for querying and analysis while loading writes the data to your destination database. In the past, this has been the most challenging part of data integration because an error in one step leads to incomplete or inaccurate data throughout. And each system comes with its own set of unique types of problems it can have. That’s why the right technology is vital in the ETL process, so you can focus less on micromanaging the movement of data and have more time to spend on analysis and decision making.
-
Data centralizationList Item 2
Data centralization is the process of getting your marketing data in one centralized location. ETL gets the data all in one place. But, many marketing dashboard tools can centralize data via APIs. To harmonize your data, your platform will need to have a data model that blends your data. Advances in machine learning have made this business user-friendly.
-
Data cleansingList Item 3
Data cleansing is the act of correcting or moving inaccurate, broken, or erroneous data from your dataset. Think of this as giving your data a makeover; if you’ve ever fixed misspelled or mashed together field names in a spreadsheet, congrats! You’ve cleansed data.
-
Data normalizationList Item 4
Data normalization and harmonization can be used interchangeably. Both imply making the fundamental aspects of your data all the same.
-
Classifications
Classifications are the field names in your data, or in simplest terms, they're the titles at the top of columns. These help you segment your data, filter it and drill in or zoom out (e.g., from a global view of a campaign down to a specific city). The naming conventions used to describe your data can surprisingly vary significantly across your marketing tools and teams– even when referring to the same concepts. For instance, the same campaign might be titled "SS17_ProductA" on Facebook and "Summer2017-Product_A" on YouTube. Getting these rolled up into one campaign requires harmonization to resolve the classification issue.
Furthermore, harmonization will allow you to connect that campaign across the entire customer journey through your website and CRM. Sometimes your data will not contain the classification you want. Still, luckily, with harmonization, new classifications or dimensions can be added to your centralized data model as well, such as creating the region “Europe” from all of your data’s European country classifications. This is handy when you need to slice and dice your marketing investments or performances in new ways without requiring any changes to how your systems or teams label your data.
