Does the output provide a structured report with business-relevant, brand-aligned detail and actionable guidance?
This test case passes. The output provides an accurate summary of user concerns and effectively develops strategic messaging that capitalizes on the weaknesses of competitor brands as perceived by consumers. No notable failures or limitations were identified in this generation. The result is suitable for real-world use without manual correction, as the data-driven approach allows for the development of highly targeted counter-messaging based on precise analysis of specific competitors.
Red: Not supported; Green: Supported
Primary deliverable: Data analysis workbook (.xlsx)
• Format: Microsoft Excel Workbook (.xlsx), no macros (no .xlsm); compatible with Excel 2019+ and Google Sheets
• Structure (tabs): README, Data_Raw (immutable), Data_Clean, Analysis, Charts, Outputs, Assumptions, QA_Log
• Tables: Excel Tables for all datasets; consistent column headers;frozen header row; filters enabled
• Data types: ISO dates (YYYY-MM-DD); currency columns formatted to campaign currency; units stated in headers; no merged cells in data tables
• Calculations: formulas only; named ranges for key inputs; clear cell comments for assumptions
• Visuals: charts embedded + editable; axes/units labeled; export-ready chart sizing for slides (16:9-friendly)
• QA: row-count checks; missing-value flags; outlier checks; reconciliation vs source totals; version + timestamp in README
• File size limit: ≤ 25MB; external links disabled; all data embedded
We conducted a social listening campaign for our brand competitors over different social media channels. Based on this data, extrapolate for us a number of key insights as to consumer sentiment surrounding their product, brand perception, trust etc.
Extrapolate that into actionable guidance, particularly strategic messaging points that could be used to inform our future social media creative.
