How Analysts Use Data Streams to Bring Adobe Analytics Data into Snowflake

Using Data Streams to bring Adobe Analytics data into Snowflake and viewing the freshly-imported data in Tableau

As an analyst, you would like to get data related to your website and products from Adobe Analytics into Snowflake.

Setting up the Data Extract Source

You can choose an Existing Data Source or a New Data Source. We’re going to connect to a New Data Source.

2018-12-12_0656

From the Data Connector List, select Adobe Analytics.

Note that you would need to link your Adobe Analytics account before getting started. Once you do that, you’ll be able to see your Adobe Analytics credentials into the credentials list.

2018-12-12_0744

You can also select the Report Suite.

2018-12-12_0744_001

Then, you can name your Data Source. We're going to call it "Test0416AA" and click Submit.

Setting up the Data Destination

2018-12-12_0745

From the Data Connector List, select your data warehouse of choice (We will go with Snowflake). First, you will have to link your Snowflake account.

2018-12-12_0745_001

Once you do that, you will be able to select your credentials from the credentials list.

2018-12-12_0745_002

You can choose an Existing table or create a New table. We're going to go with create a new table.

Schedule and Data Range

You can set your stream to be One-time or Recurring.

2018-12-12_0745_003

You have a lot of predefined sections under Date Range.

2018-12-12_0755

You can also choose to set your own Start Date and End Date.

In terms of Granularity, our product offers: Daily, Weekly, Monthly.

2018-12-12_0755_001

We also offer three types of calendars: Standard, Retail, and Custom.

2018-12-12_0755_002

If you want your stream to be recurring, you can also select the Frequency, Time of day, and Timezone. You can also make use of the fields “Import Data since” and “Run this report until.”

2018-12-12_0756

We’re gonna go with One-time only stream with a specific period of time, daily granularity, and the standard calendar.

2018-12-12_2148

Next Step would be to add Filters and Segments.

This step is optional but we’ll show you how you can choose a metric or dimension to filter specific data, or how to Segment your data.

In the Filters section, you can filter by any metrics and dimensions you have set up.

Simply use the drop-down tab and select the data you would like to segment.

2018-12-12_2149

In Segments, you can select any segments you have set up.

2018-12-12_2150

For the demo purpose, we’re going to select a segment we’ve set up in Adobe Analytics for this demo called 'Connector Demo.'

2018-12-12_2151

2018-12-12_2151_001

Metrics and Dimensions has 3 tabs:

The first tab is Source. Here you will set your metric (mandatory) or dimension in the drop-down. Once the Source is set, you can select your Destination. This will be the column in the table.

In Data Type you will need to select the appropriate description.

To have more than one metric or dimension, simply click the green button below that says Add Metric or Dimension.

You can add as many metrics and dimensions you want for your data (*any limitations in this regard are from the cloud platform). We’re going to go for the following Metrics: Revenue, Orders, Units of products sold, and we’re also going to add couple Dimensions: product and campaign name.

2018-12-12_2151_002

Before you save your stream, you can preview your data. Click Preview Data. Note: You can preview all the data you selected, not just a sample.

This is what your data would look like, see the columns: Date/Revenue/Orders, etc.

2018-12-12_2152

Now you can name your stream and save it 'test0416.'

Once it's saved, the stream will show in the stream list, right on top of the list. It's in STARTED status, and in a couple minutes it will pass in SUCCESS status.

Once it’s successful, you’ll know you were able to successfully transfer Adobe Analytics data into your Snowflake data warehouse.

2018-12-12_2152_001

What you may want to do next is analyze that data and maybe build dashboards with it. It’s very easy to put any BI tool like Tableau, Domo, or Power BI on top of Snowflake data.

We’re going to show you how easy it is to do this in Tableau.

Open Tableau Desktop, go to 'To a server’, choose 'Snowflake' from the list of data warehouses, log in with your Snowflake Credentials and click SIGN IN.

2018-12-12_2152_002

Select your Warehouse, Database, Schema, and look for your Table. Drag and Update and that’s it! Your data is now in Tableau for you to build dashboards.

2018-12-12_2152_003