One-hundred percent of all Google Analytics implementations have broken at some point. The impact can range from minimal to extreme. An ecommerce example is when sales as reported by Google Analytics does not align with actual results from a shopping cart. Google Analytics does not correct mistakes or reprocess reports. There is no way to remove, add, or overwrite historical data.
The workaround for users is to export data to a spreadsheet or database and correct the mistakes. In this post, I will explain a process for reprocessing Google Analytics data and then reporting it in Google Sheets or Data Studio.
Here is the process.
1. Identify which data needs to be reprocessed. Examples include:
I’ve addressed auditing Google Analytics to detect errors, at “How to Audit Google Analytics Data for Ecommerce.”
2. Export your data from Google Analytics. I use a Google Analytics add-on for spreadsheets.
3. Arrange the metrics by day that need reprocessing.
4. Produce reports that show the original values per day beside the reprocessed values.
I’ve assembled a sample report in Google Sheets called “Example Google Analytics Reprocessing Data.”
The “Report Configuration” sheet receives the export from Google Analytics.
The “Power My Analytics Traffic” sheet is where the Google Analytics data is reported.
The “Corrected Data” sheet contains the accurate Session data (in column C).
My graph in Google Sheets includes the “Reported Sessions” and “Corrected Sessions.” This data could be included in a Google Sheets report or Data Studio report alongside other Google Analytics data. To report in Data Studio, use the “Google Sheets” connector provided by Google.
To be sure, reprocessing Google Analytics data is tedious and time-consuming. Avoid it by frequently monitoring Google Analytics to catch tracking glitches, thus removing the need to reprocess.