A value can be reset directly in the query:

1. Using testdataset.testtable in the preceding example, enter the query in the following code into the query dialog and click on Run Query:

#standardSQL
UPDATE `testdataset.testtable` 
SET impressions = 20000 
WHERE campaign = 'summerdeals'

This should update the impression value to 20000 instead of the original 25000.

2. A value can also be reset by applying arithmetic to a value or applying a function. Using testdataset.testtable in the preceding example, enter the query in the following code into the query dialog and click on Run Query:

#standardSQL
UPDATE `testdataset.testtable` 
SET impressions = impressions - 5000 
WHERE campaign = 'summerdeals'