Create a simple table that indicates the different visitor activity types in Pardot.

pardot.visitor_activity_types.sql

CREATE TABLE visitor_activity_type AS
SELECT id::INT, name::VARCHAR(100)
FROM (
  SELECT 1 AS id, 'Click' AS name
  UNION
  SELECT 2 AS id, 'View' AS name
  UNION
  SELECT 3 AS id, 'Error' AS name
  UNION
  SELECT 4 AS id, 'Success' AS name
  UNION
  SELECT 5 AS id, 'Session' AS name
  UNION
  SELECT 6 AS id, 'Sent' AS name
  UNION
  SELECT 7 AS id, 'Search' AS name
  UNION
  SELECT 8 AS id, 'New Opportunity' AS name
  UNION
  SELECT 9 AS id, 'Opportunity Won' AS name
  UNION
  SELECT 10 AS id, 'Opportunity Lost' AS name
  UNION
  SELECT 11 AS id, 'Open' AS name
  UNION
  SELECT 12 AS id, 'Unsubscribe Page' AS name
  UNION
  SELECT 13 AS id, 'Bounced' AS name
  UNION
  SELECT 14 AS id, 'Spam Complaint' AS name
  UNION
  SELECT 15 AS id, 'Email Preference Page' AS name
  UNION
  SELECT 16 AS id, 'Resubscribed' AS name
  UNION
  SELECT 17 AS id, 'Click (Third Party)' AS name
  UNION
  SELECT 18 AS id, 'Opportunity Reopened' AS name
  UNION
  SELECT 19 AS id, 'Opportunity Linked' AS name
  UNION
  SELECT 20 AS id, 'Visit' AS name
  UNION
  SELECT 21 AS id, 'Custom URL click' AS name
  UNION
  SELECT 22 AS id, 'Olark Chat' AS name
  UNION
  SELECT 23 AS id, 'Invited to Webinar' AS name
  UNION
  SELECT 24 AS id, 'Attended Webinar' AS name
  UNION
  SELECT 25 AS id, 'Registered for Webinar' AS name
  UNION
  SELECT 26 AS id, 'Social Post Click' AS name
  UNION
  SELECT 27 AS id, 'Video View' AS name
  UNION
  SELECT 28 AS id, 'Event Registered' AS name
  UNION
  SELECT 29 AS id, 'Event Checked In' AS name
  UNION
  SELECT 30 AS id, 'Video Conversion' AS name
  UNION
  SELECT 31 AS id, 'UserVoice Suggestion' AS name
  UNION
  SELECT 32 AS id, 'UserVoice Comment' AS name
  UNION
  SELECT 33 AS id, 'UserVoice Ticket' AS name
  UNION
  SELECT 34 AS id, 'Video Watched (≥ 75% watched)' AS name
) t;
ALTER TABLE visitor_activity_type ADD PRIMARY KEY (id);