website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
ConnectWise
Google Sheets
Aloha POS
BILL
Bloom Growth
Ceridian Dayforce
Food Delivery Service Connector
Facebook Ads
Google Analytics 4
Harvest
Hubspot
Jira
McLeod Transportation
NetSuite (Oracle NetSuite)
Optimum HRIS
QuickBooks Online
Salesforce
Shopify
Square
Square Marketplace
Stripe
Workday HCM
Xero
Databases
SQL Transformations
Terraform: Reverse Terraforming
DBT Cloud Transformations
Sync Bridge (Data Pipelines)
Create a Sync Bridge
Manually Run a Sync Bridge
Deleting a Sync Bridge
Analytics
Access Analytics
Snowflake Usage Analytics
FAQ (about syncing data)
How are new columns are added to the target Data Warehouse?
....
Data Catalog
Create the Catalog
Populate the Catalog
Access the Catalog
Data Warehousing
Snowflake
Open Source DW Models
Alerts & Notifications
Integrations (Slack, etc.)
Logs & Monitoring
Security
Release Notes
April 2022
July 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
Our
License
Viewpoint
Docs powered by archbee 
5min

Food Delivery Service Connector

DataLakeHouse.io is not affiliated with DoorDash® or GrubHub®. They both offer a corporate or business-to-business platform where employers can incentivize employees with a budget or line of credit from which to purchase meals. Extracting food delivery orders from the DD4W or GH platform and enabling analytics on employee behavior and key performance indicators, can help determine whether the program is effective, showcase on which types of days employees most order, and if employees consistently have order ticket dollar amounts higher than their budgeted amounts, etc.

Most of the data from your food delivery service is in a set of monthly .zip files (i.e.: only one CSV per zip file when extracted) from the admin panel of the account.

Setup Instructions

Data on budget spend or line of credit spend and other order details is only available for an account having the "Admin" role or privilege granted to it. This typically requires some form of authentication from Food Delivery Service Admin Panel. Each service varies on levels of access, etc.. If you need a walkthrough of how to use your Food Delivery Service please contact our support team.

Alternative Setup Instructions (If requiring manual approach)

You need to make sure that you:

  1. Download or otherwise obtain access to the monthly food delivery service orders data, usually manually and in the format of .zip files (only one CSV per zip file when extracted) from your account
  2. Extract all the CSV files from your downloads
  3. From here you can use our open source academic dbt model to explore the data
  4. Contact us if you need assistance

Affiliations

It must be noted that DataLakeHouse.io is not affiliated directly with any food delivery services. This concept is provided here as a non-commercial and academic reference. Please use your best judgement regarding accessing your data from any source systems or downloading information files on your organization's behalf.

Support

If you need any assistance setting up or configuring your DD4W or GH integration please contact our support team.

Replicated Entities

The following table is typically available in your target since all of your data from the food service company is stored in a single file format there is only the one table for the analytics model to process:

  • ORDER_HISTORY



Updated 19 Feb 2023
Did this page help you?
Yes
No
UP NEXT
Food Delivery Service : Change Log
Docs powered by archbee 
TABLE OF CONTENTS
Setup Instructions
Alternative Setup Instructions (If requiring manual approach)
Affiliations
Support
Replicated Entities