All Collections
Data Warehouse Sharing
How do I configure date ranges and filters in my Data Warehouse exports?
How do I configure date ranges and filters in my Data Warehouse exports?
Mark Tombs avatar
Written by Mark Tombs
Updated over a week ago

This article explains how to configure your export to export fewer periods and less data per period.

Changing exported date periods

By default, Funnel will export data from a start date until today where today is the current day of the export. You can change the start date, and also add an end date if you want (even use future dates for the case of budget data, etc).

You can also choose a rolling window, for example, export only the last 3 months. Note that this includes the current month to date, where the last month is only the month we are currently on.

Filters

You can also reduce the amount of data in each file by adding a filter.  By default, all data is exported for every period, but with a filter like this:

Only data from Facebook sources will be included.

Best practices and pitfalls

The dimension you filter on (in this case 'Data Source type') must be included in the export.

Avoid using negation and 'or' like this filter:

This case will not reduce the data in the export at all, because every row is either not Facebook Ads or not Facebook Pages - the Facebook Ads rows are included because they are not Facebook Pages, and vice versa. In this case, the user probably meant 'and'.

Did this answer your question?