Pivot table is useful for marketing analytics to?

• A. Summarizing campaign performance across channels and time periods.
• B. Storing raw email templates.
• C. Replacing the CRM system.
• D. Creating unrelated charts.

Answer: (A)

Pivot tables are about turning a large, multi-dimensional dataset into a compact summary that highlights patterns across different groupings. In marketing analytics, you usually have data split by channels (like email, social, paid search) and by time periods. A pivot table lets you group by these dimensions and quickly summarize key metrics—such as impressions, clicks, conversions, spend, and ROI—by channel and by time. This makes it easy to compare how each channel performs, observe trends over weeks or months, and spot which combinations drive the most impact. It’s not for storing raw templates, not a replacement for a CRM, and while you can generate charts from it, the main value is the organized, aggregated view of performance across channels and time.