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

  • Unfortunately it doesn't work

  • Hi Sayrin,

    This setting only helps save the configuration in the case that an error or "no data" situation is preventing it from being recorded. There's currently no way to turn that into a 0 or other value if the data source does return a "no data" error. It will fill the data in as the error until the "no data" state is no longer true.

    If you need further assistance, please submit a private ticket:

    -Thank you

    Supermetrics Team