Data Audit Checklist: 7 Sources to Map Before You Choose a CDP

Many businesses consider a Customer Data Platform (CDP) as the solution to their fragmented customer insights. However, rushing into a CDP implementation without first understanding your existing data landscape is a common pitfall. It's like trying to navigate a new city without a map – you might have a powerful car, but you won't know where to go. Before you even speak to vendors, a thorough customer data audit checklist is essential to prevent costly mistakes and ensure your CDP investment truly delivers value.

For this activity, we encourage you to meticulously list all the different data sources your business currently uses. This includes both your online and offline channels, providing a holistic view of how customer information flows into your organisation. This foundational step will illuminate your data strengths and expose critical gaps.

Why a Data Audit is the Most Important First Step

Imagine purchasing a state-of-the-art vehicle without knowing how to drive, or even if you have roads to drive on. That's often the scenario when businesses invest in a Customer Data Platform without first conducting a rigorous data audit. A CDP is designed to unify customer data, but it can only do so effectively if you know what data you have, where it lives, and its quality.

This initial audit isn't just about listing sources; it's about understanding the journey of your customer data. It helps you identify redundant data, inconsistent formats, and privacy compliance issues before they become major roadblocks. By completing this task, you'll be able to pinpoint areas where your data might be fragmented or incomplete. This proactive approach allows you to take the first steps towards creating a more unified and complete customer profile, which is the ultimate goal of any CDP.

The Data Audit Checklist (Online Sources)

Your online presence is a rich source of customer interactions. Mapping these digital touchpoints is critical for understanding user behaviour and preferences. As mentioned, websites, mobile apps, social media, and email campaigns are prime examples of your online data sources. Here’s a checklist to guide your audit:

1. Website Analytics (e.g., Google Analytics, Adobe Analytics)

• What data points are currently tracked? (e.g., page views, time on site, bounce rate, conversion events, user demographics, traffic sources)
• Are unique user IDs consistently captured? If so, how are they generated and stored?
• What is the data retention policy? How far back can you access historical website data?
• Are there multiple websites or subdomains? How is data consolidated (or not) across them?
• What consent management platform (CMP) is in place? How does it impact data collection?

2. Mobile App Interactions

• What user actions are tracked within the app? (e.g., app opens, feature usage, in-app purchases, session duration, push notification engagement)
• How are users identified across sessions and devices? Is a consistent user ID used?
• What data is collected upon app installation and registration?
• Are there separate analytics tools for iOS and Android? How is this data unified?
• What permissions does your app request from users? How does this affect data availability?

3. Social Media Engagement (e.g., Facebook, Instagram, LinkedIn, X)

• Which platforms do you actively use for marketing and customer service?
• What data do you extract or receive from these platforms? (e.g., follower demographics, post engagement, comments, direct messages)
• How do you link social media interactions to individual customer profiles? (e.g., through lead forms, ad clicks)
• Are you using social listening tools? What data do they collect and how is it stored?

4. Email Campaigns (e.g., Mailchimp, HubSpot, Salesforce Marketing Cloud)

• What customer data is stored in your Email Service Provider (ESP)? (e.g., email addresses, names, segments, open rates, click-through rates, unsubscribe reasons)
• How are new subscribers added? (e.g., website forms, lead magnets, offline sign-ups)
• Is there a consistent unique identifier for subscribers across systems?
• What is the history of customer email interactions available?

The Data Audit Checklist (Offline & System Sources)

While online data often gets the spotlight, offline interactions provide invaluable context to the customer journey. Your offline sources can include in-store purchases, call centers, and even direct mail responses. Bridging the online-offline data gap is where a CDP truly shines, offering a complete 360-degree view of your customer. Here are the key areas to examine:

5. In-Store Purchases / Point of Sale (POS) Systems

• What customer identifiers are collected at the point of sale? (e.g., loyalty card numbers, phone numbers, email addresses, payment methods)
• What transaction data is captured? (e.g., products purchased, quantity, price, date, time, store location)
• How are returns and exchanges handled? Is this data linked to the original purchase?
• Is there a loyalty program? How is its data stored and linked to customer profiles?
• How is this data currently connected to online customer profiles, if at all?

6. Call Center Logs & Customer Service Interactions

• What customer data is recorded during calls? (e.g., caller ID, reason for call, call duration, resolution, agent notes, sentiment analysis)
• Is there a system for tagging or categorizing call reasons?
• How are customer identities verified and linked to existing profiles?
• What data is captured from other customer service channels? (e.g., live chat, support tickets)
• How long are call recordings and logs retained?

7. CRM (Customer Relationship Management) System

• What customer attributes are stored in your CRM? (e.g., contact information, company details, lead source, sales stage, interaction history, support tickets)
• How is data entered into the CRM? (manual entry, integrations, web forms)
• What is the quality and consistency of data across different CRM users?
• Are there custom fields? What purpose do they serve?
• How does the CRM data integrate with other systems?

Understanding your CRM data is especially important as it often serves as a central repository for sales and service interactions. For Indian startups looking to streamline their customer journey and build a strong foundation, ensuring data consistency across platforms, including CRM, is vital. You might find our Brand Identity Checklist for Indian Startups helpful in thinking about consistent messaging across all touchpoints.

Categorizing Your Data: First-Party vs. Third-Party

After mapping your data sources, the next step is to understand the nature of the data you've collected. This typically falls into two main categories:

• First-Party Data: This is the data you collect directly from your customers through your own channels. Examples include website analytics, mobile app interactions, email sign-ups, purchase history from your POS, and CRM entries. It's the most valuable data because it's proprietary, accurate, and reflects actual interactions with your brand.
• Third-Party Data: This is data collected by entities that don't have a direct relationship with the customer and is often purchased from external sources. While it can provide scale and broader audience insights, its accuracy and relevance can be questionable, and its future is increasingly challenged by privacy regulations.

As you review your audited sources, classify each one. Prioritising and enriching your first-party data should be a core focus, as it forms the bedrock of a truly effective CDP strategy. A strong understanding of your customer's journey, built on this data, can also inform your brand story framework, ensuring your messaging resonates directly with their experiences.

You've Mapped Your Data. Now What?

Completing this data audit checklist is a significant achievement. You now have a clearer picture of your current data landscape, identifying where your data resides and how it's collected. This exercise isn't just about listing sources; it's about revealing the health and completeness of your customer profiles. You might notice common gaps, such as extensive online behavioural data but very little linked to offline purchases, or scattered data across multiple, unconnected systems.

The next step is to interpret these findings. Look for:

• Data Silos: Where is customer data isolated and not shared across departments or systems?
• Inconsistent Identifiers: Are customers identified differently across various platforms (e.g., email in one system, phone number in another, loyalty ID in a third)?
• Missing Data Points: Are there critical pieces of information you need about your customers that you aren't currently collecting?
• Data Quality Issues: Is the data accurate, up-to-date, and free from duplicates?
• Privacy Compliance: Are you collecting and storing data in adherence to relevant regulations?

This detailed understanding of your data landscape is the true preparation for CDP implementation. It allows you to define clear objectives for a CDP, articulate your specific needs to vendors, and ultimately create a more unified and complete customer profile. To further your understanding of how to effectively manage and utilise this valuable asset, consider Juno School's free certificate course on leveraging customer data platforms, which offers deeper insights into building a strong data strategy.