Null Amperity IDs

Use this query to discover if NULL Amperity IDs are present in the customer 360 database.

Important

The number of NULL Amperity IDs that should be present is zero.

When to use

1. Run this query on a regular basis.

2. If any records are returned, investigate why those records returned with NULL Amperity IDs.

Configure query

1. From the Queries tab, open the Stitch QA folder, and then select this query.

   Tip

   Add the Stitch QA queries template folder if it does not already exist.

2. Click Run Query and debug any issues that may arise. This query should return 0.

3. Click Activate.