CREATE TABLE campaign_spends (
  id VARCHAR(64) PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
  campaign VARCHAR NOT NULL,
  spend NUMERIC(8,2) NOT NULL,
  month INTEGER NOT NULL,
  year INTEGER NOT NULL,
  created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE jam_class_reports (
  cohort DATE,
  campaign VARCHAR,
  spend NUMERIC (8,2),
  registrations INTEGER,
  td_customers INTEGER,
  jamclass_rev NUMERIC (8,2),
  td4 INTEGER,
  td2 INTEGER,
  td1 INTEGER,
  spend_td NUMERIC (8,2),
  purchases0 NUMERIC (8,2),
  purchases1 NUMERIC (8,2),
  purchases2 NUMERIC (8,2),
  purchases3 NUMERIC (8,2),
  purchases_rest NUMERIC (8,2),
  purchases0_count INTEGER,
  purchases1_count INTEGER,
  purchases2_count INTEGER,
  purchases3_count INTEGER,
  purchases_rest_count INTEGER,
  purchases_count INTEGER
);