Forum Moderators: open
I'm looking to dramatically improve the quality of monthly rank reports we give to our clients.
At the moment I'm using a simple version of wpg running from a desktop.
However I want something a lot better that can link into a dedicated asp database website we've yet to build and that can be run by clients once per day max. (to avoid IP blocking by SEs)
I spoke to someone from a well-known UK SEO company a few months ago and they told me that they had just spent over £10k on getting a java application built for this purpose (which they thought was cheap). They then had to integrate it with their site.
Do you any ideas or suggestions on:
how to go about a project like this
what software is available that could help
online guides/ samples on how to query a search engine
how to use the results generated on a site
Is it a Java applet I need built, is it an API or?
Perhaps its possible to do this very simply by somehow scheduling something like Copernic to run once per day for each client (which I accept would not be on-demand reporting). The results could then be extracted and dumped into a database which would power the client reporting site?
If you're replying asume I know a bit about SEO & computers but nothing about this kind of project!
I suppose I'm looking to outsource this as we don't have the necessary skills in-house. Would like to run it on a Windows platform
Thanks in advance
J
Keep in mind that you are talking about at least a month of work on the programming side and that you would need to update it every few weeks as the search engines checnge their HTML output.
Alon
I've been working on this for the last few hours & I think I may have come up with something very simple.
1 - Schedule WPG to run weekly on local PC and produce ranking results as CSVs
2 - These CSVs are saved on local PC (with unique filenames)
3 - Ws_FTP Scheduler places each client’s CSV in a specific location on server weekly
4 - New CSV placed beside CSV from previous week on server
5 - Every week, an Access macro running on the server somehow imports latest batch of client CSV’s from whevever they were uploaded to on the server into the main Access database driving the site.
======================================
How does this sound? Its basic I know...
Couple of tasks now though.
I've to figure out how to import the CSVs on the server such that Access can use the data. Is this possible using a macro?
Biggest problem I see however is being able to display week on week ranking comparisons.
Any thoughts would be gratefully appreciated!
Thanks
John
When you upload the CSV's to your server make sure that they have unique names, something like:
domain1-mm-dd-yyyy.csv
domain2-mm-dd-yyyy.csv
domain3-mm-dd-yyyy.csv
Now what you do, insted of the marcro.....
1. When your client logs in to see the stats it first checks which dates have already been imported (ASP pages can read the info from the CSV files and write them into the access database).
2. Which ever dates have not been "imported" are impoted on the spot (depending on the size of the files it should not take too long, maybe 30 seconds or so)
3. You now generate the reports based on the info in the access database.
You can configure these ASP reports to show as you wish...this week compared to last week, only this week, only Google, etc...
That sounds like what I need. You wouldn't happen to know of any sites (please delink/stickymail) offhand where theres example asp code for that functionality would you?
No worries if you don't. I'll go hunting.
My asp is rather rusty!
Thanks for your help
John
that's the part that updates the database.
for reading from the CSV files you need to search for:
FileSystemObject
Sticky mail me if you decide you want help with the pages.
Good Luck
