{"id":22077,"date":"2024-11-25T23:21:18","date_gmt":"2024-11-25T22:21:18","guid":{"rendered":"https:\/\/chartmogul.com\/blog\/?p=22077"},"modified":"2024-11-27T02:23:55","modified_gmt":"2024-11-27T01:23:55","slug":"our-revamped-approach-to-data-cleaning","status":"publish","type":"post","link":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/","title":{"rendered":"Our revamped approach to data cleaning"},"content":{"rendered":"\n<p>In ChartMogul, data imported from your subscription billing system(s) serves as the foundation for calculating your SaaS metrics. But sometimes, there are issues with that data which can affect the accuracy of your reports.<\/p>\n\n\n\n<p>To help, we\u2019ve enhanced our suite of data cleaning tools, giving you greater control over the data you import into ChartMogul.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#data-cleaning-chartmogul\">How data cleaning works in ChartMogul<\/a><\/li>\n<\/ul>\n\n\n\n<p>Check out the other data cleaning features in ChartMogul:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#merging-customers\">Merging customers<\/a><\/li>\n\n\n\n<li><a href=\"#MRR-editing\">MRR editing<\/a><\/li>\n\n\n\n<li><a href=\"#Connecting-subscriptions\">Connecting subscriptions<\/a><\/li>\n\n\n\n<li><a href=\"#Adding-subscriptions-manually\">Adding subscriptions manually<\/a><\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"data-cleaning-chartmogul\"><strong>How data cleaning works in ChartMogul<\/strong><\/h1>\n\n\n\n<p>Now, you can <a href=\"https:\/\/help.chartmogul.com\/hc\/en-us\/articles\/16670527715100\">easily make edits<\/a> directly in ChartMogul. All imported billing and subscription data \u2014 like invoices, line items, transactions and subscription events \u2014 can be edited. This applies to data from Stripe, Chargebee and Recurly.<\/p>\n\n\n\n<p>Users with Owner, Admin or Staff roles can make changes, and each edit is logged with the date, time and author details. Edits are reversible, too.&nbsp;<\/p>\n\n\n\n<p>Any changes you make are stored separately from the original billing data, so even if the source is resynced or billing data is reimported, your edits will still be applied.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"427\" src=\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/data-cleaning.gif\" alt=\"data cleaning\" class=\"wp-image-22094\"\/><\/figure>\n\n\n\n<p><br>Data cleaning is useful when a charge in your billing system is mistakenly categorized as non-recurring. This typically occurs when you\u2019re offering custom pricing for a specific customer or when manually adjusting a customer\u2019s subscription.<\/p>\n\n\n\n<p>When these one-time charge invoices are imported into ChartMogul, they won\u2019t contribute to your recurring revenue as ChartMogul interprets it as non-recurring from your billing platform.&nbsp;<\/p>\n\n\n\n<p>The good news is that you can now easily correct this in ChartMogul. Simply change the line item type to \u201crecurring\u201d and add the necessary subscription information&nbsp; and ChartMogul will treat that revenue as recurring.<br><\/p>\n\n\n\n<p><strong><em>There are four other ways you can correct data in ChartMogul.<\/em><\/strong><em> <\/em>Together, this suite of data cleaning tools puts you in control, ensuring your team keeps accurate SaaS metrics in ChartMogul.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"merging-customers\"><strong>Merging customers<\/strong><\/h1>\n\n\n\n<p>Duplicate records cause a lot of confusion, but can be common when importing data from multiple sources.<\/p>\n\n\n\n<p>In ChartMogul, you\u2019ll be importing customer and subscription data from a range of sources. For example, from Stripe where you manage billing, and from Hubspot where you handle leads and customer communication. When you have many data sources, you may end up in scenarios where a single customer or lead is imported multiple times, resulting in duplicate records in ChartMogul.&nbsp;<\/p>\n\n\n\n<p>One way to prevent this is via the <a href=\"https:\/\/help.chartmogul.com\/hc\/en-us\/articles\/13705053532572-Automations#merging-duplicate-customers\">merge customer automation<\/a>. Once created, it will instantly start organizing your customer records in ChartMogul, combining data from duplicates into one complete profile with all data points in one place. Note, you can also merge customers via API, or manually on the customer profile itself.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"409\" src=\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/automations-1024x409.png\" alt=\"merging customers\" class=\"wp-image-22095\" srcset=\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/automations-1024x409.png 1024w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/automations-300x120.png 300w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/automations-1536x614.png 1536w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/automations-2048x819.png 2048w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/automations-720x288.png 720w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/automations-1920x768.png 1920w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/automations-300x120@2x.png 600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"MRR-editing\"><strong>MRR editing<\/strong><\/h1>\n\n\n\n<p>MRR is a key metric in ChartMogul\u2019s Subscription Analytics. If it\u2019s incorrect, it should be fixed right away to keep your SaaS metrics accurate. Inaccurate MRR can happen if data in your billing system isn\u2019t in a state to allow ChartMogul to accurately generate an MRR history.<br>Good news&nbsp;\u2014\u2013&nbsp;ChartMogul allows you to <a href=\"https:\/\/help.chartmogul.com\/hc\/en-us\/articles\/115005750705-MRR-data-editing#editing-mrr\">edit MRR data<\/a> to ensure it\u2019s correct historically. MRR edits are highlighted, with a note of the change made, the date and which user made the edit.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"464\" src=\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/hover-over-change-optimized.gif\" alt=\"MRR editing\" class=\"wp-image-22096\"\/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"Connecting-subscriptions\"><strong>Connecting subscriptions<\/strong><\/h1>\n\n\n\n<p>Gaps in a customer\u2019s subscription history can occur if you manually cancel and re-subscribe a customer (e.g., in order to alter some terms of their subscription), or when you migrate a customer (or all your customers) from one billing system to another. In both scenarios, you\u2019ll see either a gap or overlap in their ChartMogul subscription history.&nbsp;<\/p>\n\n\n\n<p>In these situations, you can <a href=\"https:\/\/help.chartmogul.com\/hc\/en-us\/articles\/115005750705-MRR-data-editing#connecting-subscriptions\">connect the customer\u2019s two subscriptions<\/a> to report this as a single subscription without interruption.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"518\" src=\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/connect-subscriptions-ann-1024x518.png\" alt=\"Connecting subscriptions\" class=\"wp-image-22097\" srcset=\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/connect-subscriptions-ann-1024x518.png 1024w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/connect-subscriptions-ann-300x152.png 300w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/connect-subscriptions-ann-1536x777.png 1536w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/connect-subscriptions-ann-2048x1035.png 2048w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/connect-subscriptions-ann-720x364.png 720w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/connect-subscriptions-ann-1920x971.png 1920w, https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/connect-subscriptions-ann-300x152@2x.png 600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"Adding-subscriptions-manually\"><strong>Adding subscriptions manually<\/strong><\/h1>\n\n\n\n<p>Sometimes, you\u2019ll need to create a subscription manually in ChartMogul, when for example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Some customers are invoiced outside a connected billing system.<\/li>\n\n\n\n<li>You\u2019re importing old subscription data where you don\u2019t have associated invoices available to import.<\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/help.chartmogul.com\/hc\/en-us\/articles\/202854061-Manual-subscriptions\">Manual subscriptions<\/a> are treated like any other subscription in ChartMogul, and feed into your SaaS metrics.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"531\" src=\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/ChartMogul-Manual-Subscriptions.gif\" alt=\"\" class=\"wp-image-22098\"\/><\/figure>\n\n\n\n<p>If you\u2019d like to learn more about ChartMogul\u2019s suite of data cleaning tools, <a href=\"mailto:support@chartmogul.com\">reach out to us<\/a>.<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To generate accurate metrics, you need clean data\u2014here\u2019s how our improved data cleaning features make that easier.<\/p>\n","protected":false},"author":78,"featured_media":22170,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39],"tags":[25,29,47],"class_list":["post-22077","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-product-updates","tag-chartmogul","tag-data","tag-product"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Our revamped approach to data cleaning | ChartMogul<\/title>\n<meta name=\"description\" content=\"To generate accurate metrics, you need clean data\u2014here\u2019s how our improved data cleaning features make that easier.\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<link rel=\"canonical\" href=\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Our revamped approach to data cleaning | ChartMogul\" \/>\n<meta property=\"og:description\" content=\"To generate accurate metrics, you need clean data\u2014here\u2019s how our improved data cleaning features make that easier.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/\" \/>\n<meta property=\"og:site_name\" content=\"ChartMogul\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/chartmogul\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-25T22:21:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-27T01:23:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3000\" \/>\n\t<meta property=\"og:image:height\" content=\"1250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dijana Kostic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@chartmogul\" \/>\n<meta name=\"twitter:site\" content=\"@chartmogul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dijana Kostic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/\"},\"author\":{\"name\":\"Dijana Kostic\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/1c190d5765111e514d1283786cda3dfd\"},\"headline\":\"Our revamped approach to data cleaning\",\"datePublished\":\"2024-11-25T22:21:18+00:00\",\"dateModified\":\"2024-11-27T01:23:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/\"},\"wordCount\":700,\"publisher\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png\",\"keywords\":[\"chartmogul\",\"data\",\"product\"],\"articleSection\":[\"Product Updates\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/\",\"url\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/\",\"name\":\"Our revamped approach to data cleaning | ChartMogul\",\"isPartOf\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png\",\"datePublished\":\"2024-11-25T22:21:18+00:00\",\"dateModified\":\"2024-11-27T01:23:55+00:00\",\"description\":\"To generate accurate metrics, you need clean data\u2014here\u2019s how our improved data cleaning features make that easier.\",\"breadcrumb\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#primaryimage\",\"url\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png\",\"contentUrl\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png\",\"width\":3000,\"height\":1250},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/chartmogul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Our revamped approach to data cleaning\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#website\",\"url\":\"https:\/\/chartmogul.com\/blog\/\",\"name\":\"ChartMogul\",\"description\":\"Get all your SaaS &amp; Subscription Metrics with a Single Click! MRR, churn, LTV and much more.\",\"publisher\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/chartmogul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#organization\",\"name\":\"ChartMogul\",\"url\":\"https:\/\/chartmogul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2019\/05\/ChartMogul-Logo.png\",\"contentUrl\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2019\/05\/ChartMogul-Logo.png\",\"width\":278,\"height\":52,\"caption\":\"ChartMogul\"},\"image\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/chartmogul\",\"https:\/\/x.com\/chartmogul\",\"https:\/\/www.linkedin.com\/company\/chartmogul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/1c190d5765111e514d1283786cda3dfd\",\"name\":\"Dijana Kostic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2021\/09\/DijanaKostic.png\",\"contentUrl\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2021\/09\/DijanaKostic.png\",\"caption\":\"Dijana Kostic\"},\"description\":\"Product Manager @ ChartMogul\",\"url\":\"https:\/\/chartmogul.com\/blog\/author\/dijana-kostic\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Our revamped approach to data cleaning | ChartMogul","description":"To generate accurate metrics, you need clean data\u2014here\u2019s how our improved data cleaning features make that easier.","robots":{"index":"index","follow":"follow"},"canonical":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/","og_locale":"en_US","og_type":"article","og_title":"Our revamped approach to data cleaning | ChartMogul","og_description":"To generate accurate metrics, you need clean data\u2014here\u2019s how our improved data cleaning features make that easier.","og_url":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/","og_site_name":"ChartMogul","article_publisher":"https:\/\/www.facebook.com\/chartmogul","article_published_time":"2024-11-25T22:21:18+00:00","article_modified_time":"2024-11-27T01:23:55+00:00","og_image":[{"width":3000,"height":1250,"url":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png","type":"image\/png"}],"author":"Dijana Kostic","twitter_card":"summary_large_image","twitter_creator":"@chartmogul","twitter_site":"@chartmogul","twitter_misc":{"Written by":"Dijana Kostic","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#article","isPartOf":{"@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/"},"author":{"name":"Dijana Kostic","@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/1c190d5765111e514d1283786cda3dfd"},"headline":"Our revamped approach to data cleaning","datePublished":"2024-11-25T22:21:18+00:00","dateModified":"2024-11-27T01:23:55+00:00","mainEntityOfPage":{"@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/"},"wordCount":700,"publisher":{"@id":"https:\/\/chartmogul.com\/blog\/#organization"},"image":{"@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#primaryimage"},"thumbnailUrl":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png","keywords":["chartmogul","data","product"],"articleSection":["Product Updates"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/","url":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/","name":"Our revamped approach to data cleaning | ChartMogul","isPartOf":{"@id":"https:\/\/chartmogul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#primaryimage"},"image":{"@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#primaryimage"},"thumbnailUrl":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png","datePublished":"2024-11-25T22:21:18+00:00","dateModified":"2024-11-27T01:23:55+00:00","description":"To generate accurate metrics, you need clean data\u2014here\u2019s how our improved data cleaning features make that easier.","breadcrumb":{"@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#primaryimage","url":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png","contentUrl":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2024\/11\/blog-data-editing-1.png","width":3000,"height":1250},{"@type":"BreadcrumbList","@id":"https:\/\/chartmogul.com\/blog\/our-revamped-approach-to-data-cleaning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/chartmogul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Our revamped approach to data cleaning"}]},{"@type":"WebSite","@id":"https:\/\/chartmogul.com\/blog\/#website","url":"https:\/\/chartmogul.com\/blog\/","name":"ChartMogul","description":"Get all your SaaS &amp; Subscription Metrics with a Single Click! MRR, churn, LTV and much more.","publisher":{"@id":"https:\/\/chartmogul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/chartmogul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/chartmogul.com\/blog\/#organization","name":"ChartMogul","url":"https:\/\/chartmogul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2019\/05\/ChartMogul-Logo.png","contentUrl":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2019\/05\/ChartMogul-Logo.png","width":278,"height":52,"caption":"ChartMogul"},"image":{"@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/chartmogul","https:\/\/x.com\/chartmogul","https:\/\/www.linkedin.com\/company\/chartmogul\/"]},{"@type":"Person","@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/1c190d5765111e514d1283786cda3dfd","name":"Dijana Kostic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2021\/09\/DijanaKostic.png","contentUrl":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2021\/09\/DijanaKostic.png","caption":"Dijana Kostic"},"description":"Product Manager @ ChartMogul","url":"https:\/\/chartmogul.com\/blog\/author\/dijana-kostic\/"}]}},"_links":{"self":[{"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/posts\/22077","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/comments?post=22077"}],"version-history":[{"count":8,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/posts\/22077\/revisions"}],"predecessor-version":[{"id":22168,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/posts\/22077\/revisions\/22168"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/media\/22170"}],"wp:attachment":[{"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/media?parent=22077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/categories?post=22077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/tags?post=22077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}