You can currently edit the following options:
Adding and Removing Fields
Date Formats
The date used to store data in Funnel
Where headers and data start
The number of rows excluded from the bottom of your file
Delimiter (field separator) and decimal separator
Spreadsheet options for XLSX files
If you want to edit other options, you'll need to create a new Data Source. To make this easier, you can create a copy of your Data Source using the Data Explorer. We hope to add more editable options in the future.
To edit your file import configuration, start by heading to the Data Sources section and clicking on your File Import. You’ll then need to click on the ‘Manage file import’ before clicking on ‘Edit configuration’ in the top right corner of this section.
FAQ
Adding and Removing Fields
How do I add/remove fields?
You can add and remove fields by checking or unchecking the checkboxes in the Import
column:
How does Funnel handle added fields?
When Funnel detects a field that wasn’t present in the previous file, you’ll have the option to add this field to your configuration.
When adding a new field to your configuration, Funnel will look back through the previous files to see if this field was present in those files. If they were, Funnel would import the data from these files too.
How does Funnel handle removed fields?
If Funnel detects a missing field in your latest file, you’ll need to either remove this field from the configuration or upload a new file containing the missing field.
If you remove a field from your configuration, Funnel will not import this field going forward, but the historical data will still be available.
If you want to remove historical data, you can overwrite the data by uploading a new file. You can learn more in this article.
How does Funnel handle renamed fields?
If a field in your file is renamed from, e.g. “Cost” to “Spend”, you’ll need to remove the “Cost” field and add the “Spend” field.
From then on, Funnel would only import the data as “Spend”. Data previously imported as “Cost” would still be available and could be mapped with the new “Spend” field by creating a custom metric.
You can learn more about creating custom metrics and dimensions in this article.
Editing Dates
How do I edit the date format?
You can edit the date format by clicking on the dropdown menu in the row of your date field:
When do the changes to the date formats take effect?
The new date format will be applied to the next file you import and all new files going forward. If you have any previously imported files with date format errors, Funnel will try to reimport them too.
Can I combine different date formats in a single column?
Multiple date formats in the same column aren't supported, so you'll need to edit the file and import it again. Changing the date format in the configuration view will not solve the issue.
Why can't I see my desired date format in the dropdown?
Only date formats that are valid for the dates in your file will be available. For example, if the date is 02/02/2023, Funnel will only display DD/MM/YYYY and MM/DD/YYYY. If you want to use another one, simply import a new file with a different date format, and the option will become available.
How do I change the "Funnel Date"?
If you want to change the date that Funnel uses to store the data, all you need to do is ensure that your future files include your new desired date column. You can then edit the configuration, select the new date (check the import box) and ensure that the new date field is visible under the "Date" section at the bottom of the configuration. If you removed the old date column, you'll need to deselect it from the list too.