始める無料で始める

Modify the campaign ID to include source

In this exercise, you will build the second, and final, part of the ID.

This section of the ID will indicate the source by prepending the first three letters of the source to the campaign-ad group IDs created in the previous lesson.

この演習はコースの一部です

Google Sheetsで学ぶマーケティング分析

コースを見る

演習の手順

  • Add a regular expression in cell I2 that will extract the first three characters of a string.
  • In cell E2:
    • Use REGEXEXTRACT() to extract the characters from the string in cell A2 matching the regular expression in cell I2 (don't forget the absolute reference!).
    • In the same cell, use & characters to append an underscore, "_", and the contents from cell B2 to the end of the extracted string.
  • Apply the formula to the remainder of the cells in the column, E3:E29.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する