Please enable JavaScript.
Coggle requires JavaScript to display documents.
Google sheets contain: 1- Visit Date & Hour / 2- Cellphone, From this…
Google sheets contain: 1- Visit Date & Hour / 2- Cellphone
Check the cellphone in Market Pro! DB
Registered?
Yes
< 24hrs from Visit
Yes
Ordered?
Yes
Obviously 1st order in < 24hrs from Visit
Lat & Long check
1 more item...
No
"New Registered Only"
No
Ordered?
Yes
1st order?
Yes
1 more item...
No
1 more item...
No
"Not Converted Visit"
No
"Not Registered - Only Visit"
From this analysis we want:
1- Status per visited cellphone
2- A report which contains:
2-1 # Visit
2-2 # of Not Converted Visit
2-3 # of Not Registered - Only Visit
2-4 # of New Registered Only
2-5 # of Acquired Location
2-6 # of New Order - FRAUD
2-7 # of Active Location
2-8 # of Churn Location