On our site, which is subscription based, every user has a unique username that we can access for our web application. We'd like to be able to associate these user id's with visitors that we track with MS pro.
Can we extend database schema and asp to capture that username? It appears that that data should go into a new field in the mt_sessions table. Can you confirm this? What other tables would be affected?
When we create vistor reports, it looks like we would use asp to simly grab and report on this extra field that we would add. Please advise.
Operation details: Matasun pro, mysql database 4.1.11, site traffic expected at 500K page views per day. MS server and mysql running on same server, Dual 550 xeon, 1 gig ram, Windows 2000 Server, IIS 5.0. Tracking server is separate from actual server farm.
Thanks.
Steve B
Adding columns to track User ID's
Hi Steve,
Yes, I would add this to the mt_sessions table. No other tables should be affected.
One way to do this would be to add a field called s_user of datatype INT to the mt_sessions table. You could store the actual usernames in the mt_names table and have the s_user just store the ID.
If you use the support request form and send me an email, I will send you the dataschema for MetaTraffic Pro in Excel format, this may be helpful.
Regards,
~Chad