One-hundred % of all Google Analytics implementations have damaged in some unspecified time in the future. The impression 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 buying cart. Google Analytics doesn’t appropriate errors or reprocess reviews. There isn’t any option 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 submit, I’ll clarify a course of for reprocessing Google Analytics knowledge after which reporting it in Google Sheets or Knowledge Studio.
Reprocessing Google Analytics Knowledge
Right here is the method.
1. Determine 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 had been under-reported or inflated on account of lacking monitoring code on pages or cross-domain monitoring errors that double classes for some customers.
- Session errors on account of monitoring issues by Channel and even by the Supply, Medium, or Marketing campaign.
- Pageview errors on account of (i) lacking monitoring code leading to under-reporting or (ii) duplicate tags that inflate Pageviews
- Errors stemming from monitoring issues on Occasions, time on web site, common Pageviews, and different metrics.
I’ve addressed auditing Google Analytics to detect errors, at “Methods to Audit Google Analytics Knowledge for Ecommerce.”
2. Export your knowledge from Google Analytics. I exploit a Google Analytics add-on for spreadsheets.
3. Prepare the metrics by day that want reprocessing.
4. Produce reviews that present the unique values per day beside the reprocessed values.
Examples
I’ve assembled a pattern report in Google Sheets known as “Instance Google Analytics Reprocessing Knowledge.”
The “Report Configuration” sheet receives the export from Google Analytics.
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 “Energy My Analytics Visitors” sheet reviews the Google Analytics knowledge.
—
The “Corrected Knowledge” sheet comprises the correct Session knowledge (in column C).
Column C of the “Corrected Knowledge” sheet comprises the correct Session numbers.
Reported Classes vs. Precise
My graph in Google Sheets consists of the “Reported Classes” and “Corrected Classes.” This knowledge might be included in a Google Sheets report or Knowledge Studio report alongside different Google Analytics knowledge. To report in Knowledge Studio, use the “Google Sheets” connector supplied by Google.
To report in Knowledge Studio, use the “Google Sheets” connector.
To make sure, reprocessing Google Analytics knowledge is tedious and time-consuming. Keep away from it by often monitoring Google Analytics to catch monitoring glitches, thus eradicating the necessity to reprocess.