feat: AI-powered weekly activity summary #883

Activity

1. TimeToBuildBob commented on Jul 1, 2026

   

   TimeToBuildBob

   on Jul 1, 2026

   Contributor

   More actions

   This is a great fit for AW and the design already gets the privacy tradeoffs right (client-side aggregation, key in localStorage, opt-in send).

   One reference that might save you some design time: gptme-activity-summary is a Python CLI that does the same AW-query → LLM-summary pipeline for human work reports:

   gptme-activity-summary daily --mode human --date yesterday --raw   # data only, no LLM call
   gptme-activity-summary weekly --mode human --week last              # LLM narrative summary

   The --raw mode is the useful bit for your Vue prototype — it shows the intermediate data shape we settled on after a few iterations: top apps (name + duration + distinct-title count), top browser domains, and AW-category rollups (using the user's existing categorization rules, not just app names). Splitting "aggregate query results into that compact shape" from "hand the formatted text to whichever LLM provider" as two separate steps made provider-swapping trivial later — worth keeping that same seam in AiSummary.vue even though your stack is JS, not Python.

   Happy to share more detail on the aggregation logic if useful. Looking forward to seeing this land — go ahead and start prototyping.
2. 7nicetoseeu commented on Jul 1, 2026

   

   7nicetoseeu

   on Jul 1, 2026

   Author

   More actions

   Thanks, this is very helpful.

   I took your suggestion and plan to keep a clear seam between:

   1. AW query -> compact aggregated shape
   2. �ggregated shape -> provider-specific LLM request

   For the first pass, I’m aiming for a minimal but usable Tools -> AI Summary page in �w-webui that:

   • queries an existing AW time range locally
   • aggregates the data into a compact payload instead of sending raw events
   • focuses on top apps, top browser domains, and category rollups based on the user’s existing categorization rules
   • lets the user choose provider/model locally
   • stores provider config in browser local storage only, so it never touches AW server settings

   I’ll likely keep the first PR intentionally small and leave things like richer aggregation fields and streaming as follow-ups.

   I’m starting from that structure now and will open a PR once the prototype is ready.
3. TimeToBuildBob commented on Jul 1, 2026

   

   TimeToBuildBob

   on Jul 1, 2026

   Contributor

   More actions

   Thanks for picking up the seam split — that's the move that made provider-swapping easy later.

   Here's the compact aggregation shape we ended up with in gptme-activity-summary (Python, but the TS interfaces map directly). Putting them in AiSummary.vue is probably the cleanest spot:

   interface AppUsage {
     app: string;
     duration: number;        // seconds
     titleCount: number;      // distinct window titles
   }
   
   interface BrowserDomain {
     domain: string;
     duration: number;
   }
   
   interface CategoryUsage {
     category: string[];      // ["Coding", "Python"] or ["Uncategorized"]
     duration: number;
   }
   
   interface SummaryInput {
     startDate: string;
     endDate: string;
     totalActiveHours: number;
     topApps: AppUsage[];
     topDomains: BrowserDomain[];
     categories: CategoryUsage[];
   }

   The two AQL queries worth reusing — both already supported by your existing queries.ts infrastructure (bid_window, bid_afk, filter_afk):

   1. Top apps (with AFK filtering when the AFK bucket exists):

   afk_events = query_bucket("{bid_afk}");
   afk_events = filter_keyvals(afk_events, "status", ["not-afk"]);
   window_events = query_bucket("{bid_window}");
   events = filter_period_intersect(window_events, afk_events);
   events = merge_events_by_keys(events, ["app"]);
   events = sort_by_duration(events);
   RETURN = events;
   

   Then walk the result and count data.title per data.app for titleCount.

   2. Category rollup (uses the user's existing AW categorization rules via the settings API, then the AQL categorize() fn):

   window_events = query_bucket("{bid_window}");
   events = categorize(window_events, <category_rules_json>);
   events = merge_events_by_keys(events, ["$category"]);
   events = sort_by_duration(events);
   RETURN = events;
   

   When the user has no rules configured, AW returns every event as ["Uncategorized"] — gate the category section in your output on categories.some(c => c.category[0] !== "Uncategorized") so they don't get a meaningless "Uncategorized: 100%" block.

   The intermediate-format function lives at gptme-contrib/packages/gptme-activity-summary/src/gptme_activity_summary/aw_data.py (format_aw_activity_for_prompt + the _fetch_* helpers). The one detail that surprised us: use category_total as the denominator for category percentages, not total_active_seconds — the categorize() query and the apps query are separate HTTP round-trips, so their totals don't always match exactly.

   For the LLM side: keep the prompt a single markdown string of SummaryInput, and let the provider adapters just translate that into a chat-completions request. OpenAI ↔ DeepSeek ↔ Ollama becomes a config-only change.

   Happy to answer more specific questions on the aggregation logic as you build. Go for it.
4. TimeToBuildBob commented on Jul 15, 2026

   

   TimeToBuildBob

   on Jul 15, 2026

   Contributor

   More actions

   Just checking in — any progress on the prototype? Happy to answer questions or look at a draft PR if you want early feedback. If life got busy and you'd prefer Bob just build the minimal version, let me know and I can take a crack at it.
5. TimeToBuildBob

   added a commit that references this issue on Aug 3, 2026

   feat(ai-summary): add client-side AI activity summary page

   ...

   f5e2b28
6. ErikBjare

   closed this as completedin 1be5633on Aug 3, 2026
7. iloveitaly

   added a commit that references this issue on Aug 4, 2026

   feat(ai-summary): add client-side AI activity summary page (ActivityW…

   ...

   1be5633
8. ironcatan

   added a commit that references this issue on Sep 5, 2026

   feat(ai-summary): add client-side AI activity summary page (#922)

   ...

   8be2779