You’ve done it again, Google Analytics! You have provided a feature that made me feel like a true data magician.
Yesterday I received a reporting request from a client that seemed impossible. When I pitched the idea to my coworker he said, “They’re used to using Adobe Analytics, so if it’s not doable in Google Analytics you can just tell them that.” This struck me on a couple of different levels—I am wildly stubborn and my heart beats solely for Google Analytics.
The request centered around this client’s need to see their data broken down by geographical distinctions that are unique to their business model. Their designations are similar to most, in that they were interested in seeing how their EMEA region is performing versus others like APAC and LATAM. They needed this report to have a fairly tight turnaround and didn’t have the time to wait for the data from a custom dimension to start rolling in.
Meet Query-Time Processing
As of today, Google Analytics does not offer any features as a part of their Geographical Targeting that would allow a user to utilize those marketing distinctions out of the box and apply them retroactively in their reports.
What they do offer is something called Query-Time Processing data import, which is a brand new Beta feature for Premium/360 clients only. Looking back on several situations in the past couple of months, I realize how much I could’ve been utilizing this functionality to make my job as an analyst significantly simpler.
Query Time import is contained in the Data Import section of your Google Analytics Property settings. It functions very much like other data import features that have been available for some time now, but has a built in upgrade.
The clincher on QT import is that it’s actually retroactive, and can be joined to data that has already been processed. What’s more, it is reversible – meaning that if you need to change your schema, or delete your upload in the future, all of your unaltered data will still be there, unscathed. These two things are what distinguish this new feature from its older cousin, the processing time import.
Potential use cases for Query Time import
- Segmenting your subscribers around the month their contract began
- Uploading descriptive colors to a designated set of product IDs
- Using specialized neighborhood distinctions to determine where to run group-specific content
There are a couple of acknowledged drawbacks in the functionality of QT import, mainly around which reports your newly-widened information won’t function in. Specifically those are the Realtime reports and your Multi-Channel funnel reports. I would also not suggest running these uploads near a tight due date, as my mere 300 rows of data took almost an hour to finish uploading. You didn’t expect great results AND quick magic from Google Analytics, did you?
There are several different pieces of documentation that Google provides to help with the process of setting this up, and I spent a fair amount of time toggling back and forth between all of them. (You can those guides here, here, here, and here.)
If you’re interested in dimension widening and you’d like help getting it set up correctly, email our team at firstname.lastname@example.org. If you’re already utilizing this feature, I’d like to hear how it’s helping you further your analytical efforts!