Feature Request: Leave data as is when query results in error


I use your add-on to make BI reports for the clients of my company. Occasionally there is a problem with one of the data sources, like DoubleClick Bid Manager right now. As a result the queries result in an error and no new data is coming in.

This error however, also removes all the data the query has previously collected. I was wondering if it was possible, perhaps as an extra option?, that whenever a query results in an error, that the data it has previously gathered will remain intact. Ofcourse the error still needs to be visible on the SupermetricsQueries sheet.

Let me know what you think!


  • Hi,

    This functionality is forwarded to our development team and it will be added to the development pipeline.

    Best regards,

    - Supermetrics Team 

  •  Any update on this? We're also experiencing an occasional error with updating the data. And in such case all the data is gone and it would be nice to keep the old data.

  • Hi,

    This functionality is already released. Please add 'KEEP_RESULTS_ON_REFRESH_ERROR' under the Options sections in the side bar in 'Advanced Settings' field and refresh your query. 

    Best regards,

    Supermetrics Team

Login to post a comment