Work planning
How to Compare This Week So Far With Last Week
Published by OneCell
Compare the same completed weekdays in both weeks. If this week’s report is ready through Tuesday, compare Monday and Tuesday with Monday and Tuesday last week. Use the same measure, source and hours for both totals.
Choose the latest day both reports can support
Start at the beginning of your reporting week. Stop at the latest day through which the records are complete in both weeks. A day can have ended while the report for it is still preliminary. If Wednesday’s numbers are still coming in, keep both cutoffs at Tuesday. Google Search Console’s notes on incomplete periods and preliminary data
Check the dates behind a report’s comparison label. An option called Previous period may use the dates immediately before the selected range. Google Analytics, for example, offers separate options for the immediately preceding dates and a comparison aligned on weekdays. Google Analytics date comparison options
Compare 21 inquiries with 18
Imagine a community class organizer who counts registration inquiries received by email during the same operating hours each weekday. At 2 p.m. on Wednesday, the report is ready through Tuesday. Wednesday shows four inquiries so far.
Last week. Monday had 10, Tuesday had 8, Wednesday had 15, Thursday had 14 and Friday had 13. The five days add up to 60. The first two add up to 18.
This week. Monday had 12 and Tuesday had 9, for a total of 21. Leave Wednesday’s four out of this comparison while the day is in progress.
Comparing 21 with 60 would mix two days of records with five. The matched result is three more inquiries through Tuesday close. In a note, write the two windows and the scope. For example, “Email registration inquiries through Tuesday close. Nov 16–17, 21. Nov 9–10, 18.”
Advance both cutoffs when the next day is ready
Once Wednesday’s finalized count of seven arrives, include Wednesday in both weeks. This week’s total becomes 28 and last week’s becomes 33. That is five fewer inquiries through Wednesday close. Keep the cutoff with each result so readers can see why the direction changed.
Before extending the window, check for changes such as a closure, shorter hours or a new intake channel. Use the same hours, channel and counting rules where the records support it. If the two periods cover different activity, say what changed when you report the numbers.