Use Case

Marketing Operations and Project Management

A retail banking institution runs its marketing operations in Airtable, coordinating campaign workflows, managing external agency submissions, and tracking approvals in a shared workspace that replaced disconnected spreadsheets and brought cross-agency collaboration under a single platform.

The problem

Marketing operations were spread across disconnected spreadsheets, email threads, and agency-provided files. Campaign workflows had no structured tracking, and agency submissions arrived in inconsistent formats without a defined approval process. When agencies needed to submit records or upload data, they were given full workspace access, causing uncontrolled seat growth that created unexpected IT and billing overhead.

Without a shared platform, cross-agency coordination happened informally, and Marketing had no consolidated view of campaign status, pending approvals, or which submissions were complete. The lack of structure created bottlenecks and made it difficult to enforce consistent review and sign-off processes.

What they built

The Marketing team built a shared operations workspace in Airtable organized as project tables. Campaign workflows, approval routing, and agency record submissions are all tracked in one place. External agencies submit records through a defined intake process, and approvals follow a structured workflow rather than informal email chains.

IT and Marketing worked together to introduce portal-based access for agency submissions, replacing full external seats with a controlled submission mechanism. This limits the number of users with direct workspace access while still giving agencies a way to contribute records and data to the shared platform.

The outcome

Marketing now has a consolidated view of campaign status, agency submissions, and approval progress without assembling information from multiple sources. The structured approval workflow gives the team a consistent process for reviewing and signing off on agency work, and the intake records provide a documented history of all submissions.

Controlling external access through portal-based submissions reduced unmanaged seat growth. IT has better visibility into who has access to the marketing workspace, and the submission-based model scales to additional agency partners without requiring full-seat provisioning for each one.

Inside the solution

Marketing Operations and Project Management

Marketing and Campaign Operations

Program and Project Management

  • Marketing project and campaign workflow tracking
  • External agency record submissions and intake management
  • Campaign approval workflows with structured routing
  • Cross-agency coordination in a shared workspace
  • Uncontrolled external user seat growth from agency access
  • Fragmented campaign and agency data across spreadsheets
  • Lack of structured approval workflows for agency submissions
  • Structured campaign and project tracking in one platform
  • Controlled external collaboration through portal-based submissions
  • Reduced seat overhead from agency access management
  • Marketing
  • IT
  • External agency systems
  • Portals
Build out this use case

Marketing operations and project management

Run every marketing campaign, agency submission and approval in one shared workspace, with campaign status, intake completeness and sign-off progress visible on a single dashboard instead of scattered spreadsheets. Automations route new agency submissions to the right reviewer, push approved decisions back onto the campaign, open rework tasks when work is returned, and send a weekly digest, while AI fields triage incoming submissions, draft reviewer feedback and summarize campaign status.

Marketing operations and project management - Overview dashboard
How it works

How to build a marketing operations and project management workspace in Airtable

Define your campaign project structure

Set up a base with tables for active campaigns, agency submissions, and approval records. Capture status, owner, due date, and approval state for each campaign so the full pipeline is visible in one place without assembling spreadsheets.

Build structured agency submission intake

Create a submission form or interface that agencies use to upload records, files, and data. Route submissions to the appropriate internal reviewer automatically, and track the submission status on the intake record so nothing falls through the gaps.

Set up approval routing workflows

Configure approval stages with automations that notify reviewers when a submission is ready and update status when it is approved or returned for revision. This replaces email-based approval chains with a tracked, auditable process.

Control external access with portals

Use Airtable's portal feature to give agency partners submission access without full workspace seats. Define what each external user can see and submit so cross-agency collaboration is controlled and seat counts stay predictable.

Create shared campaign visibility for leadership

Build a shared interface view that shows campaign status, pending approvals, and submission completion across the full marketing program. Give Marketing leadership and IT the oversight they need without exposing the full operational dataset.

FAQ

Frequently asked questions

Airtable's portal feature allows external agencies to submit records and data through a controlled interface without being added as full workspace members. This limits seat provisioning to internal team members while still giving agencies a structured way to contribute to the shared platform, preventing the uncontrolled seat growth that occurs when agencies are given direct workspace access.

Yes. The retail banking institution consolidated its marketing campaign workflows, agency submissions, and approval routing into a single Airtable workspace, replacing fragmented spreadsheets. All campaign status, intake records, and approvals are tracked in one place, giving Marketing a consistent view of project progress without assembling data from multiple files.

When an agency submission is received, an automation routes it to the designated internal reviewer and updates the submission status. Reviewers are notified when action is required and can approve or return submissions with comments directly in Airtable. Every status change is logged, providing a documented history of each approval without relying on email threads.

Organizing marketing operations as structured Airtable tables gives each campaign a consistent record with status, owner, deadline, and approval state. This makes it easy to filter and view campaigns by status, identify bottlenecks, and give leadership a reliable view of the program without manual report assembly.

IT and Marketing use Airtable's permission and portal settings to control which external users can access the workspace and what they can see or submit. IT manages seat provisioning and access policy while Marketing manages the operational content. Portal-based submissions reduce the number of external users who need direct workspace access, making the coordination straightforward.

Reading document head…