Fourth

Fourth is a hospitality workforce and operations platform. With Weld, you can sync employee and labor data from Fourth into your data warehouse for reporting and analysis.

Features

Data Schema

Setup Guide - ELT

Step 1 - Gather your API credentials

Before setting up the connector in Weld, collect the following from Fourth:

• Organization ID — provided by Fourth
• Organization Sub Domain — your Fourth sub domain
• Username — the account username used for API access
• Password — the password for the API user account

These credentials are required to authenticate with Fourth's APIs.

Step 2 - Connect to Weld

1. In the connector setup form, enter the destination schema name of your choice. This name will be used to identify the connection in future syncs.
2. Enter your Organization ID, Organization Sub Domain, Username, and Password.
3. Click Connect to validate the credentials and establish the connection.

Step 3 - Select data to sync

1. Weld includes tables from both Fourth APIs:
   • Employees Fourth API
   • Team Hours API
2. Select the tables you wish to include in the sync. You can view the schema, remove columns, or hash sensitive information.

Step 4 - Configure sync

1. Select how often you would like the data to sync.
2. Check the Destination schema name, which is where the tables land in your warehouse, and click Start Initial Sync.

Weld will take over from here and commence syncing data from your Fourth account.

SQL Templates

View all →

Labour cost daily

Labour hours and cost per day and department, split by Fourth's payroll type, pay part and status.

grain: date x department x payroll type x pay part x status · builds on 4 models

Labour vs sales

Labour cost as a share of sales, and sales per labour hour, per day and department. The headline wage-percentage view in Fourth.

grain: date x department · builds on 5 models

Sales forecast accuracy

How close Fourth's system forecast and the manager's forecast came to actual sales, per day, department and sales type. Forecasts drive the rota, so a forecast that runs high is labour cost spent on empty tables.

grain: date x department x sales type · builds on 4 models

Staffing accuracy

Fourth's productivity view: of the hours worked each day, how many were at the right staffing level, and how many under or over the requirement.

grain: date x location · builds on 1 model

Weekly budget vs actual

Budgeted sales and labour against actuals, per budget week, location and department.

grain: budget week x location x department · builds on 6 models