Look up any customer's product usage before the call

Build me a product usage lookup console that our customer success and sales reps open right before a customer call, so they stop walking in blind on adoption. It is a pull based tool for one named person at a time, not a scheduled report.

The main screen is a search bar. A rep types an email address, a user ID, or an Amplitude ID and gets back the matching person. Use Amplitude Search Users (Find by Identifier) to resolve whatever they typed. This step is required before anything else can load, because Get User Activity keys off the Amplitude ID, so an email or user ID has to be resolved into that ID first. If the search returns more than one match, show a short picker listing the candidates with their user ID and last seen date so the rep chooses the right person. If nothing matches, say so plainly and suggest trying the other identifier types.

Once a person is selected, open the profile view. Pull their event stream and user properties with Amplitude Get User Activity and render the events as a reverse chronological timeline. Above the timeline show a summary strip with first seen, last seen, total session count, and top events by frequency. Important: this endpoint pages with a limit (default 100, maximum 1000) and an offset, so do not assume a single call returns the full history. Load the most recent page first and give the timeline a load more control that fetches the next page by increasing the offset, stopping when fewer events come back than the limit requested.

If there are no events in the last 14 days, show a prominent stale usage banner at the top of the profile, above everything else, saying how many days it has actually been. This is the number that changes the conversation, so it should be impossible to miss rather than buried in the timeline. Make the 14 day threshold easy to change in one place.

Next to the usage timeline, show the person's CRM record. Look them up with HubSpot Search Contacts using their email address and display lifecycle stage, contact owner, and associated company. If no contact matches, show an empty state saying they are not in the CRM yet rather than an error, and disable the note action while leaving the rest of the page fully usable.

Also show which Amplitude cohorts this person belongs to. Use List Cohorts to get the cohorts in the project and display the ones that include this user as labelled chips on the profile.

Three actions live on the profile. First, write a usage summary back to the CRM with HubSpot Create Note, associated to that contact, so the context lives where the rest of the account history already is. Generate a draft summary from the activity data covering last seen, session trend, top events, and any notable gaps, and let the rep edit it before saving. Second, add or remove the person from a cohort such as Beta invites or At risk using Update Cohort Membership, and when the target cohort does not exist yet, create it with Upload Cohort instead. Third, share the profile into a channel with Slack Send a Message, posting a compact readable summary rather than a raw data dump.

Keep a per rep history of recent lookups in a side panel, most recent first, showing the person's name or email and when they were last opened. Clicking an entry reloads that profile. This history is private to each rep, not shared across the team, so everyone can jump back to the accounts they are working this week.

Handle the slow parts gracefully. The search and the profile load are separate steps, so show loading states rather than blocking the whole page, and if the CRM lookup or the cohort list fails, still render the usage timeline instead of failing the entire profile.