analytics

Use analytic functions to group a set of records when timestamps in rows is less or equal than a value

Hi all, I have a table in an Oracle Database that has, among others, a DATE column that is loaded with the insertion timestamp of each row. I need to use existing data in such table to analyze the correlation between some events, so that with data like this: COL_1 COL_2 TS A 1 Mon 15, February 20...

Google Website Optimizer: track AJAX

I am tracking AJAX goals in Google Analytics with no problems. But I would like to use Google Website Optimizer to see what buttons or headlines get the most leads in our newsletter subscription form. Since a new subscription only triggers AJAX/Javascript, I cannot add a separate success/thankyou.html page to track in Google Website Ana...

iphone app analytics

Hi, We plan to advertise our iphone app on other sites. Is there a way to track from which website my iphone app hyperlink was clicked when a purchase is made? Can this be programmed, or is there any analytics app which does this. We will want to track the exact number of sales made from each site.. Appreciate any help.. mb ...

Collecting high-volume video viewing data

I want to add tracking to our Flash-based media player so that we can provide analytics that show what sections of videos are being watched (at the moment, we just register a view when a video starts playing) For example, if a viewer watches the first 30 seconds of a video and then clicks away to something else, we want the data to refl...

Use analytics tool to tie browser behavior to back end transactions

Can I use an analytics tool like Google Analytics to tie user behavior to back end (Java) transactions? I know I can use the analytics API to store custom data, like an account number or something that I can tie to the log/database created from the Java classes, but is this the best way? What I want to do is see how many users access e...

Customer Google Analytics in Web App

I have a web app where people can create custom content on the web which is hosted by my service. I want to provide users with the ability to track activity on their specific page via Google Analytic. I've seen some other companies providing this option (MailChimp). I was wondering if anyone had experience in implementing this kind of s...

How to find time spent per user per application in Google Apps?

Is it possible to obtain some kind of statistics on which user spent how much time on which application when they log into Google Apps? Applications example would be gmail/sites/talk etc., ...

Google Analytics cookies

My problem: I erased all cookies from my computer. I sent Post request to the X server log and sent me a "normal" Set-Cookie with its parameters, but then somehow it will send request for Google Analytics (GA), in which the "strange" header (utma, utmac, utmcn ...). This happens when I send request in browser. But when I pass a request t...

Architecture for database analytics

Hi, We have an architecture where we provide each customer Business Intelligence-like services for their website (internet merchant). Now, I need to analyze those data internally (for algorithmic improvement, performance tracking, etc...) and those are potentially quite heavy: we have up to millions of rows / customer / day, and I may w...

php cURL or file_get_content affect on google analytics

Im wondering what affect loading an external page with php has on a sites analytics. If php is loading an external page, and not an actual browser, will the javascript that reports back to google analytics register the page load as a hit? ...

Is there a Feedburner replacement out there?

I like that Feedburner can do some basic analytics and tracking. But I have also had (in the past) problems with Feedburner. Is there a self-hosted solution out there that is roughly equivalent? ...

getclicky, woopra, track all pages?

How can I track all my website pages using those 2 web analytics apps? I can only track the first page, what shall I do? thanks. ...

Managing multiple apps with one Google Analytics account?

I've just setup a Google Analytics for Mobile Apps account and I've implemented the SDK in my iPhone app with no trouble at all. However, I haven't figured out how to manage multiple apps with one account. It seems fairly easy to setup multiple subdomains when dealing with websites and I've noticed the javascript code has a setSubdomain ...

Google Analytics - Goal Funnel Steps

Is there a way to test the url you're entering in a step, to see if Google Analytics will recognize it? What I'd like to do is provide some web page or some web service with a URL, and get a pass or fail. It passes if Google Analytics recognizes a page hit to the url. Let me give some context. We've been having issues with our goal f...

Does preloading content from a page skew my google analytics stats?

I'd like to write myself a simple script that uses AJAX to load the content from each page on my main navbar into a hidden div on the current page. This is just so that I can preload as much of my important content as possible and get it cached on the user's computer (hopefully) before they've finished with the current page and want to ...

Would server traffic software (something like Piwik or Google) make a good case for using No SQL?

We are trying to develop a company specific tracking software but not interested in Google or Piwik. Essentially we would have a JavaScript tracking code also. The data that it would capture, would that be best suited for traditional RDMS or can we get a NO SQL solution ? Any thoughts or ideas welcome. ...

Trying to collect email analytics

I've written an email application in PHP that handles very large mailing lists. Is there a way to find out what emails are opened and by who? Any solution will do as long as it can tell me if the user has actually received and opened the email. I do not want to use email receipts either as it may put off recipients. If it's relevant, I'...

Custom iPhone analytic tool

Do you think that if I'll build my own custom analytic tool (Flurry, Pinchmedia) and I'll host that on the same server where I have my data source for the application, will Apple consider this as a thirdparty analytic tool or not? ... Problem is that Flurry and Pinch are being banned from Appstore by the newest T&C ... than I thought tha...

Resources to learn about engineering aspects of data analytics (OLAP, warehousing, ETL, etc.)

I'm a math/stats guy, interested in learning more about the engineering aspects of "data analytics" (probably an overly broad term, but this is definitely a case of "I don't know what I don't know", so I'm not sure how to be more specific). I'm fine with manipulating and analyzing the data once it's already stored somewhere and I can ac...

How do I use a jQuery not selector to select relative URLs?

I'm working on a little jQuery script to add Google Analytics pageTracker onclick data to all relative URLs on my forum, allowing me to track clicks to external sites. I don't want to add the onclick to internal links on forum.sitename or sitename, and I don't want to add them to any hrefs marked # or that start with /. My script below...