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.
Export only updated data
There is a further option: 'Only export periods with updated data. This option is enabled by default for new exports and means that Funnel will try to reduce the number of files that are exported. This will reduce warehouse costs as well as allow you to export more data. This configuration is always recommended, except for Snowflake.
It works like this:
If account configuration is changed (e.g. custom dimensions or metrics, new data sources) all data is exported.
If the export configuration is changed all data is exported.
Otherwise, start from the month that contains the oldest new data, so if Adwords data has changed in Jan 2022 the export will start from 2022-01-01.
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'.