Designing a Data Architecture System for Success with The University of Chicago

We partnered with ITM and created a new data architecture system in order to more effectively understand user activity, and how ITM could best serve their needs.

Client

The University of Chicago Institute for Translational Medicine connects researchers and community organizations with funding, education and resources to find effective ways to prevent and treat disease in real-world settings. ITM works with a consortium of 60 institutions toward advancing medicine in innovative ways, and its mission is to develop, test, and implement the most effective personalized therapies.

The Problem

Since ITM serves many segments of the medical community, including researchers, educational leaders and the general public, it became a challenge to efficiently capture and categorize varying user data sets as they scaled. Because of this, they were spending too much time manually editing information and segmenting their CRM and marketing automation platform. Finally, they were preparing for the launch of a separate research campaign, which included a new website as well as additional use cases for contact interaction.

Too Much Data to Manage
Limited Bandwidth to Manage Technical Platforms
Complex Use Cases for Users Engagement

The Solution

We completed an audit of the historical data within ITM’s Salesforce and Pardot platforms and evaluated the current process related to their form submissions and list management. Additionally, we conducted collaborative work sessions so that we fully comprehended ITM’s unique audience along with the ways in which they could be categorized. Using that knowledge, we mapped out a new data architecture and pragmatically updated and tested ITM’s Salesforce and Pardot fields, values and sync settings, along with creating new Pardot automations and rules. Leveraging the new framework, we executed a series of data migration exercises to correct outdated historical data and put in measures to align with future campaigns and activities.

Contact Us

The Outcome

The work allowed us to bring clarity towards ITM’s database and process for segmented future communication. Using the new structure, ITM was now able to deliver unique content for specific user needs, and have a greater line of sight towards how those users were engaging with their resources.

The Tools

No items found.

Why Aptitude 8?

ITM tasked Aptitude 8 with this project because of our vast knowledge with leading platforms like Pardot and Salesforce, as well as our experience in dealing with large data sets and data architectures. “The whole Aptitude 8 team was incredibly patient and helpful as they walked us through Salesforce and the plan of action. Our awesome consultant Bryan made Salesforce usable for us, and was so great at executing and communicating deliverables and teaching us how to use the platform effectively.” - Kathleen Ferraro, Senior Science Communications Specialist