Answering billions of reporting queries each day with low latency

Google Ads infrastructure runs on an internal data warehouse called Napa. Billions of reporting queries, which power critical dashboards used by advertising clients to measure campaign performance, run on tables stored in Napa. These tables contain records of ads performance that are keyed using particular customers and the campaign identifiers with which they are associated. Keys are tokens that are used both to …

ads advertising campaign dashboards data data warehouse distributed systems engineer google google ads head infrastructure latency low performance power product publications reporting research software software engineer staff tables warehouse