Skip to content

S26 · Pipeline skill

Review weekly operations

Align table definitions, identify changes worth checking and draft a weekly report with follow-ups.

Multi-table joins + periodic anomaly comparison + human explanation and follow-up

Pipeline: 5 steps
Human review: 1
Components: 11

Proposed composition; integration pendingSynthetic data

Download · ZIP · 20KB Pipeline

Review weekly operations — Synthetic walkthrough of inputs, step handoffs, human review and the final result. Live services still need integration.

01Pipeline

Base pipeline

Ordered steps. Each consumes the previous output; review gates hold until a person accepts.

Starts from: Authorized business tables, comparison periods and previous reports
Delivers: Archived weekly report and continuing follow-up items

Review contract

People decide at review gates; components supply data, drafts or review surfaces. Unaccepted outputs do not advance.

Integration note

Analysis components cover distinct dimensions of aligned tables; calendar overlap and channel correlations do not establish causation.

01
Collect and align tables
Input
Authorized business tables, comparison periods and previous reports
Output
Aligned data with source, scope and attribution
- Dashboard table extractionAuthorized dashboard table extraction + scope and source metadata
- Authenticated warehouse query adapterAuthorized query submission and polling + normalized result tables
- Partner attribution mapping and quality checksSource mapping joins + ownership conflict flags
02
Compare periods and segments
Input
Aligned data with source, scope and attribution
Output
Period trends and segment comparisons
- Hotel demand, order and traffic analyticsTime, region and entity aggregation + trends and window overlaps
- Inbound hotel cohort timepoint metricsWorkbook entities joined to historical values + period summaries
- Booking lead-time and stay-pattern analysisTime-grouped records + lead-time and cycle comparisons
03
Find exception candidates
Input
Period trends and segment comparisons
Output
Exception candidates with low-base and scope caveats
- Hotel campaign spike detectionCurrent versus historical windows + anomaly candidate evidence
- Order-to-traffic anomaly diagnosticsSegmented metric drilldowns + scope differences and divergence
04
Check causes and evidence
Human review
Input
Exception candidates with low-base and scope caveats
Output
Human-reviewed explanations and unresolved causes
Decided byAssigned reviewer or requesting user
- Campaign and holiday evidence enrichmentChanges aligned with calendar candidates + source review queue
05
Assemble report and follow-ups
Input
Human-reviewed explanations and unresolved causes
Output
Archived weekly report and continuing follow-up items
- Ranked findings and weekly follow-upAnomaly impact ranking + prior finding follow-up
- Bilingual weekly hotel performance reportsAligned period comparisons + archived bilingual weekly reports

02Industry versions

Industry versions

Travel & hotels Source-supported industry Align bookings, stays, visits and channel data, preserve metric definitions in explanations and follow up on prior findings.

Adaptation All members have travel source tags; check warehouse permissions and metric definitions, and do not treat holiday overlap as a cause.

01
Align order and channel tables
Input
Hotel orders, stays, traffic and prior weekly reports
Output
Business tables with scope and attribution
- Dashboard table extractionAuthorized dashboard table extraction + scope and source metadata
- Authenticated warehouse query adapterAuthorized query submission and polling + normalized result tables
- Partner attribution mapping and quality checksSource mapping joins + ownership conflict flags
02
Compare stays and source windows
Input
Business tables with scope and attribution
Output
Stay trends and channel comparisons
- Hotel demand, order and traffic analyticsTime, region and entity aggregation + trends and window overlaps
- Inbound hotel cohort timepoint metricsWorkbook entities joined to historical values + period summaries
- Booking lead-time and stay-pattern analysisTime-grouped records + lead-time and cycle comparisons
03
Find unusual hotel segments
Input
Stay trends and channel comparisons
Output
Exception candidates and low-base caveats
- Hotel campaign spike detectionCurrent versus historical windows + anomaly candidate evidence
- Order-to-traffic anomaly diagnosticsSegmented metric drilldowns + scope differences and divergence
04
Editor checks explanations
Human review
Input
Exception candidates and low-base caveats
Output
Reviewed explanations and unresolved causes
Decided byAssigned reviewer or requesting user
- Campaign and holiday evidence enrichmentChanges aligned with calendar candidates + source review queue
05
Archive the report and follow up
Input
Reviewed explanations and unresolved causes
Output
Bilingual weekly report and continuing items
- Ranked findings and weekly follow-upAnomaly impact ranking + prior finding follow-up
- Bilingual weekly hotel performance reportsAligned period comparisons + archived bilingual weekly reports

Travel & hotels · Solutions →

03Parameters

Parameters

From the pack’s params.schema.json. Choose values to build a synthetic request.

skills/_pipelines/weekly-business-review/params.schema.json

locale · required industry · required adapter_mode · required Human review · 4 Check causes and evidence

Request (synthetic)

{
  "synthetic": true,
  "run_id": "synthetic-example",
  "locale": "en",
  "industry": "base",
  "adapter_mode": "local",
  "records": [
    {
      "id": "synthetic-record-1",
      "synthetic": true,
      "text": "Synthetic observation A: a draft needs review."
    },
    {
      "id": "synthetic-record-2",
      "synthetic": true,
      "text": "Synthetic observation B: retain the unresolved question."
    }
  ],
  "decisions": {}
}

04Member components

Member components

Dashboard table extraction

Authorized dashboard table extraction + scope and source metadata
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Authenticated warehouse query adapter

Authorized query submission and polling + normalized result tables
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Partner attribution mapping and quality checks

Source mapping joins + ownership conflict flags
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Hotel demand, order and traffic analytics

Time, region and entity aggregation + trends and window overlaps
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Inbound hotel cohort timepoint metrics

Workbook entities joined to historical values + period summaries
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Booking lead-time and stay-pattern analysis

Time-grouped records + lead-time and cycle comparisons
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Hotel campaign spike detection

Current versus historical windows + anomaly candidate evidence
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Order-to-traffic anomaly diagnostics

Segmented metric drilldowns + scope differences and divergence
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Campaign and holiday evidence enrichment

Changes aligned with calendar candidates + source review queue
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Ranked findings and weekly follow-up

Anomaly impact ranking + prior finding follow-up
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline
Bilingual weekly hotel performance reports

Aligned period comparisons + archived bilingual weekly reports
- Travel & hotels · Source-supported industry
- Logistics & supply chain · Transferable use
Working 1 pipeline

05Skills pack

Skills pack

Runnable reference on synthetic fixtures with tests. Domain contracts, services and approvals still need integration.

weekly-business-review-1.0.0.zip

Contains SKILL.md, pipeline.json, params.schema.json, runner, tests, fixtures, integration checklist and sources.

Synthetic workflow reference; service integration pending

Download · 20KB

SHA-256 e3ba0d8fd4c09549f4506a2640b1a7998cc8048e4fea8f6c4cd80a0a9e58d6a0