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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct Reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct Reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

29-06-2019

Dear Laetizia_w,

Sequential Segments are not supported in DataWareHouse because it ties up to visits or Unique Visitors but not the individual line items or hit level as in DataWareHouse.

But for your request i don't think you need a Sequential Segment.

Create a segment with a Visit Container : SearchType equals a and Search Type eVar instances equals 2 with exclude visits container SearchType equals b.

But again, it will be tied to visits and hourly report may contain the counts of visits which didn't end during the time.

The only best solution i can say is using Data Feeds, but you need to calculate all these by yourselves using some ETL.

Thank You!

Arun

Answers (2)

Answers (2)

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>

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