<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Fueled on Medium]]></title>
        <description><![CDATA[Stories by Fueled on Medium]]></description>
        <link>https://medium.com/@fueled-io?source=rss-a49242fd320e------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*uF3uLhmGR3ugUfjnld1azQ.jpeg</url>
            <title>Stories by Fueled on Medium</title>
            <link>https://medium.com/@fueled-io?source=rss-a49242fd320e------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 09:34:43 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@fueled-io/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Why Is Implementing A CDP Traditionally So Hard?]]></title>
            <link>https://medium.com/@fueled-io/why-is-implementing-a-cdp-traditionally-so-hard-49a881e11d3e?source=rss-a49242fd320e------2</link>
            <guid isPermaLink="false">https://medium.com/p/49a881e11d3e</guid>
            <category><![CDATA[customer-data-platform]]></category>
            <category><![CDATA[segment]]></category>
            <category><![CDATA[shopify]]></category>
            <category><![CDATA[cdp]]></category>
            <dc:creator><![CDATA[Fueled]]></dc:creator>
            <pubDate>Thu, 23 Nov 2023 19:49:37 GMT</pubDate>
            <atom:updated>2023-11-23T19:49:37.448Z</atom:updated>
            <content:encoded><![CDATA[<h4>Conventional customer data platforms (CDP) are designed to be flexible and support broad engineering use cases. What does this mean for marketing and product teams?</h4><figure><img alt="Ant carrying a leaf over its head" src="https://cdn-images-1.medium.com/max/1024/0*L313iC9q-_83Owc8" /><figcaption><a href="https://www.pexels.com/photo/ant-branch-hard-work-leaf-1373894/"><em>https://www.pexels.com/photo/ant-branch-hard-work-leaf-1373894/</em></a></figcaption></figure><p>More and more companies are implementing Customer Data Platforms (CDPs) as the next step in the marketing race, to better capture and operationalize first-party and zero-party data. <a href="https://www.cdpinstitute.org/wp-content/uploads/2021/12/CDPI-2324-Use-Case-Generator-Report.pdf">The CDP Institute published</a> that <strong>among the top CPD use cases are customer value, retention, acquisition, and brand awareness</strong>.</p><p>Yet, CDP implementation is generally a complex task that demands focus, product education, considerable coordination, and engineering expertise — to say nothing of the fact that conventional CDPs are usually quite expensive.</p><p>What follows is a list of the typical challenges we’ve seen companies encounter in implementing conventional CDPs and embracing customer data strategies. It’s because of these challenges that we founded <a href="https://fueled.io/"><strong><em>Fueled</em></strong></a><strong><em>, the world’s first customer data platform designed specifically for eCommerce marketing teams.</em></strong></p><h3>Data tracking plans</h3><p>Before moving forward in implementing a CDP, companies need to develop a <strong>data tracking plan</strong>, which defines the customer engagement “events” that their team seeks to track.</p><p>The data tracking plan determines what data is going to be tracked and why. While it might look like a formality, getting this document right is mandatory. <em>A data analysis strategy cemented in a fragile data tracking plan is meant to fail</em>.</p><p>Of course, designing a data tracking plan can be tough, particularly if you’ve never done it before. It requires marketers and product leaders on your team thinking through the types of events you want to track, how you’ll measure engagement, and how you might operationalize your data for marketing automations and personalization. And then, it requires engineering input to determine how the data will be structured, how it will be pulled from various <em>source</em> applications, how it will be pushed into corresponding <em>destination</em> applications, and so forth.</p><p>We’ve seen eCommerce brands really struggle with this process — which is why Fueled ships with a flexible, <em>but opinionated</em> data tracking plan and event definitions built-in.</p><h3>Lack of integrations</h3><p>For many use cases, particularly eCommerce use cases, conventional CDPs just don’t offer the right pre-built integrations. Where conventional, “enterprise” CDPs win for engineering teams is that they usually offer strong SDKs and other development tools that allow for rapid, complete customization.</p><p>But for marketing and product teams that rely heavily on software-as-a-service tools, these SDKs aren’t applicable. What those teams need are out-of-the-box integrations that are plug-and-play.</p><p>Especially in the eCommerce space, prominent SaaS products haven’t yet built out integrations with the majority of CDPs. That’s where Fueled comes in: We’ve targeted our integration work around the eCommerce sales, marketing and support platforms that the majority of Shopify and BigCommerce merchants use.</p><p>Rather than struggle with custom integrations that are expensive to develop, our customers benefit from a deeper catalog of plug-and-play integrations that we’ve written to meet their specific needs.</p><h3>Opinionated integrations</h3><p>Even when a CDP does have integrations with other software, it’s tricky to know how to connect the CDP with the integrated application data. More importantly, doing so is different for each integration. The lack of documentation on this process will challenge the stream of information between platforms.</p><p>Similarly, the nuances of how destinations want to receive data are not forthright. How the CDP sends data to destinations varies for each case. For example, you might have good reasons to prefer implementing client-side tracking over server-side.</p><h3>Pricing</h3><p>Aside from free yet limited versions like Segment’s, conventional CDPs are often quite expensive. However, <strong>because they were built to meet engineering needs, they are difficult to set up, particularly for eCommerce</strong> Due to their complexity, they generally require the support of consultants and take a lot of time to implement, resulting in additional expenses and budget constraints.</p><h3>Accomplish CDP integration with Fueled</h3><p><a href="https://fueled.io/">Fueled</a> is a CDP for e-commerces ready to use their customers’ data to grow their business. To deal with these issues, Fueled offers:</p><ul><li><strong>Multiple options for integration</strong>. Use Fueled with your favorite sales and marketing tools: Track customer engagement on Shopify, or share data with Google Analytics or Facebook Ads.</li><li><strong>An expanding documentation</strong>. We understand documentation is at the core of building great products. You can consult Fueled documentation <a href="https://learn.fueled.io/">here</a>.</li><li><strong>Fully supported destinations</strong>. <a href="https://fueled.io/integrations">Check out in documentation the list of destinations — and sources — supported</a>. More integrations coming soon.</li><li><strong>Fair pricing options</strong>. We offer two options, Advanced and Plus, as well as an additional storage plan. See which is more fit for your business <a href="https://fueled.io/pricing">here</a>.</li><li><strong>Straightforward setup</strong>. Unlike other customer data platform companies, Fueled requires no custom code to run. Plus, our launch time process takes just 10 business days.</li></ul><p>Fueled was designed to address all of this friction for eCommerce merchants and marketing teams. Fueled cuts time, cost, and confusion in launching CDPs and world-class data strategies.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=49a881e11d3e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Third-Party vs. First-Party vs. Zero-Party Data Explained]]></title>
            <link>https://medium.com/fueled-io/third-party-vs-first-party-vs-zero-party-data-explained-cbcb7676499d?source=rss-a49242fd320e------2</link>
            <guid isPermaLink="false">https://medium.com/p/cbcb7676499d</guid>
            <category><![CDATA[first-party-data]]></category>
            <category><![CDATA[third-party-data]]></category>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[customer-data-platform]]></category>
            <category><![CDATA[zero-party-data]]></category>
            <dc:creator><![CDATA[Fueled]]></dc:creator>
            <pubDate>Wed, 21 Sep 2022 02:07:00 GMT</pubDate>
            <atom:updated>2022-09-21T02:07:00.166Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Funny gif describing a zero-party “party.”" src="https://cdn-images-1.medium.com/max/260/0*EF-sPqI5sFn9OdiL" /><figcaption>Source: <a href="https://imgflip.com/gif/6rhuw0">https://imgflip.com/gif/6rhuw0</a></figcaption></figure><p>You’ve probably heard that Apple, and soon <a href="https://www.wsj.com/articles/google-delays-cookie-removal-to-late-2023-11624542064">Google</a>, are cracking down on 3rd-party cookies and cross-website tracking scripts. But do you understand the differences between 3rd-party, 1st-party, and zero-party data?</p><p>For the last two decades, marketers have primarily leveraged third-party data to understand customer preferences and target paid advertising campaigns. However, this is about to change — with increased emphasis on 1st-party and zero-party data collection and targeting.</p><p>In this article, we will clarify the differences between each of these three types of customer data. We will describe how brands can leverage first-party and zero-party data, and we will touch upon how customer data platforms (or CDPs) can be used to make working with first-party and zero-party data easier.</p><h3>What is Third-Party Data?</h3><p>Third-party data is information obtained from sources other than the original data collectors. They’re bought from major data collectors that extract it from various platforms and websites where it was generated. Collectors then combine it into a single enormous data collection and offer it as third-party data.</p><p>For instance, Facebook Pixel can collect data from customers on your website directly as opposed to first-party pixel data that a company can setup on their website to collect data and then share with Facebook with consent.</p><p>Before the Internet, third-party data was scarce. A few organizations provided customer lists, and marketers mainly used them in telephone and mailing campaigns with limited value and attribution capacity.</p><p>Today, there is an explosion of data generated from everything connected to the internet. Businesses collect most third-party data via smartphones because people always have their phones with them; they are a valuable source of location data that would otherwise be difficult, if not impossible, to collect.</p><h3>What is first-party data?</h3><p>First-party data refers to consumer information acquired and controlled by a company. Customers’ information is compiled using software and systems that the company owns. They may use this information (digital transactions, purchase history, customer behavior, preferences, etc.) to design ads, content, and experiences that appeal to an individual’s interests.</p><p>For instance, a company may leverage first-party data such as online or mobile app activity, in-store or contact center interactions, purchase history, and customer loyalty status to generate a tailored advertisement for a particular consumer.</p><p>Then again, collecting and managing first-party data is quite simple, mainly if you utilize an audience management platform. Moreover, privacy issues about first-party data are minor since you know precisely where it comes from and owns it outright as a marketer.</p><p>Any business that does not gather first-party data leaves money on the table. Taking ownership of first-party data should be a top goal for any business that wants to monetize, learn from, and utilize the asset to grow lucrative audiences, deepen consumer engagement, and increase marketing ROI.</p><p>Also, brands that collect first-party data can use it for targeting on platforms like Google Ads and Facebook Ads, that generally rely on 3rd-party data. All they need is a tool for segmentation and pipe audiences to those platforms for ad targeting.</p><h3>What is zero-party data?</h3><p>Zero-party data enable businesses to develop close bonds with customers, which improves the personalization of their marketing initiatives, services, offers, and product suggestions.</p><p>Zero-party data, a term coined by <a href="https://www.forrester.com/report/An-Illustrated-Guide-To-Collecting-ZeroParty-Data/RES161015">Forrester Research</a> in 2018, is the most direct data explicitly generated by the consumer.</p><p>They described it as information that a <a href="https://www.forrester.com/blogs/straight-from-the-source-collecting-zero-party-data-from-customers/">consumer voluntarily and proactively provides with a brand.</a> This information may include purchase intents, preference center data, personal context, and how the person wants to be recognized, newsletter signups, product reviews, and, importantly, survey data.</p><p>Marketers may leverage zero-party and first-party data to assist companies in developing effective marketing campaigns without using third-party cookies.</p><p>Organizations may get this information from various places, including Internet forms, surveys, polls, and membership applications. Even though some clients may voluntarily supply zero-party data for free, most businesses regard it as money and provide a reward in exchange, such as an e-book, webinar, or discount coupon.</p><p>Marketers may utilize the data businesses gather via polls, surveys, and form submissions to customize product suggestions, messaging, and offers for each consumer.</p><p>In this approach, the use of zero-party data by marketers adopts a conversational style that strengthens relationships between businesses and their clients. Zero-party data is not just for big businesses. Businesses of all sizes can collect reliable, precise, and exciting data by employing interactive funnels at every stage of the customer experience.</p><figure><img alt="Image describing data types, provided by Forrester Research." src="https://cdn-images-1.medium.com/max/910/0*Skru6ayHc2cftIZs" /></figure><h3>Why 3rd-party data is essentially going away</h3><p>Everyone who uses the internet will experience a significant shift in how they create and share data. Regulations aimed at protecting consumer privacy, such as the <a href="https://en.wikipedia.org/wiki/California_Consumer_Privacy_Act">California Consumer Privacy Act </a>in America, <a href="https://www.investopedia.com/investing/all-you-need-know-about-gdpr-new-data-law/">General Data Protection Regulation (GDPR)</a> in Europe, and other tech giants, would demand users’ consent to share and utilize data obtained from online transactions.</p><p>Internet users have been demanding greater transparency in the use of data by organizations that collect it. Since consumers are typically uninformed of how their data is used, the digital advertising industry is poised to shift away from third-party data.</p><p>Cookies, particularly third-party cookies, drive many internet ads, but with the onset of explicit privacy policies empowering users, third-party data will significantly reduce in value. Web browsers such as Mozilla Firefox and Apple Safari already restrict them, and according to Google, Chrome will follow suit in 2023.</p><p>Everything we do in this connected world creates data. As a result, when collecting third-party data, there are severe issues regarding individual privacy. Recent privacy legislation, such as Europe’s GDPR and California’s CCPA, as well as high-profile court cases, have many asking whether it’s safe to continue using third-party data in marketing campaigns.</p><p>To begin, it is critical to recognize that compliant data partners give data with consumer permission, which means that the customer has opted-in to share their data. Second, it is critical to collaborate with a data partner that adheres to tight data governance in terms of who they associate with and follows an ethical code while obtaining and sharing consumer data.</p><h3>Why eCommerce brands should focus on 1st-party and zero-party data strategies</h3><p>As consumers, we do not often receive the opportunity to feel understood, unique, and cared for in the enormous international markets that exist in the modern day.</p><p>When done correctly, zero-party and first-party marketing allow marketers to make your consumers feel appreciated while gathering the knowledge essential to building your company and enhancing your customers’ overall experiences. Many eCommerce enterprises have already implemented it into their businesses and are beginning to experience its advantages.</p><h3>Have higher quality data at your disposal</h3><p>If you ask your consumers well-thought-out questions to collect data directly from them, you will have the data you want rather than the data provided. Your company will access all the specific data you need to improve personal recommendations, plan future brand movements to fit your consumer base, and develop focused promotional efforts that maintain a sense of personalization while reaching the biggest possible audience.</p><h3>Create individualized marketing campaigns</h3><p>You will be able to create marketing strategies tailored to your consumer base after you have this information since you will have superior demographic data that is particular to your company and its items.</p><p>You will no longer have to make assumptions based on previous purchase history and habits if you fully grasp what your consumers appreciate and what they need and want from your company.</p><p>After you have collected sufficient data, you will be able to design a variety of marketing automation campaigns tailored to various demographics. For instance, if you run a bookstore and survey your customers to find out which types of fiction they prefer, you can target marketing campaigns about new audiobook thrillers to people interested in that medium and type of fiction than sending it to everyone.</p><p>When you start those personalized marketing efforts, you get individuals enthusiastic and interested to read your emails rather than going over what they perceive as general advice that anybody can use. This prevents them from ignoring your messages altogether.</p><p>Accurate management of inventories and projections of demand and supply</p><p>You can construct more powerful client profiles using preference datasets, which will let you know what kinds of things customers are searching for and enable you to serve them better.</p><p>This trust will build if you employ targeted campaigns to assist novice clients in developing a better understanding of how to use your goods, hence establishing engaging shopping experiences that lead to strong customer loyalty.</p><h3>How to collect zero-party data</h3><p>When done correctly, gathering zero-party data may be relatively simple; quizzes and conversational pop-ups in your registration process and marketing efforts are a few crucial approaches.</p><p>Zero-party data collection might be an additional step in the subscription or membership onboarding process. Asking for basic details like name, phone number, email address, and demographics like age and gender is essential. Still, you should include inquiries that might help you learn more about how a consumer feels about your goods.</p><p>For instance, if you are selling fitness items, you may inquire about their degree of expertise, how often they work out, and any potential health conditions impacting how they utilize the products. Enrolling consumers in loyalty programs is a fantastic approach to getting zero-party data.</p><p>You may learn much more about your customer’s interests, preferences, and the goods to display on your owned channels by paying them with loyalty points for reviews, participating in preference centers, and participating in surveys and polls.</p><p><strong>Collecting zero-party information on your website</strong></p><p>To provide a consumer with a list of suggestions based on their requirements and interests, display a pop-up to them once they arrive on your website. Alternatively, you may pose a query that directs the consumer to a particular email flow. It is a more organic method of gathering zero-party data, and it will make a consumer feel more at ease before they may provide their email and subscribe (or make a purchase).</p><p><strong>Utilizing social media to get zero-party data</strong></p><p>Social networking is a fantastic tool for connecting with and soliciting many individuals, including new prospective clients. <a href="https://neilpatel.com/blog/social-media-ecommerce/">Generating and publishing polls </a>may get important information on trends, community demographics, and brand and product directions.</p><p><strong>Collecting zero-party information from email campaigns</strong></p><p>The process may be more attractive by including introductory quizzes in your welcome email flow. This will encourage clients to read your emails since they provide valuable information. Additionally, periodically poll your clients to find out their opinions of your company and its offerings.</p><p>Run a survey or poll asking your existing members for their opinions if you want to test a new product or brand direction. Zero-party data is more about having a dialogue with consumers than speaking “at” them since customers prefer to be heard.</p><h3>Applications of zero-party data</h3><p>Online tests to speed up and customize product research. According to studies, individuals often appreciate sharing personal information with companies they trust. By asking the appropriate questions, you may design unique interactions with new clients that come off as friendly and engaging.</p><p>Customers feel valued and heard when you provide a more condensed selection of products that match their unique preferences or address their unique demands. It demonstrates your sincere interest in their purchasing experience when you can update them about new items and marketing that cater to their preferences.</p><h3>Campaigns for personalized emails and SMS</h3><p>Creating customized email and SMS campaigns is one excellent approach to leveraging zero-party data to make customers feel mainly catered to. You may design email flows tailored to various client groups using information from the introduction quizzes and further surveys.</p><p>Companies may also tailor communications with a particular promotion to the client’s preferences. Therefore, you might send emails to folks showcasing this as a chance to visit hiking trails in California if you provide a reasonable price for treks there. Additionally, you are receiving emails telling other hikers to visit California’s warm beaches simultaneously.</p><h3>Sharing Individualized content (blogs, ebooks, other information of interest)</h3><p>Beyond only individualized product suggestions, you may customize the customer’s website experience with zero-party data.</p><h3>How brands can then leverage zero-party data for personalization and marketing automation</h3><p>Marketers have a chance to enhance the customer experience by utilizing their zero-party and first-party data in this day and age when consumer trust is declining, and restrictions on the collecting of data are becoming more stringent. Attribution tools such as Fueled, and Heap Analytics can be used to collect 1st-party data</p><p>Marketers can implement first-party attribution tools and then send that data to GA for studying customer behavior. If a company employs Google Analytics, the Nine-tailed Platform can analyze user activity and offer content based on browsing intent signals. This allows the platform to enhance the customer experience via customization based on behavior data.</p><p>Additionally, personalization may be achieved using first-party data from sources other than the website. Using first-party data from other applications, such as mobile banking or call center logs, businesses that provide customer-centric products and services could use their customer data platform (CDP) to personalize the user experience.</p><p>On the other hand, zero-party data may be considered “personalization on steroids,” since it can use first-party data and tailor marketing efforts depending on consumer preferences. This makes zero-party data comparable to “personalization on steroids.” The fact that the user is the source of their personal information, which is likely to be more accurate than information obtained from other sources, is the primary reason zero-party data is so successful.</p><p>Also, suppose you are not employed in the field of data science. In that case, you may be unaware of the significant part data from third parties plays in feeding <a href="https://www.forbes.com/sites/theyec/2022/03/14/zero-party-data-is-the-new-oil/?sh=14eaaa027e98">artificial intelligence</a> (AI). When training machine learning algorithms, data sets of greater significance both in breadth and depth are preferable.</p><p>Regardless of the level of sophistication of your algorithm, AI predictions will be more accurate if they are based on greater breadth and depth of data. If the original data collection does not have the breadth, depth, or features to meet the end objective, then enriching it with data from third parties is the key to attaining superior AI outputs. This is because first-party data seldom possesses these characteristics.</p><p>Suppose you want to extend your machine learning projects. In that case, you can jump-start your exploratory data analysis (EDA) and make feature engineering more efficient and effective by using pre-packaged, predictive features and characteristics acquired from third-party data vendors.</p><h3>Looking forward</h3><p><a href="https://fueled.io/">Fueled</a> allows eCommerce brands to collect, unify, and operationalize first-party and zero-party data. Give us a shout to learn more, or visit our <a href="https://fueled.io/">website</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cbcb7676499d" width="1" height="1" alt=""><hr><p><a href="https://medium.com/fueled-io/third-party-vs-first-party-vs-zero-party-data-explained-cbcb7676499d">Third-Party vs. First-Party vs. Zero-Party Data Explained</a> was originally published in <a href="https://medium.com/fueled-io">Fueled, Inc.</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[“SQL Traits” — Segment Personas’ Superpower]]></title>
            <link>https://medium.com/weareinclined/sql-traits-segment-personas-superpower-582367b3d20f?source=rss-a49242fd320e------2</link>
            <guid isPermaLink="false">https://medium.com/p/582367b3d20f</guid>
            <category><![CDATA[marketing-automation]]></category>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[customer-data-platform]]></category>
            <category><![CDATA[segment]]></category>
            <category><![CDATA[ecommerce-analytics]]></category>
            <dc:creator><![CDATA[Fueled]]></dc:creator>
            <pubDate>Mon, 15 Nov 2021 14:02:39 GMT</pubDate>
            <atom:updated>2022-08-26T21:03:17.299Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong><em>SQL Traits</em> — Segment Personas’ Superpower</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*7-CfOM8u_vlwqHTr-HlXaw.png" /><figcaption>Image source: <a href="https://segment.com/docs/personas/">https://segment.com/docs/personas/</a></figcaption></figure><p><strong>Customer Data Platforms</strong> (CDPs) have generated significant interest over the last few years. They’ve become the heartbeat powering modern growth and marketing teams across all industries, including the SaaS, eCommerce and mobile application markets.</p><p>In the simplest of terms, CDPs aggregate constituent behavioral event data from various sources of engagement (websites, apps, marketing automation platforms, points of sale, etc.). They then identify, validate, and transform that data, so that it can be pushed into other constituent engagement tools.</p><p>Some people think of CDPs are <em>glue</em>, as they pull together event-based data across of a companies digital engagement points.</p><blockquote>Customer Data Platforms power modern digital engagement: marketing automation, customer segmentation, personalization, machine learning, and product analytics.</blockquote><h3>When to Use Segment Personas?</h3><p><a href="https://segment.com/docs/personas/">Segment Personas</a> is a leading enterprise-grade CDP. Though, it’s certainly not the only game in town. And there are some instances in which we recommend its competitors, such as <a href="https://www.mparticle.com/">mParticle</a> or <a href="https://amplitude.com/data-management">Amplitude’s Data Management</a> platform. Ultimately, the decision between CDPs comes down to your business’ specific requirements and <em>— perhaps most importantly —</em> the other technologies already in play at your company.</p><p>In broad terms, we tend to recommend Segment Personas when:</p><ul><li>A company has a large set of application data sources and destinations, or requires complex server-side integrations;</li><li>A company has complex identity resolution needs across platforms;</li><li>A company might need to <em>play back</em> historical events when onboarding new event destinations;</li><li>A company seeks to establish and enforce a highly-structured data tracking plan; and/or</li><li>A company needs their CDP to integrate with KPIs and customer attributes that are calculated based upon data stored in a data warehouse.</li></ul><h3>Enter SQL Traits</h3><p>From our perspective, this last point above represents Segment Personas’ hidden superpower:</p><blockquote>With Segment Personas, you are not limited to customer rollup attributes that are calculated as events flow through your CDP. You can calculate customer attributes based upon SQL queries of data stored in 3rd-party application databases and/or your data warehouse.</blockquote><p>Here are two examples:</p><h4>Calculating Customer AOV</h4><p>Let’s say you’re an eCommerce brand that’s been around long enough to have re-platformed your storefront a few times. Let’s say you started out on Magento, then you experimented with Shopify for a few years, and you finally landed on BigCommerce.</p><p>In this scenario, it’s likely that you haven’t migrated <em>all</em> of your eCommerce customer and order history between each of these platforms — but you probably (hopefully) saved your historical data, dropping it into a database or warehouse.</p><p>With SQL Traits in Segment Personas, you can quickly implement an SQL query to surface each customer’s Average Order Value, Total Order Count, and so forth <em>across all of these data sources</em> with just a few lines of code.</p><p>Stepping back, this is helpful any time you <em>turn on </em>Segment after launching even a single storefront: Instead of having to try to run all of your historical orders through Segment to calculate AOV and total order count in real time: You can leverage SQL Traits for this.</p><blockquote>Leveraging SQL Traits in a scenario like this can save a company significant time and money compared to running historical orders through their CDP, the way they would have to do with mParticle and/or Amplitude.</blockquote><h4>Surfacing the Date of a Customer’s Last Stripe Transaction</h4><p>There are a number of data sources in Segment that expose <em>Object-based data</em> rather than <em>Event-based data</em>. In other words, these <a href="https://segment.com/docs/connections/sources/#object-cloud-sources">Object Cloud Sources</a> essentially replicate tabular data into Segment, rather than expose a real-time flow of events into Segment. Examples include Segment’s <a href="https://segment.com/docs/connections/sources/catalog/cloud-apps/stripe/">Stripe</a> and <a href="https://segment.com/docs/connections/sources/catalog/cloud-apps/salesforce/">Salesforce</a> integrations.</p><p>Leveraging SQL Traits, you can quickly calculate customer attributes in Personas from these data sources. For example, you might use an SQL Trait to query Stripe for a customer’s last transaction or a recurring billing event that doesn’t hit your primary application code.</p><p>Below is a screenshot of how SQL Traits are configured in Segment Personas. First, you connect your source database to Personas, and then you write a simple SQL query to pull the data for a specific customer, when identifying them by email address or customer ID. It’s that easy!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Tooj4qeXdle6_mXySk6mpg.png" /><figcaption>Image Source: <a href="https://segment.com/docs/personas/sql-traits/">https://segment.com/docs/personas/sql-traits/</a></figcaption></figure><h3>Getting Started with SQL Traits &amp; Segment Personas</h3><p>If you have questions about how to leverage SQL Traits in Segment Personas, first take a look at <a href="https://segment.com/docs/personas/sql-traits/">Segment’s documentation</a>. Then, feel free to give us a call and we can either point you in the right direction, or get you in touch with a solutions rep at Segment!</p><p><a href="https://fueled.io/">Fueled</a> connects eCommerce data with Segment and other leading CDPs.</p><p>We reduce friction, cost, and time to launch world-class data strategies for eCommerce brands that are ready for growth. With Fueled, you can unlock product insights and build personalized customer journeys that delight new and existing customers.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=582367b3d20f" width="1" height="1" alt=""><hr><p><a href="https://medium.com/weareinclined/sql-traits-segment-personas-superpower-582367b3d20f">“SQL Traits” — Segment Personas’ Superpower</a> was originally published in <a href="https://medium.com/weareinclined">Inclined, LLC</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>