Customer portfolio Browse individual customer records below to view detailed order history, contact information, and relationship details. Each customer profile provides insights into purchasing behavior and account status.
PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX dct: <http://purl.org/dc/terms/> PREFIX schema: <https://schema.org/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> CONSTRUCT { GRAPH ?graph { ?graph dct:title ?companyName ; foaf:primaryTopic ?customer ; foaf:topic ?contactPoint, ?employee, ?postalAddress . ?customer a schema:Corporation ; schema:identifier ?customerID ; dct:title ?companyName ; schema:legalName ?companyName ; schema:contactPoint ?contactPoint ; schema:employee ?employee . ?contactPoint a schema:ContactPoint ; foaf:page ?graph ; schema:telephone ?phone ; schema:faxNumber ?fax . ?employee a schema:Person ; foaf:page ?graph ; schema:name ?contactName ; dct:title ?contactName ; schema:jobTitle ?contactTitle ; schema:telephone ?phone ; schema:faxNumber ?fax ; schema:address ?postalAddress ; geo:lat ?lat ; geo:long ?long . ?postalAddress a schema:PostalAddress ; foaf:page ?graph ; schema:addressCountry ?country ; schema:addressLocality ?city ; schema:postalCode ?postalCode ; schema:streetAddress ?address ; schema:addressRegion ?region . } } WHERE { ?customer_row <#customerID> ?customerID ; <#companyName> ?companyName ; <#contactName> ?contactName ; <#contactTitle> ?contactTitle ; <#address> ?address ; <#city> ?city ; <#postalCode> ?postalCode ; <#country> ?country ; <#phone> ?phone . OPTIONAL { ?customer_row <#region> ?region } OPTIONAL { ?customer_row <#fax> ?fax } OPTIONAL { ?customer_row <#lat> ?lat_string BIND(xsd:float(?lat_string) AS ?lat) } OPTIONAL { ?customer_row <#long> ?long_string BIND(xsd:float(?long_string) AS ?long) } BIND(uri(concat(str($base), "customers/")) AS ?container) BIND(uri(concat(str(?container), encode_for_uri(?customerID), "/")) AS ?graph) BIND(uri(concat(str(?graph), "#this")) AS ?customer) BIND(uri(concat(str(?graph), "#contact-point")) AS ?contactPoint) BIND(uri(concat(str(?graph), "#employee")) AS ?employee) BIND(uri(concat(str(?graph), "#postal-address")) AS ?postalAddress) }
Customer insights Understand customer value, geographic distribution, and purchasing patterns. Identifying top customers and market concentration helps prioritize account management and target growth strategies.
Geographic distribution Our customer base spans multiple countries, with varying levels of market penetration. Understanding geographic concentration helps guide expansion efforts and resource allocation.
PREFIX schema: <https://schema.org/> SELECT ?companyName (SUM(?sale) AS ?revenue) WHERE { GRAPH ?orderGraph { ?order schema:customer ?customer ; schema:orderedItem ?orderItem . ?orderItem schema:orderQuantity ?quantity ; schema:price ?price . BIND(?quantity * ?price AS ?sale) } GRAPH ?customerGraph { ?customer schema:legalName ?companyName . } } GROUP BY ?customer ?companyName ORDER BY DESC(?revenue) LIMIT 10
PREFIX schema: <https://schema.org/> SELECT ?country (COUNT(DISTINCT ?customer) AS ?customerCount) WHERE { GRAPH ?customerGraph { ?customer a schema:Corporation ; schema:employee ?employee . ?employee schema:address ?postalAddress . ?postalAddress schema:addressCountry ?country . } } GROUP BY ?country ORDER BY DESC(?customerCount)
PREFIX schema: <https://schema.org/> SELECT DISTINCT ?customer WHERE { GRAPH ?doc { ?customer a schema:Corporation ; schema:legalName ?companyName GRAPH ?orderDoc { ?order schema:customer ?customer } } } ORDER BY ?companyName