Extracting data from Adobe Analytics with a direct connection into Snowflake?

[Todd-TD]

We want to extract Adobe Analytics data into Snowflake. We already know about Data Feeds, Data Warehouse, etc. However, we want a direct connection rather than having to automate and FTP or Email processes. We've contacted Adobe Client Care, who recommended Adobe Engineering Services.

Ideally, we would like a tool already designed for this task, but an API would be good too. Has anyone done this before or know where to start?

[pradeep_nextrow]

For sure the APIs are the answer to this and you can do this by deploying a cloud based application either hosted in a VM on cloud (EC2) or on serverless (Lambda). You can use the APIs to build the application from scratch but you can also use some wrappers to make the job easier. Here is a Python based wrapper which can help you get strated quicker - https://www.datanalyst.info/python/launch-api/launchpy-videos-tutorial/

Also remember that there are two strategies to get data from AA to your data warehouse. 1. Get the raw hit-lvel data (data feeds/Adobe LiveStream (Firehose) API - paid service). But you have to do lot of vists/visitor level computations for this. If you only need event level data, then use this. 2. Get sessionized data (AA Data warehouse/APIs). Here you can build (almost unlimited) breakdowns on visit/visitor level data. You should evaluate all these things and there is no one stop shop for this if you are using only AA. If you are using AEP, then it is a different (and simple) story. Hope this helps!

[Todd-TD]

Thanks for the info Pradeep. It looks like there's no easy, premade solution for a direct-connect to pre-processed data, but the details and links you provided were very helpful.

Does anyone know if there's a tool, like the Excel add-in, for querying post processed Analytics data?