Understand the Sponsorship Airtable Base

From MoHA Wiki


Sponsorship airtable base.png

Purpose:

A walkthrough of the various parts of the Sponsorships Airtable.

Overview:

There are three main tabs in the Sponsorship Airtable:

  • Sponsorship Asks
  • Annual
  • Events

Sponsorship Asks

Sponsorship asks tab.png


Within the “Sponsorship Asks” tab there are:

  • Views
  • Events

Views

Sponsorship asks view.png


The menu displays on the left side. You can move views by dragging them.

Main

  • In-Progress Events (single time)
  • Annual (ongoing, bigger asks)

Events

Sponsorship asks view events.png


This is where all information is tracked. When interest is flagged, information is filled out in the corresponding columns:

  • Events
  • Status
  • Last Contacted
  • Notes
  • Company

Annual

Annual tab.png


This tab tracks longer term asks.


Annual support tab.png

The Annual Support tab shows who MoHA might ask for support and why this company. The following information is found here:

  • Ask Template
    • A template for making an ask.
  • Why this company
    • Explanation of why MoHA is asking them.
  • Point of Contact
  • Ranking of Priority
  • Stage
    • Researching
    • Accepted
    • Cultivated
    • Asked
  • Next Steps
    • Schedule Meeting
    • Submit Proposal
    • Follow-up Call
    • Follow-up Email
    • Thank You
  • Next Steps Due
    • When action needs to be taken on those steps
  • Other Organizations Supported
  • MoHA Staff
    • Which staff member is linked to the ask
  • Year
  • Additional Notes
  • Product Donation
  • Liquor
  • Cash Ask
  • Cash Received

Events

Events tab.png


This tab tracks asks for specific events.

Upcoming Events

Use this database to track asks and sponsorship needs for upcoming events. Airtable’s bases are Synced, so the Sponsorship base is synced. Upcoming Events pulls from the Events base. Sometimes it makes more sense to break events into multiple days if needed.

  • Ex. “Austin Studio Tour Day 1,” “Austin Studio Tour Day 2,” etc.

Upcoming events tab.png


Main View

Events main view tab.png


This showcases all the events and has all the same details as the previous views. It also shows:

  • Sponsorship Asks
    • Status
    • Which sponsors per eventThen the status, and then which sponsors per event.
  • Status of Event
    • Already happened
    • Upcoming

Related links