Skip to content

Instantly share code, notes, and snippets.

@limata3

limata3/cazoo_attrb_modelling_example.csv

Last active August 18, 2021 10:34
Show Gist options
  • Save limata3/e007e393902db80c80fa6e094b56e976 to your computer and use it in GitHub Desktop.
Save limata3/e007e393902db80c80fa6e094b56e976 to your computer and use it in GitHub Desktop.
Download ZIP
Different attribution models using a cazoo customer journey as exmaple
Raw
cazoo_attrb_modelling_example.csv
Customer Id Device Id Touchpoint Id Touchpoint Date Touchpoint Channel Touchpoint is Lead Touchpoint is Order first touchpoint credit last touchpoint to order credit last touchpoint to lead credit linear attribution to order credit linear attribution to lead credit position based to order credit position based to lead credit last touchpoint to order non dir credit last touchpoint to lead non dir credit linear attribution to order non dir credit linear attribution to lead non dir credit position based to order non dir credit position based to lead non dir credit
XYZ A 1 06/01/2021 Generic Paid Search 100.00% 0.00% 0.00% 4.76% 50.00% 40.00% 50.00% 0.00% 0.00% 5.56% 50.00% 40.00% 50.00%
XYZ B 2 07/01/2021 Facebook Ads TRUE 0.00% 0.00% 100.00% 4.76% 50.00% 1.05% 50.00% 0.00% 100.00% 5.56% 50.00% 1.25% 50.00%
XYZ A 3 07/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 4 07/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 5 08/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 6 08/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 7 08/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 8 09/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 9 09/01/2021 Direct 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
XYZ A 10 09/01/2021 Direct 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
XYZ A 11 09/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 12 09/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 13 09/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 14 10/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 15 10/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 16 11/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 17 11/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 18 11/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 19 11/01/2021 Direct 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
XYZ A 20 11/01/2021 Email 0.00% 0.00% 0.00% 4.76% 0.00% 1.05% 0.00% 0.00% 0.00% 5.56% 0.00% 1.25% 0.00%
XYZ A 21 11/01/2021 Organic Search TRUE 0.00% 100.00% 0.00% 4.76% 0.00% 40.00% 0.00% 100.00% 0.00% 5.56% 0.00% 40.00% 0.00%
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment