🚀 Configuration Analytics

Étape 1 — Créer un compte Supabase

Rendez-vous sur supabase.com, créez un projet gratuit (500 MB inclus).

Étape 2 — Créer les tables (SQL Editor)

-- Sessions
CREATE TABLE st_sessions (
  id bigserial PRIMARY KEY,
  session_id text UNIQUE,
  device_type text, browser text, os text,
  screen_w int, screen_h int, viewport_w int,
  language text, referrer text, referrer_source text,
  utm_source text, utm_medium text, utm_campaign text,
  landing_page text, is_bot boolean DEFAULT false,
  user_agent text, country text, country_code text,
  region text, city text, ip_address text,
  is_france boolean, ts timestamptz DEFAULT now()
);

-- Events
CREATE TABLE st_events (
  id bigserial PRIMARY KEY,
  session_id text, event_type text,
  page_url text, page_title text,
  element_tag text, element_text text,
  element_href text, element_class text,
  click_category text, scroll_depth int,
  time_on_page int, product_id text,
  product_title text, product_price numeric,
  product_vendor text, search_query text,
  metadata text, ts timestamptz DEFAULT now()
);

-- RLS (sécurité)
ALTER TABLE st_sessions ENABLE ROW LEVEL SECURITY;
ALTER TABLE st_events   ENABLE ROW LEVEL SECURITY;
CREATE POLICY "anon_insert" ON st_sessions FOR INSERT TO anon WITH CHECK (true);
CREATE POLICY "anon_insert" ON st_events   FOR INSERT TO anon WITH CHECK (true);
CREATE POLICY "anon_select" ON st_sessions FOR SELECT TO anon USING (true);
CREATE POLICY "anon_select" ON st_events   FOR SELECT TO anon USING (true);

-- Index de performance
CREATE INDEX ON st_sessions(ts);
CREATE INDEX ON st_sessions(is_france, is_bot);
CREATE INDEX ON st_events(session_id);
CREATE INDEX ON st_events(event_type, ts);

Étape 3 — Configurer dans Shopify

Dans le Customizer Shopify → SEO & Analytique, collez votre Supabase URL et clé anon, puis définissez un mot de passe dashboard.