Coefficient.io Expert to handle Salesforce tasks and daily support. Long-term remote role. **Apply now to join our team!" />

Coefficient.io Expert

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

TYPE OF WORK

Any

SALARY

$1500

HOURS PER WEEK

40

DATE UPDATED

Sep 24, 2024

JOB OVERVIEW

We use Salesforce and need to push this data onto a report for the MD, Managers, Team Leaders and Staff so they can track their KPIs and Metrics. We have sourced ---------- as a suitable software to pull this data and now require someone to build this out.

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