Dashboards & Reporting

DarinSpence
Member

Opportunities without Appointments Report

SOLVE
How can I create a report that lists opportunities without appointments?
4 Accepted solutions
MFrankJohnson
Solution
Thought Leader

Opportunities without Appointments Report

SOLVE

hubspot-crm-contact-opportunities-last-meeting-unknown.png

 

 

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com

View solution in original post

0 Upvotes
DarinSpence
Solution
Member

Opportunities without Appointments Report

SOLVE

This is what I was needing, thank you!

 

I was hoping to filter the results to just the contacts where the Last Meeting was <Today.  However, yesterday when I used the 'today' filter, the date of 12/9 was entered.  Today, the date is still 12/9.  

 

Perhaps there will be some way to use a period (like today, this month, last month, etc) as a filter someday.

 

Thanks!

Hubspot Saved Filter Snip.PNG

View solution in original post

0 Upvotes
MFrankJohnson
Solution
Thought Leader

Opportunities without Appointments Report

SOLVE

Yea ... 'today' is actually a datepicker option (not a filter per se).

If you're using HubSpot Marketing Pro you can achieve your desired results using the lists tool which supports rolling dates (i.e., "<1 Days Ago").

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com

View solution in original post

0 Upvotes
MFrankJohnson
Solution
Thought Leader

Opportunities without Appointments Report

SOLVE

Sorta. Basically, that list will only show contacts ...

- associated with a company whose Lifecycle Stage is known

- AND who are associated with open deals

- AND for whom the 'Last Meeting Booked' date is '<1 Days Ago'

 

Just be aware, that future meeting booking dates also qualify as '<1 Days Ago'!

 

Once you tweak your list criteria the way you like, you can use that list membership as criteria for a view filter. Nice.

 

Have a great weekend.

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com

View solution in original post

6 Replies 6
Arne
Top Contributor

Opportunities without Appointments Report

SOLVE
Can’t answer your question but like to chime in. I‘d like to have a report that shows the deals that pretend to be in the contract negotiation phase but there hasn’t been an evaluation/POC for the product they shall buy from us.
0 Upvotes
MFrankJohnson
Solution
Thought Leader

Opportunities without Appointments Report

SOLVE

hubspot-crm-contact-opportunities-last-meeting-unknown.png

 

 

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com
0 Upvotes
DarinSpence
Solution
Member

Opportunities without Appointments Report

SOLVE

This is what I was needing, thank you!

 

I was hoping to filter the results to just the contacts where the Last Meeting was <Today.  However, yesterday when I used the 'today' filter, the date of 12/9 was entered.  Today, the date is still 12/9.  

 

Perhaps there will be some way to use a period (like today, this month, last month, etc) as a filter someday.

 

Thanks!

Hubspot Saved Filter Snip.PNG

0 Upvotes
MFrankJohnson
Solution
Thought Leader

Opportunities without Appointments Report

SOLVE

Yea ... 'today' is actually a datepicker option (not a filter per se).

If you're using HubSpot Marketing Pro you can achieve your desired results using the lists tool which supports rolling dates (i.e., "<1 Days Ago").

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com
0 Upvotes
DarinSpence
Member

Opportunities without Appointments Report

SOLVE

I think this will provide a list of opportunities without appointments.  Thanks!

Hubspot Saved Filter on List Snip.PNG

 

 

0 Upvotes
MFrankJohnson
Solution
Thought Leader

Opportunities without Appointments Report

SOLVE

Sorta. Basically, that list will only show contacts ...

- associated with a company whose Lifecycle Stage is known

- AND who are associated with open deals

- AND for whom the 'Last Meeting Booked' date is '<1 Days Ago'

 

Just be aware, that future meeting booking dates also qualify as '<1 Days Ago'!

 

Once you tweak your list criteria the way you like, you can use that list membership as criteria for a view filter. Nice.

 

Have a great weekend.

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com