All Collections
Data Connectors
Custom Connectors
Overwriting date ranges in a Custom Connector data source
Overwriting date ranges in a Custom Connector data source

How to delete or overwrite a date range in a Custom Connector Data Source

Zarah Fager avatar
Written by Zarah Fager
Updated over a week ago

For any Custom Connector Data Source, a previously imported date range of data can always be overwritten by a new file or import. This is usually done for one of two reasons:

  1. the date range contains incorrect data and it needs to be updated

  2. the date range contains incorrect data and it needs to be cleared

Keep in mind that Funnel keys on a date dimension, so it may be a good idea to refer to this article on how Funnel treats dates when sending files to a Custom Connector Data Source.

Updating incorrect data in a specific date range

If you or a platform for any reason have sent a file that has imported successfully, but contained incorrect data, the easiest way of fixing it is to re-send that date range with the correct data. This should be done in the same way and to the same Data Source as always, and you do not need to contact Funnel before doing it. As long as the file structure and format is the same as expected by the Data Source, the date range will be updated with new data automatically.

In the below Data explorer view the values in the Clicks and Impressions columns have been skewed for the date 2022-03-02:

When sending a report file with the correct data for 2022-03-02 only, the result is as below:

Clearing previously imported data in a specific date range

Sometimes it's not enough to just overwrite a date range with new data, and a date range may need to be cleared from the data source.

In the below view one of the files imported was attributed to the wrong month! In this case it's not enough to just patch or update the data imported, as the data attributed to February still will be in Funnel, causing double counting and incorrect numbers.

The only way of doing this is similar to the method above, but using a file devoid of any data except for the minimum and maximum dates in the date range affected. If there is no data associated with a certain date within the range of the file, Funnel will attribute null values to that date.

Sending a report file like this will not remove the rows in Funnel, but will result in null values for that range.

Keep in mind that this also means that the Import Start Date displayed in the Data Sources list still is February, even though the values for that date range are empty.

Did this answer your question?