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
BedrockMission!

Learn More

View all

Sign in to view all badges

DWH Export with sequence segment

Avatar

Avatar
Validate 25
Level 3
laetizia_w
Level 3

Likes

32 likes

Total Posts

91 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 3
laetizia_w
Level 3

Likes

32 likes

Total Posts

91 posts

Correct Reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
laetizia_w
Level 3

25-06-2019

Our website has two different internal searches: search type a and b. It gets differentiated by a prop called search type and also an evar with the same name.

My goal is to get a dwh export on hourly basis for visits with only one search for searchtype a and vs. visits with searchtype a more than 1.

I have tried using a sequence segment with a then condition plus including anjd excluding, but due to the sequence I am not able to use this for dwh export.

I have also tried created a calculated metric but this is another restriction from the dwh.

Does anyone know a better solution on this?

I would need a segment which for examples says something like evavr search type instance equals or greater than 2 but both must also be search type a, because if I would use it like this it would also count for search type b.

I hope someone knows a better solution and I dont get why there is such restriction on Adobes side for calculated metrics and sequence segments.

View Entire Topic

Avatar

Avatar
Validate 1
Level 3
kanikas19907318
Level 3

Likes

20 likes

Total Posts

31 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
kanikas19907318
Level 3

Likes

20 likes

Total Posts

31 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
kanikas19907318
Level 3

25-06-2019

Hi laetizia_w,

How about you try using eVar instances in segment? If it meets your requirement, it can be used in data warehouse.

Additionally, here is a document on what segment features are compatible in DW: Data Warehouse Segment Compatibility

1779307_pastedImage_0.png

See if this helps.

Regards,

Kanika