INSERT IGNORE INTO request_project (_id,_projectTitle,_created,_createdBy,_ownedBy,_lastUpdated,_ownerID,_type,_deadline,_stage,_status) VALUES('1','About Apptio','1550397778','1','','2020-07-13 07:19:15','0','9','1552989778','100','-1'),('2','Blog post & Social media posts to promote blog from Apptio webinar','1550624301','171','Shermian Lim','2019-02-20 11:05:31','0','4','1550620800','80','-1'),('3','Social Ads Case Studies','1550736457','85','','2019-02-22 00:01:27','0','9','1553328457','100','-1'),('4','Apptio Content & Messaging Guidelines','1550793369','171','','2019-02-21 23:58:29','0','9','1553385369','100','-1'),('5','Inbound email sequence based on “A Practical Guide to Zero-Based Budgeting\"','1550795468','171','Shermian Lim','2019-02-27 01:31:36','0','7','1551052800','0','-1'),('6','Test','1595209634','1','','2020-07-20 01:47:14','0','1006','1597801634','0','-1'),('7','ESIGN Anniversay Social Banner','1595402266','181','','2020-08-29 01:46:05','0','1006','1597994266','100','1'),('8','Fannie Mae Case Study','1595405663','181','','2020-08-26 14:16:16','0','1006','1597997663','100','1'),('9','Creating an email MSG file','1595502124','34','','2020-07-23 11:02:04','0','1006','1598094124','100','1'),('10','[Sean Wong] - [#9][Creating an email MSG file]','1595560005','1','','2020-07-24 03:06:45','0','4','1598152005','0','-1'),('11','[Sean Wong] - [#9][Creating an email MSG file]','1595560014','1','','2020-07-24 03:06:54','0','4','1598152014','0','-1'),('12','[Sean Wong] - [#9 - Creating an email MSG file]','1595560108','1','','2020-07-24 03:08:28','0','4','1598152108','0','-1'),('13','[Sean Wong] - [#9 - Creating an email MSG file]','1595560129','1','','2020-07-24 03:08:49','0','4','1598152129','0','-1'),('14','[Citadel #9 - Creating an email MSG file] [Sean Wong]','1595560333','1','','2020-07-24 03:12:13','0','4','1598152333','0','-1'),('15','[Citadel #9 - Creating an email MSG file] [Sean Wong]','1595560444','1','','2020-07-24 03:14:04','0','4','1598152444','0','-1'),('16','[Citadel #9 - Creating an email MSG file] [Sean Wong]','1595560525','1','','2020-07-24 03:15:25','0','4','1598152525','0','-1'),('17','Building LinkedIn Connection Dashboard in Data Studio','1595569378','1','','2020-07-24 05:42:58','0','1006','1598161378','100','1'),('18','Citadel #17 - Building LinkedIn Connection Dashboard in Data Studio','1595572065','1','','2020-07-24 06:27:45','0','4','1598164065','0','-1'),('19','Validating Emails','1595837625','93','','2020-07-31 08:07:47','0','1006','1598429625','100','1'),('20','Do marketing channel research for DoGood and evaluate ROI for meetings (Client: 2X)','1596007855','8','','2020-12-01 01:45:34','0','1006','1598599855','100','1'),('21','Create Persona Documents for eOriginal','1596010152','178','','2020-07-29 14:36:26','0','1006','1598602152','100','1'),('22','Design Fourkites Webinar Promo Banners','1596014023','181','','2020-08-10 03:56:11','0','1006','1598606023','100','1'),('23','Design Fourkites CPG Infographic','1596016408','181','','2020-09-11 14:26:50','0','1006','1598608408','100','1'),('24','Transcribe videos using Otter','1596031573','1','','2020-08-10 12:17:36','0','1006','1598623573','100','1'),('25','Citadel #22 - Fourkites August Webinar Promo Images','1596035641','1','','2020-07-29 15:14:01','0','4','1596035680','100','-1'),('26','Citadel #22 - Fourkites August Webinar Promo Images','1596035798','1','','2020-07-29 15:16:38','0','4','1598627798','0','-1'),('27','Citadel #22 - Fourkites August Webinar Promo Images','1596035861','1','','2020-07-29 15:17:41','0','4','1598627861','0','-1'),('28','Citadel #22 - Fourkites August Webinar Promo Images','1596035893','1','','2020-07-29 15:18:13','0','4','1598627893','0','-1'),('29','Citadel #22 - Fourkites August Webinar Promo Images','1596036019','1','','2020-07-29 15:20:19','0','4','1598628019','0','-1'),('30','Citadel #22 - Fourkites August Webinar Promo Images','1596036076','1','','2020-07-29 15:21:16','0','4','1598628076','0','-1'),('31','Citadel #22 - Fourkites August Webinar Promo Images','1596036330','1','','2020-07-29 15:25:30','0','4','1598628330','0','-1'),('32','Citadel #7 - ESIGN Anniversary Social Banner','1596036582','1','','2020-07-29 15:29:42','0','4','1598628582','0','-1'),('33','Citadel #7 - ESIGN Anniversary Social Banner','1596036610','1','','2020-07-29 15:30:10','0','4','1598628610','0','-1'),('34','Create a persona document for 2X','1596071885','8','','2023-02-17 13:05:27','0','1006','1598663885','100','1'),('35','Content Syndication Brief','1596076965','72','','2020-09-01 07:41:17','0','1006','1598668965','10','-1'),('36','Write outreach emails describing what 2X can do for marketing leaders','1596079857','8','','2020-10-30 08:57:39','0','1006','1598671857','100','1'),('37','','1596164798','1','','2020-07-31 03:06:38','0','1007','1598756798','0','-1'),('38','Redemption of Secretlab Omega Gaming Chair','1596164865','1','','2020-07-31 03:07:45','0','1007','1598756865','0','-1'),('39','Creating a Campaign Results Report from Google Data Studio dashboard','1596188984','1','','2020-08-05 02:34:58','0','1006','1598780984','100','1'),('40','Preparing / Maintaining Lead Routing Table','1596450282','34','','2020-08-05 02:34:50','0','1006','1599042282','100','1'),('41','Uploading contact / account list to LinkedIn','1596458887','83','','2020-08-16 14:00:43','0','1006','1599050887','100','1'),('42','Fuzzy Matching using Python','1596464357','93','','2020-08-05 03:27:58','0','1006','1599056357','0','-1'),('43','Citadel #20 - Do marketing channel research for DoGood and evaluate ROI for meetings','1596594721','1','','2020-08-05 02:32:01','0','4','1599186721','0','-1'),('44','Citadel #20 - Do marketing channel research for DoGood and evaluate ROI for meetings','1596594761','253','','2020-08-05 02:32:41','0','4','1599186761','0','-1'),('45','Citadel #23 - Creating an Infographic for Fourkites Consumer Package Goods (CPG) industry','1596595158','1','','2020-08-05 02:39:18','0','4','1599187158','0','-1'),('46','Citadel #41 - Uploading contact / account list to LinkedIn','1596595243','202','','2020-08-05 02:40:43','0','4','1599187243','0','-1'),('47','Citadel #41 - Uploading contact / account list to LinkedIn','1596595267','202','','2020-08-05 02:41:07','0','4','1599187267','0','-1'),('48','Citadel #41 - Uploading contact / account list to LinkedIn','1596595355','1','','2020-08-05 02:42:35','0','4','1599187355','0','-1'),('49','Citadel #21 - Create Persona Documents for eOriginal','1596596261','35','','2020-08-05 02:57:41','0','4','1599188261','0','-1'),('50','Fuzzy Matching using Excel','1596605714','93','','2020-08-11 02:45:28','0','1006','1599197714','0','-1'),('51','Citadel #34 - Create a persona document for 2X','1596612108','109','','2020-08-05 07:21:48','0','4','1599204108','0','-1'),('52','Deleting old images from Sitecore','1596617749','194','','2020-08-17 05:37:22','0','1006','1599209749','100','1'),('53','Citadel #24 - Transcribing videos using Otter','1596623072','1','','2020-08-05 10:24:32','0','4','1599215072','0','-1'),('54','Creating a LinkedIn Demand Gen Advertising Campaign (Contact List)','1596681168','83','','2020-08-13 10:34:01','0','1006','1599273168','100','1'),('55','Citadel #9 - Creating an email MSG file','1596685676','193','','2020-08-07 02:28:28','0','4','1596767669','100','1'),('56','eOriginal Televerde Calllist Changes','1596696479','229','','2020-09-01 15:25:57','0','1006','1599288479','100','1'),('57','Citadel #52 - Removal of outdated & non-brand compliant images from Sitecore CMS','1596698945','202','','2020-08-06 07:29:05','0','4','1599290945','0','-1'),('58','Citadel #52 - Removal of outdated & non-brand compliant images from Sitecore CMS','1596703873','1','','2020-08-06 08:51:13','0','4','1599295873','0','-1'),('59','Citadel #20 - Do marketing channel research for DoGood and evaluate ROI for meetings','1596704280','4','','2020-08-06 08:58:00','0','4','1599296280','0','-1'),('60','Citadel #9 - Creating an email MSG file','1596771640','258','','2020-08-11 08:31:08','0','4','1597133613','100','1'),('61','Citadel #52 - Removal of outdated & non-brand compliant images from Sitecore CMS','1596778871','243','','2020-08-18 06:26:48','0','4','1597731934','100','1'),('62','Citadel #39 - Creating a Campaign Results Report from Google Data Studio dashboard','1596780329','260','','2020-08-07 06:05:29','0','4','1599372329','0','-1'),('63','Citadel #9 - Creating an email MSG file','1596782210','223','','2020-08-07 06:36:50','0','4','1599374210','0','1'),('64','Citadel #24 - Transcribing videos using Otter','1596782265','223','','2020-08-07 06:37:45','0','4','1599374265','0','1'),('65','Citadel #41 - Uploading contact / account list to LinkedIn','1596786322','260','','2020-08-10 03:42:09','0','4','1597030936','100','1'),('66','Citadel #40 - Creating a Lead Routing Table','1596790460','193','','2020-08-16 08:37:31','0','4','1597567057','100','1'),('67','Citadel #24 - Transcribing videos using Otter','1596793333','139','','2020-08-07 09:42:13','0','4','1599385333','0','-1'),('68','Citadel #19 - Validating Database Purchases through Neverbounce and IPQualityScore','1596805952','85','','2020-08-10 04:02:06','0','4','1597037619','100','1'),('69','Citadel #20 - Do marketing channel research for DoGood and evaluate ROI for meetings','1596853262','260','','2020-08-08 02:21:02','0','4','1599445262','0','-1'),('70','Citadel #23 - Creating an Infographic for Fourkites Consumer Package Goods (CPG) industry','1596875543','251','','2020-08-08 08:32:23','0','4','1609038541','100','1'),('71','Citadel #24 - Transcribing videos using Otter','1596879731','243','','2020-08-08 09:42:11','0','4','1599471731','0','1'),('72','Write social post that celebrates the promotion of a 2X team member','1596890641','2','','2020-08-17 07:14:00','0','1006','1599482641','100','1'),('73','Build a content atomization plan','1597023301','214','','2020-08-14 01:39:28','0','1006','1599615301','100','1'),('74','Citadel #17 - Building LinkedIn Connection Dashboard in Data Studio','1597039180','222','','2020-08-17 05:37:44','0','4','1597631385','100','1'),('75','How to set up UTM tracking for a gated landing page in 5 minutes ','1597044169','256','','2020-08-24 03:29:38','0','1006','1599636169','100','1'),('76','LLR Marketing Collaborate Webinar Deck Beautification','1597048141','181','','2020-08-10 10:17:44','0','1006','1599640141','100','1'),('77','Enhancing a Quarterly Business Review presentation deck for eOriginal','1597049099','226','','2020-11-11 14:03:42','0','1006','1599641099','100','1'),('78','Citadel #76 - LLR Marketing Collaborate Webinar Deck Beautification','1597054835','1','','2020-08-10 10:20:35','0','4','1599646835','0','-1'),('79','Citadel #77 - Enhancing a Quarterly Business Review presentation deck for eOriginal','1597054852','1','','2020-08-10 10:20:52','0','4','1599646852','0','-1'),('80','Citadel #19 - Validating Database Purchases through Neverbounce and IPQualityScore','1597116445','197','','2020-08-18 10:04:24','0','4','1597745068','100','1'),('81','Citadel #17 - Building LinkedIn Connection Dashboard in Data Studio','1597144614','4','','2020-08-11 11:16:54','0','4','1599736614','0','-1'),('82','Citadel #17 - Building LinkedIn Connection Dashboard in Data Studio','1597144638','4','','2020-08-11 11:17:18','0','4','1599736638','0','-1'),('83','Citadel #17 - Building LinkedIn Connection Dashboard in Data Studio','1597145732','4','','2020-08-11 11:35:32','0','4','1599737732','0','-1'),('84','Citadel #7 - ESIGN Anniversary Social Banner','1597200493','237','','2020-08-12 02:48:13','0','4','1599792493','0','-1'),('85','Creating a LinkedIn Demand Gen Advertising Campaign (Account List)','1597215111','83','','2020-08-12 09:24:23','0','1006','1599807111','100','1'),('86','Citadel #54 - Creating a LinkedIn Advertising Campaign from a Specific Contact List','1597215854','260','','2020-08-12 07:29:29','0','4','1597217376','100','1'),('87','Citadel #85 - Creating a LinkedIn Advertising Campaign from an Account List','1597224228','1','','2020-08-12 09:23:48','0','4','1599816228','0','-1'),('88','Relay MQL Enrichment','1597246041','260','','2020-08-17 01:46:23','0','1006','1599838041','100','1'),('89','Optimize on-page SEO for a Hyland webpage','1597286630','224','','2021-03-31 08:05:58','0','1006','1599878630','100','1'),('90','Citadel #20 - Do marketing channel research for DoGood and evaluate ROI for meetings','1597298693','253','','2020-08-13 06:04:53','0','4','1599890693','0','-1'),('91','Write promotional copy for an analyst report','1597298938','211','','2020-08-13 14:47:58','0','1006','1599890938','0','1'),('92','Creating a LinkedIn Demand Gen Advertising Campaign using LinkedIn audience filters','1597301188','83','','2020-08-13 14:51:47','0','1006','1599893188','100','1'),('93','Citadel #17 - Building LinkedIn Connection Dashboard in Data Studio','1597305040','255','','2020-08-13 07:50:40','0','4','1599897040','0','-1'),('94','Citadel #9 - Creating an email MSG file','1597305214','139','','2020-08-30 15:03:44','0','4','1598799821','100','1'),('95','How-to Setup an Email Marketing Using Pardot','1597309430','254','','2020-08-28 14:20:44','0','1006','1599901430','100','1'),('96','Citadel #85 - Creating a LinkedIn Advertising Campaign from an Account List','1597327370','260','','2020-08-14 02:07:53','0','4','1597370281','100','1'),('97','Create a cheat sheet for the \"Building a StoryBrand\" book (with sample roadmap)','1597362773','8','','2022-05-12 02:48:12','0','1006','1599954773','100','1'),('98','Develop a StoryBrand roadmap for Xeeva (a former 2X client)','1597370639','8','','2022-07-07 01:40:25','0','1006','1599962639','100','1'),('99','Citadel #92 - Creating a LinkedIn Advertising Campaign using LinkedIn filters','1597372595','260','','2020-08-14 08:36:42','0','4','1597391667','100','1'),('100','Develop a content atomization plan','1597373572','214','','2020-08-19 05:29:18','0','1006','1599965572','100','1'),('101','Citadel #20 - Do marketing channel research for DoGood and evaluate ROI for meetings','1597376314','253','','2020-08-14 03:38:34','0','4','1599968314','0','-1'),('102','eOriginal Lead to Revenue Deck','1597385972','181','','2020-08-14 09:56:32','0','1006','1599977972','100','1'),('103','How to create UTM tracking links for LinkedIn & Facebook advertising campaign','1597387646','83','','2020-08-14 10:05:37','0','1006','1599979646','100','1'),('104','SBA Social Banner','1597389257','181','','2020-08-29 02:19:07','0','1006','1599981257','100','1'),('105','Ginnie Mae Kick-Off Meeting Presentation Deck Beautification','1597394102','181','','2020-08-16 06:46:51','0','1006','1599986102','100','1'),('106','Write content copy for an infographic','1597394540','214','','2020-08-18 23:40:09','0','1006','1599986540','100','1'),('107','Citadel #92 - Creating a LinkedIn Advertising Campaign using LinkedIn filters','1597468667','243','','2020-08-15 05:17:47','0','4','1600060667','0','-1'),('108','Citadel #92 - Creating a LinkedIn Advertising Campaign using LinkedIn filters','1597468907','243','','2020-08-25 00:51:15','0','4','1597806649','100','1'),('109','Citadel #41 - Uploading contact / account list to LinkedIn','1597471884','243','','2020-08-15 06:11:24','0','4','1600063884','0','1'),('110','Citadel #103 - How to create UTM tracking links for Advertising Campaigns','1597472278','243','','2020-08-17 05:47:08','0','4','1597643237','100','1'),('111','Citadel #103 - How to create UTM tracking links for Advertising Campaigns','1597487130','260','','2020-08-16 03:32:44','0','4','1597546552','100','1'),('112','Retrieve Results from Pardot using Dynamic List','1597574605','34','','2020-08-16 14:09:47','0','1006','1600166605','100','1'),('113','How to set up single image ads on LinkedIn','1597581301','83','','2020-08-16 14:09:55','0','1006','1600173301','100','1'),('114','Citadel #88 - Enriching Form Conversion Data to Enable Lead Routing','1597627505','83','','2020-08-17 03:34:54','0','4','1597635318','100','1'),('115','Citadel #113 - Setting up single image ads on LinkedIn','1597634925','260','','2020-08-17 05:38:17','0','4','1597642674','100','1'),('116','Update price list on Hyland web page via Sitecore CMS','1597642212','243','','2020-08-17 06:47:44','0','1006','1600234212','100','1'),('117','Designing Linkedin Banner Ads for Hyland’s Healthcare Campaign ','1597643403','235','','2020-08-31 13:15:53','0','1006','1600235403','100','1'),('118','Citadel #40 - Creating a Lead Routing Table','1597647937','130','','2020-08-17 08:46:22','0','4','1597650554','100','1'),('119','Citadel #9 - Creating an email MSG file','1597648093','130','','2020-08-17 07:08:13','0','4','1600240093','0','1'),('120','Citadel #40 - Creating a Lead Routing Table','1597648107','130','','2020-08-17 07:08:27','0','4','1600240107','0','-1'),('121','Extracting updated MQL data by forming an import file

','1597669756','260','','2020-08-24 08:25:37','0','1006','1600261756','100','1'),('122','Citadel #17 - Building LinkedIn Connection Dashboard in Data Studio','1597714746','269','','2020-08-18 01:39:06','0','4','1600306746','0','-1'),('123','Discovery of Sponsored Content publishers (eCommerce industry)','1597715094','85','','2020-08-19 01:40:15','0','1006','1600307094','100','1'),('124','Develop 3 messaging angles and initial content topics for Xeeva (a former 2X client)','1597728587','8','','2020-12-20 09:17:13','0','1006','1600320587','100','1'),('125','Citadel #52 - Removal of outdated & non-brand compliant images from Sitecore CMS','1597731668','243','','2020-08-18 06:21:08','0','4','1597731693','100','1'),('126','Citadel #52 - Removal of outdated & non-brand compliant images from Sitecore CMS','1597732548','202','','2020-08-18 06:38:01','0','4','1597732650','100','1'),('127','Citadel #89 - Website SEO Optimization for Writers','1597736454','270','','2020-08-25 02:09:16','0','4','1598320667','100','1'),('128','Come up with 3 good title options for a case study from a client brief','1597751208','8','','2020-11-05 13:32:50','0','1006','1600343208','100','1'),('129','Build JP Landing pages by using Sitecore','1597757051','243','','2020-08-19 05:38:31','0','1006','1600349051','100','1'),('130','Citadel #106 - Writing content for an infographic','1597777779','253','','2020-08-18 19:09:39','0','4','1600369779','0','1'),('131','How to store MQL information from LinkedIn Lead Gen Form Campaign into excel file','1597813373','260','','2020-08-25 05:48:36','0','1006','1600405373','100','1'),('132','Extracting Activity Log From Marketo','1597820345','258','','2020-09-07 01:13:38','0','1006','1600412345','100','1'),('133','Complete the Table on the Buyer’s Journey Stages & Content','1597824555','214','','2020-08-25 02:16:31','0','1006','1600416555','100','1'),('134','How to set up a LinkedIn lead gen form campaign & ads','1597825106','83','','2020-08-21 01:57:17','0','1006','1600417106','100','1'),('135','Copyedit and restructure the first draft of a 2X case study ','1597833329','8','','2020-12-20 09:17:47','0','1006','1600425329','100','1'),('136','Video Transcripts by Descript','1597902980','243','','2020-08-20 11:34:45','0','1006','1600494980','100','1'),('137','SQL 101 for those with zero experience','1597905201','1','','2021-06-10 09:07:03','0','1006','1600497201','100','1'),('138','Redemption of 2X Umbrella','1597916645','1','','2020-08-20 09:44:05','0','1007','1600508645','0','-1'),('139','Redemption of 2X Umbrella','1597916645','1','','2020-08-20 09:44:05','0','1007','1600508645','0','-1'),('140','Redemption of 2X Umbrella','1597916673','1','','2020-08-20 09:44:33','0','1007','1600508673','0','-1'),('141','Getting one-off data from Excel into SQL','1597918916','1','','2020-08-20 10:22:37','0','1006','1600510916','100','1'),('142','Citadel #41 - Uploading contact / account list to LinkedIn','1597931113','260','','2020-08-20 13:45:13','0','4','1600523113','0','-1'),('143','Citadel #134 - Setting up a LinkedIn Advertising campaign using Lead Gen Form','1597931210','260','','2020-09-02 06:52:05','0','4','1599029529','100','1'),('144','Citadel #40 - Creating a Lead Routing Table','1597975284','129','','2020-08-24 07:00:15','0','4','1600567284','50','1'),('145','Basic level research for Zoominfo alternatives','1597976764','1','','2020-08-21 02:26:15','0','1006','1600568764','100','1'),('146','Citadel #17 - Building LinkedIn Connection Dashboard in Data Studio','1597978452','269','','2020-08-21 02:54:12','0','4','1600570452','0','1'),('147','Citadel #145 - Basic level research for Zoominfo alternatives','1597978477','269','','2020-10-27 13:20:11','0','4','1598349992','100','1'),('148','Review E-mail Copies for 2X Latest Blog Post','1597982181','253','','2020-09-02 14:15:17','0','1006','1600574181','100','1'),('149','Do a content audit and provide a short summary of findings and recommendations','1597985721','8','','2021-01-06 03:13:17','0','1006','1600577721','100','1'),('150','Tracking Lead Pacing (Pareto)','1597992078','85','','2020-08-25 05:58:15','0','1006','1600584078','100','1'),('151','CareATC - Export opportunity report and present R4Q pipeline number (Salesforce, Microsoft Excel)','1597998953','197','','2020-08-22 09:35:47','0','1006','1600590953','100','1'),('152','How to create Landing page UTM tracking link for Relay LGF Lead routing','1598005468','260','','2020-09-01 14:12:59','0','1006','1600597468','10','-1'),('153','Create a new list for ABM Persona Email in SharpSpring ','1598109123','243','','2020-08-23 14:16:11','0','1006','1600701123','100','1'),('154','Creating Prospect ID and Updating Routable Table for Email Campaigns','1598187014','34','','2020-08-24 03:33:14','0','1006','1600779014','100','1'),('155','How to remove duplicates from email prospect list (Microsoft Excel)','1598195807','197','','2020-08-23 15:27:54','0','1006','1600787807','0','1'),('156','Choose images for Rocket campaign communication assets','1598204466','4','','2020-09-04 07:31:36','0','1006','1600796466','100','1'),('157','Enhancing stock images as client’s brand exclusive for Rocket','1598210217','4','','2020-09-03 14:53:13','0','1006','1600802217','100','1'),('158','Citadel #72 - Write social post that celebrates the promotion of a 2X team member','1598232303','244','','2020-08-24 01:25:03','0','4','1600824303','0','1'),('159','Citadel #98 - Develop a StoryBrand roadmap for Xeeva (a former 2X client)','1598239649','271','','2020-09-02 09:00:15','0','4','1598497222','100','1'),('160','Company Name Cleanup with OpenRefine','1598252735','141','','2020-08-25 05:50:42','0','1006','1600844735','100','1'),('161','Create a short list of atomized topics from a white paper ','1598269957','8','','2020-11-05 13:33:22','0','1006','1600861957','100','1'),('162','Atomize the 2X MaaS webinar into a blog','1598271407','8','','2020-12-20 09:20:44','0','1006','1600863407','100','1'),('163','How to create an LinkedIn advertising campaign performance report','1598272027','83','','2020-08-25 06:51:47','0','1006','1600864027','100','1'),('164','Atomize an industry report by writing a blog (topic provided)','1598273959','8','','2020-11-17 15:06:11','0','1006','1600865959','100','1'),('165','Automating Scrubbing on Zoominfo','1598286957','93','','2020-09-04 07:42:48','0','1006','1600878957','100','1'),('166','Citadel #97 - Create a cheat sheet for the \"Building a StoryBrand\" book','1598320712','271','','2020-09-02 09:00:34','0','4','1598352386','100','1'),('167','Do a light(er) edit on an SEO article ','1598336374','8','','2020-10-30 08:56:49','0','1006','1600928374','100','1'),('168','Edit a white paper in PDF format','1598338070','8','','2020-11-05 13:34:16','0','1006','1600930070','100','1'),('169','Citadel #112 - Creating Dynamic List in Pardot to identify specific form leads','1598340593','256','','2020-08-30 15:01:14','0','4','1598799678','100','1'),('170','Citadel #165 - Automating Data Enrichment on Zoominfo using Python','1598341675','241','','2020-08-25 07:47:55','0','4','1600933675','0','-1'),('171','Build emails in SharpSpring','1598343320','243','','2020-08-26 09:20:08','0','1006','1600935320','100','1'),('172','Citadel #160 - Fixing inconsistent company naming in Excel with OpenRefine','1598344893','197','','2020-08-26 01:11:29','0','4','1598404300','100','1'),('173','Create an e-mail copy to promote 2X blog post','1598346042','253','','2020-09-21 14:48:22','0','1006','1600938042','100','1'),('174','Produce 2 video scripts out of a client interview','1598349863','109','','2020-12-20 09:18:33','0','1006','1600941863','100','1'),('175','Write a full set of campaign promo copy (email, landing page, LI & FB social posts, ad) for a white paper ','1598350296','8','','2020-12-20 09:19:01','0','1006','1600942296','100','1'),('176','How to create a LinkedIn advertising A/B test report','1598352344','83','','2020-08-25 13:51:08','0','1006','1600944344','100','1'),('177','Write campaign copy for a 2X blog (email and one organic social post)','1598352846','8','','2023-05-30 10:30:39','0','1006','1600944846','100','1'),('178','How to create website audience on LinkedIn for retargeting campaigns','1598357064','83','','2020-08-26 00:39:19','0','1006','1600949064','100','1'),('179','Create suppression list of MQLs from email campaigns on Pardot','1598368804','256','','2020-09-04 06:01:41','0','1006','1600960804','100','1'),('180','Citadel #136 - Transcribe Video using Descript tool','1598403249','202','','2020-08-26 00:54:09','0','4','1600995249','0','-1'),('181','Anglicize UK Pages via Pearls Chrome Extension','1598405793','202','','2020-08-27 01:43:48','0','1006','1600997793','0','-1'),('182','Redemption of 2X Umbrella','1598428067','235','','2020-08-27 08:47:13','0','1007','1601020067','100','1'),('183','Redemption of 2X Umbrella','1598428081','224','','2020-08-27 08:50:57','0','1007','1601020081','100','1'),('184','Citadel #165 - Automating Data Enrichment on Zoominfo using Python','1598432566','241','','2020-08-26 09:02:46','0','4','1601024566','0','-1'),('185','Write a 15-second teaser video for LinkedIn','1598432757','109','','2020-08-27 14:29:41','0','1006','1601024757','100','1'),('186','Citadel #165 - Automating Data Enrichment on Zoominfo using Python','1598433965','241','','2020-08-26 09:42:34','0','4','1598434957','100','1'),('187','Design FourKites Store Delivery Tracking One Pager','1598435590','181','','2020-08-26 14:22:49','0','1006','1601027590','100','1'),('188','Design Fourkites eDocumentation One Pager','1598436643','181','','2020-08-26 14:25:41','0','1006','1601028643','100','1'),('189','Design Fourkites Multimodal Predictive Visibilty One Pager','1598438855','181','','2020-08-26 14:28:46','0','1006','1601030855','100','1'),('190','How to create retargeting campaign on LinkedIn','1598445093','83','','2020-08-26 14:30:48','0','1006','1601037093','100','1'),('191','Scheduling email in SharpSpring','1598446272','243','','2020-08-27 02:50:19','0','1006','1601038272','100','1'),('192','How to set up conversion tracking on LinkedIn','1598446726','83','','2020-08-26 14:39:30','0','1006','1601038726','100','1'),('193','Mastering one of the fundamental tools of PowerPoint','1598493156','226','','2020-08-27 10:49:41','0','1006','1601085156','100','1'),('194','Create ABA Ad Copy on a Glossographic','1598493910','214','','2021-05-18 08:26:05','0','1006','1601085910','100','1'),('195','Citadel #7 - ESIGN Anniversary Social Banner','1598495814','266','','2020-08-28 00:51:43','0','4','1598500794','100','1'),('196','Designing LinkedIn Post for Wavestone Webinar/Webcast Series','1598497473','182','','2021-01-02 06:01:38','0','1006','1601089473','100','1'),('197','Designing LinkedIn Quote Post for Wavestone ','1598499711','182','','2021-01-02 06:00:45','0','1006','1601091711','100','1'),('198','Write Social Ad Copy on an Infographic','1598500125','214','','2020-08-28 14:32:00','0','1006','1601092125','100','1'),('199','Citadel #105 - Deck Beautification for eOriginal Kick-Off Meeting ','1598505252','266','','2020-09-01 05:34:21','0','4','1598938444','100','1'),('200','Citadel #177 - Write campaign copy for a 2X blog (email and one organic social post)','1598515282','214','','2020-09-02 03:06:17','0','4','1599012733','100','1'),('201','How to rebrand an eOriginal infographic on Powerpoint','1598516825','226','','2020-08-28 14:18:59','0','1006','1601108825','100','1'),('202','Enhancing an Event Presentation Deck (FIS InFocus) for eOriginal','1598516897','181','','2020-08-27 15:28:46','0','1006','1601108897','100','1'),('203','eOriginal & RMS Meeting Deck Beautification','1598519493','181','','2020-08-27 15:01:18','0','1006','1601111493','100','1'),('204','Create Email Thumbnail for eOriginal SBA Email Campaign','1598523852','181','','2020-08-27 15:05:10','0','1006','1601115852','100','1'),('205','How to set up a LinkedIn brand awareness campaign','1598531126','83','','2020-08-28 05:58:55','0','1006','1601123126','100','1'),('206','Add video in landing page','1598532025','243','','2020-08-27 15:17:06','0','1006','1601124025','100','1'),('207','How to set up a LinkedIn demand gen campaign with Carousel Ad','1598533140','83','','2020-08-27 15:29:54','0','1006','1601125140','100','1'),('208','Identifying a persona using Crystalknows','1598543077','255','','2020-08-28 14:43:00','0','1006','1601135077','100','1'),('209','Xeeva Whitepaper Rebranding','1598545572','181','','2020-08-28 14:48:58','0','1006','1601137572','100','1'),('210','How to Import Contact List into SharpSpring','1598579138','120','','2020-08-29 02:16:43','0','1006','1601171138','100','1'),('211','Explainer Video for Hyland & B2B Marketing (Part 1 : Storyboard)','1598583771','161','','2020-08-28 03:02:51','0','1006','1601175771','0','-1'),('212','Explainer Video for Hyland & B2B Marketing (Part 1 : Storyboard)','1598583776','161','','2020-08-28 03:02:56','0','1006','1601175776','0','-1'),('213','Animated Explainer Video for Hyland & B2B Marketing (Part 1 : Storyboard)','1598584005','161','','2020-08-31 14:55:21','0','1006','1601176005','100','1'),('214','Designing Display Ads for Wavestone Papers','1598585019','182','','2021-01-02 06:00:10','0','1006','1601177019','100','1'),('215','Designing Display Ads for Wavestone Papers','1598585028','182','','2020-08-28 03:28:39','0','1006','1601177028','0','-1'),('216','Enhancing an eOriginal Internal Deck for a C-Level Meeting','1598593246','226','','2020-08-28 15:08:24','0','1006','1601185246','100','1'),('217','Routing leads to Televerde','1598600189','229','','2020-09-01 14:26:40','0','1006','1601192189','100','1'),('218','Citadel #133 - Match Content to Buyer’s Journey Stages ','1598602470','270','','2020-09-03 01:46:13','0','4','1599039548','100','1'),('219','One-voice SAP\'s AEF/Blast E-mails ','1598607390','253','','2020-09-22 00:14:52','0','1006','1601199390','100','1'),('220','Ryder Case Study Design','1598611477','181','','2020-09-22 09:27:09','0','1006','1601203477','100','1'),('221','How to set up Text Ad on LinkedIn','1598614962','83','','2020-08-28 15:17:00','0','1006','1601206962','100','1'),('222','How to verify LinkedIn Ad charges from 2X credit card statement','1598617394','83','','2020-08-28 15:32:24','0','1006','1601209394','0','-1'),('223','Citadel #77 - Enhancing a Quarterly Business Review presentation deck for eOriginal','1598629611','236','','2020-09-03 10:23:15','0','4','1599099513','100','1'),('224','How to set up a LinkedIn Sponsored InMail/Message Ad Campaign for Demand Generation','1598665205','83','','2020-08-29 12:32:10','0','1006','1601257205','100','1'),('225','How to Import Contact List into SendInBlue','1598666146','120','','2020-08-31 13:26:35','0','1006','1601258146','100','1'),('226','How to set up Message Ad on LinkedIn','1598702101','83','','2020-08-31 13:29:29','0','1006','1601294101','100','1'),('227','Enhance a Wavestone Deck for a C-Level Meeting','1598766879','226','','2020-08-31 13:34:08','0','1006','1601358879','100','1'),('228','Citadel #165 - Automating Data Enrichment on Zoominfo using Python','1598773577','228','','2020-09-01 06:06:38','0','4','1598940400','100','1'),('229','How to Schedule Social Posts on HubSpot (CareATC\'s content)','1598777927','69','','2020-09-21 23:27:26','0','1006','1601369927','100','1'),('230','Citadel #151 - Creating an opportunity pipeline graph (Salesforce & Microsoft Excel)','1598781614','228','','2020-09-01 08:26:42','0','4','1598948806','100','1'),('231','Citadel #203 - Enhancing use case PPT slides for Client Presentations','1598789713','250','','2020-08-30 12:15:13','0','4','1601381713','0','-1'),('232','How to Create Suppression List on SharpSpring','1598792565','120','','2020-08-31 13:44:31','0','1006','1601384565','100','1'),('233','Deploying Google Analytics with Google Tag Manager','1598799194','34','','2020-09-01 14:32:12','0','1006','1601391194','100','1'),('234','Redemption of 2X Umbrella','1598802983','256','','2020-08-30 15:56:23','0','1007','1601394983','100','1'),('235','Rebrand an existing powerpoint deck to Wavestone branding and remove client’s name','1598803447','236','','2020-12-20 09:19:27','0','1006','1601395447','100','1'),('236','Creating a LinkedIn Campaign to Promote Client’s LinkedIn Page for Followers','1598847215','83','','2020-08-31 13:47:31','0','1006','1601439215','100','1'),('237','Rebranding Apptio Datasheet','1598848249','145','','2020-08-31 15:04:32','0','1006','1601440249','100','1'),('238','Extract client’s brand elements from 3SI Security website','1598850962','4','','2020-09-01 03:22:33','0','1006','1601442962','100','1'),('239','Create CareATC landing page template wireframe','1598851950','4','','2020-10-01 13:53:27','0','1006','1601443950','100','1'),('240','Create CareATC thank you page template wireframe','1598852287','4','','2020-09-29 16:12:10','0','1006','1601444287','100','1'),('241','Create CareATC mobile responsive landing page template wireframe','1598853125','4','','2020-10-01 13:51:31','0','1006','1601445125','100','1'),('242','Create CareATC mobile responsive thank you page template wireframe','1598853411','4','','2020-10-01 13:50:46','0','1006','1601445411','100','1'),('243','Create CareATC content asset thumbnail for landing page','1598854653','4','','2020-09-03 14:54:44','0','1006','1601446653','100','1'),('244','Creating an Infographic for DELMIA 3DLean','1598871193','252','','2020-08-31 14:46:38','0','1006','1601463193','100','1'),('245','Complete Rebranding of White Paper (WGroup to Wavestone format)','1598874807','182','','2020-09-01 05:53:07','0','1006','1601466807','100','1'),('246','How to set up LinkedIn Follower Ad','1598875440','83','','2020-08-31 14:19:59','0','1006','1601467440','100','1'),('247','Selecting CareATC font type for their campaign communication asset ','1598875683','4','','2020-09-02 14:21:48','0','1006','1601467683','100','1'),('248','Complete Rebranding of Cheat Sheet (WGroup to Wavestone format)','1598875786','182','','2020-09-01 05:53:17','0','1006','1601467786','100','1'),('249','Create CareATC CTA button for their campaign communication asset ','1598876016','4','','2020-09-01 14:34:23','0','1006','1601468016','0','1'),('250','Layout Wavestone White Paper from Word Document','1598886736','182','','2020-09-01 14:00:29','0','1006','1601478736','100','1'),('251','Enhancing eOriginal Internal Jam Session Deck for ClosingCenter Meeting','1598886987','181','','2020-08-31 15:41:04','0','1006','1601478987','100','1'),('252','How to share social post via Sharpspring','1598888566','225','','2020-09-08 00:28:16','0','1006','1601480566','100','1'),('253','Layout Wavestone Cheat Sheet from Word Document','1598888794','182','','2020-09-01 14:04:01','0','1006','1601480794','100','1'),('254','Create a logo for Rocket Inclusion, Diversity & Equity (RIDE) workgroup','1598889150','251','','2020-09-01 06:32:24','0','1006','1601481150','100','1'),('255','Redemption of 2X Umbrella','1598917674','85','','2020-08-31 23:47:54','0','1007','1601509674','100','1'),('256','Citadel #137 - SQL 101 for those with zero experience','1598927192','256','','2020-09-01 02:26:32','0','4','1601519192','0','1'),('257','Create PPC form fill landing page and confirmation page','1598948098','243','','2020-09-01 14:54:35','0','1006','1601540098','100','1'),('258','Create from hanlders for PPC and RT pages','1598948210','243','','2020-09-01 14:47:32','0','1006','1601540210','100','1'),('259','Anglicize UK Pages by Pearl Extension','1598948411','243','','2020-09-01 14:51:40','0','1006','1601540411','100','1'),('260','Create New Drip Email List in SharpSpring','1598948603','243','','2020-09-01 15:05:58','0','1006','1601540603','100','1'),('261','Integrating Zapier with Google Sheets','1598957606','121','','2020-09-15 14:51:01','0','1006','1601549606','100','1'),('262','How to do the Digital Advertising Weekly Report','1599011029','260','','2020-09-03 02:47:07','0','1006','1601603029','100','1'),('263','Citadel #236 - Creating a LinkedIn Campaign to Promote Client’s LinkedIn Page for Followers','1599012416','260','','2020-09-02 08:20:09','0','4','1599034794','100','1'),('264','Citadel #163 - How to create an LinkedIn advertising campaign performance report','1599016257','260','','2020-09-02 03:10:57','0','4','1601608257','0','-1'),('265','Citadel #176 - Creating a LinkedIn advertising A/B test report for client presentation','1599016310','260','','2020-09-02 03:11:50','0','4','1601608310','0','-1'),('266','Citadel #192 - Setting up conversion tracking on LinkedIn Advertising Campaigns','1599016334','260','','2020-09-02 07:05:01','0','4','1599029838','100','1'),('267','Citadel #236 - Creating a LinkedIn Campaign to Promote Client’s LinkedIn Page for Followers','1599016393','260','','2020-09-02 03:13:13','0','4','1601608393','0','-1'),('268','Citadel #224 - Setting up a LinkedIn Sponsored InMail/Message Ad Campaign ','1599016396','260','','2020-09-02 08:17:48','0','4','1599034673','100','1'),('269','Citadel #207 - Setting up a LinkedIn Advertising campaign with Carousel Ad','1599016400','260','','2020-09-02 08:22:14','0','4','1599034917','100','1'),('270','Citadel #178 - Creating a Website Audience List for LinkedIn retargeting campaigns','1599016451','260','','2020-09-02 08:39:00','0','4','1599035409','100','1'),('271','Citadel #221 - Setting up LinkedIn Advertising Text Ad campaign','1599016510','260','','2020-09-09 07:10:57','0','4','1599635461','100','1'),('272','Citadel #205 - Setting up a LinkedIn Advertising campaign for brand awareness ','1599016537','260','','2020-09-02 08:25:17','0','4','1599035141','100','1'),('273','Citadel #190 - Setting up a retargeting campaign on LinkedIn','1599016540','260','','2020-09-09 07:36:39','0','4','1599637002','100','1'),('274','Citadel #226 - Setting up a Message Ad Campaign on LinkedIn','1599016864','260','','2020-10-26 13:32:19','0','4','1603719119','100','1'),('275','Redemption of 2X Umbrella','1599017395','121','','2020-09-02 03:29:55','0','1007','1601609395','100','1'),('276','Redemption of 2X Umbrella','1599017485','83','','2020-09-02 03:31:25','0','1007','1601609485','100','1'),('277','Redemption of 2X Umbrella','1599017552','260','','2020-09-02 03:32:32','0','1007','1601609552','100','1'),('278','Citadel #226 - Setting up a Message Ad Campaign on LinkedIn','1599024503','260','','2020-09-02 05:28:23','0','4','1601616503','0','-1'),('279','Citadel #124 - Develop 3 messaging angles and initial content topics for Xeeva (a former 2X client)','1599041926','271','','2020-09-07 01:42:50','0','4','1599442975','100','1'),('280','Citadel #177 - Write campaign copy for a 2X blog (email and one organic social post)','1599044980','253','','2020-09-03 09:35:55','0','4','1599126214','100','1'),('281','Compiling hard bounces from an email campaign using Pardot\'s dynamic list','1599057142','256','','2020-09-12 13:42:46','0','1006','1601649142','100','1'),('282','Citadel #100 - Develop a content atomization plan','1599103491','270','','2020-09-03 03:24:51','0','4','1601695491','0','-1'),('283','Redemption of 2X Umbrella (Limited!)','1599109238','182','','2020-09-03 05:00:38','0','1007','1601701238','100','1'),('284','Redemption of 2X Umbrella (Limited!)','1599110362','226','','2020-09-03 05:19:22','0','1007','1601702362','100','1'),('285','Citadel #167 - Do a light(er) edit on an SEO article ','1599118026','253','','2020-09-10 02:48:52','0','4','1599476411','100','1'),('286','Citadel #100 - Develop a content atomization plan','1599122223','270','','2020-09-03 08:37:03','0','4','1601714223','0','-1'),('287','Enhancing an eOriginal Sales Deck','1599123840','226','','2020-09-03 15:19:59','0','1006','1601715840','100','1'),('288','Citadel #177 - Write campaign copy for a 2X blog (email and one organic social post)','1599136019','270','','2020-09-03 12:26:59','0','4','1601728019','0','-1'),('289','Creating a chatbot workflow in SharpSpring','1599184214','34','','2020-09-04 03:16:04','0','1006','1601776214','100','1'),('290','Citadel #220 - Designing a Case Study asset from a word doc','1599187853','266','','2020-09-07 02:02:07','0','4','1599444104','100','1'),('291','Reformat the slides based on Wavestone\'s branding','1599188148','226','','2020-09-04 13:53:03','0','1006','1601780148','100','1'),('292','Redemption of 2X Umbrella (Limited!)','1599193287','253','','2020-09-04 04:21:27','0','1007','1601785287','0','-1'),('293','Creating a presentation deck for eO\'s webinar','1599201707','226','','2020-09-04 13:59:55','0','1006','1601793707','100','1'),('294','Email Testing on EmailOnAcid','1599201979','258','','2022-10-06 10:49:02','0','1006','1601793979','100','1'),('295','Edit page URL on Marketo','1599203184','139','','2021-08-16 07:51:22','0','1006','1601795184','100','1'),('296','Citadel #75 - Setting up UTM tracking URL for email campaigns with custom Prospect ID','1599209958','274','','2020-09-04 08:59:18','0','4','1609387786','100','1'),('297','Citadel #190 - Setting up a retargeting campaign on LinkedIn','1599210268','274','','2020-10-30 04:50:18','0','4','1604033421','100','1'),('298','Redemption of 2X Umbrella (Limited!)','1599210764','271','','2020-09-04 09:12:44','0','1007','1601802764','0','1'),('299','Build Animation in Powerpoint Presentation','1599213001','181','','2020-09-07 14:26:13','0','1006','1601805001','100','1'),('300','Redemption of 2X Umbrella (Limited!)','1599213616','236','','2020-09-04 10:00:16','0','1007','1601805616','100','1')
Invalid query: Table 'academy.request_project' doesn't exist