D2C Looker Studio Dashboard
Employer not named by the sourceRemote
Frontier is not the employer and does not collect applications.
About this role
PHP, Excel, Google Adwords, Google Analytics, Data Visualization, Data Integration, Google Sheets, Google Ads · I need our scattered Direct-to-Consumer data pulled together into a single, reliable Google Looker Studio (Data Studio) workspace that my management team can open each morning and instantly understand how the business is performing.
Scope • Combine four lenses—sales, marketing, inventory and customer behaviour—into one cohesive report. • Connect live data from Google Analytics, Meta Ads (Facebook/Instagram), Google Ads, our logistics partner’s feed, plus a manual inventory sheet (CSV/Google Sheet). If a community or partner connector is required, build or recommend it. • Design intuitive pages and filters so senior management can drill from a high-level overview into SKU, campaign or cohort detail without needing analyst support.
Key views I expect – Daily, weekly and monthly sales with YoY and MoM deltas – ROAS, cost per acquisition and funnel drop-offs for each paid channel – Customer cohorts and LTV trends – Real-time inventory position with low-stock alerts matched to marketing velocity – Order-to-delivery timeline visualised from the logistics feed
Deliverables 1. Fully-functional Looker Studio report with branded styling and shareable link 2. All