Using Clickstream with segments

Avatar

Avatar
Validate 1
Level 4
jerome_chevreau
Level 4

Likes

60 likes

Total Posts

33 posts

Correct reply

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

Avatar
Validate 1
Level 4
jerome_chevreau
Level 4

Likes

60 likes

Total Posts

33 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
jerome_chevreau
Level 4

15-01-2018

Hi all,

I am currently using clickstream data to build my own reports / visualization (as it is a piece of a bigger project) and was wondering how to go about to analyze my data using segment.

Is there a specific approach to follow?

Anyone who can help with the above?

Thank you

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

02-02-2018

Apologies there, I got my tools mixed up Data Warehouse is where you can apply segments, and not data feeds.

Pertaining getting data based on visits/visitors, there are a few good writeups on the topic. The following would be one I consider the best: Using Adobe Analytics Data Feeds and SQL for Basic Reporting – The Data Feed Toolbox

There's also a data feed lab at Summit this year that I anticipate would be valuable for your organization.

Answers (5)

Answers (5)

Avatar

Avatar
Validate 1
Level 4
jerome_chevreau
Level 4

Likes

60 likes

Total Posts

33 posts

Correct reply

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

Avatar
Validate 1
Level 4
jerome_chevreau
Level 4

Likes

60 likes

Total Posts

33 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
jerome_chevreau
Level 4

08-02-2018

Hi,

Thank you very much for sharing the link.

I will have a look at it when i have a moment.

Thanks again.

Avatar

Avatar
Validate 1
Level 4
jerome_chevreau
Level 4

Likes

60 likes

Total Posts

33 posts

Correct reply

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

Avatar
Validate 1
Level 4
jerome_chevreau
Level 4

Likes

60 likes

Total Posts

33 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
jerome_chevreau
Level 4

24-01-2018

Hi,

Thank you for the info.

I do have the PDF but nothing really highlight best practice to look at data based on a segment as mentioned in my previous comment.

I was hoping to have some best practice which will help get the data based on visitor or visits etc...

Additionally, as far as i have seen while setting up data feeds, there are no option to apply a segment unless i am missing this option completely.

Thanks

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

23-01-2018

If it's going into an SQL-type database, you can use commands like WHERE or HAVING to effectively segment data. If you need to know what each column means, you can refer to this: Clickstream Data Column Reference

If you only care about the segmented data (and nothing else), you can apply a segment when creating the data feed, so the resulting file is only the data you care about. You'd be able to use the built-in segment manager to create the criteria you're looking for.

Avatar

Avatar
Validate 1
Level 4
jerome_chevreau
Level 4

Likes

60 likes

Total Posts

33 posts

Correct reply

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

Avatar
Validate 1
Level 4
jerome_chevreau
Level 4

Likes

60 likes

Total Posts

33 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
jerome_chevreau
Level 4

20-01-2018

Hi,

Thank you very much for you response.

For the moment, it will be very manual. FTP > extract and push into mysql (as I will start testing with a day or 2 of data).

I am thinking of using python to do the rest. As a start I just want to understand what I need to do for building segments as the Adobe PDF simply highlights the calculations for certain metrics.

I would really appreciate if you have any info / additional resources or advise.

Ideally, I would think that I would go towards Hadoop and apache spark. What do you think?

Thanks

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

19-01-2018

What tool are you importing your clickstream data into?