Hi All,
We are working on a website where Google Analytics data matters us a lot. We have already registered with Google analytics & we are getting the result. We are also using Google API for .net to access analytics data on our site.
We have decided to store Google analytics data in our database for our further reference, as we are not very sure how many days Google will keep the data on their site.Also with using API , we are unable to retrieve correct data for the range more that 30 days.
We are using SQL server 2005 to store analytics data. What are the best practices for storing analytics data in DB ? Google provides lot of statistics & data on analytics site. What are the minimum things we need to store in our DB so that we will query our DB & get the result.
There will be scheduler which will update the data in our database on daily basis.
Does anyone done this kind of stuff previously ?