Adwords : Query failed: You query returned no data

Hi guys,

why must queries fail, just because there is no data?

Maybe someone, like me, wants to creates reports that will (hopefully) generate data in the future. 

Atm I cant create such a report. Which kind of sucks. Because I have to run new campaigns/accounts which I cant report, because the is no conversion so far. 

This sounds a bit sill, but some Account just generate, for example just 1or2 Conversions a year. But I still have to report monthly. 

I think you get my point.

It would be awesome that I could have a option to create this query anyway, if a query fails and doesn`t generate data.


1 person has this problem
  • Hi Daniel,

    try selecting "Show all time values" from Options dropdown. 


    Best regards,

    Jouni Hyötylä

    Twitter: @Supermetrics 

    Support forum:

  • Sorry but this only helps if just one of the columns or rows has no data but some others. If no there is no data at all (so far) the query is not be generated. 

  • For that kind of situation there is no workaround unfortunately. If there's no data, you only get the "error" message.

  • Hi there,

    I was hoping to find a solution here, since it says solved--but I don't think this issue is solved at all.

    It would be tremendously helpful if queries with future dates could be at least saved! That way, one could prepare an entire year's report, for example, in advance and only refresh on a monthly basis to get the latest data into sheets.

    I'm having the same issue with data from Adobe Analytics. I have to create a new query every month. This almost defeats the purpose of the tool for me as it is almost as time consuming as manually pulling and entering the latest data every month.

    Simply allowing future date queries to be saved would solve the problem. I would be able to create my report ONCE, then simply schedule a monthly refresh to fetch the latest data.

    I truly hope you understand and see the tremendous value in this.

    Thanks you!


    2 people like this
  • Hi,

    you can set the end date in to the future by writing it manually in to the end date, but unfortunately the query won't complete (and therefore save in to the sheet) if there's no data available at that point.

    We are still looking in to the possibility of creating such a feature but unfortunately we cannot promise if we are able to find a way.

    Best regards,

    -Supermetrics Team

  • Thanks for the quick reply! Appreciated. 

    Exactly. Because the query produces an error, it isn't saved to the sheet. I think it's perfectly acceptable if it shows an error message up until data becomes available, as long as the query stays saved. Sounds pretty straight forward to me from a feature perspective. 

    Good luck! 

  • Hi everyone,

    could you please test this feature:

    -Under options, write "RETURN_NO_DATA_RESULT" -in to Advanced settings.


    -Supermetrics Team

  • Hi,

    Thanks for the update. Just tried it. It looks like the command is accepted, but it doesn't make a difference. Query for future dates still fails and is therefore not saved.



  • Hi,

    Is there any update on this issue?


  • Hello,
    I'd like to bump this thread. Any updates yet? 

  • Hi! Thanks for coming back to this. Try using "STORE_ERROR_QUERY" in the advanced settings to store the query, no matter what kind of error it gets at this point.

    Best regards,

    -Supermetrics Team

  • Hi,

    I used "store_error_query" and it's working. Just one detail, when i update the data I have the error text in A1 but the old data are still on the sheet. Is that possible to refresh the data with the error text but delete the old data please ?

    Other request, if i configure a schedule every week. If the first week I don't have data and the second week I have data. The error text will disappear for the good data ?

    Thanks in advance

  • Error text should be completely rewritten when your query starts to bring in actual results.

    Best regards,

    -Supermetrics Team

Login to post a comment