dataform_carwise

Carwise

Notion: https://www.notion.so/graindata/Carwise-3651a0d731004ee591ce81ecfcda9b4e

Calldrip helps Van Mossel salespeople communicate with the leads and make appointments at a branch to potentially convert the lead to a conversion. As soon as a customer expresses interest via submitting a form on the website for example, a lead is generated and sent to the LEF system. Later, the phone number of the customer is sent to Calldrip, and within 20 minutes Calldrip connects the customer with the salesperson. Each call has a status, whether it is answered, busy, missed, and many more. Depending on the amount of calls answered and number of appointments made Van Mossel can better understand how a salesperson is performing over a period of time.

Dataform pipeline

Green color: This color is used to represent the data sources declared.
Blue color: This color represents tables that are ready to be used in dashboards and/or share with the client.

Pipeline table details

Currently, we only consider data from "PVLEASECW" source in carwise data. All the tables related to privelease can be identified by "vmpl" in their names. By default, we select "PVLEASECW" source and data not older than 1000 days. Depending on the table, we add additional filter to select if they are relations or offers or contracts, etc.

1. carwise_pk: This is the table where data imported from the Carwise is stored in the Bigquery. We use a scheduled query to import data from the Powerkraut Carwise data storage. This scheduled query runs daily in the morning at 10 (Amsterdam timezone).

2. vmpl_carwise_relations_analytics: This table contains customer information such as house details, email, telephone, and other personal information.

3. vmpl_carwise_offers_analytics: This table contains details about privelease offers. Along with the default filters mentioned above, we select data of "VwFLeaseOfferPublisher" type.

4. vmpl_carwise_contracts_analytics: This view is created to change the field names such as branch to vestiging, etc and filter out specific clusters that match to the old flow in order to not break the dashboard.

5. vmpl_carwise_followup_reasons: This table helps to identify if the contracts that are about to expire or can be extended what is the followup reasons for them. This can mean that the