<?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 Surya Sanchez on Medium]]></title>
        <description><![CDATA[Stories by Surya Sanchez on Medium]]></description>
        <link>https://medium.com/@suryasanchez?source=rss-2f80a6d9a8f0------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*JakTjXCjc4OzAyLYQhFdbw.jpeg</url>
            <title>Stories by Surya Sanchez on Medium</title>
            <link>https://medium.com/@suryasanchez?source=rss-2f80a6d9a8f0------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 16:53:18 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@suryasanchez/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[How to predict the day you’ll reach 10k Instagram followers]]></title>
            <link>https://medium.com/@suryasanchez/how-to-predict-the-day-youll-reach-10k-instagram-followers-511c74bb1771?source=rss-2f80a6d9a8f0------2</link>
            <guid isPermaLink="false">https://medium.com/p/511c74bb1771</guid>
            <category><![CDATA[predictive-analytics]]></category>
            <category><![CDATA[alteryx]]></category>
            <category><![CDATA[instagram]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[marketing]]></category>
            <dc:creator><![CDATA[Surya Sanchez]]></dc:creator>
            <pubDate>Fri, 03 May 2019 19:55:55 GMT</pubDate>
            <atom:updated>2019-05-03T19:55:55.691Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Plot twist: reaching 10k means unlocking the </em><a href="https://blog.hubspot.com/marketing/add-link-instagram-story"><em>swipe up feature</em></a><em>. </em>🤫</p><h4>Summary</h4><ol><li>How to collect the right data</li><li>Predictive models<br>a. Simple way with Google Spreadsheet<br>b. Advanced way with Alteryx</li><li>Bonus</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*O_91GqZU9TjHnRDG" /><figcaption>Photo by <a href="https://unsplash.com/@adeolueletu?utm_source=medium&amp;utm_medium=referral">Adeolu Eletu</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>How to collect the data?</h3><p>In order to predict your future number of followers, you’ll have to calculate your followers’ growth rate</p><p>To do that you can create a script that runs every day and collects your current number of followers. Instagram doesn’t give you followers stats over time, so you’ll have to collect it yourself. You can do this easily with Google Spreadsheet and some scripts.</p><p>Steps you can do to collect that data in Google Spreadsheet:</p><ul><li><a href="https://sheet.new/">Open a new Google Spreadsheet</a></li><li>Go to the “<em>Script editor</em>” in the “<em>Tool</em>” menu.</li><li>Name the script and delete all the prefilled code “<em>function myFunction…</em>”</li><li>Copy and past <a href="https://github.com/suryasanchez/google-script/blob/master/instagram-followers.gs">my script below from Github</a></li></ul><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/f5c0be29a0024c12e9a89fd3405e084b/href">https://medium.com/media/f5c0be29a0024c12e9a89fd3405e084b/href</a></iframe><ul><li>Replace in the script “<em>sheet1</em>” by the name of your sheet (<em>not the name of the spreadsheet</em>) and “<em>profile1</em>” by your Instagram username. If you want to track more than one account, edit “<em>sheet2</em>” and “<em>profile2</em>”. You can copy paste and add as many lines as you want to track accounts. If you only want to track one account, delete line 4.</li><li>In the same spreadsheet, you need to have a separate sheet for every account you want to track. <strong>Go ahead and create every sheet with the same name you wrote in the script.</strong></li><li>Save the script by clicking on the 💾 button. Now you need to add a trigger to execute the script automatically every day. Click on the 🕒 button next to the save icon.</li><li>On the page that opened, click on the “<em>Add Trigger</em>” button, use the settings from the screenshot below, and click save:</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7XQ4BkE7hynUWAkI7MbDKQ.png" /></figure><ul><li>If you get a message “This app isn’t verified” click on the “Advanced” link and then “Go to Untitled project (unsafe)”. You can now click on the “Allow” Button.</li></ul><p>Every day the script will write a new line with the date and your current number of Instagram followers. 🎉</p><p><em>You could also use Google Data Studio to create an automated report.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Ziq3DsGlLeM9YRP4" /><figcaption>Photo by <a href="https://unsplash.com/@georgiadelotz?utm_source=medium&amp;utm_medium=referral">Georgia de Lotz</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>How to predict the day you’ll reach 10k followers?</h3><p>There are many ways to answer this question. I’ll show you two.</p><p><em>Keep in mind that the more data you have collected, the more reliable the prediction is.</em></p><h4>First and simple method</h4><ul><li>Add this formula in a cell and the end of your sheet.</li></ul><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/6302dfba0b79798514002bbea55c2449/href">https://medium.com/media/6302dfba0b79798514002bbea55c2449/href</a></iframe><ul><li>Change <strong><em>B62</em></strong> by the cell with the most recent number of follower scrapped. Change <strong><em>B2</em></strong> by the cell with the oldest number of follower scrapped. Change <strong><em>B3</em></strong> by the cell with the second oldest number of follower scrapped.</li></ul><p>Alternatively, you can use the following formula to calculate the expected date for 10k followers based on the linear regression of the dataset.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/b8b9d8abdae95137496057521b992fad/href">https://medium.com/media/b8b9d8abdae95137496057521b992fad/href</a></iframe><p>Enter this formula in the date column. Adapt “<em>A2:A62</em>” to your date selection and “<em>B2:B62</em>” to your number of followers by date selection.</p><p>✨Voila! You just predicted the date you’ll have 10k followers on Instagram.✨</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*ApYGgK8O4_SJ0yYp" /><figcaption>Photo by <a href="https://unsplash.com/@brookelark?utm_source=medium&amp;utm_medium=referral">Brooke Lark</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h4>Second and advanced method</h4><p>The simple method only takes into account your average number of new followers per day. This would be fine if your account has linear growth.</p><p><em>If you do not have a lot of data it doesn’t really make sense to use these advanced models. Just go for the first method.</em></p><p>What if your number of followers increases every day more and more, in an exponential way? Or maybe decreases for some time due to a seasonal trend?</p><p>Let me introduce you to two statistical models:</p><ul><li>ARIMA (Autoregressive integrated moving average)</li><li>ETS (Exponential smoothing)</li></ul><p>Rather than going deep into the math I will show you how to apply these models in <a href="https://www.alteryx.com/">Alteryx</a>. This is the software I use but you could do that with any advanced BI tool or even in Python.</p><ul><li>First step, you will have to determine which of these two models is the best regarding your data. To do that, you create a validation set with about 20% of the data. In Alteryx, I did that by filtering by record ID.</li><li>You can then link the <em>ETS</em> and <em>ARIMA</em> tools to the dataset. Connect then the object output to the <em>TS Compare</em> tool. The second input of the <em>TS Compare</em> tool you connect to the validation set. Add a <em>Browse</em> tool to the report output.</li><li>In the <em>ETS</em> and <em>ARIMA</em> tools select the target field to be the number of followers and daily (all days) in the target field frequency.</li></ul><p>Here’s the models&#39; comparison workflow:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*o639rpXy9p8eXsHVaFoCEg.png" /></figure><ul><li>Check in the report the Accuracy Measures and choose which model you will use. I personally check for the lowest value of <a href="https://en.wikipedia.org/wiki/Mean_absolute_scaled_error">MASE</a> and <a href="https://en.wikipedia.org/wiki/Root-mean-square_deviation">RMSE</a> to measure the accuracy of my models.</li></ul><p><em>In my case, ARIMA is more accurate. I’ll use the ARIMA tool in the example below, but use ETS if it’s more accurate for you.</em></p><ul><li>Create a new workflow and connect the <em>ARIMA</em> (or ETS) tool with the same settings. Note that when creating the prediction model you should <strong>not </strong>use a validation set.</li><li>Connect the <em>TS Forecast</em> tool to the <em>ARIMA</em> object output. In the TS Forecast tool, choose the “number of periods into the future to forecast” depending on how far your current follower number is far from 10k. The further you are, the higher the number you’ll choose.<br>For example, if you think that you need 90 days to reach 10k, enter “90” in the field. The model will then calculate the number of followers for the next 90 days.</li></ul><p>Here’s the prediction model’s workflow:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Itfqa-txdubVq23_MqDFTQ.png" /></figure><p>On top of this, add a “real” or “predicted” label next to the number of followers. Also, make sure you format the date column of the predicted followers&#39; number correctly.</p><p>Export all of that data into a CSV file and import into <a href="https://www.tableau.com/">Tableau</a>.</p><p>You should get something like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lWVyk_x0bjEKMy-5-_YYAA.gif" /></figure><h4>Bonus</h4><p>Is the predicted date very far?</p><p>To speed up and boost the number of followers you gain every day you can automate your Instagram account. Follow if you don’t want to miss my article on how to set up a smart Instagram automation to grow your account.</p><p>If you’re in a hurry, check out my service <a href="https://www.boostyourig.com/">Boost Your IG</a>. 📸</p><p>Let me know if you succeed in finding the date you reach 10k followers. 😊</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=511c74bb1771" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The day I lost 10 years of photography]]></title>
            <link>https://medium.com/@suryasanchez/the-day-i-lost-10-years-of-photography-6b6f03f70fa0?source=rss-2f80a6d9a8f0------2</link>
            <guid isPermaLink="false">https://medium.com/p/6b6f03f70fa0</guid>
            <category><![CDATA[cloud-storage]]></category>
            <category><![CDATA[hard-drive]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[photography]]></category>
            <dc:creator><![CDATA[Surya Sanchez]]></dc:creator>
            <pubDate>Wed, 10 Apr 2019 16:32:31 GMT</pubDate>
            <atom:updated>2023-07-18T15:22:11.990Z</atom:updated>
            <content:encoded><![CDATA[<h3>The story</h3><p><em>On a lovely summer evening, I was sitting at my desk when suddenly I heard a weird noise next to my computer. At that moment I didn’t know it, but that noise would have significant consequences…</em></p><p>We are back in 2016. I just finished a year trip around the world. I am back in Geneva — my home town to (re)connect with my people. From Thailand to Mexico I traveled with two cameras and a laptop. During my travel, I developed habits to not loose or get anything stolen. As you can imagine I took heaps of photos of my adventures with my cameras and stored them all in a hard drive.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*8Xyb5Re1AqMv0XxK" /><figcaption>Photo by <a href="https://unsplash.com/@farber?utm_source=medium&amp;utm_medium=referral">Jonathan Farber</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p><em>The noise surprised me and looking closer I noticed it was coming from my hard drive. When I tried to access it, my computer didn’t recognize it. Of course, as my field is IT, I thought nothing is over. I googled the symptoms, and the result is serious. The ‘click of death’ they call it. To analyze and (hopefully) heal the sick device I ran some chkdsk commands that took days to get through. Here was my big mistake.</em></p><p>Why did I care about that hard drive? The reason is<strong> all of my photos</strong> ever taken are inside. Why? Because I wanted to travel light, having everything in the same place and I didn’t believe in backups because you know I developed habits not to get stuff stolen.</p><p><em>I decided to let the recovery of my poor hard drive to a specialized company in another country. Unfortunately, their news are bad: I destroyed all my hard drive by running the chksdk command. I now have two options: they send me the hard drive back, or they throw it away for free. Unwillingly, I choose the second option.</em></p><blockquote>At that moment I realized it is real: I lost 10 years of photography!</blockquote><h3>Why do I tell you all of that?</h3><p>Saving your data is important. It took me one week to recover from my loss. After that, I swore it will never happen again! I reflected about a safe way to take care of my data.</p><p>Steps I took:</p><ol><li>I back up my whole computer and hard drives continuously using <a href="https://secure.backblaze.com/r/014ad4">Backblaze</a>.</li><li>My photos are saved in <a href="https://aws.amazon.com/s3/">Amazon S3</a> directly after being moved from my SD card to my computer. I use <a href="https://www.odrive.com/">odrive</a> for playing the role of a custom Dropbox.</li><li>I format my SD cards only when the transfer of my photo to the Cloud is over.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*9kjyhSJ8mYhe8SIf" /><figcaption>Photo by <a href="https://unsplash.com/@chuttersnap?utm_source=medium&amp;utm_medium=referral">chuttersnap</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>Reflections</h3><p>The loss of all my photos made me reflect on some things. Right after the incident, I had the feeling that all those years practicing photography were gone as I lost all of my photos. But in fact, I realized that the knowledge I gained by doing photography for ten years is more valuable than the photos themselves. However, I encourage everybody to attend proper backups for example with the three steps mentioned above.</p><p>Let me know what your way of backing up your data is. 😊</p><p>Curious to see some of my photos? Check my <a href="https://www.instagram.com/suryasanchez1/">Instagram</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6b6f03f70fa0" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>