{"id":2732,"date":"2021-12-03T10:44:02","date_gmt":"2021-12-03T10:44:02","guid":{"rendered":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/?p=2732"},"modified":"2021-12-03T10:44:03","modified_gmt":"2021-12-03T10:44:03","slug":"ensuring-data-is-accurate-for-great-reporting","status":"publish","type":"post","link":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/","title":{"rendered":"Apprentice Hoots: Using Salesforce&#8217;s Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting"},"content":{"rendered":"\n<p>Ensuring data is as accurate as possible is extremely important for reporting purposes. A new customer who recently joined us had very messy data within their existing system. The challenges ranged from data which was put into text fields rather than fields specific to the data\u2019s purpose, pick list values which were not selected, household contact data captured in the wrong contact and many other issues.\u00a0 This made it impossible to report on with any degree of confidence, as the data was in the wrong place within the system, or simply missing. I have been working with this customer to build the structure of where the data will belong, and how all data within the system needs to be cleansed.<\/p>\n\n\n\n<p>With lots of information missing within the system, a joint effort between Coacto and the customer was required to ensure the data was correct and could show real value. On top of this, instead of having the contact type on the contact record, this was stored in a campaign named after the contact type and all contacts that were of this type were campaign members. This happened because there was nowhere for this information to be stored in the system previously, so they had to improvise.<\/p>\n\n\n\n<p><strong>Creating a plan for the data cleanse<\/strong><\/p>\n\n\n\n<p>To plan for the customer\u2019s data cleanse, we created an eight step process:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Confirm the customer is happy with the fields I have identified to cleanse \/ update within the system.<\/li><li>Due to the customer wanting to know each school the contact went to, they needed to provide us with a list of schools the contacts went to so we could put these into the system. These schools are a lookup field to an account record.<\/li><li>Extract the contacts from the system with the fields that need cleansing.<\/li><li>Extract contact type campaign and campaign members with their contact ID.<\/li><li>Merge the two data sets together and organise the data with instructions and validations to ensure when it is reviewed that it is filled in correctly.<\/li><li>Manually add any contacts that are not in the system and fill in any blank fields.<\/li><li>Cleanse the data for any duplications or incorrect data.<\/li><li>Import contacts with the updated data fields and relevant school back into the system.<\/li><\/ol>\n\n\n\n<p>Here is a visual representation of what the plan looked like:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/oPVWMxgcLho8zapyCfWAKGFtJj7fTbyTpEpLzcYEJ205UrfDqNtMMR-YdhiwUn-bdhAPiuBoyzTWsB1ThaZ9zcJm_Y8zoMSuLUBLTqXxLGsyNNjZAIcyeaXzFl1IsvSemhgK8xco\" alt=\"\"\/><\/figure>\n\n\n\n<p><em>Please note: The customer\u2019s name has been blanked out for confidentiality purposes.<\/em><\/p>\n\n\n\n<p><strong>Extracting existing data from the Salesforce system<\/strong><\/p>\n\n\n\n<p>Once we had a clear scope of the data that needed to be imported, I began to create two reports, one with the contacts and all the fields that needed to be cleansed i.e. the type field on the contact; the other with the type campaigns and the campaign members. On both of these reports I made sure to include the contact ID to map each record back to the correct record. I then exported both of these reports into corresponding spreadsheets.<\/p>\n\n\n\n<p><strong>Merging of documents<\/strong><\/p>\n\n\n\n<p>Using Google sheets vlookup formula to map the correct records together, I merged the data sets into one data set. I then merged the \u201ctype\u201d field on the contact form with the \u201ccampaign name\u201d field so all details were in one field. I could then organise the data with instructions and validations to ensure it is filled in correctly.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/T-fl5Q4U0CdVjZWAoSt9P-4Wx9eubzpX-tyrHH_Sm44VFeMkVKjmyv0agrqqGXV0fvZ3ObAjjxDQB6eTNOqXSDIpfrn83kaxUkRlv1zyEnwZbkSc-pt_Og7VfrdbYZn4VP7J6kLY\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/CLUWf22DLLN3sKxbb5cxIm1SZP62S5keuIk9zlpIeHgBDRctgXVu9C9ymEokwSg8rMgwii6uYnKhTeD6PR_Y2tQW6YHzFH5c5xQijyrPc9MHq41fxmigpmQIzI13FEYgeE1nW2pG\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>Cleansing the data<\/strong><\/p>\n\n\n\n<p>Now the data was out of the system and in an organised spreadsheet where all data was visible at once, this made it much easier for our customer to go through filling out all the blank fields and correcting any incorrect data. Although this was still a time consuming process, it would have taken much longer to click into each record and do this. As I do not know this unknown data unfortunately this is something I could not help with either. This was the stage where the customer also provided us with the list of the schools.<\/p>\n\n\n\n<p><strong>Importing the data back into Salesforce<\/strong><\/p>\n\n\n\n<p>Once the customer confirmed they are happy the data in the spreadsheet is correct, I imported the records into the system. Firstly, I needed to import the school\u2019s data into the system. I used the Data Import Wizard\u2019s new record import functionality to import all the schools into the accounts object. Next, I&nbsp; imported the contacts. Since the contacts are already in the system, this required the Data Import Wizard\u2019s update records functionality. I matched the contact by the Contact ID in case there were two contacts with the same name. I also matched the Current school \/ education provider lookup field to the account name to link the contact current school to find the school record within accounts.<\/p>\n\n\n\n<p>Now this customer has a system with consistent, accurate data that they can report on and use with confidence, knowing that it is complete and up to date. We have added validation rules, required fields and popup reminders to ensure the data remains as accurate as possible.<br><br>If you think your system and data could benefit from a data cleanse, re-structure&nbsp; or requires some rules to ensure data quality , please contact us <a href=\"https:\/\/www.coacto.co.uk\/contact\/\">here.<\/a><\/p>\n\n\n\n<p><em>Owl see you later&#8230;&nbsp;<\/em><\/p>\n\n\n\n<p>Charlotte<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ensuring data is as accurate as possible is extremely important for reporting purposes. A new customer who recently joined us had very messy data within their existing system. The challenges ranged from data which was put into text fields rather than fields specific to the data\u2019s purpose, pick list values which were not selected, household contact data captured in the wrong contact and many other [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":2733,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[13,31,41,11],"class_list":["post-2732","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-coacto","tag-coacto-consulting","tag-crm","tag-salesforce"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Apprentice Hoots: Using Salesforce&#039;s Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting | Coacto Consulting<\/title>\n<meta name=\"description\" content=\"Ensuring data is as accurate as possible is extremely important for reporting purposes. I have been working with this customer to build the structure of where the data will belong, and how all data within the system needs to be cleansed.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apprentice Hoots: Using Salesforce&#039;s Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting | Coacto Consulting\" \/>\n<meta property=\"og:description\" content=\"Ensuring data is as accurate as possible is extremely important for reporting purposes. I have been working with this customer to build the structure of where the data will belong, and how all data within the system needs to be cleansed.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/\" \/>\n<meta property=\"og:site_name\" content=\"Coacto Consultants\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-03T10:44:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-03T10:44:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-content\/uploads\/2021\/12\/Apprentice-Hoots-_LDN-Dev-Day-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"788\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Paul Harris\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Harris\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/\"},\"author\":{\"name\":\"Paul Harris\",\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/person\/bdcc18fee204ba3815045cbb826adb41\"},\"headline\":\"Apprentice Hoots: Using Salesforce&#8217;s Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting\",\"datePublished\":\"2021-12-03T10:44:02+00:00\",\"dateModified\":\"2021-12-03T10:44:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/\"},\"wordCount\":891,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#organization\"},\"keywords\":[\"Coacto\",\"Coacto Consulting\",\"CRM\",\"Salesforce\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/\",\"url\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/\",\"name\":\"Apprentice Hoots: Using Salesforce's Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting | Coacto Consulting\",\"isPartOf\":{\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#website\"},\"datePublished\":\"2021-12-03T10:44:02+00:00\",\"dateModified\":\"2021-12-03T10:44:03+00:00\",\"description\":\"Ensuring data is as accurate as possible is extremely important for reporting purposes. I have been working with this customer to build the structure of where the data will belong, and how all data within the system needs to be cleansed.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apprentice Hoots: Using Salesforce&#8217;s Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#website\",\"url\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/\",\"name\":\"Coacto Consultants\",\"description\":\"Delivery Salesforce systems that align with your business goals.\",\"publisher\":{\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#organization\",\"name\":\"Coacto Consultants\",\"url\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-content\/uploads\/2020\/11\/Coacto-Animated-Logo-100-x-50-1.gif\",\"contentUrl\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-content\/uploads\/2020\/11\/Coacto-Animated-Logo-100-x-50-1.gif\",\"width\":100,\"height\":50,\"caption\":\"Coacto Consultants\"},\"image\":{\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/person\/bdcc18fee204ba3815045cbb826adb41\",\"name\":\"Paul Harris\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/98e04fd0e377b705b6ce277b38fcb6746f6e56066d48cb57f860b5f571a85436?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/98e04fd0e377b705b6ce277b38fcb6746f6e56066d48cb57f860b5f571a85436?s=96&d=mm&r=g\",\"caption\":\"Paul Harris\"},\"url\":\"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/author\/coacto_editor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apprentice Hoots: Using Salesforce's Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting | Coacto Consulting","description":"Ensuring data is as accurate as possible is extremely important for reporting purposes. I have been working with this customer to build the structure of where the data will belong, and how all data within the system needs to be cleansed.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"Apprentice Hoots: Using Salesforce's Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting | Coacto Consulting","og_description":"Ensuring data is as accurate as possible is extremely important for reporting purposes. I have been working with this customer to build the structure of where the data will belong, and how all data within the system needs to be cleansed.","og_url":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/","og_site_name":"Coacto Consultants","article_published_time":"2021-12-03T10:44:02+00:00","article_modified_time":"2021-12-03T10:44:03+00:00","og_image":[{"width":940,"height":788,"url":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-content\/uploads\/2021\/12\/Apprentice-Hoots-_LDN-Dev-Day-1.png","type":"image\/png"}],"author":"Paul Harris","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Paul Harris","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/#article","isPartOf":{"@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/"},"author":{"name":"Paul Harris","@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/person\/bdcc18fee204ba3815045cbb826adb41"},"headline":"Apprentice Hoots: Using Salesforce&#8217;s Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting","datePublished":"2021-12-03T10:44:02+00:00","dateModified":"2021-12-03T10:44:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/"},"wordCount":891,"commentCount":0,"publisher":{"@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#organization"},"keywords":["Coacto","Coacto Consulting","CRM","Salesforce"],"articleSection":["Blog"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/","url":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/","name":"Apprentice Hoots: Using Salesforce's Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting | Coacto Consulting","isPartOf":{"@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#website"},"datePublished":"2021-12-03T10:44:02+00:00","dateModified":"2021-12-03T10:44:03+00:00","description":"Ensuring data is as accurate as possible is extremely important for reporting purposes. I have been working with this customer to build the structure of where the data will belong, and how all data within the system needs to be cleansed.","breadcrumb":{"@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/ensuring-data-is-accurate-for-great-reporting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/"},{"@type":"ListItem","position":2,"name":"Apprentice Hoots: Using Salesforce&#8217;s Data Import Wizard, Google Sheets and Salesforce reports to rollout a deep data cleanse making data accurate and consistent for great reporting"}]},{"@type":"WebSite","@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#website","url":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/","name":"Coacto Consultants","description":"Delivery Salesforce systems that align with your business goals.","publisher":{"@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#organization","name":"Coacto Consultants","url":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/logo\/image\/","url":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-content\/uploads\/2020\/11\/Coacto-Animated-Logo-100-x-50-1.gif","contentUrl":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-content\/uploads\/2020\/11\/Coacto-Animated-Logo-100-x-50-1.gif","width":100,"height":50,"caption":"Coacto Consultants"},"image":{"@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/person\/bdcc18fee204ba3815045cbb826adb41","name":"Paul Harris","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/98e04fd0e377b705b6ce277b38fcb6746f6e56066d48cb57f860b5f571a85436?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/98e04fd0e377b705b6ce277b38fcb6746f6e56066d48cb57f860b5f571a85436?s=96&d=mm&r=g","caption":"Paul Harris"},"url":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/author\/coacto_editor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/posts\/2732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/comments?post=2732"}],"version-history":[{"count":1,"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/posts\/2732\/revisions"}],"predecessor-version":[{"id":2734,"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/posts\/2732\/revisions\/2734"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/media\/2733"}],"wp:attachment":[{"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/media?parent=2732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/categories?post=2732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.coacto.co.uk\/pre-prod-sandbox\/wp-json\/wp\/v2\/tags?post=2732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}