Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SQL like queries on DataWarehouse


Level 6


On several occassions, you want Data Warehouse report which have particular value(s) of certain variable(s) only. But the interface allows only to select all values of the variable or none at all. If the query could have been created more like SQL queries where you could, for eg.


Select Gender, Age

Where Campaign variable = "Valentines email blast" AND Product = "Roses"


While in SiteCatalyst we have the ability  to do simple stuff like this through Segment but it is an overkill since I just want only 'Gender' and 'Age' values and not all other reports. And Discover is costly Smiley Indifferent !!


Ofcourse Group by etc. would be great as well if you have not used SAINT.


I suppose the resulting reports would be created much faster as well?

1 Comment