Sponsors

The Sponsors database stores all of the brands and sponsors that you either currently work with, or would like to work with in the future.

This database allows you to relate Sponsors to Content projects, showing how much money you’ve booked with each Sponsor and breaking that figure down into paid and unpaid amounts. You can also keep track of interactions, save talking points and assets, and easily save reference spots and integrations made by other creators to use as inspiration for your own ads.

Finally, Sponsors includes CRM/outreach-tracking features, which enables the deal-tracking pipeline on the Sponsor Tracker.

Below, you’ll find a reference guide for all database templates and properties in the Sponsors database. Properties are in alphabetical order.

Database Templates

Sponsor

content

Properties

Agency

Type: Multi Select

If you work with this sponsor/brand through an agency, you can add that agency as a tag here.

This property comes with no default options. Unlock the Sponsors database to add new options.

Channels

Type: Formula

Displays the channels on which you’ve been sponsored by this brand, along with some other helpful info.

prop("Content").map(
	current.prop("Channel")
).filter(
	!current.empty()
).flat().unique().map(
	lets(
		channel,
		current,
		spotCount,
		channel.prop("Content").filter(
			current.prop("Sponsor").map(current.id()).includes(id())
		).length(),
		plurality,
		spotCount == 1 ? "" : "s",
		[spotCount, channel + " " + ("(" + spotCount + " Spot" + plurality + ")").style("b", "c", "green", "green_background")]
	)
).sort(current.at(0)).reverse().map(
	current.last()
).join("\n")
Code language: JavaScript (javascript)

Content

Type: Relation

Any content projects related to this sponsor – e.g. projects that have been sponsored by this brand.

This Relation property connects to the Sponsor Relation property in the Content database.

Deal Closed

Type: Date

The date you closed a deal with this sponsor. If you also track your Reached Out date, it’s easy to see how long it took to get a response and close a deal with this sponsor.

Follow-Up

Type: Date

Use this property to set a follow-up date for sponsors that haven’t yet responded to your outreach.

This is a useful property to track using Notion Calendar if you’re doing a lot of sponsor outreach.

Name

Type: Title

The name of this sponsor/brand.

Paid Spots

Type: Rollup

The number of spots this brand has paid for.

Pay Structure

Type: Select

Note the pay schedule structure this sponsor uses here. This will be used to calculate the Pay Due Date in the Content database, which drives the Unpaid Content view in the Maintenance dashboard.

Unlock the Sponsors database to add new options.

Name	Description
On Deal Close	Deals that pay right when the deal is signed (pre-paying for content to be published).
On Publish	Deals that pay immediately when the sponsored content is published.
EOM	Deals that pay at the end of the month.
Net 30	Deals that will be paid 30 days after publish.
Net 30 (EOM)	Deals that will be paid ~30 days after the end of the month in which the content was published. In effect, at the end of the next month (Net 30 EOM terms typically use the end of the next month rather than a strict 30 days).
Net 60	Deals that will be paid 30 days after publish.
Net 60 (EOM)	Deals that will be paid 60 days after the end of the month in which the content was published. In effect, 2 months after the end of the publish month.

Reached Out

Type: Date

The date you initially reached out to this sponsor.

Spot Count

Type: Rollup

The number of spots you’ve booked with this sponsor.

Status

Type: Status

The status of your relationship with this sponsor. You can use this property for tracking outreach efforts with sponsors, as well as to mark sponsors as Active (i.e. you expect they’ll sponsor you again) or Inactive.

Unlock the Sponsors database to add new options.

Name	Description
Group: To-do
Prospective	Potential sponsors you’d like to work with, but haven’t contacted yet.
Group: In progress
Reached Out	Sponsors to whom you’ve reached out.
Negotiating	Sponsors who have responded positively, and with whom you’re actively negotiating a deal.
Group: Complete
Rejected	Brands who rejected your pitch.
Active	Sponsors with whom you have an active working relationship; you expect they’ll sponsor future content.
Past – Inactive	Sponsors you’ve worked with, who don’t seem likely to sponsor future content.

Total Booked

Type: Rollup

The total amount of money booked through this sponsor, both paid and unpaid.

Total Outstanding

Type: Formula

The total amount of money you’ve booked with this sponsor that hasn’t yet been paid.

This can include late payments, as well as money that will be paid on planned content once it is published.

if(
	prop("Content").empty(),
	"".toNumber(),
	prop("Content").filter(
		current.prop("Paid") == false
	).map(
		current.prop("Sponsor Rate")
	).sum()
)
Code language: JavaScript (javascript)

Total Paid

Type: Formula

The total amount of money this sponsor has paid you.

if(
	prop("Content").empty(),
	"".toNumber(),
	prop("Content").filter(
		current.prop("Paid") == true
	).map(
		current.prop("Sponsor Rate")
	).sum()
)
Code language: JavaScript (javascript)