COMMENTS
This is a tantalizing post. Can you spell out a bit about the nuts and bolts of how you generate the graphs?
For HubSpot prospects, this is awesome because it lets them dream what is possible.
But for us HubSpot USERS, it would be cool to get the nuts-and-bolts of implementation (for example, I don't think HubSpot generates these charts; some of this is automatic, versus other stuff might need to get some URL source tagging, etc.)
thanks in advance.
@Ilya Great question! I do exactly what you said. I export the referrals data from HubSpot Analytics and tag them with the appropriate channel. A simple pivot table in Excel gives me the tally of visitors, leads and customers by by channel and that is easy to graph. Takes me 15 minutes to do this.
One might think it is a tedious task. However if you do it once, keeping up is very easy.
A good portion of your referrals are the same every month. A quick VLOOKUP command in Excel against your older reports can auto-populate your channels and then you fill in the rest. If you keep a consolidated list of "tagged" referral sources you can create this reports in minutes.
The beauty of HubSpot closed loop reporting is you have visitor, lead and customer data all linked to the original "found site via" or referral source.
Hope this helps / make sense.
Cool, thanks. You might want to make available a sample set of spreadsheets that people could literally cut/paste stuff into, to show the full workflow. Sometimes a template can be really helpful to get someone started.
thanks again,
ilya
Agree with Ilya on this one Mike. Cool stuff, but a quick 'how to' for existing customers would be nice to see in a support topic/post.
Thanks.
This is really helpful. I'm a big believer in promoting my good work and good results to my "uppers," but I often can't get around the "how do you know" part with myself, so I don't give all the analytical data I have... That, and so many small businesses don't TRACK ANYTHING AT ALL, which is infuriating job for a new marketing director trying to gather data. A how-to on the graphy thing would be great...
Prashant, great stuff man.
I too am a card carrying member of @avinashkaushik's PALM (People Against Lonely Metrics).
Very similarly, I look at bounce rates across channels. Combining % of traffic generated & relative bounce rate gives a sort of Value Index by channel.
Data can be fun.
@Ilya Great suggestion on the templates. I'll see if we can get one up on Success.
@Drew @Jennifer We'll work on getting a "how to" up for both public and customers. For a sneak peek, the second comment above (my first response to @Ilya) outlines how to do it.
@Matt Thanks, Avinash Kaushik is the Wizard of Oz! I'm a champion of extending basic analytics with meta data!
"Visitors", "leads" and "customers" question: Visitors and customers are obvious.
Many times the funnel has only two steps: visitor x conversion rate % = customers (paying users).
What is your definition of the intermediary step "leads" exactly? I am assuming your funnel is visitor/CTR/CTA (so visitor/leads/customers) but I could be wrong. Also, forgive me, but what is "Success"? - I too am interested in checking out your excel template.
Many thanks...
As someone suggested what is needed is a small download of how to work with pivots on a spreadsheet.
The ideas are beautiful because of their simplicity.
One observation from the charts in this post is that direct traffic and partners have both been increasing. That tells me two important things. Continue to invest in partners. And, continue to invest in social media content marketing to create more impressions to drive direct traffic. The latter is often not well understood by CEOs as a metric attributable to inbound marketing.
@Abran - Great point. In many B2C / e-Commerce operations the measure of conversion is definitely visitors to purchasers (i.e. customers).
For most B2B companies with a slightly longer sales cycle there is going to be at least on intermediate stage around inquirers - some one who has questions about your product, pricing, filled out some offer on your site, etc.
At HubSpot we go a little more granular and of all our inquirers we only follow-up in person with qualified inquirers - what we call workable leads. And then we also look at the number of opportunities till we get to the final stage of customers.
This will vary from business to business and it is up to you how granular you want to get.
Hope this helps.
@berniebay Great point on investing in partners and social media. Partners are great sources of qualified traffic -- referrals always convert at a higher rate! And there is no better way to increase exposure to your brand and offerings than social media. It must be integrated into every part of your marketing, because it acts as a catalyst in so many ways.
Thanks for sharing!
Prashant - ok, great. That's what we are doing. The action required for a "visitor" to become a "lead" varies depending on the revenue channel. For example, it could be registering an account with us or clicking on a personalized ad (but not buying the product yet). Then, we work on converting them into purchasing customers.
Thanks a lot...