Report Deals Where Last Modified More Than 10 Days Ago

SOLVE
John_Egerton
Member

Hi There,

 

I would like to create a report showing me and deals that have not been updated within the last 10 days. Alternatively, any deals that have not had their 'Next Steps' property not updated in the last 10 days.

 

Is there any way of doing this?

 

Thanks,

John

0 Upvotes
2 Accepted solutions

Accepted Solutions
karstenkoehler
Solution
Most Valuable Member

Hi @John_Egerton,

 

This is possible with the new custom report builder, currently in beta. You can check whether you have access by clicking Reports > Reports > Create custom report. In the left sidebar, you would see Custom Report Builder. If it doesn't appear there, you might be able to access it via https://app.hubspot.com/advanced-builder/1234567, where 1234567 in the previous URL is your portal ID.

 

When you see the options for the Custom Report Builder BETA, select Deals as primary data source in the dropdown, and click Next. You can now search for Create Date, drag and drop it on the X-axis, put Count of deals on the Y-axis.

 

advanced-builder-axis.png

 

Next, select the tab Filter, search for Last modified date and drag the field into the filters. You probably also want to show only those deals which haven't been closed yet, so you could add that as an additional filter.

 

advanced-builder-filter.png

 

With a vertical bar chart, you should now see all of the deals, created in the month shown on the x-axis, which haven't been closed yet and which haven't been updated in the last 10 days.

 

(In the "old" report builder, we do not have the same filter options for 'Last modified date'. If you do not have access to the new report builder yet, I recommend reaching out to your account manager and request it.)

 

Hope this helps!

Karsten Köhler
Freelance Digital Marketing Advisor

Beratungstermin mit Karsten vereinbaren


Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

AmyLou
Solution
Top Contributor

Hi @John_Egerton,

 

@karstenkoehler is so good at explaining! That's definitely the best way forward. However, if you're unable to build it yourself, we have an email report that tells you just that as well as an interactive dashboard. No setup needed other than if and when you want to receive the email reports. Check us out for free at MethodData.

 

Feel free to reach out if you have other reporting queries as well. 

 

Kind Regards

Amy-Louise

Senior Business Analyst

MethodData  

View solution in original post

2 Replies 2
karstenkoehler
Solution
Most Valuable Member

Hi @John_Egerton,

 

This is possible with the new custom report builder, currently in beta. You can check whether you have access by clicking Reports > Reports > Create custom report. In the left sidebar, you would see Custom Report Builder. If it doesn't appear there, you might be able to access it via https://app.hubspot.com/advanced-builder/1234567, where 1234567 in the previous URL is your portal ID.

 

When you see the options for the Custom Report Builder BETA, select Deals as primary data source in the dropdown, and click Next. You can now search for Create Date, drag and drop it on the X-axis, put Count of deals on the Y-axis.

 

advanced-builder-axis.png

 

Next, select the tab Filter, search for Last modified date and drag the field into the filters. You probably also want to show only those deals which haven't been closed yet, so you could add that as an additional filter.

 

advanced-builder-filter.png

 

With a vertical bar chart, you should now see all of the deals, created in the month shown on the x-axis, which haven't been closed yet and which haven't been updated in the last 10 days.

 

(In the "old" report builder, we do not have the same filter options for 'Last modified date'. If you do not have access to the new report builder yet, I recommend reaching out to your account manager and request it.)

 

Hope this helps!

Karsten Köhler
Freelance Digital Marketing Advisor

Beratungstermin mit Karsten vereinbaren


Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

AmyLou
Solution
Top Contributor

Hi @John_Egerton,

 

@karstenkoehler is so good at explaining! That's definitely the best way forward. However, if you're unable to build it yourself, we have an email report that tells you just that as well as an interactive dashboard. No setup needed other than if and when you want to receive the email reports. Check us out for free at MethodData.

 

Feel free to reach out if you have other reporting queries as well. 

 

Kind Regards

Amy-Louise

Senior Business Analyst

MethodData  

View solution in original post