**Objective:** Aggregate Pageview counts into an intermediate easy/quick queryable state (Intermediate Aggregates)
**Key Result:** Intermediate aggregates are used to generate data to the Pageview API and other useful cubes. Data is available starting in May.
Story: someone taking on an analyst role runs an SQL query to get pageview numbers for Executives, FR or Communications.
For example: "What were the monthly pageviews in France, excluding spiders?"
The minimum dimensions for the data are:
# daily (though hourly would support future use cases)
# project (e.g. enwiki)
# language (e.g. EN)
# access method (desktop | mobile) - apps out of scope for now
# Country Name
# Country ISO code
# is_spider
**Backfill Data for April**
{T96067}
**Tasks to setup Impala (serving layer on the cluster that can be queried)**
{T96328}
{T96329}
{T96330}
{T96331}