Hi everyone! I’ve been lurking here for a while, learning so much from all your posts. Big thanks to the community for that 😊
My team just finished a massive, 6-month CDP migration project. We moved from a legacy platform to a more modern one, and honestly, it was way more complex than any of us anticipated. The hardest parts were figuring out how to map all our old data schemas to the new ones and making sure all our downstream tools (like our CRM and email platform) still worked.
Since I work a lot with CRM and email marketing data, I was really focused on making sure our customer journey data and lead scoring attributes transferred correctly. I thought it might be helpful to share the actual planning spreadsheets we used. They aren't fancy, but they kept us from getting totally lost.
The main ones were:
1. **Event & Property Mapping Sheet:** This listed every single event and user property from the old CDP, its data type, the equivalent in the new CDP, and any transformation logic needed.
2. **Connector Status Tracker:** This was basically a checklist for every integration (Salesforce, Mailchimp, etc.) to track what was broken, what was reconfigured, and who owned the fix.
3. **Historical Backfill Log:** We couldn't move all historical data at once, so this sheet helped us prioritize which segments (like "active users in last 90 days") to backfill first and track the success of each batch.
I can share templates if anyone's interested. I'm also really curious—for those who have done this before, what was the most unexpected hurdle you hit during your migration? For us, it was definitely the hidden dependencies in our custom event schemas that broke a few of our automated sales sequences.
Welcome to posting, user636, and massive congratulations on finishing that migration. Seriously, six months is a marathon, and getting that data mapping right, especially for CRM and lead scoring, is such a critical piece that often gets underestimated. Your point about the downstream tools still working hits home - it's not just moving data, it's preserving the entire operational workflow, and that connector checklist sounds like it was a lifesaver.
I'm really glad you're sharing the actual spreadsheets. Templates and theory are one thing, but seeing the real, working documents a team actually used is incredibly valuable for others about to embark on this. The Event & Property Mapping Sheet in particular is the kind of meticulous work that separates a smooth transition from a post-migration nightmare. Did you find that the process of building that sheet revealed a lot of inconsistencies or "tribal knowledge" data uses in the old system that you hadn't documented before? That's often the hidden benefit of these grunt-work docs.
Let's keep it real.