Skip to content

Data Migration Philosophy

GrowthZone strongly supports industry data management thought leaders, such as Wes Trochlil, that when switching AMS providers, "Convert the absolute minimum amount of data possible." To read more of Wes' thoughts on "Less is Best" click here.

Data Migration Options and Details

GrowthZone offers two options for populating your GrowthZone database with your current data:

  1. Basic Data Import  (RECOMMENDED) -- designed for those organizations choosing to "start fresh" on a new AMS or those not using an AMS currently.
  2. Specialized Vender Migration -- designed for those organizations choosing to elongate their onboarding timeframe by migrating their data from another AMS into GrowthZone

Intended for those associations that desire to follow industry Best Practices for migrating to a new AMS and start with a defined set of organization and/or individual contacts.  Simply export your data from your existing AMS and paste it into our pre-defined templates. (See below.) We also provide additional mapping tools for those challenged with converting their data to our pre-defined templates. Data migration into an initial Staging database occurs 24 hours after data receipt. Upon validation, you can be up and running in the least amount of time with our stream-lined process.

The following general guidelines can assist you in determining if this is the best fit for your data migration:

  • Contains one record per contact and connection to an organization
  • Add-in Tags, directory Categories, and/or Custom fields for each contact.
  • One membership per file. May add additional files for each membership.
  • Invoices, Payments, Chapters, logos, images are not included.

You will be able to review your data in two stages: Initial Review and a Revision. Upon confirmation, your data will be uploaded to a Production database for you to be up and running with GrowthZone!

Additional reviews may be purchased for $1000. Any updates to your data once it is in Production may incur additional fees - $175/hour. GrowthZone utilizes a "Rule of 200" when determining whether data should be modified manually by our customers or through SQL by our Customer Support team -- 200 or less rows of data is typically handled through manual updates.

What is included in the Basic Data Import?

The following information will be available in the individual and/or organization spreadsheet templates.

  • Individuals, Organization, and their Relationship: Individual Name, Title, and association to Organization. Organization Name.
  • Membership Information: Single membership per contact record. Includes member join date and renewal information.
  • Account Numbers: One unique ID per contact record.
  • Contact Information: Addresses (up to 2 per contact), Phone Numbers, Email Addresses, Websites, and Social Sites.
  • Categories, Custom Fields, and Tags: Unlimited Categories, Custom fields, and Tags. View our knowledge base article for more information on when to use each of these.
  • Primary and Billing Contacts: Ability to set these roles.
Some examples of data that is not included, would be: Historical billing, open balance, and parent/child relationships.

The following data will be manually entered by the customer during the onboarding process:

  • Fee Items
  • Open Invoices (optional supplemental import available for purchase)

The GrowthZone Cloud can be leveraged for quick reference of other data elements exported from your prior AMS.

To start your migration process, download our BDI templates and review the below videos:

Additional Data Import Options available at an extra cost could include:

Invoices or Payments    

  • Ability to import open invoices, as well as invoices and payment history. The standard BDI does not include financial information.
  • Use case: Association has 320 open invoices at the time of implementation and would like the ability for their members to pay via GrowthZone.  Note: Not intended to bring in years of historical transactions. This import will NOT create accounting transaction records.
  • Example: Importing Open Invoices
  • When the original invoice was created, the necessary accounting entries were made in your accounting software. Since this tracking has already occurred, importing these open invoices into GrowthZone will not generate this accounting transaction. However, when a payment is received in GrowthZone, the transaction will be recorded, debiting the deposit account and crediting accounts receivable.

Standard Membership 

  • Ability to assign multiple membership types to a single contact record. The standard BDI only accommodates one membership per contact.
  • Use case: An association that has multiple membership types per member (i.e. Chapter Membership and a State Membership).

Detailed Membership  

  • Ability to assign not only multiple membership types to a single contact record, but this supplemental includes the ability to set membership billing frequency. The standard membership supplemental does not accommodate the membership billing frequency.
  • Use case: Similar to the standard but allows for members to have different billing durations or frequency’s for the same membership type. (i.e. member A pays annually; member B pays monthly)

Lists and Committees   

  • Ability to account for Start and end date, as well as role assignments. The List/Committee import within the product does not account for this additional criteria.
  • Use case: Association would like to import contacts into a list including their role within the list/committee.

Additional Addresses

  • Ability to add additional addresses on a per contact bases. The standard BDI only accommodates one individual address and two organization addresses per contact.
  • Use case: Association would like to import additional addresses or assign usage for specific contacts.

Additional Phones

  • Ability to add additional phone numbers on a per contact bases. The standard BDI only accommodates work, home, cell and fax per individual and main, other, tollfree and fax per organization contact.
  • Use case: Association would like to import additional phone numbers or assign usage for specific contacts.

 Additional Emails

  • Ability to add additional email addresses on a per contact bases. The standard BDI only accommodates work, personal and other per individual and work, personal and other per organization per contact.
  • Use case: Association would like to import additional email addresses or assign usage for specific contacts.

Store    

  • Ability to import large number of store products vs manually adding one by one.
  • Use case: Association has many store products they need created within their database.

Fundraising       

  • Ability to import historical donation activity.
  • Use case: An association may be transitioning to GrowthZone mid-year and want to track a full year worth of donations.

Historical Certifications

  • Ability to import completed certification/component details.
  • Use case: The association receives a list of members who completed a course (outside of GrowthZone) and need to show the certification/ component completion within their database/member portal.

Events 

  • Ability to import basic event details in mass. This includes Event Name, Description, Start Date and time, End Date and time, Contact Description, Contact Email Address, Contact Phone, Address 1, Address 2, City, State, Postal Code, Website
  • Use case: An association has many events already created and would like to mass import the main details for the events, this does require additional setup for each event loaded. i.e. registration types, images, registration details, discounts, etc.

Chapters             

  • Ability to assign chapters in mass. The standard BDI does not include chapter assignments.
  • Use case: National association may need to know which local board each member is with. The local association would be setup as the chapter and then assigned to the member through this import.

Contacts             

  • Ability to add new contacts or add new details for existing contacts: Phone, Email, Website, Social, Addresses, Categories, Custom Fields, Tags, etc.
  • Notes: This is only a post-production option, using BDI Templates. The Contacts Import Tool works similar, however it does not bring in Organization details
  • Use case: Association may have additional organizations or individuals they would like to add at a later date

Documents and Files    

  • Ability to import documents/logos/files onto a contacts record or into the resources module.
  • Use case: Association has extensive library of member facing resources and would like them imported in mass vs one by one.
  • Note: A discussion with GrowthZone’s migrations team and the customer is required to ensure GrowthZone is able to import the documents.  As there are multiple ways GrowthZone can receive the data:
    • Actual physical data files
    • URL (has to be public) - i.e. database backup, website backup, excel file with list of URLs etc.
    • Fields available if loading into Resources: title, description, file, URL, publish start date, publish end date, categories, and folders.

Specialized Vendor Migrations are for those customers that are willing to add additional time and energy to their onboarding timeframe in order to migrate their existing AMS data into GrowthZone rather than save prior-AMS reference data in the GrowthZone Cloud. We will leverage our experience with known AMS and industry-specific sources to migrate your current systems’ data into GrowthZone. This option will allow you to review your migrated data (in a Stages database) before migrating to Production.

  • Key to your success will be the definition of your Membership Types, Levels, Billing, Rules. Not all other systems define Membership the same was as GrowthZone – they may use billing codes, member types, etc. Our guided process will help you achieve success with migrating this information to GrowthZone.
  • We have built a set of standard business rules for how the data is mapped and migrated into GrowthZone based on your data sources.

Data Review

You will be able to review your data in three Staging databases prior to the Final Production step. In between each stage, you will work with your Onboarding Project Manager to validate your data and review key elements of GrowthZone configuration. Additional staging database reviews may be purchased for $1,000 each. GrowthZone utilizes a "Rule of 200" when determining whether data should be modified manually by our customers or through SQL by our Customer Support team -- 200 or less rows of data is typically handled through a manual process.

Stages:

  • Preview based on initial consultation of pre-defined options.
  • Data consultation with data specialist to further refine the established rules *if needed.
  • Stage 1
  • Stage 2
  • Stage 3
  • Stage 4
  • Stage 5
  • Additional: $1,000

Data sources include:

  • CC Assist
  • MS Dynamics 365
  • Goldmine
  • Membee
  • NetForum
  • SalesForce
  • WebLink
  • YourMembership

REALTOR-SPECIFIC - MLS:

  • CoreLogic/Matrix
  • FlexMLS
  • StellarMLS
  • Black Knight/Paragon

REALTOR-SPECIFIC - LockBox:

  • Supra
  • SentriLock

The below groups of data will be migrated in Custom Data Migrations:

  • Organization Contacts
  • Individual Contacts
  • Membership
  • Communication
  • Lists/Committees
  • Directory Listing
  • Logos/Images/Documents
  • Custom Fields
  • Billing
  • Events
  • Sponsors/Ads

The below data will not be migrated in Custom Data Migrations:

  • Sensitive Personally Identifiable Information (PII) such as (but not limited to) Taxpayer Identification Numbers (TIN), SSN (Including Last 4)
  • Sales Opportunities
  • Projects/Tasks
  • Activity Log

Key Data Migration details:

You will provide us two sets of data:

  1. An initial set for use in the Staging Review Process
  2. A final data set for use in the Final Migration to Production

*Please be aware that some AMS vendors charge for database backups.

Details by data area for: 

Organization Contacts – name, contact information, custom fields, related contacts, contact status, category(s)

  • All contacts are migrated to GrowthZone regardless of status. Status can be assigned based on the membership rules established for the data migration.
  • Related detail/transaction information, such as event, training, committees, invoices, payments, etc. relating to the migrated contacts will be loaded into GrowthZone. Any transaction information related to contacts that are not migrated to GrowthZone will NOT be loaded.

Individual Contacts – name, contact information, custom fields, related contacts, contact status, category(s)

  • All contacts are migrated to GrowthZone regardless of status. Status can be assigned based on the membership rules established for the data migration.
  • Related detail/transaction information, such as event, training, committees, invoices, payments, etc. relating to the migrated contacts will be loaded into GrowthZone. Any transaction information related to contacts that are not migrated to GrowthZone will NOT be loaded.

Memberships – Membership Type name, description, fees per membership type, start date, renewal month, billing frequency/cycle, renewal notice days, grace period days, billing contact information

  • Active memberships are migrated. Dropped memberships are not included in the migration.
  • A membership map is required to ensure we are mapping membership information accurately.

Communication – to, from, date, subject, body/notes, follow-up, category

  • Communication for the current calendar year, plus prior four years are typical for migration.

Lists/Committees – name and roster

  • Lists and committees for all current and prior years activity will be pulled in by default for all loaded contacts based on the source. See source documentation for more specific information.

Directory listing – category, description, keywords

  • GrowthZone migrates what is available in the source systems.
  • By default, we create standard active member directory.
  • If more is available in the source and based on the Data Migration Option selected, see source documentation for further explanation.

Logos/Images/Documents

  • Contact-specific files may be loaded based on specific criteria needed to ensure exact matching. Add-on fee may be applied based on needed storage space.

Custom fields

  • Custom fields may be imported from source based on the source documentation. Some custom fields are migrated as a category or list.

Billing – Current Year Accounts Receivables including invoices, payments, credits, write-offs.

  • Transactions means: accounting invoices, payments, credits, write-offs, and refunds and does not mean G/L transactions.
    Fiscal Year (open items) for loaded contacts is in Scope
  • Bring in everything for all contacts (Less data does not mean fewer issues). If we put in a parameter, then the rules have to be defined...example: need to do write-offs, etc.
  • GrowthZone does not migrate G/L transactions.
  • GrowthZone will not change ownership/assignment of the original accounting invoices, payments, credits, write-offs, and refunds from the Source.
    • I.e. if an invoice was assigned a person and now you want it assigned to an org. This will not occur in the data migration.
  • If GZ is migrating a source system that has ‘messy accounting data’ (e.g. prior conversions created data that is not easily mapped) - then it becomes custom
  • Unapplied payments are migrated as Overpayments. This will result in these coming over as credit balance on a contact account.
  • Any transaction information related to contacts that are not migrated to GrowthZone will NOT be loaded.

Events – name, start/end dates, description, location, fees, categories, sponsors, attendees

  • It is recommended that you limit event data to the most recent 5 years.

Sponsors/ads – if sponsor/ad module is purchased

Our data migration processes focus on mapping data from the original source to GrowthZone in a way that allows the original data to be maximized for the data structure and features of GrowthZone. There may be a limited amount (typically less than 5%) of data that is not possible to effectively migrate en masse and may require manual manipulation or entry. GrowthZone does not modify data during the data migration.

Staging Review

  • The initial data migration will be done in a Staging area, which allows you to preview the data prior to the Final Conversion.
  • This allows you to continue with your day-to-day business while confirming the data is as expected.
  • There will be an opportunity for multiple staging reviews based on the Data Migration Option selected. This process provides an opportunity to review, request changes, updates, etc. with the expectation at the end of these reviews, we are in a “final” state with the data migration rules ready to schedule the Final Conversion.  If additional Staging reviews are required beyond the included Staging reviews, we are happy to do so at a rate of $500/additional Staging.
  • GrowthZone will provide a walk-through of the Staging database and will provide a checklist of items we feel are important to validate; there may be other areas outside of this list that customers feel are important and we encourage you to validate:
    • Any business processes
    • Reporting
    • Other key operations for your business

Final Data Migration

  • Final Migration to Production
    • As the reviews of data conclude, the Final Migration timing will be scheduled at least two weeks in advance.
    • A final data pull will be required from the original data source(s) at this time.
    • Should updates or changes be requested after the Final Migration to Production, charges may be incurred.