How difficult? (website tracking w/ mysql)

dan_Vt · 05-24-2007, 06:57 AM

I've never tried to learn mysql so I'm not sure how difficult this would be.

I want to create a directory in one of my sites to help me track my websites.

I would input the urls, which the system would save, and it would show the following:

Backlinks in G/Y/M, PR, Ranking (for keywords I would input) in G/Y/M

The info would all be saved, and I could click a "refresh" button which would update all the info, and have links to a historical trend (doesn't have to be a graph, just dates with figures).

I'd like it to be flexible enough to be able to add more data to be tracked without messing up the historical area, and add new domains or update keywords. Also an input area for any notes I wanted to make.

Does that sound difficult? Any help appreciated.

Dan

xous · 05-27-2007, 02:03 AM

mysql is a RDBMS not a programming language.

You could choose a programming language and have it parse your data and store it in a mysql database.

A simple method for doing this would be to create a script to read your database to get a list of sites to check and then use another script to analyze, format, and display the results.

monaco · 05-27-2007, 02:39 AM

Why don't you just sign up for Google Analytics? It does all that for you since it's integrated with sitemaps.

05-24-2007, 06:57 AM	#1 (permalink)
dan_Vt Senior Member Join Date: Dec 2004 Location: Burlington, Vermont Posts: 1,043 1,086.90 NP$ (Donate)	How difficult? (website tracking w/ mysql) I've never tried to learn mysql so I'm not sure how difficult this would be. I want to create a directory in one of my sites to help me track my websites. I would input the urls, which the system would save, and it would show the following: Backlinks in G/Y/M, PR, Ranking (for keywords I would input) in G/Y/M The info would all be saved, and I could click a "refresh" button which would update all the info, and have links to a historical trend (doesn't have to be a graph, just dates with figures). I'd like it to be flexible enough to be able to add more data to be tracked without messing up the historical area, and add new domains or update keywords. Also an input area for any notes I wanted to make. Does that sound difficult? Any help appreciated. Dan __________________ Vermont SEO Automotive SEO For Sale: Co-Sign.com \| Skiny.net \| CSIFAQ.com \| FuelBank.net \| Jibbar.com \|

05-27-2007, 02:03 AM	#2 (permalink)
xous NamePros Member Join Date: Mar 2007 Posts: 56 16.35 NP$ (Donate)	mysql is a RDBMS not a programming language. You could choose a programming language and have it parse your data and store it in a mysql database. A simple method for doing this would be to create a script to read your database to get a list of sites to check and then use another script to analyze, format, and display the results. __________________ Fast Proxy - No Popups

05-27-2007, 02:39 AM	#3 (permalink)
monaco NamePros Regular Join Date: Jul 2005 Location: Tucson, AZ Posts: 695 314.80 NP$ (Donate)	Why don't you just sign up for Google Analytics? It does all that for you since it's integrated with sitemaps. __________________ My Website \| My Blog

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)