If your file is not shared with hr@beautifulconceptsco.com - You are not ready for this step .

1. In your web browser - Open BBB.org

2. If it asks you which country - select USA

3. In your search tab - enter : Property Management

4. In you city - Enter : [ city name ]

   1. You have been provided city and state names i.e. Spring Fields Ohio , In this case - Spring Fields is the City and Ohia is the State .

   2. You should be able to see Spring Field , OH - Select that Option

   3. If you are not sure which letters represent your state - Please use google

5. When asked if you want to view Accredited Only or Accredited and Non-Accredited

   1. Please select Accredited and Non-Accredited

   2. 
      

1. 
   

2. Only select the the entries that show - Property Management

3. Skip Ads

Important

• You need to look for the email address either via Google or Facebook page

• You need to get the BM ( Business Management ) Details

• Incase you have extra Information - You can add it to notes

• Leave Form & Form Template - Blank - [ They are not for now ]

• After you have shared the sheet with us - We will map it to ensure it is working correctly

VERY IMPORTANT

1. Map the Headers to your Data Correctly - All Incorrect data will be dis-regarded.

2. Ensure you are not adding duplicates - Duplicates will be discarded

How to Check if you have duplicates :

Use the COUNTIF formula to find duplicates.

The COUNTIF formula [=COUNTIF (A:A, A1)>1] tells Sheets where to look for duplicates. The information in the parentheses represents the column you want to track and the specific cell you want to start with. The information outside the parentheses states that you want Sheets to count duplicates, or anything appearing more than once (>1). 

Since we’re looking for duplicate directors, we want to adjust the formula to read the C column. Our formula should become =COUNTIF (C:C, C2)>1. You can see how it begins to highlight repeat directors. 

• [ Feel Free to search on Youtube for a tutorial ]