Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Excel Formula To Extract Query Param Utm_Term From Url In Analytics Event Text

Q: How do I use the Excel Formula To Extract Query Param Utm_Term From Url In Analytics Event Text formula?

Paste the formula into the first output cell, then fill down to apply it to your range.

Extract query parameter utm_term from URLs in analytics event text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Quick answer

Extract query param utm_term from url in analytics event text.

Unified formula

ExcelWPS

=LET(q,IFERROR(TEXTAFTER(A2,"?"),""),pairs,TEXTSPLIT(q,"&"),m,FILTER(pairs,LEFT(pairs,LEN("utm_term="))="utm_term="),IFERROR(TEXTAFTER(INDEX(m,1),"="),""))

View platform differences

Google Sheets

=IFERROR(REGEXEXTRACT(A2, "(?:[?&])utm_term=([^&#]+)"), "")

How it works

Replace the sample range (like A2:A) with your real range.
Keep the same column order used in the example.
Fill down to apply the formula to every row.

Need a custom version?

Related formulas

Excel Formula To Extract Query Param Utm_Source From Url In Transaction Text

Extract query parameter utm_source from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Query Param Utm_Medium From Url In Transaction Text

Extract query parameter utm_medium from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Query Param Utm_Campaign From Url In Transaction Text

Extract query parameter utm_campaign from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Query Param Utm_Term From Url In Transaction Text

Extract query parameter utm_term from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Query Param Utm_Content From Url In Transaction Text

Extract query parameter utm_content from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Query Param Ref From Url In Transaction Text

Extract query parameter ref from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.