<?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 Yilin A. Lee on Medium]]></title>
        <description><![CDATA[Stories by Yilin A. Lee on Medium]]></description>
        <link>https://medium.com/@acryilinc?source=rss-47c6499e12c1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*j2bG8ZgsXq3I3TQ3mOb0gQ.png</url>
            <title>Stories by Yilin A. Lee on Medium</title>
            <link>https://medium.com/@acryilinc?source=rss-47c6499e12c1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 10:46:43 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@acryilinc/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[Live Streaming - Its Growth during COVID-19, and How Businesses Can Take Advantage]]></title>
            <link>https://medium.com/@acryilinc/live-streaming-its-growth-during-covid-19-and-how-businesses-can-take-advantage-467d6b871e2d?source=rss-47c6499e12c1------2</link>
            <guid isPermaLink="false">https://medium.com/p/467d6b871e2d</guid>
            <category><![CDATA[trends-and-insights]]></category>
            <category><![CDATA[social-media]]></category>
            <category><![CDATA[live-streaming]]></category>
            <category><![CDATA[business]]></category>
            <category><![CDATA[facebook-marketing]]></category>
            <dc:creator><![CDATA[Yilin A. Lee]]></dc:creator>
            <pubDate>Sat, 13 Jun 2020 17:51:40 GMT</pubDate>
            <atom:updated>2020-06-15T09:21:19.809Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*2GCkyB7LegZMeDgm" /><figcaption>Photo by <a href="https://unsplash.com/@tiomp?utm_source=medium&amp;utm_medium=referral">Marcos Paulo Prado</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>As the world grapples with the COVID-19 pandemic, we are also seeing really interesting shifts in how businesses adapt to the changing economic landscape.</p><p>One interesting pivot is the increased adoption of <strong>live streaming</strong>. From retail to e-commerce to governments, live streaming— particularly on Facebook — has been the go-to channel for many businesses to reach out to the (currently home-bound) masses.</p><p><em>Disclaimer: Views expressed in this post are largely limited to Singapore, as they are based on my experiences living here.</em></p><h3>The Rise of Facebook Live Streaming during COVID-19</h3><p>Live streaming has been around for a pretty long time. Youtube was one of the first, <a href="https://www.reuters.com/article/us-media-youtube-idUSTRE4AB40U20081112">launching Youtube Live back in 2008</a>, while Facebook launched its Facebook Live feature much later in <a href="https://www.cnbc.com/2017/03/06/zuckerberg-put-employees-on-lockdown-to-launch-facebook-live-wsj.html">April 2016</a>.</p><p>Interestingly, the COVID-19 pandemic has helped <em>accelerate </em>the adoption of live streaming as a marketing channel in Singapore. With millions confined to their homes, businesses have had to innovate to reach out to their audiences — naturally, they turned to live streaming, or more specifically, <strong>live selling</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*uB7sWtIp80p7xE2D.jpg" /><figcaption>Screen captures from <a href="https://www.facebook.com/TekkaOnlineMarket/">Tekka Online Market’s Facebook page</a></figcaption></figure><p>A particularly interesting example is <a href="https://www.facebook.com/TekkaOnlineMarket/">Tekka Online Market</a>, a wet market in Singapore. The online live selling page is supported by Singapore’s Infocomm Media Development Authority (IMDA), in a bid to digitalise wet market businesses and encourage seniors to stay home during the pandemic. On its debut on 5 May, several stall owners showcased their fresh produce for live bidding. <a href="https://www.straitstimes.com/lifestyle/food/going-going-gone-at-tekka-markets-first-livestream-sale">The first live streaming session was so successful that it garnered more than 28,000 views</a>, with some stores selling out within 30 minutes. In fact, several stalls later started their own pages to sell online themselves.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*ecJtoAYo-IhaLo0Wednhcg.jpeg" /><figcaption>Photo from <a href="https://www.facebook.com/wanglei.singapore/">Wang Lei’s Facebook page</a></figcaption></figure><p>In another recent example, local <a href="https://en.wikipedia.org/wiki/Getai"><em>getai</em></a><em> </em>singer-actor Wang Lei rose spectacularly in popularity since pivoting into live selling,</p><p>Due to the pandemic, public <em>getai </em>performances were halted, resulting in the singer drawing zero income for 2 months. His initial foray into live selling was a favor for a friend, who needed help selling his fish. However, Wang Lei’s crude remarks and jokes during his live sales soon gained him a large following in Singapore, Malaysia and even China (someone uploaded his livestreams to Weibo, and his videos ranked 18 in Weibo’s trending list!). To date, Wang Lei’s page has more than 410K followers — with his latest live video hitting more than 630K views. He has since set up a business to handle his growing live sales, selling other products such as fresh vegetables and meat as well.</p><h3><strong>How can businesses take advantage of Live Selling?</strong></h3><p>Live streaming — particularly for e-commerce and retail — is here to stay. To be more specific, I’d like to focus on <strong><em>live selling </em></strong>as a marketing channel.</p><p>Here are some ways I think businesses can take advantage of it:</p><h4>1. Put a Face to Your Brand</h4><p>One key observation I’ve seen across successful live sellers in Singapore are the presence of entertaining hosts, who, in their own right, have garnered a massive following as well.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/0*40uYJa31PJF9UkbS" /><figcaption><a href="https://www.facebook.com/TheLadyboyMarketplace/photos/a.328845244715180/328849851381386/?type=1&amp;theater">Profile photo of The Ladyboy Marketplace</a></figcaption></figure><p>An interesting example is <a href="https://www.facebook.com/TheLadyboyMarketplace/">The Ladyboy Marketplace</a>, which sells various fresh seafood and meat products. Their live shows are often mixed with entertaining performances by the hosts — Daniel and King — where they have even dressed up in costumes, dancing in front of the camera to hawk their wares.</p><p>In fact, The Ladyboy Marketplace claims to “combine auction, entertainment and social to introduce their products to the public in a fun and entertaining manner”. Judging from the comments during the live videos and the page’s large following (at the time of writing, TLM has about 48,900 followers), live sales combined with entertainment seems to be working well.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*8uwJSdF35QPCuh3l.png" /><figcaption>Video screenshots of Lerine Yeo’s infamous S-Hook top. (Source: <a href="https://www.8days.sg/seeanddo/thingstodo/s-hook-ah-lian-on-how-life-has-changed-after-2mil-hits-on-viral-10768894">8days</a>)</figcaption></figure><p>Back in 2018, Lerine Yeo, owner of online retail shop <em>Misshopper Boutique</em>, shot to fame when <a href="https://mothership.sg/2018/09/fb-live-funny-seller-hooks/">a video of her selling what’s now known as the S-hook top made the rounds online</a> — garnering more than two million views and 34K shares seemingly overnight. Her hilarious and forthright style of selling things gained her a large following, even catching the attention of <a href="https://www.asiaone.com/entertainment/s-hook-ah-lian-signs-2-year-contract-mark-lees-agency">local celebrity Mark Lee who ended up signing her to his artiste management company in a two-year contract</a>.</p><p>As with the case of Wang Lei and The Ladyboy Marketplace, most viewers tune in to watch them probably not to purchase anything, but for the entertainment value they bring.</p><h4>2. Engage Your Audience</h4><p>Despite the physical distance, the presence of comments and the interactive nature of live streams provide a sense of connection between the seller and its viewers. Sellers can immediately respond to comments, making it easier for both parties to engage with each other, perhaps even triumphing the (sometimes awkward) face-to-face sales.</p><p>Another popular page, <a href="https://www.facebook.com/singaporehomecooks/">Singapore Home Cooks</a> (SHC), started out as an educational page sharing recipes and culinary tips. The page has since started selling fresh produce, seafood and meat. In its now regular live streams, the host Dylan introduces its products and opens it for bidding. A professional chef then whips it up step-by-step — showcasing the recipe live, and viewers can comment and ask questions almost instantaneously. The engaging nature of such live selling has proved to be popular, with SHC’s products usually sold out within minutes. Today, SHC has a strong 51.3K followers, where its most popular live show has gained more than 40K views in total.</p><h4>3. Be Authentic &amp; Sincere</h4><p>Given the digital disconnect with live selling, it is even more essential for businesses to portray themselves with sincerity in all their dealings online. When problems arise, more often than not, I’ve observed customers being supportive and understanding, due to the strong camaraderie they’ve already established with the seller.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/482/1*7Ih3uZFvQI2Mg-HVbI9jEw.png" /><figcaption>Screen capture of a post from <a href="https://www.facebook.com/JurongLianHuat/">Lian Huat Seafood</a>, a local seafood seller. The sincerity of the sellers is evident in this post.</figcaption></figure><p>Interestingly, I’ve also found live sellers to be more relatable than most celebrities. In preparing for this article, I watched several popular live sellers. In one clothing retailer’s live stream (<a href="https://www.facebook.com/mgchannellive">MG Channel</a>), the seller was showcasing the dresses she had in stock, when her kids could be heard quarreling in the background. She excused herself apologetically to settle the dispute, much to the amusement of the audience. In another, a model shared that she had been accepted into NTU Business (a local university) and her excitement for it. Instead of “spoiling” the live stream, these incidences made the sellers more relatable and down-to-earth.</p><p>Indeed, despite its virtual nature, live streams are a uniquely authentic way for businesses to connect with their audiences.</p><h4>4. Build a Community</h4><p>Lastly, businesses should capitalize on the social media platform it resides in — Facebook.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/311/1*I8Tz9IjcblEAOZ4QvXCjJw.png" /><figcaption>Screen capture of a review on The Ladyboy Marketplace</figcaption></figure><p>Aside from the usage of live selling, businesses should also take advantage of customer reviews and posts. Sharing of customers’ reviews helps to build a sense of community, as they know that their opinions are being valued. Good reviews also help tremendously in subsequent sales of the item(s).</p><p>Interestingly, I’ve also seen customers backing up sellers even when there was a bad review. In a particular example (names have been anonymized to protect the reviewer), a customer had purchased a can of seafood, and gave a bad review when the can “exploded”. Many other customers jumped in to defend the seller, stating that he/she had repeatedly told buyers to place it in the refrigerator after receiving it (which the reviewer didn’t) in the live stream, and that their purchases were of high quality. In a surprising turn of events, the bad review turned into something good, with the community banding together to defend the seller’s reputation instead.</p><p>Similarly, utilizing Facebook Groups is also essential. Singapore Home Cooks (SHC) has several groups set up; its most popular — <em>Singapore Home Cooks Group</em> — has more than 212K members, with its members posting an astounding <strong>1.2K posts a day</strong>. The group comprises of home cooks sharing their home cooking and culinary experiences, as well as sharing of products by SHC.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/762/1*fHlmG8JS830pd2J57WnZ5w.png" /><figcaption>Groups by Singapore Home Cooks</figcaption></figure><h3>Will the Live Streaming trend change post-COVID-19?</h3><p>As the economy gradually opens up and stores resume sales in physical locations, a key question is whether this trend will still continue.</p><p>Live streaming/selling has helped sustain many businesses during the pandemic. Post-pandemic, I believe it will only be increasingly adopted by more brands and businesses due to the larger audience it can potentially reach to.</p><p>I also foresee live streaming personalities gaining in popularity, perhaps even more so than local celebrities or influencers. In fact, I believe brands may soon be defined by the faces of their live streamers.</p><blockquote>In fact, I believe brands may soon be defined by the faces of their live streamers.</blockquote><p>Evidently, we’ve reached the tipping point of live streaming as a key marketing tactic. <strong>Businesses who arrive late to this game may soon find themselves eliminated.</strong></p><p><em>Thanks for reading!</em> <em>Post your comments and let me know your thoughts — As my views are largely limited to Singapore, I would love to learn how the live selling trend is like in other parts of the world!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=467d6b871e2d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Not-So-Secret Way to Mass Update Your Salesforce Records, For Free.]]></title>
            <link>https://medium.com/@acryilinc/the-not-so-secret-way-to-mass-update-your-salesforce-records-for-free-bfee68341eb3?source=rss-47c6499e12c1------2</link>
            <guid isPermaLink="false">https://medium.com/p/bfee68341eb3</guid>
            <category><![CDATA[salesforce]]></category>
            <dc:creator><![CDATA[Yilin A. Lee]]></dc:creator>
            <pubDate>Fri, 20 Mar 2020 07:02:36 GMT</pubDate>
            <atom:updated>2020-03-20T08:07:32.545Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-nc/4.0/</cc:license>
            <content:encoded><![CDATA[<h3>The Step-by-Step Guide to Mass Update Your Salesforce Records, For Free.</h3><p>Mass updating records in Salesforce is a pain in the a** for non-common objects like Tasks.</p><p>Recently, the need arose for my organisation to create new Task types for my salespersons to record their various activity. To do so, I created new Task Record Types, each with its relevant fields (might work on another post on how I did it!).</p><p>We’ve also integrated with Pardot to sync email activity into Salesforce. However, I realized that Pardot email activities were automatically created in Salesforce with default activity types— this affected my reports and dashboards as I wanted the activities to be reported based on the new Task types I had created. I needed to do two things:</p><ol><li>Update past Pardot email activities with the new record types;</li><li>Create a process to automatically update new Pardot emails with the new Email record type I’ve created (may do up another post on this soon!)</li></ol><p>The problem with Tasks is that it’s not one of the Standard objects available in the Salesforce Data Import Wizard.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1HUzqi2cFdyrreIPheEu0w.jpeg" /><figcaption>The available Standard Objects in the Salesforce Data Import Wizard</figcaption></figure><p>After much research, I came across a solution: <strong>Data Loader</strong>.</p><p>(Note: There is a cloud solution — <a href="https://dataloader.io/">Dataloader.io </a>— that accomplishes the same and is pretty easy to use, with no installation required. However, the free version only allows you to import/export up to 10,000 records per month — it resets monthly)</p><p>Here are the steps on how you can use Data Loader, specifically to update the Record Types for Tasks (as explained above). The process should also be easily replicable for other objects.</p><p>Note: You will need to be an Administrator to perform the following steps. I will only be describing the process using a Windows machine.</p><h3>Step 1: Download Data Loader</h3><p>In Setup, search for “Data Loader”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7Bs4WreyS2O4P9y2wklKMA.jpeg" /><figcaption>Setup &gt; Data Loader</figcaption></figure><p>Click on the respective links depending on your machine. I am using a Windows machine. Once clicked, you should automatically download a .zip file. Right click the .zip file and select <strong>Extract All</strong>.</p><h3>Step 2: Install Zulu OpenJDK</h3><p>Go to the <a href="https://www.azul.com/downloads/zulu-community/?architecture=x86-64-bit&amp;package=jdk">Zulu Community site</a> and download the relevant version for your machine.</p><p>For Windows, download the .MSI file.<br>For Mac, download the .DMG file.</p><h3>Step 3: Install Data Loader</h3><p>In the Data Loader folder, double-click the <strong>install.bat</strong> file.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/774/1*pdDLTeXUbbYEE3mto5n4nQ.jpeg" /><figcaption>Install the install.bat file</figcaption></figure><p>Command prompt pops up. Specify where you want to install Data Loader. I simply hit enter as I’m okay with the selected directory.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*A4Ep19-WZBghvjgEEAinXw.png" /><figcaption>Specify where you want to install Data Loader.</figcaption></figure><p>You will be prompted on whether to create a start menu shortcut. Type “Yes” and hit enter.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uCkCr3UZr8oOiebcEEMwAA.png" /><figcaption>Create a start menu shortcut</figcaption></figure><p>Next, you will be asked if you’d like to create a desktop icon. Type “Yes” and hit enter.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EwNPYul51vtm_9DBgs2G5Q.png" /></figure><p>That’s it! Now simply hit any key to continue.</p><h3>Step 4: Prepare your data</h3><p>As explained previously, I wanted to update my Tasks.</p><p>First, export the records you want to update from Salesforce. I do it via Reports as it’s quick and easy — create a report with the fields you want to update, and export it as a csv. (Psst: You can also choose to do it via Data Loader, as it pulls out more backend details that may not be viewable on Reports.)</p><p><em>(Note: You will need to export the Activity ID to serve as the unique identifier for Data Loader to match and update accordingly.)</em></p><p>Once exported, update your records via Excel accordingly.</p><p>In my case, I updated columns B and C with the Activity Type I want, and the Record Type ID I want (you’ll need to make sure you get the correct ID!)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/535/1*l546GpLFh232It3m6G5-WQ.png" /><figcaption>How my data looks like.</figcaption></figure><p>Save your updated data as a .csv file.</p><h3>Step 5: Start Data Loader</h3><p>Before we go into Data Loader, it’s important to know what action you want to perform:</p><h4>Types of Actions:</h4><ol><li><strong>Insert</strong>: You are inserting new records only. Existing data is not changed.</li><li><strong>Update</strong>: You are updating existing records. Data will be changed.</li><li><strong>Upsert</strong>: You are updating and inserting new records. This will check existing records against the new information you upload and update accordingly. At the same time, it will also insert new records.</li><li><strong>Delete: </strong>You are deleting the records you upload.</li></ol><p><strong>Important: </strong>“Update”, “Upsert” and “Delete” alters your existing Salesforce records, hence it’s important to ensure that you’re uploading the correct information!</p><p>After the installation in step 3, you should see the Data Loader icon on your desktop or in your Start menu. Run it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/910/1*gNtrA2zyjFIs0ABSYQmx8w.png" /><figcaption>Actions available on Data Loader.</figcaption></figure><p>Select the action you want to perform. In my case, as I want to change the record type for my tasks, I will select “Update”.</p><p>You will be prompted to log into Salesforce.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/754/1*1i75AnbCrlk1avnz9TneVA.png" /><figcaption>Choose the environment.</figcaption></figure><p>As I want to update live information, I will choose the Production environment. Login. Allow access to <em>Dataloader Partner</em>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/425/1*-EORcumRouqsbM-8SfOIEg.png" /><figcaption>Allow access.</figcaption></figure><p>Hit Next.</p><h3>Step 6: Select the right Object</h3><p>Next, select the right Object to work with. Since I’m working on Tasks, I’ll select it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/754/1*FWCiJbctJVxRm54SQeybFw.png" /><figcaption>Select the object you are working with.</figcaption></figure><p>Next, choose the .csv file you’ve prepared in step 4 by clicking “Browse”. Hit next.</p><p>A popup appears, confirming the number of records you will perform the action on. Click OK.</p><h3>Step 7: Map your data.</h3><p>In this step, you are matching your data to Salesforce fields. This is a very important step — make sure you’re mapping it correctly!</p><p>Click “Create or Edit a Map”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/754/1*hptQ8Jjb0l3BdlzlJtAHVw.png" /><figcaption>Click “Create or Edit a Map”.</figcaption></figure><p>Next, you will need to drag and drop the available Salesforce fields (in the top table) down to the column mapping below. Ensure that you have selected the right column accordingly.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/770/1*huqp7NK_7yWTRK8vu4AfRw.png" /><figcaption>The “Name” column should correspond to the “File Column Header” column.</figcaption></figure><p>Once you’re done mapping, click OK. Then, click Next.</p><p>Choose a directory to indicate where your success and error files will be saved. In the event of errors, you can open the files saved to investigate and amend your data file accordingly.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/754/1*7Ht7f_RdZ5-KJT16_B7Ovg.png" /><figcaption>Select directory.</figcaption></figure><p>Hit “Finish”.</p><p>A warning pops up, asking you to verify if you still want to proceed.</p><p>Again, be very sure that your uploaded data is<strong> 100% correct</strong> as the process cannot be undone (technically, you can still re-update again with the right data, but there may be some irreversible changes, so please be extra careful!). Hit “Yes” once you’re sure.</p><h3>Step 8: You’re done!</h3><p>Data Loader will now update the records for you. Depending on the number of records you have, the process might take awhile. There will be a progress bar updating the number of records processed.</p><p>Once it’s done, you will be notified. Check that there are no errors. If there is, view them and see what went wrong to determine what you should do.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/553/1*vAcH0HaD0ZELhWPhRNo6HQ.png" /><figcaption>Update complete!</figcaption></figure><p>That’s it! You can now go back into Salesforce to verify that the changes have been made.</p><p>Data Loader’s an easy way to update (almost) anything in your Salesforce org— that’s pretty exciting but scary as well, as anything can go wrong if you’re not familiar with how things work or make a mistake. Hence, always be extra careful, or approach a professional consultant or Salesforce support staff if you need more guidance.</p><p>Hope this article helped you, and feel free to comment with any suggestions or feedback!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bfee68341eb3" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>