By default a Funnel data warehouse export will export all data starting 2015-01-01. 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 for all periods, starting at 2015-01-01. You can change the start date, and add an end date if you want.
You can also choose a rolling window, for example export only the last 3 months. Note that this includes the current month to date.
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. 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 2017 the export will start from 2017-01-01.
The UI will still report the same number of files has been created and exported, but the Job run details popup will look like this:
The greyed-out files have not been exported this time.
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.
There are a few best practices to note here:
The dimension you filter on (in this case 'Connection type code') must be included in the export.
Avoid using negation and 'or'. This filter:
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'.