Schedule automated reports

I need weekly traffic and conversion summaries sent to Maria in marketing and to Sam, the ecommerce director, every Monday by 8 a.m. Make the report include sessions, new users, conversion rate, revenue, and a one-line explanation of any week-over-week drop greater than 10%. Before scheduling, check the date range covers the last full week and that UTM-tagged campaigns are included. Send only if data is complete.

Before I automate this report for Maria and Sam, make the key decisions obvious: put total revenue and conversion rate at the top, show week-over-week percent change next to each metric, and flag any campaign with conversion rate below 1.5%. Make the download friendly for finance by including currency and transaction count on the first sheet. Point out any gap in tracking or samples that would make procurement quarrel with the numbers.

I scheduled the weekly report to Maria and Sam showing sessions, new users, conversion rate, and revenue and sent it this morning; Maria says revenue looks too low. I’m worried tracking or attribution broke but I don’t know whether an implementation change, a UTM problem, or a view filter caused it. What’s the most likely diagnosis and the one or two checks I should run first to isolate the issue?

Every month we waste hours rerunning and annotating the same weekly traffic and revenue report because someone distrusts the numbers. Where are we losing credibility and time — in inconsistent views, missing UTMs, or poorly communicated assumptions — and what two habits should we change this month to stop firefighting?