Erich Staffer

  • Social Media Dashboards

    Are you still using a spreadsheet to collect your social media data? Me too. Here is how I’m trying to automate marketing analytics. Every morning I manually calculate metrics like the number of Shopify orders, the number of Facebook likes, and the number of Twitter followers (to name a few). I started to wonder, “How…

  • Job Interview – A Review

    It started out with a verbal technical questionnaire about how I’d merge two data sets. They were mostly Access questions and I didn’t do too hot on these. They use Access to update customer lists using the ‘join’ functions (apparently). Next, I was sat in front of a computer with sample data and asked to…

  • How to Find Your Top Keywords in the New Google Analytics

    If you’re like me, you had trouble originally finding where the top keywords were in the new Google Analytics dashboard. It used to be under Traffic Sources > Keywords, but now it’s under Traffic Sources > Sources > Search > Organic. Google Analytics Organic Search Keywords report shows Site Usage with Keyword, Visits, Pages/Visit, Average…

  • Monthly Website Reports

    Here’s an example of what our customers get from us each month in their Monthly Website Report: Good afternoon. I hope your summer is going well. Attached is your monthly Google Analytics report and a special message below. A Special Message Have you ever thought of an app for your phone that you thought could…

  • Can You Skip the ‘As-Is’ Process Analysis Altogether?

    In a process improvement project is it best not to spend too much time on detailing an ‘as-is’ process analysis and focus on the ‘to-be’ process instead? One of the arguments against detailing an as-is process analysis is that it precisely hinders the involvement of the people as they may be afraid to be evaluated.…

  • How to Find a Niche (and What to Do with it Once You Find It)

    Profit can be made from almost any niche – the key is knowing how to find it This is a simplified method for how to find a niche. Essentially we begin with the end in mind, knowing we’re going to need a product to sell that is currently being sold, but maybe not as well…