{"id":184,"date":"2022-06-16T07:50:26","date_gmt":"2022-06-16T07:50:26","guid":{"rendered":"https:\/\/giuliopulino.com\/?p=184"},"modified":"2022-07-30T11:24:22","modified_gmt":"2022-07-30T11:24:22","slug":"telecom_project","status":"publish","type":"post","link":"https:\/\/giuliopulino.com\/index.php\/2022\/06\/16\/telecom_project\/","title":{"rendered":"Telecom Customer Churn Challenge"},"content":{"rendered":"\n<p>For this challenge, you&#8217;ll be assuming the role of a BI Consultant for&nbsp;<strong>Maven Communications<\/strong>, a California-based Telecommunications company.<\/p>\n\n\n\n<p>You&#8217;ve been hired to help the company&nbsp;<strong>improve retention by identifying high value customers and churn risks<\/strong>, and have been asked to present your findings to the CMO in the form of a single page report or dashboard.<\/p>\n\n\n\n<h2>About the dataset<\/h2>\n\n\n\n<p>This dataset contains&nbsp;<strong>2 tables<\/strong>, in CSV format:<\/p>\n\n\n\n<ul><li>The&nbsp;<em><strong>Customer Churn<\/strong><\/em>&nbsp;table contains information on all 7,043 customers from a Telecommunications company in California in Q2 2022<\/li><li>Each record represents one customer, and contains details about their demographics, location, tenure, subscription services, status for the quarter (joined, stayed, or churned), and more!<\/li><li>The&nbsp;<em><strong>Zip Code Population<\/strong><\/em>&nbsp;table contains complimentary information on the estimated populations for the California zip codes in the Customer Churn table<\/li><\/ul>\n\n\n\n<h2>Let&#8217;s Start !!<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>NB:<\/strong> For this challenge the dataset is already cleaned, so we&#8217;ll start directly with the analysis. <\/p>\n\n\n\n<p>There will be a query with a comment explaining what I&#8217;m calculating followed by an image (the MySQL tab result and an excel visualization to show the data).<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Before  creating the dashboard the first thing I do is analyze the dataset in MySQL.<\/p>\n\n\n\n<p>Let&#8217;s have a look at the dataset:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM customer_churn;\n<\/pre><\/div>\n\n\n<h4>Now, we can start with our exploratory analysis.<\/h4>\n\n\n\n<p>Scroll to the right for the full query<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Calculate the number of new, active and churned customers.\nSELECT\n\tCOUNT(CASE WHEN customer_status = &quot;Stayed&quot; THEN 1 ELSE NULL END) AS active_customers,\n    COUNT(CASE WHEN customer_status = &quot;Churned&quot; THEN 1 ELSE NULL END) AS churned_customers,\n    COUNT(CASE WHEN customer_status = &quot;Joined&quot; THEN 1 ELSE NULL END) AS new_customers\nFROM customer_churn;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"724\" height=\"104\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_1_SQL.png\" alt=\"\" class=\"wp-image-303\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_1_SQL.png 724w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_1_SQL-300x43.png 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><figcaption>MySQL Result<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"996\" height=\"422\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_1.png\" alt=\"\" class=\"wp-image-301\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_1.png 996w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_1-300x127.png 300w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_1-768x325.png 768w\" sizes=\"(max-width: 996px) 100vw, 996px\" \/><figcaption>Excel View<\/figcaption><\/figure>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Calculate how churned customers are affecting our revenue\nSELECT \n\tcustomer_status,\n\tROUND(SUM(total_revenue),0) AS revenue\nFROM customer_churn\nGROUP BY 1\nORDER BY 2 DESC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"370\" height=\"170\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_revenue_SQL.png\" alt=\"\" class=\"wp-image-330\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_revenue_SQL.png 370w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_revenue_SQL-300x138.png 300w\" sizes=\"(max-width: 370px) 100vw, 370px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"456\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/revenue_view-1024x456.png\" alt=\"\" class=\"wp-image-331\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/revenue_view-1024x456.png 1024w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/revenue_view-300x134.png 300w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/revenue_view-768x342.png 768w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/revenue_view.png 1086w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Total revenue is around $21 Mil, the churned revenue is $3.7 Mil.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>How long does a customer stay before to churn?<\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- number of churned customers by month\nSELECT\n\ttenure_in_months,\n    COUNT(customer_id) AS total_churned_customers\nFROM customer_churn\nWHERE customer_status = &quot;Churned&quot;\nGROUP BY 1\nORDER BY 2 DESC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"562\" height=\"274\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_4_SQL.png\" alt=\"\" class=\"wp-image-311\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_4_SQL.png 562w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_4_SQL-300x146.png 300w\" sizes=\"(max-width: 562px) 100vw, 562px\" \/><\/figure>\n\n\n\n<p>380 customers on a total of 1869 churned customers leave in the first month, it means the 20% and almost 40% in the first 5 months.<\/p>\n\n\n\n<p>So now we know the total of churned customers, how much they affect our revenue and we know that most of them churn in the first months. <\/p>\n\n\n\n<p>Let&#8217;s continue.<\/p>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Churned Customers by Category\nSELECT\n\tchurn_category,\n    COUNT(customer_id) AS total\nFROM customer_churn\nWHERE customer_status = &quot;Churned&quot;\nGROUP BY 1\nORDER BY 2 DESC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"506\" height=\"230\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_5_SQL.png\" alt=\"\" class=\"wp-image-314\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_5_SQL.png 506w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_5_SQL-300x136.png 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--Churned Customers by Reason\nSELECT\n\tchurn_reason,\n    COUNT(customer_id) AS total\nFROM customer_churn\nWHERE customer_status = &quot;Churned&quot;\nGROUP BY 1\nORDER BY 2 DESC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"608\" height=\"244\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_6_SQL.png\" alt=\"\" class=\"wp-image-316\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_6_SQL.png 608w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_6_SQL-300x120.png 300w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/figure>\n\n\n\n<p>The main reason customers churn is due to competitors, based on customers&#8217; reasons, competitors offer better devices and offer better deals.<\/p>\n\n\n\n<p>Another reason to note is the attitude of the customer support.<\/p>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Churned customers by Internet Type\nSELECT\n\tinternet_type,\n    COUNT(customer_id) AS total\nFROM customer_churn\nWHERE customer_status = &quot;Churned&quot; AND internet_type != &quot;&quot;\nGROUP BY 1\nORDER BY 2 DESC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"386\" height=\"186\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_7_SQL.png\" alt=\"\" class=\"wp-image-317\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_7_SQL.png 386w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_7_SQL-300x145.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/figure>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Churned customers by Type of Contract\nSELECT\n\tcontract,\n    COUNT(customer_id) AS total\nFROM customer_churn\nWHERE customer_status = &quot;Churned&quot;\nGROUP BY 1\nORDER BY 2 DESC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"386\" height=\"186\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_8_SQL.png\" alt=\"\" class=\"wp-image-318\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_8_SQL.png 386w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_8_SQL-300x145.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/figure>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Churned customers by city\nSELECT\n\tcity,\n    COUNT(customer_id) AS total\nFROM customer_churn\nWHERE customer_status = &quot;Churned&quot;\nGROUP BY 1\nORDER BY 2 DESC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"386\" height=\"186\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_9_SQL.png\" alt=\"\" class=\"wp-image-319\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_9_SQL.png 386w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_9_SQL-300x145.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/figure>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Offer type for churned customers\nSELECT\n\toffer,\n    COUNT(customer_id) AS total\nFROM customer_churn\nWHERE customer_status = &quot;Churned&quot;\nGROUP BY 1\nORDER BY 2 DESC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"346\" height=\"186\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_10_SQL.png\" alt=\"\" class=\"wp-image-320\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_10_SQL.png 346w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/view_10_SQL-300x161.png 300w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/figure>\n\n\n\n<p>We can see also as the major of churned customers have the Fiber Optic, a month-to-month subscription, are from San Diego and Los Angeles and they have the &#8220;Offer E&#8221; or not offer at all.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n\n\n\n<p>So far we have an overview of what are the top reasons and other info of the churned customers, now let&#8217;s analyze the high-value customers.<\/p>\n\n\n\n<p>First of all, we have to define who is a &#8220;High-Value Customer&#8221;, we&#8217;ll use these parameters:<\/p>\n\n\n\n<ul><li>total revenue &gt; 3000<\/li><li>monthly charge &gt;= 85<\/li><li>customer status = &#8220;Stayed&#8221;<\/li><\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- High Value Customers\nSELECT\n\tcustomer_id\nFROM customer_churn\nWHERE \n    total_revenue &gt; 3000 AND\n    monthly_charge &gt;= 85 AND\n    customer_status = &quot;Stayed&quot;;\n<\/pre><\/div>\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n\n\n\n<p>Now that we have the list of all our High Value Customers, we can use this list to go deeper, see where these customers live, what type of contract they have, subscriptions of extra services, etc.<\/p>\n\n\n\n<p>We can create a temporary table with the above query and then we can join it with the &#8220;customer_churn&#8221; table to see from which city they are from.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Create the temporary table with the high value customers\nCREATE TEMPORARY TABLE high_value_customers\nSELECT\n\tcustomer_id\nFROM customer_churn\nWHERE \n    total_revenue &gt; 3000 AND\n    monthly_charge &gt;= 85 AND\n    customer_status = &quot;Stayed&quot;;\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Join the high value customer table with the customer churn table\nSELECT\n\tcc.city,\n    COUNT(hvc.customer_id) AS total\nFROM customer_churn cc\n\tLEFT JOIN high_value_customers hvc\n\t\tON cc.customer_id = hvc.customer_id\nGROUP BY 1\nORDER BY 2 DESC\nLIMIT 3;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"272\" height=\"166\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/Schermata-2022-07-29-alle-16.08.03.png\" alt=\"\" class=\"wp-image-784\"\/><\/figure>\n\n\n\n<p>Now we can use the last query, changing the voice &#8220;city&#8221;, with what we want to check, for example, &#8220;Type of contract&#8221;, &#8220;Revenue&#8221;, etc.<\/p>\n\n\n\n<p>Because the query will be the same as above except for the first voice I&#8217;ll avoid to repeat the query.<\/p>\n\n\n\n<p>Finally, we have some interesting info to understand why customers churn and who are our high value customers so we can proceed to create the dashboard to present to the CTO with our recommendations.<\/p>\n\n\n\n<p>The dashboard will show the key points, such as the number of customers for each category, the revenue, what are the reasons why customers churn and lastly our recommendations.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p> The dashboard it&#8217;s available at the following link: <a href=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiZWUyZjEyMDAtYzYxNy00MmE3LWIzY2UtODI4N2U5MzEzM2U2IiwidCI6IjgwMmU1MTg5LTdhYWYtNGY0MC1hY2QzLTQ3MWM4ZTBkMjhiMiIsImMiOjl9&amp;pageName=ReportSection\" target=\"_blank\" rel=\"noopener\"> View Dashboard <\/a> <\/p>\n\n\n\n<p>Dashboard preview:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" width=\"1024\" height=\"542\" src=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/Schermata-2022-07-23-alle-15.30.27-1024x542.png\" alt=\"\" class=\"wp-image-545\" srcset=\"https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/Schermata-2022-07-23-alle-15.30.27-1024x542.png 1024w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/Schermata-2022-07-23-alle-15.30.27-300x159.png 300w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/Schermata-2022-07-23-alle-15.30.27-768x406.png 768w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/Schermata-2022-07-23-alle-15.30.27-1536x813.png 1536w, https:\/\/giuliopulino.com\/wp-content\/uploads\/2022\/07\/Schermata-2022-07-23-alle-15.30.27-2048x1084.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Thanks for your time.<\/p>\n\n\n\n<p>Giulio Pulino.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<a href=\"https:\/\/giuliopulino.com\/index.php\/portfolio\/\"> Back to portfolio <\/a>\n","protected":false},"excerpt":{"rendered":"<p>For this challenge, you&#8217;ll be assuming the role of a BI Consultant for&nbsp;Maven Communications, a California-based Telecommunications company. You&#8217;ve been hired to help the company&nbsp;improve retention by identifying high value customers and churn risks, and have been asked to present your findings to the CMO in the form of a single page report or dashboard. &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/giuliopulino.com\/index.php\/2022\/06\/16\/telecom_project\/\"> <span class=\"screen-reader-text\">Telecom Customer Churn Challenge<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/posts\/184"}],"collection":[{"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/comments?post=184"}],"version-history":[{"count":70,"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/posts\/184\/revisions"}],"predecessor-version":[{"id":873,"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/posts\/184\/revisions\/873"}],"wp:attachment":[{"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/media?parent=184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/categories?post=184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/giuliopulino.com\/index.php\/wp-json\/wp\/v2\/tags?post=184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}