SQL like queries on DataWarehouse

Avatar

Avatar
Boost 50
Level 6
gaurav2
Level 6

Likes

161 likes

Total Posts

44 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Level 6
gaurav2
Level 6

Likes

161 likes

Total Posts

44 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
gaurav2
Level 6

17-02-2010

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

Avatar

Avatar
Applaud 5
Level 1
rodan32
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
rodan32
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile
rodan32
Level 1

21-02-2010

Unica's NetInsight includes this feature.