I wish to extract (via the Analytics Core Reporting API) all the transactions made TODAY by users that had a specific ga:eventCategory few weeks ago. I'm looking to see the date of a transaction and all dated of event that are related to that transaction. If GA was sql I would join by the ga user and take in the dimension both his transactions date and his dimension update date... Thanks. Noam.
How can I query Google Analytics condition on TWO different dates?
264 views Asked by NoamZ At
1
There are 1 answers
Related Questions in GOOGLE-ANALYTICS
- Google Maps API Re-size
- Google Map Custom InfoWindow's Tail Won't move and can't remove dropshadow
- how show result the autocomplete in the map in CodeIgniter Google Maps V3 API Library?
- GoogleMaps or OpenStreetMap get graph
- GoogleMap.addGroundOverlay() takes a lot of UiThread time
- Reverse geocoding with a deferred object in a coffeescript class
- Can I get Google maps to ignore part of a search?
- IOS Google Maps skid fit bounds
- Accessing Google Maps Markers in 2D-array from outside
- kmllayer with polygons hide map
Related Questions in GOOGLE-ANALYTICS-API
- Google Maps API Re-size
- Google Map Custom InfoWindow's Tail Won't move and can't remove dropshadow
- how show result the autocomplete in the map in CodeIgniter Google Maps V3 API Library?
- GoogleMaps or OpenStreetMap get graph
- GoogleMap.addGroundOverlay() takes a lot of UiThread time
- Reverse geocoding with a deferred object in a coffeescript class
- Can I get Google maps to ignore part of a search?
- IOS Google Maps skid fit bounds
- Accessing Google Maps Markers in 2D-array from outside
- kmllayer with polygons hide map
Related Questions in UNIVERSAL-ANALYTICS
- Google Maps API Re-size
- Google Map Custom InfoWindow's Tail Won't move and can't remove dropshadow
- how show result the autocomplete in the map in CodeIgniter Google Maps V3 API Library?
- GoogleMaps or OpenStreetMap get graph
- GoogleMap.addGroundOverlay() takes a lot of UiThread time
- Reverse geocoding with a deferred object in a coffeescript class
- Can I get Google maps to ignore part of a search?
- IOS Google Maps skid fit bounds
- Accessing Google Maps Markers in 2D-array from outside
- kmllayer with polygons hide map
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Like I have indicated in my comment you can segment the data to include only those users who have the specific event. Segmentation works fine with the core reporting API.
Your segment defintion would look like this:
(where obviously the thing in [brackets] is a placeholder that needs to be substituted for the event category name). The "users::" prefix means you are segmenting by user scope (as opposed to sessions), so this will include all sessions in the selected timeframe for users who had the event at least in one of their session (even if the event was outside the selected timeframe).
Select transactionId as dimension and some metric (revenue) and todays date and you are done. Or you would be done if this was actually going to work, but there are at least two caveats:
Google Analytics does not work in realtime, so it's unlikely that TODAYs transactions are fully available (Google says it's 24 hours until the data is processed - actually it might happen faster, but you cannot rely on it).
If a user has deleted his or her cookie she won't be recognized as a recurring user and GA will be unable to segment her out. The longer the interval between the event and the transaction the less likey it is that the GA cookie is still present.
So even with a technically correct query it might be that you won't get the data you need.