Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        Projects/Quillfield

        Find the leads nobody is calling

        Demo requests from the Central region have gone quiet since August. Fix the Salesforce rule that sends them to a rep who left, build the flow that tells each owner about a new lead, and report conversion by owner in Excel.

        ProjectQuillfield · fictional company1 h 50 min4 stagesBusiness systems

        One brief, 3 toolsEvery lead keeps its id from Salesforce to the Power Automate flow to the Excel report. The owners your rule names are the ones the flow emails and the report counts.

        Quillfield

        Business software

        About the company

        Scheduling and invoicing software for plumbing, HVAC and electrical contractors in the US.

        Quillfield sells a subscription app that small contractors use to book jobs, send technicians out and get paid. Most new customers start as a demo request on the website; a few come from trade events, referrals and partners. Three account executives each cover a region, East, West and Central, and a sales development rep picks up what falls between them. Leads live in Salesforce, which routes each one with an assignment rule, and the team works from email and a Teams channel. You work in sales operations, the small team that keeps the routing, the flows and the reports running.

        Founded
        2018
        Head office
        Columbus, Ohio
        Sales regions
        East, West and Central
        Employees
        About 85

        Who writes the briefs

        • Alicia GrantVP of Sales
        • Luis OrtegaAccount Executive, Central

        A fictional company, invented for practice. Meet the other companies

        The brief

        From
        Alicia GrantVP of Sales
        To
        Sales Operations
        Subject
        Central leads going nowhere

        Luis started on the Central territory three weeks ago and says his pipeline is empty, even though the website keeps sending demo requests from his states. I suspect the leads are still going to Dana's old queue. She left on August 28.

        Please fix the routing in Salesforce so every lead lands with someone who can work it, make sure the owner hears about a new lead straight away (Hot ones in the Hot leads channel too), and send me conversion by owner so I can see what this cost us.

        You have every inbound lead from August to October with the owner it got, when someone first contacted it and where it stands now.

        Done looks like: an assignment rule that routes every lead to an active owner, a follow-up flow tested on real leads, a conversion report by owner and a short note for me.

        • Data: 126 inbound leads from August to October 2026.
        • You deliver a fixed assignment rule, a follow-up flow, a conversion report and a note.
        • Checks cover the first-match order of the rule, leads with no region, and counting by the new owner.

        The project path

        1. 1
          Salesforce30 min

          Fix the lead assignment rule

          Route Central leads to Luis Ortega and give leads with no region an owner.

          Reads
          leads
          Produces
          lead_routing

          Power Automate and Excel read the owner your rule gives each lead.

          Open stageOne Course in Salesforce or All Access
        2. 2
          Power Automate30 min

          Tell the owner about every new lead

          A cloud flow that emails each lead's owner and posts Hot leads in the team channel.

          Reads
          lead_routing
          Produces

          Excel counts the same leads by owner.

          Open stageOne Course in Power Automate or All Access
        3. 3
          Excel25 min

          Report conversion by owner

          Each owner's conversion rate, counted with COUNTIFS from the routing table.

          Reads
          lead_routing
          Produces
          conversion

          Your note quotes the rates.

          Open stageOne Course in Excel or All Access
        4. 4
          Readout20 min

          Write the note for the VP of sales

          Tell Alicia what broke, what it cost, what you changed and what happens next.

          Reads
          conversion · lead_routing
          Produces
          lead_routing_note.md

          Optional: present it in Interview Hub.

          Open stageAll Access

        Each stage includes reference inputs. Starting in the middle or using them doesn't complete the earlier stages.

        Project access

        Free

        $0

        Read all briefs and paths. Tool stages and written work are locked.

        Keep browsing

        One Course

        $17.99/month

        Practice the stages in your chosen tool. Reference tables let you start at that stage.

        All Access

        $29.99/month

        Every stage in every format, plus optional spoken readouts using dumbbells.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.