AdWords daily shceduled query issue when no filter match found
I have an adwords query set up which has a filter for certain campaigns.
This query is supposed to update daily with data for yesterday only.
The problem is the campaigns I am filtering for aren't running at the weekends and that seems to be upsetting the query which is scheduled to run daily.
Instead of the query running and not returning anything it it just returns the Account dimensions with blank date and all metrics set to 0.
That's upsetting my report as that invalid data is automatically being appended to a sheet with all our marketing channels.
I tried filters and it doesn't work and I need the Account column there to identify the country the campaign was run in - any other solutions?