FreshDirect needed to provide the historical data including visit and transactional data to Planalytics broken down by app and web platforms in addition to location, shopping mode (today’s delivery or later one), and if a client was an individual or a company.
Napkyn, the FreshDirect long measurement partner, offered to leverage BigQuery to build the reports and send them to Google Cloud Storage, so they would be available for download as CSV files.
Napkyn wrote a series of BigQuery SQL queries to produce tables that are in a format that Planalytics needed for as much historical data as were available in BigQuery for web as well as app data.
In Google Cloud Storage, the files were automatically partitioned into several downloadable files.