Ingest Adobe Data into Snowflake

Avatar

Avatar
Validate 1
Level 2
bc11043975
Level 2

Likes

8 likes

Total Posts

23 posts

Correct reply

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

Avatar
Validate 1
Level 2
bc11043975
Level 2

Likes

8 likes

Total Posts

23 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
bc11043975
Level 2

29-03-2019

What is the best way to load Adobe Analytics data or also Adobe Audience Manager data into Snowflake. On visitor level, or visit or hit level. Only selected data and it doesn't have to be like the entire clickstream data feed. Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct reply

145 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

130 likes

Total Posts

334 posts

Correct reply

145 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile
Asheesh_P
MVP

29-03-2019

It actually depends on how you want to analyze the selected data. Hit based data makes sense when you are only looking for total instances vs visit/visitor based data makes sense when you look for visit/user-based calculations in place of the total hits. Ex. If I look for the total unit sold for an item than hit based data makes sense but if I look for units sold per visit/visitor than its a different story.

However, hit based clickstream data export (data feed - A defined set of parameters and values used to collect a set of data.) is the safest bet while if you need to calculate hits by visits/visitors than segment export (data warehouse) can help.

Answers (1)

Answers (1)

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

537 likes

Total Posts

968 posts

Correct reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

537 likes

Total Posts

968 posts

Correct reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

29-03-2019

The visit and visitor level data means you are interested in the processed data. Use Data Warehouse in Adobe Analytics.

Audience Manager operates with a different type of data sets — profiles that are linked to traits and segments.