Forum Moderators: open
I'm trying to design a database to hold our search engine rankings for keywords over time - has anyone got a script or article I could have a look at? I've seen some software out there but would rather design it myself.
Here's my first attempt:
Table: search_engine
Fields: ID, search_engine_query_structure
Example: 1, www.google.com//search?hl=en&q=<KEYWORD>&meta=
Notes: This should also be able to do num=100 (100 results) queries,
other engines such as Yahoo! and MSN as well.
Table: keywords
Fields: ID, keyword
Example: 1, "fish patties"
Notes: This should be able to deal with exact, findall and combined queries.
Table: ranking
Fields: ID, Date, URL_found, position, fk_search_engine_ID, fk_keywords_ID
Example: 1, 01-01-2006, www.mysite.com/fish_patties.html, #1, 1, 1
Table: site_pages
Fields: ID, URL_page
Notes: I'd like to query if our site pages are ranking page by page for a specific keywords
Table: log_sengine_referrer
Fields: ID, fk_search_engine_ID, querystring, landing_URL
Notes: I'd like to see what pages users are landing on for a particular search engine keyword.
I'd like to regularly check how we rank for a range of keywords and record the data so I can present historical information and trends.
I'm unsure how to get historical data to display - what sort of queries and table design would be best?
Any help would be greatly appreciated.
Cheers
I'm new here and am still learning what I can and cannot do. I don't think I am allowed to promote anything - so I'm not sure how to answer your question (within the TOS :)
A search for web ranking should help you out.
Sorry mods if I've made another mistake.
Cheers
Forget doing it yourself. Google is doing this for you for free. Check out [google.com...] and enjoy these types of reports without having to store the information in your own databases.
just signed up and it looks very nice. Thanks for the heads up.
Cheers
