Advanced Form Analytics? Combine frevvo + Google Sheets

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.

Geo Location ChartHere’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.

Pledge amount by positionThe 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s