CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • What are the most commonly used email domains?
Pages: [1]

Author Topic: What are the most commonly used email domains?  (Read 6325 times)

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
What are the most commonly used email domains?
May 22, 2012, 01:11:45 am
Hi,

Working on a module to get less invalid emails http://drupal.org/sandbox/tttp/1593172 and I would need the most commonly used domain names by your users.

Running on some of my dbs, that's what I have

generic ones:
| gmail.com
| hotmail.com
| yahoo.com

french:
| wanadoo.fr 
| yahoo.fr   
| free.fr
| orange.fr
| laposte.net
| hotmail.fr

UK
| yahoo.co.uk
| hotmail.co.uk
| btinternet.com
| live.co.uk
| tiscali.co.uk

belgium/nl

telia.com
skynet.be
xs4all.nl


Could you run the following sql command on your db:
Code: [Select]
SELECT SUBSTRING_INDEX(email, '@', -1) as Domain, count(*) as Total  FROM civicrm_email GROUP BY Domain ORDER BY Total DESC        LIMIT 10;
and post what you have in your country (or correct me if you have different results above)

X+
« Last Edit: May 22, 2012, 01:16:47 am by xavier »
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: What are the most commonly used email domains?
May 22, 2012, 10:33:06 am
In addition to the ones you listed:

nyc.rr.com
earthlink.net
verizon.net
msn.com
mac.com
mindspring.com
optonline.net
att.net
nyu.edu
me.com
schools.nyc.gov
hearst.com
citi.com
condenast.com
columbia.edu
hunter.cuny.edu
legal-aid.org
aexp.com

Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

Owen

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 2
    • Leukaemia & Lymphoma Research
  • CiviCRM version: 4.3.4
  • CMS version: Drupal 7
  • MySQL version: -
  • PHP version: -
Re: What are the most commonly used email domains?
May 23, 2012, 01:53:45 am
UK :

hotmail.com
hotmail.co.uk
btinternet.com
yahoo.co.uk
gmail.com
aol.com
ntlworld.com
yahoo.com
googlemail.com
tiscali.co.uk

mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: What are the most commonly used email domains?
May 23, 2012, 07:34:06 am
Quebec:

videotron.ca
sympatico.ca
yahoo.ca
live.ca
umontreal.ca
usherbrooke.ca
ulaval.ca
mail.mcgill.ca
globetrotter.net
cgocable.ca
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • What are the most commonly used email domains?

This forum was archived on 2017-11-26.