{"id":7204,"date":"2016-07-13T11:45:08","date_gmt":"2016-07-13T11:45:08","guid":{"rendered":"https:\/\/www.process.st\/templates\/optimising-exoclick-accounts\/"},"modified":"2024-02-28T17:47:49","modified_gmt":"2024-02-28T17:47:49","slug":"optimising-exoclick-accounts","status":"publish","type":"post","link":"https:\/\/www.process.st\/templates\/optimising-exoclick-accounts\/","title":{"rendered":"Optimising Exoclick Accounts"},"content":{"rendered":"
\n

Log - in to Voluum and Exoclick (through RDP) <\/h2>\n
\n

https:\/\/panel.voluum.com\/login\/<\/a><\/p>\n<\/p><\/div>\n<\/section>\n

\n

In Voluum, Click Campaigns <\/h2>\n
\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n<\/section>\n
\n

Look for the Campaign to optimise. Set the Variables. <\/h2>\n
\n
\n <\/a>
\n Using the search option, look for the Account you need to optimise. eg: Stephen. All of Stephen's campaigns will show up.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Double click on the campaign to optimise.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n The campaign will open in a new tab. Click on the date range you want to optimise. eg: custom date range. Set the start and end date.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Click Variables and choose V3:Domain. The sites will show up.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n<\/section>\n
\n

Export CSV <\/h2>\n
\n
\n <\/a>
\n Click Export CSV.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n<\/section>\n
\n

Rules: <\/h2>\n
\n

1. All visits above 30, 0 clicks.<\/p>\n

2. All visits above 30, more than 1 click, 0 conversions and less profit. (profit = Pay-out x -3)<\/p>\n

3. All with more than 1 click, more than 1 conversion, less profit and EPV.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Filter the sites to Block. (1) <\/h2>\n
\n

An Excel Sheet will be downloaded. Open the Excel.<\/strong><\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n On the Data Tab, Click Filter.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Click the arrow button beside clicks.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Deselect all and tick 0.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n

Copy all sites with above 30 visits and paste on the notepad.<\/strong><\/p>\n<\/p><\/div>\n<\/section>\n

\n

Filter the sites to Block (2) <\/h2>\n
\n
\n <\/a>
\n Click the arrow besides click again, choose Number Filters, choose Greater Than or Equal To. Type 1. Click ok.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Click the arrow beside Conversions. Deselect all and tick 0.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Click on the arrow button beside profit, choose Number Filter, choose Less than or Equal to. Type the amount (pay-out x -3). Click OK **Note: Check Voluum for pay-out amount and multiply it by -3.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n

Copy the sites with more than 30 visits and paste\/add to the list on Notepad.<\/strong><\/p>\n<\/p><\/div>\n<\/section>\n

\n

Filter the sites to Block (3) <\/h2>\n
\n
\n <\/a>
\n Click on conversion, choose Number Filters, choose Greater Than or Equal To. Type 1. Click OK.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Click the arrow for EPV, choose number filters, choose less than or Equal To. Type the CPV amount. Click OK. **Note: CPV = eCPM\/1000. eCPM is found on exoclick.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Filter profit again.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n

Copy the sites and add to the list on Notepad.<\/p>\n

**Note: doublecheck the cost on Exoclick to verify the profit.<\/p>\n<\/p><\/div>\n<\/section>\n

\n

Adding (-) on the sites to block <\/h2>\n
\n

Copy and paste the sites on Notepad ++ or Sublime<\/p>\n<\/p><\/div>\n

\n

For Notepad++: <\/strong>Press Ctrl +H.<\/strong><\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n Type ^ in Find what and - in Replace with. Make sure the regular expression is ticked. Click Replace All.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n It should look like this.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n

For Sublime: <\/strong>Press Command+Shift+F.<\/strong><\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n Type - in Replace.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Click Replace.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n It should look like this.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n<\/section>\n
\n

Copy the sites to block and paste in exoclick. <\/h2>\n
\n
\n <\/a>
\n Click Campaigns.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Look for the campaign you are optimising and click on the edit icon.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Click on the 6-Advance Settings
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Go to Domain Targeting and paste the sites to be blocked.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n Click Save Campaign.
\n <\/figcaption><\/figure>\n<\/p><\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"

Log - in to Voluum and Exoclick (through RDP) https:\/\/panel.voluum.com\/login\/ In Voluum, Click Campaigns Look for the Campaign to optimise. Set the Variables. Using the search option, look for the Account you need to optimise. eg: Stephen. All of Stephen's campaigns will show up. Double click on the campaign to optimise. The campaign will open […]<\/p>\n","protected":false},"author":3,"featured_media":7205,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ep_exclude_from_search":false,"cover_icon_emoji":"","cover_icon_url":"","tasks_count":"10","template_description":"","template_id":"j48cg-02ux6vAhNuOh1DJw","task_0":"Log - in to Voluum and Exoclick (through RDP)","task_slug_0":"log--in-to-voluum-and-exoclick-through-rdp","task_1":"In Voluum, Click Campaigns","task_slug_1":"in-voluum-click-campaigns","task_2":"Look for the Campaign to optimise. Set the Variables.","task_slug_2":"look-for-the-campaign-to-optimise-set-the-variables","task_3":"Export CSV","task_slug_3":"export-csv","task_4":"Rules:","task_slug_4":"rules","task_5":"Filter the sites to Block. (1)","task_slug_5":"filter-the-sites-to-block-1","task_6":"Filter the sites to Block (2)","task_slug_6":"filter-the-sites-to-block-2","task_7":"Filter the sites to Block (3)","task_slug_7":"filter-the-sites-to-block-3","task_8":"Adding (-) on the sites to block","task_slug_8":"adding--on-the-sites-to-block","task_9":"Copy the sites to block and paste in exoclick.","task_slug_9":"copy-the-sites-to-block-and-paste-in-exoclick","task_10":"","task_slug_10":"","task_11":"","task_slug_11":"","task_12":"","task_slug_12":"","task_13":"","task_slug_13":"","task_14":"","task_slug_14":"","task_15":"","task_slug_15":"","task_16":"","task_slug_16":"","task_17":"","task_slug_17":"","task_18":"","task_slug_18":"","task_19":"","task_slug_19":"","task_20":"","task_slug_20":"","task_21":"","task_slug_21":"","task_22":"","task_slug_22":"","task_23":"","task_slug_23":"","task_24":"","task_slug_24":"","task_25":"","task_slug_25":"","task_26":"","task_slug_26":"","task_27":"","task_slug_27":"","task_28":"","task_slug_28":"","task_29":"","task_slug_29":"","task_30":"","task_slug_30":"","task_31":"","task_slug_31":"","task_32":"","task_slug_32":"","task_33":"","task_slug_33":"","task_34":"","task_slug_34":"","task_35":"","task_slug_35":"","task_36":"","task_slug_36":"","task_37":"","task_slug_37":"","task_38":"","task_slug_38":"","task_39":"","task_slug_39":"","task_40":"","task_slug_40":"","task_41":"","task_slug_41":"","task_42":"","task_slug_42":"","task_43":"","task_slug_43":"","task_44":"","task_slug_44":"","task_45":"","task_slug_45":"","task_46":"","task_slug_46":"","task_47":"","task_slug_47":"","task_48":"","task_slug_48":"","task_49":"","task_slug_49":"","task_50":"","task_slug_50":"","task_51":"","task_slug_51":"","task_52":"","task_slug_52":"","task_53":"","task_slug_53":"","task_54":"","task_slug_54":"","task_55":"","task_slug_55":"","task_56":"","task_slug_56":"","task_57":"","task_slug_57":"","task_58":"","task_slug_58":"","task_59":"","task_slug_59":"","task_60":"","task_slug_60":"","task_61":"","task_slug_61":"","task_62":"","task_slug_62":"","task_63":"","task_slug_63":"","task_64":"","task_slug_64":"","task_65":"","task_slug_65":"","task_66":"","task_slug_66":"","task_67":"","task_slug_67":"","task_68":"","task_slug_68":"","task_69":"","task_slug_69":"","task_70":"","task_slug_70":"","task_71":"","task_slug_71":"","task_72":"","task_slug_72":"","task_73":"","task_slug_73":"","task_74":"","task_slug_74":"","task_75":"","task_slug_75":"","task_76":"","task_slug_76":"","task_77":"","task_slug_77":"","task_78":"","task_slug_78":"","task_79":"","task_slug_79":"","task_80":"","task_slug_80":"","task_81":"","task_slug_81":"","task_82":"","task_slug_82":"","task_83":"","task_slug_83":"","task_84":"","task_slug_84":"","task_85":"","task_slug_85":"","task_86":"","task_slug_86":"","task_87":"","task_slug_87":"","task_88":"","task_slug_88":"","task_89":"","task_slug_89":"","task_90":"","task_slug_90":"","task_91":"","task_slug_91":"","task_92":"","task_slug_92":"","task_93":"","task_slug_93":"","task_94":"","task_slug_94":"","task_95":"","task_slug_95":"","task_96":"","task_slug_96":"","task_97":"","task_slug_97":"","task_98":"","task_slug_98":"","task_99":"","task_slug_99":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-7204","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-miscellaneous"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/7204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/comments?post=7204"}],"version-history":[{"count":0,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/7204\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media\/7205"}],"wp:attachment":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media?parent=7204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/categories?post=7204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/tags?post=7204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}