We help you to use your digital potential. For a strong positioning, more visibility and more leads.
Targeted customer acquisition for more sales. Identify, target and close the right leads.
With the BEE.Transformance model, we bring continuous and profitable growth to your company. A new mindset for your team.
We transform your challenges into opportunities through the experience we have gained from projects in these industries.
As a HubSpot Diamond Partner, we help you implement your digital growth strategy with a focus on performance - by implementing and integrating new and existing systems as well as 3rd party apps.
As a HubSpot Diamond Partner with +50 certifications, host of the HubSpot User Group Zurich, HubSpot Trainer and HuSpot User Champions, you have access to in-depth HubSpot expertise.
The BEE.Theme offers you more creative freedom than any other theme on the market. Whether you're a beginner or a professional, a creative mind or a digital agency - with the BEE theme, you can easily unleash the maximum power for your pages in HubSpot CMS.
Knowledge around digital marketing, digital sales, technology, data intelligence and employees.
Pure knowledge: everything essential concentrated, compact, digitally prepared for you and ready to download.
The most effective way to successfully combine digital marketing and digital sales.
The BEE.Performers: many different characters - with one thing in common: the fascination for a digital world.
More than 100 large and small companies have already started with BEE: to more visibility, more performance, more growth.
Participate in the growth of BEE and become part of the BEE Growth Story by purchasing Digital Share Tokens.
Have you ever been in a meeting where all the reports show you outstanding numbers and only green lights? You wonder how that could be possible when your experience on the frontline of the business reflects a different reality. There are two potential answers:
It is my hope that you work with honest people who apply best practices when processing and presenting data. In most cases, however, it’s the latter issue that is most likely to be causing the discord, and that’s the one I’m going to address. In this blog, I’d like to present you with a few tips on how to set up a proper database for your organisation––in particular, if you use multiple sources for your reporting.
Start small; there's no need to change the world in a single day. Compare the data shown in the report with your experience, it’s likely that your colleagues had the same reservations about the results, and you’re all probably right! Ask yourself the following questions to start a troubleshoot:
It might sound silly, but if your data uses figures from a different desired data range, the report won’t be realistic. Ensure that your database administrator gave you the latest information or the relevant data set you need for your report. It's also your responsibility to ask for the exact data set you need. Check in with the administrator to verify how frequently the data is refreshed.
Imagine that you have two systems, A and B. System A sends raw data to System B only once a week. You rely on your System B for that set of data and do your reporting on Wednesday. However, the interface (the connector between System A and System B) operates only on Thursday. This means you will always be one week late with your reporting.
If your data is all coming from a single source, you might skip this part. However, if you collect data from multiple sources you need to ensure that your data is consistent and accurate. In my experience, multiple sources of data often corrupt your report organically if you try to measure KPIs which are actually shared between systems. What does that mean?
Here is an example:
You are collecting data from Facebook Business Manager (the Facebook Advertising Tool) to measure cost performance and you also use Google Analytics to compare conversion performance; you might have discrepancies. Why? Facebook and Google have different attribution models. Facebook and Google don’t align in their methodology of calculating conversions. As a result, you will have discrepancies in your report if you simply combine data from two different sources sharing common metrics.
How did you or your system administrator set up the attributes in your database? Do they fit your business requirements? What I mean by that is easier to explain with a real-life situation. Let's pick the example of a CRM system where you collect information about your clients such as occupation, age, and type of subscriptions they have with your company (imagine a SaaS environment) or products that your company sells. Let's do a small exercise here and try to picture how these three customers’ attributes need to be configured in your organisation. [My recommendations can be found at the bottom of the article]
Which fields are required? If data is collected from multiple sources for the same field, do you ensure the consistency of your data? If a report contains empty fields, you might revise if this is actually what you expected. This might also be the expected behaviour as empty values also have a significance.
There are numerous types of fields which I will not explain in an exhaustive manner but only mention the most frequent ones:
The way you structure your data will massively influence how it is connected between these fields and the ultimate outcomes of your report. Think about your business needs to structure the data. I've seen companies collecting a customer's occupation attribute with a text field. This can result in you having 10'000 different values in your database with plenty of errors. Other companies collect data for this field with a dropdown menu (pre-selected values that you can choose from – only one choice is applicable), ending up with the majority of their clients being "occupation = other".
This is a rather technical part which you may not be familiar with, but it's important to understand the mechanisms. How data are created might depend on the methods of your interface (or the connector between System A and System B). I will simply mention here two basic functionalities:
Thank you for reading! The second part (a bit more technical and specific) will be published in a few weeks, as I thought it would be too long, in particular for an introduction to data troubleshooting. If you're interested to work on a project with us, just click here:
Please find below my recommendations for the exercise about the setup of 3 attributes for your organisation.
How is this information relevant for your organisation? Keep in mind that some people might have two occupations! People also change jobs –– how do you keep that information up to date? Do you have any client portals so they can amend this information or do you collect only when they first register? Is this field also required in your organisation?
Do you want to collect the age of your customers or rather their birth date? As the famous motto states "age is just a number", but it's also a dynamic value which evolves from the date of birth. So you might want to create a date field to collect the customer birthdate and ask your system administrator/data scientist to create a formula field/calculated field to return the correct value into age (basically today's date - date of birth).
Most probably you already know your products/services so you don't want to leave this field open for the client but rather create a dropdown. The concern here is to understand the way your products/services are connected to your client. Can they subscribe to multiple services at the same time? If your client can have only one option, you might set up a dropdown field for this attribute; however, if a customer can have multiple services at the same time, you should opt for a multi-select dropdown field.
Lanny Heiz | 10 Jun 2021
In the words of John Lennon, "Life is what happens while you're busy making other plans." And boy, oh boy, did 2020 shake up all of our plans.
reading time: 5min
Romy Fuchs | 23 Feb 2023
We have some bad news: your email marketing contact database unfortunately decreases over time. Your contacts' email addresses change as they move from one company to ...
reading time: 7min
Lanny Heiz | 6 Jan 2022
Some businesses quickly see the value in content marketing and start producing content without hesitation; they hire in-house teams or outsource specialists and crack on ...
reading time: 9min
Transform to perform
For mid-market and corporates in the DACH Region that want to transform their business in order to grow locally and globally, BEE is the highest-ranked digital growth solution partner that combines strategy, execution, data intelligence and people in a transformance model.
What BEE stands for