Respond to questions quicker by sharing report links over email

March 17, 2016 – Charlie Francis


In OpenGov, each visualization, data table, filtered selection, and breakdown has a unique URL. This feature makes it easy for you to answer the frequent questions that interrupt your day such as:

  1.     How much did we spend last year on XYZ vendor?
  2.     Why is my current year professional services line-item over budget?
  3.     What are the city’s pension expenses?
  4.     How much did we spend on overtime for the past ten years broken down by department?
  5.     Who were the design engineers for the streets capital improvement project five years ago?

To answer these questions, all you need to do is log-in to OpenGov, click through to the visualization and table that answers the question, copy the URL into an email, and reply with the answer linked to OpenGov. The recipient can click the link and go straight to the chart and table you sent. From there, she can filter, drill into, and pivot the data however she wishes to learn more.

Sending report URLs to answer questions provides you with at least two benefits:

  1. It’s usually faster to get answers out of OpenGov than from your enterprise system. Try it out right now – pick a question and answer it from within OpenGov, then try to get the same information faster from your ERP.
  1. Attaching a URL sends the not so subliminal message that the inquirer could have looked up the answer themselves, saving both them, and you time in getting the information!

Are you an OpenGov customer? Start answering questions in seconds by logging in now!



Charlie Francis is a municipal finance expert. He has more than forty years of local government financial management experience in both the public and private sector, including twenty years of experience as a Chief Financial Officer. Most recently, he served as the Director of Administrative Services and Treasurer for the City of Sausalito where he earned the unofficial title of “OpenGov super user”.  He has also served as a finance manager for the Town of Colma, CA and as CFO and acting City Manager for the Cities of Indian Wells, CA and Tracy, CA.

Questions or comments? Email Charlie at cfrancis@opengov.com.

Category: Product Advice