- CREATE TABLE Campaign
- (
- Client varchar(50),
- Campaign varchar(50),
- PackageID int,
- Active int
- );
- INSERT INTO Campaign
- VALUES
- ('A', 'Holiday', 1, 1),
- ('A', 'Holiday', 2, 1),
- ('A', 'Holiday', 3, 1),
- ('A', 'Holiday', 4, 1),
- ('A', 'Holiday', 2, 0),
- ('A', 'Holiday', 5, 0),
- ('A', 'Valentine''s', 7, 1),
- ('A', 'Valentine''s', 8, 1),
- ('A', 'Valentine''s', 9, 1);
- CREATE TABLE Metric
- (
- MetricID int,
- PackageID int,
- PlacementID int,
- Creative varchar(50),
- Size varchar(50),
- AirDate date,
- Spend float,
- Impressions bigint,
- Clicks bigint
- );
- INSERT INTO Metric
- VALUES
- (1, 1, 1, 'A', '160x600', '2020-01-01', 135.00, 1657339, 17086),
- (2, 1, 1, 'A', '160x600', '2020-01-02', 129.00, 1874154, 33467),
- (3, 1, 1, 'B', '300x250', '2020-01-01', 118.00, 1200452, 30011),
- (4, 1, 1, 'B', '300x250', '2020-01-04', 155.00, 1955154, 27931),
- (5, 1, 1, 'B', '300x250', '2020-01-07', 131.00, 1855471, 45255),
- (6, 1, 1, 'B', '300x250', '2020-01-08', 138.00, 1713089, 26355),
- (7, 1, 1, 'C', '300x250', '2020-01-03', 196.00, 1133126, 33327),
- (8, 1, 1, 'C', '300x250', '2020-01-04', 106.00, 1283039, 51322),
- (9, 2, 2, 'A', '160x600', '2020-01-02', 158.00, 1212905, 32781),
- (10, 2, 2, 'A', '160x600', '2020-01-03', 119.00, 1863155, 19012),
- (11, 2, 2, 'A', '160x600', '2020-01-04', 157.00, 1490992, 87705),
- (12, 2, 2, 'D', '160x600', '2020-01-02', 173.00, 1519337, 63306),
- (13, 2, 2, 'D', '160x600', '2020-01-03', 144.00, 1347899, 36430),
- (14, 2, 2, 'D', '160x600', '2020-01-04', 135.00, 1373254, 76292),
- (15, 2, 2, 'E', '320x50', '2020-01-05', 182.00, 1805398, 18054),
- (16, 2, 2, 'E', '320x50', '2020-01-06', 152.00, 1186376, 17707),
- (17, 2, 2, 'E', '320x50', '2020-01-07', 196.00, 1775857, 49329),
- (18, 2, 2, 'E', '320x50', '2020-01-08', 150.00, 1121286, 19672),
- (19, 2, 3, 'B', '300x250', '2020-01-02', 178.00, 1111403, 48322),
- (20, 2, 3, 'B', '300x250', '2020-01-03', 169.00, 1562195, 25197);
- CREATE TABLE Engagement
- (
- MetricID int,
- EngagementType varchar(50),
- EngagementCount int
- );
- INSERT INTO Engagement
- VALUES
- (1, 'Swipe Up', 79),
- (4, 'Swipe Up', 65),
- (5, 'Swipe Up', 49),
- (6, 'Swipe Up', 13),
- (7, 'Swipe Up', 89),
- (8, 'Swipe Up', 22),
- (9, 'Tap to Login', 7),
- (10, 'Tap to Login', 32),
- (11, 'Tap to Login', 99),
- (12, 'Tap to Login', 70),
- (13, 'Tap to Login', 84),
- (14, 'Tap to Login', 37),
- (15, 'Tap to Login', 91),
- (16, 'Tap to Login', 83),
- (17, 'Tap to Login', 25),
- (18, 'Tap to Login', 2),
- (19, 'Tap to Login', 59),
- (20, 'Tap to Login', 3),
- (10, 'Expansion', 45),
- (11, 'Expansion', 73),
- (12, 'Expansion', 47),
- (14, 'Expansion', 73),
- (15, 'Expansion', 5),
- (16, 'Expansion', 79),
- (17, 'Expansion', 84),
- (19, 'Expansion', 16),
- (20, 'Expansion', 47);
[text] jj
Viewer
Editor
You can edit this paste and save as new: