Does Funnel support zip files?
Yes. Upload a .zip file manually, or send it by scheduled email. Funnel doesn't support other archive types, such as .7z and .rar.
What file types does Funnel support?
Funnel supports these file types:
CSV
TSV
TXT
XLSX
ZIP (one or more of the file types above)
If the file uses another extension, such as .xls or .eml, convert it to a supported format.
Can I upload data without a date?
The file must include a date column. If you can't aggregate the data by date, import it from a Google Sheet. See Google Sheets: Connection guide.
Can a date column include a timestamp?
No. Funnel doesn't support a time in the date column, and it doesn't aggregate data by time. Funnel can remove the time or replace it with zeros.
To keep the time, format the field as a string instead of a date when you configure the data source.
Can I upload data for dates in the future?
Yes. A future date works the same way as a past date. The data appears in Funnel and in shared locations.
Why does my File Import show an import end date in the past?
On the Data sources page, Import end date is the latest date with data in the data source. It isn't an expiry date.
If Import end date doesn't change to a later date, Funnel hasn't received a file with a later date. For a data source that receives files by email, open the data source and select Show emails to see when the last email arrived. If no new email has arrived, confirm that the sender still sends files to the email address for that data source. For example, check a scheduled report in another platform.
Can I delete files after Funnel imports them?
You can't delete a file after Funnel imports it. You can overwrite the data.
Funnel stores data by date. To overwrite a date, import a new file with a blank row for that date. The new file replaces the data for that date.
Example
Data in the file you want to replace:
Data in the file that replaces it:
To overwrite a date range, see Missing data in File Import Troubleshooting.
Is there a maximum file size for imports?
Only email attachments have a size limit: 30 MB. Manual uploads and files from email links don't have a size limit, but a large file can time out during import.
Can I update the File Import configuration after setup?
You can edit most options after you create the data source. See How to edit a file import configuration.
To change an option that you can't edit, create a new data source. To copy the data from the existing data source, use Data Explorer:
On the Data sources page, select the File Import data source, then select Manage file import > View in Data Explorer.
Set the date range so that it includes all imported data.
Set Limit number of rows to No.
Confirm that the visible columns match the fields in the original files. The export includes only the columns you can see.
Select Export > Download as CSV.
Create the new File Import data source from the downloaded file.
If the old data source receives files by email, the new data source has a different email address. Update the sender to use the new address.
Can I use the file name to segment data?
You can't create a custom dimension or metric from the file name. Funnel doesn't provide the file name as a dimension.
Can I use a different currency for each monetary field?
You can't set a different currency for each monetary field. Set the currency on each row with a currency column, or set one currency for the whole file.