Spreadsheet: 784437d1655734947-googlesheets-pulling-data-from-a-set-of-dynamic-data-sample
Sheet: Renewal Status Tracker

Client Name | Duration | URL | Status | Start Date | End Date | Contact Number | Name | [NAME] | Follow Up By | Call to Setup Meeting | 1st call date | 1st Call Status | 2nd Call | 2nd call status | 3rd Call | 3rd call status | Meeting Scheduled | Meeting Attended | Call Attended | 1st Meeting Attended Date | 2nd Meeting attended Date | Over 3 time of meeting | Rejection reason | 1st follow up date | 1st follow up date (status) | 2nd follow up date | 2nd follow up date (status) | 3rd follow up date | 3rd follow up date (status) | 4th follow up date | 4th follow up date (status) | Payment Date | [NAME] | Renewal (Y/N) | Forecasted Renewal (Y/N)
S.M (Samas) Enterprises Sdn Bhd | 12 | https://www.smsamas.com/ | Ended | 2021-01-04 00:00:00 | 2022-01-04 00:00:00 | [PHONE] | Mr.[NAME] | [EMAIL] | Ling | Yes | 2021-11-02 00:00:00 | to call bk on 3 Nov 2021 | 2021-11-03 00:00:00 | went through discussion over phone, he aslright wit the performance and renewal for anothed year. would like to change the outlook oh website homepage as some client tell him his web looks the same for whole year ady. He also looking to receive some keywords sharing, so that he can feedback if any other keywords to be added/feedback to us for better performance adjustments | NA | NA | Yes | Yes | Yes | NA | NA | No |  |  |  |  |  |  |  |  |  | 2021-11-24 00:00:00 | Yes | Yes | Yes
SEVEN STAR PACKING SERVICES SDN BHD | 3 | https://sevenstar.com.my/ | Ended | 2021-01-15 00:00:00 | 2021-05-11 00:00:00 | [PHONE] | Mr.[NAME] | [EMAIL] | [NAME] | Yes | NA | NA | NA | NA | NA | NA | No | No | No | NA | NA | No |  |  |  |  |  |  |  |  |  | NA | No | No | No
MULTI FOCUS ENTERPRISE SDN BHD (1127733-T) | 3 | https://multifocus.com.my/ | Ended | 2021-01-15 00:00:00 | 2021-06-15 00:00:00 | [PHONE] | Ms. [NAME] | [EMAIL] | [NAME] | Yes | NA | NA | NA | NA | NA | NA | No | No | No | NA | NA | No |  |  |  |  |  |  |  |  |  | NA | No | No | No
BOON CHYE RENOVATION & CONSTRUCTION | 6 | http://kontraktor-rumah.com.my/ | Ended | 2021-03-15 00:00:00 | 2021-08-15 00:00:00 | [PHONE] | Mr.[NAME] | [EMAIL] [EMAIL] | [NAME] | No | NA | NA | NA | NA | NA | NA | Yes | Yes | Yes | NA | NA | No |  |  |  |  |  |  |  |  |  | NA | No | Yes | No
LANTECH RESOURCES | 3 | https://www.spygadgets.com.my/ | Ended | 2021-04-20 00:00:00 | 2021-12-20 00:00:00 | [PHONE] | Mr.[NAME] | [EMAIL] | Ling | Yes | 2021-11-03 00:00:00 | to call back | 2021-11-08 00:00:00 | no picking up | 2022-01-12 00:00:00 | [NAME] | Yes | Yes | Yes | NA | NA | No |  |  |  |  |  |  |  |  |  | NA | No | No | No
Livingscape Design | 3 | https://livingscape.com.my/ | Ended | 2021-02-15 00:00:00 | 2021-05-15 00:00:00 | [PHONE] | Mr.[NAME] | [EMAIL] | [NAME] | Yes | NA | NA | NA | NA | NA | NA | No | No | No | NA | NA | No |  |  |  |  |  |  |  |  |  | NA | No | No | No
Kollect Systems Sdn Bhd | 4 | https://kollect.biz/ | Ended | 2021-07-15 00:00:00 | 2021-11-15 00:00:00 | [PHONE] | Mr.[NAME] | [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | Yes | Yes | Yes | NA | NA | No |  |  |  |  |  |  |  |  |  | NA | No | No | No
Eastern Gases Trading Sdn Bhd | 3 | http://easternwelding.com.my/ | Ended | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | [PHONE] | Mr.[NAME] | [EMAIL] | Ling | Yes | 2021-11-03 00:00:00 | asked how to differentiate the enquiries from Orion with New Pages.  10+ enquiries from Orion and coversion is about 50%, satisfied with the performance as by comparing ours with New Pages, he received more related enquiries. | 2021-11-08 00:00:00 | he will monitor the performance again before renewal | 2021-12-01 00:00:00 | not much enquiry, want to monitor further | Yes | Yes | Yes | 2021-12-15 00:00:00 | NA | No |  | 2021-12-16 00:00:00 | client mentioned the result seems not much diff with new pages, althought got traffic and enquiries but low conversion. He wants to hold first. He said althought got enquiries but enquiries not those he want to focus, asked him to share the product he wants to focus and review the performance again in the next few weeks |  |  |  |  |  |  | NA | No | No | No
KK Officepoint Sdn. Bhd. | 6 | https://kk-officepointsg.com/ | Ended | 2021-08-01 00:00:00 | 2022-01-31 00:00:00 | [PHONE] | Ms.[NAME] | [EMAIL] | [NAME] | No | NA | NA | NA | NA | NA | NA | No | No | No | NA | NA | No |  |  |  |  |  |  |  |  |  | 2022-01-11 00:00:00 | Yes | Yes | Yes
SAUCE EMPIRE MANUFACTURING SDN BHD | 12 | https://nyolike.com/ | Ended | 2021-02-01 00:00:00 | 2022-02-01 00:00:00 | 60 17-664 6809 | Mr. [NAME] Mr. [NAME] | [EMAIL] [EMAIL] | Ling | Yes | 2021-12-16 00:00:00 | went through call for sending DM renewal invoice | NA | NA | NA | NA | Yes | Yes | Yes | NA | NA | No |  | 2021-10-25 00:00:00 | agreed to renew for the DM, sent invoice | 2021-10-29 00:00:00 | followed up payment status | 2021-11-02 00:00:00 | followed up payment, said waiting boss ([NAME]) to approve | 2021-11-05 00:00:00 | followed up payment, said waiting boss ([NAME]) to approve | 2021-12-30 00:00:00 | Yes | Yes | Yes
ACTIVE NETWORK SECURITY SERVICES SDN BHD | 12 | https://activesecurity.com.my/ | Ended | 2021-02-15 00:00:00 | 2022-02-15 00:00:00 | [PHONE],  011-33938958 | Ms. [NAME] Ms. [NAME]  Mr. [NAME] Mr. [NAME]. Ms. [NAME] | [EMAIL] [EMAIL] [EMAIL] [EMAIL] [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | Yes | Yes | Yes | NA | NA | No |  |  |  |  |  |  |  |  |  | 2022-01-20 00:00:00 | Yes | Yes | Yes
BOON CHYE RENOVATION & CONSTRUCTION-2nd | 6 | http://kontraktor-rumah.com.my/ | Ended | 2021-08-15 00:00:00 | 2022-02-15 00:00:00 | [PHONE] | Mr.[NAME] | [EMAIL] [EMAIL] | [NAME] | No | NA | NA | NA | NA | NA | NA | No | No | No | NA | NA | No |  |  |  |  |  |  |  |  |  | NA | No | No | Yes
Little Nature Explorer Sdn Bhd | 12 | https://www.oshandpiper.com/ | Ended | 2021-02-15 00:00:00 | 2022-01-06 00:00:00 | [PHONE] | [NAME] | [EMAIL] | Ling | Yes | 2022-01-03 00:00:00 | meeting set on 11 January 2022 | NA | NA | NA | NA | Yes | Yes | No | NA | NA | No |  |  |  |  |  |  |  |  |  | NA | No | No | No
Pro Aces Marketing Sdn Bhd | 12 | https://ppesupply.com.my/ | Running | 2021-04-15 00:00:00 | 2022-04-15 00:00:00 | [PHONE] | [NAME] | [EMAIL] | Ling | Yes | 2022-02-15 00:00:00 | meeting set on 23 Feb 2022 (postpone) | NA | NA | NA | NA | Yes | Yes |  | 2022-03-17 00:00:00 | - |  |  |  |  |  |  |  |  |  |  | 2022-03-29 00:00:00 | Yes | Yes | Yes
Vinwei Marketing | 3 | http://www.vinweipack.com/ | Ended | 2021-11-01 00:00:00 | 2022-01-31 00:00:00 | [PHONE] | Mr [NAME] | [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | No | No
[NAME] Bhd | 12 | https://chemin.com.my/ | Running | 2021-01-01 00:00:00 | 2022-05-01 00:00:00 | 010- 210 3154  012- 384 2925 | Ms. [NAME] Ms. [NAME] | [NAME] | Ling | Yes | 2022-02-15 00:00:00 | No Ans | 2022-02-23 00:00:00 | No Ans | NA | NA | No | Yes
ARCHTRON RESEARCH & DEVELOPMENT SDN BHD | 12 | https://bluguard.com.my/ | Running | 2021-01-04 00:00:00 | 2022-05-04 00:00:00 | [PHONE] | Ms. [NAME] | [EMAIL] | Ling | Yes | 2022-02-15 00:00:00 | meeting set on 24 Feb 2022 | NA | NA | NA | NA | Yes | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Star Wheels Electronic Sdn Bhd | 12 | https://starwheels.com.my/ | Running | 2021-05-03 00:00:00 | 2022-05-03 00:00:00 | [PHONE] | Mr.[NAME] | [EMAIL] | Ling | Yes | 2022-02-15 00:00:00 | No Ans | 2022-02-18 00:00:00 | No Ans | 2022-02-23 00:00:00 | No Ans | No | No
GE GREEN SDN BHD | 12 | https://pacifica.my/ | Running | 2021-01-01 00:00:00 | 2022-05-01 00:00:00 | [PHONE] | Ms.[NAME] | [EMAIL] | Ling | Yes | 2022-02-15 00:00:00 | meeting set on 24 Feb 2022 | NA | NA | NA | NA | Yes | Yes
Gigamach Sdn Bhd | 3 | https://gigamach.com/ | Running | 2021-12-15 00:00:00 | 2022-03-15 00:00:00 | [PHONE] [PHONE] | Mr. [NAME] [NAME] | [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | Yes | No
Red Ant Print Sdn. Bhd. | 12 | https://redant.com.my/ | Running | 2021-01-15 00:00:00 | 2022-05-15 00:00:00 | 0 19-314 1234 | Mr. [NAME] | [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | Yes | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Yes
HSH Transportation Sdn Bhd | 12 | https://hshtrans.com/ | Running | 2021-01-15 00:00:00 | 2022-05-15 00:00:00 | [PHONE] [PHONE] | Mr. [NAME] Mr. [NAME] | [EMAIL] [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | Yes | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | No | No | No
Team Power Marketing Sdn Bhd | 12 | https://officefurnitureasia.com/ | Running | 2021-01-15 00:00:00 | 2022-05-15 00:00:00 | [PHONE] | Mr. [NAME] | [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | Yes | No
JJ Furniture | 12 | https://www.jjfurniture.com.my/ | Running | 2021-01-15 00:00:00 | 2022-05-15 00:00:00 | 0 19-212 3433 | MR. Chew | [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | Yes | Yes |  | 2022-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2022-03-10 00:00:00 | Yes | Yes | Yes
[NAME] | 12 | https://vicfil.com/ | Running | 2021-05-15 00:00:00 | 2022-05-14 00:00:00 | [PHONE] | Mr. [NAME] | [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | Yes | Yes |  | 2022-04-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Yes
IJUS Fruits Sdn Bhd | 6 | https://www.ijusfruits.com.my/ | Running | 2021-11-15 00:00:00 | 2022-05-15 00:00:00 | [PHONE] | Ms. [NAME] | [EMAIL] | Ling | Yes | NA | NA | NA | NA | NA | NA | Yes | Yes |  | 2022-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Yes
Green House Ingredient Sdn Bhd
ORION Food Industries (M) Sdn. Bhd
[NAME] Bhd
Wenyip Knitwear Industries Sdn Bhd
Active Developers Sdn Bhd