BrightCart is a mid-market ecommerce company that recently redesigned its website and marketing dashboards. The Head of Growth wants a candidate who can use Google Analytics, Tableau, or Excel to define the right KPIs, calculate them consistently, and explain performance changes to non-technical stakeholders.
In the last month, BrightCart recorded 1.8M website sessions, 720K product detail page views, 126K add-to-cart events, 54K checkout starts, and 27K completed orders. Revenue was $2.43M, down 6% month over month, while sessions were up 12%. Paid traffic sessions increased from 420K to 560K, but paid conversion rate fell from 2.4% to 1.6%. Mobile accounted for 68% of sessions and had a 1.1% conversion rate versus 2.8% on desktop. Leadership wants to know whether the issue is traffic quality, funnel friction, or a reporting-definition problem.
ga_sessions: session_id, user_id, session_start, device_type, channel, landing_page, countryga_events: session_id, event_time, event_name, page_type, product_idorders: order_id, user_id, session_id, order_time, gross_revenue, discount_amountmarketing_spend: date, channel, campaign_id, spend, clicks, impressionsdashboard_definitions: metric_name, formula_text, owner, last_updated