One-hundred % of all Google Analytics implementations have damaged in some unspecified time in the future. The influence can vary from minimal to excessive. An ecommerce instance is when gross sales as reported by Google Analytics doesn’t align with precise outcomes from a procuring cart. Google Analytics doesn’t appropriate errors or reprocess reviews. There isn’t a solution to take away, add, or overwrite historic knowledge.
The workaround for customers is to export knowledge to a spreadsheet or database and proper the errors. On this publish, I’ll clarify a course of for reprocessing Google Analytics knowledge after which reporting it in Google Sheets or Information Studio.
Reprocessing Google Analytics Information
Right here is the method.
1. Establish which knowledge must be reprocessed. Examples embody:
Gross sales knowledge doesn’t align together with your ecommerce platform. The discrepancies can come from (i) orders not captured by Google Analytics, (ii) offline orders, (iii) order cancellations, or (iv) partial or full refunds.
Classes that have been under-reported or inflated attributable to lacking monitoring code on pages or cross-domain monitoring errors that double periods for some customers.
Session errors attributable to monitoring issues by Channel and even by the Supply, Medium, or Marketing campaign.
Pageview errors attributable to (i) lacking monitoring code leading to under-reporting or (ii) duplicate tags that inflate Pageviews
Errors stemming from monitoring issues on Occasions, time on website, common Pageviews, and different metrics.
I’ve addressed auditing Google Analytics to detect errors, at “Find out how to Audit Google Analytics Information for Ecommerce.”
2. Export your knowledge from Google Analytics. I take advantage of a Google Analytics add-on for spreadsheets.
three. Prepare the metrics by day that want reprocessing.
four. Produce reviews that present the unique values per day beside the reprocessed values.
I’ve assembled a pattern report in Google Sheets known as “Instance Google Analytics Reprocessing Information.”
The “Report Configuration” sheet receives the export from Google Analytics.
The “Energy My Analytics Visitors” sheet is the place the Google Analytics knowledge is reported.
The “Corrected Information” sheet accommodates the correct Session knowledge (in column C).
Reported Classes vs. Precise
My graph in Google Sheets consists of the “Reported Classes” and “Corrected Classes.” This knowledge could possibly be included in a Google Sheets report or Information Studio report alongside different Google Analytics knowledge. To report in Information Studio, use the “Google Sheets” connector offered by Google.
To make certain, reprocessing Google Analytics knowledge is tedious and time-consuming. Keep away from it by steadily monitoring Google Analytics to catch monitoring glitches, thus eradicating the necessity to reprocess.