Validations using cell criteria and checkboxes
1. Validations using cell criteria and checkboxes
Let's discuss two more data validation options: the text data validation and the checkbox data validation.2. Data validation for common mistakes
How can we prevent bad data entry in cells that have a seemingly infinite number of variations? From a digital marketing standpoint, landing pages and emails fit this criteria.3. Data validation for common mistakes
Landing pages are the pages that paid advertisements take the user to after they click on the ad. The landing pages are very important to digital marketing professionals because their pay-per-click strategies are based on these pages. If a certain landing page is not driving any quality traffic, it will need to be modified to better suit the consumer. It is a common mistake to include a URL with typos, which causes issues when reporting the data, since it results in misreporting the amount of money spent on sending users to a certain page.4. Data validation for common mistakes
It is common for a digital marketing agency to use different emails for different sources and campaigns. The email address is important because it typically indicates who is making changes to the campaigns and setting the budgets. Emails and URLs are similar in that they have a seemingly infinite number of possible variations. Luckily, data validation provides a way to ensure that cells contain valid emails or URLs.5. Text validation: URL and email validity
URL validity is a predefined criteria provided by Google Sheets that you can use by selecting "text" and "is valid url". Note that this validation will not ensure that the right URL is entered, it simply tests if the entry is structured as a functioning URL. For example, if you enter google-dot-com instead of datacamp-dot-com in a cell, it will not throw an error, as google-dot-com is structured correctly.6. Text validation: URL and email validity
Email text validation is similar to URL validation; we simply select the "is valid email" criteria instead. Similar to URL validation, this does not verify that you are typing in the correct email, it only checks that it is an email.7. Data validation: checkboxes
Let's now explore the checkbox data validation, which adds interactive checkboxes to the cells. Checkboxes can be used with data that have binary values, such as True/False or Yes/No.8. Data validation: checkboxes
The cell's value is based on the checkbox status, which is True if the box is checked and False if it is unchecked. These are extremely useful, especially when combined with filters, as we can set custom values for checked and unchecked boxes. A common use case is determining which campaigns are active, where the checked boxes are active campaigns and unchecked boxes are inactive campaigns. If we apply a filter, we can filter the entire table by checked or unchecked boxes, which represent active campaigns or inactive campaigns!9. Let's get to work!
Keep in mind, the email and URL text validation options only check validity and not correctness, while checkboxes are for cells that will only ever have one or two values. Let's get to work!Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.