Important information about data updates
We manage each retailer’s data for you in a bespoke fashion. During the onboarding process we agree on a data format, and the method we will be receiving it, with you. With this information, we automate the weekly loading of the files, so you have access to the data as quickly as possible each week.
Pulling Data
When pulling data from portals, the content we utilize is done so in a way to give you specific outcomes in your krunchbox reports. We are reliant on access, data availability, and content to be without error, to do so. From time to time, one of these three elements may fail but we will work to resolve any issues and come to you for intervention only when it is necessary.
There may be times when your team views portal content prior to it being available in krunchbox. If the content we are loading is available and without error we will not be far behind.
On some occasions, only part of your portal content may be available. In this case, we will avoid loading the data until it is complete to avoid misunderstandings on the results.
Data Exceptions
Data can be absent for a number of reasons. The most common are:
- We could not access it
- It was not available
- The content was dubious and is being investigated
- The format changed and we were unable to auto load it, and it is being handled by our team
If the file naming convention, the content column headers or the file extension changes then the file will not load automatically and a delay of up to 48 hours may occur as we investigate and manually repair the file for loading. We will then attempt to put in place future corrective actions where possible.
Pushing Data
Content provided directly to us from other avenues such as EDI or spreadsheet goes through the same load testing process. Data availability is dependent on where it is coming from and whether the push to us is manual (forwarded from someone's email) or automated (like retailer EDI systems).
In our experience, manual is generally more problematic as it is reliant on people to keep the process consistent.
Data Timing
For each retailer, we know which day to expect the content and all attempts will be made to load the data on that day. If the retailer does not make the data available by the close of business on the expected day, we have processes in place to alert us that something is not going to plan. We will contact you at the close of the business day regarding issues with data availability.
Data History
The number of weeks of history in krunchbox may vary by retailer. To investigate how many weeks of data is available, use the Data Load Status on the splash page and click the History button.
What happens when something goes wrong?
If the content we receive does not pass the loading or testing processes, you can be assured that our team is investigating and correcting the issue where possible. In some cases, we can correct the problem without involving your team and you will experience a delay in viewing the outcomes. There may be instances where we are made aware of incorrect content after it is loaded. In this case we will remove the data and reload when correct content is provided. You will receive multiple load notifications in this instance. In a small number of cases, we may need to defer to you to resolve the issue.
And what about when everything goes to plan?
When all goes well, and this is the majority of cases, you will receive an email notification (if opted in). Your krunchbox site will also display loading status on your home screen. While krunchbox is not responsible for the content provided by the retailer or other sources, and is not in a position to validate the content, we will do our best to investigate and correct content when you share any concerns with us. If the data format, receipt method, naming convention, content, remain consistent then our bespoke automated loading processes should ensure you have access to the content as quicky as possible.
What we need from you
To ensure we can support you in your data needs, we ask that you advise us of:
- any portal access changes
- any password changes
- staff changes, especially those assisting with data connection
- new vendor numbers
- changes in data or delays you may be aware of
- business changes that may impact the satisfaction you receive in the data we pull for you