Contains Url Best Practices

Guidelines for getting reliable signal from Contains Url checks while keeping the noise (and the maintenance) low.

Point the check at a field that should always carry the value

The rule asserts that URLs are present in every row, so it belongs on a column dedicated to that data. Pointing it at a free-text column where a URL is merely common turns every ordinary row into an anomaly.

Use containment deliberately

The value passes as soon as a URL appears anywhere inside it, so "contact: {value}" passes just like a bare value. When the field must hold nothing but the value, pair the check with Matches Pattern anchored to the whole string.

Pair with Not Null when the field is mandatory

NULL values pass. Contains Url asserts that present values contain a URL; it does not require the field to be populated. When the field must also exist, add a Not Null check on the same field.

Decide whether relative paths should pass

A storage key or a relative path is not a URL and will be reported. When your column legitimately holds relative locations, either normalize them into absolute links upstream or use Matches Pattern with an expression that describes the shape you actually accept.

Remember the check does not fetch the link

A well-formed URL can still be dead. The check validates the shape of the text, not the availability of the resource; monitoring the target is a separate concern outside the platform.

Keep coverage at 100% unless a known backlog exists

At 100% coverage every failing row is reported as a Record Anomaly, which tells you exactly which values are wrong. Below 100% the check reports a single Shape Anomaly only when the failing fraction crosses the tolerance, and no per-row detail is produced. Lower coverage only while a known set of legacy rows is being cleaned up.

Scope with a filter instead of loosening coverage

When the rule only applies to part of the table (one channel, one country, rows created after a migration), express that with a filter clause rather than by lowering coverage. The filter removes the out-of-scope rows from evaluation entirely, and the expression is echoed in every anomaly message.

Route the anomalies to the right people

A missing or malformed value usually comes from a collection form or an integration. Set an Anomaly Assignee from the team that owns that producer, and tag the check so related checks are easy to find.