3 Helpful Apps to Visualize and Simplify Google Analytics Data

Google Analytics is an awesome platform. It’s the most advanced, flexible and the smartest website analytics software that comes for free. But it will easily take you days (if not months to figure out!)

While digging deep into the data is important, you may want to leave it to pros while enjoying the simplified regular reports using the following tools:


Whatagraph is a most indepth, yet easy-to-understand visualization of Google Analytics I have ever seen. Below are some screenshots of visualizations for you to enjoy!

To set it up, you’ll need to approve its access to your Google Analytics account and then choose the sites you want to create regular reports for. Then choose which reports you want to receive daily and weekly:

Report settings

Site Reports

General user stats: Total users as week as new vs returning users

Total users as wekk as new vs returning users

General engagement stats: Bounce rate as well as views per session

Bounce rate as well as views per session

Device stats: Browsers, mobile vs desktop

Browsers, mobile vs desktop

Sources of traffic: Channels, countries, cities

Channels, countries, cities

Page-Level Reports

Trending and descending pages (Pages with highest increase in views this day vs pages with the biggest decrease in views this day):

Trending and descending pages

Pages with the highest bounce rate and the highest exit count (Check these pages for bad user experience!)

Pages with the highest bounce rate and the highest exit count

Top 5 pages and their loading time

Top 5 pages and their loading time

Channel Reports

Channels with highest increase in traffic and channels with highest decrease in traffic

Top 5 pages and their loading time

Also included in the reports you’ll see:

  • Goal completion stats
  • In-site search stats

What a neat tool!


Sumome has other cool features, so I haven’t installed it for its Google Analytics integration, but having it there, why not enable and play?

Sumome will show you current page stats from Google Analytics as you browse your own site:

Sumome Google Analytics

On top of that, there’s a handy dashboard inside showing the most popular pages from your site (in terms of incoming traffic):

Sumome Google Analytics Dashboard

And top referrals:

Sumome Google Analytics top referrals

3. DataDeck

DataDeck is a multi-task analytics dashboard you can integrate a lot of sources into including Google Analytics. When setting it up, select your sources, and then select which data you want to see on your dashboard.

Datadeck data

Here’s a sample dashboard based on my settings above:

Datadeck dashboard

Happy playing!

The post 3 Helpful Apps to Visualize and Simplify Google Analytics Data appeared first on Internet Marketing Ninjas Blog.

from Internet Marketing Ninjas Blog http://www.internetmarketingninjas.com/blog/seo-tools/3-helpful-apps-visualize-simplify-google-analytics-data/

from Blogger http://barrymilton.blogspot.com/2016/10/3-helpful-apps-to-visualize-and.html

A Guide on How to Use XPath and Text Analysis to Pitch Content

Posted by petewailes

In my day-to-day role at Builtvisible, I build tools to break down marketing challenges and simplify tasks. One of the things we as marketers often need to do is pitch content concepts to sites. To make this easier, you want to pitch something on-topic. To do that more effectively, I decided to spend some time creating a process to help in the ideation stage.

In the spirit of sharing, I thought I’d show you how that process was created and share it with you all.

Tell me what you write

The first challenge is making sure that your content will be on-topic. The starting point, therefore, needs to be creating a title that relates to the site’s own recent content. Assuming the site has a blog or recent news area, you can use XPath to help with that.

Here we see the main Moz blog page. Lots of posts with titles. If we use Chrome and open up Web Inspector, we see the following:

We can see here the element that corresponds to a single blog post title. Right click and hover over “Copy,” and we can copy the XPath to it.

Now we’re going to need a handy little Chrome plugin called XPath Helper. Once installed, we can open it and paste our XPath into XPath Helper. That’ll highlight the title we copied the path to. In this case, that XPath looks like this:


This only selects one title, though. Fortunately, we can modify this to pick up all the titles. That XPath looks like this:


By removing the nth selectors (where it says [1]), we can make it select all instances of links in h2 headings in headers in articles. This will create a list of all the titles we need in the results box of XPath helper. Doing that, I got the following…

Recent Moz post titles

  • Digital Strategy Basics: The What, the Why, & the How
  • Should My Landing Page Be SEO-Focused, Conversion-Focused, or Both? – Whiteboard Friday
  • A Different Kind of SEO: 5 Big Challenges One Niche Faces in Google
  • Google’s Rolling Out AMP to the Main SERPs – Are You Prepared?
  • Diagramming the Story of a 1-Star Review
  • Moz Content Gets More Robust with the Addition of Topic Trends
  • Wake Up, SEOs – the NEW New Google is Here
  • 301 Redirects Rules Change: What You Need to Know for SEO
  • Should SEOs and Marketers Continue to Track and Report on Keyword Rankings? – Whiteboard Friday
  • Case Study: How We Created Controversial Content That Earned Hundreds of Links
  • Ranking #0: SEO for Answers
  • The Future of e-Commerce: What if Users Could Skip Your Site?
  • Does Voice Search and/or Conversational Search Change SEO Tactics or Strategy? – Whiteboard Friday
  • Architecting a Unicorn: SEO & IA at Envato (A Podcast by True North)

Doing this for a few pages gave me a handy list of titles. This can then be plugged into a text analysis tool like this one, which lets us see what the posts are about. This is especially useful when we may have lists of hundreds of titles.

Having done this, I got a table of phrases from which I could determine what Moz likes to feature. For example:

Top Two-Word Phrases Occurrences
how to 13
guide to 6
accessibility seo 4
local seo 3
for accessibility 3
in 2016 2
online marketing 2
how google 2
you need 2
future of 2
conversion rates 2
the future 2
seo for 2
long tail 2
301 redirects 2

Assuming that Moz is writing about things people care about, we can look at this and make a few educated guesses. “How,” “guide,” and “you need” sound like phrases around educating how to do specific tasks. “Future of” and “the future” indicates people might be looking for ways to stay ahead of the curve. And, of course, “SEO” turns up with various modifiers. A blog post that might resonate with the Moz crowd, then, would be something focused on unpacking a tactic, focused on delivering results, that not many people are yet using.

Who’s writing what?

So we’ve decided we’re going to write a guide about something to do with SEO, focused on enabling SEOs to better address a task. Where do we go from here?

In the course of creating ideas for what became this post (and a few other posts), I started to turn to other sites that I knew the community hung around on, and used the same trick with XPath and content analysis on those areas. (For the sake of completeness, I looked at Inbound, HackerNews, Lobsters, and Twitter.) Things that came up repeatedly included content marketing, {insert type here} content, and phrases around the idea of effective/creative/innovative methods to {insert thing here}.

With this in mind, I had a sit and a think about what I do when I want to pitch something, and how I’ve optimized that process over the years for speed and efficacy. It fit into the types of content Moz seems to like, and what the community at large is talking about at the moment, with a twist that is reasonably unique.

The same data gives a list of people who are interested in and writing about similar stories. This makes it easy to create a list of people to reach out to with regards to research, who you can get to contibute, and who’ll be happy to promote it when it’s live. Needless to say, in a world where content is anything but scarce, that network of people shouting about what you’ve created is going to help you get word out and make the community take more notice of it.

Taking this further

For the moment, and because I’m a developer first, I don’t have much problem with the slightly technical and convoluted nature of this. However, as SEOs, you might want to swap out some of the tools. You could, for example, use Screaming Frog to compile the titles, and people might want to use their own text analysis tools to break down phrases, remove stop words, and other useful things.

If you’ve got any similar processes or any ideas of how you would extend this, I’d love to hear about it in the comments!

Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don’t have time to hunt down but want to read!

from The Moz Blog http://tracking.feedpress.it/link/9375/4687409 petewailes

from Blogger http://barrymilton.blogspot.com/2016/10/a-guide-on-how-to-use-xpath-and-text.html

Weekend Favs October 22

Weekend Favs October 22 written by John Jantsch read more at Duct Tape Marketing

My weekend blog post routine includes posting links to a handful of tools or great content I ran across during the week.

I don’t go into depth about the finds, but encourage you to check them out if they sound interesting. The photo in the post is a favorite for the week from an online source or one that I took out there on the road.


Drift – Messaging app for sales and customer success. Turn leads into customers faster by focusing on the people who are live on your website.

Sleeknote – Set up lead capture forms on your website in minutes and sync your new email leads with your favorite email service provider – no coding required.

FotoJet – An all-in-one free online tool for photo editing, graphic design and photo collages.

from Blog – Duct Tape Marketing https://www.ducttapemarketing.com/blog/drift-sleeknote-fotojet/

from Blogger http://barrymilton.blogspot.com/2016/10/weekend-favs-october-22.html

Mobile Optimization Is Even More Essential: Weekly Forum Update

seochat-wmw-cre8asite-threadwatch-roundup-768x576You thought Google was done with mobile and had moved on? No way!

This week, our communities are all talking about some news that came out of Pubcon: a mobile index is coming and it’s going to be Google’s primary index going forward.

So if you were willing to take a few hits on the chin and ignore mobile optimization, you could see yourself in a whole heap of trouble in the future. How soon will the mobile index be here? What will the consequences be?

Check out some of our discussion threads below to learn more!

Mobile or Die

Cre8asiteforums members are talking about the future and mobile optimization in this thread. As Kim says, it was one of the most popular and compelling themes to come out of Pubcon this year.

“The future was a theme in various ways…to my surprise [it included] an emphasis on smarter development and marketing tactics related to user experience, targeting users’ needs and a clear overlap between SEO and UX, the likes of which I’ve never seen before.”

Sounds like the SEO world is swinging hard towards user experience. That’s probably just where Google wants it to go. Forums member iamlost writes that it’s a bit of a late realization, though.

“This is October 2016. I started seriously thinking and hypothesizing and testing ‘for mobile’ from Wednesday, March 19, 2008. That was the day that Reuters published ‘Google sees surge in Web use on mobile phones.’”

Late or not, give this thread a read to catch up on the news.

Google Has a New AMP Testing Tool

Just before Mobilegeddon rolled out, Google put up a mobile friendly testing tool. Now they have a similar tool for AMP pages. If you put in your exact AMP page URL, the tool will tell you if the page is working properly. AMP pages seem to be a key part of Google’s vision for the future of the web.

But they aren’t yet well understood or trusted by webmasters. As iamlost wrote in the previous Cre8asiteforums thread, there’s a lot of talk about how to take advantage of these new tools…but not much talk about whether we even should.

WebmasterWorld’s Brett Tabke Wins Lifetime Achievement Award

Raise a glass and give a hearty congratulations to WebmasterWorld’s founder, Brett Tabke! Tabke is also Pubcon’s CEO, and has been working in the computer industry for three plus decades. As WebmasterWorld’s admin, engine, writes Tabke

“founded a specialty software business producing a line of software for Commodore computers in the ’80s and ’90s.”

He’s the author of several early and authoritative books about website design and microprocessor programming, too. We know him as a long-time ace networker and community builder! He coined some popular SEO terms like “link farm,” “SEO themes,” and even “SERP”! As WebmasterWorld user not2easy writes, “A well deserved award there.” Congratulations, Mr. Tabke!

Separate Mobile Index Coming Within “Months,” To Be Treated as Primary Google Index

According to Gary Illyes, who spoke at Pubcon, Google’s mobile index is just months away. Threadwatch writer Adam W says that

“This sounds like it will match up close to the date when intrusive interstitials are devalued in mobile results.”

As it currently stands, Google uses the desktop index to determine mobile rankings… but soon, the mobile index will replace the desktop index as top dog.

We aren’t sure what the full consequences of this change will be. Will pages that aren’t mobile friendly be pushed out of mobile rankings completely? Will content take a back seat to design?

New and Less Common Technologies: What Are We Missing?

All this talk about the cutting edge and mobile design has stirred the hearts and souls of WebmasterWorld users. Forum member graeme_p has started this thread to talk about the new and less common technologies that people need to know about.

“I mean anything that is not often talked about. Programming languages, databases, frameworks, web servers…whatever.”

What follows is my favorite type of thread – the one where our scientists and experimenters share the fruits of their labor! You can find tips and thoughts about all kinds of new tech in this thread, like Haskell, Cherrypy, Hiawatha web servers, Elasticsearch, Soir, MongoDB…and more! Give it a read!

How to Fix a Bad Bounce Rate

SEO Chat member deadpebbley has the same problem that many of you might have as well. On a client’s site, a massive number of visitors are coming from spammy websites and bouncing immediately.

Whether they’re bots or people who have somehow gotten lost in a spam-hole, they’re really skewing deadpebbley’s bounce rate.

Since this traffic is useless and worth ignoring, a simple solution is to filter it out of your metrics. How do you do that? Well, read on and find out!

The post Mobile Optimization Is Even More Essential: Weekly Forum Update appeared first on Internet Marketing Ninjas Blog.

from Internet Marketing Ninjas Blog http://www.internetmarketingninjas.com/blog/sem-industry/mobile-optimization-is-even-more-essential-weekly-forum-update/

from Blogger http://barrymilton.blogspot.com/2016/10/mobile-optimization-is-even-more.html

From RepPilot.com/info: Small Business Trends Presents: 10 Facebook Business Page Tips that Will Keep You From Screwing Up Your Marketing Efforts

from Small Business Trends http://www.youtube.com/watch?v=R9Hn34zmhdw

The post Small Business Trends Presents: 10 Facebook Business Page Tips that Will Keep You From Screwing Up Your Marketing Efforts appeared first on RepPilot.

from RepPilot http://reppilot.com/info/small-business-trends-presents-10-facebook-business-page-tips-that-will-keep-you-from-screwing-up-your-marketing-efforts/

from Blogger http://barrymilton.blogspot.com/2016/10/from-reppilotcominfo-small-business_21.html

How to Calculate the ROI of Offline Transactions

In a way, e-commerce sites have it easier than offline companies who need to get a sales person involved in each deal. When it comes to measuring your AdWords ROI, it’s waaaay easier to measure performance when you have an e-commerce transaction with a specific value at the end of the chain.

An online store can easily set up e-commerce tracking through Google Analytics to see which ads lead to the highest sales, but when you involve a salesperson offline, you lose all of the keyword and ad data, right?

Think again!

The problem with measuring offline transactions

Picture this – you’re a company that sells electric fences. People who buy electric fences know they need electric fences, but they don’t know what type, size, etc. they need. That’s where the product specialist (aka salesperson) comes in. After they fill out a form online, the salesperson calls them, asks questions about their project, recommends a solution and makes the sale.

Looking at this scenario initially, it sounds difficult to determine which ad campaigns deliver the best leads (the ones that are most likely to turn into the highest-value offline sales). But let’s give it a try and see what we can do!

In the electric fence example, your sales funnel would look something like this:

Offline ROI Calculation

We can measure which ad campaigns lead to form completions (conversions), but how do we know which ones lead to actual sales?

You Need Marketing Automation or a CRM that Tracks AdWords Data!

Marketing automation delivers personalized communications to prospects based on their interactions with your website, emails and ads. Some features of marketing automation include: dynamic website content, segmented email communications (drip email campaigns), visitor tracking, landing page creation, A/B testing, workflow automations, call tracking and analytics.

CRMs (customer relationship management systems) can be part of marketing automation systems or sold as software on their own.

They come in all shapes and sizes. A quick Google search of “marketing automation” or “crm” will yield a plethora of results.

Almost every marketing automation system out there tracks visitors and leads from their first interaction with your website all the way through to the moment they become a customer, which is key to what we want to do here.

What we’re trying to do requires a system that integrates with AdWords and links ad cost data with specific leads, as well as provides aggregate summaries of ad ROI.

How Marketing Automation Helps You Measure Offline ROI

Here’s how it works: When someone visits your site from an AdWords ad, marketing automation captures the ad data and associates it with the visitor. When the visitor becomes a lead (by filling out a contact form), marketing automation puts a name to the anonymous data.

When your salesperson finally closes that lead – whether it be tomorrow or a month after the day they first clicked on your ad – they enter the sale information (volume, price, etc.) in your CRM or marketing automation system. The system attributes the sale to the exact ad and cost-per-click that brought the customer to your site.

Not using marketing automation yet? A few popular marketing automation systems that have AdWords integrations include Marketo and SharpSpring. Check them out to see if they work for you.

What kind of insights can I get if I set this all up?

Ultimately, you’re taking traditional ad campaign performance metrics and adding sales volume and cost to the end, so this…

offline transation

Becomes this:

offline transation with customers

Knowing which lead came from which ad campaign is useful already, but when it’s aggregated you’re able to get a big picture view of ad campaign ROI. You can answer questions like:

  • Which ad campaigns get people to JUST visit my website vs. which ad campaigns are most likely to get people to visit my website AND become paying customers?
  • Which ad campaigns drive visitors who are most likely to turn into high-paying customers vs. being low-paying customers?

Here’s an example of a report from a popular marketing automation system, showing ad-level ROI:

ad level roi

How to calculate ad campaign ROI

To get the ad campaign’s ROI, use this equation:

formula calcuate roi

Example: Campaign A cost $500 and resulted in $10,000 in new sales, and Campaign B cost $1,000 and resulted in $2,000 in new sales.

Campaign A ROI = ($10,000 – $500) / $500

                         = 19

                         = 1,900%

Campaign B ROI = ($2,000 – $1,000) / $1,000

                         = 1

                         = 100%

This tells us that Campaign A results in way more dollar-value sales than Campaign B and delivers a much higher AdWords ROI. With this information, you could do any of the following:

  • Double down on Campaign A
  • Work to further optimize Campaign B so it performs better

Isn’t that better?

Too often ad agencies and marketers focus on impressions and clicks. But at the end of the day, a company’s ad spend better be generating business (real dollars) otherwise it’s going to end up on the chopping block. Although it’s easy to measure ad campaign ROI with online transactions, it’s a challenge when transactions occur offline with a salesperson.

Marketing automation isn’t for everyone, but it does bring the value of tracking these on and offline activities all in one place so you can get clear insights into campaign performance. When you know which campaigns are driving actual business and which ones aren’t you can double down on the ones that work and cut out the underperformers.

If you’re not currently using a marketing automation system, I’d encourage you to check out what’s out there, and if you are using marketing automation, start using the AdWords integration if it’s available for your platform!

Happy advertising!

About the author

John Rau is a Campaign Specialist at Accel Web Marketing, a WordStream client that helps companies set up marketing automation systems and run online advertising campaigns.

from Wordstream Blog Feed http://www.wordstream.com/blog/ws/2016/10/21/calculate-roi-offline-transactions

from Blogger http://barrymilton.blogspot.com/2016/10/how-to-calculate-roi-of-offline.html

How Gamification of Business Process Yields Successful Results

How Gamification of Business Process Yields Successful Results written by Guest Post read more at Duct Tape Marketing

How Gamification of Business Process Yields Successful Results - Duct Tape MarketingSimulating business processes in the gaming scenario is an interesting way to keep yourself intrigued in the business. Better if you were once a gaming freak in your early days of life. No matter if you are an employee, CEO, or even a stakeholder. You need to get aware of the buzz around Gamification. It simplifies your task to comprehend and analyze the business process to undertake resourceful activities.

Gamification is a trending tool to grow skills, behavioral design patterns, and solve problems that facilitate innovation. Gamification is the process of deploying gaming techniques designs to the business framework. The aim is to engage efficiently and motivate the ones who works for the common goal of the organization.

The noticeable advantage of Gamification is that it makes learning more exciting by incorporating visual gaming elements and keeping it more practical. The idea is to convert the business activities into games in an assertive manner.

Often, technology is integrated into the Gamification process that leads to innovation in the process along with the personnel growth, employee performance management, and escalation of a learning curve.

According to numerous industrial experts, gamification brings a positive change in the way people evolve within the organization. It is because there is much more to gamification than just badges and points. If deployed strategically, it might turn out to be the most popular mechanism to alter business operations in all the departments.

According to Brian Burke, it is an entirely different model altogether, and it might be possible that a lot of stakeholders in Information Technology organizations are unaware of gamification.

Undoubtedly, effective implementation of gamification technique can lead to a significant increment in business revenue as well. The entire process involves employees, customers, and any other group of interest who interacts with the business on a frequent basis. Few examples of companies or organizations that have managed to apply gamification effectively are Nike and Khan Academy. Nike utilized the concept of gamification to enhance the engagement level of fitness maniacs to take their workout session to a higher standard. On the other hand, Khan Academy does it to improve the students’ learning experience.

Since gamification is one of the new age practices that companies have their eye on, the initial phase of this rise has been followed by various misconceptions regarding its implementation. One commonly heard myth about gamification is that it is only for the young learners or perhaps, it should look like a game.

But in reality, the organization is expected to pay attention to their gamification design as even a bit of error can prove hazardous. Here are few of the steps that you can follow to figure out the appropriate gaming application for your business.

  1. It is important to define the target players to get them actively involved in the gamification process. It can be anyone; specific departmental staff, certain distinctive employees, managers, or even customers.
  • In the case of engaging employees in the process, the prior objective should be to maximize the return on investment (ROI). The ideal way is to determine the areas you intend to improve.
  • Designing Gamification process for customers requires you to retrospect the online engagement model as well the offline methods. In the case of B2B business, the ideal way is to come up with a robust symbiotic gamification model for business progression.
  1. It possible to simply gamification in multiple areas like health and wellness, sales performance, training, and retention.
  • In the case of health and wellness, the organization must come to a customized solution. In the event of health and wellness gamification, you can opt for a successful platform like Keas.
  • For gamification of the sales process and gauging its performance, the decision regarding the integration with the CRM software must be taken. If work process permits then it is best to go ahead with the Fantasy Sales platform for else Play Vox is always the best bet.
  • The training and retention area requires management to determine whether a deficit of learning management system. If there is, then is Badgeville offers a suitable platform. While in another case where the Learning Management System is already implemented, Wheeldo can work wonders.
  1. While targeting gamification method for customers to increase online engagement, you should determine whether it is for new clients or customer retention. In either case, you have the option.
  • While aiming to attract new customers, you can opt for any intuitive platform, or else, Gigya serves the purpose for customer retention. However, if your target is not limited to the enhancement of online engagement, then you should determine whether you would like to get regular customers back into your retail stores.
  • In case you are looking for restaurant management solution by gamification of the restaurant process then you should go for Belly. In case you run a retail store, then you should go for Perkville.

How Gamification of Business Process Yields Successful Results - Duct Tape Marketing

Shahid MansuriShahid Mansuri co-founded Peerbits, one of the leading mobile app development companies, in 2011. His visionary leadership and flamboyant management style have yield fruitful results for the company. He believes in sharing his strong knowledge base with a learned concentration on entrepreneurship and business. Being an avid nature lover, he likes to flaunt his pajamas on the beach during the vacations.

from Blog – Duct Tape Marketing https://www.ducttapemarketing.com/blog/gamification-of-business-process/

from Blogger http://barrymilton.blogspot.com/2016/10/how-gamification-of-business-process.html