INBOX INSIGHTS: User Stories and Requirements Gathering, Direct Traffic (11/2)
Trust Insights
We are a marketing analytics consulting firm. We help you solve marketing's data and analytics problems.
November One Click Poll!
Please click/tap on just one answer - this is our monthly survey to see how we’re doing, so please do take it each month!
How likely are you to recommend Trust Insights as a consulting firm to someone in the next 90 days?
We use this information to measure how effective our marketing is. There’s no form to fill out - tapping your answer is literally all there is to it, and then you get to see Katie’s dog.
Creating User Stories to Gather Requirements
You don’t need yet one more opinion on what’s happening on Twitter, right? I didn’t think so. In that case, I’m going to talk about how we are creating user stories to gather our own requirements.
I’ve been struggling to get a handle on my sales data. We have a CRM but because we’re a small business I cannot afford the tier that would allow me to do any kind of custom reporting. Our CRM allows for basic functionality at the moment, such as collecting prospect data and tracking deals. I’ve been scratching my head, trying to figure out a solution to this. These are some of the options I considered.
Do I switch CRMs? That’s a pain in the butt for a couple of reasons. First, I would need to evaluate my needs and write up my requirements. Next, I would need to evaluate the different CRM options. This might mean talking to other salespeople, sitting through demos, and all that good stuff that I can’t focus on right now. Last, I would need to create a migration plan for all my data and an official rollout for the new processes for data collection on the new platform. Ok, so that’s not an ideal solution.
Maybe I can download the data and merge the different tables using Excel? I would need to first make sure that all the different tables in the CRM are connected with some kind of ID. Then I would need to develop a process for downloading the data, cleaning it, and then merging it. Then I need to create a static report and make some decisions. Another not ideal solution since this one would be time-consuming and error-prone.
After talking to Chris, we determined that he could extract data from the CRM’s API, bring it into Big Query, and build reports in Looker Studio (formerly Google Data Studio). Automated data extraction and reports? That could work. First, I would need to figure out what I need before Chris starts extracting the hundreds of data points.
How did we proceed, you ask? If you guessed user stories, you get the gold star for today!
Chris and I hopped on a video call last Friday and talked through about 25 different user stories. Why so many? Because I had different questions that I wanted to answer. Going through this exercise did a couple of things. We were able to narrow down the data points that we needed to extract from the CRM. We were able to focus the purpose of each of the reports we would build. We were able to determine which tables we needed data from. We were able to see where there was an overlap between user stories.
Fun fact, a single user story hits all the 5Ps.
As a [persona], I [want to], so [that].
If done correctly and thoughtfully, a single user story can tell you just about everything you need to know to move a project forward.
Here is an example of some of my user stories for building reports with our sales data:
The user stories are not overcomplicated and the goal is that each one was a single purpose.
What’s next? Chris will write code to extract the necessary data points into Big Query. Once we extract the data on a regular basis using automation, we can build the reports in Looker Studio. I’ve requested that each user story is on its own page in a book of reports, listed at the top so that it’s crystal clear what question is being answered. In my view, it’s ok if there are redundant tables of data. Each user story is its own question and when I am looking for the answer to that question, I can easily find it. Honestly, I can’t wait to start using the data to make decisions.
Are you using user stories to gather your requirements?
- Katie Robbert, CEO
SHARE WITH A COLLEAGUE
Do you have a colleague or friend who needs this newsletter? Send them this link to help them get their own copy:
In this week’s episode, Katie and Chris tackle news media’s usage of data. Is what you read believable? How would you go about proving it? We examine some recent claims in Bloomberg and Business Insider about racial slurs on Twitter and the process for verifying that claim, extending it to the role data-savvy organizations should play in ESG and social good. Tune in to learn more!
BINGE WATCH & LISTEN
Last week on So What? The Marketing Analytics and Insights Live show, we looked at the importance of YouTube handles.?Catch the replay here ?
This Thursday at 1 PM Eastern, we’ll be talking about the newly-announced YouTube handles.?Are you following our YouTube channel? If not, click/tap here to follow us!
Need a reminder? Click here for a calendar appointment:
#ICYMI IN CASE YOU MISSED IT
Here’s some of our content from recent days that you might have missed. If you read something and enjoy it, please share it with a friend or colleague!
PAID COURSES
Take your skills to the next level with our premium courses.
FREE CLASSES
Get skilled up with an assortment of our free, on-demand classes.
领英推荐
DATA DIARIES
In this week’s Data Diaries, let’s tackle something very interesting - the rise of direct traffic. One of the privileges of having clients in many different industries and sizes is that we can look at trends across websites to see if something is affecting just one site or if there’s something bigger at play.
As we were putting together client reporting this month, we noticed something unusual: the amount of direct traffic (meaning traffic that lacks attribution data) seemed to be on the rise.
We were unsure whether this was the case or not, so how would we determine it? We could start by looking at sites’ ingestion of direct traffic:
While an easy answer, it’s not a correct one; direct traffic is inherently part of the website as a whole, so if a site lost traffic during the study period, direct traffic would go down as well. What we need is an understanding of the percentage of direct traffic as a whole for the site.
So, let’s take a look at these same sites, but aggregated and anonymized. What do we see as a percentage of direct traffic?
What we see over the last 4 months is a significant increase in the amount of direct traffic as a percentage of the sites’ total traffic. This is meaningful because even if a site lost traffic during the study period, direct traffic as a percentage of the whole increased.
For marketers, this is bad news. Direct traffic is traffic that has no attribution. We don’t know where it came from, and it could come from a variety of places - misconfigured ads, emails missing tracking codes, people just typing URLs into browser - the possibilities are limitless.
What should we do about it? The rise of direct traffic overall among this selection of sites from different industries seems to indicate it’s not limited to one vertical or type of customer. It might be a change in browsing behavior or device privacy settings.
What we should do as marketers is redouble our efforts to vigorously use tracking parameters so that we know where people are clicking from. These are UTM tracking codes for Google Analytics, and cid codes for Adobe Analytics. Never let a URL go out in a piece of marketing content (emails, social, ads, etc.) without tracking codes appended - and if you need to make it look nice, use a link shortener to not only tidy its appearance, but preserve your tracking codes.
We will never get rid of direct traffic entirely, but there’s no reason it should ever be more than a small portion of our site’s traffic if we’re vigilant about analytics operations and governance.
TRUST INSIGHTS IN ACTION
JOB OPENINGS
Here’s a roundup of who’s hiring, based on positions shared in the Analytics for Marketers Slack group and other communities.
JOIN THE CLUB
Are you a member of our free Slack group, Analytics for Marketers? Join 2800+ like-minded marketers who care about data and measuring their success.?Membership is free - join today. Members also receive sneak peeks of upcoming data, credible third-party studies we find and like, and much more.?Join today!
BLATANT ADVERTISEMENT
We heard you loud and clear. On Slack, in surveys, at events, you’ve said you want one thing more than anything else:?Google Analytics 4 training.
We heard you, and we’ve got you covered. The new?Trust Insights Google Analytics 4 For Marketers Course?is the comprehensive training solution that will get you up to speed thoroughly in Google Analytics 4.
What makes this different than other training courses?
With more than 5 hours of content across 17 lessons, plus templates, spreadsheets, transcripts, and certificates of completion, you’ll master Google Analytics 4 in ways no other course can teach you.
UPCOMING EVENTS
Where can you find Trust Insights face-to-face?
STAY IN TOUCH
First and most obvious - if you want to talk to us about something specific, especially something we can help with,?hit up our contact form.
Where do you spend your time online? Chances are, we’re there too, and would enjoy sharing with you. Here’s where we are - see you there?
FEATURED PARTNERS
Our Featured Partners are companies we work with and promote because we love their stuff. If you’ve ever wondered how we do what we do behind the scenes, chances are we use the tools and skills of one of our partners to do it.
DISCLOSURES AND LEGAL
Read our?disclosures statement?for more details, but we’re also compensated by our partners if you buy something through us.
Some events and partners have purchased sponsorships in this newsletter and as a result, Trust Insights receives financial compensation for promoting them.?Read our full disclosures statement on our website.
CONCLUSION AND THANKS
Thanks for subscribing and supporting us.?Let us know if you want to see something different or have any feedback for us!