Looker Studio Date Range and Comparison Logic Audit
Check that periods and comparisons are right.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Audit date logic in Looker Studio. Reports with default date range, comparison setting, date field used by each chart, and time zone: [DATE_SETTINGS]. Examples of numbers that look wrong: [EXAMPLES]. Make a table of every chart with Date field, Default range, Comparison, Time zone, Issue and Fix. Check for charts using different date fields (created versus paid: orders created in March and orders paid in March are different numbers, and a chart mixing them misleads), incomplete periods compared with full ones, comparison periods of different lengths, time zone differences between source and report, and week start differences. Recalculate two examples by hand, comparing the same period in the report and the source system: 1,214 in the report against 1,226 in the source is a difference of 12, or 1.0 percent; find its cause (time zone boundary, late-arriving data, a filter). Recommend a label on every page stating the date field, range and comparison, and a default of the last complete period rather than a partial one. Mark settings [VERIFY].
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.