A request came in from my team to put together a dashboard for AO analytics. They want it in the format for a quarterly summary as the purpose of the programs are to automate webinars, training etc or renewal due reminders for our smaller customers. Has anyone done anything similar? I cannot seem to summarize the results in a quarterly formatting.





Below is a summary of what I am looking to put together:





Reports





A bounce back email list:





Account Name, Account ARR, Product Family and email from bounce back, Next Renewal Date





Quarterly Summary:





• # of Tech Touch Outreaches->Successfully Delivered->Email Opened





• # of Email Assists Sent-Successfully Delivered->Email Opened





• # of Opps where nothing was sent





• # of Customers who unsubscribed from outreaches





• # of CTAs sent to Team by Bill To State





Thanks,





Joe