Sequence Analysis with Tableau and Alteryx Part 2 by Orders

In the previous post, I analyzed the SuperStore data set under the angle of the sequence of Products purchased. In this post, we will adopt a different angle: the sequence of Orders.
Continue reading

Posted in Alteryx, Marketing, Tableau | Comments Off on Sequence Analysis with Tableau and Alteryx Part 2 by Orders

Sequence Analysis with Tableau and Alteryx

I’m introducing a different type of post this week: still a tips and tricks style of post, but it stands against additional business context than usual, to be more relevant and applicable.

Sequence Analysis techniques and concepts originate from biology research, but they are actually very relevant in the field I am more familiar with: Marketing. Since a lot of Marketing analytics revolve around the understanding of customer behavior, it only seems logical that the sequence of the observed behavior comes to prominence. For instance, in most research scenarios, a customer who purchased a music album on iTunes after watching a video of the artist on YouTube, should be segmented differently than the one who purchased that same album and then proceeded to watch the same YouTube video: the sequence reveals most certainly a different causality between those actions.

Now, unlike biology where sequencing applies to strings of nucleic acids, sequencing in marketing implies trying to identify trends within large amounts of transactions, using reference time/date stamps. Here are some examples:

  • Combing through weblog data such as Google Analytics, to understand the paths taken by visitors among the pages or actions on a web property, to optimize their experience and drive them towards a favored outcome, such as purchasing in e-commerce.
  • Analyzing Marketing Automation data such as Marketo, Eloqua, Pardot to identify the combined impact of marketing campaigns in sequence. Is a free trial campaign performing better after or before a webinar to introduce the offer? Is there a Golden Path of campaign touches that will convert a prospect to a customer in a minimal amount of time at a minimal cost? It is also interesting to note that the effectiveness of an automated marketing campaign can vary depending on the industry in which it is launched. For example, in the finance sector, using marketing automation tools can be a fantastic way to curate a personalized approach to marketing involving custom emails and text messages for instance. In other industries, alternative approaches might have more of an impact.
  • Monitoring and maintaining Customer Relationship to prevent churn in subscriptions using predictive models for instance, using CRM data (SFDC, SAP, Microsoft Dynamics, Oracle…)
  • Integrating your marketing solutions together (e.g. finding a way to integrate SMS for Microsoft Dynamics) to help improve your marketing efforts and getting people to pass through the customer journey funnel as quickly as possible.
  • Recommendation Systems to evaluate what is the most relevant next purchase for a customer, using predictive models here again, feeding from past transaction sequences, like seen on Amazon, the uncontested pioneer in that field.

Continue reading

Posted in Alteryx, Marketing, SFDC, Tableau | Comments Off on Sequence Analysis with Tableau and Alteryx

Coloring Tableau Worksheet

This post is most certainly more relevant to Tableau beginners coming from Excel, but advanced Tableau users might still find some value, since the question looks easy but turns out the solution is less than obvious…

Continue reading

Posted in Excel, Tableau | 1 Comment

Avoid Sampling Your Google Analytics Data

Google Analytics (GA) is a good freemium tool to analyze traffic flowing through your web properties. It is the most widely used for web analytics, with a 82.4% market share for July 2015, commensurate to Google’s share of the web search market.

Both Alteryx and Tableau provide GA connectors out of the box, which work pretty well. If you need a quick look up, the Tableau connector is the way to go:
Connect
You can pick up to 7 Dimensions and 10 Measures, the usual GA set limits.

If you need to blend the data with another data source, or other fancier manipulations before getting into Tableau, you are better off with the Alteryx Connector:
Alteryx GA Connector
Alteryx GA Connector 2

Now we are all done and happy, since Google Analytics scenarii are so well covered by those tools, right? Well, unless you ponied up the annual subscription for a Google Analytics Premium account, North of $80k, you might run into this situation when working at the transaction level:
SampleWhat happens is that the free version of GA limits each query to 500,000 sessions, and if you need to analyze sessions over several days at the page level, it’s quite easy to break that ceiling. It is a not so subtle nudge towards the Premium account.

Nevertheless, if you have an urgent need to conduct a non sampled analysis, there is a quick (and free!) fix, which involves Excel:

  1. Head to Analytics Edge to download their Simply Free tool, and install that brillant plugin into Excel. Once you relaunch Excel, a new Analytics Edge tab will appear
  2. Click on Free Google Analytics/Analytics Reporting:
    Analytics Edge 2
  3. The Plug in will let you enter your GA Credentials and define your query. Pay attention to the last Options tab, as it is where the magic happens:
    Analytics Edge
    If you check those boxes, the Analytics Edge macro will chop your query in multiples and reassemble the output in one go, leaving you with one worksheet with all the detailed transactions you need.
  4. It is then easy to import that Excel spreadsheet into Tableau or Alteryx, and aggregate at the required level, while keeping transactions details.

Easy enough?

Posted in Alteryx, Excel, Qlik, Tableau | Tagged , | Comments Off on Avoid Sampling Your Google Analytics Data

Optimize Performance by Adjusting Automatically Fields Width

Field width is not a very sexy topic compared to Visualization or Spark R. That’s a very good reason to get that basic topic out of the way with an approach that will save you time to spend on much more exciting topics. This post is all about efficiency!

It’s accepted that searching a DB table on an integer column is faster than on a string column, especially a wide one. As Interworks puts it succinctly in their Tableau Performance Checklist:
“Number and Boolean > date > string calculations when it comes to performance.”

What are the common situations where the problem is likely to happen?

  • you might have got your hands on a CSV flat file which has lost all of its formatting, defaulting to Strings
  • You might have to extract a table from a source system that is less than optimized, with fields given way too much real estate.

Continue reading

Posted in Alteryx, Performance, SFDC, Tableau | Tagged , | 1 Comment