{"id":899,"date":"2017-03-25T12:58:01","date_gmt":"2017-03-25T08:58:01","guid":{"rendered":"https:\/\/optimizationup.com\/?p=899"},"modified":"2021-02-28T14:13:57","modified_gmt":"2021-02-28T10:13:57","slug":"regex-guide-google-data-studio","status":"publish","type":"post","link":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/","title":{"rendered":"Practical Guide to Regex in Google Data Studio"},"content":{"rendered":"<p>Regular expressions (regex or regexp) can help save time and effort when working with Google Analytics, <a href=\"https:\/\/optimizationup.com\/tag\/gtm\/\">Google Tag Manager<\/a> and now Google Data Studio. \u00a0They add extra flexibility to the way you create definitions or include &amp;\u00a0exclude\u00a0data from your reports.<\/p>\n<p>You can think of regex as specific sequences of characters that broadly or narrowly match patterns in your data. And to build a pattern you need learn the regex metacharacters. In this post, I will be covering most of the metacharacters along with practical examples from <a href=\"https:\/\/optimizationup.com\/tag\/google-data-studio\/\">Google Data Studio<\/a>.<\/p>\n<p>Before we start, I recommend you have a look and understand the formulas in the article below, because all of our regex examples are based on these formulas.<\/p>\n<p><a href=\"https:\/\/optimizationup.com\/custom-dimensions-google-data-studio-formulas\/\">Create Advanced Di<\/a><a href=\"https:\/\/optimizationup.com\/custom-dimensions-google-data-studio-formulas\/\">mensions in Google Data Studio via these 6 Formulas<\/a><\/p>\n<h4><\/h4>\n<h4>Caret ^<\/h4>\n<p>It matches the start of a string. In other words, it means something begins\u00a0with.<br \/>\n^social\u00a0matches\u00a0social media and\u00a0social network, but not online social.<\/p>\n<p>Practical Use in Google Data Studio<\/p>\n<p>Let&#8217;s say you have 3 paid social sources in your <a href=\"https:\/\/optimizationup.com\/tag\/analytics\/\">Google Analytics<\/a> (facebook \/ paid-social,\u00a0instagram\/paid-social, twitter\/paid-social). And you want to group any medium that starts with the string paid under a channel grouping called &#8220;Paid&#8221; and anything else under &#8220;Organic&#8221;.<\/p>\n<pre>CASE WHEN REGEXP_MATCH(meduim,\"^paid\") THEN \"Paid\"  ELSE \"Organic\" End<\/pre>\n<h4><\/h4>\n<h4>Dot .<\/h4>\n<p>It matches any single character.<\/p>\n<p>go.gle\u00a0matches\u00a0google, goagle\u00a0and\u00a0gosgle but not gogle.<\/p>\n<p>The power of using the dot lies in combining it together with other characters.<\/p>\n<p>Practical Use in Google Data Studio<\/p>\n<p>Google Data Studio by default has a formula to convert all text to uppercase, but what if you want to capitalize only the first letter of your\u00a0traffic sources in Google\u00a0Analytics and create a report of the same.<\/p>\n<p>This can be done in three steps using the caret and the dot together\u00a0^. (which means select the first letter):<br \/>\n1- Extract the first letter using REGEXP_EXTRACT() with the regular expression ^.\u00a0which captures the first letter.<\/p>\n<p>2- Capitalize the extracted letter using UPPER().<\/p>\n<p>3- Replace the first letter in Source with nothing using\u00a0REGEXP_REPLACE() and concatenate it with the extracted CAP letter using CONCAT().<\/p>\n<p>So if we put all the formulas altogether, the final syntax will be as below:<\/p>\n<pre>CONCAT(UPPER(REGEXP_EXTRACT(Source, \"(^.)\")), REGEXP_REPLACE(Source, \"^.\", \"\"))<\/pre>\n<h4>Asterisk\u00a0*<\/h4>\n<p>It matches the preceding character 0 or more times.<\/p>\n<p>go*gle matches with google, gooogle, gooooogle\u00a0and gogle, but not goegle.<\/p>\n<p>One of the most powerful combinations of asterisk is with the dot (.*) It \u00a0actually matches everything,<\/p>\n<p>go.* matches with google, goooogle, goosssf and goelge.<\/p>\n<p>Practical Use in Google Data Studio<\/p>\n<p>You have search and display campaigns running within the same AdWords account, you want to review and compare the performance of each channel separately. Your campaigns naming includes the acronym SN for search and CN for display.<\/p>\n<p>^.* means text starts with anything, then contains (SN, CN) and finally ends with any string.<\/p>\n<p>So basically, the regex below means search for text contains my acronyms\u00a0(SN, CN) in the campaign name.<\/p>\n<pre>CASE WHEN REGEXP_MATCH(Campaign,\"^.*(SN).*\") THEN \"Search\"\nWHEN REGEXP_MATCH(Campaign,\"^.*(CN).*\") THEN \"Display\" \nELSE \"Undefined\" End<\/pre>\n<h4>Pipe |<\/h4>\n<p>It means OR.<\/p>\n<p>men|women match with men clothes\u00a0or\u00a0clothes for women.<\/p>\n<p>Practical Use in Google Data Studio<\/p>\n<p>You can run a performance report of your landing pages grouped into unified dimensions. For example, you&#8217;re running a fashion website that sells dresses, shirts, boots, sandals..etc. You\u00a0want to compare the performance of your website categories and review which category has the most sessions or transactions.<\/p>\n<pre>CASE WHEN REGEXP_MATCH(Landing Page,\"^.*(shirt|dress|jeans\") THEN \"Clothes\" \nWHEN REGEXP_MATCH(Landing Page,\"^.*(boot|sandal|sneaker\") THEN \"Shoes\" \nELSE \"Undefined\"\nEnd<\/pre>\n<h4>Dollar Sign $<\/h4>\n<p>It means text ends with.<\/p>\n<p>color$ matches red color and green color, but not color yellow.<\/p>\n<p>Practical Use in Google Data Studio<\/p>\n<p>You want to run a URL performance report of your website, but some of your links end with .php and you want to standardize\u00a0all the URLs by removing .php only from the end.<\/p>\n<pre>REGEXP_REPLACE(Landing Page, \"(.php$)\", \"\")<\/pre>\n<h4>Question Mark ?<\/h4>\n<p>It matches the preceding character zero or one time. In other words, it means the previous character is optional.<\/p>\n<p>colo?r matches colr\u00a0and color, but not colour.<\/p>\n<p>Practical Use in Google Data Studio<\/p>\n<p>You want to run a keywords performance report of your branded and non-branded terms.<\/p>\n<p>Optimization ?up matches both;\u00a0optimization up with space and optimizationup without space.<\/p>\n<pre>CASE WHEN REGEXP_MATCH(Keyword,\".*(optimization ?up).*$\") THEN \"Paid\"  ELSE \"Organic\" End<\/pre>\n<h4>Square brackets []<\/h4>\n<p>Matches the enclosed characters in any order anywhere in a string.<\/p>\n<p>col[oau]r matches color, colar\u00a0and\u00a0colur,\u00a0but not coloaur.<\/p>\n<p>Square brackets are very powerful when they are combined with dashes. Dashes create a range of characters between the brackets.<\/p>\n<p>[a-z] matches any lowercase letter between a to z.<\/p>\n<p>[0-9] matches any number from 0 to 9.<\/p>\n<p>Practical Use in Google Data Studio<\/p>\n<p>Let&#8217;s assume you sell cars and you want to create a performance report for all the sold car models between 2010 and 2017. You can create a filter for your query using the regular expression below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1257\" src=\"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/03\/filter-regex-1-300x39.png\" alt=\"regex in google data studio\" width=\"524\" height=\"68\" srcset=\"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/03\/filter-regex-1-300x39.png 300w, https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/03\/filter-regex-1.png 677w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/p>\n<h4>Parentheses ()<\/h4>\n<p>Matches the enclosed characters in exact order anywhere in a string. It also uses to group characters or string together.<\/p>\n<p>g(oo)gle matches only google.<\/p>\n<p>The power of parentheses lies in combing it with different metacharacters.<\/p>\n<p>Practical Use in Google Data Studio<\/p>\n<p>Let&#8217;s say you want to run a report of the categories included in your campaigns names. Your campaign naming looks like\u00a0below:<\/p>\n<p>SN-EN_Category:Cars_Exact<\/p>\n<p>SN-EN_Category:Bikes_BMM<\/p>\n<p>To extract the category name from the campaign name, we can write something as follows:<\/p>\n<pre>REGEXP_EXTRACT(Campaign, \"Category:(.*?[^_]*)\")<\/pre>\n<p>.*? means capture everything after Category: The ? is added to make .*\u00a0non-greedy by matching little data.<\/p>\n<p>[^_]* to\u00a0stop at the _ underscore. Please note when the caret\u00a0comes between the square brackets [^], it means doesn&#8217;t contain.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Regular expressions (regex or regexp) can help save time and effort when working with Google Analytics, Google Tag Manager and now Google Data Studio. \u00a0They add extra flexibility to the way you create definitions or include &amp;\u00a0exclude\u00a0data from your reports. You can think of regex as specific sequences of characters that broadly or narrowly match&#8230;<\/p>\n<p><a class=\"read-more\" href=\"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":1262,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[45],"class_list":["post-899","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analyze","tag-google-data-studio"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Practical Guide to Regex in Google Data Studio | Optimization Up<\/title>\n<meta name=\"description\" content=\"Learn how to use regular expressions, regex or regexp in Google Data Studio to create advanced formulas, calculated fields, filters and dimensions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Practical Guide to Regex in Google Data Studio | Optimization Up\" \/>\n<meta property=\"og:description\" content=\"Learn how to use regular expressions, regex or regexp in Google Data Studio to create advanced formulas, calculated fields, filters and dimensions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/\" \/>\n<meta property=\"og:site_name\" content=\"Optimization Up\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/A7med.3lii\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-25T08:58:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-28T10:13:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/03\/data-studio-regex-resized.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1203\" \/>\n\t<meta property=\"og:image:height\" content=\"466\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ahmed Ali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@A7med_3ly\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ahmed Ali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/\"},\"author\":{\"name\":\"Ahmed Ali\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\"},\"headline\":\"Practical Guide to Regex in Google Data Studio\",\"datePublished\":\"2017-03-25T08:58:01+00:00\",\"dateModified\":\"2021-02-28T10:13:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/\"},\"wordCount\":904,\"commentCount\":47,\"image\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/data-studio-regex-resized.png\",\"keywords\":[\"Google Data Studio\"],\"articleSection\":[\"Analyze\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/\",\"name\":\"Practical Guide to Regex in Google Data Studio | Optimization Up\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/data-studio-regex-resized.png\",\"datePublished\":\"2017-03-25T08:58:01+00:00\",\"dateModified\":\"2021-02-28T10:13:57+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\"},\"description\":\"Learn how to use regular expressions, regex or regexp in Google Data Studio to create advanced formulas, calculated fields, filters and dimensions.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/#primaryimage\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/data-studio-regex-resized.png\",\"contentUrl\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/data-studio-regex-resized.png\",\"width\":1203,\"height\":466},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/regex-guide-google-data-studio\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/optimizationup.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Practical Guide to Regex in Google Data Studio\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#website\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/\",\"name\":\"Optimization Up\",\"description\":\"Advanced Optimization &amp; Analytics Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/optimizationup.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\",\"name\":\"Ahmed Ali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"caption\":\"Ahmed Ali\"},\"description\":\"Entrepreneur focused on building MarTech products that bridge the gap between marketing and technology. Check out my latest products Markifact,\u00a0 Marketing Auditor &amp; GA4 Auditor - discover all my products here.\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/A7med.3lii\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/a7med-ali\\\/\",\"https:\\\/\\\/x.com\\\/A7med_3ly\"],\"url\":\"https:\\\/\\\/optimizationup.com\\\/author\\\/a7med\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Practical Guide to Regex in Google Data Studio | Optimization Up","description":"Learn how to use regular expressions, regex or regexp in Google Data Studio to create advanced formulas, calculated fields, filters and dimensions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/","og_locale":"en_US","og_type":"article","og_title":"Practical Guide to Regex in Google Data Studio | Optimization Up","og_description":"Learn how to use regular expressions, regex or regexp in Google Data Studio to create advanced formulas, calculated fields, filters and dimensions.","og_url":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/","og_site_name":"Optimization Up","article_author":"https:\/\/www.facebook.com\/A7med.3lii","article_published_time":"2017-03-25T08:58:01+00:00","article_modified_time":"2021-02-28T10:13:57+00:00","og_image":[{"width":1203,"height":466,"url":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/03\/data-studio-regex-resized.png","type":"image\/png"}],"author":"Ahmed Ali","twitter_card":"summary_large_image","twitter_creator":"@A7med_3ly","twitter_misc":{"Written by":"Ahmed Ali","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/#article","isPartOf":{"@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/"},"author":{"name":"Ahmed Ali","@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768"},"headline":"Practical Guide to Regex in Google Data Studio","datePublished":"2017-03-25T08:58:01+00:00","dateModified":"2021-02-28T10:13:57+00:00","mainEntityOfPage":{"@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/"},"wordCount":904,"commentCount":47,"image":{"@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/03\/data-studio-regex-resized.png","keywords":["Google Data Studio"],"articleSection":["Analyze"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/optimizationup.com\/regex-guide-google-data-studio\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/","url":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/","name":"Practical Guide to Regex in Google Data Studio | Optimization Up","isPartOf":{"@id":"https:\/\/optimizationup.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/#primaryimage"},"image":{"@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/03\/data-studio-regex-resized.png","datePublished":"2017-03-25T08:58:01+00:00","dateModified":"2021-02-28T10:13:57+00:00","author":{"@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768"},"description":"Learn how to use regular expressions, regex or regexp in Google Data Studio to create advanced formulas, calculated fields, filters and dimensions.","breadcrumb":{"@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/optimizationup.com\/regex-guide-google-data-studio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/#primaryimage","url":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/03\/data-studio-regex-resized.png","contentUrl":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/03\/data-studio-regex-resized.png","width":1203,"height":466},{"@type":"BreadcrumbList","@id":"https:\/\/optimizationup.com\/regex-guide-google-data-studio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/optimizationup.com\/"},{"@type":"ListItem","position":2,"name":"Practical Guide to Regex in Google Data Studio"}]},{"@type":"WebSite","@id":"https:\/\/optimizationup.com\/#website","url":"https:\/\/optimizationup.com\/","name":"Optimization Up","description":"Advanced Optimization &amp; Analytics Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/optimizationup.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768","name":"Ahmed Ali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","caption":"Ahmed Ali"},"description":"Entrepreneur focused on building MarTech products that bridge the gap between marketing and technology. Check out my latest products Markifact,\u00a0 Marketing Auditor &amp; GA4 Auditor - discover all my products here.","sameAs":["https:\/\/www.facebook.com\/A7med.3lii","https:\/\/www.linkedin.com\/in\/a7med-ali\/","https:\/\/x.com\/A7med_3ly"],"url":"https:\/\/optimizationup.com\/author\/a7med\/"}]}},"_links":{"self":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/comments?post=899"}],"version-history":[{"count":4,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/899\/revisions"}],"predecessor-version":[{"id":1488,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/899\/revisions\/1488"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/media\/1262"}],"wp:attachment":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/media?parent=899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/categories?post=899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/tags?post=899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}