Posts Tagged ‘beginner’

Oct 23

desktop background google analytics regex cheatsheetI have a background in design. With powerful tools and applications like Photoshop, remembering all the commands can be a challenge. It’s almost 100% necessary to have keyboard shortcuts and cheat sheets if you plan to do heavy surgery with them. Despite your best efforts, some shortcuts and codes just never get memorized (I’ve been trying to remember the hex for red for 7 yrs now, just never has been a priority).

I saw this awesome Photoshop keyboard shortcut desktop background and thought, “How convenient!”

Google Analytics is a powerful tool too, but the commands (Regex’s and Keyboard Shortcuts) can be hard to remember. So for the analytics ninjas (or wannabe ninjas who haven’t memorized every shortcut yet) doing heavy data crunching and report making, we thought it might be cool to have one of those for Google Analytics! We know that there are already some out there, but we wanted ours to be really “pretty” AND could be used as a desktop background (for maximum convenience). This is only for the hardcore analytics ninjas that are willing to get rid of that Hello Kitty desktop pic, picture of your spouse and kids, or “Man of Steel” desktop background.

Click here to find your screen resolution!

DOWNLOADS: Google Analytics Regex Cheat Sheet

Black and White Printable (8.5in x 11in)
1024×1024 (iPad)

DOWNLOADS: Google Analytics Keyboard Shortcuts

Black and White Printable (8.5in x 11in)
1024×1024 (iPad)

Sep 23


You are a marketing manager and your online sales have never been better. Your greedy CEO calls you into the office. “We hit our quota this quarter, but next quarter, we want to blow the numbers out of the water! I need to buy a new yacht!”

How are you going to increase online sales when the numbers are already decent? You’re going to really need to dig deep and find ways to cut the data so you can uncover hidden “gems” of insights allowing you to further optimize.

Too many times we see business owners looking at aggregates. What do we care about most in eCommerce? Dollar Dollar bills. The metrics usually measured are things like “conversion rates” and “number of transactions”. This is important obviously, but you’re potentially missing ways of slicing the data that can show you more money.

For Practical Ecommerce, I wrote an article called “5 Ecommerce Metrics You Should Be Tracking“. I thought it would be cool to make a video series based on this.

Here is the first in our 5 part series:

Here’s Google’s developer topic on segmenting by category: Tracking Code: Ecommerce.

Jun 16

advanced-segment-logic-thumbWe just passed Father’s Day! Your client’s site sells silk ties and they’re expecting big bucks this season, so they increased their PPC spend. They want do some advanced segments to see how their U.S. and Canada paid traffic did.

We just read a great piece by Jesse Nichols on advanced segment logic and thought it might be a good idea, as part of our “Back To Basics” series, to expand on that a little.

Advanced segments are essential in filtering your data so you can dive deep and get clean insights. However, you might have to blow the dust off your old symbolic logic text books, cause this stuff can be confusing. Getting the logic wrong could mess up your data analysis and reports.

Hopefully, the diagrams we made here will help you remember your “and’s” AND “or’s”. Or, I guess it would be your “and’s” OR “or’s”…(Anyway, whatever…)

Advanced Segment Logic (Non-Exclusive)

When creating Google Analytics advanced segments, you can “include” or “exclude” dimensions.

We’ll go through the following:

  • Include “this” AND Include “that” (This and That)
  • Include “this” OR “Include “that” (This or That)
  • Exclude “this” AND Exclude “that” (Not This and Not That)
  • Exclude “this” OR Exclude “that” (Not This or Not That)

For non-exclusive dimensions (dimensions that can overlap, like place and kind), the following is a visual representation of how it will work. (We’ll go through exclusive dimensions – dimensions that don’t overlap, like two different places).


Let’s break this down in terms of the potential Google Analytics dimensions we’ll be looking at.
Let’s say:

  • “This” = “U.S. traffic”
  • “That” = “Paid traffic”

Include “this” AND Include “that” (This and That). You’re looking for traffic that is U.S. and paid. You might translate “Include U.S. Traffic and Include paid traffic” into normal English, “I want U.S. traffic and paid traffic”. The latter implies you want both, which is where the confusion happens. In actuality, you are looking for where they overlap. Thus, in our diagram, you are looking for the dark grey color.

Include “this” OR “Include “that” (This or That). Translating this into English would sound like “I want U.S. or paid traffic”, which sounds exclusive – “I want either U.S. or paid traffic”, which sounds misleading. You will be pulling up “either or” as well as the overlap. If the condition hits either case (which includes if it hit’s both), it will be included. In our diagram, this corresponds to the dark and light grey.

Exclude “this” AND Exclude “that” (Not This and Not That). “Not U.S. and Not paid traffic”. A little tricky. In traditional symbolic logic, “And” means both conditions need to be satisfied. You would think then that this is an overlap. Actually, you’re not getting rid of the overlap, you’re getting rid of both cases. That means anything that is from the U.S. will be eliminated as well as all paid traffic will be eliminated . Thus everything that is grey will be gone. You will only be looking at the orange universe.

Exclude “this” OR Exclude “that” (Not This or Not That). “Not U.S. or Not paid traffic”. To me, this is the most confusing one. Again, traditionally, you’re thinking “OR”, which is both data sets. That’s not correct.

To understand this one, let’s look at “include ‘this’ or include ‘that’ “ for a second. The logic behind this implies: The data set either has to have “this” or has to have “that”.

Along the same lines, for “exclude”, if we take that italicized part of the previous sentence and insert “NOT”, you get this:
The data set has to NOT have ‘this’ or NOT have ‘that’.
Meaning, if the data set doesn’t have one of them or is missing one of them, it checks out.

Let’s go through each color area we have and compare it to that last logical sentence.

  • Does the orange NOT have “this” or not have “that”? The orange doesn’t have either, so that checks out.
  • Does the light grey ‘this’ area NOT have one dimension? It doesn’t have ‘that’, so that checks out.
  • Does the light grey ‘that’ area NOT have one dimension? It doesn’t have ‘this’, so that checks out.
  • The dark grey area isn’t missing either one, it contains both! So it doesn’t check out!

Conclusion? This advanced segment eliminates the dark grey overlap! So here, you are looking at the orange universe and the light grey. In other words, you are filtering out U.S. Paid traffic.

Advanced Segment Logic (Exclusive)

What happens when you have dimensions that are mutually exclusive? For example, U.S. traffic and Canada traffic? (Another example of sets that don’t overlap is if U.S. has no paid traffic). Things become a little different.


Include “this” AND Include “that” (This and That). It’s impossible that one visit will fall under both locations (unless you have the power to teleport or go warp speed, in which case, you’d have to also be surfing the net during that time). Thus, you’ll get nothing from this segment, as they never overlap!

Include “this” OR Include “that” (This or That). This would be either U.S. or Canada traffic. Thus, you’ll get both (light) grey colors from this segment.

Exclude “this” AND Exclude “that” (Not This and Not That). Similar to non-exclusive dimensions or sets, you’re just getting rid of both. Thus, in our diagram, you’re left with the orange universe. Anything that is not either one.

Exclude “this” OR Exclude “that” (Not This or Not That). “Not U.S. or Not Canada traffic”. If we look at the non-exclusive diagram, you are getting rid of the dark grey overlap. Since there is no dark grey overlap in this diagram, you’re not really getting rid of anything. Thus, this is a moot segment when dimensions are mutually exclusive.


To analytics ninjas, the obvious segment you would want to create to analyze “U.S. paid traffic” is “Include U.S. and Include Paid Traffic”. When filtering for mutually exclusive dimensions like U.S. and Canada, “Include” and “OR” would be the way to go. Of course, there are a bunch of different combinations that will create different logic, but hopefully, these diagrams will help remind everyone of the basics to build on.

In any case, forget the ties, and get your dad something cool, like a camera or an iPad or something…