<aside> 💡 How to use this template

1. Copy this Notion template.
2. Go to GRID (you can sign up for a free account if you don’t already have one) and copy the GRID document for the Notion Link Preview in this template.
3. Replace the spreadsheet in the GRID document with your own data. Note: if you ensure that your data is laid out in the same way as the sample spreadsheet, you won’t have to update any references in the GRID document, and it will work seamlessly with your numbers.
4. Replace the link in this Notion template with the link to your own GRID document.
5. Share with your team!

</aside>

December summary

We finished the year on a high, setting a new monthly record in signups and subscribers. Organic traffic has been driving our growth throughout the year and we had an 8.3% increase in signups and an 8.1% increase in subscribers from organic traffic this month.

<aside> 💡 5.512 Total signups 481 New subscribers

</aside>

Signups

Subscribers

For the first time, we got over 2500 signups from paid channels. As we can see in the table below, signups from paid channels have been around 230 this quarter as our budget has pretty much remained the same. Meanwhile, we have seen a 277% ****increase in organic signups since the beginning of the year with an average of 9.9% ****monthly organic growth.

We acquired 481 subscribers in December and continued beating our monthly subscription record for the 8th month in a row. December was the first month we gained more subscribers from organic traffic than paid.

Our cost per signup in December was $9.1 and the conversion rate from website visitor to signup was 12.3%

Our cost per subscriber in December was $104 and the conversion rate from visitor to subscriber was 8.7%.

Projection tool

Use the tool below to project the next month’s marketing effort, find the most profitable budget allocation and spot the easiest point for improvement.

How to use:

Use the total budget slider to adjust your total advertising spend for the coming month. In the budget allocation column you can allocate your total budget to the five different advertising platforms, but make sure they add up to exactly 100%.

From the platform dropdown, you can select which advertising platform’s assumptions you want to interact with. You can adjust the CPC (cost per click), conversion rate (from website visitor to signup) and the signup to subscriber conversion rate.

You’ll see the results of a slight change in the model appear immediately in the table and bar chart below. You can use this to compare last month's numbers as well as the average of the last three months.

↓ Embed your GRID data app here

https://grid.is/@grid_templates/budget-allocation-for-social-media-1zoyfuWXQOiuwwAaTltK3g