Hello My name is Tay and
I’m going to show you from start to finish how to make “Optimized” hashtag sets that you can sell to accounts/clients that takes really $0
investment if you already have an automation tool.
This is the final product. I sold a ton of these with my audits back in
the day when i was getting started. Now I’ll show you how. There’s too
many niches for this to get saturated and the price is so good that most
accounts don’t mind giving you $10 to $20 bucks for this.
It’s basically a super clean hashtag portfolio that shows popular
hashtags in their niche that they can choose to target. It also compares
whether they are “ranking” or “exposure” tags and provides ready to use
hashtags blah blah a lot of fluff
Step 1: Generate Hashtags for The Niche
So to start first you will want to find a hashtag generator. USE A FREE
ONE. You don’t have to spend money on this you just need ideas, your
automation tool can probably do this for you, I just find it easier to
do online.
In this example, I’ll be using the niche fortnite. I just googled
hashtag generator and this was the first result so just went with it.
Put your niche in and click generate.
Boom. This is what you get. 30 relevant tags in that niche. Are they the best? Probably not, but we’re not selling the best we’re
selling optimized analytics that compare these tags to the client
account.
Step 2: Go To Automation Tool And Analyze Hashtags
For this example, I willl be using Jarvee (MassPlanner 3 clone). Most
good automation tools will have a hashtag analyzer feature, I
unfortunately just don’t know how to use each one, so for this we will
stick with Jarvee.
Go to Tools ----> Users And Hashtags
You will see a section at the bottom called Related Hashtags. This is where we will be putting our hashtags in.
So put your hashtags into the box. Only annoying thing is that you have
to take the # sign out. So just put your tags like I put mine. You can
simplify taking out the hashtag sign using simple excel commands which I
won’t go into. But if you’re lazy just google how to take out the first
character in excel. Super simple just copy and paste the formula.
This is what you should have now:
We are now going to click Get Hashtag Info. I always check the box for
scrape a minimum number of hashtags to 30, but that might be unnecessary
so idk test it out. I just always get the right number of hashtags when
I do that.
Now this might take a while depending on the performance of your VPS. If
it freezes DONT WORRY. It happens, just wait and be patient and Jarvee
will spit out the info.
You should get something like this:
That is now all the info you need to make a killer consumer friendly optimized hashtag portfolio!
Step 3: Convert Jarvee Info Info To Excel
So you want to click export all in Jarvee from the last picture. This will give you something like this:
Now I don’t have excel or google sheets installed on my server, so it
was a pain in the.... the first getting this info into a sheet because I
couldn’t copy and paste it right for some reason.
So I’ll show you how I do it but again this might be me being bad at computers/my server before really sucked.
Do these steps:
Copy the file location from the above picture (yours not mine lol)
Open up file explorer and paste it in BUT delete the last part file name because it will just open it up again.
Hit enter and it should take you to the file location
Now upload that file to your excel or google sheets program. I use google sheets because I’m a cloud type of guy.
You should get something like this:
Very ugly and bland and has no value for the customer.
So here’s how we add some easy value for them. At least $10 to $20 bucks worth.
Make 3 new columns.
- Probability of Ranking
- Ready to Use Hashtag
- Tag Purpose
I will go through how to set these all up in a second. But we need
metrics to compare these columns to. So we are going to add a box that
includes the clients stats:
It will look like this:
Very basic information. Followers. Engagement Rate. Avg likes. Avg Comments.
If you’re new, I know what you’re thinking: “BLACKGRUMPS HOW DO I GET ALL THIS ADVANCED INFO THIS MUST BE SECURE IN IGs VAULTS”
Chill homies, I gotchu.
Simply type “instagram engagement calculator” into google and click
anyone of them. They all give the same info. Don’t pay for one. The one I
have screenshotted is called phlanx. It’s free and you don’t need to
enter an email or anything so not a nuisance either.
Anyways take that info and put it in a nice box like I did above.
We now have stats we can compare our 3 columns too. I just made some up.
So how do you get these recommendations columns that look advanced and cool? Simple excel formulas. Here is each one.
Probability of Ranking
=if($O$8<D2,"Lower","Higher")