How to Import Opportunities in your PROSPER OS CRM
As a TRUSTfluencer—a coach, consultant, mentor, therapist, content creator, or public speaker—your invaluable expertise transforms lives, yet the journey of growing your business can often be bogged down by administrative tasks. At KonnectMaster, we understand that you're an expert in guiding clients, not necessarily in intricate data management. Our PROSPER OS is your all-in-one AI Business Operating System designed to simplify complexity, allowing you to focus on your vision and impact. One powerful feature that empowers you to efficiently manage and expand your client base is the ability to import opportunities. This guide will walk you through ensuring a seamless and successful import process, transforming your client acquisition from overwhelming to effortless.
Importing Opportunities: Your Path to Automated Client Management
Prepare Your Client Data for Import
To ensure a smooth transition of your valuable client opportunities into PROSPER OS, a little preparation goes a long way. This isn't just about moving data; it's about setting the stage for streamlined client journeys and consistent follow-ups.
Supported File Types: Your data should always be in .csv format. This ensures compatibility and easy processing within PROSPER OS.
File Preparation Essentials:
Single Sheet: Keep your data organized on a single sheet within your spreadsheet.
Manageable Size: For optimal performance, ensure your file is smaller than 30 MB.
Clear Headers: Always include a header row that clearly labels your columns. At least one of these columns must correspond to a field already recognized by PROSPER OS.
Important Note: Once imported, opportunity data cannot be reversed. Double-check everything to maintain data integrity and consistency.
Mandatory Fields for Creating New Opportunities:
When you’re bringing new opportunities into PROSPER OS, you absolutely need these three pieces of information for each entry:
Contact ID: This links the opportunity to an existing client or lead in your system. (You can fetch this by exporting contacts from the same sub-account).
Opportunity Name: A clear, descriptive name for the opportunity.
Pipeline ID/Name: Specifies which of your carefully crafted pipelines this opportunity will enter. (You can fetch this by exporting opportunities).
Default Values if Absent: PROSPER OS is smart enough to fill in gaps to keep your process flowing:
If the Stage ID/name is not provided, the opportunity will automatically land in the first stage of its assigned pipeline.
If the Opportunity Value is missing, it will default to 0.
If the Opportunity Status isn't specified, it will default to "Open".
If a valid Opportunity lost reason is included, the Opportunity Status will automatically update to "Lost".
Mandatory Fields for Updating Existing Opportunities:
To update information for opportunities already in PROSPER OS, you only need the Opportunity ID. (This can be easily fetched by exporting your existing opportunities).
Understanding Your Import Options in PROSPER OS
PROSPER OS offers flexible options to ensure your data management strategy perfectly matches your needs, whether you're adding new prospects or refining existing client journeys:
Create Opportunities: Choose this if you are uploading entirely new records into the system. Perfect for bringing in new leads from a recent workshop or event.
Update Opportunities: Select this to modify information for existing opportunities. Ideal for bulk updates on client progress or contact details.
Create and Update Opportunities: This versatile option allows you to add new records and update existing ones simultaneously. It’s a powerful way to keep your data current and comprehensive.
Structuring Your File for Seamless Integration
Proper formatting of your data ensures that PROSPER OS accurately interprets every piece of information, minimizing errors and maximizing efficiency. Here’s how to format various field types:
Date Picker: Use clear formats like mm/dd/yyyy (e.g., 10/28/2020), yyyy/mm/dd (e.g., 2020/10/28), mm-dd-yyyy (e.g., 10-28-2020), or yyyy-mm-dd (e.g., 2020-10-28).
Multiple Options, Checkbox, Textbox List: Separate multiple values with a comma (,), semicolon (;), or period (.). For example: "Value 1, Value 2, Value 3" (e.g., "Blue, Yellow, Green").
Radio, Single Option: Simply provide the single value. For example: "Value 1" (e.g., "Blue").
Opportunity Owner: Format as FirstName LastName (e.g., "Logan Paul").
Tags: Similar to multiple options, use commas (,), semicolons (;), or periods (.) to separate tags. For example: "Value 1, Value 2, Value 3" (e.g., "Blue, Yellow, Green").
Phone Number: The recommended format is E.164 (e.g., +1 1234567890). For US numbers, common formats like 123-456-7890 or (123) 456-7890 are also acceptable.
Numerical: Standard numerical formats like 1.23, 1234, or .123 are accepted.
Monetary: Use formats such as 1234, or 1,234,234.33.
Opportunity Followers: If multiple team members are following an opportunity, list them as FirstName LastName, FirstName2 LastName2 (e.g., "Adam Smith, David Lee").
Importing Your File into PROSPER OS
Now that your data is perfectly prepared, let's bring it into PROSPER OS.
Activate Feature: First, ensure the Opportunities Import feature is turned on under "Labs" > Subaccounts within PROSPER OS.
Navigate to Opportunities: Go to the Opportunities section in your PROSPER OS dashboard.
Start Import: In the top right corner, click on the three dots (...) and select "Import Opportunities".
Upload & Select: Click the 'Import' button and upload your meticulously prepared .csv file. Then, choose your desired import option: "Create," "Update," or "Create and Update".
Map Your Fields: This crucial step ensures PROSPER OS understands your data. Carefully map each column in your file to the corresponding field in the system. Adjust as needed.
Preventing Empty Value Overwrites: If you check the "Don't update Empty Values" box, PROSPER OS will retain existing field values for an opportunity if the imported file has an empty value for that specific field.
Handling Unmapped Columns: If you choose not to import certain fields, you can leave them unmapped. Just remember to check the box at the bottom to acknowledge and proceed, ensuring all mandatory fields are either mapped or explicitly chosen to be ignored.
Review and Confirm: Take a moment to review the data preview. This is your final check to ensure everything looks correct before proceeding. Confirm the import to initiate the process.
Accept Disclaimer: It's mandatory to check the box at the bottom and accept the disclaimer to start importing.
Add Contact Tags: On this screen, you also have the option to add specific tags to the contacts associated with these opportunities, enhancing your segmentation and follow-up capabilities.
Monitor the Import: Keep an eye on the import progress under Opportunities > Bulk Actions.
Understanding Feedback: If any issues arise, PROSPER OS provides clear error messages for guidance.
Errors: Indicate failures in mandatory fields, causing the entire row to fail import.
Warnings: Highlight failures in optional fields, where the row is imported, but that specific field remains unupdated.
You can monitor detailed stats, errors, and warnings by clicking the "Show Stats" button for any import.
Step By Step Guide
Troubleshooting Common Import Errors: Keeping Your Flow Smooth
Even with careful preparation, issues can sometimes arise. Here are common errors and their straightforward solutions to get you back on track quickly:
Error: Invalid option selected for multiselect or dropdown field
Solution: Carefully check your import file for any values in multiselect or dropdown fields that don't match the options already defined in PROSPER OS. Update the value in your file to match an existing option or add it as a custom option in the system, then re-import.
Error: Invalid Contact ID
Solution: Verify that the Contact ID you've provided actually exists in PROSPER OS. If you're not updating an existing contact, remove the ID from your file.
Error: Could Not Parse Date
Solution: Ensure all date fields in your file are in one of the accepted formats: mm/dd/yyyy, yyyy/mm/dd, mm-dd-yyyy, or yyyy-mm-dd.
Error: Duplicate Unique Property Value
Solution: Check for duplicate values in fields designated as unique, such as emails or IDs. Each entry in a unique field must be distinct.
Error: File Not Found
Solution: Confirm that your file is in the correct .csv type and format, then re-upload it.
Error: Required Fields Missing
Solution: Ensure all mandatory fields (like Opportunity Name for opportunities, or Contact ID/Opportunity Name/Pipeline ID for creating opportunities) are included and correctly formatted in your file.
Additional Tips
Always Double-Check: A quick review of your file before importing can save significant time and effort.
Lean on Support: If you encounter any challenges, don't hesitate to refer back to this guide or reach out to the KonnectMaster support team for personalized assistance. We're here to ensure your journey to automated efficiency is as smooth as possible.
Frequently Asked Questions
Q1: What are Pipelines in PROSPER OS and why are they crucial for my business?
Pipelines in PROSPER OS are your strategic blueprint for guiding potential and existing clients through their journey with you, from initial contact to long-term success. They are structured sequences of actions, each step a "pipeline stage", representing a milestone in the client's journey.
For TRUSTfluencers, they are crucial because they transform inconsistent interactions into a reliable, repeatable client flow. By automating and streamlining these processes, Pipelines free up your time and energy, allowing you to focus on what you do best: helping your clients achieve great results in their lives.
Q2: How can Pipelines help me streamline my client acquisition and sales process?
Pipelines are designed to provide a visual roadmap for your sales journey.
You can create stages like "Lead Capture," "Qualification," "Appointment Setting," "Proposal Sent," and "Closed-Won/Lost". As a lead progresses, they move through these stages, triggering automated follow-ups and tasks, ensuring no opportunity is missed. This gives you a reliable sales pipeline that nurtures leads consistently, improves conversion rates, and reduces the stress of manual tracking. You’ll gain the confidence to pursue more clients, knowing your backend is robust enough to handle the growth.
Q3: Once I secure a new client, how can Pipelines ensure a smooth onboarding experience?
The administrative duties of client onboarding can be overwhelming, leading to delays and inconsistent experiences. Pipelines simplify this by automating and standardizing your onboarding process.
You can set up stages such as "Welcome Email Sent," "Contract Signed," "First Session Booked," "Welcome Packet Delivered," and "Initial Assessment Completed." This ensures every new client receives a professional, high-quality, and consistent experience right from the start. By streamlining these organizational and support processes, Pipelines free you from administrative chaos, allowing you to dedicate more time to client-facing activities—your core strength.
Q4: I offer multi-stage coaching or consulting programs. Can Pipelines help me manage client progress?
Absolutely! For TRUSTfluencers offering longer-term engagements or multi-phase programs, Pipelines are an excellent tool for structured service delivery and project management.
You can design pipelines to track each phase or milestone of a client's program. Stages could include "Program Kick-off," "Module 1 Complete," "Mid-Program Review," "Action Plan Implemented," or "Final Session." This helps you ensure consistency and reliability in your service delivery, manage client progress effectively, and maintain the high quality your clients expect. It also reduces the stress of juggling multiple clients at different stages, giving you a clear overview of everyone's journey.
Q5: As a public speaker or content creator, how can Pipelines assist with event planning and content launches?
For TRUSTfluencers like public speakers and content creators, managing logistics, planning, and execution for events or new content can be complex and time-consuming. Pipelines can automate and organize these workflows, transforming chaotic manual processes into seamless operations.
For events, you might use stages like "Event Inquiry," "Proposal Sent," "Event Confirmed," "Pre-Event Logistics," and "Post-Event Follow-up." For content creation, stages could include "Content Idea Generation," "Outline Drafted," "Production in Progress," "Review," and "Launch Scheduled." This approach reduces delays, ensures consistent execution, and frees up your creative and planning time, allowing you to focus on developing engaging content and delivering impactful presentations.
Q6: How do Pipelines help me avoid missed opportunities and keep track of all my leads and clients?
PROSPER OS's Pipelines ensure that you never miss a beat with your leads or clients by providing a centralized, visual system for all interactions. You can consolidate all customer information and interactions within our robust CRM system, which is part of PROSPER OS.
By moving contacts through defined pipeline stages, you can track every interaction, follow-up, and potential sales opportunity, ensuring nothing falls through the cracks. This allows you to leverage analytics to gain insights into pipeline effectiveness, identify bottlenecks, optimize conversion rates, and enhance customer experiences. The result is improved productivity, reduced stress, and the confidence that your business operations are running efficiently, consistently, and reliably, ready for growth.
What is a TRUSTfluencer and How KonnectMaster Helps
A TRUSTfluencer is a coach, consultant, mentor, therapist, or speaker who builds trust-based relationships to help clients achieve life-changing results. They often struggle with business operations, diverting focus from their core value. KonnectMaster and its AI Business Operating System, PROSPER OS, empower TRUSTfluencers by automating organizational and support processes, providing ready-to-use SOPs. This frees up their time, energy, and money, enabling them to scale their businesses with less effort and maximize their impact.
