Hi Kimberly,
You might find my descriptions in this post helpfull. A better Dashboard for high level overview - #4 by Peter_Skjoldager
That is how we use the dashboard funtionc and the google export to create what you are looking for, if i understand you correctly.
/Peter