1 |
|
---|
2 | INSERT INTO AuditlyUser (Id, FirstName, LastName, EmailAddress, ProductDomainName)
|
---|
3 | VALUES
|
---|
4 | (1, 'Leon', 'Spremo', leonspremo@gmail.com', 'heyreach.io'),
|
---|
5 | (2, 'Jane', 'Petel', 'jane.petel@outlook.com', 'nativeteams.com),
|
---|
6 | (3, 'Alex', 'Johnson', 'alex.johnson@email.com', '');
|
---|
7 |
|
---|
8 | INSERT INTO UserProducts (UserId, ProductDomainName)
|
---|
9 | VALUES
|
---|
10 | (1, 'expandi.io'),
|
---|
11 | (3, 'prospeo.io'),
|
---|
12 | (1,'heyreach.io'),
|
---|
13 | (3, 'netnut.io');
|
---|
14 |
|
---|
15 | INSERT INTO Product (ProductDomainName)
|
---|
16 | VALUES
|
---|
17 | ('expandi.io'),
|
---|
18 | ('prospeo.io'),
|
---|
19 | (nativeteams.com),
|
---|
20 | ('smartrecruiters.com');
|
---|
21 |
|
---|
22 |
|
---|
23 | INSERT INTO ProductIndustry (ProductDomainName, Industry)
|
---|
24 | VALUES
|
---|
25 | ('expandi.io', 'Lead Generation'),
|
---|
26 | ('heyreach.io', ' Lead Intelligence'),
|
---|
27 | ('heyreach.io', ' Lead Generation'),
|
---|
28 | ('nativeteams.com', 'Freelancer Management Systems'),
|
---|
29 | ('smartrecruiters.com', 'Recruitment Automation');
|
---|
30 |
|
---|
31 | INSERT INTO Reviewer (Id, FirstName, LastName, Position, CompanyName, EmailAddress, LinkedInUserProfileUrl, DateOfReview)
|
---|
32 | VALUES
|
---|
33 | (1, 'Sarah', 'Miller', 'Analyst', 'TechAnalysis', 'sarah.miller@email.com', 'http://linkedin.com/sarahmiller','2023-12-12'),
|
---|
34 | (2, 'Mike', 'Brown', 'Senior Reviewer', 'MarketExperts', NULL, 'http://linkedin.com/mikebrown','2023-12-12'),
|
---|
35 | (3, 'Emily', 'White', 'Lead Researcher', 'BizInsights', 'emily.white@email.com', NULL,'2023-12-12');
|
---|
36 |
|
---|
37 |
|
---|
38 | INSERT INTO Message (Id, UserId, MessageType, EmailSubject, EmailText, LinkedInText)
|
---|
39 | VALUES
|
---|
40 | (1, 1, 'email', 'Question About Your Lead Generation Tool', 'Hello, I saw that you left a negative review about expandi, want to book a demo and show you our product?.', NULL),
|
---|
41 | (2, 2, 'linkedin', NULL, NULL, 'Heyo, I saw your lovely review on about our product and i would like to give you a 10% discount as a thank you :).'),
|
---|
42 | (3, 3, 'email', 'Meeting Request', 'Can we schedule a meeting for next week?', NULL);
|
---|
43 |
|
---|
44 |
|
---|
45 | INSERT INTO Review (Id, ReviewerId, ProductDomainName, ReviewSite, Sentiment, ReviewerScore, ReviewText)
|
---|
46 | VALUES
|
---|
47 | (1, 1, 'heyreach.io', 'g2', 'positive', 8.0, 'Great product with innovative features.'),
|
---|
48 | (2, 2, 'nativeteams.com', 'capterra', 'neutral', 3.5, NULL),
|
---|
49 | (3, 3, 'prospero.io', 'trustPilot', negative', NULL, 'Disappointing experience with customer service.');
|
---|
50 |
|
---|
51 |
|
---|
52 | INSERT INTO ReviewerSocialMediaLinks (SocialMediaLink, ReviewerId, SocialMediaType)
|
---|
53 | VALUES
|
---|
54 | ('http://facebook.com/sarahmiller', 1, 'facebook'),
|
---|
55 | ('http://twitter.com/mikebrown', 2, 'twitter'),
|
---|
56 | ('http://instagram.com/emilywhite', 3, 'instagram');
|
---|