TryGhost/Ghost

SCHEMA >
    `site_uuid` String,
    `date` Date,
    `device` String,
    `browser` String,
    `location` String,
    `source` String,
    `pathname` String,
    `member_status` SimpleAggregateFunction(any, String),
    `visits` AggregateFunction(uniq, String),
    `pageviews` AggregateFunction(count)

ENGINE AggregatingMergeTree
ENGINE_PARTITION_KEY toYYYYMM(date)
ENGINE_SORTING_KEY date, device, browser, location, source, pathname, site_uuid