Introduction

This is a case study from a Clicked Data Loading in Salesforce skills challenge.

You are a Salesforce Business Analyst and you have been hired for a consulting project to support the upcoming TrailblazerDX conference hosted by Salesforce. The conference team needs to sell sponsorship booths for the conference, but their internal process to secure sponsors is outdated and broken, and needs to be improved.

To begin working with this process for this year’s conference, the team at TrailblazerDX has asked you to upload a data set of companies who were previously contacted about sponsorships for the conference, some of which were sponsors for past events and some of which were not.

Look through the data, and note any missing or incorrect data that is included. Only upload data that has a designated “company” into Salesforce as a Contact.

Create a brief note or 1-2 slide presentation describing the work you were able to do and highlighting any remaining questions you have:

How much of the data was ready for upload?

How much of the data is missing or incorrect?

Do you have any questions that you would need answered to complete your work?

Setup / Data Import

I used tidyverse and scales libraries for data cleaning and calculations. I imported the included CSV file and examined its structure.

library(tidyverse)
library(scales)
tdx_sponsors <- read_csv("Trailblazer DX Sponsorship Contacts - MOCK_DATA.csv")
str(tdx_sponsors)
## spc_tbl_ [829 × 6] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
##  $ id                     : num [1:829] 1 2 3 4 5 6 7 8 9 10 ...
##  $ company                : chr [1:829] "Riffpedia" "Rhycero" NA NA ...
##  $ first_name             : chr [1:829] "Roberta" "Odette" "Elliott" "Maryanne" ...
##  $ last_name              : chr [1:829] "Leyburn" "Grzelczyk" "Gurden" "Molan" ...
##  $ email                  : chr [1:829] "rleyburn0@imgur.com" "ogrzelczyk1@quantcast.com" "egurden2@typepad.com" "mmolan3@newyorker.com" ...
##  $ previous_sponsor_status: logi [1:829] TRUE TRUE TRUE TRUE FALSE TRUE ...
##  - attr(*, "spec")=
##   .. cols(
##   ..   id = col_double(),
##   ..   company = col_character(),
##   ..   first_name = col_character(),
##   ..   last_name = col_character(),
##   ..   email = col_character(),
##   ..   previous_sponsor_status = col_logical()
##   .. )
##  - attr(*, "problems")=<externalptr>
## [1] "All rows: 829"
## [1] "Rows w/out 'Company' data: 151"
## [1] "Rows w/ 'Company' data: 678"
## [1] "Percentage of rows w/ 'Company' data: 81.79%"

The challenge asked to only upload contacts with ‘Company’ data included. This shows us that we’re able to upload 678 entries, or around 82% of the inlcuded data, into a salesforce org.

We will use salesforce to perform further actions, such as sorting between previous sponsors and resolving the N/A values in those fields.

To deal with N/A rows, I would create a report that lists companies with TRUE rows as a list of verified previous sponsors. I would want to create a task to follow up with N/A rows, and effectively read them as FALSE, unless another contact at that same company has a TRUE value.

Creating a cleaner .csv for import.

First, drop the rows with N/A values in the ‘Company’ column. Then, write a new csv file with those values dropped.

tdx_sponsors_wcompany <- tdx_sponsors %>% 
  drop_na(company)

write.csv(tdx_sponsors_wcompany, file="TDX_sponsors_clean.csv")

Questions

Some questions I’d want to ask…

Importing & Preview

Here are the mappings I chose in the org

Salesforce org mappings

I created a table to show the preview of the data that will be imported into the org.

tdx_sponsors_wcompany <- tdx_sponsors_wcompany %>% 
  arrange(company)
knitr::kable(tdx_sponsors_wcompany, col.names=c("ID", "Company", "First Name", "Last Name", "Email", "Previous Sponsor?"))
ID Company First Name Last Name Email Previous Sponsor?
202 Abata Karna Danforth FALSE
96 Abatz Herold Sedger FALSE
239 Abatz Maurie Brymham TRUE
778 Abatz Odele Kohnert TRUE
247 Agimba Had Galletley NA
125 Aibox Pablo Lyste TRUE
211 Aibox Samson Lacoste FALSE
30 Ailane Janean Hanson TRUE
407 Ailane Sadie Hawke TRUE
755 Ailane Maiga Kimm TRUE
516 Aimbo Stanton Dreamer FALSE
580 Aimbo Berkley Hovington TRUE
799 Aimbo Tomasina Jakoubec TRUE
172 Aivee Steven Theaker NA
289 Aivee Sybila Menichini NA
52 Avamba Karita Pote TRUE
705 Avamba Carlin Laxston NA
751 Avamba Nikolaos Cassam FALSE
137 Avamm Gwynne Kerne NA
206 Avavee Roscoe Beauchamp FALSE
241 Avavee Alia Murrthum FALSE
326 Avavee Wanda Astlett FALSE
31 Avaveo Wyatan Casol FALSE
59 Avaveo Madelina Wicher NA
106 Avaveo Nester Fleg TRUE
303 Babbleblab Tabbatha Gorch TRUE
165 Babbleopia Reube Gutans FALSE
270 Babbleopia Lorin Frye TRUE
690 Babbleopia Burgess Vlasenko TRUE
73 Babbleset Wilden Belly TRUE
162 Babbleset Rosaleen Noonan TRUE
641 Babblestorm Hersch August FALSE
108 BlogXS Evonne Iacobacci FALSE
178 BlogXS Bartholomeo Cratere TRUE
257 BlogXS Sashenka Gadson FALSE
216 Blognation Giuseppe Cattonnet TRUE
634 Blognation Dana Keppel FALSE
805 Blognation Ada Buckley TRUE
530 Blogpad Britte Dundredge TRUE
351 Blogspan Sukey Matonin FALSE
323 Blogtag Ricky Folkes FALSE
704 Blogtag Maureene Bayne TRUE
795 Blogtags Evvy Knight FALSE
67 Brainbox Allayne Manketell FALSE
276 Brainlounge Ellwood Hillaby FALSE
673 Brainlounge Jessie Jacobson FALSE
168 Brainsphere Shanna Jime TRUE
99 Brightbean Catina Van Niekerk FALSE
470 Brightbean Connie Densun TRUE
790 Brightbean Fanya Bankes FALSE
279 Brightdog Tris Munson TRUE
406 Brightdog Dougie Deeson FALSE
458 Brightdog Willie Pashby NA
689 Brightdog Ximenes Dunbobbin FALSE
196 Browsebug Krisha Valdes TRUE
347 Browsebug Edouard Gayler FALSE
672 Browsebug Benji Teasey FALSE
80 Browsecat Sharity Heiss TRUE
135 Browsecat Morganica Costley FALSE
321 Browsecat Elnora Bealton FALSE
539 Browsecat Marylinda Bernardot TRUE
218 Browsedrive Egbert Kocher FALSE
364 Browsedrive Lucina McGloughlin FALSE
812 Browsedrive Karim Maasz FALSE
660 Browsetype Mycah Lathaye FALSE
676 Browsetype Shell Lawful NA
21 Browsezoom Nicol Sinkin TRUE
382 Browsezoom Carolin Toyne NA
515 Browsezoom Freddy Ventham TRUE
18 Bubblebox Eran Syder FALSE
422 Bubblebox Brinna Sabati NA
597 Bubblebox Simmonds Syddon FALSE
706 Bubblebox Winston Grugerr FALSE
650 Bubbletube Georgianna Wall TRUE
160 Buzzbean Nelson Sinnett TRUE
215 Buzzdog Mavis Legge FALSE
587 Buzzdog Dreddy Costin FALSE
230 Buzzshare Regina Beer TRUE
741 Buzzshare Henry Szepe FALSE
117 Buzzster Cassy Simonato FALSE
425 Buzzster Kiersten Juliano TRUE
25 Camido Orly Mulryan NA
536 Camido Mike Full FALSE
637 Camido Timmie Izod FALSE
77 Centidel Tobe Cadge TRUE
388 Centidel Chickie Mauchline FALSE
720 Centidel Charmaine Prozillo TRUE
298 Centimia Tedie Claricoats FALSE
127 Centizu Oliver Blunt FALSE
188 Centizu Betsy Wendover FALSE
565 Centizu Cole Phair TRUE
186 Chatterbridge Jacques Seal TRUE
329 Chatterbridge Guthry Rattenberie NA
342 Chatterbridge Demott Seignior TRUE
426 Chatterpoint Cristen Coffin FALSE
534 Chatterpoint Kristian Larraway FALSE
193 Cogibox Ellerey Toffoletto FALSE
362 Cogibox Clark Galpen FALSE
169 Cogidoo Martainn Archdeckne TRUE
726 Cogidoo Joella Heinert FALSE
777 Cogidoo Bald Lathbury FALSE
51 Cogilith Korella Python NA
148 Cogilith Malva Duckers FALSE
473 Cogilith Kirk Gecks FALSE
569 Cogilith Dena Saltsberger FALSE
639 Cogilith Jermaine Gritskov FALSE
439 Dabfeed Sharon Woolland TRUE
576 Dabfeed Aime Van Merwe FALSE
697 Dabfeed Marie Hassey TRUE
640 Dabjam Heidi Strangeways TRUE
763 Dabjam Hailee Hemphrey TRUE
723 Dabshots Corly Bleasdille TRUE
757 Dabshots Karin Lemme TRUE
771 Dabshots Bernadina Jorin NA
132 Dabtype Whitby Spinas FALSE
297 Dabtype Florencia Gormally NA
768 Dabtype Armand Senn TRUE
543 Dabvine Jojo Dawber FALSE
142 Dazzlesphere Tricia Pitcaithley FALSE
383 Dazzlesphere Noami Bultitude FALSE
552 Dazzlesphere Freddy Fasham TRUE
793 Dazzlesphere Susann Tongs FALSE
546 Demivee Gordon Masseo TRUE
701 Demivee Anstice Cregin FALSE
448 Demizz Dedra Kellington TRUE
126 Devcast Ray Mitrovic FALSE
719 Devify Jack Geaney TRUE
736 Devify Josephina Trebbett FALSE
368 Devpoint Yale Belson TRUE
461 Devpoint Jeffrey Allchorne FALSE
638 Devpoint Mattias Littlechild TRUE
797 Devpoint Ettore Jerzak FALSE
12 Devpulse Mayor Paolinelli TRUE
159 Devpulse Lynde Jukes FALSE
409 Devpulse Val Cottee FALSE
696 Devpulse Calli Moyle FALSE
150 Devshare Suzette McDaid FALSE
311 Devshare Owen Halsted FALSE
28 Digitube Salvatore Allender FALSE
614 Digitube Celestyna Ellingford TRUE
6 Divanoodle Alard Halls TRUE
116 Divanoodle Alvis Borrows TRUE
254 Divape Vanda McQuillin TRUE
44 Divavu Kerby Bond FALSE
212 Divavu Elizabeth Disney TRUE
761 Divavu Sergent Maffeo FALSE
412 Dynabox Wilek Kitcherside NA
563 Dynabox Ainsley Renton TRUE
586 Dynabox Thane Dominique NA
769 Dynabox Douglass Cammell FALSE
783 Dynabox Lisa Lening FALSE
376 Dynava Laverne Denson FALSE
479 Dynava Christian Dzenisenka TRUE
610 Dynava Pattie Drissell FALSE
679 Dynava Tome Hellard TRUE
682 Dynava Gilberta Pullar FALSE
24 Dynazzy Nicky Durrans FALSE
26 Dynazzy Aloin Prinett FALSE
316 Eabox Harri Sant TRUE
91 Eamia Clarisse Ioan NA
432 Eamia Noak Stickins TRUE
98 Eare Ginny Sweetland TRUE
745 Eare Merry Minchella TRUE
811 Eare Myer Hallas TRUE
278 Eayo Rogerio Esley TRUE
293 Eayo Corabelle Jandel FALSE
456 Eayo Aryn Gorring FALSE
498 Eayo Germayne Cheng NA
758 Eayo Doralyn Heighton FALSE
474 Eazzy Link Colleford FALSE
646 Eazzy Lani Winterbourne FALSE
500 Edgeblab Lou Tuley FALSE
724 Edgeblab Hunter Rosengarten TRUE
22 Edgeclub Drusie Durie TRUE
526 Edgeclub Marinna Seyfart NA
294 Edgepulse Thelma Wyley TRUE
537 Edgepulse Pierrette Bremner TRUE
630 Edgepulse Kacy Lillie FALSE
201 Edgetag Evelyn Everington TRUE
629 Edgetag Sigfrid McEachern FALSE
468 Edgewire Charlean Ducroe FALSE
393 Eidel Adina Surphliss FALSE
605 Eidel Yevette Ladewig FALSE
767 Eidel Kate Dann TRUE
158 Eimbee Joannes Perico FALSE
332 Eimbee Wolfie Silcox TRUE
101 Eire Chantal Rutty TRUE
415 Eire Yorker Franzman FALSE
37 Fadeo Karoly Gouch NA
392 Fadeo Jobina Cabell TRUE
260 Fanoodle Salomon Wickardt FALSE
359 Fanoodle Freddi Nieass TRUE
716 Fanoodle Barbara-anne Doncom TRUE
796 Fanoodle Rhona Osbidston FALSE
819 Fanoodle Mora Letchford FALSE
747 Fatz Rorie Halleday FALSE
10 Feedbug Randi Colcutt FALSE
11 Feedbug Antonie Beal TRUE
829 Feedbug Allix Moodycliffe FALSE
380 Feedfire Rodina Gilhoolie TRUE
602 Feedfire Chris Berecloth TRUE
313 Feedfish Erich Kollach TRUE
607 Feedfish Danyette Rustedge FALSE
762 Feedfish Maurizia Robinet FALSE
62 Feedmix Emera Shemilt FALSE
167 Feedmix Cammi Priestman FALSE
620 Feedmix Westbrook Dymock FALSE
728 Feedmix Tito Cockcroft TRUE
752 Feedmix Hermine Pennuzzi FALSE
532 Feednation Osborne Reedie FALSE
113 Feedspan Cymbre Rennolds FALSE
556 Feedspan Kean Schroeder NA
825 Feedspan Melvyn Pitkaithly FALSE
57 Fivebridge Raimondo Bartoshevich TRUE
808 Fivebridge Jo Yeld FALSE
78 Fivechat Raven Armiger FALSE
717 Fivechat Juanita McRill TRUE
124 Fiveclub Andonis Lipsett FALSE
267 Fiveclub Teriann Bonnick TRUE
802 Fiveclub Torr Gostridge FALSE
403 Fivespan Ernst Arpino NA
775 Fivespan Mayer Jillings FALSE
82 Flashdog Gabbie Le Grice FALSE
337 Flashdog Alexi Brandenberg FALSE
334 Flashpoint Diannne Scawen FALSE
420 Flashpoint Gideon Milland NA
731 Flashpoint Annabal Ponnsett TRUE
483 Flashset Benny Harte TRUE
535 Flashset Trisha Dudderidge TRUE
86 Flashspan Sephira Pedycan FALSE
651 Flashspan Corabel Kemell FALSE
45 Flipstorm Noby Jandak FALSE
508 Flipstorm Addy Kikke NA
55 Fliptune Sargent Croci TRUE
510 Fliptune Geri Boule FALSE
514 Fliptune Courtenay Priden FALSE
677 Fliptune Tamiko Rowlatt FALSE
694 Fliptune Bradney Hurcombe TRUE
72 Gabcube Terry MacCartair FALSE
748 Gabspot Lula Shoulders FALSE
238 Gabtune Heddi Rostern FALSE
315 Gabvine Maurizio Veazey FALSE
549 Geba Brandy Ponde NA
810 Geba Alexine Pringour FALSE
623 Gevee Silvano Cowely TRUE
457 Gigaclub Gaylor MacKartan TRUE
66 Gigashots Minna Dondon FALSE
469 Gigashots Frederique Mechan FALSE
477 Gigashots Maryann Trowell FALSE
756 Gigashots Cortney Gillanders NA
47 Gigazoom Raye Gayne TRUE
143 Gigazoom Bill Bertin FALSE
130 Innojam Karlik Lainton TRUE
328 Innojam Gisela Cloake TRUE
338 Innojam Graehme Beadnall TRUE
449 Innojam Mac Greetham NA
753 Innojam Marjy Itzkov TRUE
61 Innotype Herminia Shrieves FALSE
450 Innotype Cami Astridge FALSE
564 Izio Vance Sterland TRUE
618 Izio Roana Bennison FALSE
220 Jabberbean Ediva Malpas TRUE
670 Jabberbean Grete Ferrierio FALSE
806 Jabberbean Hedvig Cahey FALSE
226 Jabbercube Cosme Hardiman FALSE
49 Jabbersphere Berthe Shermore TRUE
94 Jabbersphere Sallee Girodon FALSE
110 Jabbersphere Jehu Flieger FALSE
139 Jabbersphere Marna Devennie TRUE
153 Jabbersphere Sheela Cord FALSE
305 Jabbersphere Matilda Premble TRUE
386 Jabbersphere Ade Neeve NA
665 Jabbersphere Reeba MacSween FALSE
770 Jabbersphere Herschel Effemy TRUE
233 Jabbertype Noll Hairsine FALSE
442 Jabbertype Carrie Kilner NA
666 Jabbertype Abagail Shales FALSE
83 Jaloo Rayner Harral FALSE
524 Jaloo Edan Raddin FALSE
555 Jaloo Hulda Kissock TRUE
794 Jaloo Zulema Shawdforth FALSE
185 Jamia Reginald Doring NA
377 Janyx Alexine Phillott TRUE
578 Janyx Odell Rushbrooke TRUE
754 Janyx Winthrop Lavalle NA
192 Jatri Fonsie Seamans TRUE
582 Jatri Phip Rodolfi NA
627 Jatri Fifine Shambroke TRUE
718 Jatri Abrahan Surby FALSE
121 Jaxbean Chip Hawsby FALSE
129 Jaxbean Esmaria Cluatt FALSE
813 Jaxbean Marven Branscomb TRUE
460 Jaxnation Saunders Jeannet TRUE
251 Jaxspan Sydney Gallemore TRUE
643 Jaxspan Corrianne Farlham NA
358 Jaxworks Kathrine Mines FALSE
366 Jaxworks Tobin Rabley FALSE
69 Jayo Osgood Truman TRUE
175 Jayo Xenia Breadon TRUE
180 Jayo Ianthe Rodson FALSE
367 Jayo Corey Bottrill TRUE
789 Jayo Wandie Prevett NA
497 Jazzy Karee Zucker TRUE
528 Jazzy Elfrieda Wyldish TRUE
5 Jetpulse Ole Bratley FALSE
600 Jetpulse Benedetto Helliar FALSE
714 Jetpulse Suzann Petrussi FALSE
488 Jetwire Kimbell Rentilll FALSE
557 Jetwire Ricky Colqueran FALSE
729 Jetwire Warren Corringham TRUE
312 JumpXS Alphard MacCoughen TRUE
345 JumpXS Rustin McKeon FALSE
503 JumpXS Tabby Slora FALSE
773 JumpXS Flinn Errigo FALSE
156 Kamba Hayes Bengtsen NA
163 Kanoodle Loella Bolens FALSE
203 Kanoodle Candice Roskilly FALSE
436 Kanoodle Shawna Dibbe TRUE
625 Kanoodle Augusta Fansy TRUE
411 Kare Diannne Pavis TRUE
482 Kare Justus Wheaton FALSE
800 Kare Efren Emmatt FALSE
19 Katz Deerdre Vouls TRUE
100 Katz Lonnie Papis FALSE
490 Katz Leesa Ginman TRUE
596 Katz Hardy Bortoletti TRUE
683 Katz Craggie Choat NA
265 Kaymbo Vladamir Truelock FALSE
520 Kayveo Ganny Fragino FALSE
570 Kazio Estelle Le Batteur TRUE
43 Kazu Cecilius Clucas TRUE
419 Kazu Yurik Fleg NA
478 Kazu Maynard Knight TRUE
612 Kwilith Lisle Huton FALSE
189 Kwimbee Berny Kohnert TRUE
288 Kwimbee Eldin O’Bradden FALSE
484 Kwimbee Mechelle Bankes TRUE
208 Kwinu Llewellyn Olyet NA
540 Lajo Amii Rubinsztein TRUE
58 Latz Cullan Penketh TRUE
322 Latz Jennette Skough FALSE
622 Layo Paige Foulkes TRUE
735 Layo Lennie Chasteau FALSE
53 Lazz Ax Leifer TRUE
588 Lazz Darleen Greenmon TRUE
828 Lazz Nannette Newitt FALSE
17 Lazzy Lyndsie Colenutt TRUE
222 Lazzy Josephina Turville TRUE
786 Lazzy Candace Porker FALSE
15 Leenti Samaria Whyke FALSE
229 Leexo Tilly Burland TRUE
70 Linkbuzz Westbrooke Pharoah TRUE
732 Linkbuzz Pietra Warlaw TRUE
271 Linklinks Caressa Jankiewicz TRUE
435 Linklinks Gianni Gilfether TRUE
481 Linktype Vanda Stolle FALSE
538 Linktype Dur Brunke FALSE
354 Livefish Adora McNeice FALSE
16 Livepath Kendrick Smyth FALSE
48 Livepath Penn Bloxland FALSE
128 Livepath Hersch Hornbuckle NA
223 Livepath Charo Novotne FALSE
823 Livepath Artemus Leydon NA
404 Livetube Lise Espine TRUE
652 Livetube Idalia Reeder TRUE
742 Livetube Abey Burgon TRUE
441 Meedoo Chic Kordovani TRUE
700 Meedoo Charita Autrie FALSE
20 Meembee Keelby Rushsorth FALSE
511 Meembee Phaidra Crunkhorn FALSE
428 Meetz Winifield Ghidelli NA
654 Meetz Nady Scruton TRUE
339 Meevee Juditha Carmen TRUE
727 Meezzy Bebe Giabucci TRUE
219 Miboo Odella Dignum TRUE
645 Miboo Kay Carletti NA
657 Miboo Ana Deschelle TRUE
759 Miboo Derrik Dalglish FALSE
603 Minyx Dario Kingsnode FALSE
38 Mudo Randall Simmers FALSE
282 Mudo Cathrin Tschierse NA
344 Muxo Carmelina Buffham TRUE
583 Muxo Terencio Bowry TRUE
495 Mycat Kacy Ledger TRUE
680 Mycat Cyndi Danilyuk TRUE
821 Mycat Tobit Siebert FALSE
92 Mydeo Randolph I’anson FALSE
779 Mydeo Uri Massey TRUE
801 Mydo Arlen George TRUE
562 Mymm Redford Ashburner TRUE
573 Mymm Ray Alten FALSE
589 Mymm Lenora Elkins NA
204 Mynte Carmine Toulmin FALSE
207 Mynte Jonathan Crookshank FALSE
746 Mynte Elie Fahy FALSE
324 Myworks Robina Ferne TRUE
423 Myworks Hanan Bleacher TRUE
760 Nlounge Lee Husk FALSE
170 Npath Odie Farrant TRUE
14 Ntags Odilia Bonnier FALSE
302 Oba Joella Pietrusiak TRUE
27 Oloo Shina Bosden FALSE
243 Oloo Minette Kerswell TRUE
250 Oloo Arlyne Gwilt FALSE
336 Omba Jermaine Torricina TRUE
486 Omba Eloisa Claris TRUE
784 Omba Karim Goslin FALSE
118 Oodoo Mendel Biagi FALSE
502 Oodoo Thornie Baselli TRUE
455 Oozz Florentia Heel FALSE
274 Oyoba Toddie Hullah TRUE
145 Oyoloo Reeba Matthewson TRUE
199 Oyoloo Lanae Lauder TRUE
234 Oyoloo Zachary Martinyuk FALSE
400 Oyoloo Gun Gerty TRUE
544 Oyoloo Lorenzo Bentke TRUE
642 Oyoloo Drucy Wignall TRUE
798 Oyoloo Rollo Aulds TRUE
65 Oyonder Dottie O’Dowling TRUE
190 Oyonder Phil Sivess TRUE
197 Oyonder Stevena Mocher TRUE
447 Oyonder Harwell Ellsbury TRUE
444 Oyondu Fawne Mufford TRUE
507 Oyondu Gradey Pailin FALSE
591 Oyondu Gage Ffrench FALSE
817 Oyondu Joyann Gilbee NA
103 Oyope Rycca Cockroft TRUE
585 Oyope Amery Roderick FALSE
7 Oyoyo Louisette Cattlow FALSE
244 Oyoyo Leoline Sproul NA
504 Oyoyo Hans Belford FALSE
827 Oyoyo Yance Ornelas NA
350 Ozu Kerwinn Byard TRUE
272 Photobean Lawton Scare FALSE
136 Photobug Jeanne Hanscomb NA
246 Photobug Hermie Berndtsson NA
424 Photobug Marj Bowld TRUE
471 Photobug Grove Struan TRUE
780 Photobug Rosalia Symcoxe FALSE
120 Photofeed Andrei Caslane TRUE
181 Photofeed Tristan Murrells FALSE
430 Photofeed Sidnee Leppington TRUE
141 Photolist Selinda Pithie TRUE
822 Photolist Lianna Selliman NA
242 Photospace Kristoffer Fearnyough NA
465 Photospace Phaedra Napolione FALSE
144 Pixoboo Leyla Passe TRUE
285 Pixoboo Gerhardt Gagan FALSE
485 Pixoboo Lark Gasperi FALSE
567 Pixoboo Farand Kiezler TRUE
309 Pixonyx Dehlia Lambard TRUE
601 Pixonyx Neely Hance TRUE
333 Pixope Raleigh Chasemoore TRUE
525 Pixope Carmencita Feirn NA
105 Plambee Imojean Leghorn TRUE
429 Plambee Alisander Mott FALSE
598 Plambee Finlay Devaney TRUE
104 Podcat Caty McMurthy TRUE
280 Podcat Roda Augustine FALSE
531 Podcat Ced Cossem FALSE
306 Quamba Lukas Vallentine TRUE
595 Quamba Tracey Brevetor TRUE
56 Quatz Gradeigh Veldman TRUE
281 Quatz Ebonee Stonhewer NA
340 Quatz Melli Tollet TRUE
492 Quatz Bart Holson FALSE
575 Quatz Loralie Wolfit FALSE
68 Quaxo Pietra Viscovi FALSE
217 Quaxo Wiley Todaro TRUE
231 Quaxo Devi O’Bradane TRUE
93 Quimba Donavon Giamitti TRUE
521 Quimba Patsy Wipfler FALSE
579 Quimba Munroe Allsopp TRUE
36 Quimm Andy Dalgardno TRUE
433 Quimm Olin Russ TRUE
572 Quimm Gustav Ginty TRUE
792 Quimm Lilah Vigars FALSE
147 Quinu Dagny Fensome TRUE
394 Quinu Humberto Lehrian TRUE
109 Realblab Maynord Thompson FALSE
413 Realblab Vikky MacCahee FALSE
421 Realblab Wallache Chaloner TRUE
695 Realblab Kimberlee Ilchuk NA
140 Realbridge Rubi Coleson FALSE
558 Realbridge Alanson Nunson FALSE
667 Realcube Kalina Kullmann TRUE
693 Realcube Gardy Cumpsty FALSE
151 Realfire Darnall Corrao TRUE
408 Realfire Greer Dulanty FALSE
71 Realmix Maryanna Hessentaler TRUE
389 Realmix Chan Swallow TRUE
154 Realpoint Lynett Wellwood TRUE
228 Realpoint Adelina Drinan NA
476 Realpoint Zared Rankine TRUE
669 Realpoint Godfree Brannigan FALSE
671 Rhybox Selma Ambage TRUE
2 Rhycero Odette Grzelczyk TRUE
818 Rhycero Hilary Coggan FALSE
35 Rhynoodle Katleen Sahlstrom FALSE
296 Rhynoodle Gussie Gawne NA
782 Rhynoodle Fields Letertre FALSE
356 Rhynyx Poul Hansley FALSE
807 Rhynyx Gabrila Rocco FALSE
8 Rhyzio Amelia Newbury TRUE
299 Rhyzio Claude Enric FALSE
385 Rhyzio Alexi Hatchard NA
788 Riffpath Rolland Balsellie TRUE
1 Riffpedia Roberta Leyburn TRUE
647 Riffpedia Ashlan Granleese TRUE
658 Riffwire Arleen aManger FALSE
32 Roodel Gasper Woolfenden FALSE
256 Roodel Yvonne Titford TRUE
506 Roodel Rubin Zapata FALSE
772 Roodel Clayson Hutable NA
9 Roombo Manda Fibbings TRUE
395 Roombo Crin O’Dougherty TRUE
205 Roomm Lon Liger TRUE
365 Roomm Hebert Dawidowsky TRUE
568 Roomm Quincey Brockherst TRUE
89 Shufflebeat Persis Gottelier FALSE
161 Shuffledrive Birgit Casajuana FALSE
541 Shuffledrive Devan Corner TRUE
749 Shufflester Nicolina Lemonby TRUE
134 Shuffletag Shell Sabbatier FALSE
434 Shuffletag Sydelle Butting FALSE
590 Shuffletag Lucilia Normansell FALSE
300 Skaboo Isis Vaun FALSE
518 Skaboo Hyman Earthfield NA
559 Skajo Ferdinanda Sterrick TRUE
803 Skajo Ed Shevelin FALSE
584 Skalith Vlad Harfleet FALSE
440 Skiba Westbrook Gorke TRUE
88 Skibox Clayborn Wylder TRUE
183 Skibox Legra Frampton FALSE
264 Skibox Emilia Maudson TRUE
346 Skibox Delmore Wasbrough TRUE
561 Skibox Harlan Peevor TRUE
710 Skibox Meris Ghent TRUE
164 Skidoo Erhard Hillock FALSE
619 Skidoo Di Carcass FALSE
824 Skidoo Aksel Madner TRUE
177 Skilith Ardene Booi TRUE
213 Skimia Siegfried Hagyard TRUE
331 Skimia Emmalyn Balentyne FALSE
384 Skimia Torie Petran TRUE
501 Skimia Noah de Almeida FALSE
548 Skimia Sonnie Allsop FALSE
678 Skimia Kriste Bartalini NA
820 Skimia Jayme Jakel NA
200 Skinix Rolland Duding FALSE
730 Skinix Winnifred Cockran FALSE
626 Skinte Tedda Gipps FALSE
391 Skipfire Vanessa Moss FALSE
398 Skipfire Sarine Grunguer NA
608 Skippad Wernher Witty TRUE
373 Skiptube Torrey Heditch TRUE
685 Skyba Filippa Meindl TRUE
744 Skyba Nona Pawelczyk TRUE
372 Skyble Hana Horbath TRUE
431 Skyble Oran Cranke FALSE
633 Skyble Lamont Downer TRUE
684 Skyble Deni Pitbladdo FALSE
290 Skyndu Roseanne Stobbs FALSE
453 Skyndu Stacia D’eye TRUE
466 Skyndu Muire Hutcheons TRUE
152 Skynoodle Cindra Deverall TRUE
357 Snaptags Nap Kinningley NA
593 Snaptags Kipp Werny TRUE
262 Tagcat Mavra Erangy FALSE
42 Tagchat Benedicto Squibe TRUE
668 Tagchat Conrade Kopisch FALSE
23 Tagfeed Madel Polhill FALSE
252 Tagfeed Sherline Lyston NA
599 Tagfeed Nari Crommett TRUE
295 Tagopia Sindee Insko FALSE
179 Tagpad Hestia Lippett NA
258 Tagpad Silas Sabate FALSE
604 Tagpad Shannon Andreolli TRUE
79 Tagtune June Beldham NA
467 Tagtune Bernelle Bilton TRUE
606 Tagtune Vidovic Ockwell FALSE
628 Tagtune Betty Ceely TRUE
33 Talane Westbrooke Passmore TRUE
115 Talane Jacky Jurn TRUE
268 Talane Benjamen Dixon TRUE
737 Talane Mari Lyddiatt TRUE
259 Tanoodle Ewen Azema FALSE
253 Tazz Ryan Giabuzzi FALSE
405 Tazz Twila Vell FALSE
102 Tekfly Brandais Cooley TRUE
187 Tekfly Antons Echalier TRUE
715 Tekfly Nan Laugherane TRUE
60 Teklist Corrie Handling TRUE
662 Thoughtbeat Hilde Honeywood TRUE
691 Thoughtbeat Carlita Leek NA
826 Thoughtbeat Marvin Lethbury FALSE
194 Thoughtbridge Gregorio Woltering TRUE
648 Thoughtbridge Ike Noot NA
64 Thoughtmix Rudiger Organ TRUE
396 Thoughtmix Gavin McKeighen FALSE
327 Thoughtsphere Dionis Bumpus FALSE
308 Thoughtstorm Myriam Dover FALSE
550 Thoughtstorm Borg Bultitude FALSE
76 Thoughtworks Vidovik Hardwick FALSE
655 Topdrive Kathe Caley FALSE
664 Topdrive Rufus Cancellario TRUE
209 Topiclounge Findlay Strangeways FALSE
75 Topicstorm Zebulen Casillis TRUE
397 Topicstorm Cash Jeanin FALSE
416 Topicstorm Clifford Glaisner FALSE
708 Topicstorm Kori Ludlam NA
513 Topicware Perice Gourlay FALSE
63 Topiczoom Eustacia Hendricks TRUE
496 Trilia Jordon Burgwyn FALSE
283 Trilith Ingeberg Faulder NA
417 Trilith Gianna Dibnah TRUE
210 Trudeo Theodore Tiltman FALSE
240 Trudeo Pansie Mattiassi TRUE
286 Trudeo Miguel Hassall FALSE
594 Trudeo Averil Bauckham FALSE
787 Trudeo Cammie Mountney FALSE
122 Trudoo Lew Billam TRUE
815 Trudoo Gail Daud TRUE
157 Trunyx Riva O’Tierney TRUE
341 Trunyx Cull Climar TRUE
631 Trunyx Athena MacAnelley FALSE
245 Trupe Gale Mercey TRUE
624 Trupe Killian Yeomans NA
688 Trupe Pen Rogier NA
255 Twimbo Boot Malacrida FALSE
318 Twimbo Malia Twidell TRUE
707 Twimbo Prince Bernuzzi TRUE
310 Twinder Chicky Crook FALSE
512 Twinder Darnell Grissett TRUE
551 Twinder Olly Jojic FALSE
553 Twinte Nolan Itzhayek TRUE
656 Twinte Andreana Durnan FALSE
621 Twitterbeat Lanni Limrick FALSE
107 Twitterlist Andrew Meffen FALSE
371 Twitterlist Rochella Moreside TRUE
378 Twitternation Valdemar Bunt TRUE
574 Twitternation Jamal Heistermann FALSE
698 Twitterwire Rica Hammerman FALSE
173 Twitterworks Ennis Morse TRUE
452 Twiyo Ferd Harnell TRUE
703 Twiyo Esmaria Kellough FALSE
330 Vidoo Dedie Cramphorn NA
611 Vidoo Sutherland Pratley TRUE
734 Vidoo Archambault Wooller FALSE
740 Vidoo Cameron Nourse FALSE
41 Vimbo Georgy Mauro NA
472 Vimbo Andrus Curphey NA
522 Vinder Lamond Vequaud TRUE
721 Vinder Annamaria Darth TRUE
738 Vinder Calvin Coyte TRUE
39 Vinte Uriel Davidovitz TRUE
287 Vipe Karlen Aitken NA
414 Vipe Bern Poynzer TRUE
487 Viva Novelia Tizard FALSE
427 Voolia Nicolis Blamire TRUE
381 Voolith Yuri McGooch FALSE
74 Voomm Querida Hapgood TRUE
123 Voomm Holly MacCallester FALSE
232 Voomm Barton Poley TRUE
463 Voomm Shandy MacLardie NA
776 Voomm Sarine Lindeberg TRUE
363 Voonder Bette Prazer TRUE
87 Voonix Jordanna Leroy TRUE
374 Voonix Niel Trendle TRUE
261 Voonte Corinne Castlake TRUE
527 Voonte Julee Zini NA
292 Voonyx Arabele McCrow TRUE
314 Voonyx Catharina Snasel TRUE
50 Wikido Packston Haslewood TRUE
343 Wikido Amber Geertsen FALSE
95 Wikivu Thatcher Audenis FALSE
97 Wikivu Alie Guidera FALSE
111 Wikivu Tammi McNally TRUE
214 Wikivu Marnia Bunner TRUE
227 Wikivu Saw Phillipp FALSE
307 Wikivu Margarita Stockle TRUE
494 Wikivu Renata Bosma FALSE
499 Wikivu Dorelia Bannell TRUE
743 Wikivu Zandra Demead TRUE
29 Wikizz Drugi Cabrera FALSE
133 Wikizz Glad Mille TRUE
387 Wikizz Rustie Lyven TRUE
445 Wikizz Vallie Imms FALSE
489 Wordify Celestina Yetman FALSE
709 Wordify Zebedee Jeaycock FALSE
352 Wordware Gwendolyn Brabant FALSE
542 Wordware Kelley Klauber FALSE
765 Wordware Corena Pellitt NA
184 Yabox Donia Shellshear TRUE
523 Yabox Gaelan Grevatt TRUE
176 Yacero Tiphany Orrum FALSE
237 Yadel Harald Jochens TRUE
592 Yadel Dina Brason NA
764 Yadel Laraine Harkess TRUE
804 Yadel Darb Curnow FALSE
446 Yakidoo Agnese Bontoft TRUE
545 Yakidoo Edith Swigg TRUE
335 Yakijo Val Defty FALSE
566 Yakijo Celinda Avrasin FALSE
263 Yakitri Jeramie Kepp FALSE
370 Yakitri Tedman MacEnelly FALSE
554 Yakitri Milly Ormes TRUE
119 Yambee Shanon McCall FALSE
304 Yambee Timotheus Fitzjohn FALSE
437 Yambee Irwinn Dutnall TRUE
353 Yamia Barnabas Horsted FALSE
454 Yamia Gayelord Allberry TRUE
681 Yamia Paxon Dever FALSE
509 Yata Isaac Colliard FALSE
766 Yodel Talbot Marshman FALSE
81 Yodo Carmina Percy TRUE
491 Yodo Bette Rushford FALSE
40 Yombu Wrennie Preator TRUE
131 Yombu Bernardo Buntain FALSE
674 Yombu Pier Enderle NA
277 Youbridge Nicoli Saing FALSE
348 Youbridge Raphael Barrie TRUE
712 Youbridge Janith Houlden TRUE
221 Youfeed Ogdan Hillborne FALSE
249 Youfeed Gabriel Kobierski FALSE
191 Youopia Ade Murison FALSE
686 Youopia Freddy Durn FALSE
114 Youspan Bellina Pedrol NA
146 Youspan Pet Turbat TRUE
224 Youspan Althea Hazleton FALSE
325 Youspan Edie Rachuig TRUE
401 Youspan Anthia Woolfitt NA
615 Youspan Aurel Castelyn TRUE
809 Youspan Xerxes Burtt TRUE
816 Youspan Karole Guerin TRUE
653 Yoveo Padget Kollach FALSE
369 Yozio Stirling Fishburn NA
687 Yozio Rhianon Moulden FALSE
713 Zava Elaina Wiltshier TRUE
739 Zava Martino Cornehl FALSE
112 Zazio Gerard Hanner FALSE
547 Zazio Lilas Lineham TRUE
613 Zazio Tracie Slisby TRUE
410 Zoombeat Chick Albion FALSE
661 Zoombeat Robinett Whitland FALSE
517 Zoombox Manny Passy TRUE
635 Zoombox Cloris Edmott TRUE
317 Zoomcast Maxine Benneyworth FALSE
399 Zoomdog Vanna Welland NA
418 Zoomdog Harvey Filyukov FALSE
519 Zoomdog Monte Heaford FALSE
702 Zoomdog Ravi Hitter TRUE
225 Zoomlounge Sybil Oliveras FALSE
360 Zoomlounge Garald Nizet TRUE
529 Zoomlounge Paige Pexton TRUE
375 Zoonder Aubrette Guido TRUE
533 Zoonder Marylinda Corgenvin TRUE
699 Zoonder Lannie Rayhill FALSE
402 Zoonoodle Patric Cone TRUE
750 Zoonoodle Jodee Merring TRUE
571 Zooveo Melony Llewellyn FALSE
198 Zoovu Ros Glaze FALSE
390 Zooxo Jillana Hacaud TRUE
438 Zooxo Fernanda Durward FALSE
659 Zooxo Almira Sandle NA