This job will be paid as a completed job.
Were looking for a seasoned marketing data specialist engineer that can lead a dashboard built out project. We currently have data stored in Shopify, Amazon, Google Analytics, Facebook Ads, ActiveCampaign, and our backend DB.
Wed like to connect all the data into a central place, automatically pulling it, and calculating necessary formulas to present an easy to use dashboard that covers the following KPIs by time:
- LTV (+cohort analysis)
- 1st, 2nd, 3rd customer counts
- Subscribes and Unsubscribes
- Revenue (split between reoccurring and 1-time)
- Top selling products
- Daily profitability (return on ad spend)
- Organic vs. Ad-driven traffic
- (Plus) Traffic attribution
- Average products per customer
- # of Product 1 --> Product 2 Buyers
- # of Product 2 --> Product 1 Buyers
- % of Free Test Takers
- Count of Test Results (4 Types)
What I am looking for:
- Individual
- Perfect English
- Ability to problem solve
- Amazing data visualization skills
- Familiar with Google Data Studio (or similar), APIs, Data Automation
- Detail-oriented
- Provide daily reports that are ready in the morning in PST
- Can work quickly, but is very conscious of bugs and errors
- Available to work for the next 2 weeks to complete this job
This is a rather urgent project. Were open to you using whatever pre-created tool (Klipfolio, Google Data Studio, or homemade). Even open to you using Wordpress and creating your own. I am looking to build a long term relationship with a data expert I can trust and continue to go back to.
Please reply sweet, Im ready once youve read this description and include why youll be a good fit for this project, steps youd take to approach this, and where itll be most challenging.
About the recuiterMember since Nov 11, 2022 Yogesh Pawar
from New South Wales, Australia
Candidate shortlisted and hiredHiring open till - May 2, 2024
Work from Anywhere
40 hrs / week Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions