{"id":28023,"date":"2018-09-28T16:01:05","date_gmt":"2018-09-28T14:01:05","guid":{"rendered":"https:\/\/www.exoclick.com\/api-master-class-3-campaign-performance\/"},"modified":"2018-09-28T16:04:41","modified_gmt":"2018-09-28T14:04:41","slug":"api-master-class-3-campaign-performance","status":"publish","type":"post","link":"https:\/\/www.exoclick.com\/de\/api-master-class-3-campaign-performance\/","title":{"rendered":"API Master Class #3 Campaign Performance"},"content":{"rendered":"

Welcome to our final API Masterclass! In Part 1 we covered Data Collection<\/a>, in Part 2 we explained Zone Optimization<\/a>. In this third API Masterclass, we show you how to evaluate the performance of your campaigns then automatically adjust (up or down) your bids for each one. The aim is for you as an advertiser to use our examples to help get you started using the API and then later, when you feel more confident you can start creating your own examples and tasks.<\/p>\n

The spreadsheet<\/strong>
\nFor this tutorial, we will be using two of the sheets on this spreadsheet<\/a>: \u2018Campaign Performance\u2019 and \u2018Mock Affiliate Network Data\u2019. The purpose of the spreadsheet is to help you compare campaign data. In addition, some formulas have been supplied in order to estimate new bid values which we will demonstrate in Part 2 of this blog post.\u00a0The relevant information that you will need from the \u2018Mock Affiliate Network Data\u2019 sheet (orange) is some fake data which you can substitute with real data later once you are familiar with how this process works.<\/p>\n

\"\"<\/p>\n

So let\u2019s get started!<\/p>\n

Step 1<\/strong>
\nIn order to use ExoClick\u2019s API, you must set a Session Token. To set a token, you must have a valid account with the required username and password. The API Token creation is available from the API tab within the Admin Panel.<\/p>\n

\"\"<\/p>\n

Step 2<\/strong>
\nCopy the spreadsheet<\/a> to your Google Drive and then open it. All of the API coding is done using Google script language, so when you open the spreadsheet simply go to the Tools menu and select Script Editor.<\/p>\n

Step 3<\/strong>
\nOpen the \u2018Campaign Performance\u2019 sheet and copy and paste your API token in the spreadsheet as shown in the diagram below.<\/p>\n

\"\"<\/p>\n

Part 1 – Get Campaign Data<\/strong><\/p>\n

Step 4<\/strong>
\nNow set the date parameters by adding them into the date fields (Date from, Date to). This will establish the period from which you wish to request the data.<\/p>\n

Step 5<\/strong>
\nNow you can filter your results by cost using \u2018ascending\u2019 or \u2018descending\u2019 modes by clicking on the field Order by [asc-dec]: In our example, we have chosen ‘d’ for descending. Then select how many campaigns you wish to pull data for by inserting a number value in the Limit field. In our spreadsheet example we have put the Limit at 2, this will pull data for the 2 campaigns we have spent the most money on, because the deciding parameter here is Cost. But you can select as many as you want, however, we recommend you concentrate on the bigger spend campaigns.<\/p>\n

Step 6<\/strong>
\nThen simply click on the Generate Data button on the spreadsheet and the data will be displayed as in our example below:<\/p>\n

\"\"<\/p>\n

Part 2 – Update Your Bids<\/strong>
\nThis function allows you to update +\/- the bid depending on the data comparison and calculations done in Part 1.<\/p>\n

Here is an example of the 2 campaigns we pulled to show you how the formulas work:<\/p>\n

\"\"<\/p>\n

In our 2 campaigns you will see that all the green coloured header fields are now filled with the data for that campaign: Campaign ID, Campaign name, Ad Type, Price Model, Bid, Clicks, Impressions, Goals and Cost. As we mentioned before, the orange\u00a0header fields have been pulled with the mock data from the Affiliate Network, these are your variables. The magenta coloured header fields contain the calculation: D Cost calculates the difference between the campaign\u2019s cost versus the external affiliate cost and D% Cost is the same but in %. In this example you will see it is negative or positive, in this first campaign it is negative at -9.58%. When this value is negative, it means you have to lower your bid, when it is positive you need to put the bid higher. This sheet automatically calculates the new bid for you which you can see under Estimated Value Change.<\/p>\n

Step 7 –\u00a0How to update the bid with the API<\/strong><\/p>\n

To the far right of the spreadsheet you will see the purple header fields, which contain the CID, New Bid and Response Message. The CID is the campaign id that needs to be added manually, the New Bid is a calculation between Current Bid (green) and Estimated Value Change (magenta). Then click the large Update Bid button and the API will automatically adjust your bid price. If the bid has been correctly updated the Response Message will be (\u201cCampaign successfully updated\u201d)<\/p>\n

\"\"<\/p>\n

Now, why don\u2019t you try with some real data and see how ExoClick\u2019s API can help you adjust your bids to help you drive those conversions for your offers.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this third API Masterclass, we show you how to evaluate the performance of your campaigns then automatically adjust (up or down) your bids for each one.<\/p>\n","protected":false},"author":20,"featured_media":28014,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[155,90,142],"tags":[],"yoast_head":"\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\t\n\t\n\t\n