When using Funnel's dashboards or data explorer, you may have received an error message which states that the data is unable to be displayed like the example below:
This message is usually displayed when there's lots of data in your account and you are trying to view too much at the same time. Funnel currently limits the number of rows we can query to 100,000 in order to improve performance. Note that even when filtering the data in the web browser, Funnel still queries the entire data set in order to show the filtered data and allow you to quickly change the filters.
Thankfully, there are a number of ways to decrease the number of rows that Funnel queries in order to display your data:
Shortening the date range
If you're using a large date range, 2 years for example, simply selecting a shorter period may resolve the issue.
Using fewer dimensions
When using a large number of dimensions simultaneously it increases the amount of data which Funnel has to go through. If you remove a dimension or two, your data may display as expected. This all depends on the dimensions you remove. Let's take a look at an example below:
When just viewing the date dimension, Funnel only needs to query 3 rows of data:
When adding the campaign dimension, the number of rows is doubled:
Adding the market dimension on top of this increase the number of rows drastically:
Removing the Market dimension in this example would significantly decrease the number of rows that Funnel needs to query.
Filtering in dashboards
If you receive this error message in your dashboard, setting a filter on the dashboard level is another option that can help reduce the size of the query.
Head to your dashboard and click 'Edit' in the top right hand corner. Next, click on the edit icon in the first widget and choose an inclusion filter:
When creating individual widgets, Funnel will now have fewer rows to query.