Google Custom Search API Quota Alert MQL

googlesearch_daily_quota_alert.mql

fetch consumer_quota
# Only fetch the quota usage metric
| metric 'serviceruntime.googleapis.com/quota/rate/net_usage'
# Only count custom search API requests
| filter
    (metric.method == 'google.customsearch.v1.CustomSearchService.List'
     && metric.quota_metric == 'customsearch.googleapis.com/requests')
# Map 'yyyymmdd' formatted date field in PST timezone to column 'Date'
| map
    add[
      Date:
        end().timestamp_to_string("%Y%m%d", "America/Los_Angeles")
        .string_to_int64()]
# Group by Date, sum with sliding 24h sliding window
| group_by [Date], sliding(24h), [s: sum(val(0))]
| every 1m
# Calculate percent value based on 10K quota
| value (val() / 10000)*100 '%'
# Return only the last Date
| top 1, Date
| condition val() >= 80 '%'