In this video I show the easiest way to chin mount a GoPro to your motorbike helmet using Sugru. My helmet is a Shoei Multitec from way back when. Enjoy!
Timestamps
0:10 Mount GoPro
7:19 Test Bike Footage
In this video I show the easiest way to chin mount a GoPro to your motorbike helmet using Sugru. My helmet is a Shoei Multitec from way back when. Enjoy!
Timestamps
0:10 Mount GoPro
7:19 Test Bike Footage
Eight months ago, I kept hearing from the video marketing whales that TikTok was a fantastic way to leverage exposure to your YT channel. I ignored the suggestion. TikTok is for kiddies. I’m a 53-year-old who digs into the inner workings of success on YouTube, why the hell would any kid care about what I have to say on that venue?
A month ago, I read that TikTok was the new Vine. I loved Vine, I’ve never laughed so hard watching those videos, so I installed TikTok and played with it for a while. I was amazed to see that kids were not the only demographic. It’s funny there are many videos where 40 something creators make fun of the kids because they are there to stay. I guess the younger crew thought they had exclusivity. Those days are gone.
After watching videos and learning how it works, I rolled the dice and made a 15-second video about how to respond to negative comments on YouTube. The next day I checked it and received 153 views, a few likes, and ten follows. My brand is nonexistent on TikTok. I’m a nobody, a grain of sand on the venue, and I received 153 views.
MY MIND WAS BLOWN. How is it that some random dude could get so many views from his first post? Obtaining this kind of exposure on YouTube would be impossible.
The next day I made two more videos. DAMN! Both received over 100 views, and more follows and likes came in. Making the videos takes minutes, and recording is super easy. Engagement is stronger than I thought. MY GOD! TikTok is incredible. Only creators who have been grinding, and toiling over their channel at YouTube could appreciate how easy TikTok is. There’s another benefit as well. When your video is finished, it takes you straight over to Instagram for a cross-post. Now I’m making content for two social media venues.
**THE BOTTOM LINE**
You know that feeling of dread you get when your precious video only receives a handful of views after producing it for hours. That feeling does not exist on TikTok.
Create a TikTok account now. Make sure your YouTube channel is tied to your account and start banging out 15-second videos. Over time it’ll push traffic to your YouTube channel. Stay in your within your niche.
Best wishes and good fortune.
SOURCE: u/tlo_oly
This is a case study documenting the progress and what I did to grow a channel from 0 subscribers to over 90,000 subscribers in 3 months. Below are a series of articles and notes I put together to document my thoughts, process, and strategy on how to accomplish this. YouTube is the second most trafficked website on the planet, next to Google, and there is massive opportunity waiting for those that can crack the system of ranking into the algorithm and create content that a massive amount of people want to consume. I wish you all the best and hope this adds value to you and your journey.

Grow Your YouTube Channel From Zero With The Right Strategy And Not Just “GETTING LUCKY”
Aside from luck, I think there needs to be strategy as well. YouTube won’t help you grow at all from my experience until you prove your audience and trust as a channel. YouTube has to know it wants to promote your content as a suggested video to an audience it can find key interests in.
I tried to figure out the best way to show YouTube what audience WANTS to see my content. So, quality counts there. You need to make content people actually want to see. The key metrics in that measurement is: 1. Click Through Rate and 2. Audience Retention (Watch Time). If you have a decent CTR which I believe is above 8% and a watch time of 5:00+ minutes per video, you are good from my communication with other larger channels.
Ok, so YouTube now knows you have good content that people want to see. Now they need to know you are a channel that it trusts with content. This just takes time and consistency. I recommend daily uploads, bi weekly uploads, weekly uploads, monthly uploads. This depends on the type of audience you have. Example, most gaming channels need to pop out daily videos to be competitive in the market with an audience that demands daily binge worthy content. A review channel or a channel that does comedy sketches that takes time to make, may be a bit more forgiving and come flood your video with views when it releases every month or two. So, that quantity and consistency really relies on what other popular channels are doing and what the audience expects for your type of content.
So, now you have a consistent upload schedule that YouTube can trust, you have a high audience retention rate showing YouTube you have binge worthy content that people want to see, now who is your audience YouTube needs to suggest your videos to?
You have to actively work to promote your content off of YouTube alongside utilizing YouTube’s features for your video to help target an audience naturally.
There are three ways I have come to find that work so far:
When it comes to Social Media:
As you can see, Instagram takes a lot of work, but if you are serious about it, put in the time and you will see returns on your effort. Of course you need to post to your account as well. Make posts about thanking them for follower goals, post clips of your videos, make announcements of your newly released videos. Your entire goal should be to push traffic to your YouTube channel in hopes of gaining new Subscribers and getting dedicated fans to view your content with high retention. Let the ego go of not trying to interact with people because you are a “big YouTuber to be”. Stay humble and interact with people and talk with them to build a bond with your fans. It goes a long way. You should always interact with your fans by responding to comments on posts and videos for as long as you can until your channel is so big that you physically can’t anymore. So, until that day comes, put in the effort to respond and thank people for everything.
This is my two cents on the subject. Hope it helps. This is all my opinion and is subject to be completely wrong. I just simply believe these to be the reasons for my stunted growth or growth in general.
The main things I learned:
You need to focus on making sure a relevant audience is targeted by YouTube for your channel overall. Once YouTube sees a high CTR and high audience retention, it starts to look for an audience. Once it figures out what kind of audience watches your content, it pushes your vids like crazy and the channel sees real growth.
I would say high CTR is over 10% and videos 10-15 minutes get over 5 min watch time averages for high audience retention.
Search results don’t seem to matter as much as they would seem. With traditional SEO for things like blogs and branded sites, it matters so much and I recommend tools like SEMrush to help with research. But for YouTube, videos seem to be hardly found through search when comparing the results of successful videos to the impressions YouTube just hands out to your video if the algorithm likes you content. And YouTube likes your content when you can keep people on their platform and engaged in their brand. This is done by getting people to see the impression of the Thumbnail and Title, clicking on it, and then staying for a long time and engaging with the content through liking, commenting, subscribing, clicking an end card, watching another video of yours or watching another recommended video (therefore not leaving the website). This keeps YouTube a dominate website and makes their bounce rate stats insane compared to other websites on the internet. This generates trust from companies to know they can feel comfortable dedicating massive amounts of money from marketing budgets towards this arm of their strategy. Therefore, the channel wins, YouTube wins, and advertisers win.
Results (Proof of Concept)
When I originally posted this Post I was at:
731/1000 Subscribers and 476/4000 hrs watch time (Requirements for Monetization)
Currently the channel is at 53,000 Subscribers and 479,000 hrs of watch time
I was able to post my first video on October 24, 2019 and got the official “Congratulations” email from YouTube on November 25, 2019 to be approved for the YouTube Partner Program.
Summary
Ideally you want your CTR to be as high as possible when the video first comes out (24-48hrs) this is critical as the higher the CTR and the higher the AR (audience retention) the more impressions you’ll get. If you get a 15-20% CTR that’s amazing, which is why I recommend trying to get over 15%. The more YouTube pushes the video with impressions, it’s natural for the CTR to drop. YouTube wants to push good videos as long as it can until the CTR gets burned down to low conversions. This is why videos get pushed for many months and sometimes even years.
The key is to make a Thumbnail that captivates the viewer and use a title that compliments the thumbnail, but try not to reuse text in the thumbnail in the description. Also, make sure you focus on keeping your audience retention as high as possible. I try to aim for 10+ minute videos and anything under 5 minutes for me is not good retention. My videos average around 6:30-7:30 minutes retention.
The key to high retention is making sure people click and don’t leave within 10 seconds because they see the video is really off from their expectation or there is not captivating reason to stay. Next, focus on first 69 seconds of the video. Your best stuff should be packed into the first minute of the video. If you have a decent intro that is good energy and captivating, you can use the rest of the first minute to put in the best content available for the video. Don’t be afraid to mix the video up, even out of original recorded order, to fit in the best stuff. Next, focus on keeping people from minute 1 through minute 5. Do this with keeping up with you audience expectations for your niche. What is it that other massively successful channels are doing? Take notes and study their content. Understand what they are doing and implement similar strategies and styles to make sure you are aligning with what has already been proven in the market to succeed for that targeted audience.
From there is just a game of uploading consistently and waiting on YouTube to kick in it’s magic and boost your channel. There’s 4 phases to YouTube’s algorithm:
YouTube sees your uploads are consistent and that the CTR and AR is high. Once this occurs, you will start to see YouTube views coming from Suggested. Once suggested happens, YouTube then sees if it can identify an audience that shares similar interests and if those suggested views garner the same CTR and AR. If the CTR and AR are good on the suggested views, YouTube then takes the audience it has identified to want to consume your content and the channel takes off pretty fast because you will start getting a ton of Browse Feature views. Once you get the Browse Feature views going, you are locked into the algorithm.
And from there is just posting consistently and keeping your CTR and AR high. The main thing I learned as well is that because YouTube needs to identify an audience, it’s important to make sure the content or niche you are targeting with your content stays very very similar in each video. Don’t get too much variety for the channel. Keep the theme and subject matter consistent. The moment you want to veer off into another area of interest or focus, it’s better to start another channel just for that.
I.
I believe it takes about 30-90 days to get a channel from zero to favored in the algorithm.
Basically the name of the game is:
The name of the game is to help YouTube make as much money as possible. This is done by keeping people on the platform for as long as possible to expose them to more opportunities to see ads. You do this and YouTube will reward you with tons of traffic and impressions.
II.
This is all you need to worry about:
III.
You want to help YouTube identify your audience, so here are some tricks:
In your description:
Put – “Inspired by [channel names of VERY VERY similar channels]”
Also add something like:
Check Out More Videos or More Awesome Videos
This will let YouTube know who your audience is related to, and if people click on these links it will show a common interest from the viewers and associate your content with these other videos and channels
Next, make a playlist:
Hot COD Vids [Or whatever you like lol]
Add Your Videos and Other Videos from channels you are trying to gain an audience from or have an audience identified from for your channel.
Put this playlist as an End Card in all your videos. People that click on these will see your video, another channel video, your video, another channel video (mix it up). And this will also tell YouTube that these viewers that watch your content want to see more of your content AND like other channels like yours. Over time YouTube will recognize this and start suggesting your videos to the right audience (the channels you are associating with).
Once you do this, if your content is good with high CTR and high AVD, YouTube will now know your audience (because you helped it figure it out) and you are in business.
IV.
You can grow with only YouTube. There is no need to post videos anywhere else. However, I have noticed that TikTok does not stunt organic reach like other platforms like Facebook and Instagram. So, the best thing that I’ve found is to grow organically on YouTube by understanding how the platform works and if you want, you can post clips on TikTok and get a lot of traffic and potentially subscribers.
However, YouTube is very particular about identifying audiences. So, if you are posting videos online and it’s driving traffic to your videos but the audiences are not right for the content and/or people are leaving very quick and the watch time is low, it will affect your channel overall and you will see slower growth and potentially even hurt the channel from growing at all.
Basically, ideally you want your CTR to be as high as possible when the video first comes out (24-48hrs) this is critical as the higher the CTR and the higher the AR (audience retention) the more impressions you’ll get. If you get a 15-20% CTR that’s amazing, which is why I recommend trying to get over 15%. The more YouTube pushes the video with impressions, it’s natural for the CTR to drop. YouTube wants to push good videos as long as it can until the CTR gets burned down to low conversions. This is why videos get pushed for many months and sometimes even years.
The key is to make a Thumbnail that captivates the viewer and use a title that compliments the thumbnail, but try not to reuse text in the thumbnail in the description. Also, make sure you focus on keeping your audience retention as high as possible. I try to aim for 10+ minute videos and anything under 5 minutes for me is not good retention. My videos average around 6:30-7:30 minutes retention.
The key to high retention is making sure people click and don’t leave within 10 seconds because they see the video is really off from their expectations or there is not captivating reason to stay. Next, focus on the first 60 seconds of the video. Your best stuff should be packed into the first minute of the video. If you have a decent intro that is good energy and captivating, you can use the rest of the first minute to put in the best content available for the video. Don’t be afraid to mix the video up, even out of original recorded order, to fit in the best stuff. Next, focus on keeping people from minute 1 through minute 5. Do this with keeping up with you audience expectations for your niche. What is it that other massively successful channels are doing? Take notes and study their content. Understand what they are doing and implement similar strategies and styles to make sure you are aligning with what has already been proven in the market to succeed for that targeted audience.
From there is just a game of uploading consistently and waiting on YouTube to kick in it’s magic and boost your channel. There’s 4 phases to YouTubes algorithm:
YouTube sees your uploads are consistent and that the CTR and AR is high. Once this occurs, you will start to see YouTube views coming from Suggested. Once suggested happens, YouTube then sees if it can identify an audience that shares similar interests and if those suggested views garner the same CTR and AR. If the CTR and AR are good on the suggested views, YouTube then takes the audience it has identified to want to consume your content and the channel takes off pretty fast because you will start getting a ton of Browse Feature views. Once you get the Browse Feature views going, you are locked into the algorithm.
And from there is just posting consistently and keeping your CTR and AR high. The main thing I learned as well is that because YouTube needs to identify an audience, it’s important to make sure the content or niche you are targeting with your content stays very very similar in each video. Don’t get too much variety for the channel. Keep the theme and subject matter consistent. The moment you want to veer off into another area of interest or focus, it’s better to start another channel just for that.
V.
Watch hours usually happen very quickly once things pick up. If you have a 5+ min AVD on a video and it gets thrown into the algorithm you need about 48,000 views. This can be accomplished with one video alone in a day or across a few decent videos that take in 10,000-20,000 views.
Focus on getting CTR and AVD as high as possible and keep an eye on if YouTube is trying to find you an audience. YouTube is looking for your audience with Suggested Views. The more content you give it, the more it will test audience groups. This is why uploading content a lot is good for growing quickly. You give YouTube more opportunities to search for your audience. This is also why you should stick with your niche and don’t switch up your content . You want YouTube to identify your audience and consistently get it right.
Create content for niches that get tons of traffic and that people want to consume. Get your CTR and AVD high. Pump out content as much as you can. Become a content creating machine. Watch your KPIs and see where you can improve. Watch for YouTube suggesting your content and where they are suggesting and what the results are. Then be patient and upload consistently if everything is looking good.
If your CTR and AVD are not good, youtube won’t even try to find you an audience because it has no incentive to. YouTube makes money when people stay on the website for as long as possible. If your content can’t keep people on the platform, youtube has no interest in helping your channel grow.
If you can keep people on the platform with great content, youtube has a massive incentive to find your content a home with the proper audience and it will continually reward you as long as you feed the system what it needs to make its platform the best experience as possible for its user base and make the platform a ton of money by keeping people on the website.
VI.
You do not need to post anywhere else to grow on YouTube. YouTube has an algorithm that works and if you hit your KPIs, the system will reward you. YouTube is designed to take underrated content and blow it up, along with promoting already proven content.
In fact, promoting on other platforms may or may not hurt your growth. YouTube builds a profile to figure out your audience. If you promote on say a Reddit forum and people go watch it, YouTube will build a profile around those viewers and try to recommend your content to what THOSE viewers are interested in. If they are irrelevant to your niche, YouTube will then have the wrong data to work with because you fed the algorithm bad information by bringing in irrelevant traffic to your channel/videos.
The title is the first thing users see when they find your content. And if it isn’t punchy, it might be the last. Here are some basic tips for writing strong YouTube titles: Keep it short and sweet. The most popular YouTube videos tend to have the shortest titles. Stick to 60 characters or less or some of your title may get cut off when displayed. Include your keyword(s) in the first half of the title to avoid losing valuable information. Most online readers focus on the beginning of the sentence and skip the rest. Engaging doesn’t mean clickbait. The best headlines offer an obvious benefit or create an emotional reaction. Clickbait is tempting, but can damage your channel’s reputation in the long term. Still can’t come up with a title? YouTube’s autocomplete feature is a great way to find popular keywords. Start by searching for a particular theme or topic, and see what title YouTube suggests.
TIK TOK IS GREAT FOR PROMOTING!!!
I see a lot of people on here asking where to promote their videos. There’s truly only one answer. Tik Tok. I know what most of you are thinking. Isn’t Tik Tok that cringey dancing app? NO! Believe me I didn’t like the idea of Tik Tok until I got into it for promoting my YouTube channel. I LITERALLY AMASSED OVER 1700 FOLLOWERS IN 2 DAYS!!! The algorithm is ridiculously good. Just put good effort into your tik toks. The community is great. And to make matters better… YOU CAN LINK YOUR YOUTUBE CHANNEL RIGHT ON YOUR PROFILE! I can’t express enough how much this app has surprised me. Give it a try! Its 100% worth it!
We all know that just one viral video can give a huge boost to a channel and get it of the ground and even launch it into the sky.
And for a small channel a viral video doesn’t have to have millions of views, even just a few tens of thousands are a game changer.
One way you can create a video like this, is something I did by accident, and it helped me go from a channel of a few hundred subscribers to a few thousands in less then a month.
So that is enough for the intro, here is the main point:
Find a potentially viral subject, event, idea, trick, tip etc. in a non English language, do it in English and post on your channel while promoting in places that are relevant to that subject.
Now how this worked out in my case:
I run a gaming channel, started in 2011. about a single PC video game. Then after a launch of a new, very popular game, I started making videos about it and researching it’s game-play for more video ideas. I ran across a video in Japanese showing how something could be done which was not enabled in the game by the developers but could be done under certain specific conditions. I saw that is was really useful and after more experimentation found even more uses for it. Then I made a 20+ minute video about it and posted it on the official forums for the game.
The first two days I got a relative spike in views, but nothing amazing. Then, as players started to share my video it exploded to thousands of views a day, and because I had other video about this game, I gained over a thousand subscribers just in the next few weeks. Later the subject of the video was made obsolete by the developers update for the game but 6 years later and that video is still getting views, it’s almost up to 300,000 with YouTube suggesting it 20% of those views, another 20% from search and 20% from browse.
It might seem like a cheap way of making a viral video and using someone else’s idea but how many of you speak Japanese, and how many times did YouTube recommend you a video in a foreign language besides English?
Videos in other languages are a gold mine of information and ideas but the language barrier is just too large.
So, that is my tip for you today. I hope you are able to use it. Good luck!
I was thinking about my journey as a web novel author and how it shares a lot of similarities with my YouTube journey.
I’ve been writing years and slowly writing/uploading new chapters for people to read. It started with me having a horrendously depressing day and needing an outlet for all the dark negative thoughts going through my head. I decided to take what was inside of my body and pour it into my computer. My first chapter was over 8,000 words but by the end of it, I felt immensely better about myself. Then I just kept writing new chapters.
It was a nice feeling seeing people read my work and comment below the chapter. After several chapters, I got my first review which was great. As I continued to write, I began getting a varying degree of comments/reviews/DMs from people who either hated or loved my work. I kept writing new chapters. I got reviews saying how my work was like an adolescent’s wet dream or some other negative thought, but I kept writing new chapters. Sometimes, I’d crawl into bed because of the comments and reviews but it wouldn’t be long before I would continue writing new chapters.
Years passed by and I found out I’d written over 500,000 words (a combination of writing the chapter and editing them). In my analytics for the site, I’d had over 1,000,000 accumulated views and reached the top 10 for active series on the site (I dropped down to #~3,000. T^T). But I kept typing new chapters. I’ve had people comment about their surprise to see I’m still writing my web novel series.
Then in 2018, I came up with the idea of narrating my story and uploading the chapters onto YouTube. Just like with writing out my chapters, I had people tell me that I had no business on YouTube. I was told my accent is too strong or I suck at narrating my work, but I keep uploading new chapters. I’ve also received DMs from people who told me they were die-hard fans of my videos and love the story.
Just like with writing, though I don’t have an impressive number of views, subs, or watch-time, I know that it’s just about uploading new videos. The same as when I realized I had written ~500,000 words, I know I’ll get to 1,000 videos (maybe even 10,000) and I’ll just continue uploading new videos.
Crossing a mountain is intimidating, but if you remove a grain of dirt and keep going you’ll eventually remove your obstacle and reach your goal. There may be various strategies shared on YouTube, related to SEO, thumbnails, titles, and etc, but everything boils down to keep making videos and having the intent to improve your skills with each one. It may take 1,000, 10,000, or even 100,000 videos, but if you keep at it then you’ll reach your goal.
Source: https://www.reddit.com/r/NewTubers/comments/es4dsn/just_keep_uploading_videos_and_youll_get_there/
Thumbnails and Tags are the gateway to your videos. Thumbnails are very important because they are the first thing viewers see before clicking your video, and their purpose is to attract people and make them watch the video.
So thumbnails must be:
1.Suggestive and describing in images what viewers are about to see.
2. Recommended resolution is 1280×720 (if your image dont have this resolution you can use online free tools to resize it, but be aware to mantain quality and ratio).
3. Don’t use small or misleading texts in your thumbnails, viewers must easily see what is in the image.
4. Before you set TAGS, you can search on youtube & google to see the most relevant and popular searches. From there you can take keywords and use them as tags.
5. Don’t use tags that are not describing your content!
6. Before setting tags above the title, search them of youtube to see how many results you get. If your tags don’t show popular videos in search results then it wont bring you many viewers.
Good Luck!
Hi everyone, I’ve learned a lot from this subreddit, so I wanted to give back and share a few things that have helped my channel.
My watch time and views on youtube have been improving so much in the past few months and it’s all because of three things: SEO, better thumbnails, and better titles. For me improving on these three elements is key for consistent growth month over month. I’d love to get lucky and get massively recommended by the algorithm, but so far it hasn’t happened.
For thumbnails what works on my channel is big, and I mean, BIG titles. Taking up half of the screen or more and words that will spark curiosity. Make sure your thumbnails are readable and eye-catching in the smallest size possible (I couldn’t find the exact measurement, but it is the size of the suggested videos thumbnails when you’re watching in the YT app). I also try to use aesthetically pleasing photos, enhanced bright colors in the photo (I started editing my thumbnail photos with lightroom, too and use presets that enhance the colors – you can find free or cheap presets online and the lightroom app is free)
Using close ups of my face if possible or prominently showing the product if a product review has led to higher CTR. Also, using consistent fonts – I only use 3 fonts on my channel in different combinations.
For titles: half of my title is SEO friendly – I run it through TubeBudy (free version) to see if it is searched enough and what the competition is (aka my chance to rank); the second part of the title is a bit more directed to making viewers interested, I try to make it a little more sensational.
I also make my video descriptions super SEO friendly – I find all the tags that are searched enough and that I can potentially rank for and write a copy that naturally uses as many of them as possible.
By no means am I saying that I’ve cracked the code to youtube success and perfected these techniques, but doing these things has definitely made a difference in my channel. Hope it’s helpful to someone.
Most people don’t understand online automation. They don’t even realize that almost all their cyber-chores can be automated inexpensively. They think that Automation is too expensive and/or meant for larger enterprises. But fact is if any part of your business depends on the internet (And let’s face it, this is 2018. Everything does) chances are automation can save you a lot of time. Whether it’s automatically processing orders, keeping an eye on your competitors or just some cyber-chores.
Disclosure: I own two small businesses and also work as a freelance automation developer. Both of my businesses are highly automated and I’ve helped over 30 clients save more than a combined 100+ hours every day.
It’s hard to explain exactly what can be automated so I’ll instead give you an intuition by giving you a few examples:
Online car rental – One of my clients rented out cars via several online car rental websites. Each day he’d log into each website, browse various pages (Some websites with multiple accounts) and create an Excel spreadsheet of all the cars that have been booked, updated locations of each car etc. This took him about 1-2 hours per day. For $300, he now gets an updated spreadsheet in his Google Drive every 30 minutes with no action required by him.
Form generation – Another SMB client provided legal services. They would access data from an Excel sheet, fill it out on a PDF form then print it and mail it to a government office. He would then track the application online on their website to know the status of the application every day. Now a script automatically reads the Excel sheet, fills and prints out the form and also automatically tracks the status of every application and updates it in another Google Drive sheet.
Competitor watch – Another client had to check their competitor’s e-commerce websites regularly to keep an eye on their prices, this took them about 3-6 hours of work every week. Instead they now have a script that E-Mails them every time a price change is detected on a competitor’s website within 5 minutes of the price change happening.
This should give you an intuition for the kind of things that online automation can do for you. If you have any questions feel free to comment and I’ll try to give you as thorough an answer as possible!
Most projects i work on have little to no maintenance cost. It’s usually a script that you run on your computer, you just click it on it and watch it do it’s magic.
Maintenance costs may come in one of two ways:
Kofax, Connotate and Mozenda are three service-based automation SaaS-based products that anyone, including non-technical people, can use to build and execute automation scripts to run on a schedule, on demand or as a part of an “if-this-then-that’ workflow. As a person who has built automation software as a part of my business for the last 8 years, these services are impressive, cost-effective and reliable for the average use case. Plus, they are massively parallel and include built-in IP masking as well as a simple user interface to design and maintain scrape templates.
I have no affiliation with any of these services but just passing it along as it’s something I had considered at one time or another.
An addendum as well: In probably 80% of the cases I’ve seen, Excel is not the right tool for the job for any given data needs. Spending a little on a database architect to properly come up with a plan to store your data can save you tons of time down the road. It makes automating tasks that involve your data even easier to implement. Source: I’m a database architect.
I’m by no means a database architect, but I’m a competent user of Access. I watch some of our data analysts build huge Excel spreadsheets with all sort of complexity, essentially trying to recreate database functionality in a spreadsheet. It takes forever, is prone to errors, and incredibly difficult to audit. The same task in a database takes seconds.
MS Access is my dirty little secret. I throw data into a database, analyse it, and spit out the results in minutes rather than days. No one else around me is familiar with access, and they’re blown away by how quickly I can do the number crunching and come up with a compelling story about what the data means.
So people usually use Excel for everything from storing data, munging, doing pivots, joins, and data visualizations. Often times, I see a single spreadsheet contain multi-dimensional data (e.g. they have cells A1:E40 as a ‘table’, G2:G30 as another ‘table’, etc.) and then similar data from the pull from 6 months ago will be in a separate Excel file with similar, but different storage convention.
A much better approach would be to store everything in a normalized format such that there is no redundancy. For example, if you are looking at survey data, you would ideally put all of your questions in one table, people in another table, and then a third table that joins the questions, people, and answers together. By doing this, you can easily compare, say, the same persons answer from the last 6 months instead of needing to go into two spreadsheets, figure out how both of them store the data, and then manually determine which questions they answered, etc. etc.
You don’t even need anything complicated to do this either. While you can setup a database like PostgreSQL (free), you could also use database containers like SQLite or a hybrid like Access (if the data are <2GB) or LibreBase.
That said, there are situations where Excel is great. Quick and dirty munging is where it excels (pun intended) at in particular. The import process into say, SQLite takes like 30 seconds to go through all the steps. In Excel, that process can be like, seconds. So if you’re doing a simple, add columns 1 and 2 together and that’s all, Excel definitely wins. BUT the cool part about Excel is that if you aren’t using it for data storage, you can still use it to access your data, which gives you the best of both worlds.
As far as visualization tools are concerned, it’s fine. Again, quick and dirty. PowerBI (also MS product) makes better visualizations, especially if the data are more complicated. Tableau makes better live visualizations (embedded, interactive visualizations are possible very easily). And something like Matplot (Matplotlib in Python) gives you much more fine grained control over the appearance of your visualizations. But the latter three have more of a learning curve too.
All about the right tool for the job, which sometimes Excel can be, but there are so many great technologies that are out there that do things better than Excel it’s definitely worth it to branch out!

Yes. Python can do pretty much everything. Reddit is written in Python, for example. Python is also the most popular language for machine learning and data science. You can even program some of the more powerful microcontrollers with it. For automation in particular, the book Automate the Boring Stuff is highly recommended, though I haven’t read it myself. There’s also r/learnpython.
Be careful of the split between Python 2 and Python 3; not everyone was eager to update when 3 came out, so some libraries only support 2. On the other hand, some only support 3. Everyone’s gradually moving toward 3, so that’s what you should start with as a newcomer, so that you don’t have to switch to 3 after learning 2 (not that the differences are huge).
Interpreted vs. compiled and scripting vs. ‘real programming’ aren’t really meaningful distinctions anymore, if they ever were.
Screen scrapers to monitor competitors’ pricing, applications for automating tasks that were repetitive and monotonous (and therefore highly prone to user error), etc. It cannot be overstated just how much time can be saved through automating the simple little things.
For simple tasks I used to just write the scrapers in C#. For more complicated actions I used the iMacros API (I wouldn’t recommend it). These days I just use CefSharp for the complicated stuff.
I’d like to talk about a client who worked hard for their business. 10 hours a day! Their job? They would scour over 14 different mediums for trade alerts (Alerts for potentially good trades). These 14 were through different services. Some were over E-Mail, some over SMS, some on Slack chatrooms and others posted on websites.
Their day job was to filter through these alerts, find the most worthwhile ones and forward them on to their own users. On top of this they’d end up spending 1-2 hours a day just managing overhead. Subscriptions, adding them to their own E-Mail, SMS lists, verifying that the people already on the lists have paid for their subscription etc. Quite a tiresome process!The automation
One problem with the automation here was that the client needed to hand-pick the alerts that finally went out. They couldn’t provide a simple algorithm to do it, their customers were paying for 20 years of experience!
The job was simple. Build a bot that automatically: Reads E-Mails, SMS, Slack channels & constantly updating websites. Okay, maybe not so simple. An algorithm would then filter out the worst of these leads based on a few objective criteria. This’d eliminate about 70-80% of the alerts.
For the rest? They would get a notification on their mobile phone. The notification would have an ‘accept’ and ‘reject’ button right there in the notification bar. Accept it and the alert is forwarded to all their subscribers.
Their entire subscription management was also automated. A script would automatically add & remove subscribers and verify payments received.Lessons learned
Many of the times i work with clients, i end up automating 10-30% of their workload. Maybe some tool that allows them to pursue a new line of work that was previously too time consuming. Rarely do i have the opportunity to automate 80-90% of the work!
With one tool, this man got his life back. An entire workday spent monitoring different websites, E-Mail, slack and SMS changed to just going about your day and responding to mobile notifications every 5-10 minutes (Remember, most of the alerts are automatically filtered out, only a few actually go to him for review).
That’s the real power of automation. It gives you your life back. One day you’re working hard on your business. The next day you’re thinking hard about your next side hustle. Automation doesn’t just give you wings, it gives you an entire jet engine. Think hard about how much work you do for your business. Unless it requires that ‘insight’ garnered over years of experience, i could probably automate it. And even if it does, automation can take away most of the work as in this example.
I’m going to blast through some of the best advice I can give to you in a few (thirty) minutes. In 2019 I did 0-46,000 in 8 months, 3M+ views and $16,000.00 from scratch. I’ve commented on hundreds of threads, but wanted to go off the deep end and type for a bit. Aiming for 150,000 subscribers by the end of 2020, and a full-time years pay. I want everyone to have that same opportunity! Wont be plugging a link to my channel, because that’s NOT the goal of this thread.
If anyone has questions, aside from the typical “I’m not growing, what do I do?”, feel free to ask below and I’ll get to everyone! Sorry for the long read, hopefully you can take something away from it.
Best of luck w/ your success in 2020, let’s make it a good year.. If you have anything to add, feel free to chime in below:
Source: https://www.reddit.com/r/NewTubers/comments/en3w9o/my_best_advice_allinone_post/