If you encounter an error reading Query failed: ScriptError, there are a few steps you can take to diagnose and resolve the issue.
Causes and solutions
Being logged into multiple Google Accounts while using Supermetrics can cause errors, including ScriptError.
Google Sheets cell limitations
Google Sheets imposes some limitations on how much data you can have in a single spreadsheet. Including too many rows of data in a spreadsheet can trigger this limitation and cancel any queries that would push the number of rows over Google Sheets' limit.
Rows in every tab in a spreadsheet count toward the spreadsheet's total row value.
To solve this, lighten and optimize your Google Sheets queries.
Google application conflicts
Occasionally, third-party applications running in Google Sheets (like Supermetrics) can conflict with each other. This can cause errors, including ScriptError.
The best way to solve this is to clear your browser's cache and cookies. Here are instructions on how to do this in some popular browsers: