Think about a corporate performance report. Connecticut, South Carolina, Minnesota were the Top 3 performs. Wyoming, New Hampshire and New York were the Bottom 3. There were X, Y and Z trends. Revenue and profit grew A% and B% respectively. You could go on and on for pages.
Or, you could show charts like this.
It wouldn’t surprise me if this is the first sentence you read in this article. That’s because the visualization immediately captures our attention. If you’ve automated workflows with frevvo, your data is already digital. Data visualization is the best way to present your data.
Through the years, we know that customers just want their data so they can use their preferred tools and methods to analyze it. As a result, our product strategy maximizes customers’ ability to push or export form and workflow submission data into other systems.
We provide a variety of connectors e.g. the SQL Database Connector, the Google Connector (Google Drive and Google Sheets), the File System Connector, the SharePoint Connector and others. While these connectors have varied capabilities , a common thread is that they can export your submission data into another system.
We’ve written a series of articles on how frevvo + Google Apps (Sheets, Drive, Maps) can work together to solve business problems. frevvo includes a built-in submission repository that saves all your form and workflow submissions. You can view this data, filter it, and export it using the Submissions Views available in Live Forms. But, you can also combine frevvo + Google Sheets and leverage some sophisticated capabilities that are part of Google Sheets (charts, queries, filters etc.) for powerful data analysis on your submission data.
Here’s an example form that you can try. It’s a simple one with a few fields. A survey form for participants in the 2014 World Cup Soccer tournament. The form adds your submission data to this Google Sheet and shows it. When you submit it, you’ll see your submission in the last row.
The spreadsheet also contains two other Tabs: Geo Location and Pie Chart. The Geo Location Tab runs a query on the raw submission data and groups submissions by country. The Sheets Query language is very general and allows SQL-like queries. Once we have the data by country in a nice tabular format, we can generate a nice chart that plots submissions by country on a world map. Easy as pie.
The Pie Chart Tab, as you might expect, contains a pie chart. It contains a very similar query except that it sums pledge amounts by country and by position. Once again, we have the required data in a table and can easily generate pie charts to report on the data.
In this way, you can easily use frevvo’s Google Connector to save your submissions to Google Sheets. Then, you can use a whole host of built-in features in Google Sheets to analyze your submissions.
Interested in using frevvo with Google Apps? Contact us to learn how you can automate your approval workflows, integrate with Google Apps to manage your documents and use some of Sheets capabilities for advanced reporting.
Google Apps includes Sheets, using which you can create powerful online spreadsheets. frevvo forms and flows integrate with Sheets so you can save submissions to a spreadsheet. But that’s not all – Sheets includes some sophisticated capabilities including charts, queries, filters etc. and you can leverage these for powerful data analysis on your submission data.
We’ve created a simple example. Click the image or this link. You’ll see a simple frevvo form with a few fields. Fill it in (all fields are required) and click Submit. The form adds your submission data to a Sheet and shows it. You’ll see your submission in the last row.
But, the spreadsheet also contains two other worksheets (the Tabs at the bottom). The first one (Geo Location) runs a query on the raw submission data and groups submissions by country. The Sheets Query language is very general and allows SQL-like queries. For example, the table in the Geo Location worksheet is generated using =QUERY(Results!A2:E2012, “select C, count(B) where E > 0 group by C”). Now that we have the data by country in a nice tabular format, we can generate a nice chart that plots submissions by country on a world map.
The second one (Pie Chart) runs a similar query except that it sums pledge amounts by country and by position. Once again, we have the required data in a table and can generate pie charts to report on the data.
In this way, you can use frevvo’s Google Connector and Sheets to create advanced reports, charts and analytics based on your form submissions. There’s a lot more you can do and we’ll be creating more examples over time.
Does your organization use Google Apps? Contact us to learn how you can automate your approval workflows and integrate with Google Apps to manage your documents and reports.