How does Funnel treat dates?

The way data is imported by date when providing reports directly.

Bruno Petersen avatar
Written by Bruno Petersen
Updated over a week ago

After making a custom connector request, chances are you provide your reports by SFTP or as a scheduled email. If that is the case, there are some things worth keeping in mind when sending in your reports.

Date is key 

Funnel keys data based on date. This means each row of data is attributed to a date. It is fine to put multiple rows of data, containing the same date, within the same report. However, if you send 2 different reports, with the same date range, the second report’s data will overwrite the first report’s data.

Example:
Report A. Sent 10/01/2019

Report B. Sent 10/01/2019

The date for Row 1 of Report B contains the same date as Row 3 and Row 4 of Report A. Because Report B was sent most recently, Row 1 of Report B will overwrite Row 3 and Row 4 of Report A.

The result after sending Report B in Funnel is the following:

Min/Max Dates in the report:

When Funnel reads a file it takes a minimum and maximum date within the file. If there is no data associated with a certain date within the range of the file, Funnel will attribute that missing date null values. This mainly poses issues when trying to attach one missing/incorrect data point to the end of a current report.

Example:
Report A Sent 10/01/2019

Report B Sent 10/01/2019

If you, for instance, realize Row 3 within Report A had the wrong amount for Clicks, so you attached the correct data at the end of Report B. The minimum date within Report B is now 10/03/2019, and the maximum date within Report B is 10/08/2019. Because there is no data within Report B for 10/04/2019, Funnel will regard this as null values and overwrite existing data for these dates. 

The result after sending Report B in Funnel is the following:

If you find gap like the one above you can always send in a new file with the current and missing data. 

Did this answer your question?