Skip to main content

Posts

Excel in my day by day routine

I would like to say that the best program I've ever used for analyzing my data is excel. Since the late 90's Excel was there for me and is still here today. I'm not saying I didn't try other programs like R Studio , Power Bi and  Tableau  but excel is still helping me on my day by day routine. The list below will give you my top functions and use cases with Excel. 1. VLOOKUP This function is by far my favorite one. The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. Syntax VLOOKUP( value, table, index_number, [approximate_match] ) 2. CONCATENATE  The word concatenate is just another way of saying "to combine" or "to join together". The CONCATENATE function allows you to combine text from different cells into one cell. In our example, we can use it to combine the text in column A and column B to create a co
Recent posts

The innovators and the early adopters, can you spot them?

Before I start this post. I would like to thank TED talks for helping me enrich my world of marketing and more. One of the best talks I ever heard was made by  Simon Sinek  and was about how great leaders inspire action. In this post I would like to emphasis the change in my approach towards contacting customers and in which way to do it. Simon presented the following diagram: We need to talk to our customers from the inside to the outside. Conveying why we do things, how we do it and at last the what we do. As Simon said, people follow the why you do it and not the what you do.  Then he spoke about the innovators and the late adapters using the following diagram: Where he brakes down your customers into groups, where the innovators pass your story along with the early adopters.  The 80/20 rule also can be adjusted according to this diagram: 1. The Innovators - 2.5% - your top VIPs 2. Early Adopters - 13.5% - 2nd level VIPs 3. Early Majority - 4

Content Writer Template

When it comes to writing content you need to explain to your writers what you want from them. During these years I've developed a template that helped me convey my message to my writers in the best way. You can download the template here . Let's go over the sections in this template. 1. Intro section The general information about the promotion. Who you are targeting, when do you need it and so on 2. Promotion flow In this section I like to show my writers the big picture. It's important in my opinion to show them what is going on in all aspects of the promotion. When are things going out, why, where and more. The more specific you are the better content you will receive from them. 3. Promotion explanation This is where you specify the what. What is going on in the promotion. How does it work, the structure of it. Who can claim it and what happens when he claims it.  4. Terms and conditions Specify the terms and condition for the promotion. It&

Building your emails, how to do it right!

When writing an email to promote a discount, update terms and conditions, or announce an important message you should follow some key points. I have two: 1. Tech side (SPF, DKIM, DMARC) 2. The HTML/Text part or content part . The tech side: In the world today when the war on spam is becoming more and more sophisticated  its important to understand some configuration you need to do in order to authenticate your sender and make sure your clients receive your emails.  1. SPF Sender Policy Framework (SPF) is a simple email-validation system designed to detect email spoofing by providing a mechanism to allow receiving mail exchangers to check that incoming mail from a domain comes from a host authorized by that domain's administrators. You can read more on Wikipedia here .  2. DKIM Domain Keys Identified Mail (DKIM) is an email authentication method designed to detect email spoofing . It allows the receiver to check that an email claimed to have come from a sp

Signup process, how to do it right!

Every flow, campaign you do should have KPIs , but most of all it should have a purpose. When we work on the signup flow we need to understand that the purpose is 100% clients that start the signup flow will complete it. This means your signup flow should be KISS (keep it stupid/super simple). In the signup flow we usually need the basic information of a customer, like: 1. Full name 2. Email 3. Phone number 4. Birthday 5. Country 6. City 7. Zip Code 8. Gender An example of a signup flow: The above diagram describes a nice signup flow: 1. On the first step you fill in your email and password (could be separated into two steps) 2. Step 2 you will need to fill in your full details, in the meantime you will receive a confirmation email. 3. Step 3 you will need to verify your phone number The email confirmation step is not part of the signup process. This email should have only one purpose, confirming the customer's email. Don't make it long or explain abo

Terminology you should know before starting your online gaming company

In this post I will try to layout the most important terms you need to know before starting an online gaming business. GGR, NGR, KPI, ARPU, CPA, CR and CLV. Of course the most important thing is understanding your goal. What do you want from your clients? What should they do? During my years in many online companies our goal was to buy DEPOSITS (i.e get 10% for xxx deposit, and so on). These days the goal is for players to play on their money as much as they can. In order to understand your goal in nowadays online casinos. You will need to understand a few key terms: Gross Gaming Revenue (GGR) Gross Gaming Revenue (GGR) is the amount wagered minus the winnings returned to players, a true measure of the economic value of gambling. GGR is the figure used to determine what a casino or other gaming operation earns before expenses like salaries and taxes are paid. GGR is the equivalent of “sales” not “profit” . Net Gaming Revenue (NGR) Net Gaming Revenue (NGR) is defined as gross bets le

Constant communication, what does it mean?

When it comes to conveying  your story to your clients you need to remember you are not the only one. When I started working in an online E-Gaming company our approach was not to engage clients more than twice a week. In the coming months we saw that the more we send the more clients come to our sites. This was 15 years ago and is true till today. The more you communicate with new content the more clients will visit your site.  In the world today your average customer receives five emails per hour. The competition is absolutely ridiculous. So if you want your customers to hear and notice you, you need to engage them often (i.e every day/two days). I know some of your clients won't like it so much. This is why most client communication platforms have a frequency option. Meaning the client can select how many emails/sms/automatic calls to receive on a weekly/monthly basis. Constant communication is really important to survive in the world today if your clients don't