1 | Not Interested | 105.0 | API | Olark Chat | No | No | BLANK | No | Select | Modified | 01/08/2016-07/ 08/2016 | 25/07/2016-31/ 07/2016 | .0 | .0 | .0 | Select Speciali- zation | MAT | Select | Unemployed | Accounting/ Finance | Select | Better Career Prospects | Select | No | No | No | No | No | No | No | No | Interested in other courses | Low in Relevance | No | No | Select | Select | India | Consumer Durables | 02.Medium | 02.Medium | 15.0 | 15.0 | No | Select | Select | Select | Select | Select | Select | Select | Select | Select | Select | Select | 2 | 03-08-2016 12:00 | 31-07-2016 17:16 | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Unreachable | 120.0 | API | Organic Search | No | No | BLANK | No | Select | Email Opened | 08/08/2016-14/ 08/2016 | 08/08/2016-14/ 08/2016 | .0 | 5.0 | 2.5 | Mumbai | India | Select Speciali- zation | MAT | Select | Unemployed | Accounting/ Finance | Select | Better Career Prospects | Select | No | No | No | No | No | No | No | No | Ringing | No | No | Leads Support | Select | Select | India | Consumer Durables | 02.Medium | 02.Medium | 15.0 | 15.0 | No | Select | Select | Select | Select | Select | Select | Select | Select | Select | Select | Select | 2 | 08-08-2016 13:11 | 08-08-2016 13:11 | ||||||||||||||||||||||||||||||||||||||||
3 | Qualified | 150.0 | Landing Page Submission | Direct Traffic | No | No | BLANK | Yes | Select | Email Opened | 01/08/2016-07/ 08/2016 | 01/08/2016-07/ 08/2016 | 80.0 | 2.0 | 2.0 | Mumbai | Maharashtra | India | Business Administration | MAT | Select | Student | Accounting/ Finance | Select | Better Career Prospects | Select | No | No | No | No | No | No | No | No | Will revert after reading the email | Might be | No | No | Potential Lead | Mumbai | India | Consumer Durables | 02.Medium | 01.High | 14.0 | 20.0 | No | Select | Select | Immediate | Required for continuing current job | Well Aware | Distance MBA | Select | Useful | Select | Stopped studying formal courses long back | Medium Match | Took just information | 2 | 06-08-2016 12:59 | 06-08-2016 12:59 | ||||||||||||||||||||||||||||||||||||||
4 | Unreachable | 60.0 | Landing Page Submission | Direct Traffic | No | No | BLANK | No | Select | Modified | 01/08/2016-07/ 08/2016 | 01/08/2016-07/ 08/2016 | .0 | 1.0 | 1.0 | Mumbai | Maharashtra | India | Media and Advertising | MAT | Word Of Mouth | Unemployed | Accounting/ Finance | Select | Better Career Prospects | Select | No | No | No | No | No | No | No | No | Ringing | Not Sure | No | No | Select | Mumbai | India | Consumer Durables | 02.Medium | 01.High | 13.0 | 17.0 | No | Select | Select | Select | Select | Select | Select | Select | Select | Select | Select | Select | 2 | 03-08-2016 11:35 | 03-08-2016 11:34 | |||||||||||||||||||||||||||||||||||||||
5 | Qualified | 80.0 | Landing Page Submission | Google | No | No | BLANK | No | Select | Modified | 01/08/2016-07/ 08/2016 | 01/08/2016-07/ 08/2016 | 10.0 | 2.0 | 1.0 | Mumbai | Maharashtra | India | Select Speciali- zation | MAT | Other | Unemployed | Accounting/ Finance | Select | Better Career Prospects | Select | No | No | No | No | No | No | No | B Com + 5 | No | Will revert after reading the email | Might be | No | No | Select | Mumbai | India | Consumer Durables | 02.Medium | 01.High | 15.0 | 18.0 | No | Select | Select | Select | Select | Select | Select | Select | Select | Select | Select | Select | 2 | 01-08-2016 11:15 | 01-08-2016 4:58 |
Table truncated: Columns 1 to 100 of 128 shown.
>library(flipFormat)
>library(flipTransformations)
>if (length(unique(sapply(formVariables, length))) != 1)
stop("All variables must be the same length and are not.")
>rawdata = ProcessQVariables(data.frame(if (length(formVariables) == 1) formVariables[[1]] else formVariables, stringsAsFactors = FALSE))
>rawdata = rawdata[QFilter,, drop = FALSE]
>
>rawdata = rawdata[1:5, ]# amend to 10 rows
>
>names(rawdata) <- if(!formNames) lapply(formVariables, Labels) else lapply(formVariables, Names)
>if (nrow(rawdata) * ncol(rawdata) > 1000000)
stop("Your table contains more than 1,000,000 cells. To get around this limitation, edit the R Code, or, create tables using RAW DATA.")
>raw.data.2 <- rawdata
Lead Stage Lead Score Lead Origin1 Lead Source1
1 Not Interested 105 API Olark Chat
2 Unreachable 120 API Organic Search
3 Qualified 150 Landing Page Submission Direct Traffic
4 Unreachable 60 Landing Page Submission Direct Traffic
5 Qualified 80 Landing Page Submission Google
Do Not Email1 Do Not Call1 Profile Score1
1 No No BLANK
2 No No BLANK
3 No No BLANK
4 No No BLANK
5 No No BLANK
a free copy of Mastering The Interview1 you to consider SomeSchool1
1 No Select
2 No Select
3 Yes Select
4 No Select
5 No Select
Last Notable Activity1 Last Notable Activity Date1 Last Visit Date1
1 Modified 01/08/2016-07/08/2016 25/07/2016-31/07/2016
2 Email Opened 08/08/2016-14/08/2016 08/08/2016-14/08/2016
3 Email Opened 01/08/2016-07/08/2016 01/08/2016-07/08/2016
4 Modified 01/08/2016-07/08/2016 01/08/2016-07/08/2016
5 Modified 01/08/2016-07/08/2016 01/08/2016-07/08/2016
Engagement Score TotalVisits Page Views Per Visit Cityold State Country
1 0 0 0.0
2 0 5 2.5 Mumbai India
3 80 2 2.0 Mumbai Maharashtra India
4 0 1 1.0 Mumbai Maharashtra India
5 10 2 1.0 Mumbai Maharashtra India
Zip Facebook URL Twitter URL LinkedIn URL Industry Work Area
1 NA <NA> <NA> <NA> <NA> <NA>
2 NA <NA> <NA> <NA> <NA> <NA>
3 NA <NA> <NA> <NA> <NA> <NA>
4 NA <NA> <NA> <NA> <NA> <NA>
5 NA <NA> <NA> <NA> <NA> <NA>
Course Interested Keyword Date Specialization Entrance Test
1 <NA> <NA> Select Specialization MAT
2 <NA> <NA> Select Specialization MAT
3 <NA> <NA> Business Administration MAT
4 <NA> <NA> Media and Advertising MAT
5 <NA> <NA> Select Specialization MAT
How did you hear about SomeSchool What is your current occupation
1 Select Unemployed
2 Select Unemployed
3 Select Student
4 Word Of Mouth Unemployed
5 Other Unemployed
If you are a working professional
1 Accounting/Finance
2 Accounting/Finance
3 Accounting/Finance
4 Accounting/Finance
5 Accounting/Finance
If you are a working professional please mention
1 Select
2 Select
3 Select
4 Select
5 Select
What matters most to you in choosing an ADP Age Next Follow Up Search
1 Better Career Prospects Select No
2 Better Career Prospects Select No
3 Better Career Prospects Select No
4 Better Career Prospects Select No
5 Better Career Prospects Select No
Magazine Newspaper Article Welearn Forums Newspaper Digital Advertisement
1 No No No No No
2 No No No No No
3 No No No No No
4 No No No No No
5 No No No No No
Through Recommendations Any other Please specify Last Degree
1 No
2 No
3 No
4 No
5 No B Com + 5
Receive More Updates About Our Courses Admission Number
1 No
2 No
3 No
4 No
5 No
Tags Lead Quality
1 Interested in other courses Low in Relevance
2 Ringing <NA>
3 Will revert after reading the email Might be
4 Ringing Not Sure
5 Will revert after reading the email Might be
Update me on Supply Chain Content Get updates on PGDMHBSCM Chat Group
1 No No <NA>
2 No No Leads Support
3 No No <NA>
4 No No <NA>
5 No No <NA>
Lead Profile City New Country New Industry New
1 Select Select India Consumer Durables
2 Select Select India Consumer Durables
3 Potential Lead Mumbai India Consumer Durables
4 Select Mumbai India Consumer Durables
5 Select Mumbai India Consumer Durables
Asymmetrique Activity Index Asymmetrique Profile Index ecode amt eventname
1 02.Medium 02.Medium <NA> NA <NA>
2 02.Medium 02.Medium <NA> NA <NA>
3 02.Medium 01.High <NA> NA <NA>
4 02.Medium 01.High <NA> NA <NA>
5 02.Medium 01.High <NA> NA <NA>
Enquiry Type Asymmetrique Activity Score Asymmetrique Profile Score
1 <NA> 15 15
2 <NA> 15 15
3 <NA> 14 20
4 <NA> 13 17
5 <NA> 15 18
Admission Date I agree to pay the amount through cheque Previous Stage
1 <NA> No Select
2 <NA> No Select
3 <NA> No Select
4 <NA> No Select
5 <NA> No Select
Number of Followup Calls Asym how soon you can join program
1 Select Select
2 Select Select
3 Select Immediate
4 Select Select
5 Select Select
Asymm Reason to take admission
1 Select
2 Select
3 Required for continuing current job
4 Select
5 Select
Asymm Are you aware about SomeSchool College
1 Select
2 Select
3 Well Aware
4 Select
5 Select
Asymm Are you applying for any other form of MBA
1 Select
2 Select
3 Distance MBA
4 Select
5 Select
Asym What is your expectation from this course
1 Select
2 Select
3 Select
4 Select
5 Select
Asym How do you feel about taking admission
1 Select
2 Select
3 Useful
4 Select
5 Select
Asym What stopping you from joining course
1 Select
2 Select
3 Select
4 Select
5 Select
Asym What are your concerns for taking admission
1 Select
2 Select
3 Stopped studying formal courses long back
4 Select
5 Select
Asym preferences for selecting management course
1 Select
2 Select
3 Medium Match
4 Select
5 Select
What attracted you to consider SomeSchool Landing Page Admission Constraints
1 <NA> <NA>
2 <NA> <NA>
3 <NA> Took just information
4 <NA> <NA>
5 <NA> <NA>
Lead Type Asymmetrique Scoring Model Last Notable Activity Date
1 <NA> 2 03-08-2016 12:00
2 <NA> 2 08-08-2016 13:11
3 <NA> 2 06-08-2016 12:59
4 <NA> 2 03-08-2016 11:35
5 <NA> 2 01-08-2016 11:15
Source Referrer Last Visit Date Photo Url Stage Rotting Flag Status
1 31-07-2016 17:16 <NA> <NA>
2 08-08-2016 13:11 <NA> <NA>
3 06-08-2016 12:59 <NA> <NA>
4 03-08-2016 11:34 <NA> <NA>
5 01-08-2016 4:58 <NA> <NA>
Stage Rotting Flag: Message Stage Rotting Flag: Modification Date
1 <NA> <NA>
2 <NA> <NA>
3 <NA> <NA>
4 <NA> <NA>
5 <NA> <NA>
Stage Rotting Flag Additional Info Stage Rotting Flag Level
1 <NA> <NA>
2 <NA> <NA>
3 <NA> <NA>
4 <NA> <NA>
5 <NA> <NA>
Mailing Preferences Twitter Id Facebook Id LinkedIn Id Skype Id Gtalk Id
1 <NA> <NA> <NA> <NA> <NA> <NA>
2 <NA> <NA> <NA> <NA> <NA> <NA>
3 <NA> <NA> <NA> <NA> <NA> <NA>
4 <NA> <NA> <NA> <NA> <NA> <NA>
5 <NA> <NA> <NA> <NA> <NA> <NA>
Google Plus Id Quality Score 01 Groups Average Time Per Visit
1 <NA> <NA> <NA> 0.00
2 <NA> <NA> <NA> 83.75
3 <NA> <NA> <NA> 4.00
4 <NA> <NA> <NA> 0.00
5 <NA> <NA> <NA> 0.00
Created On1 Modified On1
1 25/07/2016-31/07/2016 01/08/2016-07/08/2016
2 25/07/2016-31/07/2016 01/08/2016-07/08/2016
3 25/07/2016-31/07/2016 01/08/2016-07/08/2016
4 25/07/2016-31/07/2016 01/08/2016-07/08/2016
5 25/07/2016-31/07/2016 01/08/2016-07/08/2016
Prospect ID Last Activity1
1 7927b2df-8bba-4d29-b9a2-b6e0beafe620 Page Visited on Website
2 2a272436-5132-4136-86fa-dcc88c88f482 Email Opened
3 8cc8c611-a219-4f35-ad23-fdfd2656bd8a Email Opened
4 0cc2df48-7cf4-4e39-9de9-19797f9b38cc Unreachable
5 3256f628-e534-4826-9d63-4a8b88782852 Converted to Lead
Last Activity Date1 Last Activity Date Created On Modified On
1 25/07/2016-31/07/2016 31-07-2016 17:16 31-07-2016 17:11 03-08-2016 12:00
2 08/08/2016-14/08/2016 08-08-2016 13:11 31-07-2016 17:00 01-08-2016 12:45
3 01/08/2016-07/08/2016 06-08-2016 12:59 31-07-2016 16:57 01-08-2016 11:45
4 01/08/2016-07/08/2016 03-08-2016 11:34 31-07-2016 16:38 03-08-2016 11:35
5 01/08/2016-07/08/2016 01-08-2016 4:58 31-07-2016 15:54 01-08-2016 11:15
Lead Number Company Mobile Number Website Time Zone Job Title Lead Source
1 660737 <NA> <NA> Olark Chat
2 660728 <NA> <NA> Organic Search
3 660727 <NA> <NA> Direct Traffic
4 660719 <NA> <NA> Direct Traffic
5 660681 <NA> <NA> Google
Source Medium
1
2
3
4
5 CPC
Notes
1
2
3
4 I want to know about the full time mba program @ SomeSchool.admission process#fees#placements#
5 I want to know the all courses and fees
Source Campaign Source Content Lead Grade Order Value
1 <NA> <NA> <NA>
2 <NA> <NA> <NA>
3 <NA> <NA> <NA>
4 <NA> B <NA>
5 Google-CPC-Sitelink Sitelink B <NA>
Related Landing Page Id First Landing Page Submission Id
1 <NA>
2 <NA>
3 52c73a3d-727c-11e5-a199-22000aa4133b f04c0b9c-0cb0-43dc-bde0-c14980e04af6
4 c3af079d-70c7-11e5-a199-22000aa4133b ecd36859-3612-4e29-bb29-7486d2122ff0
5 8f63510d-6cd9-11e5-a199-22000aa4133b a10c0a82-8ab4-422b-b358-5b15e160bbfc
First Landing Page Submission Date Lead Conversion Date Address: 1 Address: 2
1 <NA> <NA>
2 31-07-2016 17:02 <NA> <NA>
3 31-07-2016 16:57 31-07-2016 16:57 <NA> <NA>
4 31-07-2016 16:38 31-07-2016 16:38 <NA> <NA>
5 01-08-2016 4:58 01-08-2016 4:58 <NA> <NA>
| Started: | Wed Dec 05 2018 23:39:34 GMT+0000 (Coordinated Universal Time) |
|---|---|
| Finished: | Wed Dec 05 2018 23:39:42 GMT+0000 (Coordinated Universal Time) |
| Total time: | 8.02s |
| Time executing code: | 0.64s |
| Other overhead on R server: | 7.34s |
| Time spent transferring data: | 0.03s |
| Data sent to R server: | 6.5MB |
| Data received from R server: | 99KB |
