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

I did but I still need at least a sequence which says instance for evar must be in combination for search type a both. And without sequence only visitbased segment saying 2 instances and syerachtype a doesnt necessary include visits with twice searchtypoe a also a>b and a>a and a>b-->b

Any other idea?

Julia Katharina Wielgat

Corporate Intelligence

Telefon + 49 (0) 4106 - 704 23 34

Telefax + 49 (0) 4106 - 704 19 56

juliakatharina.wielgat@comdirect.de<mailto:juliakatharina.wielgat@comdirect.de>

Von: kanikas19907318 <forums_noreply@adobe.com>

Gesendet: Dienstag, 25. Juni 2019 18:54

An: Wielgat, Julia Katharina <JuliaKatharina.Wielgat@comdirect.de>

Betreff: DWH Export with sequence segment

DWH Export with sequence segment

created by kanikas19907318<https://forums.adobe.com/people/kanikas19907318> in Adobe Analytics - View the full discussion<https://forums.adobe.com/message/11138788#11138788>