谷歌分析工具LIKE [英] Google Analytics LIKE Tool

问题描述

我考虑写我自己的跟踪访问者/销售工具，谷歌分析和其他人都只是不够全面数据部。他们有很好的图形用户界面，但如果你有SQL技能的图形用户界面是不必要的。

I'm considering writing my own tool for tracking visitors/sales as Google Analytics and others are just not comprehensive enough in the data dept. They have nice GUIs but if you have SQL skills those GUIs are unnecessary.

我想知道最好的办法是做这个的。

I'm wondering what the best approach is to do this.

我可以简单地只记录IP等等到一个文本文件，然后在后台异步服务运行它转储到数据库。或者，也许这就是矫枉过正，我可以只是把它直接在数据库中。但是每个Web请求对应一个DB WRITE似乎是一个糟糕的选择，其中的可扩展性而言。思考？

I could simply just log the IP, etc to a text file and then have an async service run in the background to dump it into the DB. Or, maybe that's overkill and I can just put it straight in the DB. But one DB WRITE per web request seems like a poor choice where scalability is concerned. Thoughts?

一点题外话，可以捕捉引用URL或任何传入流量，对不对？所以，如果他们从一个论坛的帖子什么的来了，你可以跟踪实际的URL，是这样吗？

As a sidenote, it is possible to capture the referring URL or any incoming traffic, right? So if they came from a forum post or something, you can track that actual URL, is that right?

这似乎只是认为这是一个非常标准的要求，我不不想去重新发明轮子。

It just seems that this is a very standard requirement and I don't want to go reinventing the wheel.

一如既往，感谢您的洞察力SOF。

As always, thanks for the insight SOF.

推荐答案

要这个问题提到答案开源GAnalytics替代 Piwik - 这不是C＃，但你可能会得到一些想法在看执行

The answer to this question mentions the open-source GAnalytics alternative Piwik - it's not C# but you might get some ideas looking at the implementation.

有关.NET解决方案我建议阅读马特Berseth的的访问/浏览量Analysis Services多维数据博客文章（和的较早和的例如，另一个的例如，因为他们不容易找到他的网站上）。

For a .NET solution I would recommend reading Matt Berseth's Visit/PageView Analysis Services Cube blog posts (and earlier and example and another example, since they aren't easy to find on his site).

我不知道他是否贴在服务器端代码（虽然你会发现他的 openurchin.js 在他的HTML链接），但你会发现大多数的概念解释。你也许可以得到的东西按照他的指示迅速漂亮的工作。

I'm not sure if he ever posted the server-side code (although you will find his openurchin.js linked in his html), but you will find most of the concepts explained. You could probably get something working pretty quickly by following his instructions.

我不认为你会想要写一个文本文件 - 锁定问题可能出现;我会去插入到数据库表。如果表增长得太大，你总是可以卷起周期性的结果，并清除旧记录。
作为引荐来源网址，你绝对可以抓住从HTTP头文件（假设它已经被客户端发送的，而不是通过代理或严格AV S / W设置剥离）的信息。

I don't think you'd want to write to a text file - locking issues might arise; I'd go for INSERTs into a database table. If the table grows too big you can always 'roll up' the results periodically and purge old records. As for the REFERER Url, you can definitely grab that info from the HTTP HEADERS (assuming it has been sent by the client and not stripped off by proxies or strict AV s/w settings).

顺便说一句，请记住，谷歌Analytics（分析）增加了很多有价值的统计 - 其地理编码IP地址由ISP以显示定位结果（国家/城市）以及/ IP拥有者。他们的JavaScript并闪存检测和段的用户代理为有用的'浏览器名作，也检测到其它用户设置，如操作系统和屏幕分辨率。这是一些非平凡的编码，如果你想实现报告的同一水平，你将不得不这样做 - 不提数据和计算得到的条目和放大器; 。退出页面信息，回访，独立访问者，回访者，时间在网站上花费等。

BTW, keep in mind that Google Analytics adds a lot of value to stats - it geocodes IP addresses to show results by location (country/city) and also by ISP/IP owner. Their javascript does Flash detection and segments the User-Agent into useful 'browser catagories', and also detects other user-settings like operating system and screen resolution. That's some non-trivial coding that you will have to do if you want to achieve the same level of reporting - not to mention the data and calculations to get entry & exit page info, returning visits, unique visitors, returning visitors, time spent on site, etc.

有一个的谷歌Analytics（分析），你可能想看看，太API 。

这篇关于谷歌分析工具LIKE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！