Ingest Adobe Data into Snowflake | Community
Skip to main content
Level 2
March 29, 2019
Solved

Ingest Adobe Data into Snowflake

  • March 29, 2019
  • 2 replies
  • 3374 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Asheesh_Pandey

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.

2 replies

Andrey_Osadchuk
Level 10
March 29, 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.

Asheesh_Pandey
Community Advisor
Asheesh_PandeyCommunity AdvisorAccepted solution
Community Advisor
March 30, 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.

- Asheesh