Skip to main content
Topics#Reports & DashboardsLEAH Gus's Question
LEAH Gus (Gus) asked in #Reports & Dashboards
Jun 9, 2021, 11:07 AM

report that calculates percent of leads

We have a field on our leads record named GCLID that sometimes has a value in it and sometimes it doesn't. This field is filled in by Hubspot when the lead is imported into salesforce from our website. I need to run a report that shows what percent of leads are GCLID leads and what percent are not. 

 

 
2 answers
  1. Karan Kehar (Acxiom)
    Jun 9, 2021, 11:28 AM
    Hi,

     

    You can create a formula checkbox field on Lead and name it: IsGCLIdEmpty

     

    Use the formula

    ISBLANK(GCLID__c)

     

    Now create a summary report. Create a formula in the report which is displayed on all grouping levels.

     

    Use the below formula 

    Lead.IsGCLIdEmpty__c:SUM/RowCount

     

     
Write an answer...
0/9000