Creating a report of deals that lack certain information

Matt_26464
Matt_26464 Posts: 6
edited May 29 in Lead Generation #1

Hey,

I tried my best but failed so far. I'd like to create a report (a list view) of all the deals that lack certain information like Lead Source (custom single option select field).

My need is to:
- Be able to create a list of deals that are missing f.e. Lead Source information so I can give it to my Sales Reps so they know which deals they should update

Any ideas?

Comments

  • Bert Calatz
    Bert Calatz Community Driver Posts: 79
    10 Comments Community Driver
    edited February 25 #2

    @Matt  As far as I know this is not possible in list view.

    A possible workaround.

    Make som fields mandatory (company settings - data fields). I suggest from a particular stage of the pipeline. Only when you want to reach the next stage these fields are mandatory. Otherwise you cant move on.

    The next step is then to create a report in insights so you monitor the progress.

  • Matt_26464
    Matt_26464 Posts: 6
    edited February 2021 #3

    @Matt  As far as I know this is not possible in list view.

    A possible workaround.

    Make som fields mandatory (company settings - data fields). I suggest from a particular stage of the pipeline. Only when you want to reach the next stage these fields are mandatory. Otherwise you cant move on.

    The next step is then to create a report in insights so you monitor the progress.

    Thanks Bert,

    This is actually what I did, but I'd like to create a list of the past deals to update them, from the period of time when this field wasn't mandatory.

  • Bert Calatz
    Bert Calatz Community Driver Posts: 79
    10 Comments Community Driver
    edited February 2021 #4

    @Matt  As far as I know this is not possible in list view.

    A possible workaround.

    Make som fields mandatory (company settings - data fields). I suggest from a particular stage of the pipeline. Only when you want to reach the next stage these fields are mandatory. Otherwise you cant move on.

    The next step is then to create a report in insights so you monitor the progress.

    In that case, an alternative is to create an overview in list view with only the currently required fields. Export this to excel or sheets. Filter on the empty fields and you have your overview.

  • Brad Krause_13404
    Brad Krause_13404 Posts: 518
    edited February 25 #5

    @Matt You can create a filter and then the sales rep can go to deals list view and apply the filter to see the list of all the deals that are missing that info and update it. Tip, add the 'Lead Source' as a column in that list view and it can be updated tight in that view very quickly. 

     

    image

     

     

    You could also add a condition 'Deal Owner is Current User'. When I create a filter that is specific to pulling data for the current user I name them 'My' : ABC : XYZ

     

    image

     

    Click the gear in the upper right corner to add the custom lead source field. 

     

    image
  • Matt_26464
    Matt_26464 Posts: 6
    edited February 2021 #6

    @Matt You can create a filter and then the sales rep can go to deals list view and apply the filter to see the list of all the deals that are missing that info and update it. Tip, add the 'Lead Source' as a column in that list view and it can be updated tight in that view very quickly. 

     

    image

     

     

    You could also add a condition 'Deal Owner is Current User'. When I create a filter that is specific to pulling data for the current user I name them 'My' : ABC : XYZ

     

    image

     

    Click the gear in the upper right corner to add the custom lead source field. 

     

    image

    Thank you Brad, this solved my problem!

  • Inês Batata
    Inês Batata Admin Posts: 3,155 COMMUNITY MANAGER
    2500 Comments Second Anniversary 5 Likes First Answer
    edited February 2021 #7

    Hi @Matt  and everyone, great to see you helping each other with tips and workarounds. 👏

    Quickly dropping by to let you know that we're working on more improvements for Leads, to make them work more like the rest of Pipedrive you're used to. 

    Here’s how to get notified about what’s coming down the line:

    • Follow What's Planned to know what we're currently working on and what’s to come.
    • Follow What’s New and don’t miss any new release announcements.
    • Join our Research and Beta Testing channel for the chance to try out early versions and give us your opinion about new and improved features before they go live.