Supermetrics Support Forum


How can we get this to display zero - Query failed: Your query returned no data

Using supermetrics for G sheets.  I have several queries that don't return any data... YET, however they will do in the near future.

Is it possible to get Supermetrics to save the query and return a zero "0" value to the cell?  Currently I get the error message below and the query isn't saved :-(

Query failed: Your query returned no data

I have tried ticking "Replace blank metric values with zeros"


  • Hi Jon,

    Try using the Advanced setting:


    It may still give the error in the cell instead of a 0, but at least you can save the query configuration to use later.

    -Thank you

    Supermetrics Team

Login to post a comment