Skip to content

Wealthbox to Swivel Import

How Wealthbox Data Migrates to Swivel

Wealthbox FieldSwivel FieldNotes
First NameFirst Name
Middle NameMiddle Name/Initial
Last NameLast Name
NicknamePreferred Name
SuffixSuffix
Marital StatusMarital Status
Company - Job TitleJob Title
Assigned toServicing Agent
Household Title = “Head”Spouse association type
Primary Contact on respective Household
Added as Family Member
Household title or roles are not currently supported in Swivel.
Swivel will migrate related individual contacts as “Spouse” association type.
Household Title = “Spouse”Spouse association type
Secondary Contact on respective Household
Added as Family Member
Household - Household NameHousehold (Association Only)Inherits Wealthbox “Household Name” —> Swivel (e.g. Mr. & Mrs. Halpert)
Household will associate both spouses as family members to the respective household.
See also Household Title = Head, Household Title = Spouse
Phone Number TypePhone Name
Phone NumberPhone
Phone Number - Primary ?Primary PhonePhone number with Wealthbox primary?=True
Email TypeEmail Name
Email AddressEmail Address
Email Address - Primary?Primary EmailEmail address with Wealthbox primary?=True
Background InformationPersonal Note
LinkedIn URLN/A
TwitterN/A
Address TypeAddress NameIn Swivel, Address Names are free-text.
Street Address 1Address Line 1
Street Address 2Address Line 2
CityAddress City
StateAddress State
ZipAddress Zip Code
Country
Mailing AddressPrimary Address Line 1
Primary Address Line 2
Primary Address City
Primary Address State
Primary Address Zip Code
Street Address with Wealthbox mailing address?=True
Referred ByReferred ByThis is a contact-oriented field in Wealthbox and Swivel.
ReferralsReferrals
BirthdateDate of Birth
Date of deathDate of Death
Client SinceClient Since
AnniversaryN/A
SSNSSN
Contact SourceLead SourceContact Sources can be customized in Wealthbox.
If ‘Lead Source’ doesn’t exist, the system will dynamically create new one on migration
Contact TypeContact Category
StatusContact StatusWealthbox only has “Active” and “Inactive” statuses
GenderGender
TagsTags
WebsiteN/A
Important InformationPersonal Note
Related ContactsN/A
Additional Information (Important Information)Personal NoteNote: Background also maps to Personal Note.
When data exists for both Background and Important Information from Wealthbox

Contact (Household) → Contact (Household)

Section titled “Contact (Household) → Contact (Household)”

Households without members will migrate into Swivel a contact type WB Empty Household and Unspecified contact category.


Wealthbox FieldSwivel FieldNotes
First NameFirst Name
Middle NameMiddle Name/Initial
Last NameLast Name
NicknamePreferred Name
SuffixSuffix
Marital StatusMarital Status
ContactsOwner(s)
Creator Id / NameN/A
N/AAgent of RecordWealthbox accounts will migrate with Agent of Record value = null or empty
There is no account field that maps 1:1 with Swivel Agent of Record
Account NumberProduct Number
CompanyInstitutionSystem will check the product, then institution.
If product name exists, but institution is different, the system will create a new product and institution.
ProductProductIf product pre-exists in Swivel (e.g. from blueprint applied), the system will map the product to the pre-configured product and inherit the relationships (e.g. product type/product line/institution)
Account TypeProduct TypeSee also Product
Tax Qualified?N/A
Tax Qual TypePlan TypeIf plan type pre-exist in Swivel, the system will create a new plan type and associate it to the respective product type
Discretionary (checkbox)N/A
Managed (checkbox)N/A
ManagerN/A
Model StrategyN/A
StatusProduct StatusWealthbox options include Open, Closed, Pending, Under Review
N/AProduct Status DateThere is no Wealthbox equivalent for product status date.
Issue DateIssued Date
Cash Value”Cash Value”If a value exists, the system will create product register_value
Face Value”Face Value”If a value exists, the system will create product register_value “Face Value”.
Surrender Value”Surrender Value”If a value exists, the system will create product register_value “Surrender Value”.
Loan Balance”Loan Balance”If a value exists, the system will create product register_value “Loan Balance”.
Asset Balance (checkbox)N/A
Rebalance FrequencyN/AWealthbox options include None, Monthly, Quarterly, Semi-Annual, Annual
Coverage
RegistrationN/A
Ownership TypeN/A
Owner”Owner”This a free text field in Wealthbox
Joint Owner”Joint Owner”This a free text field in Wealthbox
InsuredInsuredThis a free text field in Wealthbox. Listed as the first ‘Insured’ person in Swivel
Insured 2InsuredThis a free text field in Wealthbox. Listed as the second ‘Insured’ person in Swivel
Coverage Amount ($)“Coverage Amount”If a value exists, the system will create product register_value “Coverage Amount”
Death Benefit OptionN/A
RidersN/A
Payment Dates
Annual Premium ($)“Annual Premium”If a value exists, the system will create product register_value “Annual Premium”
Modal Premium ($)“Modal Premium”If a value exists, the system will create product register_value “Modal Premium”
Premium FrequencyN/A
Withdrawals Monthly ($)N/A
Invested Initial ($)“Invested Initial”If a value exists, the system will create product register_value “Invested Initial”
Invested Total ($)“Invested Total”If a value exists, the system will create product register_value “Invested Total”
Application DateN/A
Delivery DateN/A
Effective DateEffective Date
Renewal DateN/A
Close DateClosed Date
Beneficiaries
NameName
TypeTypePrimary —> Primary
Secondary —> Contingent
PercentagePercentage
Assets
Asset NameN/A
CUSIPN/A
SymbolN/A
Share BalanceN/A
Share Balance DateN/A
Share PriceN/A
Share Price DateN/A
Asset Type (single-option)N/A
Asset Objective (single-option)N/A
Transactions
Rep #N/A
Trade DateN/A
Trade TypeN/A
Product NameN/A
SecurityN/A
Gross AmountN/A
Share BalanceN/A
Share PriceN/A
Date ReceivedN/A
Date ForwardedN/A
CUSIPN/A
Source of FundsN/A

Seminar events saved as Wealthbox Projects without related ‘Events’.

Wealthbox FieldSwivel FieldNotes
N/ACampaignMarketing_events must be associated to a campaign in Swivel so Swivel will create a default ‘Wealthbox’ campaign.
ProjectMarketing Event (or Event)Projects can have associated calendar events in Wealthbox.
N/AEvent TypeDefault to ‘Project’ type
Project TitleEvent Name
Project DescriptionEvent Description
N/AStatusDefault to ‘closed’
Created onStart OnProjects don’t have a ‘Start On’ date attribute in wealthbox
Swivel requires a ‘Start On’ date for marketing events
On migration, we will use the ‘Created Date’
N/AEnd OnDefault to 1 hour duration from Created on date/time
N/AVenueDefault to ‘TBD’
Organizer NameAssigned to
Related contactsEvent attendanceDefault to ‘registered’ status = true
Event status mapping
Event registration status = pending
Event registration outcome = none
Archived = TrueRecord State = Archived
Visibility
• visibility type
• visibility_user_ids
• visibility_user_names
• restricted_visibility_group_id
N/A

Wealthbox FieldSwivel FieldNotes
N/AWorkspaceAll Migrated Wealthbox Tasks are migrated to a “Wealthbox” workspace
Task NameTask Name
Repeats?N/A
Due TypeN/AWealthbox Due Type options include Today, Tomorrow, This Week, Next Week, Future, Specific Date
Due DateDue Date
Due TimeN/A
Assigned to
• assigned_to_id
• assigned_to_type
• assigned_to_name
AssigneeIf a task is assigned to a “Team” in Wealthbox it comes over to swivel as “Unassigned”
DueStatusAny value not is listed as “To Do” in Swivel unless Task is Done
Then Status = Done
PriorityPriorityNone -> Normal
Low -> Low
Medium -> Normal
High -> High
CategoryCategoryAll Category Colors come in as Blue and can be reconfigured in Settings -> Advanced Setup -> Tasks
DescriptionDescription
AttachmentsN/A
CommentsComments
Related to “Contact”Linked Records
Related to “Opportunity”Tenant Task > Opportunity Tasks listWhen Wealthbox tasks are associated to an opportunity, it will create a tenant “task” on a task list name “Opportunity Tasks”
Note: Swivel doesn’t currently support tasks associated opportunities.
Related to “Project”Tenant Task > Project Checklist ItemsWhen Wealthbox tasks are associated to a project, it will create a tenant “task” on the task list name “Project Checklist”
Note: Swivel doesn’t currently support tasks associated projects.

Wealthbox FieldSwivel FieldNotes
Replies (also referred to as ‘Comments’)Comments

Wealthbox FieldSwivel FieldNotes
Opportunity NameOpportunity NameAll Migrated Wealthbox Tasks are migrated to a “Wealthbox” workspace
Contact = IndividualContact
Contact = HouseholdHousehold
PipelinePipeline
StageSales Stage
Next StepNext Step
Probability (%)N/A
Assigned toAssigned to
Amount (first_amount)Amount / Premium
Target CloseEst. Closed Date
DescriptionDescription
Opportunity NameOpportunity Name
Contact = IndividualContactOpportunity can only be associated to one (1) contact in Wealthbox, one(1) household is considered a contact
Contact = HouseholdHouseholdOpportunity is associated “Household” (e.g. Pam & Jim Halpert). It is not associated to the individual contacts. The migrated opportunity is still visible on the individual contact(s) opportunity section.
Current State: For Household contact types (with ‘Association Only’ setting enabled) Swivel doesn’t support opportunities associated to “Jim & Pam Halpert Household” - when creating an opportunity from the Household view, it will default to associating the opportunity to both individual contacts
PipelinePipelineIf pipeline exists in Swivel (e.g. Annuities), the system will create and add the additional sales stages to the respective pipeline.
If pipeline does NOT exist in Swivel, pipeline is created and respective sales stages associated to open/closed opportunity records.
For Testing / Data Review: When migrating Wealthbox pipelines, the data only provides sales stages associated to open/closed opportunities. Depending on the opportunity record, it may or may not migrate all configured sales stages from Wealthbox.
StageSales Stage’{custom sales stage name} —> sale stage of ‘{custom sales stage name}’ with workflow step “prospect” and open status
’Lost’ sales stages —> sales stage of “Lost” with workflow step “Lost” and closed status
’Won’ sales stages —> sale stage of “Won” with workflow step “Won” and closed status
Next StepNext Step
Probability (%)N/AWealthbox supports 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, and 100%
Assigned toAssigned to
Amount (first_amount)Amount / PremiumWealthbox currently supports multiple “amounts/amount types” to be stored on an opportunity. Swivel only support one (1) amount to be stored on the opportunity.
The first amount listed will migrate to the Amount/Premium value.
Target CloseEst. Closed Date
DescriptionDescription

Wealthbox FieldSwivel FieldNotes
Event NameSubjectAll Migrated Wealthbox Tasks are migrated to a “Wealthbox” workspace
CategoryAppointment Type
Start DateStart Time
Start TimeStart TimeWealthbox Due Type options include Today, Tomorrow, This Week, Next Week, Future, Specific Date
End DateEnd Date
End TimeEnd Time
All day?See also Start Date, Start Time, End Date, End Time, AttendingAll-day calendar events migrate with Start Time as 12:00 AM and End Time 11:59 PM
From Edit Appointment form, the duration defaults to “15 minutes”
Repeats?N/A
Status:
Unconfirmed
Tentative
Confirmed
Cancelled
Completed
Status Options:
Pending
Confirmed
Canceled
Kept
Unconfirmed —> Pending
Tentative —> Pending
Confirmed —> Confirmed
Cancelled —> Canceled
Completed —> Kept
LocationLocationAll Category Colors come in as Blue and can be reconfigured in Settings -> Advanced Setup -> Tasks
DescriptionDescription
Related to “Contact”ContactsWhen Related resource_type = contact , associates the events to the corresponding contact in Swivel
Related to “Opportunity”Origin OpportunityFor Data Review:
When viewing an appointment in Swivel, the appointment form doesn’t include an origin or associated opportunity field.
To confirm navigate to the corresponding opportunity record in Swivel, click Edit > Origin Appointment field.
Creator,
Attending User
Organizer,
Calendar
Organizer - Creator From WB
Calendar - First look for attending user; If no attending user, use creator
See also Attending users.
Attending usersCalendarWealthbox supports one or multiple user attendees on calendar events.
Swivel only supports associating calendar events or appointments to one (1) user calendar.
Invited contactsN/ASee also Related to Contact
Send email invitation to new invitees and BCC the event creator (checkbox)N/ACreating an appointment from Swivel does not email a calendar invite to your contact recipient(s). Calendar invites are only sent to recipients when the origin event was created in Outlook or Google calendar.

Wealthbox FieldSwivel FieldNotes
Workflow Template
Workflow NameName
Sequential?Force sequential step progression = True
Workflow For
• “Contact”
• “Opportunity”
• “Project”
Wealthbox options include: Contact, Opportunity and Project
DescriptionDescription
Workflow Steps
Step NameName
Based OnDepends On
DueDue Date
Step Assigned ToAssigneeWealthbox options include: “Contact Owner,” “Workflow Starter,” and specified user
Step PriorityN/A
CategoryN/A
Step DescriptionDescription
File AttachmentN/A
CommentsWorkflow Step Note
Creator IdUser ID
Creator NameUser Name
Resource Id
Resource IdWorkflow Step
Created at
Updated at
External system IdN/A
Subtasks
NameWorkflow step name
CompletedWorkflow step completed? (true/false)
Completed atWorkflow step completed date
Completer_idRelated user ID
Competer_nameRelated user name
DescriptionN/A
Due atWorkflow step due date
PriorityN/A
RepeatsN/A
ScheduleN/A
Assigned to IdRelated user ID
Assigned to type
Assigned to name
Resource Id
Resource Type
Created at
Updated at
Visibility
• visibility_type
• visibility_user_ids
• visibility_user_names
• restricted_visibility_group_id
N/A
Due Based OnN/A
Due date setN/A
Due later intervalN/A
Due later interval valueN/A
Due later timeN/A

What additional data does not migrate over?

Section titled “What additional data does not migrate over?”

The import will not bring over:

  • Files/Documents
  • Templates (i.e. email templates, note templates, and custom reports).
  • Email communications
  • Custom Fields, or Customizations