[Jeff Yankley]

Hi Greg, as Brian Riley mentioned, at Consumers Energy, we purchase data from Dun & Brad​street (D&B) that includes NAICS codes (along with 200+ other firmographic attributes).  Twice per year, we send D&B a file containing all of our business customer names and addresses (along with customer account numbers) and they run through an algorithm to match our customers with a DUNS number in their systems and they append the 200+ data attributes.  We then store this data into our data lake to query on whenever we need to. 

This information came in real handy for us while we deal with the COVID-19 situation.  The federal and state governments have financial programs designed for small businesses with under 50 employees.  Two of the attributes we receive from D&B are number of employees at a specific location and for the business overall (think of a business like General Motors where they may have tens of thousands of employees in their corporation but at a given location, they will have less than that).  Using this information, we were able to send targeted emails to these small business customers explaining the different programs that are available to help them.

Certainly not a fool proof solution but it at least gave us something.

Not sure if this is exactly what you’re looking for.  Happy to connect if you have any follow-up questions. 

Stay safe and healthy y’all (I’m a Michigander – the y’all is for Gina Weber :-) )

——————————
Jeff Yankley
Consumers Energy
——————————
——————————————-
Original Message:
Sent: 03-30-2020 12:42
From: Greg McMahan
Subject: NAICS codes

Hello,

I would like to post a question for any members that are using or plan on using NAICS codes for Customer Segmentation. I have been asked to identify businesses in our service area that are most effected by our state shutdown of non-essential businesses  – restaurants, bars ect. NAICS codes seem to be the best avenue but we currently don’t collect them in our system just a UBI#.

Has anyone found a way to crossreference UBI# to NAIC codes or even been able to get these codes based on addresses or UBI#. I did see a site with a lookup tool (not sure if anyone has used this or not) that may work for purchasing them by address. If anyone has any experience with this site or any other sites that have been used. https://www.naics.com/company-lookup-tool/

Any help would be appreciated.

Thanks, Greg

——————————
Greg McMahan
Data Analyst
Benton PUD
——————————

[Greg Mcmahan]

Thanks Amber for providing the information on what you are doing.

 

Thanks, Greg

 

——Original Message——

Hi there.  What we’ve been using is a combination of fields, we have SIC codes in our customer system (but those are only captured when the customer first becomes a gas or electric customer through our New Business process not updated through move in/move out processes) and a revenue class field where we identify attributes such as hospital, etc.  The data quality isn’t great but its the best we have.  We don’t capture NAICS code or anything else in our systems.

——————————
Amber Cole
Director Customer Insights & Performance
NiSource
acole@nisource.com
614-460-6086
——————————
——————————————-
Original Message:
Sent: 03-30-2020 12:42
From: Greg McMahan
Subject: NAICS codes

Hello,

I would like to post a question for any members that are using or plan on using NAICS codes for Customer Segmentation. I have been asked to identify businesses in our service area that are most effected by our state shutdown of non-essential businesses  – restaurants, bars ect. NAICS codes seem to be the best avenue but we currently don’t collect them in our system just a UBI#.

Has anyone found a way to crossreference UBI# to NAIC codes or even been able to get these codes based on addresses or UBI#. I did see a site with a lookup tool (not sure if anyone has used this or not) that may work for purchasing them by address. If anyone has any experience with this site or any other sites that have been used. https://www.naics.com/company-lookup-tool/

Any help would be appreciated.

Thanks, Greg

——————————
Greg McMahan
Data Analyst
Benton PUD
——————————

[Greg Mcmahan]

Thanks Jeff and Brian,

 

The information you provided is a good option for getting lots of customer attributes for many use cases such as the COVID-19 situation. We will definitely need to look into this. I may be asking for a follow up call with you on this for more detail.

 

Thanks again,

 

Greg McMahon

 

 

——Original Message——

Hi Greg, as Brian Riley mentioned, at Consumers Energy, we purchase data from Dun & Brad​street (D&B) that includes NAICS codes (along with 200+ other firmographic attributes).  Twice per year, we send D&B a file containing all of our business customer names and addresses (along with customer account numbers) and they run through an algorithm to match our customers with a DUNS number in their systems and they append the 200+ data attributes.  We then store this data into our data lake to query on whenever we need to. 

This information came in real handy for us while we deal with the COVID-19 situation.  The federal and state governments have financial programs designed for small businesses with under 50 employees.  Two of the attributes we receive from D&B are number of employees at a specific location and for the business overall (think of a business like General Motors where they may have tens of thousands of employees in their corporation but at a given location, they will have less than that).  Using this information, we were able to send targeted emails to these small business customers explaining the different programs that are available to help them.

Certainly not a fool proof solution but it at least gave us something.

Not sure if this is exactly what you’re looking for.  Happy to connect if you have any follow-up questions. 

Stay safe and healthy y’all (I’m a Michigander – the y’all is for Gina Weber :-) )

——————————
Jeff Yankley
Consumers Energy
——————————