Select a Goal | Track | Set Expectations | Update
Always use numeric targets. Track the current value and expected end-of-half values. Then use those values to report the status, using these deterministic rules. Finally include a brief update that contextualizes your progress using this style guide.
| Goal | As of | Status | Current | Target | Expected | Owner | Update |
|---|---|---|---|---|---|---|---|
| Grow DAU | 02/05 | 🟢 | 45M | 50M | 60M | John | ... |
| Grow MAU | 02/05 | 🟡 | 150M | 180M | 175M | Paul | ... |
| GTP in Bing (milestones) | 02/05 | 🔴 | 1 | 4 | 2 | Ringo | ... |
If you use this exact format, you can import rows across different sheets using import range. First add four more columns to your tracker.
| I | J | K | L | |
|---|---|---|---|---|
| 1 | Import from | Tab Name | Start | End |
| 2 | https://docs | Sheet1 | A8 | H8 |
Then import data from another tracker using this formula, adjusting the cell references as needed:
=importrange(I2, CONCATENATE(J2, "!", K2, ":", L2))