Cannot import data for older time frames
Hi there dear community,
I'd like to do the following: We've got an online magazine with about 1500 articles (used Google Analytics from beginning on 5 years ago). We'd now like to add the author and publication date to each article (=URL) in GA. CSV Import via custom dimensions already worked (via https://support.google.com/analytics/answer/3191589?hl=en). However, the problem is that the values of the custom dimensions (so author and date) ONLY are shown for dates / page views AFTER the time of the import. But what I would like is to of course also see author and date for older time frames. I don't understand why this is not possible - as I imported static values which do not change for a page view...date and author are static values which the import matched based on page path. Why can I then only see those values for dates AFTER the import? I thought that is what CSV import is for (matching URLs with static values)...values which I would like to import to GA based on page views (e.g variable user data or so), I'd instead use the tag manager.
Any way to see time frames with the date and author values before the time of the import?
Thanks a lot in advance,
Cannot import data for older time frames[ Edited ]
January 2017 - last edited January 2017
There is a very easy (and very expensive) way to do this. GA 360 has query time data import/join it is this exact functionality -- starting at the low low price of $12,500 per month.
That said, you can also do this in Excel or a tool like Tableau by joining on the URL.
Edit: You can also use Google Sheets, the GA Google Sheets plugin to automate this.