Social Media Manager/Data scraper

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Part Time

SALARY

3/hour

HOURS PER WEEK

20

DATE UPDATED

Aug 18, 2026

JOB OVERVIEW

I want someone who is very good at following directions, generating workflows, finding data, and generally intelligent and smart.


Test Task: Following directions, 15 min

Create a spreadsheet containing exactly 11 rows.

Find 5 NYC bars and include these columns in exactly this order:

Restaurant | Neighborhood | Cuisine | Google Rating | # Reviews | Price | Google maps link | Website

Requirements:

Google rating ? 4.0
Manhattan only
Open past 11pm
Has Couches where two people can sit next to each other.
Sort from highest to lowest number of reviews
Highlight the 3 restaurants that seem the best fora. date


If you pass the test I will hire you.

SKILL REQUIREMENT
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0008
Controller Execution Time ( Jobseekers / Job )  0.0141
Total Execution Time  0.0155
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,482,472 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Social-Media-ManagerData-scraper-1711262
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0071 seconds)  (Hide)
0.0004   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0004   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1711262
 LIMIT 1 
0.0005   SELECT *
FROM `employers`
WHERE `employer_id` = 966175
 LIMIT 1 
0.0010   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1711262
AND `misc`.`idIS NULL 
0.0006   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-09-09',ej.date_added) duration_daysDATEDIFF('2026-09-09',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_jobs ej WHERE e.employer_id ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-09-09',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1711262' 
0.0004   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1711262 
0.0009   UPDATE employer_jobs SET hit_counts '***Aug-18-2026=667***Aug-19-2026=109***Aug-20-2026=36***Aug-21-2026=15***Aug-22-2026=8***Aug-23-2026=6***Aug-24-2026=33***Aug-25-2026=7***Aug-26-2026=3***Aug-27-2026=7***Aug-28-2026=4***Aug-29-2026=5***Aug-30-2026=3***Aug-31-2026=1***Sep-01-2026=5***Sep-02-2026=6***Sep-03-2026=10***Sep-04-2026=2***Sep-05-2026=2***Sep-09-2026=1' WHERE job_id'1711262'  
0.0007   UPDATE employer_jobs SET monthly_hits '***Aug-2026=903***Sep-2026=26' WHERE job_id'1711262'  
0.0008   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1711262' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1711262 
0.0004   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '966175'
AND `date_added` >= '2022-06-08' 
0.0004   select from teasers 
0.0003   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)