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.
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.
You can also select the Report Suite.
Then, you can name your Data Source. We're going to call it "Test0416AA" and click Submit.
Setting up the Data Destination
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.
Once you do that, you will be able to select your credentials from the credentials list.
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.
You have a lot of predefined sections under Date Range.
You can also choose to set your own Start Date and End Date.
In terms of Granularity, our product offers: Daily, Weekly, Monthly.
We also offer three types of calendars: Standard, Retail, and Custom.
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.”
We’re gonna go with One-time only stream with a specific period of time, daily granularity, and the standard calendar.
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.
In Segments, you can select any segments you have set up.
For the demo purpose, we’re going to select a segment we’ve set up in Adobe Analytics for this demo called 'Connector Demo.'
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.
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.
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.
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.
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.