How to Use the Geo Companion Document

A step-by-step guide to using the Geo Companion document when building an audience.

When targeting by city & state, county, or CBSA codes, you must use the Companion Document to ensure your values are correct and can be accurately processed by the system. It is recommended that you create your own copy of the Companion Document. 

1. In this example, we want to target Bergen County, New Jersey. To do so, we will open the Companion Document and navigate to the Unique State/County Codes sheet. 

unnamed (41)

2. To find New Jersey quickly and easily, we can set a filter by clicking the upside-down triangle in Column A. Under Filter by values, click Clear.

3. Type in the state your county is in. Click it. A checkmark will appear in front of it. Then, click OK.

unnamed (42)

4. Now we can see all the counties in NJ. Below, you’ll see we’ve highlighted Bergen. We will then copy the number in the column titled COMBINED_STATE_COUNTY_CODE.

unnamed (43)

5. Paste the county code into Connect under the County, State box. Make sure each number is followed by a pipe delimiter. 

unnamed (44)