In my last post, I touched upon the 80/20 rule, and how it relates to content marketing—specifically, that only about 20% of the content you post is earning you 80% of your results. I then went on to share the first two steps of the process I use when determining exactly which kinds of content are the most valuable. In this post, I will pick up where I left off, with Step 3.
Step 3. Use URL Profiler to crawl each competitor's unique URLs
As I’ve said, there are probably other ways to accomplish this, but URL Profiler is the best option I’ve encountered. In fact, it’s a great Swiss Army tool in general, and I am confident that you won’t regret the purchase (assuming you don’t have it already).
Note: If you are not using Ahrefs, but you want to use URL Profiler for this step, you will need an Ahrefs API for this to work.
Adding the API is actually a really simple process: Open URL Profiler, click “accounts,” select “Ahrefs,” and paste your API token into the box. Click test to make sure that everything is working, and you're all set.
For this particular task, we don’t need URL Profiler to pull that many metrics—a few should be enough.
Under “Domain Level Data,” check the “Ahrefs” box. Under the “URL Level Data” section, check the “Ahrefs” and “Social Shares” boxes.
That's it. For reference, your settings should look like this:
Once this is set up, go to the g-drive folder for your first competitor, select the tab titled “Content KOB,” copy the list of unique URLs found in column A, and then paste them into the URL Profiler “URL List.”
Note: You can’t use certain keyboard shortcuts (such as ctrl+v) in URL Profiler; you have to right-click in the window, and select “Paste from clipboard.”
Once you’ve pasted the URLs, go ahead and run the tool.
The time it takes to run will vary depending on the size of the list and your rig, but usually it takes fewer than 10 min.
Once that is done, open the file, command shift v select all and paste this over the URL’s you have on your Content KOB tab.
It should look like this:
Now, like the we did in the “positions” step, we need to re-arrange the columns and rid ourselves of data we won’t be using.
Put your columns in this order:
- URL Ahrefs Backlinks
- URL Ahrefs Ref Domains
- URL Total Shares
- Domain Ahrefs Backlinks
- Domain Ahrefs Ref Domains
Delete any columns not included in this list.
Repeat this process for each competitor.
This is part two of a four-part series on creating quality content. In part three, you’ll learn how to add Position Tab data to your Content KOB tab.