{"id":1195,"date":"2009-05-29T12:56:00","date_gmt":"2009-05-29T12:56:00","guid":{"rendered":"https:\/\/staging.elixirrdigital.com\/us\/2009\/05\/29\/roi-turning-three-letters-into-big-figures\/"},"modified":"2025-03-05T14:49:59","modified_gmt":"2025-03-05T14:49:59","slug":"roi-turning-three-letters-into-big-figures","status":"publish","type":"post","link":"https:\/\/staging.elixirrdigital.com\/us\/2009\/05\/29\/roi-turning-three-letters-into-big-figures\/","title":{"rendered":"ROI: turning three letters into big figures"},"content":{"rendered":"<p>If you\u2019re going to work in the world of pay per click (PPC), you have to get to grips with endless TLAs (three letter acronyms).<\/p>\n<p>Once you\u2019ve grasped the basics, you\u2019ll know all about <acronym title=\"click through rate\">CTR<\/acronym>, <acronym title=\"cost per click\">CPC<\/acronym> and <acronym title=\"cost per action\">CPA<\/acronym>. But there\u2019s one acronym that isn\u2019t mentioned in Google\u2019s Adwords interface, and it\u2019s the most important of the lot.<\/p>\n<p>ROI.<\/p>\n<p>ROI, or Return on Investment, is overlooked way too frequently. But if you\u2019re optimising a PPC campaign, there\u2019s nothing better to show you which areas of your campaigns are working, and which aren\u2019t.<\/p>\n<p>So how do we work out ROI?<\/p>\n<p><b>How to calculate ROI <\/b><br \/>\nThere are loads of ways to calculate ROI, none of which are wrong. I\u2019m going to show you how I calculate it, and what the final number means.<\/p>\n<p>ROI = <u>(Revenue\u00a0&#8211; Cost)<\/u><br \/>\nCost<\/p>\n<p>This calculation gives a ratio of Revenue generated for every \u00a31 spent. Let\u2019s say you\u2019d spent \u00a31000 on Adwords and generated \u00a35000 in revenue. Your equation would look like this.<\/p>\n<p>ROI = <u>(\u00a35000 &#8211; \u00a31000)<\/u><br \/>\n\u00a31000<\/p>\n<p>This gives you a ROI of 4. So, for every \u00a31 you spent, you generated \u00a34 in revenue.<\/p>\n<p><b>So\u2026 now what?<\/b><br \/>\nUnfortunately Google doesn\u2019t give ROI as an option in its reporting interface. However, if you know your way around Excel, you should have no trouble in using the formula to create a new column in an exported Adwords report.<\/p>\n<p>Once you\u2019ve done this, you can sort your report using the new column and get an instant insight into where your campaign is doing well, and where there\u2019s room for improvement.<\/p>\n<p>For example, if you run a keyword report, add your ROI column and then sort it so the highest ROI is at the top, you\u2019ll easily be able to spot the best performing keywords across your whole campaign.<\/p>\n<p>Top Tip \u2013 look for keywords where ROI is high, and then invest in boosting your average position. If the keyword is working well and has potential to generate more traffic, make sure you up your bid!<\/p>\n<p>As you start scrolling down the list, you\u2019ll see ROI getting closer to\u00a0zero and then dipping\u00a0into negative numbers. Any keywords with a return of less than\u00a0zero \u00a0are costing you money. Pause them, lower their bids, or reassess your ad and landing page.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you\u2019re going to work in the world of pay per click (PPC), you have to get to grips with endless TLAs (three letter acronyms). Once you\u2019ve grasped the basics,&hellip;<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"related_service":[63],"related_industry":[],"class_list":["post-1195","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"card":"<article class=\"wp-component-card wp-component-card--dark wp-component-card--resource wp-component-card--post wp-component-card--full-width wp-component-card--no-image            wp-component-card--link js-card-link\n        \">\n        <div class=\"wp-component-card__content\">\n        <div class=\"wp-component-card__content-top\">\n                                                    <p class=\"wp-component-card__eyebrow\">\n                    Blog                <\/p>\n                        <a href='https:\/\/staging.elixirrdigital.com\/us\/2009\/05\/29\/roi-turning-three-letters-into-big-figures\/'>\n        <h2 class='wp-component-card__title'>\n            ROI: turning three letters into big figures\n        <\/h2>\n    <\/a>        <\/div>\n                    <div class=\"wp-component-card__content-bottom\">\n                                    <div class=\"wp-component-card__description wysiwyg\">\n                        If you\u2019re going to work in the world of pay per click (PPC), you have to get to grips with endless TLAs (three letter acronyms). Once you\u2019ve grasped the basics,&hellip;                    <\/div>\n                                                                    <div class=\"wp-component-card__meta\">\n                                                    <p class=\"wp-component-card__date\">\n                                29 May 2009                            <\/p>\n                                                                            <div class=\"wp-component-card__terms\">\n                                                                                            <div class=\"wp-component-tags__tag\">\n                Search Marketing            <\/div>\n                                                                                                            <\/div>\n                                            <\/div>\n                                            <\/div>\n            <\/div>\n<\/article>\n","_links":{"self":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/posts\/1195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/comments?post=1195"}],"version-history":[{"count":0,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/posts\/1195\/revisions"}],"wp:attachment":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/media?parent=1195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/categories?post=1195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/tags?post=1195"},{"taxonomy":"related_service","embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/related_service?post=1195"},{"taxonomy":"related_industry","embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/related_industry?post=1195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}