A client wanted to see how many impressions and clicks they were getting for broken pages. So I queried their Search Console data in Google BigQuery—removing query parameters and consolidating landing pages—then used the requests API in Python to batch return the status codes for their top landing pages. I scheduled that query to execute every morning at 3am. Finally, I added Response Code as a filter to all their Tableau dashboards that use Search Console as a data source, which were already scheduled to refresh daily at 4am.