1 Accepted solution
Hi @AZatulovsky,
Your starting point for this would be a score property. All of the criteria that you mentioned would be included in this score property.
For marketing emails you can work with the property Marketing emails opened, for page views with Number of sessions or Number of page views. For sales emails, there isn't a default property that counts the number of opens, but you could work with Recent sales email open date to check whether at least one sales email was opened. (If you need a counting property here because the number 2 is crucial, you would have to create a custom number property and have a contact-based workflow count up this this number whenever Recent sales email open date is known, re-enrollment enabled.)
Once the score property is set up, you can create a custom report for each sales rep. Navigate to Menu > Reports > Reports > Create custom report > Single object > Contacts.
Click Filters on the upper left of the screen. This is where you can narrow down the Create date of the contact and potentially exclude contacts by Lifecycle stage and Lead status. You would also filter each report by Contact owner is any of [one sales rep from your list]. You will later recreate this report for the other sales reps.
Hide the filters, click Add contact properties, find your score property. Next, switch to the Visualization tab, pick the chart type Table, select Unsummarized data table and sort the table on the right by HubSpot score so that the highest shows at the top.
You can now save the report and recreate it for other sales reps. Let me know if you get stuck at any stage.
Best regards!
| Karsten Köhler |
 | Did my post help answer your query? Help the community by marking it as a solution. |
Hi @AZatulovsky,
Your starting point for this would be a score property. All of the criteria that you mentioned would be included in this score property.
For marketing emails you can work with the property Marketing emails opened, for page views with Number of sessions or Number of page views. For sales emails, there isn't a default property that counts the number of opens, but you could work with Recent sales email open date to check whether at least one sales email was opened. (If you need a counting property here because the number 2 is crucial, you would have to create a custom number property and have a contact-based workflow count up this this number whenever Recent sales email open date is known, re-enrollment enabled.)
Once the score property is set up, you can create a custom report for each sales rep. Navigate to Menu > Reports > Reports > Create custom report > Single object > Contacts.
Click Filters on the upper left of the screen. This is where you can narrow down the Create date of the contact and potentially exclude contacts by Lifecycle stage and Lead status. You would also filter each report by Contact owner is any of [one sales rep from your list]. You will later recreate this report for the other sales reps.
Hide the filters, click Add contact properties, find your score property. Next, switch to the Visualization tab, pick the chart type Table, select Unsummarized data table and sort the table on the right by HubSpot score so that the highest shows at the top.
You can now save the report and recreate it for other sales reps. Let me know if you get stuck at any stage.
Best regards!
| Karsten Köhler |
| Did my post help answer your query? Help the community by marking it as a solution. |
