WFFM Data Report Statistics

In a recent project I worked on, client reported an issue with the statistics fields for WFFM reports,  the visits, submission attempts and dropouts are displaying as zeros while the number of successful submissions has a value. This was the trigger to look deeper for this issue, in this post will mention the different WFFM forms data providers, and what is the issue with these statistics fields.

First of all I should mention that this is for Sitecore.NET 8.1 (rev. 160519) or Update 3.

What are the different form's data providers? 

If you open ..\website\App_Config\Include\Sitecore.WFFM.Dependencies.config, under the analytic section, you can find the following:

1. sqlFormsDataProvider: Only form's data from wffm sql db is involved in reporting and export processes
2. analyticsFormsDataProvider:  only form's data from analytics sql and mongo db is involved in reporting (sql) and export (mongo) processes in this case you should be sure that xDb and tracker is on
3. combinedFormsDataProvider:  form's data from wffm sql db is used for export and data from analytics sql is used for reporting

Why WFFM Report Statistic is not correct?

This is a screenshot of how the form report statistic fields look like:

Further looking it seems that these fields are being pulled using the SQL query placed in the following sitecore item:

/sitecore/system/Settings/Analytics/Report Queries/WFFM/Form Submit Statistics

Following the SQL query:

Running this query into the SQL reporting database directly also didn't show the expected data, so I investigated this more and found the following in Sitecore documentation:

By default, the Experience Database (xDB) data provider stores and exports data from the xDB analyticsFormsDataProvider class. However, you can change the data provider to a custom SQL Server database data provider, or to a combined reporting and custom SQL Server database data provider.

Both data providers store and export data from a custom SQL Server database. However, in the Form Reports for a particular form, only the Custom SQL Server database data provider shows the number of forms that have been successfully submitted.

So, If you switched your data provider from the default one to SQL data provider, your forms report will read data from SQL but not all information will be available in this option,  but in case you also have a MongoDB, then you can keep the default or use the combined provider. Hope this will help someone.