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
I2that will extract the first three characters of a string. - In cell
E2:- Use
REGEXEXTRACT()to extract the characters from the string in cellA2matching the regular expression in cellI2(don't forget the absolute reference!). - In the same cell, use
&characters to append an underscore,"_", and the contents from cellB2to the end of the extracted string.
- Use
- Apply the formula to the remainder of the cells in the column,
E3:E29.
