Archive for the ‘Reports’ Category

Twitter Integration Enhancement Ideas

Posted on March 9th, 2010 by Adam Greco  |  2 Comments »

As I was at Omniture Summit last week, I couldn’t believe that it had already been a year since I started talking about integrating Twitter data into Omniture SiteCatalyst!  Since I haven’t seen many updates about this integration come from Omniture, I thought I would share a few enhancements I have made over the year in case any of them are useful to those out there using the integration…

Competitor Twitter Share
When I first envisioned importing Twitter data into SiteCatalyst, my primary focus was tracking how often my brand was mentioned and importing the brand-related tweets.  This allowed me to monitor my brand usage and filter tweet reports to send the right tweets to the right people based upon search phrases.  However, the more I thought about it, the more I realized that this integration could be used to keep tabs on competitors as well.  Instead of setting one “Brand Mentions” Success Event, you could expand the scope of what is tracked and also grab tweets mentioning your competitors and set a second Success Event named “Competitor Tweets.”  This second Success Event allows you to trend your competitors and track them on the same SiteCatalyst dashboard you use to track your own brand:

This led me to another cool idea…Why not track overall “Competitor Tweet Share” in which you quantify the % of tweets your brand gets in relation to those of your competitors?  This would allow you to trend your “share of twitter” for your narrow competitive niche.  To do this, create a Calculated Metric as follows:

This results in a graph like this which allows you to see when spikes occur to see if local events or press releases move the needle:

You can also set Alerts based upon this Calculated Metric to be notified when you are spiking or tanking in relation to your competitors!

General Tweets
The next concept I thought about was “general tweets” that were related to a business.  For example, if you are Coca-Cola, you might want to keep tabs on tweets mentioning “soda” or “soft drink.”  However, you wouldn’t want these counted as “Brand Tweets” or “Competitor Tweets,” so instead you can set a third Success Event called “Twitter General Mentions” and specify a list of keywords that should trigger this Success Event.  This allows you to see if a list of “general” keywords related to your business is rising or falling over time to gauge the general level of interest in your category over time:

#Fail
Lastly, I decided that the #Fail hashtag was too good to pass up.  If your brand is mentioned in the same tweet as the #fail hashtag, you probably want your social media team (if you have one!) to be alerted at once!  To do this, all you have to do is create a scheduled report with #Fail in the search box and schedule it to run hourly.  Unfortunately, SiteCatalyst delivers hourly reports whether there is data or not (to stop this please vote for this idea) so you may need your social media folks create an Outlook rule to filter the alerts that say “No Data” in the subject.

In addition, you can perform the same exercise for your “Competitor Tweets” since your social media team may want to be notified when your competitors have a #Fail hashtag in tweets mentioning their brand name!

So there you have it…a few minor updates or enhancements to the Twitter – SiteCatalyst integration.  If you have other ideas, please leave a comment here…Thanks!

Adam Greco is the Director of Web Analytics at Salesforce.com.  You can read his previous Inside Omniture SiteCatalyst blog at http://blogs.omniture.com/author/agreco/ and can follow him on Twitter at http://twitter.com/adamgreco.  You can also hear Adam on the BeyondWebAnalytics podcast.  Please send questions and comments to adam@the-omni-man.com.

Please note: I am no longer an employee of Omniture and the content/views expressed here are my own and not those of Omniture.


Page, Section, Site Naming Best Practices

Posted on March 1st, 2010 by Adam Greco  |  7 Comments »

Recently on Twitter, there was some discussion about the best way to name your pages in SiteCatalyst.  Therefore, I thought I would share some thoughts on the best way to set names for Pages, Sections, etc… when using SiteCatalyst.  Hopefully, you are already doing most of what I will mention here, but just in case, here are my suggestions.  Also, keep in mind that many people have different styles of naming pages (and feel very strongly about it!) so what is shown here are my personal preferences…

Naming Pages
If you don’t manually apply a “friendly” page name to the s.pagename Traffic variable (sProp) in SiteCatalyst, Omniture will capture the URL by default.  This is not ideal for the following reasons:

  1. URL’s can be very long and exceed the sProp character limit (normally 100 characters)
  2. URL’s can be hard to understand by end-users
  3. URL’s can have querystring parameters that get cutoff which means that many pages get treated as one page name in SiteCatalyst (which ruins Pathing reports)
  4. URL’s can have a http:// and https:// versions which means two versions of each URL which subdivides Pathing, Unique Visitors, etc…

Therefore, it is highly recommended that you name your pages the way you would like to see them in the Pages report.  I generally recommend naming pages based upon directory structures or manually by adding fields to your content management system.  Once you figure out how you will name your pages, the key question is what should you name your pages.  Here are my recommendations:

  • Make sure all pages within each unique website have a common identifier.  For example, if you have three distinct websites that serve different purposes, I like to assign a value in the page name for each website so I can easily filter those pages in a global report suite (one that has data from all websites).  For example, for the Omniture website, I would have an identifer for the public (marketing) website (i.e. “omtr:”) and a different identifier for say the Idea Exchange (i.e. “ideas:”).
  • I like to include the section in the page name when possible.  For example, if the Omniture public website has a section for “Products” and another for “Services,” I would include those in the page name (i.e. “omtr:products:” or “omtr:services”).  This allows you to easily filter Page reports to get all of the pages within a section.  Some companies also include the sub-section in the page name which is fine as long as you don’t hit the sProp character limit.
  • Make sure all pages have a unique name.  If you have two pages with the same exact page name, SiteCatalyst will treat them as a single page and all stats for that page will be merged (including paths).
  • Be mindful of case-sensitivity.  sProps are case-sensitive, so if you have the same pagename value, but in different cases, you will get two distinct page names.  A common best practice is to force upper or lower case in the JS file to avoid any issues.

So if you put all of these ideas together, a list of your pages might look like this:

One wrinkle that can emerge are cases where you have multiple geographic websites.  For many companies, this results in a similar version of the website, but translated into different languages.  If you have this situation, I recommend tweaking the above page names to include a site locale indicator.  For example, each page in the UK site should have “uk:” in the page name and so on.  When this is done, your page names might look like this:

[Advanced User Alert - If you have multiple site locales, I also recommend passing the page name without the site locale to a different sProp (with Pathing enabled) so you can see how a page does across all site locales (i.e. Participation).  I also like to pass the site locale by itself to a separate sProp so in a global report suite I can create correlations between sProps and other variables (i.e. Internal Search Terms).]

One other item related to site locales is the use of different languages or translated pages.  While I do recommend different page names for each site locale, I do not recommend that you have different pagen ames for the same page translated into different languages.  You can read more about this in my old Foreign Language post.

As you can see, this doesn’t look all that hard to implement, but by using the above items you can easily:

  • Filter pages for a website (i.e. omtr: vs. ideas:)
  • Filter all pages for a specific section (Search contains :services:)
  • Filter all pages for a particular site locale (Search contains “:uk:”)
  • Filter on a combination of the above items.  For example, let’s say you wanted to see all UK Product pages (Search contains “:uk:products:”)

When you look at this it makes common sense, but I can’t tell you how many clients I ran into that had incomprehensible page naming which made everything more difficult.  Even if it means losing some historical page data, I always recommend that clients have good page names as it pays great dividends down the road…

Site Sections (s.channel)
After dealing with Page Names, the next thing I like to tackle is Site Sections.  These are useful if you want to see how visitors are navigating your website at a higher level than pages.  If you have good page names, you really should be able to build your Site Sections by setting it equal to the page name minus everything past the last “:” symbol.   For example, in the example above, if the page name is “omtr:us:services:consulting” then the section would be “omtr:us:services” (you choose whether you want to include the “:” at the end or not).  I have seen many clients that can set Site Section values automatically based upon good page names which saves a lot of development work and ensures consistency.

Site
One variable that many clients forget to include is the Site variable.  Essentially, what you are doing here is to pass in a value for the website by itself into an sProp.  In the example above, this would mean values of “omtr” or “ideas” by themselves in an sProp.  Doing this allows you to see total Visits and Unique Visitors by site in one report and when Pathing is enabled, allows you to see how people are navigating from one website to another.  Again, if you have good page names, you can set the Site variable by simply grabbing everything before the first “:” symbol in the page name.

Page Type
Those of you who have read my previous blog posts know that I am a fan of setting a Page Type on each page that represents the function of the page.  I won’t rehash this topic, but recommend you check out my prior post on this.

Advanced Stuff
For those who are a bit more advanced in their SiteCatalyst usage, you can check out the following page related advanced topics:

So there are a few items related to naming Pages, Sections, etc…Let me know if you find these tips helpful and/or if you have come up with best practice suggestions of your own you’d like to share…

Adam Greco is the Director of Web Analytics at Salesforce.com.  You can read his previous Inside Omniture SiteCatalyst blog at http://blogs.omniture.com/author/agreco/ and can follow him on Twitter at http://twitter.com/adamgreco.  Please send questions and comments to adam@the-omni-man.com.

Please note: I am no longer an employee of Omniture and the content/views expressed here are my own and not those of Omniture.


Traffic Source Bounce Rates

Posted on January 25th, 2010 by Adam Greco  |  8 Comments »

Recently out on Twitter, someone had asked how you can calculate Bounce Rate for various Traffic Sources.  In the past I have shed light on how you can create Bounce Rates for campaign elements, visitor types, etc…, but I failed to share how to see Bounce Rates for SEO, SEM, E-mail, etc…  In this post I will share the way to do this. If you are reading this post, odds are you know what Bounce Rates are, but quickly, it is the percent of visitors who saw one thing (normally page or section) and then went no further.  If you need a refresher on Bounce Rates, you can look at my old Bounce Rate post, or better yet, check out Avinash’s post on Bounce Rates.

Why Traffic Source Bounce Rate?
Often times, marketers want to see how each of their disparate online marketing channels are doing when compared to each other.  Most will rate them by how well they perform against the website KPI’s.  However, due to its popularity, may want to see the Bounce Rate for these online traffic sources.  While my Segment Pathing post showed you how to see the bounce rate for a specific traffic source element (i.e. SEO Google keyword going to your home page), what if you want to see the total Bounce Rate for SEO or SEM?  Unfortunately, that doesn’t come out of the box in Omniture SiteCatalyst (though you can derive it in Omniture Discover).  I am not going to tell you whether the Traffic Source Bounce Rate is a valid metric as that depends upon your business objectives, but the next section will outline how to implement it.

Implementing Traffic Source Bounce Rate
So how do you implement Traffic Source Bounce Rate?  Like any Bounce Rate metric, you need to be able to calculate Single Access and Entries.  In SiteCatalyst, that means you need Pathing to see these metrics, so you know right off the bat we are going to need a Traffic Variable (sProp).  Once you have identified which sProp you are going to use and had Pathing enabled for it by ClientCare, you need to find a way to get the various Traffic Sources that you use into that sProp.  The ones I commonly use are:

  1. SEM
  2. SEO
  3. E-mail
  4. Display Ads
  5. Affiliates
  6. Social Media
  7. Other Websites
  8. Typed/Bookmarked (a.k.a. the rest)

The key to this solution is that you need to find a way to identify the Traffic Source of the first click to your site.  This can be done manually in your JS file or semi-automated using the Unified Sources VISTA Rule or the similar Channel Manager Plug-in.  Regardless of the method, what I try to do is to find something that uniquely identifies each online marketing channel.  Usually the best way to do this is through a query string identifier.

Here is how I do this:

SEM – If a click to your website comes from a Search Engine, you should have an identifier (i.e. ?s_kwid=) in the URL.  If you do, you know the Traffic Source is SEM.

SEO -  If the click comes from a Search Engine, but doesn’t have that identifier, it is SEO!

E-mail – When you send e-mails, you should be tracking the inbound clicks with a query string parameter.  If so, set it to something unique for e-mails (i.e. ?eid=) so you know that if you see that identifier in the URL, the Traffic Source is E-mail.

Display Ads – In a similar manner, if you are buying Display Ads, you normally get to choose the destination URL.  Therefore, you can set the destination URL on your site to have another unique identifier (i.e. ?displayid=) so you know which clicks have come from Display Ads.

Affiliates – See Display Advertising (i.e. ?affID=)

Social Media – This one is a bit trickier, but what I do is make a list of the key Social Media sites I want to track and when I see the referring URL contains one of those URL’s, I set the Traffic Source to Social Media.

Other Websites – If all of the above criteria have not been met, but there is a referring URL, set the Traffic Source equal to “Other Website.”

Typed/Bookmarked – If none of the preceding conditions have been met and there is no referring URL, set the Traffic Source to “Typed/Bookmarked.”

Phew!  It sounds difficult, but you should be using different query string parameters anyway in your campaigns area and any good JavaScript developer can do this somewhat easily.  It does require coding (which I don’t do myself!), but maybe Omniture will provide this out of the box one day…

But Wait…There’s More!
Believe it or not, you are not done yet!  Once you have found a way to distinguish the Traffic Source and are passing that into an sProp on the first page of every visit, you are 90% of the way there.  The last step is a bit confusing (techie alert!).  In order for SiteCatalyst to know if a visitor made it beyond their first page of the visit (hence, did not “Bounce”), it needs to see a different value in the sProp at some point during the Visit.  If it doesn’t see another value passed to the sProp, it will assume they didn’t see any other pages and exited the site (your boss won’t want to see a 100% Bounce Rate for every channel – trust me!).  Therefore, when a visitor navigates to a second page in the visit (any page – doesn’t matter which one), you need to force a “dummy” value into the same sProp that you previously passed Traffic Source.  My clever developer, passes in the value “Did Not Bounce” as the dummy value.  I will let those more technical than me discuss the best way to pass this dummy value, but once you have done this, you will have a new sProp that has one value for each of your Traffic Source Types and one extra one for the dummy value.  Since this sProp has Pathing enabled, you will have a Single Access and Entries metric for each of your Traffic Sources and can now calculate Bounce Rate (I recommend using Advanced Search to hide the dummy value and save it as a Custom Report so you don’t confuse your users).

For the most part , this sProp won’t have much value beyond calculating the Bounce Rate since it is really only set on the first page of the visit, but here are some additional goodies:

  1. Use Trended reports to monitor Traffic Source Bounce Rates over time
  2. Enable Daily, Weekly, Monthly, etc… Unique Visitors on the sProp to see Uniques for each Traffic Source
  3. Correlate it to any other sProps that are most important on the first page of the visit (i.e. Referrer, Visit Number, etc…)
  4. There is one more cool thing you can do with this, but it is so cool, I need to do a full post about it so stay tuned for my next post…

Final Thoughts
Well there you have it.  I wish it was not so convoluted, but don’t shoot the messenger!  If anyone else knows an easier way to do this, I am all ears.  I apologize for this being a bit more technical/complicated than most of my posts, but I don’t know of a non-technical way to explain this.  Let me know what you think…

Adam Greco is the Director of Web Analytics at Salesforce.com.  You can read his previous Inside Omniture SiteCatalyst blog at http://blogs.omniture.com/author/agreco/ and can follow him on Twitter at http://twitter.com/adamgreco.  Please send questions and comments to adam@the-omni-man.com.

Please note: I am no longer an employee of Omniture and the content/views expressed here are my own and not those of Omniture.

Basic Brand Awareness Tracking

Posted on January 18th, 2010 by Adam Greco  |  1 Comment »

One of the holy grails of online marketing teams is to find a way to track and measure a company’s Brand Awareness.  There are many different approaches to do this including the use of products like comScore, Compete, Twitter, but more often than not, it takes place offline in research studies.  While this trend is not going to change anytime soon, as a web analyst, you may be looking for data that you can collect to provide an estimate of your Brand Awareness.  Therefore, in this post, I wanted to share a “quick and dirty” way to use online data to see and trend the popularity of your company brand.  While this will not be a comprehensive approach, it might provide a basic starting point into the larger “Brand Awareness” puzzle.

Why Track Brand Awareness?
There are many schools of thought on whether it is even worthwhile to try and track Brand Awareness.  While people like us try to track everything, sometimes, there are things that are just not meant to be tracked.  If you own a website that sells stuff, then there is so much you can do with Web Analytics that tracking Brand Awareness is probably way down on the list.  However, there are many companies (i.e. B2B) that don’t sell products directly and inevitably the question arises:

“What is the true purpose of my website?”

If you are part of one of these companies, the above question is often followed with a spirited debate about whether success should be judged by lead counts, unique visitors, visitor engagement, etc…  At some point one Marketer will say that the website should be used to build Brand Awareness so success should be judged by increasing Unique Visitors, only to be countered by another saying that Unique Visitors don’t mean anything if they aren’t the right types…After about an hour of this, there is rarely a consensus on how to judge the success.  Soon you can see why this is not a popular topic in Web Analytic circles!

Amid all of this confusion, I think that people sometimes forget the real reason that people care about Brand Awareness.  At the end of the day, you want to measure how often consumers that are interested in a product/service that you provide think of you when the time comes to research or buy that product/service.  If you are doing a really good job at branding your company such that you are top of mind when consumers are at this stage, then one way or another you have done something right.  This is why I think there is some value in trying to quantify this and trend it over time.

So What Can Be Tracked?
So building upon the previous section, let’s assume that you don’t sell a product directly on your website, but that there are consumers out there who need your product/service (and have a blank checkbook in hand!).  Do you think they would:

  1. Come to your office and ask to see your salespeople?
  2. Pick up the Yellow Pages and give you a call?
  3. Mail you a letter asking for information?

Maybe in the 1980’s, but not today!  Most are going to go to a Search Engine and a few savvy ones will go to Twitter.  So if the bulk of these will go to a Search Engine, and you are truly “top of mind” from a branding standpoint, they would probably search for your company name or the name of one of your products.  For example, if the consumer is looking for a “CRM” product they might search for “CRM.”  But if you are doing your job and have an awesome brand such that the first thing people think of when they think about “CRM” is your company brand (I don’t know…maybe something like “salesforce.com” ;-) ), then you would know that your brand is alive and kicking!

Following this logic, you can see that one interesting way to track your brand awareness is to quantify how often people are coming to your website from a list of “Branded” keywords of your choosing.  This list of keywords would include your company name, product names, key executive names, etc…  If you can aggregate these SEO keywords (I wouldn’t include Paid Search Keywords), then you have a number that you can trend over time.  Keep in mind that this is not an exact way to track brand awareness, but the logic behind it is that the more people [organically] search for your key brand phrases, the more pervasive your brand is out there.  In my consulting experience, I have often found that the number of SEO Brand Searches has a direct correlation with other key website success metrics.

So How Do I Implement SEO Branded Keyword Tracking?
In a perfect world, it would be great if there were an easy, reliable way to track how often your brand keywords were searched on all of the major search engines.  Companies like comScore try to estimate this, but it is not always accurate due to the panel-based methodology.  Another way I have tried to get at this data is through Google Trends, but I have not found ways to automatically export that data through API’s (if you know how please let me know!).

That being said, if you want to use SEO Branded Keywords to track your brand, take the following steps:

  1. Work with your Marketing team to identify the list of keywords that everyone agrees are “Brand Keywords.”  In order to not distort the trend, it is important that you not continually add to the list so try and get an exhaustive list and stick to it for an extended period of time (i.e. readjust yearly).
  2. The next step is to isolate these Branded Keywords in your SEO reports.  One way to do this is to add each one to the advanced search criteria for your SEO Keywords report (in the interface or ExcelClient), but if you have a lot this can be difficult.  My preferred approach is to pass SEO Keywords to a custom eVar.  Once you have done this, you can use SAINT to classify these keywords as “Branded Keywords” and then use the trended view of reports.  If you are using the Channel Manager plug-in or the Unified Sources Vista Rule, you should already have the data you need in a custom variable.
  3. Once you have these branded keywords isolated, you can create a report that looks like this:

In addition, if you have specific products that are brands of their own, you may want to apply the same technique to the SEO Keywords that represent those brands and chart the Brand Awareness of your different products amongst each other (maybe inspire some competitiveness?).  For example, at Salesforce.com, we group our products into “Clouds” so you might chart the SEO Keywords related to the various “Clouds” on a graph to see how each is doing (shown with sample data here):

Don’t Forget About Twitter!
As mentioned earlier, another way to look at how your brand is doing is to look at Twitter.  This can be done using the Omniture Twitter Integration I proposed last year.  Implementing this provides you with a way to see how often your brand is being talked about so you can see a chart like this:

If you want to get fancy, you can even measure how your brand compares to the brand of your competitors on Twitter.  The graph below shows what I call “Twitter Competitive Share” and is calculated by the following formula:

Branded Tweets / (Branded Tweets + Competitors Branded Tweets)

The result is a chart that looks like this:

Final Thoughts!
Well there you have it, definitely not world peace, but if you are looking for some different ways to leverage your web analytics data, hopefully these ideas give you some food for thought.  If there are other ways that you are using web analytics data to track Brand Awareness, please leave a comment here as I’d love to hear about it…

Adam Greco is the Director of Web Analytics at Salesforce.com.  You can read his previous Inside Omniture SiteCatalyst blog at http://blogs.omniture.com/author/agreco/ and can follow him on Twitter at http://twitter.com/adamgreco.  Please send questions and comments to adam@the-omni-man.com.

Please note: I am no longer an employee of Omniture and the content/views expressed here are my own and not those of Omniture.

Embedding SiteCatalyst Reports

Posted on December 21st, 2009 by Adam Greco  |  1 Comment »

One of the old adages in business is location, location, location.  In this post, I will share a way that you can ease end-users into the data you want them to see by embedding key reports in to places they are already are frequenting.

Why Embed Reports?
In my experience, most users don’t log into tools (check the SiteCatalyst usage logs) and many ignore e-mailed reports.  But if you can provide relevant information in a context that is meaningful to them, you have a better chance of adoption.

Another barrier to web analytics adoption is that SiteCatalyst reports don’t provide a lot of context.  What I have longed for is a place where I could share more than a few sentences of information about the report an end-user is viewing.  However, for all of its virtues, SiteCatalyst does not provide a lot of tools to provide context to reports.  The ones I have seen are as follows:

  1. Adding a text reportlet to a SiteCatalyst Dashboard.  This is ok, but it is hard to share a lot of information or graphics here.
  2. Adding notes to reports.  Again, you are limited to basic HTML and it is difficult to replicate report notes to many report suites.
  3. There is no real way to associate notes to reports that are e-mailed out other than a short description.
  4. Adding notes to an Excel Dashboard.  This is what I have used the most, but Excel Dashboards can be harder to share and have issues for Mac users.

In addition to the above limitations, as stated earlier, I like to get reports closer to my end-users.  For these reasons, I choose to embed reports into Intranets and web pages.  For example, recently, our development team launched a cool new sidebar helper tool on the website affectionately known as “Super-Sassy.”  Instead of sending a report to my users telling them how the new tool has performed, why not show all recipients what the tool is with the associated data:

embed_1

In the example above, I might show data related to our “Super-Sassy” tool along with explanations of all of the metrics on an Intranet page used by the people who designed and developed the tool.  This provides context for people who would not normally be using web analytics data and (hopefully) gets them excited about learning how the tool they have developed is being used.  I even included a button at the top that allows them to launch the full report in SiteCatalyst should they want to change the date range, country data set or dig into more detail.  Finally, in the embedded SiteCatalyst report, I can pre-filter the data using a search and pre-select the appropriate report suite and date ranges, which all goes a long way to simplifying things for people who are not web analysts.

Which do you think will be used more, the above report or the same report buried in an eVar report somewhere within the SiteCatalyst interface?

How’d He Do That?
So how do I do this?  Obviously embedding depends upon the environment you are trying to embed into so I will share the general principles and hoepfully you can apply them to your own envirnment.

One approach is to use SiteCatalyst Widgets.  About a year ago I showed how to use SiteCatalyst Widgets to embed reports into tools like iGoogle so I recommend you check out that post to see if that will work in your environment.

For today’s example, I am going to show what I did above, which is embedding SiteCatalyst reports into Google Sites.  If you are not familiar with Google Sites, it is a free template-based tool you can use to build team group pages, Intranets or any other site you’d like.  I like to use secure Google Sites to build Web Analytics portals or embed reports in existing Google Sites being used by teams at my organization.

Let’s imagine that your social media team has a Google Site that they use to track information about the company’s social media program.  This site has a page for the social media team, social media policies, articles related to social media, etc… Now let’s say that you have implemented some cool Omniture SiteCatalyst Twitter Integration which allows you to see how often your company’s branded keywords are mentioned on Twitter.  Wouldn’t it be cool if you could embed the report showing Twitter mentions directly into the social media team’s existing Google Site?  Here’s how to do it:

  • Work with your social media team to add a page to their Google Site that describes the business question that your report aims to solve.  In this case it might be something like “How often is Salesforce.com mentioned on Twitter?”  On this page, you should provide some context, such as what keyword phrases you would characterize as a “Salesforce.com mention” so users know what makes up the metric.
  • Next, in a new browser window/tab, create the SiteCatalyst report that you want to show your audience on the page.  You do this as you would normally create a report, by selecting the variable (eVar, sProp or Success Event) and the desired date range.
  • Next is the tricky part, in the Google Site menu, insert a Google iFrame Gadget as shown here:

embed_2

  • Once this gadget is embedded, click the Properties link which will show the window below.  In your SiteCatalyst tab/window, use the new shortcut link feature (if you need a refresher on how to do this, see this post) to create a shortcut link to the report you created above.  Enter this shortcut link in the “URL to content” box.  Choose the sizing and border settings as you wish and when you are done, save the gadget.  The only bummer in this technique is that Omniture only keeps these shortcut links for one year which means that you would have to repeat this step with a new link once per year (please join me in lobbying Omniture to make these links indefinite!)

embed_3

  • Finally, save the new Google Site Page and you are finished.  You can go to the Google site and search on a phrase you included in your page (i.e. “Twitter”) and see the new page in the results list:

embed_4

  • When your users click on the page you created, they will see a page like the following:

embed_5

Presto!  You now have a SiteCatalyst report embedded into a Google Site already used by your stakeholder that provides useful information and as much free text/graphic context as you would like to add!

How Much of a Web Analytics Geek Are You?
So the above example is specific to Google Sites, but there are many ways to create iFrames of the shortcut links or the Widgets discussed earlier.  However, if you do use Google Sites and are truly a Web Analytics geek, there is a checkbox in the Google Site setup that allows you to track how Google Site pages are used (using a tool that shall remain nameless here!).  Said tool would allow you to see how often people are accessing your wonderful new page and might look something like this:

embed_6

Final Thoughts
Since most of you out there are more technical than I am, I expect that you can apply these concepts in ways I never imagined to do amazing things.  The goal of this post was simply to get you to “think outside of the box” and realize that there are many more ways to share your SiteCatalyst data other than e-mailed reports and SiteCatalyst Dashboards.  Enjoy!

Adam Greco is the Director of Web Analytics at Salesforce.com.  You can read his previous Inside Omniture SiteCatalyst blog at http://blogs.omniture.com/author/agreco/ and can follow him on Twitter at http://twitter.com/adamgreco.  Please send questions and comments to adam@the-omni-man.com.

Please note: I am no longer an employee of Omniture and the content/views expressed here are my own and not those of Omniture.

My Favorite v14.6 New Features

Posted on August 6th, 2009 by Adam Greco  |  4 Comments »

A few weeks ago, with the release of SiteCatalyst v14.6, there were a few interface features added that people like me have been requesting for a long time.  While there were many new items released, two of the more simple ones can go a long way to making the lives of power users easier.  Below is a quick description of these two enhancements and why I like them.

Send Link
Have you ever worked hard to create a beautiful report in SiteCatalyst and wanted to share it with others at your company?  To do so, you usually have to save it as a Bookmark or to a Dashboard and then share that Bookmark or Dashboard and then tell users how to find it and add it to their list of Bookmarks or Dashboards.  Alternatively, you could send it to them in PDF/Excel/CSV format, but then they cannot manipulate it (change the dates, add different metrics, etc…).  Well all of that is a thing of the past now since you can now easily send a link to the exact report you are looking at to one of your peers.  The only prerequisite is that they have a log-in to SiteCatalyst and have security access to the report suite and variables used in the report.  This is a real time-saver and I think will be useful in driving SiteCatalyst adoption by getting people into the tool to explore vs. always looking at reports sent via e-mail.

To send a link to a report, simply click the new icon found in the toolbar…

14_6_SendLink

…and you can copy this link and send it to people at your organization.  I was told that these links would be good for a year which should be plenty of time.  The way I am excited to use this feature is in PowerPoint presentations where you can put a screen shot of a report and then make the entire screen shot image a hyperlink to the real report so when you are presenting you can easily dive right into the report without having to fumble around to find different reports when you are short on time and/or in front of executives.

My only complaints/enhancement requests of this new feature are as follows:

  • I would like to be able to have this feature for Dashboards as well
  • It would be cool if you could e-mail the link to SiteCatalyst users be picking names from an address book since they all exist in the Admin Console anyway.  Even better if you could set-up some groups for people who you commonly e-mail
  • In the future, it would be interesting if you could send the link to a Publishing List which would show the same report, but for a different report suite to different groups of people (however, this would mean you need to check a box to determine if the link is variable or not like Dashboard reportlets)

Update Dashboard Reportet
The second new feature I love is the ability to update Dashboard reportlets.  Using this feature, you can now make changes to a Dashboard reportlet much more easily than in the past.  Previously, to update a Dashboard reportlet, you would have to:

  1. Open the Dashboard
  2. Launch the reportlet into full view
  3. Make your changes
  4. Click to add the new version back to the Dashboard
  5. Update the reportlet settings
  6. Wait for the Dashboard to open
  7. Delete the old version of the reportlet
  8. Move the new version to the correct space (phew!)

Now you can accomplish the same thing by doing the following:

  1. Open the Dashboard
  2. Launch the reportlet into full view
  3. Make your changes
  4. Click the new link (shown below) to update the Dashboard reportlet

14_6_Reportlet

As you can see, this is much easier and much more intuitive for end-users.  In addition, you can even change report suites and view the same reportlet for a different data set and update it and it will be saved back to the Dashboard tied to the new report suite!  Very exciting for Omniture guys like me!

Well those are my two favorite enhancements, but I know there were many more made.  Let me know if you agree/disagree that these two items are useful or if there are other feature updates that you have found useful or if you have additional suggestions on how these two can be improved (maybe Omniture Product Management will end up reading these!).  Thanks!

Adam Greco is the Director of Web Analytics at Salesforce.com.  You can read his previous Inside Omniture SiteCatalyst blog at http://blogs.omniture.com/author/agreco/ and can follow him on Twitter at http://twitter.com/adamgreco.  To be alerted to new blog posts, I recommend subscribing to this blog via e-mail using the tool provided on the top-right of this page.  Please send questions and comments to adam@the-omni-man.com.

Please note: I am no longer an employee of Omniture and the content/views expressed here are my own and not those of Omniture.