The Basic Properties

There are properties that can be really useful for building and analyzing Twitter threads. They include the Date a thread was posted or scheduled for, a Weekday formula to return the day of the week from the date, a Reception property to give the thread a star rating, a Media property to save images attached to the thread, a Published checkbox, a Link property to the published tweet, a Mentioned multi-select property to group by mentions, and of course, a dozen tweet boxes with a character limit (up to 280) formula.

The Character Limit Formula

For each text box, or tweet box, the user can write each tweet up to 280 characters. The sum of all characters will be calculated and a counter will begin upon writing. When the counter exceeds 280 characters, a warning will appear.

The Formula

if(empty(prop("🅰️ Tweet A")), "", if(length(prop("🅰️ Tweet A")) / 280 <= 1, "✅ " + format(length(prop("🅰️ Tweet A"))) + "/" + "280", "⛔️ Too many characters"))

How to add new tweet boxes

1. Create a new text property, a.k.a tweet box, to write the tweet in.

2. Create a new formula property and paste the above formula.

3. Change every instance of "🅰️ Tweet A" to the name of the new tweet box.

The Database Views

There are six database views to analyze and add new threads. Most of them use Notion’s new grouping feature too!

Group by: Active Threads

This view groups by the Published checkbox. One group is for active threads and the other for published. This is a good place to add new threads in addition to the Add new thread view.

Group by: Week

This view groups threads by weeks starting on a Sunday and ending on a Saturday. Users can revisit old threads here. There is also the ability to group by months via the group configuration located in the database menu.

Group by: Reception

This view groups by the Reception multi-select property of which has a star rating dropdown menu. Another great way to revisit or analyze threads regarding popularity.

Group by: Mentioned

This view lets the user organize threads by Mentioned people or organizations in their threads. Are there particular mentions that garner better reception? You’ll be able to determine that here.

Group by: Weekday (Read Only)

Create more properties to analyze threads with more precision using formulas and a little creativity. The last view is for grouping threads by Weekday. Yes, you can group by formula results in Notion. In this case, the user can determine how well a thread performs on a Monday vs a Thursday.

Further Reading