Problem summary
The data in a data source that Funnel built for you through a data request doesn't match the data in the source. The data source can still show OK, so you might not see an error.
Error message or symptoms
When you compare the data in Funnel with the source, you see one or more of these:
Values or totals that are different from the source
Missing data for some dates
Data that should have been removed
When does this occur
The files you send to Funnel by email or SFTP have wrong or incomplete data.
Someone else sends the files to Funnel, and the data they send is wrong or incomplete.
Funnel pulls the data for you, for example through an API, an internal database, cloud storage or a reporting interface, and it doesn't match what you see in the source.
Root cause
Funnel stores the data it receives and keeps it until new data replaces it. Most data sources key on date. When Funnel receives a file, it reads the earliest and latest date in it and replaces the data it has for that date range. Any date in that range with no rows gets empty values. Data sources that don't key on date replace all their data each time Funnel receives a file. Learn how Funnel treats dates.
If wrong or incomplete data reaches Funnel, it stays there until correct data replaces it. When Funnel pulls the data for you, the cause can be in the source or in how Funnel collects the data, so Funnel needs to investigate it.
Solution
First, check that the data source has no error:
Go to Data > Connect > Data sources.
Find the data source and check its Status. If it shows an error status such as Error or No Access, fix that first. Learn what each status means in Request new data in Funnel.
Then follow the steps for how the data reaches Funnel.
If you send the files
Resend the correct data:
For a data source that keys on date, include the entire dataset for each date range you resend.
For a data source that doesn't key on date, resend a complete file with all the data you want to see in Funnel. Learn how Funnel handles dateless data.
To remove data that shouldn't be in Funnel, overwrite it with empty values. You can't delete data from these data sources. Learn how to overwrite date ranges from a data request.
If the data still doesn't match, contact support.
If someone else sends the files
Ask the person who sends the files to check the data and resend the correct data, following the steps in the previous section.
If they can't find the cause, contact support.
If Funnel pulls the data
Contact support. Include the data source ID, the date range and an example of the values that don't match.