Website Location Pages

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

TYPE OF WORK

Gig

SALARY

$7.00-9.00 hour depending on experience.

HOURS PER WEEK

TBD

DATE UPDATED

Feb 18, 2025

JOB OVERVIEW

For website location "service area" pages. Update Google Spreadsheet with specific location information including, demographical, weather, and buyer intent keywords associated with the roofing industry. The use of AI tools are encouraged but want content to come across the user in a "casual" language tone. The task usually takes me 10-15min per location to complete, I think 15-20 min per location is reasonable. I have 59 locations, so thinking this gig will be 15 to 20 hours to complete. I will provide an example and share spreadsheet.

SKILL REQUIREMENT
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0009
Controller Execution Time ( Jobseekers / Job )  0.0178
Total Execution Time  0.0194
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,487,008 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Website-Location-Pages-1318258
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0097 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0005   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1318258
 LIMIT 1 
0.0009   SELECT *
FROM `employers`
WHERE `employer_id` = 778377
 LIMIT 1 
0.0009   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1318258
AND `misc`.`idIS NULL 
0.0006   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-09-21',ej.date_added) duration_daysDATEDIFF('2026-09-21',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-21',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1318258' 
0.0008   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1318258 
0.0008   UPDATE employer_jobs SET hit_counts '***Feb-18-2025=106***Feb-19-2025=19***Feb-20-2025=11***Feb-21-2025=7***Feb-22-2025=5***Feb-23-2025=2***Feb-24-2025=2***Feb-25-2025=3***Feb-26-2025=1***Feb-27-2025=3***Feb-28-2025=1***Mar-01-2025=1***Mar-05-2025=4***Mar-06-2025=1***Mar-13-2025=1***Mar-18-2025=1***Mar-19-2025=1***Mar-24-2025=1***Mar-25-2025=3***Mar-27-2025=4***Mar-30-2025=4***Apr-04-2025=1***Apr-06-2025=1***Apr-07-2025=1***Apr-08-2025=2***Apr-11-2025=1***Apr-15-2025=2***Apr-30-2025=2***May-04-2025=3***May-07-2025=5***May-13-2025=1***May-15-2025=2***May-23-2025=1***May-24-2025=1***May-28-2025=3***Jun-28-2025=1***Jun-29-2025=2***Jul-01-2025=2***Jul-02-2025=1***Jul-09-2025=1***Jul-16-2025=2***Jul-23-2025=1***Jul-29-2025=1***Jul-31-2025=2***Aug-23-2025=1***Aug-29-2025=1***Sep-08-2025=2***Sep-11-2025=1***Sep-19-2025=2***Sep-20-2025=1***Sep-28-2025=1***Oct-03-2025=1***Oct-05-2025=1***Oct-06-2025=1***Oct-10-2025=1***Oct-12-2025=1***Oct-24-2025=1***Oct-28-2025=2***Oct-29-2025=1***Nov-02-2025=2***Nov-10-2025=1***Nov-17-2025=2***Nov-18-2025=2***Nov-29-2025=1***Dec-05-2025=1***Dec-10-2025=1***Dec-23-2025=1***Dec-28-2025=2***Dec-29-2025=1***Dec-30-2025=1***Jan-07-2026=1***Jan-08-2026=2***Jan-10-2026=1***Jan-19-2026=3***Jan-22-2026=2***Feb-02-2026=3***Feb-09-2026=1***Feb-11-2026=1***Feb-18-2026=1***Mar-15-2026=1***Mar-23-2026=1***Mar-27-2026=2***Apr-09-2026=1***Apr-21-2026=2***Apr-25-2026=1***Apr-26-2026=9***Apr-29-2026=2***Apr-30-2026=1***May-01-2026=1***May-11-2026=2***May-12-2026=1***May-17-2026=2***May-31-2026=1***Jun-14-2026=2***Jun-20-2026=1***Jul-01-2026=1***Jul-04-2026=1***Jul-23-2026=1***Jul-24-2026=1***Jul-28-2026=1***Jul-31-2026=1***Aug-01-2026=1***Aug-02-2026=1***Aug-28-2026=1***Sep-03-2026=1***Sep-11-2026=1***Sep-21-2026=2' WHERE job_id'1318258'  
0.0006   UPDATE employer_jobs SET monthly_hits '***Feb-2025=160***Mar-2025=21***Apr-2025=10***May-2025=16***Jun-2025=3***Jul-2025=10***Aug-2025=2***Sep-2025=7***Oct-2025=9***Nov-2025=8***Dec-2025=7***Jan-2026=9***Feb-2026=6***Mar-2026=4***Apr-2026=16***May-2026=7***Jun-2026=3***Jul-2026=6***Aug-2026=3***Sep-2026=4' WHERE job_id'1318258'  
0.0020   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1318258' 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` = 1318258 
0.0013   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '778377'
AND `date_added` >= '2022-06-08' 
0.0003   select from teasers 
0.0003   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)