Data Analyst for Product Usage & Reporting

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

TYPE OF WORK

Gig

SALARY

PHP 25,000–50,000 per month (project-based, dependent on scope and timeline).

HOURS PER WEEK

TBD

DATE UPDATED

Jan 16, 2025

JOB OVERVIEW

About Us
QCard Enterprise is a digital business card company revolutionizing the way businesses and professionals connect. Using cutting-edge technology, we provide innovative solutions for networking and seamless profile sharing. We are seeking a Data Consultant to assist with a specific project aimed at improving our data analysis, reporting, and insights.

This is a one-time consulting gig, with the possibility of future collaboration or even a permanent role depending on the project's success and our evolving needs.

Project Overview
The goal of this project is to analyze product usage data using Mixpanel and streamline reporting processes across multiple platforms, including Apollo, LinkedIn, email tools, and ClickUp. The consultant will help us answer key questions about user behavior, retention, and industry-specific trends while creating intuitive dashboards and exportable reports.

Key Deliverables

Mixpanel Analytics

Analyze and interpret product usage trends, user behavior, and retention patterns.
Define and categorize user activity levels (e.g., inactive, low active, active, super active) on a weekly basis and over extended periods (e.g., 3-6 months).
Build dashboards and reports to visualize:
Card activation rates and trends over time.
Usage trends by user levels and industries.
Leaderboards showcasing the most active users across QCard and specific companies.
Total activity graphs displaying user trends over time.
Investigate drop-offs in usage (e.g., after the first week or month) and identify variations by industry.
User Behavior Insights

Evaluate user preferences for scanning methods and profile sharing.
Identify key industries showing sustained or high usage.
Determine common traits of users with consistent engagement.
Reporting & Integration

Export and analyze data from platforms like Apollo, LinkedIn, email tools, and ClickUp.
Develop workflows to consolidate data into comprehensive Excel reports.
Create and document an automated reporting system for ongoing use.
Data Presentation

Design dashboards offering quick snapshots of user activity (e.g., weekly active users, super active users over 90-120 days).
Ensure visualizations are actionable and align with business goals.
Requirements

Technical Expertise:

Proficiency with Mixpanel or similar analytics platforms.
Advanced Excel skills, including pivot tables, data visualization, and automation.
Familiarity with Apollo, LinkedIn reporting, and email analytics tools.
Experience with task management tools like ClickUp for data tracking and reporting.
Consulting Skills:

Proven ability to deliver high-impact results within a limited timeframe.
Strong communication and organizational skills to collaborate effectively with our team.
Preferred Qualifications

Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.
Background in SaaS, digital platforms, or tech industries.
Familiarity with analyzing user behavior in B2B or B2C contexts.

Project Details

Duration: Depending on project scope and deliverables.
Compensation: Competitive and based on experience.
Future Potential: While this is a one-time consulting project, there is a possibility for future collaboration or a permanent role based on performance and company needs.

How to Apply
If you’re passionate about leveraging data to drive actionable insights and have the expertise to deliver impactful results, we’d love to hear from you. Submit your resume and a brief proposal outlining your approach to Mixpanel analytics and cross-platform reporting.

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Jobseekers / Job )  0.0207
Total Execution Time  0.0220
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,527,128 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Data-Analyst-for-Product-Usage-Reporting-1297125
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0151 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0014   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1297125
 LIMIT 1 
0.0009   SELECT *
FROM `employers`
WHERE `employer_id` = 368243
 LIMIT 1 
0.0018   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1297125
AND `misc`.`idIS NULL 
0.0006   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 '1297125' 
0.0008   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1297125 
0.0016   UPDATE employer_jobs SET hit_counts '***Jan-16-2025=114***Jan-17-2025=95***Jan-18-2025=37***Jan-19-2025=35***Jan-20-2025=39***Jan-21-2025=33***Jan-22-2025=28***Jan-23-2025=6***Jan-24-2025=14***Jan-25-2025=6***Jan-26-2025=4***Jan-27-2025=9***Jan-28-2025=5***Jan-29-2025=3***Jan-30-2025=7***Jan-31-2025=9***Feb-01-2025=7***Feb-02-2025=9***Feb-03-2025=4***Feb-04-2025=10***Feb-05-2025=12***Feb-06-2025=7***Feb-07-2025=7***Feb-08-2025=2***Feb-09-2025=4***Feb-10-2025=4***Feb-11-2025=4***Feb-12-2025=2***Feb-13-2025=2***Feb-14-2025=1***Feb-16-2025=10***Feb-17-2025=4***Feb-18-2025=2***Feb-19-2025=2***Feb-20-2025=5***Feb-21-2025=4***Feb-22-2025=2***Feb-23-2025=2***Feb-24-2025=7***Feb-25-2025=5***Feb-26-2025=4***Feb-27-2025=2***Feb-28-2025=6***Mar-01-2025=3***Mar-02-2025=6***Mar-03-2025=5***Mar-04-2025=4***Mar-05-2025=4***Mar-06-2025=3***Mar-07-2025=3***Mar-08-2025=2***Mar-09-2025=1***Mar-11-2025=4***Mar-12-2025=7***Mar-13-2025=2***Mar-14-2025=9***Mar-15-2025=2***Mar-16-2025=3***Mar-17-2025=3***Mar-18-2025=8***Mar-19-2025=6***Mar-20-2025=11***Mar-22-2025=5***Mar-23-2025=4***Mar-24-2025=3***Mar-25-2025=6***Mar-26-2025=4***Mar-27-2025=8***Mar-29-2025=4***Mar-30-2025=2***Mar-31-2025=3***Apr-02-2025=5***Apr-03-2025=3***Apr-04-2025=4***Apr-05-2025=3***Apr-06-2025=2***Apr-07-2025=5***Apr-08-2025=4***Apr-09-2025=1***Apr-10-2025=1***Apr-11-2025=1***Apr-13-2025=1***Apr-14-2025=2***Apr-15-2025=1***Apr-16-2025=2***Apr-17-2025=7***Apr-18-2025=3***Apr-19-2025=2***Apr-21-2025=1***Apr-22-2025=1***Apr-23-2025=4***Apr-24-2025=1***Apr-25-2025=1***Apr-26-2025=1***Apr-27-2025=2***Apr-29-2025=1***Apr-30-2025=2***May-01-2025=2***May-02-2025=1***May-05-2025=2***May-06-2025=1***May-07-2025=1***May-08-2025=3***May-09-2025=2***May-11-2025=2***May-15-2025=4***May-17-2025=1***May-18-2025=1***May-20-2025=1***May-21-2025=2***May-22-2025=9***May-23-2025=2***May-24-2025=1***May-25-2025=1***May-26-2025=1***May-27-2025=1***May-28-2025=4***May-29-2025=1***May-30-2025=2***Jun-01-2025=1***Jun-02-2025=2***Jun-03-2025=1***Jun-04-2025=1***Jun-05-2025=4***Jun-08-2025=1***Jun-09-2025=3***Jun-11-2025=2***Jun-12-2025=1***Jun-13-2025=1***Jun-15-2025=1***Jun-16-2025=1***Jun-18-2025=1***Jun-19-2025=2***Jun-20-2025=3***Jun-21-2025=2***Jun-22-2025=1***Jun-23-2025=5***Jun-24-2025=3***Jun-26-2025=1***Jun-27-2025=3***Jun-28-2025=1***Jun-30-2025=1***Jul-01-2025=4***Jul-02-2025=1***Jul-04-2025=1***Jul-05-2025=1***Jul-06-2025=1***Jul-07-2025=3***Jul-08-2025=2***Jul-09-2025=5***Jul-10-2025=2***Jul-11-2025=1***Jul-13-2025=1***Jul-14-2025=2***Jul-15-2025=3***Jul-16-2025=2***Jul-17-2025=4***Jul-18-2025=1***Jul-19-2025=1***Jul-20-2025=2***Jul-23-2025=7***Jul-24-2025=2***Jul-25-2025=2***Jul-26-2025=1***Jul-27-2025=2***Jul-28-2025=2***Jul-29-2025=2***Jul-30-2025=1***Jul-31-2025=2***Aug-03-2025=1***Aug-04-2025=6***Aug-05-2025=4***Aug-07-2025=3***Aug-08-2025=1***Aug-09-2025=1***Aug-10-2025=1***Aug-11-2025=2***Aug-12-2025=5***Aug-13-2025=1***Aug-14-2025=12***Aug-15-2025=5***Aug-16-2025=1***Aug-17-2025=2***Aug-19-2025=5***Aug-20-2025=1***Aug-21-2025=7***Aug-22-2025=3***Aug-23-2025=3***Aug-24-2025=3***Aug-25-2025=3***Aug-26-2025=1***Aug-27-2025=2***Aug-28-2025=1***Aug-29-2025=4***Aug-31-2025=3***Sep-01-2025=4***Sep-02-2025=1***Sep-05-2025=2***Sep-07-2025=1***Sep-08-2025=1***Sep-09-2025=2***Sep-10-2025=3***Sep-11-2025=1***Sep-12-2025=3***Sep-13-2025=1***Sep-15-2025=1***Sep-16-2025=1***Sep-17-2025=4***Sep-18-2025=2***Sep-20-2025=1***Sep-21-2025=2***Sep-22-2025=3***Sep-23-2025=4***Sep-24-2025=1***Sep-25-2025=1***Sep-26-2025=2***Sep-27-2025=2***Sep-28-2025=4***Sep-29-2025=2***Oct-01-2025=1***Oct-03-2025=4***Oct-04-2025=2***Oct-05-2025=4***Oct-06-2025=2***Oct-07-2025=2***Oct-08-2025=2***Oct-09-2025=2***Oct-10-2025=2***Oct-11-2025=5***Oct-12-2025=1***Oct-13-2025=2***Oct-14-2025=1***Oct-15-2025=3***Oct-16-2025=2***Oct-17-2025=1***Oct-18-2025=3***Oct-19-2025=4***Oct-20-2025=3***Oct-21-2025=1***Oct-22-2025=3***Oct-23-2025=4***Oct-25-2025=6***Oct-26-2025=3***Oct-27-2025=2***Oct-28-2025=4***Oct-29-2025=1***Oct-30-2025=1***Oct-31-2025=4***Nov-01-2025=2***Nov-02-2025=2***Nov-03-2025=2***Nov-04-2025=3***Nov-06-2025=1***Nov-07-2025=1***Nov-08-2025=2***Nov-09-2025=1***Nov-10-2025=1***Nov-12-2025=1***Nov-13-2025=1***Nov-16-2025=1***Nov-18-2025=2***Nov-19-2025=2***Nov-20-2025=2***Nov-21-2025=1***Nov-22-2025=1***Nov-23-2025=2***Nov-24-2025=2***Nov-26-2025=2***Nov-27-2025=1***Nov-28-2025=2***Nov-29-2025=2***Dec-01-2025=3***Dec-02-2025=10***Dec-03-2025=1***Dec-04-2025=1***Dec-05-2025=1***Dec-06-2025=1***Dec-09-2025=4***Dec-10-2025=3***Dec-12-2025=1***Dec-13-2025=4***Dec-14-2025=3***Dec-15-2025=2***Dec-18-2025=4***Dec-19-2025=5***Dec-20-2025=4***Dec-21-2025=2***Dec-26-2025=1***Dec-29-2025=3***Dec-31-2025=2***Jan-01-2026=2***Jan-02-2026=1***Jan-03-2026=3***Jan-05-2026=2***Jan-07-2026=2***Jan-08-2026=2***Jan-09-2026=3***Jan-10-2026=1***Jan-17-2026=1***Jan-18-2026=2***Jan-22-2026=2***Jan-24-2026=1***Jan-25-2026=1***Jan-29-2026=1***Jan-31-2026=1***Feb-06-2026=1***Feb-08-2026=2***Feb-10-2026=2***Feb-12-2026=1***Feb-13-2026=3***Feb-14-2026=1***Feb-18-2026=1***Feb-20-2026=1***Feb-22-2026=1***Feb-23-2026=1***Feb-25-2026=2***Mar-04-2026=2***Mar-10-2026=1***Mar-11-2026=1***Mar-15-2026=3***Mar-17-2026=1***Mar-18-2026=1***Mar-19-2026=3***Mar-20-2026=2***Mar-21-2026=1***Mar-24-2026=1***Mar-25-2026=2***Mar-26-2026=3***Mar-27-2026=3***Mar-31-2026=1***Apr-01-2026=1***Apr-05-2026=1***Apr-06-2026=1***Apr-07-2026=1***Apr-09-2026=1***Apr-15-2026=1' WHERE job_id'1297125'  
0.0007   UPDATE employer_jobs SET monthly_hits '***Jan-2025=444***Feb-2025=130***Mar-2025=125***Apr-2025=61***May-2025=45***Jun-2025=42***Jul-2025=58***Aug-2025=81***Sep-2025=49***Oct-2025=75***Nov-2025=37***Dec-2025=55***Jan-2026=25***Feb-2026=16***Mar-2026=25***Apr-2026=6' WHERE job_id'1297125'  
0.0013   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1297125' 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` = 1297125 
0.0047   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '368243'
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)