Skip to content

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.

  • data-1

    Too Much Data to Manage

  • 5f21777d5768ceafaa42649e_use_cases_users

    Complex Use Cases for Users Engagement

  • scaling pain

    Automation

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

sales-force-logo
sales-force-logo

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

Partner with Aptitude 8

We're good at solving problems and would love to solve
yours.

contact details