Zip Count Report
================
This is a list of all zip codes and how many people
match each **Zip +2** code.
After you create it and run it the first time,
you have the option to **Add to Menu**.
This will add it to the **blue Toolbar** on Search Builder,
an Organization, or a Tag.

Create the Report
~~~~~~~~~~~~~~~~~
Copy the :ref:`code below <ZipCountCode>` and paste it
into a new SQL Script in your database. The recommended name is ``ZipCount``.

See :doc:`../CreateSqlScript`.

Run this Report
---------------
If you add this to the blue Toolbar you
can create a search and, making sure you have one person per household
in the search results, you can generate this Zip Count Report
to see how many mail pieces will be in each zip plus 2 area.

You also have the option to **Download as Excel**.

Sample Report
~~~~~~~~~~~~~

.. figure:: https://i.tpsdb.com/2017-09-25_17-44-20.png
    :target: #

.. _ZipCountCode:

.. code-block:: sql

    ;WITH zips AS (
	SELECT
		LEFT(dbo.GetDigits(PrimaryZip), 7) zip
	FROM dbo.People p
	JOIN dbo.TagPerson tp ON tp.PeopleId = p.PeopleId
	WHERE LEN(ISNULL(PrimaryZip,'')) > 0
	AND @qtagid = tp.Id
    )
    SELECT zip, COUNT(*) [Count] FROM zips
    GROUP BY zips.zip
    order by zip


|
|

+--------------------+------------------+
| **Latest Update**  | **11/13/2020**   |
+--------------------+------------------+

Modify image link with secure protocol.