Particular ad created on an ad network are shown on mutliple clients with a traffic of 200 Billion impressions per day.
Design a system that can store ad impressions per ad id and can aggregate information over a day per ad id.

The information should be accurate within 30 sec, meaning when a query is made, the data 30 sec ago should be accurate. This data needs to be kept for 2 years.