![]() ![]() To make this work, I’ve found you’ll need to instead put your question mark with brackets around it. Note: If you have a question mark in your URL, you won’t be able to simply escape the character with a slash (\). Even though this formula uses regular expressions, you will notice there is no need for you to escape characters such as dashes or forward slashes in either one of these examples. When you use this formula on your own data, replace my fake URL with the URL you want to use. Translated, this says “Whenever you see the URL ‘/locations/dallas-main-street/’, use ‘Dallas – Main Street’ instead. The second formula is much more simple: WHEN REGEXP_MATCH(Landing Page, '.*(/locations/dallas-main-street/).*') THEN "Dallas - Main Street" If you have prepended your hostname, make sure to add it in right after the caret. This formula will only work for those who have not prepended the hostname to the URL in Google Analytics. Translated, the formula says “Whenever you see a landing page that exactly matches ‘/’, make it say “Homepage” instead. ![]() This formula will change the page path “/” to the word “Homepage.” If you are not familiar with regex and haven’t read my regex 101 post, the formula may seem like a foreign language. The first one is WHEN REGEXP_MATCH(Landing Page, "^/$") THEN "Homepage" In the screenshot, I have given two types of REGEXP_MATCH formulas to produce our desired end result. Name your Field Name – I chose the name “Modified URL.” Then you will use a Case/When formula to categorize your URLs. Try adding a prefix in your reporting to add more clarity, such as “PPC Landing Page: 50% Off.”Īfter you have added your data source (in this case, Google Analytics) into Google Data Studio, go to Resource > Manage Added Data Sources.Ĭlick “Edit” once your data source appears. While this is a smart move by your PPC team, remembering all your landing page URLs when looking at a report can be a pain. For example, you may want to use the URL “/50-percent-off” on your Google Ads campaigns instead of “/landing-page/50-percent-off” to get a higher click-through rate. Grouping Pages: Sometimes landing pages are more user-friendly without grouping them under a subfolder.For example, if the Dallas Main Street location is referred to as Store # 152, use that nomenclature in your reporting. Try changing the page path “/locations/dallas-main-street” to “Dallas – Main Street Location.” Even better, stick to standard naming conventions used throughout the organization. Your Location Pages: For multi-location businesses, interpreting URLs is not always impossible, rather it is just inconvenient.Make it easier for your reader by changing the name in your reports to “Homepage.” When not accompanied by the rest of your domain, it is less intuitive that the symbol “/” is the front page of your website. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |