Subject: RE: LiveChat - googleSheet columns
From: "Weibrecht, Karen (AE/GVM)" <[email-masked]>
To: Kieran Harris <[email-masked]>, "'Chris Barnes' ([email-masked])" <[email-masked]>
Cc: Saurabh Dadu <[email-masked]>, "Joshi, Pooja (AE/GAM)" <[email-masked]>, Sahil Modgil Consultant - IT <[email-masked]>, ashwinee <[email-masked]>
Date: Sun, 6 Dec 2020 06:14:56 +0000

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]>
Sent: 30 November 2020 11:01
To: 'Chris Barnes' ([email-masked]) <[email-masked]>; Weibrecht, Karen (AE/GVM) <[email-masked]>
Cc: Saurabh Dadu <[email-masked]>; Joshi, Pooja (AE/GAM) <[email-masked]>; Sahil Modgil Consultant - IT <[email-masked]>; ashwinee <[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>