Looker Studio Metric Accuracy Audit Against Source Platforms
Check dashboard numbers against the original platforms.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Audit report accuracy. Numbers shown for a period: [REPORT_NUMBERS]. The same numbers from the source platforms: [SOURCE_NUMBERS]. Date range, time zone and filters used in each: [SETTINGS]. Tolerance: [TOLERANCE]. Compare each metric, compute the difference and percentage, and group differences into three bands: within tolerance, explainable, and unexplained, with the count and largest difference in each. Examine causes in plain words: different time zones, different attribution windows, sampling, filters, definition differences, recent days still updating, and duplicates from blends. Do not call a difference an error until you have explained it. For each unexplained difference give the first three checks in order of cost. Return a table with Metric, Report, Source, Difference, Percent, Likely cause and Next check, prioritised by the largest differences, and a sign-off note stating the period, tolerance and the person who accepted the report. Repeat monthly for three months and then quarterly. Keep the sign-off note short enough to attach to the report. If a difference stays unexplained after the three checks, say who should be asked next and what to tell readers in the meantime.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.