{"version":"1.0","provider_name":"Keys Support","provider_url":"https:\/\/keys.express\/support\/en\/","author_name":"admin","author_url":"https:\/\/keys.express\/support\/en\/author\/dev_staedeli\/","title":"SQL Report by customer segment (Eurabis) - Keys Support","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"WUFv1csv0v\"><a href=\"https:\/\/keys.express\/support\/en\/documentation\/sql-report-by-customer-segment\/\">SQL Report by customer segment (Eurabis)<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/keys.express\/support\/en\/documentation\/sql-report-by-customer-segment\/embed\/#?secret=WUFv1csv0v\" width=\"600\" height=\"338\" title=\"&#8220;SQL Report by customer segment (Eurabis)&#8221; &#8212; Keys Support\" data-secret=\"WUFv1csv0v\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/keys.express\/support\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"Example SQL report to filter all orders with customer segment Eurabis. This has information on Kick Backs All orders for customers in segment Eurabis remove all cancelled and closed orders from the list Eurabis Customer list with yearly spend","thumbnail_url":"https:\/\/keys.express\/support\/wp-content\/uploads\/2024\/03\/Snag_650e6c.png","thumbnail_width":1748,"thumbnail_height":361}