Data Sources [Inside Omniture SiteCatalyst]
by Adam Greco
posted on 01-25-2009
While more and more business is taking place on the web each day, we online marketers cannot forget about successes and/or conversions that take place beyond the website. While Omniture SiteCatalyst can capture all of your online success, there are times when you need to couple this with business metrics that take place offline or in other channels. To do this, Omniture SiteCatalyst provides a Data Sources feature. In this post I will briefly explain what Data Sources is and how it can be used.
Understanding Data Sources
So what is Data Sources? Data Sources is a mechanism to manually import additional metrics and metric dimensions into SiteCatalyst. The primary reason that customers choose to import this data is to compare online metrics to these non-website metrics. The following are some examples of situations in which you might want to use Data Sources to import data:
- Import historical traffic data from log files or a previous vendor
- Import offline success metrics unrelated to the website or taking place after a visit to the website
- Import metrics from a separate channel such as e-mail or call center so you can compare them to online metrics and create calculated metrics
- Import metrics from other products through Omniture Genesis such as e-mail or CRM metrics (most Genesis integrations use Data Sources behind the scenes)
In all of these cases, clients are looking to supplement their online data with related data so they can get a more complete picture of their business. I find a good way to understand Data Sources is through a practical example. Let’s say that an Omniture customer decides to start an e-mail marketing program. They select a vendor and the vendor happens to be part of Omniture’s Genesis network. As part of the Genesis integration, the client begins receiving some new metrics in SiteCatalyst via Data Sources including E-mail Sends, E-mail Opens, etc… Each of these metrics appears alongside existing online Success Events. Therefore, the client can view key e-mail statistics from within SiteCatalyst without having to look two places. Finally, the client can create a calculated metric that divides Submitted Online Leads by E-mail Sends and many others. All of this is accomplished through Data Sources.
How Do I Enable Data Sources?
While I won’t go through the detailed steps required to set-up Data Sources, the following is a brief overview of the process of setting up a Data Source:
- Most Data Source imports use Incrementor Success Events so you must create these ahead of time through the Administration Console. You will need one Success Event for every metric that you plan to import
- Create any desired Conversion Variables (eVars). In addition to importing metrics, you can optionally choose to import eVar values associated with those metrics. For example, if you track online activity with a Campaign Tracking Code, and have Campaign Tracking Codes for the offline metrics, you can import the metrics with Campaign Tracking Codes. This will allow you to view both online and offline metrics in Campaign reports. If you do not import Data Sources metrics with an associated eVar value, you will not be able to view Data Source metrics broken down by eVars, but rather, will only be able to see total metrics (please re-read as this confuses many clients).
- Go through the Data Sources wizard which will help you to create a Data Sources file import template and FTP site. As you go through the wizard you will need to know the Success Events and eVars for which you want to import data. Please note that the wizard only allows you to select a few Success Event Metrics and a few eVar dimensions which can be confusing, but rest assured that you can add more metrics and eVars directly to the template afterwards (Omniture Consulting or ClientCare can show you how to do this).
- Once you have the template and the FTP site, you are ready to import data. Most clients will do the first few uploads manually and then find a way to automate the FTP upload process on a daily or weekly basis.
Important Things To Know About Data Sources
The following are some important things to know about Data Sources:
- Once you import Data Sources data into SiteCatalyst, it cannot be undone or removed. For this reason, you need to be very careful and make sure you have done thorough testing and have a good process in place for automated data uploads. Always test within a development report suite!
- All data imported via Data Sources is tied to a date so it does not matter when it is imported. Obviously, the sooner it is imported, the more accurate your overall SiteCatalyst data set will be
- You cannot have more than 50 Megabytes of data in your Data Sources FTP account at a time (not 50MB per file, but in total across all files) or it will become “locked” so it is recommended that you feed the data to SiteCatalyst accordingly
- Each row of data imported via Data Sources is charged ($$) as an image request (“hit”) at your contracted rate
- Some types of Data Source imports allow you to see the imported data in SiteCatalyst only, while others allow you to see imported data in SiteCatalyst, DataWarehouse, ASI and Discover. For this reason it is important to be sure you select the correct Data Source Type (for more information read the Data Sources user manual found in Knowledge Base article # 527)
In this week’s real-world example, we will look at a scenario for one of Greco Inc.’s electronics subsidiaries. In this situation, Greco Inc. is doing its best to sell printers online, but at the time that the sale is completed, it is not able to accurately determine the exact shipping cost, which can vary based upon a few post-sale factors. In addition, Greco Inc. would like to add the Cost of Good Sold to SiteCatalyst so it can create some more realistic calculated metrics for judging Campaign success and other analyses.
To accomplish these two goals, Greco Inc. sets up two new Incrementor Success Events (COGS & Shipping Costs) and then determines how it would like to break down these new offline metrics. For its online sales, Greco Inc. does most of its analysis by Tracking Code, Order Number, Brand, Product Type and Coupon (if used). It already has eVars created for these and regularly looks at online metrics such as Orders, Units and Revenue by these dimensions. After going through the Data Sources wizard, Greco Inc. has an FTP account set-up and the following Data Sources import template (shown here with one sample line of offline data):
Once all testing is done, Greco Inc. can begin importing the offline data via Data Sources and can then see a SiteCatalyst report that includes both online and offline data:
There is a great deal more to learn about Data Sources including different types (Integration, Full Processing, etc…), but these are more advanced topics to be saved for a future post. If you are interested in digging into Data Sources, Omniture provides a special user manual on the topic (Knowledge Base article # 527) which I suggest you check out.
Have a question about anything related to Omniture SiteCatalyst? Is there something on your website that you would like to report on, but don’t know how? Do you have any tips or best practices you want to share? If so, please leave a comment here or send me an e-mail at firstname.lastname@example.org and I will do my best to answer it right here on the blog so everyone can learn! (Don’t worry – I won’t use your name or company name!). If you are on Twitter, you can follow me at http://twitter.com/Omni_man.
Learn more about Omniture Consulting
Learn more about Omniture University