Overview
In this episode of the Ecommerce Coffee Break Podcast, host Claus Lauter interviews Feifan Wang about the five biggest data challenges plaguing growing e-commerce brands. Feifan draws from his background at Google and as VP of Product & Analytics at Resident Home (which scaled from $7M to $100M+ in one year) to explain why data isn’t just about reporting—it’s about survival at scale.
They discuss the evolution of data needs as a business matures: early-stage brands can survive on directional insights from Google Analytics, but as complexity grows (multiple sales channels, international markets, high ad spend), the margin for error shrinks. Feifan breaks down SourceMedium’s approach to data quality, emphasizing that true accuracy requires handling the messy reality of e-commerce—like refunds, exchanges, and cross-border tax implications—that standard tools often miss.
Key Takeaways
- Data Maturity Curve: Data needs evolve with your business stage. What works at $5M (GA4 + spreadsheets) becomes a liability at $50M when 20% error margins translate to millions in lost efficiency.
- The “Horizontal” Trap: Tools like Supermetrics or Fivetran move raw data from A to B but leave you with the heavy lifting of transformation and normalization. SourceMedium provides a vertical-specific infrastructure that understands commerce logic out of the box.
- Data Quality is Multi-Dimensional: It’s not just accuracy; it’s breadth (integration coverage) and depth (richness of data). Reliable net sales figures must account for discounts, refunds, and exchange loops that platform dashboards often ignore.
- The Human Element: Even the best tech fails without data culture. Feifan emphasizes the importance of standardized taxonomies and consistent naming conventions to move organizations from “land of opinions” to “land of facts.”
- Proactive Onboarding: SourceMedium’s onboarding isn’t just technical setup; it’s a data hygiene audit that catches issues like inconsistent UTMs or untracked landing pages before they corrupt your insights.
- Build vs. Buy: Feifan advises brands to carefully consider the hidden costs of building internal data stacks—maintenance, scaling challenges, and the need for specialized engineering talent—versus buying a purpose-built solution.
Transcript
[00:00] hello and welcome to another episode of the eCommerce coffee break podcast today the eCommerce coffee break podcast today we want to focus back on the topic of we want to focus back on the topic of data no data for a lot of merchants is data no data for a lot of merchants is part of their daily business and it’s
[00:09] part of their daily business and it’s all over the place but we want to find all over the place but we want to find out five data challenges that plaguing out five data challenges that plaguing e-commerce businesses the most and how e-commerce businesses the most and how you can overcome them with me on the you can overcome them with me on the show I have hey one he is the CEO of
[00:20] show I have hey one he is the CEO of SourceMedium and he’s a seasoned SourceMedium and he’s a seasoned entrepreneur with a rich background and entrepreneur with a rich background and sales software engineering and product sales software engineering and product analyzers he was born in China analyzers he was born in China immigrated to the asset 14 and his early
[00:31] immigrated to the asset 14 and his early experience of cultural adoption Blade experience of cultural adoption Blade the groundwork for his entrepreneurial the groundwork for his entrepreneurial Spirit he worked for Google followed by Spirit he worked for Google followed by a vpay or VP of product and analytics a vpay or VP of product and analytics role at residence home then he navigated
[00:42] role at residence home then he navigated the company’s rapid scale up on complex the company’s rapid scale up on complex data challenges gaining unique insights data challenges gaining unique insights into the struggles that Brands face with into the struggles that Brands face with data management and these experience data management and these experience finally inspired him the creation of
[00:52] finally inspired him the creation of SourceMedium a leader in e-commerce SourceMedium a leader in e-commerce data software so let’s dive into the data software so let’s dive into the world of data and welcome Fey to the world of data and welcome Fey to the show hey how are you today thank you I’m show hey how are you today thank you I’m good I’m good how are you class I’m very
[01:03] good I’m good how are you class I’m very well data part of every business data part of every business very complex specifically if you very complex specifically if you grow your business might be easier if grow your business might be easier if you’re a smaller Merchant a smaller you’re a smaller Merchant a smaller Enterprise but once Things become bigger
[01:17] Enterprise but once Things become bigger and bigger things become much more and bigger things become much more complicated you help with that give me a complicated you help with that give me a bit of an idea why data can be such a bit of an idea why data can be such a burden it can be so complex
[01:27] burden it can be so complex totally and also thank you totally and also thank you for that great introduction earlier for that great introduction earlier you know I think data challenges I you know I think data challenges I think the most important thing to think the most important thing to understand is that it evolves based on
[01:38] understand is that it evolves based on what stage of business that you’re in what stage of business that you’re in you know if you’re in the stage where you know if you’re in the stage where it’s really still kind of looking for it’s really still kind of looking for product Market fit making sure that the product Market fit making sure that the product is actually liked and enjoyed by
[01:50] product is actually liked and enjoyed by a large enough audience and things like a large enough audience and things like that the challenge there really is that the challenge there really is around just having something right GA is around just having something right GA is usually sufficient you just need usually sufficient you just need directional insights to know if you’re doing
[02:02] insights to know if you’re doing something good or not right but once you something good or not right but once you get to the stage where a lot of these get to the stage where a lot of these things are figured out at least you know things are figured out at least you know 80 percent of them are figured out and
[02:11] 80 percent of them are figured out and you’re now really kind of thinking about you’re now really kind of thinking about the medium to long term in terms of the medium to long term in terms of scaling right whether that’s scaling or scaling right whether that’s scaling or top line or optimizing for profitability top line or optimizing for profitability then the data that you’re working with
[02:24] then the data that you’re working with becomes a lot more important you becomes a lot more important you know and I think analogy that I like to know and I think analogy that I like to give here is right if you’re driving at give here is right if you’re driving at 20 miles an hour your number’s off 20
[02:34] 20 miles an hour your number’s off 20 either direction isn’t going to be that either direction isn’t going to be that big of a deal if even noticeable at all big of a deal if even noticeable at all right but if you’re driving down the right but if you’re driving down the highway that becomes almost life and death
[02:45] that becomes almost life and death sometimes right so that’s kind of you sometimes right so that’s kind of you know how I would think about it know how I would think about it now with the growing business as I said now with the growing business as I said you get great data from all kinds of
[02:56] you get great data from all kinds of sources well some data is hosted in your sources well some data is hosted in your own system some data is hosted on own system some data is hosted on external systems and it becomes really external systems and it becomes really difficult to find out really difficult to find out how to compare and how to read out
[03:06] how to compare and how to read out the data now at SourceMedium you do the data now at SourceMedium you do it slightly different tell me a little it slightly different tell me a little bit on what your approach is bit on what your approach is yeah so we’re we’re ultimately a data
[03:17] yeah so we’re we’re ultimately a data company that is about the data and not company that is about the data and not as much about the user experience right as much about the user experience right so I think most solutions that you see so I think most solutions that you see out there will have you know a lot of
[03:28] out there will have you know a lot of focus in terms of their marketing on the focus in terms of their marketing on the visualizations that they have or visualizations that they have or integration coverage or you know things integration coverage or you know things that are perhaps more ux oriented in that are perhaps more ux oriented in terms of use ease of use but what we
[03:43] terms of use ease of use but what we really focus on is to be the really focus on is to be the provider of the highest quality data in provider of the highest quality data in the Commerce industry right so in terms the Commerce industry right so in terms of how we think about data quality
[03:54] of how we think about data quality there’s a few things one is around there’s a few things one is around accuracy right is there out of the box accuracy right is there out of the box accuracy in the sense that do your accuracy in the sense that do your numbers match with the whip with the numbers match with the whip with the platforms actually report on and but
[04:06] platforms actually report on and but nine out of ten times once you have some nine out of ten times once you have some complexity in the business the numbers complexity in the business the numbers on the platforms are actually on the platforms are actually also incorrect for various also incorrect for various reasons so does the data provider have
[04:19] reasons so does the data provider have those nuances built into the product those nuances built into the product right so that’s the accuracy piece and right so that’s the accuracy piece and then the next piece is around breadth of then the next piece is around breadth of the data right so that’s just the data right so that’s just essentially the integration coverage
[04:31] essentially the integration coverage that it has right does it kind of that it has right does it kind of sufficiently cover all of the different sufficiently cover all of the different various platforms that you’re going to various platforms that you’re going to be using as you scale the business and be using as you scale the business and then lastly the depth of that data right
[04:43] then lastly the depth of that data right how rich is the data that’s actually how rich is the data that’s actually coming out right because the richness of coming out right because the richness of the richness of that data is very the richness of that data is very important in terms of how actionable important in terms of how actionable that actually becomes as well so that’s
[04:57] that actually becomes as well so that’s kind of like the main thing that we kind of like the main thing that we focus on and then kind of go and then focus on and then kind of go and then the then the operators that we cater to the then the operators that we cater to are folks that are a little bit more
[05:08] are folks that are a little bit more sophisticated in terms of what they’re sophisticated in terms of what they’re looking for in the quality of the data looking for in the quality of the data and the type of decisions that they make and the type of decisions that they make that they that they think has to be
[05:19] that they that they think has to be supported by analytical insights and supported by analytical insights and then we have a couple different types of then we have a couple different types of consumption methods you know we have consumption methods you know we have brands that are consuming our data brands that are consuming our data directly in our hosted visualizations or
[05:32] directly in our hosted visualizations or we have more sophisticated Enterprise we have more sophisticated Enterprise customers that are consuming our data customers that are consuming our data directly within their data warehouse directly within their data warehouse let’s dive a little bit deeper into let’s dive a little bit deeper into quality of the data because I think quality of the data because I think that’s a bit of a gray area for a lot of
[05:46] that’s a bit of a gray area for a lot of merchants out there because they assume merchants out there because they assume that whatever data comes in should be that whatever data comes in should be right but probably it’s not so what are right but probably it’s not so what are the quality of data actually stands for
[05:56] the quality of data actually stands for yeah so it again that really is a yeah so it again that really is a little bit different depending on the little bit different depending on the phase of the business that you’re in and phase of the business that you’re in and what metrics your what kpis you’re what metrics your what kpis you’re orienting around you know so besides
[06:13] orienting around you know so besides kind of the high level understanding of kind of the high level understanding of accuracy breadth and depth right there accuracy breadth and depth right there is also for example just to out of the is also for example just to out of the box being able to have reliable net box being able to have reliable net sales based kpis right let’s say if you
[06:28] sales based kpis right let’s say if you base your CAC on that sales or your base your CAC on that sales or your LTV on that sales LTV on that sales that has a lot of implications there for that has a lot of implications there for example you have to have the correct example you have to have the correct gross calculation and correct
[06:42] gross calculation and correct discounts and refunds calculation and discounts and refunds calculation and that also differs across borders right that also differs across borders right so the Shopify data that comes out of so the Shopify data that comes out of Europe for example has certain Europe for example has certain implications that’s different from the implications that’s different from the states
[06:55] states and then you know if and then you kind and then you know if and then you kind of as the brands grow and they get to a of as the brands grow and they get to a point where they want to for example point where they want to for example optimize around profits optimize around profits then that can open a whole can of worm
[07:08] then that can open a whole can of worm right because the expenses data and the right because the expenses data and the cost data are very fragmented and cost data are very fragmented and there’s a lot of different opinions as there’s a lot of different opinions as far as how certain things should be far as how certain things should be calculated right where are you pulling
[07:21] calculated right where are you pulling those numbers so you know accuracy the those numbers so you know accuracy the way that I think about it is you can way that I think about it is you can never have 100 never have 100 accuracy it’s it’s almost physically accuracy it’s it’s almost physically impossible because of just the
[07:35] impossible because of just the levels of layers and complexities that levels of layers and complexities that exist but also you also get to a point exist but also you also get to a point where you enter into the world of where you enter into the world of opinions right so that’s where a data opinions right so that’s where a data culture becomes very important having a
[07:47] culture becomes very important having a standardized taxonomy within the standardized taxonomy within the organization having a source of truth organization having a source of truth that everybody in the company is that everybody in the company is orienting towards is extremely important orienting towards is extremely important you know so for example right you know so for example right you could calculate your row ass based on
[08:02] could calculate your row ass based on your gross sales or your net sales your gross sales or your net sales well which one do you do right the well which one do you do right the marketer may prefer to look at it based marketer may prefer to look at it based on growth and the finance person may
[08:11] on growth and the finance person may prefer to look at it based on that and prefer to look at it based on that and the CEO may prefer to look at both but the CEO may prefer to look at both but really they’re tracking one of those really they’re tracking one of those right so you do also end up getting to
[08:21] right so you do also end up getting to that where it’s just about the human that where it’s just about the human beings and the governance that’s kind of beings and the governance that’s kind of coming with that as well coming with that as well a very good point that you mentioned a very good point that you mentioned there have been sitting in a lot of
[08:30] there have been sitting in a lot of shareholder meetings looking at the same shareholder meetings looking at the same data and everyone was basically reading data and everyone was basically reading something different out of it now something different out of it now obviously you use the data to make your obviously you use the data to make your decisions based on that and I think
[08:39] decisions based on that and I think visualization is a point there and visualization is a point there and that’s something you do in your help was that’s something you do in your help was so how do you visualize all this data so how do you visualize all this data for the different players in the game for the different players in the game great question yeah so our visualization
[08:52] great question yeah so our visualization design Philosophy from the get-go has design Philosophy from the get-go has always been orienting towards the more always been orienting towards the more sophisticated operators right so our you sophisticated operators right so our you know when you kind of look at our hosted know when you kind of look at our hosted visualization templates it’s it can be
[09:09] visualization templates it’s it can be overwhelming for some right so we’ve overwhelming for some right so we’ve seen other Solutions where for example seen other Solutions where for example it’s really about the simplification of it’s really about the simplification of that right go into scoreboard it’s very that right go into scoreboard it’s very simple graphs and lines and stuff like
[09:21] simple graphs and lines and stuff like that but you know our product where you that but you know our product where you open it look almost looks like a open it look almost looks like a Bloomberg terminal to some so it takes a Bloomberg terminal to some so it takes a lot of intentional learning lot of intentional learning and onboarding with us to really
[09:35] and onboarding with us to really kind of understand how to look at it kind of understand how to look at it right but of course that granularity and right but of course that granularity and richness of data richness of data can only be leveraged if the human being can only be leveraged if the human being on the other side is already sort of
[09:48] on the other side is already sort of committed to working that way right so committed to working that way right so ultimately you know we’re very sort of ultimately you know we’re very sort of clear about not everybody is the right clear about not everybody is the right fit for our solution and then I think fit for our solution and then I think for folks that are consuming our data
[10:01] for folks that are consuming our data directly to build their own directly to build their own visualizations you know we’re we’re visualizations you know we’re we’re more than happy to provide a ton of more than happy to provide a ton of advice there in terms of how can they advice there in terms of how can they connect the dots between our data and
[10:14] connect the dots between our data and the charge that they wish to build and the charge that they wish to build and of course anything that we’ve already of course anything that we’ve already created ourselves will be able to help created ourselves will be able to help them stand that up as well you know them stand that up as well you know within their own bi of choice
[10:28] a lot of companies or probably every company has a different data stack where company has a different data stack where they get or data sources where they get they get or data sources where they get the data from how do you integrate with the data from how do you integrate with all these different data sources and all these different data sources and give me a bit of an example on what sort
[10:42] give me a bit of an example on what sort of the starting point and best case of the starting point and best case examples great question yeah so we are a great question yeah so we are a vertically oriented data infrastructure vertically oriented data infrastructure solution so then the question might be solution so then the question might be what is a horizontal data infrastructure
[10:58] what is a horizontal data infrastructure solution right so I think the way you solution right so I think the way you can think about is like the super can think about is like the super metrics funnel five Tran of the world metrics funnel five Tran of the world right they’re there to serve basically a right they’re there to serve basically a lot of different Industries so they have
[11:12] lot of different Industries so they have a particular boundary where they won’t a particular boundary where they won’t go further right so with the solutions go further right so with the solutions that I mentioned they’re only kind of Mo that I mentioned they’re only kind of Mo is to move raw data from A to B right is to move raw data from A to B right but that doesn’t really that’s kind of
[11:26] but that doesn’t really that’s kind of where your problem begins right because where your problem begins right because there’s so many other things that kind there’s so many other things that kind of comes from that and but for us not of comes from that and but for us not only do we take care of data movement
[11:37] only do we take care of data movement and extraction from your data silos we and extraction from your data silos we also have our Advanced Data also have our Advanced Data transformation Technologies and in transformation Technologies and in terms of how we actually active that the terms of how we actually active that the reason that this works for Commerce
[11:51] the reason that this works for Commerce is because there has been sort of an is because there has been sort of an aggregation of customer base and user aggregation of customer base and user base into a you know a finite set of base into a you know a finite set of platforms right so if you think about
[12:03] platforms right so if you think about why this is this will be way harder for why this is this will be way harder for SAS is every SAS company have their own SAS is every SAS company have their own schema have their own database model schema have their own database model right that have their own intricate sort
[12:14] right that have their own intricate sort of ways of operating but you know most of ways of operating but you know most Merchants are on you know especially Merchants are on you know especially brands that have started in the last few brands that have started in the last few years is you know finite number of
[12:25] years is you know finite number of platforms right you have your platforms right you have your e-commerce transaction and customer data e-commerce transaction and customer data in platforms like Shopify Magento of in platforms like Shopify Magento of the world right you have your customer the world right you have your customer communication data and support data and
[12:39] communication data and support data and platforms like gorgeous zendesk clavio platforms like gorgeous zendesk clavio attentive right you have GA you have attentive right you have GA you have your marketing data from you know meta your marketing data from you know meta and Google and Tick Tock Etc right so and Google and Tick Tock Etc right so that actually makes it possible for us
[12:54] that actually makes it possible for us to really Orient towards a set of to really Orient towards a set of platforms that covers the 80 20 as platforms that covers the 80 20 as far as what the brands are using far as what the brands are using and then essentially creating a and then essentially creating a standardized taxonomy you know one of
[13:07] standardized taxonomy you know one of the things that’s really powerful with the things that’s really powerful with our offering is that it’s omnichannel by our offering is that it’s omnichannel by Design so what that means is if you just Design so what that means is if you just understand for example how net revenue understand for example how net revenue is calculated for Shopify you’ll be able
[13:18] is calculated for Shopify you’ll be able to understand that for any Amazon to understand that for any Amazon business for anybody on stripe on charge business for anybody on stripe on charge beat but really on any other e-commerce beat but really on any other e-commerce platform that we would integrate with platform that we would integrate with down the road right so that’s really
[13:30] down the road right so that’s really kind of what people love about our kind of what people love about our offering is that you just need to really offering is that you just need to really learn the taxonomy one time learn the taxonomy one time right and again that becomes right and again that becomes impossible with SAS because every SAS
[13:43] impossible with SAS because every SAS company’s offering is just could be so company’s offering is just could be so wildly different so wildly different yeah I can totally follow that yeah I can totally follow that thought of train of thought of train of thought obviously was a technical stag obviously was a technical stag Shopify clay view gorgeous whatever you
[13:59] Shopify clay view gorgeous whatever you made it a lot of merchants a lot of made it a lot of merchants a lot of listeners will find themselves in that listeners will find themselves in that kind of ecosphere and then it’s kind of ecosphere and then it’s relatively easy to do the next step now relatively easy to do the next step now what’s the kind of
[14:10] what’s the kind of homework or when do as a merchant do homework or when do as a merchant do I need to think about getting up to the I need to think about getting up to the next level and maybe getting contact next level and maybe getting contact with SourceMedium.com to get my data with SourceMedium.com to get my data consolidated
[14:21] consolidated absolutely yeah so I think you know we absolutely yeah so I think you know we have this concept internally of the data have this concept internally of the data maturity curve right so you know for maturity curve right so you know for example in my last company I got to sort example in my last company I got to sort of participate in the scaling of the
[14:36] of participate in the scaling of the brand as we went from seven to nine brand as we went from seven to nine figures and now Beyond right as kind figures and now Beyond right as kind of the biggest online of the biggest online mattress retailer in North America now mattress retailer in North America now where I started right under 10 million
[14:49] where I started right under 10 million dollars in sales I remember but each dollars in sales I remember but each stage of that Journey required a certain stage of that Journey required a certain amount of self-awareness in terms of amount of self-awareness in terms of what it is that you actually need right what it is that you actually need right so how do you kind of think about that
[15:03] so how do you kind of think about that right it’s in terms of the maturity right it’s in terms of the maturity curve it’s it’s kind of made up of how curve it’s it’s kind of made up of how large your business is large your business is but also how complex your business is but also how complex your business is right so you know you could be for
[15:17] right so you know you could be for example a decent sized business but example a decent sized business but you’re only advertising on Google meta you’re only advertising on Google meta and selling through Shopify there are and selling through Shopify there are businesses out there so it’s not businesses out there so it’s not you could one could argue it’s not as
[15:31] you could one could argue it’s not as complex although that is very rare complex although that is very rare but you could be for example a 10 but you could be for example a 10 million dollar brand that’s selling on million dollar brand that’s selling on retail Amazon retail Amazon Shopify right you may have more than one
[15:45] Shopify right you may have more than one brand right or you may be selling in both the right or you may be selling in both the US and the UK right so all of these US and the UK right so all of these things are going to very rapidly things are going to very rapidly increase your complexity level
[16:00] increase your complexity level regardless of your actual Revenue size regardless of your actual Revenue size right so that’s kind of the most right so that’s kind of the most important but for every business they important but for every business they will get to a point where their will get to a point where their spreadsheet setup is not really doing it
[16:14] spreadsheet setup is not really doing it anymore right so whether that is a trust anymore right so whether that is a trust of rely a lack of reliability or it’s of rely a lack of reliability or it’s just not loading anymore right just not loading anymore right you know or maybe the out of the box you know or maybe the out of the box Shopify app that you installed is it
[16:30] Shopify app that you installed is it doesn’t have the richness of the data doesn’t have the richness of the data that you require to make the type of that you require to make the type of decisions that you need to be able to decisions that you need to be able to make right make right you know or you realize that the
[16:40] you know or you realize that the numbers that you’re seeing is let’s say numbers that you’re seeing is let’s say 20 off then what’s actual right so but 20 off then what’s actual right so but now you actually care whereas before now you actually care whereas before maybe you were fine with that right maybe you were fine with that right because it was smaller
[16:52] because it was smaller so once you kind of get to that so once you kind of get to that threshold then it’s time to really think threshold then it’s time to really think about this concept of a data strategy about this concept of a data strategy right in terms of what are you going to
[17:04] right in terms of what are you going to be adopting that is going to not only be adopting that is going to not only support you today but also the next two support you today but also the next two three four acts of growth that you’re three four acts of growth that you’re going to experience right because the
[17:15] going to experience right because the last thing a lot of people want to the last thing a lot of people want to do is probably to get to you know do is probably to get to you know another threshold in six months and you another threshold in six months and you have to do a whole other round of vendor
[17:23] have to do a whole other round of vendor evaluation and things like that evaluation and things like that right and that can really slow right and that can really slow down a business down a business if you do that if you do that yeah makes total sense yeah makes total sense obviously some businesses are growing
[17:36] obviously some businesses are growing slower and more predictable and some slower and more predictable and some business and hopefully you’re among that business and hopefully you’re among that as a merchant have this kind of ice as a merchant have this kind of ice hockey stick growth which for a lot of hockey stick growth which for a lot of them comes with a ton of problems and
[17:47] them comes with a ton of problems and challenges and then it’s better to be to challenges and then it’s better to be to have the right setup already done now have the right setup already done now you spoke a little bit earlier you spoke a little bit earlier you mentioned is the onboarding process mentioned is the onboarding process where you help with data quality and all
[17:58] where you help with data quality and all of that how does that work yeah great of that how does that work yeah great question so for us it’s pretty question so for us it’s pretty straightforward you know you sort of straightforward you know you sort of just oauth into your various just oauth into your various platforms and then we ingest the data
[18:10] platforms and then we ingest the data you know that’s pretty much the same you know that’s pretty much the same with every data provider out there but with every data provider out there but you know with our onboarding you know you know with our onboarding you know because of our focus on data quality we because of our focus on data quality we actually do a preliminary data quality
[18:23] actually do a preliminary data quality check right making sure that our numbers are right making sure that our numbers are matching right for example what’s coming matching right for example what’s coming out of the Shopify sales report right out of the Shopify sales report right yeah and if there are differences we yeah and if there are differences we actually spend the time to
[18:35] actually spend the time to understand ahead of our actual understand ahead of our actual onboarding call right that’s kind of one onboarding call right that’s kind of one layer of just kind of like numbers layer of just kind of like numbers matching right so that’s very easy to matching right so that’s very easy to understand but then there’s a lot of
[18:47] understand but then there’s a lot of other data hygiene things that we help other data hygiene things that we help identify proactively for example you identify proactively for example you have a lot of non-nons or direct nuns in have a lot of non-nons or direct nuns in your UTM values right so or let’s say your UTM values right so or let’s say you’re not tagging your utms correctly
[19:03] you’re not tagging your utms correctly where you’re not for example using where you’re not for example using something like UTM campaign that can something like UTM campaign that can give you some richer information there give you some richer information there right where you’re using inconsistent right where you’re using inconsistent naming conventions or discount codes are naming conventions or discount codes are being used you know in inconsistent
[19:16] being used you know in inconsistent ways right or let’s say for a zero ways right or let’s say for a zero dollar Waters the Cs department is dollar Waters the Cs department is doing different types of things that doing different types of things that actually makes cleaning that data more actually makes cleaning that data more tricky so all of those things we would
[19:30] tricky so all of those things we would be identifying proactively but also sort be identifying proactively but also sort of what are some of the things that we of what are some of the things that we know that is a generally accepted best know that is a generally accepted best practice that the brand is not doing so
[19:41] practice that the brand is not doing so an example that I can give there for an example that I can give there for example is not doing post-purchase example is not doing post-purchase surveys right getting information on how surveys right getting information on how did you hear about us right so we did you hear about us right so we integrate with our partners in the
[19:53] integrate with our partners in the ecosystem there as well you know but ecosystem there as well you know but I think ultimately the reason a lot of I think ultimately the reason a lot of people haven’t done some of those things people haven’t done some of those things even though they may already know the even though they may already know the importance of it is they haven’t had an
[20:06] importance of it is they haven’t had an actionable way to really look at it actionable way to really look at it right so the aha moment that we right so the aha moment that we typically get is okay well I can typically get is okay well I can actually use this Insight now I can actually use this Insight now I can actually make types of decisions based
[20:18] actually make types of decisions based on utms that I didn’t even think was on utms that I didn’t even think was possible right and then that opens up a lot of right and then that opens up a lot of other thoughts there right I think just other thoughts there right I think just being able to look at your last click
[20:31] being able to look at your last click attribution relative to the zero party attribution relative to the zero party attribution AKA how the customer heard attribution AKA how the customer heard about you becomes very insightful right about you becomes very insightful right because you typically see for example a because you typically see for example a lot of Google taking a lot of last click
[20:46] lot of Google taking a lot of last click credits right but then you might say you credits right but then you might say you might actually see that well they might actually see that well they actually heard about you on YouTube or actually heard about you on YouTube or they actually heard about you on classes they actually heard about you on classes podcast or what have you so all of a
[20:57] podcast or what have you so all of a sudden it’s like you’re going into high sudden it’s like you’re going into high def right whereas previously you know def right whereas previously you know you’re just kind of like you’re just kind of like suffering under the obscurity of Google suffering under the obscurity of Google CPC SourceMedium right and having a
[21:11] CPC SourceMedium right and having a lot of opinion based debates around are lot of opinion based debates around are we overspending on Google or how do we overspending on Google or how do we think about this right you really want think about this right you really want to just be moving your discussions from to just be moving your discussions from the land of opinions to a land of right
[21:26] the land of opinions to a land of right a consistently analyzed a consistently analyzed a consistent analysis based on you know a consistent analysis based on you know a trusted source of data a trusted source of data awesome example that you gave there was awesome example that you gave there was the last click attribution
[21:41] the last click attribution all the providers out there always all the providers out there always want to have the last click attribution want to have the last click attribution because they want to claim the business because they want to claim the business or they click for themselves and it or they click for themselves and it screws up the data and it shows you also
[21:50] screws up the data and it shows you also that having a good structured system and that having a good structured system and an external partner who knows on how to an external partner who knows on how to look in the data will help your business look in the data will help your business massively now who’s your perfect
[21:59] massively now who’s your perfect customer yeah we typically work with brands that yeah we typically work with brands that do sales between 20 million to up to a do sales between 20 million to up to a billion you know but with that being said we you know but with that being said we also work with brands of all sizes
[22:14] also work with brands of all sizes because we have a very selective few because we have a very selective few agency partners that are able to agency partners that are able to essentially use our data as their essentially use our data as their infrastructure and service that to their infrastructure and service that to their own clientele so you know but we
[22:29] own clientele so you know but we actually also work with SAS companies actually also work with SAS companies who take in our data to power their own who take in our data to power their own reporting or power their own feature reporting or power their own feature sets and of course then we indirectly sets and of course then we indirectly serve those customers as well
[22:44] serve those customers as well but you know I would say in terms of but you know I would say in terms of brands that are coming to us directly brands that are coming to us directly and we’re working with directly there and we’re working with directly there really has to be a commitment to
[22:56] really has to be a commitment to onboarding with us and kind of onboarding with us and kind of like stepping into our methods you like stepping into our methods you know and that also requires know and that also requires work on the Brand’s end in terms of work on the Brand’s end in terms of let’s say cleaning up things like utms
[23:09] let’s say cleaning up things like utms right cleaning up internal right cleaning up internal practices to make sure that the data practices to make sure that the data coming in is going to be standardized coming in is going to be standardized and clean right actually learning about and clean right actually learning about some of these neural Pathways you know
[23:21] some of these neural Pathways you know going from let’s say having an going from let’s say having an analytical question to getting to a analytical question to getting to a trustworthy actionable piece of insight trustworthy actionable piece of insight so you know but then I would say in you know but then I would say in that case it’s typically brands that
[23:37] that case it’s typically brands that have some level of complexity baked in have some level of complexity baked in apparel is a great example of that right apparel is a great example of that right they have a ton of exchange data they have a ton of exchange data reshipments influencer samples right reshipments influencer samples right tons and tons of orders that you really
[23:51] tons and tons of orders that you really don’t want to be calculating in your don’t want to be calculating in your metrics right or let’s say they have metrics right or let’s say they have Amazon and Shopify right or let’s say Amazon and Shopify right or let’s say they’re leveraging a retail partner like they’re leveraging a retail partner like leap right that’s kind of sitting on top
[24:06] leap right that’s kind of sitting on top of their Amazon store or tap car and you of their Amazon store or tap car and you need to be able to look at the need to be able to look at the performance of those channels separately performance of those channels separately right so all of those things will be
[24:15] right so all of those things will be sort of just like out of the box sort of just like out of the box for us you know but again right that’s for us you know but again right that’s not for every Merchant right the not for every Merchant right the ultimately the long tail majority of ultimately the long tail majority of merchants
[24:26] merchants are probably just on Shopify are probably just on Shopify probably just using Google ads and meta probably just using Google ads and meta and probably just having GA and probably just having GA you know so in that case we could you know so in that case we could obviously absolutely still work for
[24:37] obviously absolutely still work for those Brands but it’s really for brands those Brands but it’s really for brands that already have some sense of the that already have some sense of the complexity that’s either incoming or complexity that’s either incoming or that’s already in their business that’s already in their business I like to focus that in your onboarding
[24:48] I like to focus that in your onboarding you basically completely dissect what you basically completely dissect what they have and not only provide a they have and not only provide a technical solution but also the technical solution but also the expertise on how to make it better and expertise on how to make it better and I’m sure you must have seen a huge mess
[24:59] I’m sure you must have seen a huge mess with one or other clients onboarding you with one or other clients onboarding you I can’t just imagine that some people I can’t just imagine that some people just do not have control over their data just do not have control over their data give me the overview about what’s the
[25:09] give me the overview about what’s the pricing structure just a rough idea pricing structure just a rough idea yeah so it sort of depends on the use yeah so it sort of depends on the use case you know so we have more of a case you know so we have more of a wholesale model for agencies and SAS
[25:19] wholesale model for agencies and SAS companies that’s more so as a potential companies that’s more so as a potential replacement for products like five Tran that they for products like five Tran that they may be using you know but direct to may be using you know but direct to Brand we look at they’re trying 12
[25:32] Brand we look at they’re trying 12 months sales and we have different sort months sales and we have different sort of levels there depending on how much of levels there depending on how much sales that you’re you’re actually doing sales that you’re you’re actually doing that’s actually flowing through our that’s actually flowing through our system so the for example
[25:45] system so the for example the decision to say whether or not we the decision to say whether or not we want to integrate Amazon becomes want to integrate Amazon becomes relatively easy because you know how relatively easy because you know how much sales is coming through that and much sales is coming through that and how much increased cost and that would
[25:54] how much increased cost and that would sort of sort of be bundled into that as a result be bundled into that as a result okay before we come to the end of our okay before we come to the end of our coffee break today is a one final coffee break today is a one final thought that you want to leave our
[26:03] thought that you want to leave our listeners with well thank you for allowing me the time and air space to talk about the time and air space to talk about SourceMedium but yeah no I think the SourceMedium but yeah no I think the final thought really is to reiterate final thought really is to reiterate right this relationship between
[26:20] right this relationship between understanding where you are in terms of understanding where you are in terms of your own maturity as a brand and having your own maturity as a brand and having establishing opinion between the establishing opinion between the complexity of your business and the complexity of your business and the needs that you actually have when it
[26:34] needs that you actually have when it when it comes to data and then being when it comes to data and then being very intentional about selecting the very intentional about selecting the right solution there and of right solution there and of course I think there’s always the build course I think there’s always the build versus buy discussion as well so it’s
[26:47] versus buy discussion as well so it’s really important to also understand if really important to also understand if one were to build internally right what one were to build internally right what are the implications and scaling are the implications and scaling challenges that they will inevitably challenges that they will inevitably sort of come into play as the businesses
[27:00] sort of come into play as the businesses grow so you know there’s there’s grow so you know there’s there’s hours and hours of conversations we can hours and hours of conversations we can have about that but you know I would have about that but you know I would say happy to kind of chat with
[27:11] say happy to kind of chat with anybody that’s that’s in The Listener anybody that’s that’s in The Listener base of the podcast here feel free to base of the podcast here feel free to just email me directly at just email me directly at faiSourceMedium.com that’s efficacyfrank faiSourceMedium.com that’s efficacyfrank E.I SourceMedium.com and we’d be happy
[27:23] E.I SourceMedium.com and we’d be happy to dig deeper into some of those to dig deeper into some of those topics excellent I will put the links in the excellent I will put the links in the show notes as always then you just one show notes as always then you just one click away hey thanks so much for giving
[27:32] click away hey thanks so much for giving us a in a very in-depth insight into us a in a very in-depth insight into Data why it’s so important and what you Data why it’s so important and what you can do to make it better and I hope a can do to make it better and I hope a lot of listeners will get in touch with
[27:40] lot of listeners will get in touch with you thanks so much for your time today you thanks so much for your time today plus take care bye hey Claus here before you go I would like to invite you to become part of the like to invite you to become part of the e-commerce Merchant Pro Community to get
[27:52] e-commerce Merchant Pro Community to get actionable advice from other Shopify actionable advice from other Shopify Merchants who already have achieved what Merchants who already have achieved what you are aiming for our community is a you are aiming for our community is a safe place to actively grow your online safe place to actively grow your online retail business with the support of the
[28:02] retail business with the support of the most amazing and helpful group of most amazing and helpful group of e-commerce entrepreneurs behind you e-commerce entrepreneurs behind you running a Shopify business is tough running a Shopify business is tough don’t do it alone join us now you will don’t do it alone join us now you will find the link in the show notes also if
[28:13] find the link in the show notes also if you think your online store has you think your online store has conversion or marketing issues and you conversion or marketing issues and you would like to have a fresh set of eyes would like to have a fresh set of eyes on your business then drop me an email on your business then drop me an email at Klaus klauslaughter.com and let me
[28:22] at Klaus klauslaughter.com and let me know a little bit about your business it know a little bit about your business it might be beneficial for you to have me might be beneficial for you to have me look over your store offers emails and look over your store offers emails and ads and get an unbiased outside ads and get an unbiased outside perspective and guidance to help you
[28:32] perspective and guidance to help you make most of your online business thank make most of your online business thank you as always for tuning in today I you as always for tuning in today I appreciate you until next time and I appreciate you until next time and I talk to you soon