The Schema Audit provides an overview of how your user fields are being used, the data they contain, and where they are getting that data. It is a great way to see if you have user fields that don't have any data or are not being used for any audience. If you haven't viewed the User Fields document yet, we recommend doing so before diving in here.
On your Lytics dashboard, navigate to Data > Schema Audit. This section offers a snapshot of your data to verify your data mapping techniques. When you need more detailed information during data onboarding or while troubleshooting, the Data Streams section will more likely serve your needs.
Filtering the Schema Audit
By default, the Schema Audit includes all user fields in your account. You can filter the report in three different ways.
Users with field allows you to filter fields based the percentage of users in your account who have a user field. For example, if you choose At least 50%, the Schema Audit will be filtered to include only user fields found on 50% or more of the profiles in your account.
Data stream allows you to filter the Schema Audit based on the data source of a user field. Keep in mind that a user field may be receiving data from more than one data stream.
Search box allows you to search for a specific user field by name.
Interpreting Data Visualizations
The visualizations near the top of the report tell you about how user fields are being used in your Lytics account. You can click on one of the visualizations to filter the table below.
The first pie chart shows the percentage of user fields that are providing data to build profiles from. In the example above, only 40% of user fields provide data to profiles. That means the other 60% of user fields have no data at all. This number should be as close to 100% as possible.
The second pie chart shows the percentage of user fields that are being used to define audiences. In this example, 94% of user fields are not being used to define any audience. This account probably mapped too much data, and could trim down their LQL quite a bit.
The third pie chart shows how many user fields are merging data from multiple streams. A common example of merging data from multiple streams is an
The distribution bar along the bottom of this section shows you what type of user fields are in your account. Certain types of user fields, especially any containing
map, are more expensive and should be used carefully. Mouse over the slices of the distribution bar to see how many user fields of each type are in your account.
User Fields Table
Browse the table to find detailed information about a specific user field. Select the List audiences each field uses checkbox to expand the table and see any audience that contains a user field in its definition.
|ID||Slug for a user field|
|Name||User friendly name for a user field|
|Type||Data type contained in the user field|
|Sources||Streams that the user field reads data from|
|Users with field||Number of user profiles with data from this user field|
|Approx. Cardinality||Number of unique values in this user field|
|Times used||Number of times this user field is used to define an audience|
NOTE: If you have questions about the user fields on your Schema Audit, contact your Lytics customer success representative for more information.