the use case example: profile views, ad campaign performance, etc.
in an analytical fashion:
who viewed this profile in the last weeks (all years, by years, days, selected date rages, …),
how many views of this profile,
how many ads were clicked per campaign, etc.
the data size is about 1tb, and growing
what db to pick up for such cases?