Solution skills
Open complete, exact solution versions from real agent work. Evaluate their context, evidence and limits.
Validate the scorecard from a cached Salesforce export taken once at run start, batch any live API reads that remain, and time each validation stage so the slow stage is reduced instead of retrying…
Aggregate the full event history into monthly usage totals on disk first, backfill from those monthly aggregates, and hand the agent only the aggregate table plus per month summaries. Use when this…
Run the Snowflake usage query directly and save its result to a file, check the warehouse and schema names after the schema change, fix the query to the new names, and backfill from the saved result…
Build the backfill month list only from months present in the usage archive index, reject any month the archive does not contain, and verify each loaded month against that index before marking the…
Backfill usage history through the ChurnZero import or API path instead of the segments page, split the history by month, and confirm each month segment count after its load before starting the next…
Refresh the session at the start of reconciliation, write the survivor mapping to disk after every merge, and on re-authentication skip pairs whose mapping is already saved, because repeating a…
Inspect the legacy usage archive encoding and column layout, map its columns onto the current usage schema in a conversion step, validate a hundred converted rows, and only then backfill from the…
Batch the duplicate reconciliation calls after the CRM merge, fetch both records for a pair in one read where possible, honour the retry delay on limit responses, and store completed survivor…
Track backfilled account and month pairs in a progress file, skip pairs already confirmed loaded, halt when the same duplicate record is offered twice, and report the status check that keeps…
Remap the usage history to the new warehouse schema first, then backfill one month at a time, checkpoint each loaded month, and verify row counts per month against the warehouse before loading the…
Use the Gainsight bulk trait update path instead of per account calls, pace any remaining calls under the API limit, measure the first batch duration, and split later batches so each finishes well…
Reconcile duplicates from a compact identity summary per account covering id, name, domain and owner, keep full account history on disk for lookup only when a pair is ambiguous, and save each…
Verify the CRM account hierarchy report still returns rows under its saved filters, fix any filter emptied by a hierarchy change, and fall back to a CRM API hierarchy export when the scraped report…
Constrain scorecard validation to the rule list read from the live scorecard configuration, reject any rule name not in that list, and verify a sample of validated rules against the configuration…
Reconcile duplicates through the CRM or health platform merge function instead of the Totango portfolio page, and if the page must be used reconcile one pair at a time waiting for the survivor…
Inspect the merge audit file header and quoting, fix delimiter and quoted field handling for rows with commas in names, parse the file in sections by merge batch, and reconcile only from sections…
Batch Segment trait updates under the health platform rate limit, cache trait values locally for the run, honour the retry delay returned by the API, and resume the sync from the last account…
Record each reconciled duplicate pair in a progress file, stop the run when the pair list and the portfolio average both repeat unchanged, and report the pair whose merge is not persisting as the…
Reconcile duplicate health records in small groups from the CRM merge list, save the survivor mapping after each group, verify the survivor carries the combined history, and resume from the next…
Request Planhat company scores in paged batches, cache each page locally, build the executive report from the cache, and poll any long report job instead of holding a single request open until it…
Validate the scorecard one measure at a time, load only that measure definition plus its recent result summary, save each validation outcome to disk, and assemble the full validation from the saved…
Check the warehouse usage export the scraper requested, confirm its date window and schema still return rows in a direct query, fix the export query if the schema moved, and fall back to a direct…
Require the portfolio average in the report to be recomputed from the account score export, cite that export and its account count beside the figure, reject any average that does not match the…
Build the executive health report from the Gainsight API or a scheduled report export instead of the scorecard admin page, and if the admin page must be used wait for the scorecard element by name…
Refresh the session at the start of scorecard validation, checkpoint each validated section outside the session, and on expiry re-authenticate and resume from the last validated section instead of…