With Google Analytics we mostly complain about delay in data reporting as sometimes data is delayed up-to 48 hours. (Google Analytic Data Limits) So we have to wait 48 hours to know the result of our campaigns and sometimes this time could be decisive.
Although Google provides some cool real time stats (see screenshot) but use of that is limited. For example, you can only see:
- how many people are on your site right now,
- their geographic locations,
- the traffic sources that referred them, and
- which pages they’re viewing.
so we cannot have the full picture with numbers provided there.
But as we know with every problem we have a solution available in Google Analytics framework itself.
Problem-Google Analytics data is at 48 hours late
Let’s look at the problem itself. whenever we try to run a report to get current day status Google Analytics provide incomplete picture as GA data generally takes upto 48 hours to update. (look at the screenshot).
Please take note of two things (marked with red circles in above screenshot) 1. visit numbers and 2. on top of the report pie showing % of total visits. because soon you will see some cool stuff.
Solution-How to get the complete data from GA in real time?
First we have to create an advance segment which will help us to get full data of the time frame.
1. go to advance segment
2. click to create new segment
3. create an advance segment to exclude some segment of your data (any segment which is negligible and inconsequential for your business see screenshot 2).
as you can see I have chosen country/territory dimension to exclude mauritius traffic from my new report as I know mauritius traffic is negligible for my website (1 or 2 visits a day) and doesn’t have any business goal attached to it. you can choose any dimension you want.
4. click apply and you will get all the data Google Analytics received till last minute.
Now check the visits numbers they are reflecting all the data gathered by GA till last minute. also check the small pie at the top it is showing 107% of total visits. How is that possible?
How this happened?
Google Analytics keeps two copy of data to be accessed by Reports
1. dashboard view which we see as summary on the top
2. raw data which gets reported in rows underneath (or through any api)
when we put any restriction (advance segment/custom report) on the data, Google standard reports breaksdown that result in fresh query directly from the raw data and we get what we want.
Note- the real time data we get by this method will only be reported in table view, Dashboard/summary view will continue to show lagged data. that’s why the small pic shows 107% of total visits when we access our intraday data using advance segment as it tries to compare numbers returned by the query with summary numbers
Now it will be the awesome to get all Google Analytics data/report in real time and you can impress your boss with it.
you can run any report with this advance segment and you will have all data in real time.
Please share your feedback
Universal Web Directory