January 27, 2012 | 3 Comments
Guest blogging is a powerful link-building tool. To keep track of your progress, it’s helpful to save a record of your activities. For this, one can build a guest blogging spreadsheet or table.
What Is a Guest Blogging Spreadsheet for?
You use a guest blogging spreadsheet to get a clear picture of your contributions to other blogs. The spreadsheet should tally information about your posts such as the host website’s URL and ranking (PageRank), the types of links you can get from that site and the specific pages on your site that you promote there.
While I firmly believe that link-building isn’t as important as creating a quality website of your own, I think guest blogging is worth the effort nonetheless. And the more organized and diligent you are about keeping records, the more chances of success for your campaign.
What Do You Put in a Guest Blogging Spreadsheet?
Put whatever details about your guest posts that you want to tally and remember, such as:
- URL of the blog you contributed or want to contribute to
- Google PageRank of that blog (use a PageRank checker)
- Minimum/maximum word count
- Number of backlinks allowed
- Whether or not anchor text in links is allowed
- Location of the backlinks (body of article? author byline?)
- Your status at that blog (pending, published, rejected, no response?)
- Target URLs on your site that you link to in your guest posts
- Titles of your guest posts
- Special requirements of each blog (gravatar? images?
Don’t try to put everything in a single sheet if they don’t fit or if it gets too big. If you use a spreadsheet program like LibreOffice Calc or Microsoft Excel, you can click the “sheet” tabs at the bottom of the spreadsheet to create a new sheet within the same file. For example, you may wish to put your list of backlinks and article titles per site in a separate sheet.
Example Guest Blogging Spreadsheet Entry
The key to this whole idea is keeping it simple. Don’t over-think it; don’t over-analyze. Add the data quickly and then go back to publishing. Here’s a sample of what you might put in an entry:
- URL / Website: Blog ABC
- PageRank: 4
- No. of Links: 2
- Where: 1 in article body, 1 in author byline
- Anchor text: Yes
- Word count: 450+
- Status: Published
- No. of Articles: 3
On another spreadsheet, you can list the article titles and their backlinks at that site:
- Post Title: ex: Help Logging in to Facebook
- Backlink 1: ex: http://your-blog-link-here
- Anchor text to 1: so-so-keyword
- Backlink 2: ex: http://your-blog-link-here-2
- Anchor text to 2: your blog title
I don’t think it’s necessary to go into this much detail. Instead, you can track your backlinks per page with an analytics software such as Google Webmaster Tools. But if it’s important to you to track each link and anchor text, this is a good way to do it.
Using the Guest Blogging Spreadsheet
So how do you use the spreadsheet to guide your guest posting campaign? Well, you can use it to:
- See at a glance where you have built the most links, and the fewest links
- Strike out blogs that never respond to you
- Identify the best blogs to submit more articles to
- Quickly find the blogs you have yet to submit to
- Balance the use of keywords and brand names in your anchor text
- Decide which article idea should go where, judging by word count, link requirements, etc.
That’s how you use it. Remember, it’s just a tool. Don’t obsess with it. Use it to save time and organize your campaign. And you can use it in article marketing too to track your submissions to article directories, though often these have their own tools for your analysis.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.