Creator Agency CRM Migration: A Practical Checklist
Move your creator agency workflow into a CRM with a field map, a controlled pilot, reconciliation checks and a realistic rollback plan.
Moving an agency into a CRM is not finished when the new dashboard contains names. The real test is whether a teammate can see the latest context, find an outstanding commitment and know what to do next without consulting three other tools. A migration that loses those details can look tidy while making daily operations worse.
This checklist is for planning a controlled move from spreadsheets, scattered notes or another workspace. It does not assume every platform offers an export or that Substy can import every historical field. Confirm supported connections and transfer methods before selecting a cutover date. Never scrape private data or bypass a platform restriction to fill a gap.
Define success before exporting anything
Write a short acceptance statement. For example: every active creator has an owner; unresolved commitments remain visible; approved offers are accessible to the right people; and the team can continue a conversation without repeating a resolved question.
Separate essential information from historical material that is merely convenient. A current commitment matters more than a duplicate note from six months ago. Decide how long older records are needed and who is allowed to access them. Minimize the personal data you move rather than copying everything by default.
The agency SOP checklist helps identify the workflows you need to preserve. Migration should support those workflows rather than introduce a new set of labels without a purpose.
Make a field map with explicit gaps
List each source field, its meaning, its destination and what happens when there is no supported destination. Two columns named “status” may describe entirely different things. One might mean subscription status; another might mean the next task in the team's queue.
| Source information | Decision to document | Acceptance check |
|---|---|---|
| Account identifier | Which stable identifier links the record? | Correct account, no ambiguous name matching. |
| Current owner | Who owns the next action? | Owner exists and has appropriate access. |
| Open commitment | Where are scope and due date recorded? | Team can find and complete the obligation. |
| Tags and notes | Which labels are still actionable? | Meaning preserved, duplicates removed. |
| Historical metrics | Are definitions and timezones compatible? | Totals reconciled or differences explained. |
Use an “unsupported” status where needed. A documented limitation is better than a silent substitution. If an export omits conversation history, do not present an imported contact list as a complete conversation record. Keep an authorized, access-controlled reference where appropriate and make the limitation visible to the team.
Choose one small pilot
Select an account with enough real variation to reveal problems, but not your most complex workload. Include a new fan, a repeat buyer, an inactive conversation and an unresolved request. Use fictional or minimized sample data when testing a format before handling live records.
Before the pilot, confirm who can export, who can import and who can view the result. Do not email raw exports around the team. Use the approved storage location, restrict access and define when temporary copies will be removed. Keep credentials out of spreadsheets and migration notes.
- STEP 01MapDefine fields and owners
- STEP 02PilotTest one limited account
- STEP 03ReconcileCheck meaning and counts
- STEP 04SwitchKeep a rollback path
Give one person responsibility for the migration log. Record the time of each export or connection, the scope included, the checks performed and any unresolved gap. The log is what lets you distinguish a missing field from a record changed during the move.
Reconcile meaning as well as totals
Start with counts: expected records, transferred records, skipped records and duplicates. Then inspect samples. A matching record count can hide shifted columns, merged identities or notes attached to the wrong account.
Use a reconciliation sheet with one row per issue. Record the expected value, observed value, cause, owner and resolution. Do not overwrite the source simply to make the totals agree. If historical revenue uses a different timezone, currency or refund treatment, document that difference before comparing dashboards.
Suppose a source has 120 active records, while the destination shows 117. The correct response is not to add three anonymous rows. Identify whether those records were duplicates, outside the supported scope or missed by the transfer. Resolve each case and have the operating owner sign off. This example is illustrative, not an acceptable loss threshold.
Review the KPI definitions before using a new dashboard to judge staff performance. A change in calculation can look like a performance change even when behavior is unchanged.
Rehearse the handoff before cutover
Ask a teammate who did not build the migration to perform three tasks: identify an outstanding commitment, find the latest relevant note and assign the next action. Watch where they hesitate. Fix the field definitions or training, not just the interface.
For each active shift, name the system of record. Running two writable workspaces indefinitely creates conflicting notes and duplicated follow-up. A short parallel check may be useful, but define exactly which system owns new updates and how those updates will be reconciled.
Use the creator onboarding checklist to confirm permissions and responsibilities. Moving software does not remove the need for the creator to approve the account's operating rules.
Write the rollback plan while everything is calm
List the conditions that would pause the move: records attached to the wrong account, missing outstanding commitments, access failures or an inability to continue normal work. Assign the person who can make that call. A rollback is a controlled response, not an admission that the project failed.
Preserve an authorized source snapshot and the migration log. If work continues after cutover, those new actions need reconciliation before reverting. Otherwise a rollback can lose the very conversations you intended to protect. Do not disconnect the old workspace until you understand how access and data retention will change.
Where Substy fits in the move
Substy's CRM brings fan context and team performance into a shared workspace. Confirm the account connection, supported history and transfer options with the product before committing to a particular import method. This checklist does not promise a universal one-click import.
After the core workflow is stable, evaluate additional features such as fan memory and personalized scripts. Moving the CRM and changing every conversation process on the same day makes it harder to identify the cause of a problem.
The first week after the switch
Review a small sample daily: duplicated notes, missing owners, unanswered questions and pending commitments. Ask the team which fields they actually use. Retire redundant labels only after confirming they are not supporting an important exception.
At the end of the week, compare the acceptance statement with actual work. The migration is complete when the team can reliably carry the context forward and the remaining limitations are documented. A clean dashboard is a welcome side effect, not the definition of success.
Frequently asked questions
Can every historical field be moved into Substy?
Do not assume so. Confirm the current connection and import options, and document unsupported fields before planning the move.
Should we copy all old notes?
Move only relevant information you are authorized to retain and transfer. Define retention and access for historical records separately.
How do we avoid duplicates?
Use a stable account identifier, document matching rules and reconcile counts and samples. A display name alone may be ambiguous.
Can we keep both tools running?
A short controlled comparison can help, but name one system of record for new updates and define how changes are reconciled.
When is it safe to remove the old workspace?
After acceptance checks, unresolved obligations and rollback requirements are addressed, and after confirming the provider's retention and access consequences.




