Zacznij terazZacznij za darmo

Text validation

Previously, you fixed and fine-tuned the digital marketing data table. In this exercise you are going to work to ensure that some key components of paid search marketing are clean.

Each of the ad groups in a campaign has a theme, which we have defined in a previous lesson as the product category: Mugs, Tee Shirts, and Sweaters. It is important to know what page on your website the user is landing on, so landing pages are often included in the table. Learn more about landing pages.

Another key component is knowing who is managing the campaigns, which is usually defined by the email associated with the campaigns. From this data, there are three emails, all controlling a set of campaigns.

To ćwiczenie jest częścią kursu

Marketing Analytics w Google Sheets

Zobacz kurs

Instrukcje do ćwiczenia

  • For the cells in range D2:D29, add a data validation to make sure each url is valid.
  • Correct any flagged cells in the URL column.
  • Add a data validation to check for valid email entry for the cells in range E2:E29.
  • Fix all flagged emails in the Email column.

Interaktywne ćwiczenie praktyczne

Przekształć teorię w praktykę dzięki jednemu z naszych interaktywnych ćwiczeń

Rozpocznij ćwiczenie