| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | LEGEND | FinalReport is due | DONE but FR not yet sent | Starting soon or overdue | Work in progress | Campaign LIVE | ||||||||||||||||||||
2 | FinalReport Sent | Not Media Buy (Status set to N/A) | Uploaded but not checked | All assets ready | Camp. Held/Paused | |||||||||||||||||||||
3 | ||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||
5 | CAMPAIGN DETAILS | CAMPAIGN FLIGHT | FINANCIALS | MAX COST/UNIT | ||||||||||||||||||||||
6 | SM | TM | CAMPAIGN TITLE | PLATFORM | ADVERTISER | CLIENT | JOB NO. | OBJECTIVE | START DATE | END DATE | DAYS | BUDGET(MYR) | COM.% | REVENUE(MYR) | USD RATE | MARGIN | USD OUT | STATUS | CHECK | FR | MYR OUT | MYR PROFIT | DAILY | UNIT | PLAN(MYR) | OUT |
7 | CL | CL | Cab decals | Cab Company x | Agency1 | C2015/PC/006 | Printing | 18-08-2015 | 02-09-2015 | 16 | 5,175.00 | 0% | 5,175.00 | N/A | 35% | N/A | DONE | SENT | 3,363.75 | 1,811.25 | 210.23 | |||||
8 | Launch Campaign | Media Company y | Agency2 | C2016/BAM/185 | Lead Generation | 02-08-2016 | 20-08-2016 | 19 | 3,125.00 | 0% | 3,125.00 | 4.5 | 28% | 500.00 | WIP | OK | N/A | 875.00 | 26.32 | CPL | 70.00 | 11.200 | ||||
9 | Lead Generation | GDN | SkinCare 4 | Agency1 | C2016-242-BSC | Lead Generation | 04-08-2016 | 31-08-2016 | 28 | -15,000.00 | 0% | -15,000.00 | 4.5 | 0% | -3,333.33 | READY | 0.00 | -119.05 | ||||||||
10 | Launch Campaign_link ad | Search | Media Company y | Agency1 | C2016/BAM/185 | Website Clicks | 21-08-2016 | 09-09-2016 | 20 | 3,125.00 | 0% | 3,125.00 | 4.5 | 0% | 694.44 | READY | N/A | N/A | 0.00 | 34.72 | ||||||
11 | Redemption Programme | YouTube | toxyplan | Agency1 | C2016-249-Toh | Awareness | 01-09-2016 | 13-11-2016 | 74 | 4,000.00 | 0% | 4,000.00 | 4.5 | 30% | 622.22 | WIP | OK | 1,200.00 | 8.41 | CPM | 8.00 | 1.244 | ||||
12 | Pets and Dogs | Petshop City | Agency2 | C2016/PD/228 | Drive Traffic | 4,000.00 | 0% | 4,000.00 | 4.4 | 35% | 590.91 | READY | 1,400.00 | |||||||||||||
13 | Hollywood (Official Trailer) | CinemaX | Agency1 | C2016/TGV/229 | Video views | 28-07-2016 | 14-08-2016 | 18 | 10,000.00 | 0% | 10,000.00 | 4.4 | 30% | 1,590.91 | LIVE | OK | SENT | 3,000.00 | 88.38 | CPV | 0.06 | 0.009 | ||||
14 | Instagram Jul-Aug 16 | SkinShop | Agency1 | C2016/Den/230 | Engagement | 22-07-2016 | 14-08-2016 | 24 | 6,600.00 | 0% | 6,600.00 | 4.5 | 0% | 1,466.67 | UP | N/A | 0.00 | 61.11 | CPE | 0.75 | 0.166 | |||||
15 | Nutox Redemption Programme(version3) | SkinCare 4 | Agency2 | C2016-249-Toh | Awareness | 01-09-2016 | 13-11-2016 | 74 | 4,000.00 | 0% | 4,000.00 | 4.5 | 30% | 622.22 | HELD | 1,200.00 | 8.41 | CPM | 8.00 | 1.244 | ||||||
16 | ActionMovie_official trailer | YouTube | CinemaX | Agency1 | C2016-250-TGV | Video views | 19-08-2016 | 21-08-2016 | 3 | 3,000.00 | 0% | 3,000.00 | 4.5 | 35% | 433.33 | HELD | 1,050.00 | 144.44 | CPV | 8.00 | 1.155 | |||||
17 | ActionMovie_official trailer2 | CinemaX | Agency1 | C2016-250-TGV | Video views | 22-08-2016 | 29-08-2016 | 8 | 3,000.00 | 0% | 3,000.00 | 4.5 | 30% | 466.67 | HELD | 900.00 | 58.33 | CPV | 8.00 | 1.244 | ||||||
18 | ||||||||||||||||||||||||||
19 | DONE | |||||||||||||||||||||||||
20 | YouTube | UP | ||||||||||||||||||||||||
21 | LIVE | |||||||||||||||||||||||||
22 | READY | |||||||||||||||||||||||||
23 | 4.1 | 50% | WIP | N/A | SENT | |||||||||||||||||||||
24 | READY | |||||||||||||||||||||||||
25 | WIP | |||||||||||||||||||||||||
26 | READY | |||||||||||||||||||||||||
27 | Snapchat | N/A | ||||||||||||||||||||||||
28 | ||||||||||||||||||||||||||
29 | ||||||||||||||||||||||||||
30 | ||||||||||||||||||||||||||