Subject: Re: LiveChat - googleSheet columns
From: Kieran Harris <[email-masked]>
To: "Weibrecht, Karen (AE/GVM)" <[email-masked]>
Cc: Sahil Modgil Consultant - IT <[email-masked]>, Saurabh Dadu <[email-masked]>, Chris Barnes <[email-masked]>, "Joshi, Pooja (AE/GAM)" <[email-masked]>, ashwinee <[email-masked]>
Date: Tue, 8 Dec 2020 09:28:50 +0200

We are just waiting for the adapted code from @Saurabh and we can push live

Kind regards / شاكرين لكم على حسن تعاونكم / Viele Grüsse

Kieran Harris
Web and IT Department

TheProject Media & Advertising
South Africa
Tel: +27-11-646-06-16
Mail: [email-masked] <mailto:[email-masked]>
Web: theproject.co.za <http://theproject.co.za/>

> On 08 Dec 2020, at 09:01, Weibrecht, Karen (AE/GVM) <[email-masked]> wrote:
> 
> Hi guys
> Can you please let me know status on this?
>  
> From: Kieran Harris <[email-masked]> 
> Sent: 07 December 2020 14:12
> To: Sahil Modgil Consultant - IT <[email-masked]>; Saurabh Dadu <[email-masked]>
> Cc: Chris Barnes <[email-masked]>; Joshi, Pooja (AE/GAM) <[email-masked]>; ashwinee <[email-masked]>; Weibrecht, Karen (AE/GVM) <[email-masked]>
> Subject: Re: LiveChat - googleSheet columns
>  
> Here are the URLs
>  
> https://www.vwcertifiedusedcars.me/en/abu-dhabi <https://www.vwcertifiedusedcars.me/en/abu-dhabi>
> https://www.vwcertifiedusedcars.me/en/bahrain <https://www.vwcertifiedusedcars.me/en/bahrain>
> https://www.vwcertifiedusedcars.me/en/dubai-northern-emirates <https://www.vwcertifiedusedcars.me/en/dubai-northern-emirates>
> https://www.vwcertifiedusedcars.me/en/kuwait <https://www.vwcertifiedusedcars.me/en/kuwait>
> https://www.vwcertifiedusedcars.me/en/saudi-arabia <https://www.vwcertifiedusedcars.me/en/saudi-arabia>
> https://www.vwcertifiedusedcars.me/en/oman <https://www.vwcertifiedusedcars.me/en/oman>
> https://www.vwcertifiedusedcars.me/en/qatar <https://www.vwcertifiedusedcars.me/en/qatar>
> https://www.vwcertifiedusedcars.me/en/jordan <https://www.vwcertifiedusedcars.me/en/jordan>
> https://www.vwcertifiedusedcars.me/en/lebanon <https://www.vwcertifiedusedcars.me/en/lebanon>
>  
> https://www.vwcertifiedusedcars.me/ar/abu-dhabi <https://www.vwcertifiedusedcars.me/ar/abu-dhabi>
> https://www.vwcertifiedusedcars.me/ar/bahrain <https://www.vwcertifiedusedcars.me/ar/bahrain>
> https://www.vwcertifiedusedcars.me/ar/dubai-northern-emirates <https://www.vwcertifiedusedcars.me/ar/dubai-northern-emirates>
> https://www.vwcertifiedusedcars.me/ar/kuwait <https://www.vwcertifiedusedcars.me/ar/kuwait>
> https://www.vwcertifiedusedcars.me/ar/saudi-arabia <https://www.vwcertifiedusedcars.me/ar/saudi-arabia>
> https://www.vwcertifiedusedcars.me/ar/oman <https://www.vwcertifiedusedcars.me/ar/oman>
> https://www.vwcertifiedusedcars.me/ar/qatar <https://www.vwcertifiedusedcars.me/ar/qatar>
> https://www.vwcertifiedusedcars.me/ar/jordan <https://www.vwcertifiedusedcars.me/ar/jordan>
> https://www.vwcertifiedusedcars.me/ar/lebanon <https://www.vwcertifiedusedcars.me/ar/lebanon>
>  
>  
> https://www.audiapproved.com/en/abu-dhabi <https://www.audiapproved.com/en/abu-dhabi>
> https://www.audiapproved.com/en/bahrain <https://www.audiapproved.com/en/bahrain>
> https://www.audiapproved.com/en/dubai-northern-emirates <https://www.audiapproved.com/en/dubai-northern-emirates>
> https://www.audiapproved.com/en/kuwait <https://www.audiapproved.com/en/kuwait>
> https://www.audiapproved.com/en/saudi-arabia <https://www.audiapproved.com/en/saudi-arabia>
> https://www.audiapproved.com/en/oman <https://www.audiapproved.com/en/oman>
> https://www.audiapproved.com/en/qatar <https://www.audiapproved.com/en/qatar>
> https://www.audiapproved.com/en/jordan <https://www.audiapproved.com/en/jordan>
> https://www.audiapproved.com/en/lebanon <https://www.audiapproved.com/en/lebanon>
>  
> https://www.audiapproved.com/ar/abu-dhabi <https://www.audiapproved.com/ar/abu-dhabi>
> https://www.audiapproved.com/ar/bahrain <https://www.audiapproved.com/ar/bahrain>
> https://www.audiapproved.com/ar/dubai-northern-emirates <https://www.audiapproved.com/ar/dubai-northern-emirates>
> https://www.audiapproved.com/ar/kuwait <https://www.audiapproved.com/ar/kuwait>
> https://www.audiapproved.com/ar/saudi-arabia <https://www.audiapproved.com/ar/saudi-arabia>
> https://www.audiapproved.com/ar/oman <https://www.audiapproved.com/ar/oman>
> https://www.audiapproved.com/ar/qatar <https://www.audiapproved.com/ar/qatar>
> https://www.audiapproved.com/ar/jordan <https://www.audiapproved.com/ar/jordan>
> https://www.audiapproved.com/ar/lebanon <https://www.audiapproved.com/ar/lebanon>
> 
> 
> 
> Kind regards / شاكرين لكم على حسن تعاونكم / Viele Grüsse
> 
> Kieran Harris
> Web and IT Department
> 
> TheProject Media & Advertising
> South Africa
> Tel: +27-11-646-06-16
> Mail: [email-masked] <mailto:[email-masked]>
> Web: theproject.co.za <http://theproject.co.za/>
> 
> 
> On 07 Dec 2020, at 10:52, Kieran Harris <[email-masked] <mailto:[email-masked]>> wrote:
>  
> Hi @Sahil
>  
> We will push the live chat script onto the Used car sites today.
>  
> In terms of salesforce its all handled from the Live chat code, so there shouldn’t be any concerns.
>  
> The only thing is to make sure that all enquiries from these URLs are set as used car.
>  
> We are going to use the same live chat script as new car, unless there is a different one?
>  
> https://www.audiapproved.com/ <https://www.audiapproved.com/>
> http://vwcertifiedusedcars.me/ <http://vwcertifiedusedcars.me/>
> 
> 
> Thanks
> 
> Kind regards / شاكرين لكم على حسن تعاونكم / Viele Grüsse
> 
> Kieran Harris
> Web and IT Department
> 
> TheProject Media & Advertising
> South Africa
> Tel: +27-11-646-06-16
> Mail: [email-masked] <mailto:[email-masked]>
> Web: theproject.co.za <http://theproject.co.za/>
> 
> 
> On 07 Dec 2020, at 10:48, Weibrecht, Karen (AE/GVM) <[email-masked] <mailto:[email-masked]>> wrote:
>  
> @Sahil and Kieran, can you please test this today and once confirmed we can look at go live for all markets.
> Also KSA and Kuwait we need to confirm that Salesforce integration is working and test accordingly.
>  
> From: Kieran Harris <[email-masked] <mailto:[email-masked]>> 
> Sent: 07 December 2020 11:34
> To: Weibrecht, Karen (AE/GVM) <[email-masked] <mailto:[email-masked]>>
> Cc: Chris Barnes <[email-masked] <mailto:[email-masked]>>; Saurabh Dadu <[email-masked] <mailto:[email-masked]>>; Joshi, Pooja (AE/GAM) <[email-masked] <mailto:[email-masked]>>; Sahil Modgil Consultant - IT <[email-masked] <mailto:[email-masked]>>; ashwinee <[email-masked] <mailto:[email-masked]>>
> Subject: Re: LiveChat - googleSheet columns
>  
> Hi Karen, this should be smooth, we must just make sure all requests from used car are set as used car with the URL, but that should already be done.
>  
> Thanks
> 
> 
> 
> 
> Kind regards / شاكرين لكم على حسن تعاونكم / Viele Grüsse
> 
> Kieran Harris
> Web and IT Department
> 
> TheProject Media & Advertising
> South Africa
> Tel: +27-11-646-06-16
> Mail: [email-masked] <mailto:[email-masked]>
> Web: theproject.co.za <http://theproject.co.za/>
> 
> 
> 
> On 07 Dec 2020, at 09:29, Weibrecht, Karen (AE/GVM) <[email-masked] <mailto:[email-masked]>> wrote:
>  
> Awesome thank you.
> We have status call now at 12 dubai time to discuss timelines and details for used car go live. Is there anything else we have to be mindful of for implementation on used car website or this should be smooth?
>  
> From: Chris Barnes <[email-masked] <mailto:[email-masked]>> 
> Sent: 07 December 2020 11:25
> To: Weibrecht, Karen (AE/GVM) <[email-masked] <mailto:[email-masked]>>; 'Kieran Harris' <[email-masked] <mailto:[email-masked]>>
> Cc: 'Saurabh Dadu' <[email-masked] <mailto:[email-masked]>>; Joshi, Pooja (AE/GAM) <[email-masked] <mailto:[email-masked]>>; 'Sahil Modgil Consultant - IT' <[email-masked] <mailto:[email-masked]>>; 'ashwinee' <[email-masked] <mailto:[email-masked]>>
> Subject: RE: LiveChat - googleSheet columns
>  
> Done across all market sheets.
>  
> Kind regards,
>  
> Christopher Barnes   |   Web and IT
> [email-masked] <mailto:[email-masked]>      +27116460616 <tel:27116460616>
>  
> From: Chris Barnes <[email-masked] <mailto:[email-masked]>> 
> Sent: Monday, December 7, 2020 8:50 AM
> To: 'Weibrecht, Karen (AE/GVM)' <[email-masked] <mailto:[email-masked]>>; 'Kieran Harris' <[email-masked] <mailto:[email-masked]>>
> Cc: 'Saurabh Dadu' <[email-masked] <mailto:[email-masked]>>; 'Joshi, Pooja (AE/GAM)' <[email-masked] <mailto:[email-masked]>>; 'Sahil Modgil Consultant - IT' <[email-masked] <mailto:[email-masked]>>; 'ashwinee' <[email-masked] <mailto:[email-masked]>>
> Subject: RE: LiveChat - googleSheet columns
>  
> Morning all,
>  
> Sorry for the delay.
>  
> Yeah of course we can quickly adjust the formula and implement on the sheets. We’re doing so ASAP this morning. Will confirm once all sheets are done.
>  
> Kind regards,
>  
> Christopher Barnes   |   Web and IT
> [email-masked] <mailto:[email-masked]>      +27116460616 <tel:27116460616>
>  
> From: Weibrecht, Karen (AE/GVM) <[email-masked] <mailto:[email-masked]>> 
> Sent: Sunday, December 6, 2020 8:15 AM
> To: Kieran Harris <[email-masked] <mailto:[email-masked]>>; 'Chris Barnes' ([email-masked] <mailto:[email-masked]>) <[email-masked] <mailto:[email-masked]>>
> Cc: Saurabh Dadu <[email-masked] <mailto:[email-masked]>>; Joshi, Pooja (AE/GAM) <[email-masked] <mailto:[email-masked]>>; Sahil Modgil Consultant - IT <[email-masked] <mailto:[email-masked]>>; ashwinee <[email-masked] <mailto:[email-masked]>>
> Subject: RE: LiveChat - googleSheet columns
>  
> Good morning guys
> Hope all had a good weekend.
>  
> @Chris, is the formula still available and can we have it on the sheets?
> We are planning to go live on used car website also shortly (ideally tomorrow but tbc)
>  
> From: Kieran Harris <[email-masked] <mailto:[email-masked]>> 
> Sent: 30 November 2020 11:01
> To: 'Chris Barnes' ([email-masked] <mailto:[email-masked]>) <[email-masked] <mailto:[email-masked]>>; Weibrecht, Karen (AE/GVM) <[email-masked] <mailto:[email-masked]>>
> Cc: Saurabh Dadu <[email-masked] <mailto:[email-masked]>>; Joshi, Pooja (AE/GAM) <[email-masked] <mailto:[email-masked]>>; Sahil Modgil Consultant - IT <[email-masked] <mailto:[email-masked]>>; ashwinee <[email-masked] <mailto:[email-masked]>>
> Subject: Re: LiveChat - googleSheet columns
>  
> Hi Karen in the past Chris created a formula to do this, @Chris can you adjust it with the new sheet column structure?
>  
> Thanks
>  
> 
> Kind regards / شاكرين لكم على حسن تعاونكم / Viele Grüsse
> 
> Kieran Harris
> Web and IT Department
> 
> TheProject Media & Advertising
> South Africa
> Tel: +27-11-646-06-16
> Mail: [email-masked] <mailto:[email-masked]>
> Web: theproject.co.za <http://theproject.co.za/>
>  
> 
> On 30 Nov 2020, at 08:53, Sahil Modgil Consultant - IT <[email-masked] <mailto:[email-masked]>> wrote:
>  
> Hi Karen,
> 
> Please find the attached sheet of leads we sent to API on 28th November. Please compare the data on your end as we don’t have access to the Google Sheet.
> Let me know if you found any issues so I can check on my end and rectify.
>  
>  
> From: Saurabh Dadu <[email-masked] <mailto:[email-masked]>> 
> Sent: 29 November 2020 09:00 PM
> To: Weibrecht, Karen (AE/GVM) <[email-masked] <mailto:[email-masked]>>
> Cc: Sahil Modgil Consultant - IT <[email-masked] <mailto:[email-masked]>>; [email-masked] <mailto:[email-masked]>; Joshi, Pooja (AE/GAM) <[email-masked] <mailto:[email-masked]>>; 'Chris Barnes' ([email-masked] <mailto:[email-masked]>) <[email-masked] <mailto:[email-masked]>>; ashwinee <[email-masked] <mailto:[email-masked]>>
> Subject: Re: LiveChat - googleSheet columns
>  
> Hi Karen
>  
> Will get back to you on everything tomorrow.
> 
> Regards,
>  
> Saurabh Dadu
> LiveSalesman
>  
> 
> On Nov 29, 2020, at 6:53 PM, Weibrecht, Karen (AE/GVM) <[email-masked] <mailto:[email-masked]>> wrote:
> 
>  
> Hi guys,
>  
> The integration to googlesheet seems to work now, which is good news.
> However – since we are only live now for NewCar the column which previously differentiated new and used car, is no used for the model name. (which is def information we want to capture)
> We however also need to add the differentiator for New/ used/ Aftersales somehow on the googlesheet please as we roll out more parts of LiveChat.
>  
> Option1: Can we add another column potentially which will have New/ used/ Aftersales as differentiator?
> Or please let me know what else is possible.
>  
> Thanks
> Karen 
>  
> Best regards/ Mit freundlichen Gruessen
>  
> Karen Weibrecht
> Marketing Manager
> Customer Experience and Brand Strategy
>  
> Volkswagen Middle East
> Audi Volkswagen Middle East FZE
> Dubai Airport Free Zone
> Mobile +971 50 450 7633
> http://www.volkswagen-me.com <http://www.volkswagen-me.com/>
>  
>  
> Important Notice: The above information is automatically added to this e-mail.
> This addition does not constitute a representation that the content of this e-mail is legally relevant and/or is intended to be legally binding upon Audi Volkswagen Middle East FZE.
>  
>  
> <leads-28Nov.xlsx>