How to use an excel tracking spreadsheet for Pinterest
To achieve the best results, you must follow-up your daily Pinterest activity. That means, you should:
- Track your Pins
- Maintain a daily pinning schedule
- Pin each Pin to all the relevant boards
- Pin the best Pins to the best boards first, and pin them more often
- Mark the best performing or underperforming Pins
Use spreadsheets to track your daily activity. Either an Excel file or Google sheets, whatever is more comfortable for you.
Your spreadsheets should include a list of your boards, a list of your Pins (with their links), a pinning schedule, and additional details that will help you sort your pins, such as pin topics, article number, etc.
Here is a screenshot of the spreadsheet I use:
- Last Pinned/scheduled on Tailwind – Last date the Pin was pinned or scheduled to be pinned.
- Topic – The topic of the Pin. Use this criterion only when your blog covers more than one niche.
- Article number – chronological order of your published Pins/articles.
- Pin Scale – Marked Pins from 1 to 5 according to my Pin Scale Strategy (more details below).
- Article – Name of the article.
- Pin URL – Link to the Pin.
- Sum – The total number of times you repined a specific Pin.
- The pink cells – Filled with all the boards/group boards you have on Pinterest.
- The yellow cells – Will contain the number of times you pinned a specific Pin.
Let’s simulate how to track these actions using the spreadsheet:
How to Use Pinterest Follow Up Spreadsheets Youtube Tutorial
Yanna’s Pin Scale Strategy
When I first started pinning on Pinterest, I was busy looking for the ultimate Pinterest strategy that would skyrocket my blog traffic.
I thought that I would find a pinning method that included a certain order of pinning to specific boards and that this method would increase my blog traffic without me having to put any effort into optimizing my blog content.
I was determined to decipher that secret pinning strategy so I read all the articles on the topic online and experimented with a bunch of strategies.
Although my blog traffic was pretty good, after all, I managed to get over 100 thousand page views in less than 5 months, I wasn’t satisfied with my accomplishments. I found that there were a few other bloggers who were talking about reaching more than 180 thousand page views in just 4 months, or even 500 thousand page views after a certain period of pinning.
My blog traffic was stuck at around 100 thousand monthly page views. I couldn’t seem to break through that limit! It drove me nuts – Why were other bloggers getting that kind of traffic while I wasn’t? What was I doing wrong?
Believe me I tried so many pinning tactics, I optimized my boards constantly, I designed awesome Pins, manually pinned for 6 months and then used Tailwind, pinned new pins every day, deleted boards, deleted Pins, optimized my Virality scores, pinned the most viral pins more often – whatever you can think of, really… I was even banned a few times for pinning with other Pinterest users to increase engagement (Don’t try that!).
While most of these tactics were effective and my blog traffic did increase, I didn’t manage to break through the traffic limit until I did this one thing!
This small change doubled my blog traffic!
You’ll laugh when you hear what it was.
All I did was focus on writing ONLY VIRAL CONTENT!
Now I know some of you may say – “WHAT?! Are you real? Writing great content is an obvious method …”
Well, not that obvious, I guess. I did EVERYTHING to optimize my Pinterest traffic besides focusing on writing only the best posts that I was sure would go viral.
Writing viral content exclusively is a small thing that will turn a small cute blog into a freaking traffic monster! Read about how to find topics for viral articles – Step 9.
That moment, my goal changed: I would find the most popular topics that would become viral on Pinterest, track the behavior of each of my Pins on Pinterest. Then I would sort my Pins by popularity and optimize my Pinterest profile by repinning only my best Pins.
To that end, I developed a Pin Scale Strategy that includes a scaling technique, which helps me track my viral Pins, check the performance of my Pins, determine what Pins should be repinned more often and which Pins should be deleted, and gain a deep understanding of the evolution of my Pinterest Pins.
For more than a year, I followed the behavior of each and every one of my Pins to learn what characterizes each Pin scale.
The Scaling Technique and The Strategy Behind
I use my strategy to find out which Pins drive most of the traffic to my blog, then I pin them more often and design new Pins to promote the linked articles. To track the top 10 or even top 20 Pins, I use Google Analytics.
But what about the rest of my pins? Which of them should I pin more often? What about the less popular Pins or the Pins that used to be viral? After all, not all of them are bad, right?
When you grow your blog and have hundreds of Pins, tracking the best Pins is not enough because you have many different kinds of other Pins – Some of them might perform well while others might be a total disaster.
The goal is to boost the top Pins, promote the popular Pins, renew Pins that used to be good once, and get rid of the Pins that are a total disaster.
To avoid getting lost in an “ocean” of Pins, I developed the Pin Scaling Technique that helps me track all my Pins and prioritize the Pins I should pin more often, identify the ones that I should redesign, the ones I should delete, and understand the reasons.
In this Scaling Technique, a Pin can be marked as 1, 2, 3, 4, or 5.
Every Pin you create belongs to one of the rating groups. Below I explain how to rate your Pins according the Pins Scale Strategy, and how to promote each rating group to get the maximum out of your Pinterest profile.
As long as you rate your Pins on a regular basis, you will be able to sort them from “high” (1) to “low” (5), and easily gain a sense of which Pins you should promote to generate more traffic to your blog.
The Pin Rating Scores
Pin Rating Score no. 2 – New Pins
I will start with Rating 2 Pins since they are the easiest Pins to describe. Rating 2 Pins are new Pins. Every new Pin I pin on Pinterest is marked as “2” in the Pins Scale column.
After I repin that Pin at least 7 times, I reevaluate its rating and re-mark it – 1, 3, 4, or 5. I explain how to I decide on the new score below.
Pin Rating Score no. 1 – Viral Pins
Score 1 Pins are definitely my favorites – these are viral Pins or Pins that drive the most traffic to my blog.
It takes approximately 1 to 14 days for a new Pin to go viral. You will notice a viral Pin when your blog traffic suddenly soars! There is no chance you’ll miss that kind of Pin, as you’ll see a huge amount of traffic entries on your web analytics and your ad revenues will rise quickly.
A viral Pin can last between one and several days, but it can last weeks or even months if you know how to boost it to generate a steady flow of traffic (Step 19). At some point, the traffic will suddenly drop to the level it was before that Pin went viral.
How to track Rating 1 Pins?
Every week I track my Score 1 Pins – The Pins that generated the most traffic to my blog in the last 7 days, based on Google Analytics (Step 15).
Pins that were rated 1 two weeks ago, automatically become Score 3 Pins, unless they still generate most of the traffic to my blog.
Pin Rating Score no. 3 – Popular Pins
Score 3 Pins are popular Pins that attracted more than 100 clicks on Pinterest. They can be Pins that used to be viral or new Pins with 100 clicks on Pinterest statistics.
You can check each Pin’s statistic – it looks like this:
In the case of viral Pins (Score 1 Pins), I automatically re-mark them as Score 3 Pins after their virality decreases. The most convenient way to do this would be when you do your weekly task of tracking your highest-performing Pins with Google Analytics. This means that every week, you will have 10 new pins that are rated as no. 1 Pins, and the old rated no. 1 Pins will automatically become rated as no. 3.
Mark a new Pin as Score 3 only after it has been repinned at least 7 times.
Please note, Pins that are rated as 1 and 3 Pins are your best Pins, and they are associated with your most popular articles.
These are the articles that have a higher chance of going viral on Pinterest. Therefore, when designing a new Pin for an old article, choose one of these articles.
Although, the Pinterest algorithm tends to show fewer clicks on each Pin analytics over time, never re-mark a Score 1 or Score 3 Pin as Score 4 or 5.
Pin Rating Score no. 4 – Unpopular Pins
Score 4 Pins are Pins that didn’t manage to get more than 100 clicks on Pinterest, but still attracted some clicks.
It is rare to see Score 4 Pins go viral, although they might turn out to be popular (Score 3 Pins).
Score 4 Pins are your last priority for repinning or redesigning.
Mark a new Pin as Score 4 only after it has been repinned at least 7 times.
Pin Rating Score no. 5 – Pins that are a disaster
Score 5 Pins are a total disaster. This type of pin can be identified as Pins that have only a few hundred impressions and no clicks at all.
These are your worst Pins and you should never repin or even delete them.
Usually, you can identify Score 5 Pins after they have been repined at least 7 times, but to make sure, you can repin them several times more.
Score 5 Pins will never become popular, and certainly will not go viral.
Once you rated a certain Pin as a 5 Pin, you have 2 options:
If this Pin has a certain value for you and the linked webpage must be promoted (for example, a promotional page), then you will need to redesign it. Try to use a different title and photo.
The second option is to delete this Pin since it doesn’t do any good to your Pinterest account.
How to implement the Pin Scale Strategy?
In the follow-up spreadsheets, one of the columns is dedicated to my Pin Scale Strategy.
Marking the scale of each Pin will allow you to sort them from “low to high.” By doing this, you will have an organized list of Pins, with the most viral Pins appearing at the top of the list. AS a result, every time you will access your spreadsheets to start pinning or scheduling, you will know exactly what you should pin more often and what you shouldn’t pin at all, and why.
In the follow-up spreadsheets make sure to complete the “Pin Scale” column as this will help you sort the Pins from “low to high” and prioritize the Pins that should be pinned more often.
PINTEREST TRAFFIC GUIDE TO INCREASE BLOG TRAFFIC– NAVIGATION
Click to Move to The Next Step»»»