This job will be paid as a completed job.
We're 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.
We'd 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. We're 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, I'm ready' once you've read this description and include why you'll be a good fit for this project, steps you'd take to approach this, and where it'll be most challenging.
About the recuiterMember since Jul 3, 2017 Horton
from Bergamo, Italy