The power of Claude Cowork: A single prompt that replaces an entire consulting team

The problem: weeks of analysis, multiple specialists

Imagine this: your German e-commerce revenue dropped sharply in Q1. You need answers. Normally that means weeks of analysis, multiple specialists, and scattered reports in different formats.

With Claude Cowork, you submit one structured prompt and get back a complete analysis, including executive summaries, board presentations, action plans, appendices with detailed breakdowns, methodology documentation, and a full source log. All generated from your internal data files, enriched with online market research.

What the prompt does

The prompt below demonstrates what Claude Cowork can do. It instructs Claude to act as a senior e-commerce analyst, digital strategist and executive reporting assistant. It analyzes GA4 exports, Google Ads reports, SEO data, price monitoring, inventory, returns, CRM data, and promotional calendars. It cross-references internal findings with external market trends. And it delivers everything in structured, board-ready output files.

This is not a demo or a mockup. This is a real prompt that you can submit to Claude Cowork today. The output is comprehensive, traceable, and actionable.

The prompt

You are Claude Cowork acting as a senior e-commerce analyst, digital strategist and executive reporting assistant.

Goal: investigate the Q1 revenue decline in Germany and determine which causes contributed most per channel, product group, device, region and week. Use both internal files and online research. Deliver not only conclusions, but also verifiable evidence, structured output files and a complete source overview.

Environment and sources

Work in the /Germany_Q1_Decline/ folder and analyze at least these internal files:

GA4_export_sessions_conversions.xlsx

Google_Ads_DE_Q1_campaign_report.csv

Microsoft_Ads_DE_Q1.csv

SEO_landingpages_DE.xlsx

Merchant_Center_disapprovals_DE.csv

Price_monitor_DE_vs_competitors.xlsx

Inventory_and_stockouts_DE_Q1.xlsx

Returns_and_cancellations_DE_Q1.csv

CRM_repeat_purchase_DE.xlsx

Promo_calendar_Q1_DE.pdf

Additionally, search online for context on market developments in Germany in Q1, consumer demand and seasonal effects, visible price differences with key competitors, trends in CPC, competitive pressure and shopping advertising in Germany, and external factors that may have contributed to the revenue decline. Use online sources only as a supplement to internal analysis, not as a replacement.

Analysis questions

What part of the revenue decline is due to less traffic, what part to lower conversion rate and what part to lower average order value?

What role did Paid Search, SEO, Shopping, price position, stock issues, returns/cancellations and CRM/repeat purchases play?

In which campaigns, product categories, devices, regions and weeks was the decline largest?

Are the causes mainly internal (price, stock, landing page, feed quality, promotion, CRM) or external (market, competition, demand)?

Which 3 causes had the biggest impact, supported by numbers?

What signals point to correlation between channels?

Which issues are immediately solvable and which require further investigation?

Methodology

Inventory all available files, tabs, columns and metrics.

Create an overview of relevant KPIs per file.

Analyze traffic, conversion, revenue, AOV, stock, price, feed quality, returns and CRM separately.

Identify connections between datasets.

Check online for external explanations or benchmarks.

Draw conclusions only based on demonstrable evidence.

Create all requested output files.

Add complete source documentation.

Requested output files

Executive_summary_DE_Q1.pdf

Board_presentation_DE_Q1.pptx

Action_plan_DE_Q2.xlsx

Appendix_analysis_DE_Q1.xlsx

Methodology_and_sources_DE_Q1.docx

Source_log_DE_Q1.xlsx

Transparency and source log

For every important conclusion, explicitly document:

Which file was used.

Which tab, report or section was used.

Which metric was used.

Which period was compared.

Which benchmark or comparison was applied.

Which online source was potentially used.

Reliability of the conclusion: high, medium or low.

Final delivery

Top 3 root causes of the revenue decline.

Evidence per root cause.

Which files and reports were examined.

Which online sources were consulted.

Which actions should start within 7 days.

Which actions should be tested within 30 days.

What additional data is needed to strengthen the analysis further.

Working with your own files

The key difference with Claude Cowork is that it works directly with your files on your machine. It can read spreadsheets, CSVs, and PDFs. It creates output files that you can open in Excel, PowerPoint, and Word. No copy-pasting, no reformatting. Just results.

This is why I believe Claude Cowork is the most powerful AI tool for business professionals today. Not because it can chat, but because it can work.