Delta Air Lines Modernizes Marketing Budget Management With Quickbase Automation

The Solutions

Rebuilding Delta's Quickbase Marketing Budget Management Platform

Quandary Consulting Group redesigned Delta Air Lines' existing Quickbase marketing application around a more scalable financial architecture.

Instead of applying incremental fixes to the existing structure, Quandary rebuilt the underlying budget logic so financial information originated at the project, source, and quarterly level before rolling upward into campaigns, teams, and annual departmental budgets. This created a cleaner relationship between detailed marketing activity and executive-level financial reporting and the result was a more connected financial operating model for Delta's marketing organization.

The new architecture allowed Delta to manage: Projects → Quarterly Plans → Funding Sources → Commitments → Budget Transfers → Invoices → Accruals → Team Budgets → Annual Marketing Performance

Automating Quarterly Marketing Budget Planning

Quandary introduced automation throughout the quarterly planning process. When projects were created, the application generated the appropriate quarterly planning records based on project start and end dates. New projects extending across a full year could automatically receive the necessary quarterly records instead of requiring employees to manually create each planning period.

Remaining budget amounts could also roll forward automatically and this transformed quarterly planning from a repetitive administrative exercise into a structured workflow driven by project data. Delta's marketing teams gained a clearer view of:

• Planned budget
• Active budget
• Committed funds
• Uncommitted funds
• Quarterly allocations
• Budget adjustments
• Remaining available funding

The application also enabled users to commit funding across all four quarters at once, reducing repetitive data entry associated with managing multi-quarter projects.

Automating Marketing Budget Transfers and Adjustments

Quandary also streamlined Delta's budget transfer process. New project plans could flow directly into budget transfer/change-budget requests, with relevant fields and values automatically populated. When approved transfer requests were submitted, automation updated the corresponding financial plan rather than requiring employees to manually reconcile the adjustment. Delta also gained the ability to move funding between teams and quarters while maintaining controls around the overall budget.

This created a much more structured process: Budget Requirement → Transfer Request → Approval → Budget Adjustment → Updated Plan → Reporting

Instead of financial changes becoming separate administrative transactions that employees later had to reconcile, approved changes became part of the underlying budget model.

Establishing Team-Level Budget Targets and Spend Visibility

Quandary introduced annual target budgets at the team level, providing marketing leadership with a consistent financial benchmark. Initial budget amounts established by administrators could then evolve throughout the year as approved adjustments and budget transfers occurred.

The application connected those changes with actual financial activity so Delta could compare: Target Budget → Active Budget → Commitments → Invoices → Remaining Funds

This gave leadership a more meaningful view of marketing spend than simply looking at isolated transaction records and teams could see where they stood against their targets and identify potential budget issues earlier.

Connecting Accruals With Marketing Projects and Invoices

The redesigned Quickbase application also strengthened marketing accrual management. Pending invoice amounts were reflected against the appropriate projects, helping Delta maintain visibility into financial obligations that had not yet been completely processed. Project owners received visibility into pending accruals, while incoming invoices could be matched with the corresponding financial activity.

This helped Delta distinguish between funds that were technically unspent and funds that were already effectively committed to outstanding obligations and the distinction created a more accurate view of true available marketing budget.

Introducing Proactive Budget Notifications

Rather than requiring employees to continually check the application for changes, Quandary introduced automated notifications around important financial events.

The system proactively surfaced conditions such as:

• Budget requests awaiting approval
• New invoices added to projects
• Invoiced amounts exceeding active budgets
• Successful budget request submissions and next steps
• Remaining uncommitted funds at month-end or quarter-end

These notifications turned Quickbase from a passive repository into a more proactive marketing budget monitoring system and employees no longer needed to discover every issue themselves. The platform helped identify conditions requiring attention and routed that information to the appropriate stakeholders.

Creating Role-Based Dashboards and a More Intuitive User Experience

Quandary redesigned Delta's Quickbase dashboards to provide a clearer, high-level view of marketing budget performance.

Unnecessary information was removed from user-facing views, while administrative and adjustment tables remained available where appropriate. Users could also designate frequently accessed projects as favorites, bringing the projects they managed most often to the forefront of dashboards and budget actions and dropdown menus were cleaned up so inactive teams and projects from previous years no longer cluttered current workflows.

These seemingly small improvements had an important cumulative effect: employees spent less time navigating the application and more time managing the work that mattered.

Embedding Training Directly Into Quickbase

Quandary also brought Delta's Quickbase training resources closer to the employees who needed them. Rather than requiring users to locate tutorials stored separately in Microsoft Teams, updated training materials were incorporated into a dedicated Quickbase Tutorials experience and this created a more self-service environment for application users and reduced dependence on institutional knowledge.

Strengthening Enterprise Access With Delta SSO

Finally, the application was configured to support Single Sign-On using Delta credentials, improving both ease of access and enterprise security and employees could access the marketing budget application using their established Delta identity rather than managing a separate authentication experience.