Are you a Google Analytics enthusiast?
More SEO Content
Keeping Track Of Link Partners, Etc
Posted 06 November 2004 - 10:12 AM
I tried to build something in excel and was met by several challenges-
Can some one offer me a suggestion? Is there a template of sorts out there? I dont need anything complicated. My husband has suggested building an data base but I think that might be overkill (and beyond my ability)
Posted 06 November 2004 - 10:49 AM
A database WOULD be cool though -- maybe I'll write one and offer it for people to use. I'm finding that Excel does an ok job though.
Good luck -- let me know if you come up with anything, always good to learn new tricks.
Posted 06 November 2004 - 11:57 AM
I'd use Excel, too to keep track of that type of data (something like Shannon suggested). What kinds of challenges are you running into? Maybe we can give you some pointers.
Posted 06 November 2004 - 12:43 PM
Site (the site's domain name)
Link Page (URL of the page I want to get a link from)
Target (my client's home page or some other page on client site)
Contact Address (email address or page URL to which I will make the request)
Contact Name (if available, the person I need to contact)
Reciprocal (Yes or No)
Accept Date (Left blank until I know, then I enter either "No" or the date)
Billed (I bill link building in three separate steps, so I track that here)
That usually works for me. Ocassionally, a client will insist on knowing the PR of the link page, so I'll throw in a column for that too.
Posted 06 November 2004 - 05:46 PM
I also like the Excel spreadsheet idea for adding additional, and important, info. Linking is such a tedious CHORE! But if it helps with the rankings, you gotta do it. ACK!!!
Posted 06 November 2004 - 06:55 PM
If you feel compfortable with it, can you explain your billing a bit?
I am using optilink in conjunction with an excel spreadsheet. The optilink will instantly verify links, show your competitions links and pr and much much more. You can save the projects.
Posted 06 November 2004 - 08:16 PM
Stage 2 is requests: I send in the link request for each of the proposed links that the client has approved, and bill for that step.
Stage 3 is acceptance: I only bill this portion of the campaign for those sites that actually put up a link to my client's site, so this portion comes in little by little. I generally check on the outstanding links every Sunday before putting together that week's invoice.
The whole thing is laid out (and a bit over-complicated, I'm afraid) on my link building page. It's a nuisance, but it seems to me its the fairest setup for both me and the client. I'm guaranteed to get paid something for my work, whether it's successful or not, but the client doesn't pay the full amount for those links that never appear.
Posted 06 November 2004 - 08:45 PM
Posted 06 November 2004 - 10:50 PM
I am guessing I want to do to much. When I started workinging on it realized I couldn;t do it- Soo- most likely I should give up and have each client have there own worksheet.
I am wondering if some generous hearted soul has a BLANK excel sheet set up they woudl consider sending me. ??
Lynne.. who is veing sucked into vortex of data ...
Posted 07 November 2004 - 08:52 AM
Posted 08 November 2004 - 06:00 PM
Posted 09 November 2004 - 10:38 AM
Instead, I scroll to the cell containing the URL, hit ctrl-C, then go to the browser window (which is strategically located and sized for good viewing without completely covering the spreadsheet), select the address bar and hit ctrl-V.
It makes things run much more smoothly, especially if you're checking up on a lot of URLs. But I'm picky when it comes to these things
Posted 09 November 2004 - 04:44 PM
Heres a draft of the email i plan to use for my next campaign:
Useful Resources for your Visitors
I am pleased to announce 6 super web sites
your visitors may find useful.
The sites are content rich and leaders in
their field. Please include links to these
sites in your useful resources section.
Here are text links for the sites. There is
easy cut and paste banner code at this
I have visited your web site and approved it
for inclusion in our useful resources directories.
Please let me know how you would like me to
link to your web site and I will put links
up to your site in each of these directories:
Provide a banner or image for your listing
to attract more hungry visitors to your
I periodically check whos referring the
most visitors to our sites and will reward
you with a higher position in your category.
The top 5 referrers go on the main page!
As a thank you for linking to our web sites
I will recommed your URL to the best travel sites
I exchange links with in the coming months. This
is a great way to get more quality link partners
while you sip a glass of wine on the veranda.
Wishing you every success with your internet
Posted 14 November 2004 - 02:32 PM
Feel free to download it. -Beth
Posted 22 December 2004 - 07:43 PM
In the meantime, I have created some Perl scripts that I use to display what I call the 'raw' URL's on each links page on my site. That way I can look at the actual sites instead of the anchor text to see if I have already exchanged links with someone. It took a lot of time to create the various scripts, but now I can count total # of links on each page, actual links on each page, total # of links on all pages, etc. It really helps me avoid duplicate link submissions, and I get the information directly off my live pages.
I would suggest that if any of you have some scripting experience in ASP, VBScript, Perl, etc that you set something up that can write directly to a database. That way you can update your site and keep track of things at the same time.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users