Build a LinkedIn Content Tracker on Notion from scratch with me! (Part 2)

A few days ago I put up my first Notion template for sale! I also posted about its features, benefits, and how to use it.

Click here to see the post:

A Walkthrough of my LinkedIn Content Dashboard on Notion

Today I’ll teach you how to build this template from scratch. (If you don’t want to pay $10 for the template.) But, if you want to get it immediately without building it, you can buy it here!

https://stayontask.gumroad.com/l/linkedincontenttracker

Welcome to part 2! If you haven’t read part 1, I split this tutorial in half to get these posts out faster. Here’s the link to part 1:

In Part 1, I explained that this template has 7 parts.

1. Posts Database

2. Notes Database

3. Analytics Database

4. Home Page

5. Analytics Section

6. Focus Page

7. Document Templates

Now we should have 3 of those parts done: the Posts Database, Notes Database, and the Home Page. This is what we have left:

1. Analytics Database

2. Analytics Section on Home Page

3. Focus Page

4. Document Templates

So let’s finish this template off!

Analytics Database

So this template will keep track of all our post statistics and analytics. It will take some numbers from the Post Database and we’ll create formulas to show ratios and percentages.

To create the database, go into an empty block and type “/page”. When you enter the page, click on “Table” near the bottom right. On the right, select “New table” and call it “Analytics”. (For the sake of not having to write “Analytics Database” every time I refer to this page. Also, I will change the Post Database and Notes Database names to just “Posts” and “Notes”.)

Let’s start creating properties.

1. Delete the “Tags” property.

2. Add a “Relation” property.

3. Under “Related to”, select “Posts”.

4. Make sure to NOT show on “Posts”.

5. Click on “Add relation”.

Now that we have a Relation, we can add all the rollups. This might take a while because we need to add 10 rollups and 6 formulas.

1. Add a property as a “rollup”.

2. For “Relation”, select “Posts”.

3. Duplicate the property until there are 10 rollup columns. It should say “Duplicate Property” when you click on the property name.

4. Let’s go through the rollups.

5. First, we have the link to the post.

   1. In the first rollup column, select “Edit property”.

   2. Next to “Property”, click on the menu and select your “Link to Post” property from “Posts”.

   3. Make sure under “Calculate”, it says “Show original”.

   4. Do this same method for the rest of the rollups.

6. The next three are the independent variables.

   1. The 2nd - 4th rollups will be “Hashtags”, “Topics”, and “Day and Time”.

   2. Go into each Rollup menu to select each of those 3 in the “Property” menu.

   3. This is what it should look like so far:

7. The next 6 will be the numbers from “Posts”.

   1. Impressions, Likes, Comments, Reposts, Followers, and Followers Gained.

   2. Go into each rollup menu to select each of those 6 in the “Property” menu.

   3. This is how it should look with the 10 rollups.

8. Let’s add the 6 formulas.

   1. Add a new property and select “Formula”.

   2. Duplicate until you have 6 of these columns.

9. Name the first column “Reactions/Impressions”.

   1. Click on the formula box below the top row.

   2. There should be your properties listed right below the text box.

   3. Select “Reactions”, type “/” and then select “Impressions”.

   4. You’ll notice this message pop up: “Cannot do math on array and array. [0,3]”. This is because rollups are arrays¹ by default so you can’t do math operations on them. To fix this, we will take just the first (and only) value of the arrays in each rollup.

   5. So type in “first()” twice (for each of the property names) and insert the rollups into the brackets. The entire formula should look like this. We’ll be using this structure for the rest of the formulas.

10. Name the second formula “Comments/Reactions”.

    1. In the formula box, type in “first(Comments)/first(Reactions)”.

    2. For the property names, you can just select from the list below the text box.

11. Name the third formula “Comments/Impressions”. I think you can see where I’m going with this.

    1. In the formula box, type in “first(Comments)/first(Impressions)”.

    2. Again, select the properties from the list.

12. The fourth should be called “Reposts/Impressions”.

    1. In the formula box, type in “first(Reposts)/first(Impressions)”.

13. The fifth should be called “Followers Gained/Impressions”.

    1. In the formula box, type in “first(Followers Gained)/first(Impressions)”.

14. The final formula should be called “Impressions/Followers”.

    1. In the formula box, type in “first(Impressions)/first(Followers)”.

15. This is how it should look with all of the formulas. I’ll add example posts and fill in all of the numbers so that you can see how it works.

That’s the full database complete! Now let’s add a section to the Home Page of organized versions of this table.

Analytics on the Home Page

Let’s go back to the Home Page.

Scroll down below the calendar and enter a new line.

Let’s add a divider. Just type “-” 3 times and you’ll see a thin gray line across the page.

To give this section a heading type “/h1” and hit Enter. Type “Analytics” as the header.

We will have 3 parts of this section each containing a table with three tabs.

1. The Basic Stats - Impressions, Reactions, Comments, Reposts.

2. The Engagement Stats (the ratios) - Reactions/Impressions, Comments/Reactions, Comments/Impressions, Reposts/Impressions.

3. The Follower Stats - Followers, Followers Gained, Followers Gained/Impressions, Impressions/Followers.

Don’t worry, this will take shorter than you think. It’s all about copy + paste!

• Enter a new line and type “/linked” for a new database.

• Select your “Analytics” page.

• Select “Table” since you don’t need a new view.

• Make sure the properties are all ordered the way we made them in the previous section. This is how the order should be:

1. We’ll have 3 tabs in each section, for the 3 independent variables of this data.

   1. Day and Time

   2. Hashtags

   3. Topics

2. At the top left of the table, click on “Table” and select “Duplicate” in the menu. Do this twice so you have 3 tabs.

3. Name the first one “Day and Time”.

   1. In this view, remove (not delete!) the “Hashtags” and “Topics” from the shown properties.

4. Name the second “Hashtags”.

   1. In this view, remove (again, not delete!) the “Day and Time” and “Topics” from the shown properties.

5. Name the third “Topics”.

   1. In this view, remove (again, not delete!) the “Day and Time” and “Hashtags” from the shown properties.

6. This is what each view should look like right now.

   

   

   

7. We need to make 3 of these, so we have to duplicate it twice. To duplicate the table, hold “alt” and drag the table down with the 6 dots on the left. Now there should be two identical tables. Do this again and you’ll get a third.

8. Let’s make the headings for each table. Type in “/h2” for Heading 2 text.

9. Above the first table, name it “Basic Stats” in the heading.

   1. This table will just show Impressions, Reactions, Comments, and Reposts in each of the three tabs.

   2. To change the shown properties, click on the 3 dots at the top right of the table next to the blue “New” button.

   3. In the menu, select “Properties”.

   4. Use the eye icon next to all of the property names to hide the property. For this section, hide everything below “Reposts” as shown in the video.

10. Above the second table, write “Engagement” in the heading.

    1. This table will show Reactions/Impressions, Comments/Reactions, Comments/Impressions, and Reposts/Impressions.

    2. To change the shown properties, click on the 3 dots at the top right of the table and select “Properties”.

    3. Use the eye icon to hide the properties. For this section, hide the properties from Impressions to Reposts and from Followers and below. See the video.

11. Above the third table, write “Followers” in the heading.

    1. This table will show Followers, Followers Gained, Followers Gained/Impressions, and Impressions/Followers.

    2. To change the shown properties, click on the 3 dots at the top right of the table and select “Properties”.

    3. Use the eye icon to hide the properties. For this section, hide all properties from Impressions to Reposts/Impressions. See the video.

With that, we’re finished with the Analytics section. Here’s what the completed section should look like, including some posts that you can compare:

We set the formulas up to show as regular numbers but if you want percentages:

• For each formula, go to “Edit property”, click on “Number format”, and select “Percent”.

We only have a few sections left in this template before you have a fully functioning LinkedIn Content Tracker!

The Focus Page

In my template walkthrough post, I said that the Focus Page is meant to block out all the other distractions with a minimal design to help you focus on writing or editing. Now when I said distractions, I meant the rest of my template. But my template isn’t a distraction!

The better wording would be: Without the pressure of a calendar or analytics, this page helps you enter a flow state where you can write or edit without interruption. That’s why I called it a Focus Page. I believe more templates should have a feature like this. One that cuts through the noise and helps you get started.

Anyways, let’s build it!

Enter a new line at the top and type in “/page” to create a new page. Name this one “Focus”. There are 4 parts to this: the buttons, the writing section, the editing section, and the notes section. This should be much faster than the other sections since we have everything we need.

Buttons

We’ll have three buttons: “New Post”, “New Note”, and “Open Notes”. What’s great is that we’ve already created these buttons on the Home Page (except “Open Notes” oops). All we have to do is duplicate them.

1. Go back to the Home Page.

2. Hover your mouse over the “New Draft” button.

3. Hold “alt” and drag the button with the 6 dots on the side.

4. Drag the button into the Focus page. The page should highlight blue when the button is hovering over it.

5. Hover your mouse over the “New Notes” button and do the same “alt” and drag into the Focus page again.

6. Go back to the Focus page. Both buttons should be there.

7. Enter a new line and type “/button” to create a new button.

8. Name it “Open Notes”.

9. Click on “Add action” and select “Open page”.

10. Click on “Select page” and select “Notes”.

11. Set it to open in “Full page”, otherwise the database won’t show.

12. You can also put the buttons in columns to save space.

Writing

Enter a new line below the buttons and type “/h1”. Name this section “Write”.

Let’s make a table that helps you focus on what you need to write.

1. Type “/linked” and hit Enter.

2. Select your Posts database.

3. Select “New table view”.

4. You can name it “Write” or “To Write”.

5. Click on the filter icon on the top bar of the table.

6. Select “Status” and filter only for “Ideas”.

7. The only properties that need to be shown here are “Name”, “Type”, “Status”, and “Related Notes”.

That’s it. You can also hide the database title by clicking on the 3 dots next to it and selecting “Hide database title”.

Editing

Enter a new line below the Writing section and type “/h1”. Name this section “Edit”.

Let’s make the Editing table which just focuses on posts that you need to edit.

1. Type “/linked” and hit Enter.

2. Select your Posts database.

3. Select “New table view”.

4. Name it “Edit” or “Editing”.

5. Click on the filter icon on the top bar of the table.

6. Select “Status” and filter only for “Drafts”.

7. You can show more properties in this view like “Days from Post”, “Carousel File”, “Hashtags” and “Topics”.

Notes Gallery

Let’s create the notes gallery. We can do the same duplication trick with the buttons since we have a version of it on the Home page.

1. Go back to the Home Page.

2. Hover over the 6 dots in the Notes gallery to drag.

3. Hold “alt” and drag the gallery into the Focus page like before.

4. Go back to the Focus page.

5. Right above the Notes gallery, type “/h1” for a heading and type “Notes” as the name of the section.

6. You don’t need to change any of the gallery settings.

Focus Page done! We have one more section left! We’re almost there!

Document Templates

When you start writing a post, you don’t always want to start with an empty page with no outline or prompts. You also don’t want to keep writing the same lines repeatedly.

For example, in all of my posts, I have this line: “Follow me at Sidd Shenoi and repost to your network!”

Since I don’t want to write that every time. I create templates. Not to be confused with Notion templates that are full systems. These are document templates that will create pages with text automatically filled in. Let’s create some in our Posts database!

We’re going to be creating 2: one for written posts, and one for carousels.

Go to the Posts full-page database. On the top right of the table, there should be a blue button saying “New”. Click on the down arrow next to that and click on where it says “New template”. Do this for both templates.

Written Post Templates

1. Name it “Post”. Or you don’t have to name it.

2. Set the Type to “Post”.

3. Set the Status to “Idea” or “Draft” whichever you prefer.

4. Finally, write some common phrases that you always say in every post.

5. Just click outside of the template to stop editing.

Carousel Post Templates

1. Name this template “Carousel”. Or leave it blank.

2. Set the Type to “Carousel”.

3. Set the Status to “Idea” or “Draft” whichever you prefer.

4. In this template, you can put links to Canva, Google Slides, or wherever you create LinkedIn carousels.

5. You can also type “/image” to create a box to put your carousel file in.

6. Click outside of the template to stop editing.

If you want to go back and edit the template again:

1. Go back to the down arrow in the blue box.

2. Click on the 3 dots across from the template name.

3. Click on “Edit”.

Add it to the buttons!

1. Go to the Home page.

2. Click on the gear next to the “New Draft” button to edit.

3. Where it says “Add page to “Posts” as Empty”, click on “Empty” to switch it to the “Post” template.

4. Do the same for the “New Carousel” button and switch it to the “Carousel” template.

5. Now any time you click on the buttons, it should each create a new page with the templates.

6. You can do the same thing for the buttons on the Focus page.

And that is the LinkedIn Content Tracker!

Conclusion

Congratulations! That took a while but now you have your own LinkedIn Content Dashboard to help you rise to the next level in your LinkedIn writing journey. Also, you didn’t have a spend a dollar! You have this for free now!

Here’s the link if you still want to buy it: https://stayontask.gumroad.com/l/linkedincontenttracker

Check out my other articles! If you like my content, consider subscribing!

Thanks for reading.

1. Arrays in programming are essentially a list of values, whether numbers or text. They usually cannot be changed once the values are set.