I have a list of 500 UK businesses in a Google Sheet and would like to find out how active they are on YouTube and social media.
Here is the spreadsheet: https://docs.google.com/spreadsheets/d/1TSnF4x1pYEpnK2kaoDt482nU-79hdLJnJAQZLKZ1UEQ/edit?usp=sharing
The spreadsheet has all the information you need to work from and just requires a simple 'Yes' or 'No' in each box.
Step 1 - Enter the company name and town into Google to find their website. If so, navigate to see if they have a video on their website. Check the landing page and maybe one other page. Step 2 - Enter the company name into YouTube to see if they have any video content on YouTube. Anything related to the business is fine. Then check to see if they have a YouTube channel. Step 3 - Use Google to quickly see if the company has a social media presence on Facebook, Instagram or Twitter.
Here is a quick walkthrough to show you how to do it. https://www.youtube.com/watch?v=bXnkHI_yV28&feature=youtu.be
I will spot check the results during the work to ensure accuracy, so do get in touch with any questions at any point if you are unclear on what is required.
