What is a practical limitation of spreadsheets for marketing analytics?

• A. They are expensive
• B. They require no maintenance
• C. They excel at multi-database integration
• D. They have a limit on how much data they can handle

Answer: (D)

Spreadsheets hit a practical ceiling as data grows. They’re excellent for small to moderate datasets and quick calculations, but each spreadsheet has a finite amount of data it can store and process. Modern Excel tops out around 1,048,576 rows by 16,384 columns, and even with tools like Google Sheets, you can run into performance bottlenecks, sluggish recalculations, and higher risk of errors as the data volume from multiple marketing sources increases. For marketing analytics, where you often pull in large volumes from ad platforms, web analytics, CRM, and offline data, this data limit makes spreadsheets unsuitable as the sole analytics solution. That’s why this is the best choice: there is a real, practical limit on how much data they can handle. The other options don’t fit because affordability isn’t inherent to spreadsheets, they do require ongoing maintenance, and spreadsheets aren’t built to excel at multi-database integration.