Génération de prospects à partir de la base SIRENE

Bonjour à tous,

J’ai agrégé la base SIRENE, RNCS et DataInfoGreffe.
Ce sur quoi je suis venu brancher Salesforce.

Cette grosse table permet de segmenter les entreprises selon tout un tas de critères (Activité, Effectifs, Catégorie Juridique, Scoring, prospect en cours, etc…).

Mon but est de pouvoir générer des prospects à partir de ces segments de la base SIRENE. Une solution serais d’aller scraper Sales Navigator avec des outils tels que PhantomBuster ou Captain Data.

C’est une solution, mais je la trouve un peu bancale pour plusieurs raisons :

  • La dénomination SIRENE peut ne pas correspondre à la dénomination Linkedin
  • Cela génère beaucoup de bruit car le matching de la dénomination est imprécise

Bref, c’est pas la joie donc je suis ouvert à vos suggestions :slight_smile:

Très bonne question. C’est quelque chose que nous gérons très bien chez Datagma.com par API. Ton call va ressembler à ça

https://gateway.datagma.net/api/ingress/v2/full?apiId=APIKEY&data=821893286&companyPremium=true&companyEmployees=true&employeeCountry=FR

En input, le numéro de SIREN, tu dis que tu veux la liste des employées, combien tu en veux, et dans quel pays . Et voila

Par exemple pour Spendesk ( SIREN 821893286) on va renvoyer (bien sur tu peux avoir plus d’infos en fonction de ce que tu demandes) :

{
"phone": null,
"email": null,
"person": null,
"company": {
"basic": null,
"french": null,
"full": null,
"premium": {
"url": "https://fr.linkedin.com/company/spendesk",
"name": "Spendesk",
"sphere": "",
"employeesAmountInLinkedin": "268",
"about": "Spendesk is the all-in-one spend management solution that delivers more control, visibility, and automation to today's finance teams. Combine spend approvals, virtual cards, physical cards, expense reimbursements, and invoice management into a single source of truth. With automated reconciliation processes and complete pre-spend control, finance teams are empowered to make smarter spending decisions.\n\nCheck out CFO Connect— a community for finance leaders with regular meetups, helpful content and an exclusive Slack channel. Learn more: http://www.cfoconnect.eu/",
"headquaterAddr": "Paris, Ile-de-France",
"headquaterAddrStreet": "51, Rue de Londres",
"headquaterAddrPostalCode": "75008",
"headquaterAddrLocality": "Paris",
"headquaterAddrRegion": Ile-De-France",
"headquaterAddrCountry": "FR",
"subsidiary": [
{
"subsidiary": "41 Luke Street, Hackney\nLondres, Angleterre EC2A 4DP, GB",
"firstPart": "41 Luke Street",
"secondpart": "Hackney\nLondres, Angleterre EC2A 4DP, GB"
},
{
"subsidiary": "Oberwallstraße 6, Berlin, Berlin 10117, DE",
"firstPart": "Oberwallstraße 6",
"secondpart": "Berlin, Berlin 10117, DE"
},
{
"subsidiary": "156 2nd St, San Francisco, Californie 94105, US",
"firstPart": "156 2nd St",
"secondpart": "San Francisco, Californie 94105, US"
}
],
"numberOfLocation": "4",
"website": "https://www.spendesk.com",
"industries": "Internet",
"companySize": "201-500 employees",
"headquarters": "Paris, ÃŽle-de-France",
"type": "Privately Held",
"founded": "2016",
"specialties": "Fintech, Cards, Banking, Accounting, Start-up, Expense management, and SaaS",
"specialtiesArr": [
{
"value": "Fintech"
},
{
"value": "Cards"
},
{
"value": "Banking"
},
{
"value": "Accounting"
},
{
"value": "Start-up"
},
{
"value": "Expense management"
},
{
"value": "SaaS"
}
],
"input": null,
"companyId": "10554832",
"locations": [],
"premiumConfidenceScore": 1
},
"phone": null,
"technologies": [
"amazon-cloudfront",
"amazon-s3",
"cloudflare",
"contentful",
"g-suite",
"google-cloud",
"gsap",
"hubspot",
"jquery",
"lodash",
"netlify",
"nginx",
"node-js",
"nuxt-js",
"segment",
"sqreen",
"vue-js",
"webpack"
],
"technologiesCategories": [],
"deepTraffic": null,
"employees": [
{
"name": "James Colgan",
"firstName": "James",
"lastName": "Colgan",
"location": "",
"jobTitle": "Chief Product Officer",
"company": "Spendesk",
"linkedInUrl": "https://linkedin.com/in/jamesacolgan",
"extractedRole": "product",
"extractedSeniority": "Executive",
"extractedGender": "male",
"dateDeNaissanceFormate": "",
"age": "",
"personConfidenceScore": 0,
"employeeJobScore": 1,
"employeeCompanyScore": 1
},
{
"name": "Stephanie Bowker",
"firstName": "Stephanie",
"lastName": "Bowker",
"location": "",
"jobTitle": "Head of Marketing",
"company": "Spendesk",
"linkedInUrl": "https://linkedin.com/in/stephanie-bowker-b8172717",
"extractedRole": "marketing",
"extractedSeniority": "Senior-level",
"extractedGender": "female",
"dateDeNaissanceFormate": "",
"age": "",
"personConfidenceScore": 0,
"employeeJobScore": 1,
"employeeCompanyScore": 1
},
{
"name": "Fabien Dawidowicz",
"firstName": "Fabien",
"lastName": "Dawidowicz",
"location": "",
"jobTitle": "Chief Financial Officer",
"company": "Spendesk",
"linkedInUrl": "https://linkedin.com/in/fabien-dawidowicz-920235",
"extractedRole": "finance",
"extractedSeniority": "Executive",
"extractedGender": "male",
"dateDeNaissanceFormate": "",
"age": "",
"personConfidenceScore": 0,
"employeeJobScore": 1,
"employeeCompanyScore": 1
},
{
"name": "Diane Bunod",
"firstName": "Diane",
"lastName": "Bunod",
"location": "Paris, Île-de-France, France",
"jobTitle": "Product Manager",
"company": "Spendesk",
"linkedInUrl": "https://linkedin.com/in/diane-bunod-8bb233a8",
"extractedRole": "product",
"extractedSeniority": "Mid-level",
"extractedGender": "female",
"dateDeNaissanceFormate": "",
"age": "",
"personConfidenceScore": 0,
"employeeJobScore": 1,
"employeeCompanyScore": 1
},
{
"name": "Lionel Paulus",
"firstName": "Lionel",
"lastName": "Paulus",
"location": "Paris et périphérie",
"jobTitle": "Front-End Engineer",
"company": "Growth",
"linkedInUrl": "https://linkedin.com/in/lionelpaulus",
"extractedRole": "engineering",
"extractedSeniority": "",
"extractedGender": "male",
"dateDeNaissanceFormate": "",
"age": "",
"personConfidenceScore": 0,
"employeeJobScore": 1,
"employeeCompanyScore": 0
},
{
"name": "Dominique Farrar",
"firstName": "Dominique",
"lastName": "Farrar",
"location": "",
"jobTitle": "Head of Community & Comms",
"company": "Spendesk",
"linkedInUrl": "https://linkedin.com/in/dominique-farrar",
"extractedRole": "",
"extractedSeniority": "",
"extractedGender": "",
"dateDeNaissanceFormate": "",
"age": "",
"personConfidenceScore": 0,
"employeeJobScore": 1,
"employeeCompanyScore": 0
},
{
"name": "Rodolphe Ardant",
"firstName": "Rodolphe",
"lastName": "Ardant",
"location": "Paris et périphérie",
"jobTitle": "Founder and CEO",
"company": "Spendesk",
"linkedInUrl": "https://linkedin.com/in/rodolpheardant",
"extractedRole": "leadership",
"extractedSeniority": "Owner",
"extractedGender": "male",
"dateDeNaissanceFormate": "",
"age": "",
"personConfidenceScore": 0,
"employeeJobScore": 1,
"employeeCompanyScore": 1
},
{
"name": "Lucy Warwood",
"firstName": "Lucy",
"lastName": "Warwood",
"location": "Paris, Île-de-France, France",
"jobTitle": "Tech People Partner",
"company": "Spendesk",
"linkedInUrl": "https://linkedin.com/in/lucywarwood",
"extractedRole": "",
"extractedSeniority": "",
"extractedGender": "female",
"dateDeNaissanceFormate": "",
"age": "",
"personConfidenceScore": 0,
"employeeJobScore": 1,
"employeeCompanyScore": 1
}
]
},
"emailV2": null,
"creditBurn": "1"
}```