CREATE TABLE analytics.google_analytic_report (
	account_login text NOT NULL,
	account_view_id text NOT NULL,
	report_date date NOT NULL,
	utm_marks text NOT NULL,
	metric_name text NOT NULL,
	metric_value numeric NULL,
	account_id int4 NOT NULL,
	CONSTRAINT google_analytic_report_pk PRIMARY KEY (account_view_id, account_id, report_date, utm_marks, metric_name)
);

select account_view_id, report_date, utm_marks, metric_name, count(*)
from analytics.google_analytic_report
group by account_view_id, report_date, utm_marks, metric_name
HAVING count(*) > 1

DELETE FROM analytics.google_analytic_report t1
  USING      analytics.google_analytic_report t2
WHERE  t1.account_id    < t2.account_id
  AND  t1.account_view_id   = t2.account_view_id     
  AND  t1.report_date = t2.report_date
  AND  t1.utm_marks = t2.utm_marks
  AND  t1.metric_name = t2.metric_name;