<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Mark Kofman on Medium]]></title>
        <description><![CDATA[Stories by Mark Kofman on Medium]]></description>
        <link>https://medium.com/@markkofman?source=rss-9c25b11800d1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*w_bVODPghkVb5p1d.png</url>
            <title>Stories by Mark Kofman on Medium</title>
            <link>https://medium.com/@markkofman?source=rss-9c25b11800d1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 22:35:15 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@markkofman/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Things I want to tell my kids as they grow up]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">These are the notes that I was collecting over the past years to later share with my kids (David, Esther, Adam). I hope they can come back&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@markkofman/things-i-want-to-tell-my-kids-as-they-grow-up-c223d5cfc623?source=rss-9c25b11800d1------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@markkofman/things-i-want-to-tell-my-kids-as-they-grow-up-c223d5cfc623?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/c223d5cfc623</guid>
            <category><![CDATA[parenting]]></category>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Wed, 05 Jan 2022 01:01:22 GMT</pubDate>
            <atom:updated>2022-01-05T01:01:22.445Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[What Software To Instal for a Newly Established Business?]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@markkofman/what-software-to-instal-for-a-newly-established-business-df0d1eb87f26?source=rss-9c25b11800d1------2"><img src="https://cdn-images-1.medium.com/max/2422/1*WMlRs2J7498mMOQlAv07lQ.png" width="2422"></a></p><p class="medium-feed-snippet">You have just started a new business and now thinking about setting up some simple modern software solutions to better run it. But where&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@markkofman/what-software-to-instal-for-a-newly-established-business-df0d1eb87f26?source=rss-9c25b11800d1------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@markkofman/what-software-to-instal-for-a-newly-established-business-df0d1eb87f26?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/df0d1eb87f26</guid>
            <category><![CDATA[crm]]></category>
            <category><![CDATA[saas]]></category>
            <category><![CDATA[business-software]]></category>
            <category><![CDATA[business]]></category>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Fri, 07 Feb 2020 06:10:01 GMT</pubDate>
            <atom:updated>2020-02-10T04:31:02.837Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[The most simple breakfast dish]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">One of the easiest and fastest to prepare. One of my kids&#x2019; favorites. Best choice when you are late to work.</p><p class="medium-feed-link"><a href="https://medium.com/@markkofman/the-most-simple-breakfast-dish-cde620badea6?source=rss-9c25b11800d1------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@markkofman/the-most-simple-breakfast-dish-cde620badea6?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/cde620badea6</guid>
            <category><![CDATA[breakfast]]></category>
            <category><![CDATA[simple-living]]></category>
            <category><![CDATA[cooking]]></category>
            <category><![CDATA[food]]></category>
            <category><![CDATA[kids]]></category>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Tue, 28 Jan 2020 03:50:49 GMT</pubDate>
            <atom:updated>2020-01-28T03:50:49.105Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Emotions]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">I am not very emotional person. At least I think so.</p><p class="medium-feed-link"><a href="https://medium.com/@markkofman/emotions-324ae43f4648?source=rss-9c25b11800d1------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@markkofman/emotions-324ae43f4648?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/324ae43f4648</guid>
            <category><![CDATA[emotions]]></category>
            <category><![CDATA[startup]]></category>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Sat, 18 Jan 2020 14:09:05 GMT</pubDate>
            <atom:updated>2020-01-18T14:09:05.676Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Join Multiple Data Sheets in Excel Using VLOOKUP Function]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@markkofman/join-multiple-data-sheets-in-excel-using-vlookup-function-24e3a27d80cd?source=rss-9c25b11800d1------2"><img src="https://cdn-images-1.medium.com/max/600/1*EGoxoHtmRfm_oobMd2H9gQ.gif" width="600"></a></p><p class="medium-feed-snippet">I know Excel gurus might laugh at me for writing this blog post. But whenever I am opening Excel, and need to join data from 2&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@markkofman/join-multiple-data-sheets-in-excel-using-vlookup-function-24e3a27d80cd?source=rss-9c25b11800d1------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@markkofman/join-multiple-data-sheets-in-excel-using-vlookup-function-24e3a27d80cd?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/24e3a27d80cd</guid>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[vlookup]]></category>
            <category><![CDATA[csv]]></category>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Sat, 14 Apr 2018 01:01:29 GMT</pubDate>
            <atom:updated>2020-01-28T04:51:01.713Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Associating contacts and companies]]></title>
            <link>https://medium.com/@markkofman/associating-contacts-and-companies-3210c00b628d?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/3210c00b628d</guid>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Thu, 05 Apr 2018 23:18:35 GMT</pubDate>
            <atom:updated>2018-04-05T23:18:35.937Z</atom:updated>
            <content:encoded><![CDATA[<img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3210c00b628d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Importing tasks into Asana]]></title>
            <link>https://medium.com/@markkofman/importing-tasks-into-asana-7505880ca71e?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/7505880ca71e</guid>
            <category><![CDATA[task-management]]></category>
            <category><![CDATA[import]]></category>
            <category><![CDATA[import-export]]></category>
            <category><![CDATA[asana]]></category>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Sun, 14 Jan 2018 00:06:37 GMT</pubDate>
            <atom:updated>2018-01-14T00:06:37.154Z</atom:updated>
            <content:encoded><![CDATA[<p>Now using <a href="http://wizard.import2.com/">Import2 Wizard</a> you can import tasks into <a href="http://www.asana.com/">Asana</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WDLqaIaAWLLqX_cWW_6YiA.png" /></figure><p>Here are some important features of the Asana tasks import</p><ul><li>Works with both free and premium Asana versions</li><li>Allows you to associate tasks into projects and sections</li><li>Allow to set task assignee</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/400/1*LBTKOd33gMRr8L3ILpy36w.gif" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7505880ca71e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Counting Users with Intercom]]></title>
            <link>https://medium.com/rasper-com/counting-users-with-intercom-e5656896809c?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/e5656896809c</guid>
            <category><![CDATA[intercom]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[users]]></category>
            <category><![CDATA[metrics]]></category>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Thu, 10 Aug 2017 00:18:23 GMT</pubDate>
            <atom:updated>2017-08-10T00:18:23.203Z</atom:updated>
            <content:encoded><![CDATA[<p>Did you start using Intercom recently and now thinking about getting some metrics and analytics? This post will help you to get started. Nothing complicated, no advanced analytics tools, just a quick overview of things you can setup in few minutes today right inside Intercom.</p><h3><strong>Total Number of Users</strong></h3><p>So first obvious metric you will want to track is the total number of users. Just to show you how many total users you have. You can see this number in the top left corner in Intercom with title <strong><em>All users</em></strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/916/1*J4FufbHeAGydN15XVcdm4A.png" /><figcaption>Total Number of Users</figcaption></figure><p>Keep in mind that depending on your Intercom setup it might also include deleted or inactive users. In which case, you may want to clean up the database before counting all users.</p><h3>Active Users</h3><p>So next logical step is to understand how many users of the total are using your system and can be called <strong>active users</strong>. Luckily, Intercom allows you to create a filter/segment like that.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/524/1*IIFwfIt1tN8nOBCXKYX3uA.png" /><figcaption>Segment users based on last seen date</figcaption></figure><p>Depending on your business, you might also want to track your daily and monthly active users. Just choose the right number of days, when filtering.</p><h3>New Users</h3><p>Now that you know a number of your active users, you will quickly notice, that this number doesn’t change that much on a daily basis. And you will soon start asking yourself, how do I track new users that are signing up for your product. And again, you can use Intercom filters/segments to create a view to show you count of new users created during certain period.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/518/1*D3VAlo8QcjSJbM51UPK1VQ.png" /><figcaption>Segment users based on their sign up date</figcaption></figure><h3>Total Number of Paid Users</h3><p>Unless you are a non-profit organization, you will also want to know how many of users are paying you. This metric will have different setup depending on if your customers are businesses or individuals.</p><p>Let’s assume though you are selling directly to end users (B2C) and you are already sending purchase events into Intercom. If not, you can read the following guide: <a href="https://docs.intercom.com/the-intercom-platform/track-events-in-intercom">Track events in Intercom</a>.</p><p>So counting number of paid users, would be again as simple as creating a filter to find all users that have custom purchase event in the past</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/512/1*la36HKm1uO6_UlrZ6mBVbQ.png" /></figure><h3>4 Metrics with Intercom Segment Feature</h3><p>Now you can use Intercom segment and filter feature to start tracking 4 simple metrics about your user base</p><ul><li>Total Number of Users</li><li>Active Users</li><li>New Users</li><li>Paid Users</li></ul><p><strong><em>Hope this was helpful, and if you have any questions about more specific Intercom metrics, please leave a comment on this post</em></strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e5656896809c" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rasper-com/counting-users-with-intercom-e5656896809c">Counting Users with Intercom</a> was originally published in <a href="https://medium.com/rasper-com">Rasper Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Calculating First Reply Time for Intercom Conversations]]></title>
            <link>https://medium.com/rasper-com/calculating-first-reply-time-for-intercom-conversations-9dbdfe7b35c4?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/9dbdfe7b35c4</guid>
            <category><![CDATA[customer-service]]></category>
            <category><![CDATA[customer-support]]></category>
            <category><![CDATA[metrics]]></category>
            <category><![CDATA[intercom]]></category>
            <category><![CDATA[first-reply-time]]></category>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Tue, 01 Aug 2017 04:15:45 GMT</pubDate>
            <atom:updated>2017-08-01T04:15:45.294Z</atom:updated>
            <content:encoded><![CDATA[<p>I don’t know if you have noticed, but <a href="http://www.intercom.com/">Intercom</a> definition of built-in First Reply Time metric is a bit unusual. Here is how it works according to <a href="http://www.intercom.com/">Intercom</a>:</p><blockquote>The median first response time is the time within which 50% of the messages received were responded to. It’s a better measurement of response times than average, because with average response time, a few messages received at the weekend or during non-business hours could take much longer to reply to and skew your numbers.</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8r8MvQki94TDmD1Cjmoy5w.png" /></figure><p>Let’s make sure we are on the same page with the definition. So to calculate this number, Intercom takes all new incoming messages and find 50% of conversations with the best first reply time. Now, if you take the worst first reply among this 50% of conversations, you would get your Median First Reply Time.</p><p>For example, if for a specific day, your median response time was 45 minutes, it means 50% of your conversations were responded to in less than 45minutes, and 50% were responded to in more than 45 minutes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/400/1*WKzbwaksukWYzf0Z5ynsgA.gif" /></figure><p>I see few problems with that definition:</p><ul><li>Whatever number you get, it is hard to build an intuition if it’s a good value or not. For example, if your first response time is 2 hour for 50%, but for other 50%, it’s 2 days. Is it good or bad?</li><li>It doesn’t account the other 50% of your conversations with users. For example, you might be doing a good job during your business hours and have 2 hours first reply time for 50% of your customers, but your other 50% might be waiting for 8+ hours.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/480/1*NqPcqJynevaGIPWMckhvFA.gif" /></figure><ul><li>This definition is not standard across the industry, so if you want to compare your numbers to companies using tools other than Intercom, like Zendesk, Help Scout or Salesforce, you are out of luck.</li></ul><p>In addition to built-in median first reply time measuring, I recommend you also track average first reply time as <a href="http://metrics.rasper.com/metrics/18-first-reply-time">defined here</a>. Metric is calculated in calendar minutes from when the ticket was created to the first agent reply. The calculation is for all tickets created in the specified timeframe. For example, if your team received 3 new tickets yesterday. The first was replied to in 2 minutes, the second in 5 minutes and the third in 8 minutes. Your average first reply time for yesterday is 5 minutes.</p><ul><li>Tracking first reply time for all conversations would make sure you are not sugarcoating the results. If you have outliers that are making numbers look bad, you have to take those into account. Every customer message deserves a fast reply.</li><li>Said that, you can also find <a href="https://hbr.org/2002/11/the-flaw-of-averages">flaws with calculating average</a>s. So try to track this in addition to other metrics including median provided by <a href="http://www.intercom.com/">Intercom</a>.</li><li>Even better, if you look into different problematic conversations one by one, to see the real reason why your first reply numbers are lower than expected. This would guarantee you have a full understanding of the problem.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/480/1*aYcXQbVyLgVxzV9NhX4U8Q.gif" /></figure><p>To automate First Reply Time metric calculation, you can use <a href="http://www.rasper.com/">Rasper</a> or write a script to load all conversations from Intercom API and calculate metric manually.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9dbdfe7b35c4" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rasper-com/calculating-first-reply-time-for-intercom-conversations-9dbdfe7b35c4">Calculating First Reply Time for Intercom Conversations</a> was originally published in <a href="https://medium.com/rasper-com">Rasper Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[When NOT to Use Data]]></title>
            <link>https://medium.com/rasper-com/when-not-to-use-data-18033beb5331?source=rss-9c25b11800d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/18033beb5331</guid>
            <category><![CDATA[intuition]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[analytics]]></category>
            <dc:creator><![CDATA[Mark Kofman]]></dc:creator>
            <pubDate>Wed, 26 Apr 2017 23:44:29 GMT</pubDate>
            <atom:updated>2017-04-26T23:44:29.690Z</atom:updated>
            <content:encoded><![CDATA[<p>I am big advocate of using data and metrics in your daily operations. But to my surprise a very common problem you see is that people use data too much. So I have documented for myself a short checklist to show myself if my urge to use the data in certain situation is reasonable.</p><h4><strong>Cost of collecting data is too high</strong></h4><p>If it costs more to collect data, than value you get from this, just don’t do it. If you are just choosing where to go for lunch, there is no need to check Michelin guide.</p><h4><strong>When data is not giving you the full picture.</strong></h4><p>Sometimes you have lots of data, but it is only giving you partial information. Look at the Google Analytics report about organic search keywords.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*b_2cek39ZH6TqlAEGhnQiQ.png" /></figure><p>There is no point looking into that report if Google is not providing you the keyword data.</p><h4><strong>When you don’t have data</strong></h4><p>I know this sounds obvious, but many times we just don’t want to give up. We promised ourself to become data-driven and are trying to base all decisions on data. But if you don’t have data, you need to move on.</p><h4>Cost of the mistake is too small.</h4><p>Think of a cost of a mistake of your decision. If its low, just go with your intuition instead.</p><blockquote>“the only real valuable thing is intuition”, Albert Einstein</blockquote><h4><strong>When you don’t have specific question or issue defined.</strong></h4><p>Many data projects start after you read some cool article about big data or new analytics tools and you want to go ahead and also make your company data-driven. But before you do so, please make sure you have an idea of what questions you are trying to find an answer for.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=18033beb5331" width="1" height="1" alt=""><hr><p><a href="https://medium.com/rasper-com/when-not-to-use-data-18033beb5331">When NOT to Use Data</a> was originally published in <a href="https://medium.com/rasper-com">Rasper Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>