{"id":6805,"date":"2020-04-21T15:33:00","date_gmt":"2020-04-21T15:33:00","guid":{"rendered":"https:\/\/begradient.com\/?p=6805"},"modified":"2022-10-12T14:29:13","modified_gmt":"2022-10-12T14:29:13","slug":"efficienter-advertising-campagnes-bouwen-met-excel-7-tips","status":"publish","type":"post","link":"https:\/\/begradient.com\/en\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/","title":{"rendered":"Building advertising campaigns more efficiently with Excel: 7 tips"},"content":{"rendered":"<div class=\"elementor-element elementor-element-93e2091 elementor-widget elementor-widget-text-editor\" data-id=\"93e2091\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<div data-id=\"93e2091\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div>\n<div>\n<p>There it is! Part 2 in the series featuring smarts for automating a multi-channel campaign setup.&nbsp;In&nbsp;part 1, we took you through the reason for and process of automating.&nbsp;Now it gets really interesting for the techies and Excel enthusiasts among us.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-05995ea elementor-widget elementor-widget-heading\" data-id=\"05995ea\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h2 class=\"elementor-heading-title elementor-size-default\">In this article<\/h2>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-c13c49a elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"c13c49a\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n<div class=\"elementor-widget-container\">\n<ul class=\"elementor-icon-list-items\">\n<li class=\"elementor-icon-list-item\"><a href=\"https:\/\/begradient.com\/verhalen\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#anker1\"><i class=\"far fa-arrow-alt-circle-right\" aria-hidden=\"true\"><\/i><span class=\"elementor-icon-list-text\">VLOOKUP (or VERT.ZOEKEN)<\/span><\/a><\/li>\n<li class=\"elementor-icon-list-item\"><a href=\"https:\/\/begradient.com\/verhalen\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#anker2\"><i class=\"far fa-arrow-alt-circle-right\" aria-hidden=\"true\"><\/i><span class=\"elementor-icon-list-text\">VLOOKUP for location targeting.<\/span><\/a><\/li>\n<li class=\"elementor-icon-list-item\"><a href=\"https:\/\/begradient.com\/verhalen\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#anker3\"><i class=\"far fa-arrow-alt-circle-right\" aria-hidden=\"true\"><\/i><span class=\"elementor-icon-list-text\">Data validation<\/span><\/a><\/li>\n<li class=\"elementor-icon-list-item\"><a href=\"https:\/\/begradient.com\/verhalen\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#anker4\"><i class=\"far fa-arrow-alt-circle-right\" aria-hidden=\"true\"><\/i><span class=\"elementor-icon-list-text\">Conditional data validation<\/span><\/a><\/li>\n<li class=\"elementor-icon-list-item\"><a href=\"https:\/\/begradient.com\/verhalen\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#anker5\"><i class=\"far fa-arrow-alt-circle-right\" aria-hidden=\"true\"><\/i><span class=\"elementor-icon-list-text\">Data validation with multiple selections<\/span><\/a><\/li>\n<li class=\"elementor-icon-list-item\"><a href=\"https:\/\/begradient.com\/verhalen\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#anker6\"><i class=\"far fa-arrow-alt-circle-right\" aria-hidden=\"true\"><\/i><span class=\"elementor-icon-list-text\">Conditional formatting<\/span><\/a><\/li>\n<li class=\"elementor-icon-list-item\"><a href=\"https:\/\/begradient.com\/verhalen\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#anker7\"><i class=\"far fa-arrow-alt-circle-right\" aria-hidden=\"true\"><\/i><span class=\"elementor-icon-list-text\">Other example of ALS cell contains text<\/span><\/a><\/li>\n<li class=\"elementor-icon-list-item\"><a href=\"https:\/\/begradient.com\/verhalen\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#anker8\"><i class=\"far fa-arrow-alt-circle-right\" aria-hidden=\"true\"><\/i><span class=\"elementor-icon-list-text\">What does blog 3 say?<\/span><\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-2c0e3c7 elementor-widget elementor-widget-menu-anchor\" data-id=\"2c0e3c7\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n<div class=\"elementor-widget-container\">\n<div id=\"anker1\" class=\"elementor-menu-anchor\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-2269cf2 elementor-widget elementor-widget-heading\" data-id=\"2269cf2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h2 class=\"elementor-heading-title elementor-size-default\">VLOOKUP (or VERT.ZOEKEN)<\/h2>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-24390b5 elementor-widget elementor-widget-text-editor\" data-id=\"24390b5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Remember how we ended the previous post with the image below and the question of how to convert this&nbsp;information? So how do you make sure that &#8220;Utrecht&#8221; automatically becomes &#8220;UT&#8221; and &#8220;Autumn&#8221; is shortened to &#8220;NJ&#8221;?<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-ed0bf80 elementor-widget elementor-widget-image\" data-id=\"ed0bf80\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img fetchpriority=\"high\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_informatie_omzetten-1024x511.png\" sizes=\"(max-width: 750px) 100vw, 750px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_informatie_omzetten-1024x511.png 1024w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_informatie_omzetten-300x150.png 300w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_informatie_omzetten-768x383.png 768w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_informatie_omzetten-1536x766.png 1536w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_informatie_omzetten.png 1828w\" alt=\"\" width=\"750\" height=\"374\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-1b6ca83 elementor-widget elementor-widget-text-editor\" data-id=\"1b6ca83\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Right! Using the FLOOKUP (or VERTICAL SEARCH) function.&nbsp;This function retrieves a value in a column and then returns the value of another cell in the same row. To make use of this, we first created an auxiliary table in which all possible lookup values (in this example, place names) correspond to the appropriate result values (in our case, these are the abbreviations of the place names).<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-d36badb elementor-widget elementor-widget-image\" data-id=\"d36badb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_vlookup.png\" sizes=\"(max-width: 442px) 100vw, 442px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_vlookup.png 442w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_vlookup-300x190.png 300w\" alt=\"\" width=\"442\" height=\"280\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-29b9d46 elementor-widget elementor-widget-text-editor\" data-id=\"29b9d46\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p><strong>The syntax for this function is VERT.SEARCH(value, range, index, [is_gesorteerd]).<\/strong>&nbsp;When you enter it for our particular case, you get VERT.SEARCH(C3,H2:I8,2,False).<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-c3ecc1a elementor-widget elementor-widget-image\" data-id=\"c3ecc1a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_verticaalzoeken.png\" sizes=\"(max-width: 666px) 100vw, 666px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_verticaalzoeken.png 666w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_verticaalzoeken-300x46.png 300w\" alt=\"\" width=\"666\" height=\"102\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-4efe187 elementor-widget elementor-widget-text-editor\" data-id=\"4efe187\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<ol>\n<li>Cell C3 is the value &#8220;Utrecht&#8221; that we are going to look up in the table.<\/li>\n<li>This value is looked up in the table with ranges H2 through I8.<\/li>\n<li>If there is a match, the value from the second column (column I) is then returned.<\/li>\n<li>The value [is_gesorteerd] can be TRUE (or 0) or TRUE (or 1) are. If you want to find an exact match between lookup value and result value enter 0 or FALSE here.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-c80e5f3 elementor-widget elementor-widget-text-editor\" data-id=\"c80e5f3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Et voil\u00e0, with this formula we conjure up &#8220;UT.&#8221; When you change cell C3 to another place name, for example, Amsterdam, the output changes to &#8220;AM.&#8221; We can repeat the same trick for edition, so that the input &#8220;Spring&#8221; is always displayed as &#8220;VJ&#8221; and &#8220;Autumn&#8221; is displayed as &#8220;NJ&#8221;.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-abaea80 elementor-widget elementor-widget-text-editor\" data-id=\"abaea80\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>When we combine these formulas all together, we get =C2&amp;&#8221;_&#8221;&amp;C4&amp;&#8221;_&#8221;&amp;VERT.SEARCH(C3,H2:I8,2,TRUE)&amp;&#8221;_&#8221;&amp;VERT.SEARCH(C5,!H11:I13,2,TRUE). This produces as output Dutch Heroes Comic Con_2019_UT_NJ. With another fair, another year, another place and another edition, the name will also automatically change with it. Not wrong, right?<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-d5ef195 elementor-widget elementor-widget-text-editor\" data-id=\"d5ef195\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>In addition to this somewhat technical knack, we have many other automations and smarts built into the spreadsheet. We&#8217;ll take you through that, too.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-5332b7c elementor-widget elementor-widget-menu-anchor\" data-id=\"5332b7c\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n<div class=\"elementor-widget-container\">\n<div id=\"anker2\" class=\"elementor-menu-anchor\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-df77324 elementor-widget elementor-widget-heading\" data-id=\"df77324\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h2 class=\"elementor-heading-title elementor-size-default\">VLOOKUP for location targeting.<\/h2>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-41c89bd elementor-widget elementor-widget-text-editor\" data-id=\"41c89bd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Starting with the VLOOKUP just discussed. In fact, we use these in many more places in the document. The Swiss army knife of spreadsheet aficionados. Similarly, we use it to specify campaign location coordinates.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-885f463 elementor-widget elementor-widget-text-editor\" data-id=\"885f463\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>These coordinates are required because the client wants to advertise in a radius around the event location. You can pull this off relatively easily through the Google Ads interface, however, for high volume campaigns, this is quite a time-consuming task.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-bf96809 elementor-widget elementor-widget-text-editor\" data-id=\"bf96809\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Fortunately, there is also a scalable solution; namely, you can look up the relevant latitude and longitude of a location and import it through the Google Ads Editor. Using the table below, we can use this trick to set the right radius targeting for trade shows in different places around the country.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-516cfc4 elementor-widget elementor-widget-image\" data-id=\"516cfc4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_vlookup_locatietargeting.png\" sizes=\"(max-width: 459px) 100vw, 459px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_vlookup_locatietargeting.png 459w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_vlookup_locatietargeting-300x180.png 300w\" alt=\"\" width=\"459\" height=\"276\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-345df69 elementor-widget elementor-widget-text-editor\" data-id=\"345df69\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>With the VLOOKUP formula that you are now familiar with, this allows us to enter the correct coordinates for each place and transmit them linearly to the platform.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-4083752 elementor-widget elementor-widget-menu-anchor\" data-id=\"4083752\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n<div class=\"elementor-widget-container\">\n<div id=\"anker3\" class=\"elementor-menu-anchor\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-f6f15f8 elementor-widget elementor-widget-heading\" data-id=\"f6f15f8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h2 class=\"elementor-heading-title elementor-size-default\">Data validation<\/h2>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-abbd391 elementor-widget elementor-widget-text-editor\" data-id=\"abbd391\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Another gimmick we frequently use in our document is the data validation feature in Google Sheets. This functionality allows you to limit the input to a cell to a range of values you specify. Often this is in the form of a dropdown menu, as shown below in the example from our document.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-7989b86 elementor-widget elementor-widget-image\" data-id=\"7989b86\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_1.png\" alt=\"\" width=\"189\" height=\"287\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-945fdef elementor-widget elementor-widget-text-editor\" data-id=\"945fdef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>How do you set this up? Select your cell and then navigate to&nbsp;<i>Data &gt; Data validation<\/i>. In the section&nbsp;<i>Criteria<\/i>&nbsp;set which choices should appear in the dropdown menu. Here you can enter a list of options yourself or use a list you have put elsewhere in the document.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-d8e2a08 elementor-widget elementor-widget-text-editor\" data-id=\"d8e2a08\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Tip: For cells where the date needs to be entered, you can use&nbsp;<i>Date<\/i>&nbsp;use as criteria. When setting the date, you can then double-click on the cell to easily select the desired date.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-23f16da elementor-widget elementor-widget-image\" data-id=\"23f16da\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_2.png\" sizes=\"(max-width: 272px) 100vw, 272px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_2.png 272w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_2-266x300.png 266w\" alt=\"\" width=\"272\" height=\"307\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-4f7ebaf elementor-widget elementor-widget-text-editor\" data-id=\"4f7ebaf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Like the VLOOKUP, we use the data validation function several times in the document. For the targeting of Display campaigns, where you can choose from over 3,000 (!) audiences, this is also a welcome addition to the document.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-908c266 elementor-widget elementor-widget-text-editor\" data-id=\"908c266\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>To get this working, we put all the possible target groups into separate columns. So you have columns for affinity and in-market audiences as well as topics you can advertise on. By pointing the cell to which you want to apply data validation to one of these columns, you make it very easy to pick out the desired target groups.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-050c493 elementor-widget elementor-widget-text-editor\" data-id=\"050c493\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>A nice functionality here is that the list is automatically refreshed based on the text you enter here (also known as&nbsp;<i>autocomplete<\/i>), so you don&#8217;t have to scour the entire list looking for the right audience.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-d5aa0c2 elementor-widget elementor-widget-text-editor\" data-id=\"d5aa0c2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Are you looking for&nbsp;<i>Trekkies<\/i>&nbsp;or persons who have an affinity for the Skywalker family? Then enter science fiction (or simply science) and autocomplete will complete it:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-858df52 elementor-widget elementor-widget-image\" data-id=\"858df52\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_3.png\" sizes=\"(max-width: 366px) 100vw, 366px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_3.png 366w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_3-300x107.png 300w\" alt=\"\" width=\"366\" height=\"131\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-f0b73d8 elementor-widget elementor-widget-menu-anchor\" data-id=\"f0b73d8\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n<div class=\"elementor-widget-container\">\n<div id=\"anker4\" class=\"elementor-menu-anchor\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-5b2f234 elementor-widget elementor-widget-heading\" data-id=\"5b2f234\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h2 class=\"elementor-heading-title elementor-size-default\">Conditional data validation<\/h2>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-721cc5a elementor-widget elementor-widget-text-editor\" data-id=\"721cc5a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Now that we understand how data validation works, we can move on to advanced data validation; based on one or more conditions. Among other things, we use this in our video campaigns that we run on YouTube.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-e5ef550 elementor-widget elementor-widget-text-editor\" data-id=\"e5ef550\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Creating a video campaign through a spreadsheet is basically quite simple, however, you need a trick to make the process of choosing campaign type and bidding strategy correct. For example, unlike Search and Display, not every bidding strategy can be linked to every campaign type.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-76d1d15 elementor-widget elementor-widget-text-editor\" data-id=\"76d1d15\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>For video campaigns, you can choose from several campaign types, including&nbsp;<i>drive conversions<\/i>,&nbsp;<i>non-skippable<\/i>&nbsp;and&nbsp;<i>outstream<\/i>. The tricky part is that just about every type requires the use of a different bidding strategy. For example, for drive conversions you can choose maximize conversions or target CPA, and for outstream you can deploy only manual CPM.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-5383ab6 elementor-widget elementor-widget-text-editor\" data-id=\"5383ab6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>When picking the campaign type as well as the bidding strategy, you only want to show the bidding strategy options that are actually possible for the chosen campaign type. Fortunately, even this challenge can be solved with a formula. Only this time it is not a standard formula, but an array. A what? An array.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-85e7160 elementor-widget elementor-widget-image\" data-id=\"85e7160\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_array.png\" sizes=\"(max-width: 551px) 100vw, 551px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_array.png 551w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_array-300x300.png 300w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_array-150x150.png 150w\" alt=\"\" width=\"551\" height=\"552\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-284ecc4 elementor-widget elementor-widget-text-editor\" data-id=\"284ecc4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>To start with this, it is useful to first record all possible combinations in the sheet.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-bfd4223 elementor-widget elementor-widget-image\" data-id=\"bfd4223\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_voorwaardelijke_gegevensvalidatie_1.png\" sizes=\"(max-width: 669px) 100vw, 669px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_voorwaardelijke_gegevensvalidatie_1.png 669w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_voorwaardelijke_gegevensvalidatie_1-300x36.png 300w\" alt=\"\" width=\"669\" height=\"80\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-4e0fe71 elementor-widget elementor-widget-text-editor\" data-id=\"4e0fe71\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Next, create the cell where you set data validation for the campaign type. You refer these to the cells where you have noted all possible campaign types (in the case above, H80 to L80).<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-68c13ac elementor-widget elementor-widget-image\" data-id=\"68c13ac\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_voorwaardelijke_gegevensvalidatie_2.png\" alt=\"\" width=\"279\" height=\"178\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-59384af elementor-widget elementor-widget-text-editor\" data-id=\"59384af\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Now you can start creating the array formula. In our case, it looks like this:<\/p>\n<p>=ALS(C74=H80;H81:H82;ALS(C74=I80;I81;ALS(C74=J80;J81;ALS(C74=K80;K81;ALS(C74=L80;L81;\u201d\u201d))))). After entering, remember not to simply press ENTER, but CTRL+SHIFT+ENTER. After all, Mr. array, like your troublesome sister or brother, is someone with a manual of his own. Alternatively, you could wrap the entire formula in an ARRAYFORMULA function. Or in a roll of toilet paper, see what you do.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-47b976b elementor-widget elementor-widget-text-editor\" data-id=\"47b976b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>The above formula may look a bit frightening, but it is actually just a simple nested ALS formula. The formula tries to match cell C74 (the cell containing the campaign type data validation) and H80 through L80 (the cells containing all possible campaign types). If a match is found here, the contents of the cell in row 81 (and in the case of drive conversions rows 81 and 82) become the output of the formula. And you can then use this output again in a second cell with data validation for the bidding strategy. Three cheers!<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-6a12451 elementor-widget elementor-widget-image\" data-id=\"6a12451\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_voorwaardelijke_gegevensvalidatie_3.png\" alt=\"\" width=\"277\" height=\"113\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-e6716c3 elementor-widget elementor-widget-menu-anchor\" data-id=\"e6716c3\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n<div class=\"elementor-widget-container\">\n<div id=\"anker5\" class=\"elementor-menu-anchor\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-d85cdac elementor-widget elementor-widget-heading\" data-id=\"d85cdac\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h2 class=\"elementor-heading-title elementor-size-default\">Data validation with multiple selections<\/h2>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-4c173af elementor-widget elementor-widget-text-editor\" data-id=\"4c173af\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>When setting up data validation, you can only select one option from the list. But what if you want to check more than one? Normally this is impossible, but by using a script it can be done. Just say data validation&nbsp;<i>on steroids<\/i>.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-24ea131 elementor-widget elementor-widget-text-editor\" data-id=\"24ea131\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>The use case for this feature is to target certain counties in Facebook. How can we make sure that you can click on the counties you want to target and not have to type the counties piece by piece into the cell (since the latter is monk work and here, maybe you already figured it out, we don&#8217;t like it)?<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-060fe11 elementor-widget elementor-widget-text-editor\" data-id=\"060fe11\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Before we get going with the script, we first need to set up data validation, as normal via Data &gt; Data Validation. In our case, we refer herein to a cell range containing all Dutch provinces.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-cf86a9c elementor-widget elementor-widget-text-editor\" data-id=\"cf86a9c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Next, we can work on the scripting part. By the way, it&#8217;s actually two scripts, one that takes care of the pop-up window and one that takes care of the actual script. You can find them both at&nbsp;<a href=\"https:\/\/gist.github.com\/coinsandsteeldev\/4c67dfa5411e8add913273fc5a30f5e7\">this link<\/a>&nbsp;(free and for nothing, even we are not the lousy ones) and you install them via Tools &gt; Scripteditor. Once you install them you will find a new menu button called Scripts and a Multi-select sub-button.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-b4b5919 elementor-widget elementor-widget-text-editor\" data-id=\"b4b5919\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Now select the cell in which you set the data validation and click Scripts &gt; Multi-select. A number of windows open in which you give the script access to your spreadsheet. A pop-up will then open on the right side of your screen:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-f0be83e elementor-widget elementor-widget-image\" data-id=\"f0be83e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_meerdereselecties_1.png\" sizes=\"(max-width: 337px) 100vw, 337px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_meerdereselecties_1.png 337w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_meerdereselecties_1-280x300.png 280w\" alt=\"\" width=\"337\" height=\"361\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-07bef16 elementor-widget elementor-widget-text-editor\" data-id=\"07bef16\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>The rest is self-explanatory; check the provinces you want to target and click Set. The selected cell is now automatically populated with all provinces checked, separated by commas. This cell can now be imported 1-to-1 to Facebook Ads. Still, you saved yourself some unnecessary mouse clicks! Your index finger will thank you.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-0b753e5 elementor-widget elementor-widget-image\" data-id=\"0b753e5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_meerdereselecties_2.png\" sizes=\"(max-width: 579px) 100vw, 579px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_meerdereselecties_2.png 579w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_gegevensvalidatie_meerdereselecties_2-300x16.png 300w\" alt=\"\" width=\"579\" height=\"31\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-6bfbf43 elementor-widget elementor-widget-menu-anchor\" data-id=\"6bfbf43\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n<div class=\"elementor-widget-container\">\n<div id=\"anker6\" class=\"elementor-menu-anchor\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-ac4a077 elementor-widget elementor-widget-heading\" data-id=\"ac4a077\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h2 class=\"elementor-heading-title elementor-size-default\">Conditional formatting<\/h2>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-ec54569 elementor-widget elementor-widget-text-editor\" data-id=\"ec54569\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Most of you may already be familiar with conditional formatting. Allows you to format cells (for example, by giving the cell a different color background) based on conditions you set. Google Sheets contains many standard terms that you can select and you can additionally use formulas here.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-8e7e479 elementor-widget elementor-widget-text-editor\" data-id=\"8e7e479\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>We find a practical example of this in our paper when entering the YouTube video URL. This is because it is important to enter the full URL (and not the shortened URL; i.e.&nbsp;https:\/\/www.youtube.com\/watch?v=ENDQUZIX6jI&nbsp;and not&nbsp;<a href=\"https:\/\/www.youtu.be\/ENDQUZIX6jI\">https:\/\/www.youtu.be\/ENDQUZIX6jI)<\/a>. By adding a formatting line like&nbsp;<i>text does not contain<\/i>&nbsp;<i>watch<\/i>&nbsp;make sure the input cell changes color as soon as the URL is entered incorrectly.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-518ada1 elementor-widget elementor-widget-image\" data-id=\"518ada1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_1.png\" sizes=\"(max-width: 302px) 100vw, 302px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_1.png 302w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_1-300x291.png 300w\" alt=\"\" width=\"302\" height=\"293\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-4844fa2 elementor-widget elementor-widget-text-editor\" data-id=\"4844fa2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Thus, a cell with an incorrectly entered URL turns orange:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-757c4e8 elementor-widget elementor-widget-image\" data-id=\"757c4e8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_2.png\" sizes=\"(max-width: 475px) 100vw, 475px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_2.png 475w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_2-300x20.png 300w\" alt=\"\" width=\"475\" height=\"32\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-9925ea1 elementor-widget elementor-widget-text-editor\" data-id=\"9925ea1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>And a cell in which the URL did enter correctly remains yellow:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-281469b elementor-widget elementor-widget-image\" data-id=\"281469b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_3.png\" sizes=\"(max-width: 474px) 100vw, 474px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_3.png 474w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_3-300x19.png 300w\" alt=\"\" width=\"474\" height=\"30\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-3e3567a elementor-widget elementor-widget-text-editor\" data-id=\"3e3567a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>We find another example when entering ad copy for Google Ads. There are all restrictions and rules attached to this; for example, you may not go over a certain character limit and your description lines may not both contain an exclamation point. Faintly, Google.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-46dc7fe elementor-widget elementor-widget-text-editor\" data-id=\"46dc7fe\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>To check that your text is not over the character limit, you can use the formula =30-LENGTH(A1), where you replace the number 30 with the appropriate character limit (30 for headers, 90 for descriptions) and have the text to be checked in cell A1. With a conditional formatting rule, you make sure that all outcomes that are less than 0, i.e., where you have gone over the character limit, are highlighted by a different cell color. The formatting rule then becomes&nbsp;<i>less than or equal to -1<\/i>.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-f4a5b12 elementor-widget elementor-widget-image\" data-id=\"f4a5b12\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_4.png\" sizes=\"(max-width: 312px) 100vw, 312px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_4.png 312w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_4-300x288.png 300w\" alt=\"\" width=\"312\" height=\"300\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-4a160b3 elementor-widget elementor-widget-text-editor\" data-id=\"4a160b3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>In the example below, we went 4 characters over the limit:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-615a6c8 elementor-widget elementor-widget-image\" data-id=\"615a6c8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_5.png\" sizes=\"(max-width: 651px) 100vw, 651px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_5.png 651w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_5-300x13.png 300w\" alt=\"\" width=\"651\" height=\"29\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-be16105 elementor-widget elementor-widget-text-editor\" data-id=\"be16105\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>Removing the word &#8220;Autumn&#8221; puts us back nicely within the limit:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-0a3f80b elementor-widget elementor-widget-image\" data-id=\"0a3f80b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_6.png\" sizes=\"(max-width: 650px) 100vw, 650px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_6.png 650w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_6-300x12.png 300w\" alt=\"\" width=\"650\" height=\"27\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-f059dd2 elementor-widget elementor-widget-text-editor\" data-id=\"f059dd2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>A third practical example of conditional formatting is slightly more complex than the previous two. Indeed, in doing so, we use a formula to detect double exclamation points. In our document, this formula is = IF(ISGETAL(FIND.SPEC(&#8220;!&#8221;;B9));AND(IF(ISGETAL(FIND.SPEC(&#8220;!&#8221;;B10));1;0))).<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-327bb64 elementor-widget elementor-widget-text-editor\" data-id=\"327bb64\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>The combination of ISGETAL and FIND.SPEC allows you to search for certain character or word, in our case the exclamation point. The function AND looks up this character in both cell B9 and B10. And should the exclamation point be found in both cells, the output will be 1, if not, it will be 0. With an output 1, you trigger the conditional formatting rule and the formatting style is applied (in our case, the cell gets an orange background).<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-621a594 elementor-widget elementor-widget-image\" data-id=\"621a594\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_7.png\" sizes=\"(max-width: 304px) 100vw, 304px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_7.png 304w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_7-300x290.png 300w\" alt=\"\" width=\"304\" height=\"294\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-e4f1b0a elementor-widget elementor-widget-text-editor\" data-id=\"e4f1b0a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>With one exclamation point, nothing is wrong:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-94271d7 elementor-widget elementor-widget-image\" data-id=\"94271d7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_8.png\" sizes=\"(max-width: 624px) 100vw, 624px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_8.png 624w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_8-300x22.png 300w\" alt=\"\" width=\"624\" height=\"46\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-3d81870 elementor-widget elementor-widget-text-editor\" data-id=\"3d81870\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>But using two exclamation points makes it clear that you are breaking a rule:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-9ee4898 elementor-widget elementor-widget-image\" data-id=\"9ee4898\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_9.png\" sizes=\"(max-width: 623px) 100vw, 623px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_9.png 623w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_opmaak_9-300x22.png 300w\" alt=\"\" width=\"623\" height=\"45\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-1f0dc57 elementor-widget elementor-widget-text-editor\" data-id=\"1f0dc57\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>So do yourself a favor, make sure your ads are error-free and follow the (formatting) rules nicely. And remove your dt errors right away (am I right, my fellow language Nazis?).<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-2999a67 elementor-widget elementor-widget-menu-anchor\" data-id=\"2999a67\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n<div class=\"elementor-widget-container\">\n<div id=\"anker7\" class=\"elementor-menu-anchor\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-d5824dd elementor-widget elementor-widget-heading\" data-id=\"d5824dd\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h2 class=\"elementor-heading-title elementor-size-default\">Other example of ALS cell contains text<\/h2>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-c3c76bf elementor-widget elementor-widget-text-editor\" data-id=\"c3c76bf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>In addition to detecting double exclamation points, we use the trick in which we combine ISGETAL and VIND.SPEC even more often in the document. Similarly, to match keywords to the right campaign. With this feature, we separate branded from non-branded and trade show or event-related words from the rest, among other things:<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-e76f303 elementor-widget elementor-widget-image\" data-id=\"e76f303\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image\"><img loading=\"lazy\" decoding=\"async\" class=\"attachment-large size-large\" src=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_ALS_tekst.png\" sizes=\"(max-width: 673px) 100vw, 673px\" srcset=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_ALS_tekst.png 673w, https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/voorbeeld_ALS_tekst-300x60.png 300w\" alt=\"\" width=\"673\" height=\"134\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-05593e0 elementor-widget elementor-widget-text-editor\" data-id=\"05593e0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>To make this function a little more readable, we will dissect it:<\/p>\n<ol>\n<li>This section compares the name of the scholarship (entered in the &#8220;General&#8221; tab in cell C2) with the keyword in cell A1. Should a match be found here then the output of the cell becomes &#8220;Branded&#8221;<\/li>\n<li>Should the keyword &#8220;stock market&#8221; (with this you match on both stock market and exchanges) appear in the keyword, the output will be &#8220;Stock Market&#8221;<\/li>\n<li>Should the keyword &#8220;even&#8221; (for a match on both event and event) appear in the keyword, the output will also be &#8220;Scholarship&#8221;<\/li>\n<li>If no match is detected in any of the above cases then the output will be &#8220;General&#8221;<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-5cd0653 elementor-widget elementor-widget-text-editor\" data-id=\"5cd0653\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>With such separation of keywords at the campaign level, you ensure that it is easier to keep track and make better decisions when managing your campaigns. For example, you probably want to set very different budgets and bids for your branded campaigns and your generic campaigns. With this formula, then, you ensure that keywords are assigned to the right campaigns.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-ad21ed4 elementor-widget elementor-widget-menu-anchor\" data-id=\"ad21ed4\" data-element_type=\"widget\" data-widget_type=\"menu-anchor.default\">\n<div class=\"elementor-widget-container\">\n<div id=\"anker8\" class=\"elementor-menu-anchor\"><\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-85c057c elementor-widget elementor-widget-heading\" data-id=\"85c057c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n<div class=\"elementor-widget-container\">\n<h2 class=\"elementor-heading-title elementor-size-default\">What does blog 3 say?<\/h2>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-caea0df elementor-widget elementor-widget-text-editor\" data-id=\"caea0df\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<p>In the next (and final) blog, we cover the latest technical gadgets and briefly look ahead to developments in the future.<\/p>\n<div data-id=\"945fdef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<ul>\n<li>Importing display banners<\/li>\n<li>Finding out channel IDs<\/li>\n<li>Facebook Image Hash \/ Video ID<\/li>\n<li>Facebook interests API<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>There it is! Part 2 in the series featuring smarts for automating a multi-channel campaign setup.&nbsp;In&nbsp;part 1, we took you through the reason for and process of automating.&nbsp;Now it gets really interesting for the techies and Excel enthusiasts among us. In this article VLOOKUP (or VERT.ZOEKEN) VLOOKUP for location targeting. Data validation Conditional data validation [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":6803,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[22],"tags":[],"class_list":["post-6805","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"_elementor_source_image_hash":null,"_wp_attachment_backup_sizes":null,"_menu_item_type":null,"_menu_item_menu_item_parent":null,"_menu_item_object_id":null,"_menu_item_object":null,"_menu_item_target":null,"_menu_item_classes":null,"_menu_item_xfn":null,"_menu_item_url":null,"_elementor_popup_display_settings":null,"_elementor_global_widget_included_posts":null,"_elementor_screenshot_failed":null,"_elementor_location":null,"_elementor_priority":null,"_elementor_code":null,"_elementor_extra_options":null,"_elementor_is_screenshot":null,"_oembed_c20df2f369c0b3ecc5a430b0490b215d":null,"_oembed_858d65f9aa5ea80356bdc3ca70b70afe":null,"_oembed_1760c26966eb47469322c7b4c5ae7077":null,"_oembed_time_1760c26966eb47469322c7b4c5ae7077":null,"_oembed_20bcc060401754e2e44a944bab2d1119":null,"_oembed_f7a9e644c801a47c2b4f8e69fb03890a":null,"_oembed_time_f7a9e644c801a47c2b4f8e69fb03890a":null,"_oembed_c1e51587acdd6f7b99399159914bba82":null,"_oembed_56c2e10bf89361d24bbc9bf50b02b2b3":null,"_oembed_time_56c2e10bf89361d24bbc9bf50b02b2b3":null,"_oembed_ffef5431030b06ba6b7c3693aec70948":null,"_oembed_e95798b35ea65385ff5a2890ff7fe1bf":null,"_oembed_time_e95798b35ea65385ff5a2890ff7fe1bf":null,"_oembed_5c8d3563985123f323e8225d34235a42":null,"_oembed_585a3e6fa40045bbf31674eaccd9462e":null,"_oembed_time_585a3e6fa40045bbf31674eaccd9462e":null,"_oembed_196e47dd6329bbf617a8a3bf0d4cd578":null,"_oembed_558c6c4290e2f5eddcfc9e93e8806a99":null,"_oembed_d16c99919345a20d43d3cce75101ecbb":null,"_oembed_time_d16c99919345a20d43d3cce75101ecbb":null,"_oembed_0058f1ce77a0146b16fe594d0c626919":null,"_oembed_4020f75318bddd52dcee1c876f663e5f":null,"_oembed_time_4020f75318bddd52dcee1c876f663e5f":null,"_yoast_wpseo_primary_category":null,"_encloseme":null,"_wp_attachment_image_alt":null,"_wpcode_auto_insert":null,"_wpcode_auto_insert_number":null,"_wpcode_library_id":null,"_wpcode_conditional_logic_enabled":null,"_wpcode_priority":null,"_wpcode_note":null,"_wpcode_conditional_logic":null,"_wpcode_library_version":null,"_elementor_template_sub_type":null,"_wp_attachment_context":null,"_oembed_4afe4ad3b3a931cfe075fb5a3a925335":null,"_yoast_wpseo_bctitle":null,"__elementor_forms_snapshot":null,"_yoast_wpseo_meta-robots-noindex":null,"_yoast_wpseo_meta-robots-nofollow":null,"_wp_trash_meta_status":null,"_wp_trash_meta_time":null,"_wp_desired_post_slug":null,"_icl_lang_duplicate_of":null,"_menu_item_orphaned":null,"_elementor_source":null,"embed_link":null,"_embed_link":null,"spotify_embed_code":null,"_spotify_embed_code":null,"_oembed_49eb4f33d26da85e7f2c4f155cbf6971":null,"_elementor_edit_mode":null,"_elementor_template_type":"wp-post","_wp_attached_file":null,"_wp_attachment_metadata":null,"_edit_lock":"1663865270:2","_wp_page_template":"default","_elementor_page_settings":null,"_elementor_data":"[{\"id\":\"c86b487\",\"elType\":\"section\",\"settings\":{\"padding\":{\"unit\":\"px\",\"top\":\"249\",\"right\":\"0\",\"bottom\":\"80\",\"left\":\"0\",\"isLinked\":false},\"padding_tablet\":{\"unit\":\"px\",\"top\":\"135\",\"right\":\"6\",\"bottom\":\"20\",\"left\":\"6\",\"isLinked\":false},\"padding_mobile\":{\"unit\":\"px\",\"top\":\"105\",\"right\":\"6\",\"bottom\":\"0\",\"left\":\"6\",\"isLinked\":false}},\"elements\":[{\"id\":\"51aca57d\",\"elType\":\"column\",\"settings\":{\"_column_size\":100,\"_inline_size\":null,\"space_between_widgets\":80,\"space_between_widgets_tablet\":30,\"space_between_widgets_mobile\":16,\"padding_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"10\",\"bottom\":\"0\",\"left\":\"10\",\"isLinked\":false}},\"elements\":[{\"id\":\"4760937b\",\"elType\":\"widget\",\"settings\":{\"__dynamic__\":{\"title\":\"[elementor-tag id=\\\"\\\" name=\\\"post-title\\\" settings=\\\"%7B%22before%22%3A%22%22%2C%22after%22%3A%22%22%2C%22fallback%22%3A%22%22%7D\\\"]\"},\"title\":\"Add Your Heading Text Here\",\"typography_typography\":\"custom\",\"typography_font_family\":\"Montserrat\",\"typography_font_size\":{\"unit\":\"px\",\"size\":80,\"sizes\":[]},\"typography_font_weight\":\"700\",\"typography_line_height\":{\"unit\":\"px\",\"size\":100,\"sizes\":[]}},\"elements\":[],\"widgetType\":\"theme-post-title\"}],\"isInner\":false}],\"isInner\":false},{\"id\":\"6863b8f8\",\"elType\":\"section\",\"settings\":{\"margin\":{\"unit\":\"px\",\"top\":\"0\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":true},\"padding_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"6\",\"bottom\":\"0\",\"left\":\"6\",\"isLinked\":false},\"padding_mobile\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"6\",\"bottom\":\"0\",\"left\":\"6\",\"isLinked\":false}},\"elements\":[{\"id\":\"50596188\",\"elType\":\"column\",\"settings\":{\"_column_size\":100,\"_inline_size\":null,\"padding\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false}},\"elements\":[{\"id\":\"515ff180\",\"elType\":\"section\",\"settings\":[],\"elements\":[{\"id\":\"1b81422d\",\"elType\":\"column\",\"settings\":{\"_column_size\":100,\"_inline_size\":null,\"space_between_widgets\":160,\"space_between_widgets_tablet\":60,\"space_between_widgets_mobile\":40},\"elements\":[{\"id\":\"55d98112\",\"elType\":\"widget\",\"settings\":{\"__dynamic__\":{\"image\":\"[elementor-tag id=\\\"\\\" name=\\\"post-featured-image\\\" settings=\\\"%7B%22fallback%22%3A%7B%22url%22%3A%22%22%2C%22id%22%3A%22%22%7D%7D\\\"]\"},\"image_size\":\"full\"},\"elements\":[],\"widgetType\":\"theme-post-featured-image\"}],\"isInner\":true}],\"isInner\":true}],\"isInner\":false}],\"isInner\":false},{\"id\":\"148b8cb6\",\"elType\":\"section\",\"settings\":{\"margin\":{\"unit\":\"px\",\"top\":\"160\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":false},\"margin_tablet\":{\"unit\":\"px\",\"top\":\"40\",\"right\":0,\"bottom\":\"15\",\"left\":0,\"isLinked\":false},\"padding_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":true},\"css_classes\":\"Accordian-section\",\"margin_mobile\":{\"unit\":\"px\",\"top\":\"20\",\"right\":0,\"bottom\":\"40\",\"left\":0,\"isLinked\":false},\"padding_mobile\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false}},\"elements\":[{\"id\":\"3dc2451f\",\"elType\":\"column\",\"settings\":{\"_column_size\":100,\"_inline_size\":null,\"padding_tablet\":{\"unit\":\"px\",\"top\":\"10\",\"right\":\"16\",\"bottom\":\"10\",\"left\":\"16\",\"isLinked\":false}},\"elements\":[{\"id\":\"7884fbef\",\"elType\":\"widget\",\"settings\":{\"tabs\":[{\"tab_title\":\"Trigger\",\"tab_content\":\"<h2>Bekend worden voordat je dominant kunt zijn<\\\/h2><p>Na marktleider te zijn geworden in behavioral marketing software in de VS &amp; UK, is Wunderkind (WK) in 2022 gestart met zijn Europese expansie via de Nederlandse markt. Doel: #1 personalisatie software worden voor online retailers. <\\\/p><p>Om dit doel te bereiken moet aan drie belangrijke randvoorwaarden zijn voldaan:<br><span style=\\\"background-color: transparent; color: var( --e-global-color-text );\\\">- Genereer bekendheid onder specifiek online detailhandelsegment<\\\/span><\\\/p><p><span style=\\\"background-color: transparent; color: var( --e-global-color-text );\\\">- Genereren van vraag onder specifieke online retailer segmenten<\\\/span><\\\/p><p><span style=\\\"background-color: transparent; color: var( --e-global-color-text );\\\">- Bouw een pipeline van hoge kwaliteit van leads die klaar zijn om te kopen<\\\/span><\\\/p>\",\"_id\":\"6b83b73\",\"index\":0},{\"tab_title\":\"Aanpak\",\"tab_content\":\"<h2>Gericht informeren. Ge\\u00efntegreerd en vanaf het begin <\\\/h2><div class=\\\"elementor-accordion-item\\\"><div id=\\\"elementor-tab-content-2482\\\" class=\\\"elementor-tab-content elementor-clearfix elementor-active\\\" role=\\\"tabpanel\\\" data-tab=\\\"2\\\" aria-labelledby=\\\"elementor-tab-title-2482\\\"><p>Door te focussen op online retail ontstaat een duidelijk beeld van de Serviceable Obtainable Market en de spelers daarbinnen. CEO's en CMO's maakten kennis met WK via PR: veel nieuws en toonaangevende artikelen in hun belangrijkste media. Vervolgens werd deze groep voorzien van diepgaand onderzoek over de Nederlandse markt, waardoor zij goed ge\\u00efnformeerde beslissingen konden nemen.  Om de cirkel rond te maken werden ze via LinkedIn opnieuw met WK in contact gebracht in hun zoektocht naar kritische inzichten in de behoeften van hun publiek en manieren om daarop in te spelen via personalisatietechnologie.<\\\/p><\\\/div><\\\/div>\",\"_id\":\"b1fe5cd\",\"index\":1},{\"tab_title\":\"Resultaat\",\"tab_content\":\"<h2>Merk gevestigd. Pipeline gevuld. Retailers worden klant.<\\\/h2>\\n<p><span style=\\\"font-family: Poppins, sans-serif;\\\"><span style=\\\"font-size: 26px; font-weight: 300;\\\">Binnen 2 maanden na de PR campagne heeft 100% van de target retailers contact gehad met WK. Dit heeft geresulteerd in gesloten deals en een sterke pipeline, waardoor WK dringend haar Nederlandse team moet uitbreiden.\\n\\n<\\\/span><\\\/span><\\\/p>\",\"_id\":\"54d191c\",\"index\":2}],\"selected_icon\":{\"value\":\"fas fa-chevron-down\",\"library\":\"fa-solid\"},\"selected_active_icon\":{\"value\":\"fas fa-chevron-up\",\"library\":\"fa-solid\"},\"title_html_tag\":\"h5\",\"faq_schema\":\"yes\",\"title_color\":\"#000000\",\"tab_active_color\":\"#000000\",\"title_typography_typography\":\"custom\",\"title_typography_font_family\":\"Montserrat\",\"title_typography_font_size\":{\"unit\":\"px\",\"size\":32,\"sizes\":[]},\"title_typography_font_size_tablet\":{\"unit\":\"px\",\"size\":18,\"sizes\":[]},\"title_typography_font_size_mobile\":{\"unit\":\"px\",\"size\":18,\"sizes\":[]},\"title_typography_font_weight\":\"700\",\"title_typography_line_height\":{\"unit\":\"px\",\"size\":39,\"sizes\":[]},\"title_typography_line_height_tablet\":{\"unit\":\"px\",\"size\":22,\"sizes\":[]},\"title_typography_line_height_mobile\":{\"unit\":\"px\",\"size\":21,\"sizes\":[]},\"title_padding_tablet\":{\"unit\":\"px\",\"top\":\"15\",\"right\":\"16\",\"bottom\":\"15\",\"left\":\"16\",\"isLinked\":false},\"icon_align\":\"right\",\"content_typography_typography\":\"custom\",\"content_typography_font_family\":\"Poppins\",\"content_typography_font_size\":{\"unit\":\"px\",\"size\":26,\"sizes\":[]},\"content_typography_font_size_tablet\":{\"unit\":\"px\",\"size\":15,\"sizes\":[]},\"content_typography_font_weight\":\"300\",\"content_typography_line_height\":{\"unit\":\"px\",\"size\":39,\"sizes\":[]},\"content_typography_line_height_tablet\":{\"unit\":\"px\",\"size\":18,\"sizes\":[]},\"content_typography_line_height_mobile\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"content_padding\":{\"unit\":\"px\",\"top\":\"48\",\"right\":\"0\",\"bottom\":\"16\",\"left\":\"0\",\"isLinked\":false},\"content_padding_mobile\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"_css_classes\":\"operation-tabs\",\"_background_background\":\"classic\",\"icon_space_tablet\":{\"unit\":\"px\",\"size\":0,\"sizes\":[]},\"content_padding_tablet\":{\"unit\":\"px\",\"top\":\"24\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"_margin\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"title_padding\":{\"unit\":\"px\",\"top\":\"32\",\"right\":\"28\",\"bottom\":\"32\",\"left\":\"32\",\"isLinked\":false}},\"elements\":[],\"widgetType\":\"accordion\"}],\"isInner\":false}],\"isInner\":false},{\"id\":\"3fe749ef\",\"elType\":\"section\",\"settings\":{\"margin\":{\"unit\":\"px\",\"top\":\"117\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":false},\"margin_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":0,\"bottom\":\"22\",\"left\":0,\"isLinked\":false},\"margin_mobile\":{\"unit\":\"px\",\"top\":\"47\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":false},\"padding_mobile\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"6\",\"bottom\":\"0\",\"left\":\"6\",\"isLinked\":false}},\"elements\":[{\"id\":\"53f3a205\",\"elType\":\"column\",\"settings\":{\"_column_size\":100,\"_inline_size\":null,\"space_between_widgets\":0,\"space_between_widgets_tablet\":0,\"padding_tablet\":{\"unit\":\"px\",\"top\":\"10\",\"right\":\"16\",\"bottom\":\"10\",\"left\":\"16\",\"isLinked\":false}},\"elements\":[{\"id\":\"727ea938\",\"elType\":\"widget\",\"settings\":{\"title\":\"\\\"Gradient, onze partner voor groei.\\\"\",\"align\":\"center\",\"align_tablet\":\"left\",\"typography_typography\":\"custom\",\"typography_font_size_tablet\":{\"unit\":\"px\",\"size\":32,\"sizes\":[]},\"typography_font_weight\":\"700\",\"_margin\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":true},\"_margin_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":true},\"_element_width\":\"auto\",\"_element_vertical_align_tablet\":\"center\",\"_padding\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":true},\"_element_vertical_align\":\"flex-start\",\"_css_classes\":\"gradient-partner-growth\",\"align_mobile\":\"center\",\"typography_font_size_mobile\":{\"unit\":\"px\",\"size\":26,\"sizes\":[]},\"typography_line_height_mobile\":{\"unit\":\"em\",\"size\":29.260000000000001563194018672220408916473388671875,\"sizes\":[]},\"text_stroke_text_stroke_type\":\"yes\",\"_padding_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"typography_line_height_tablet\":{\"unit\":\"px\",\"size\":39,\"sizes\":[]}},\"elements\":[],\"widgetType\":\"heading\"}],\"isInner\":false}],\"isInner\":false},{\"id\":\"cb04adb\",\"elType\":\"section\",\"settings\":[],\"elements\":[{\"id\":\"ac7bc35\",\"elType\":\"column\",\"settings\":{\"_column_size\":100,\"_inline_size\":null},\"elements\":[{\"id\":\"9479d68\",\"elType\":\"section\",\"settings\":{\"structure\":\"20\"},\"elements\":[{\"id\":\"778ce15\",\"elType\":\"column\",\"settings\":{\"_column_size\":50,\"_inline_size\":null},\"elements\":[],\"isInner\":true},{\"id\":\"d541c37\",\"elType\":\"column\",\"settings\":{\"_column_size\":50,\"_inline_size\":null},\"elements\":[],\"isInner\":true}],\"isInner\":true}],\"isInner\":false}],\"isInner\":false},{\"id\":\"723047ae\",\"elType\":\"section\",\"settings\":{\"background_background\":\"classic\",\"css_classes\":\"cta-book-a-call\",\"margin\":{\"unit\":\"px\",\"top\":\"70\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":false},\"padding\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"149\",\"left\":\"0\",\"isLinked\":false},\"padding_mobile\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"padding_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"60\",\"left\":\"0\",\"isLinked\":false},\"margin_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":false},\"margin_mobile\":{\"unit\":\"px\",\"top\":\"24\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":false}},\"elements\":[{\"id\":\"5cb4bc46\",\"elType\":\"column\",\"settings\":{\"_column_size\":100,\"_inline_size\":null,\"background_background\":\"classic\",\"background_color\":\"#F4D03E\",\"border_radius\":{\"unit\":\"px\",\"top\":\"8\",\"right\":\"8\",\"bottom\":\"8\",\"left\":\"8\",\"isLinked\":true},\"padding\":{\"unit\":\"px\",\"top\":\"40\",\"right\":\"0\",\"bottom\":\"60\",\"left\":\"0\",\"isLinked\":false},\"padding_mobile\":{\"unit\":\"px\",\"top\":\"24\",\"right\":\"20\",\"bottom\":\"0\",\"left\":\"20\",\"isLinked\":false},\"padding_tablet\":{\"unit\":\"px\",\"top\":\"30\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"space_between_widgets\":0,\"space_between_widgets_tablet\":0},\"elements\":[{\"id\":\"3773c956\",\"elType\":\"widget\",\"settings\":{\"title\":\"\\\"In onze zoektocht om het personalisatie segment binnen Martech in NL te domineren heeft Gradient ons enorm geholpen door een tweeledige aanpak: ten eerste ons op de radar krijgen bij onze doelgroepen en ten tweede hen zeer ge\\u00efnteresseerd krijgen in de propositie van Wunderkinds via hoge kwaliteit content en hyper gerichte messaging. In NL groeien we snel en goed.\\\"\",\"header_size\":\"p\",\"align\":\"center\",\"title_color\":\"#000000\",\"typography_typography\":\"custom\",\"typography_font_weight\":\"300\",\"_margin\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":true},\"_padding\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"124\",\"bottom\":\"0\",\"left\":\"124\",\"isLinked\":false},\"_element_width\":\"initial\",\"_element_custom_width\":{\"unit\":\"%\",\"size\":1191,\"sizes\":[]},\"_element_vertical_align\":\"center\",\"_padding_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"16\",\"bottom\":\"0\",\"left\":\"16\",\"isLinked\":false},\"_padding_mobile\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":true},\"typography_font_style\":\"normal\",\"typography_line_height\":{\"unit\":\"px\",\"size\":39,\"sizes\":[]},\"typography_line_height_tablet\":{\"unit\":\"px\",\"size\":27,\"sizes\":[]},\"typography_line_height_mobile\":{\"unit\":\"px\",\"size\":24,\"sizes\":[]},\"typography_font_family\":\"Poppins\",\"typography_font_size\":{\"unit\":\"px\",\"size\":26,\"sizes\":[]}},\"elements\":[],\"widgetType\":\"heading\"},{\"id\":\"4c0e522c\",\"elType\":\"widget\",\"settings\":{\"title\":\"- Wouter Koch, algemeen directeur Wunderkind NL\",\"header_size\":\"p\",\"align\":\"center\",\"typography_typography\":\"custom\",\"typography_font_weight\":\"700\",\"_margin\":{\"unit\":\"px\",\"top\":\"16\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"typography_font_size_tablet\":{\"unit\":\"px\",\"size\":20,\"sizes\":[]},\"typography_font_size_mobile\":{\"unit\":\"px\",\"size\":18,\"sizes\":[]},\"typography_line_height_tablet\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"typography_line_height_mobile\":{\"unit\":\"px\",\"size\":27,\"sizes\":[]},\"text_stroke_text_stroke_type\":\"yes\",\"typography_font_family\":\"Poppins\",\"typography_font_size\":{\"unit\":\"px\",\"size\":26,\"sizes\":[]},\"typography_line_height\":{\"unit\":\"px\",\"size\":39,\"sizes\":[]}},\"elements\":[],\"widgetType\":\"heading\"},{\"id\":\"143fbb8f\",\"elType\":\"widget\",\"settings\":{\"text\":\"Boek een strategy call\",\"align\":\"center\",\"typography_typography\":\"custom\",\"typography_font_family\":\"Poppins\",\"typography_font_size\":{\"unit\":\"px\",\"size\":20,\"sizes\":[]},\"typography_font_weight\":\"700\",\"typography_line_height\":{\"unit\":\"px\",\"size\":30,\"sizes\":[]},\"button_text_color\":\"#FFFFFF\",\"background_color\":\"#000000\",\"_margin\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"-64\",\"left\":\"0\",\"isLinked\":false},\"typography_font_size_mobile\":{\"unit\":\"px\",\"size\":16,\"sizes\":[]},\"typography_line_height_mobile\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"_margin_mobile\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"_padding_mobile\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"link\":{\"url\":\"#link-popup\",\"is_external\":\"\",\"nofollow\":\"\",\"custom_attributes\":\"\"},\"text_padding\":{\"unit\":\"px\",\"top\":\"17\",\"right\":\"45\",\"bottom\":\"17\",\"left\":\"45\",\"isLinked\":false},\"__dynamic__\":{\"link\":\"[elementor-tag id=\\\"69955e6\\\" name=\\\"popup\\\" settings=\\\"%7B%22popup%22%3A%221680%22%7D\\\"]\"},\"button_css_id\":\"link-popup\",\"hover_color\":\"#FFFFFF\",\"button_background_hover_color\":\"#000000\",\"border_radius\":{\"unit\":\"px\",\"top\":\"8\",\"right\":\"8\",\"bottom\":\"8\",\"left\":\"8\",\"isLinked\":true},\"_margin_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"-1\",\"left\":\"0\",\"isLinked\":false}},\"elements\":[],\"widgetType\":\"button\"}],\"isInner\":false}],\"isInner\":false},{\"id\":\"4e8194e4\",\"elType\":\"section\",\"settings\":{\"padding\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"150\",\"left\":\"0\",\"isLinked\":false},\"margin\":{\"unit\":\"px\",\"top\":\"0\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":false},\"padding_mobile\":{\"unit\":\"px\",\"top\":\"80\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":false},\"margin_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":false},\"padding_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"60\",\"left\":\"0\",\"isLinked\":false}},\"elements\":[{\"id\":\"6437605c\",\"elType\":\"column\",\"settings\":{\"_column_size\":100,\"_inline_size\":null,\"space_between_widgets_tablet\":0,\"padding_tablet\":{\"unit\":\"px\",\"top\":\"10\",\"right\":\"6\",\"bottom\":\"10\",\"left\":\"6\",\"isLinked\":false},\"padding_mobile\":{\"unit\":\"px\",\"top\":\"10\",\"right\":\"6\",\"bottom\":\"10\",\"left\":\"6\",\"isLinked\":false}},\"elements\":[{\"id\":\"7426f926\",\"elType\":\"section\",\"settings\":{\"margin\":{\"unit\":\"px\",\"top\":\"0\",\"right\":0,\"bottom\":\"80\",\"left\":0,\"isLinked\":false},\"margin_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":0,\"bottom\":\"0\",\"left\":0,\"isLinked\":false}},\"elements\":[{\"id\":\"56a6078\",\"elType\":\"column\",\"settings\":{\"_column_size\":100,\"_inline_size\":null,\"space_between_widgets\":0,\"space_between_widgets_tablet\":0},\"elements\":[{\"id\":\"5dbe7b6a\",\"elType\":\"widget\",\"settings\":{\"title\":\"Andere case die we hebben gedaan\",\"typography_typography\":\"custom\",\"typography_font_family\":\"Montserrat\",\"typography_font_weight\":\"700\",\"typography_font_size_tablet\":{\"unit\":\"px\",\"size\":32,\"sizes\":[]},\"typography_line_height_tablet\":{\"unit\":\"px\",\"size\":39,\"sizes\":[]},\"typography_line_height_mobile\":{\"unit\":\"px\",\"size\":29.260000000000001563194018672220408916473388671875,\"sizes\":[]},\"typography_font_size_mobile\":{\"unit\":\"px\",\"size\":24,\"sizes\":[]},\"align\":\"center\",\"_margin_tablet\":{\"unit\":\"px\",\"top\":\"0\",\"right\":\"0\",\"bottom\":\"0\",\"left\":\"0\",\"isLinked\":true}},\"elements\":[],\"widgetType\":\"heading\"}],\"isInner\":true}],\"isInner\":true},{\"id\":\"1988128d\",\"elType\":\"widget\",\"settings\":{\"classic_posts_per_page\":3,\"classic_show_excerpt\":\"\",\"classic_meta_data\":[],\"classic_meta_separator\":\"\\\/\\\/\\\/\",\"classic_show_read_more\":\"\",\"classic_read_more_text\":\"Lees meer \\u00bb\",\"cards_meta_separator\":\"\\u2022\",\"cards_read_more_text\":\"Lees meer \\u00bb\",\"full_content_meta_separator\":\"\\\/\\\/\\\/\",\"posts_include\":[\"terms\"],\"posts_include_term_ids\":[\"21\"],\"classic_title_typography_typography\":\"custom\",\"classic_title_typography_font_family\":\"Poppins\",\"classic_title_typography_font_size\":{\"unit\":\"px\",\"size\":26,\"sizes\":[]},\"classic_title_typography_font_weight\":\"300\",\"pagination_page_limit\":\"5\",\"pagination_prev_label\":\"\\u00ab Vorige\",\"pagination_next_label\":\"Volgende \\u00bb\",\"text\":\"Load More\",\"load_more_no_posts_custom_message\":\"No more posts to show\",\"posts_exclude\":[\"current_post\"],\"classic_thumbnail_size_size\":\"full\",\"classic_item_ratio\":{\"unit\":\"px\",\"size\":0.5,\"sizes\":[]}},\"elements\":[],\"widgetType\":\"posts\"}],\"isInner\":false}],\"isInner\":false}]","_elementor_page_assets":{"styles":["widget-heading","widget-image","widget-accordion","widget-posts"],"scripts":["elementor-frontend","imagesloaded"]},"_elementor_version":"3.7.4","_elementor_pro_version":null,"_elementor_controls_usage":{"theme-post-title":{"count":1,"control_percent":2,"controls":{"general":{"__dynamic__":{"count":1}},"content":{"section_title":{"title":1}},"style":{"section_title_style":{"typography_typography":1,"typography_font_family":1,"typography_font_size":1,"typography_font_weight":1,"typography_line_height":1}}}},"column":{"count":11,"control_percent":0,"controls":{"layout":{"layout":{"_inline_size":11,"space_between_widgets":5}},"advanced":{"section_advanced":{"padding":2}},"style":{"section_style":{"background_background":1,"background_color":1},"section_border":{"border_radius":1}}}},"section":{"count":10,"control_percent":1,"controls":{"advanced":{"section_advanced":{"padding":3,"margin":6,"css_classes":2}},"layout":{"section_structure":{"structure":1}},"style":{"section_background":{"background_background":1}}}},"theme-post-featured-image":{"count":1,"control_percent":1,"controls":{"general":{"__dynamic__":{"count":1}},"content":{"section_image":{"image_size":1,"image":1}}}},"accordion":{"count":1,"control_percent":7,"controls":{"content":{"section_title":{"tabs":1,"selected_icon":1,"selected_active_icon":1,"title_html_tag":1,"faq_schema":1}},"style":{"section_toggle_style_title":{"title_color":1,"tab_active_color":1,"title_typography_typography":1,"title_typography_font_family":1,"title_typography_font_size":1,"title_typography_font_weight":1,"title_typography_line_height":1,"title_padding":1},"section_toggle_style_icon":{"icon_align":1},"section_toggle_style_content":{"content_typography_typography":1,"content_typography_font_family":1,"content_typography_font_size":1,"content_typography_font_weight":1,"content_typography_line_height":1,"content_padding":1}},"advanced":{"_section_style":{"_css_classes":1,"_margin":1},"_section_background":{"_background_background":1}}}},"heading":{"count":4,"control_percent":2,"controls":{"content":{"section_title":{"title":4,"align":4,"header_size":2}},"style":{"section_title_style":{"typography_typography":4,"typography_font_weight":4,"text_stroke_text_stroke_type":2,"title_color":1,"typography_font_style":1,"typography_line_height":2,"typography_font_family":3,"typography_font_size":2}},"advanced":{"_section_style":{"_margin":3,"_element_width":2,"_padding":2,"_element_vertical_align":2,"_css_classes":1,"_element_custom_width":1}}}},"button":{"count":1,"control_percent":4,"controls":{"general":{"__dynamic__":{"count":1}},"content":{"section_button":{"text":1,"align":1,"link":1,"button_css_id":1}},"style":{"section_style":{"typography_typography":1,"typography_font_family":1,"typography_font_size":1,"typography_font_weight":1,"typography_line_height":1,"button_text_color":1,"background_color":1,"text_padding":1,"hover_color":1,"button_background_hover_color":1,"border_radius":1}},"advanced":{"_section_style":{"_margin":1}}}},"posts":{"count":1,"control_percent":2,"controls":{"content":{"section_layout":{"classic_posts_per_page":1,"classic_show_excerpt":1,"classic_meta_data":1,"classic_show_read_more":1,"classic_read_more_text":1,"cards_read_more_text":1,"classic_thumbnail_size_size":1,"classic_item_ratio":1},"section_query":{"posts_include":1,"posts_include_term_ids":1,"posts_exclude":1},"section_pagination":{"pagination_prev_label":1,"pagination_next_label":1}},"style":{"classic_section_design_content":{"classic_title_typography_typography":1,"classic_title_typography_font_family":1,"classic_title_typography_font_size":1,"classic_title_typography_font_weight":1}}}}},"_wp_old_date":null,"_elementor_conditions":null,"_edit_last":"2","_wpml_word_count":"{\"total\":0,\"to_translate\":{\"nl\":2,\"en\":2}}","_wpml_media_featured":"1","_wpml_media_duplicate":"1","wpml_media_processed":null,"_top_nav_excluded":"","_cms_nav_minihome":"","_last_translation_edit_mode":"translation-editor","_elementor_template_widget_type":null,"_wpml_location_migration_done":null,"_thumbnail_id":"6803","njt_duplicate_count_duplicate":null,"_elementor_screenshot":null,"_yoast_wpseo_focuskw":null,"_yoast_wpseo_title":null,"_yoast_wpseo_metadesc":"7 tips to build advertising campaigns more efficiently with Excel! Are you a techie or Excel enthusiast? Read on quickly.","_yoast_wpseo_linkdex":null,"_yoast_wpseo_content_score":"60","_yoast_wpseo_estimated-reading-time-minutes":"15","_yoast_wpseo_wordproof_timestamp":"","_wpml_post_translation_editor_native":null,"_wp_old_slug":null,"wat_je_gaat_doen_bij_gradient":null,"_wat_je_gaat_doen_bij_gradient":null,"jij_hebt":null,"_jij_hebt":null,"perks":null,"_perks":null,"tekstkleur":null,"_tekstkleur":null,"achtergrondkleur":null,"_achtergrondkleur":null,"samenvatting":null,"_samenvatting":null,"trigger":null,"_trigger":null,"trigger_subtitel":null,"_trigger_subtitel":null,"aanpak":null,"_aanpak":null,"aanpak_subtitel":null,"_aanpak_subtitel":null,"resultaat":null,"_resultaat":null,"resultaat_subtitel":null,"_resultaat_subtitel":null,"quote":null,"_quote":null,"quote_auteur":null,"_quote_auteur":null,"voornaam":null,"_voornaam":null,"rol":null,"_rol":null,"foto":null,"_foto":null,"linkedin":null,"_linkedin":null,"_elementor_css":null,"extra_afbeeldingen_case":null,"_extra_afbeeldingen_case":null,"youtube_url":null,"_youtube_url":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Building advertising campaigns more efficiently with Excel: 7 tips | Gradient<\/title>\n<meta name=\"description\" content=\"7 tips to build advertising campaigns more efficiently with Excel! Are you a techie or Excel enthusiast? Read on quickly.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Building advertising campaigns more efficiently with Excel: 7 tips | Gradient\" \/>\n<meta property=\"og:description\" content=\"7 tips to build advertising campaigns more efficiently with Excel! Are you a techie or Excel enthusiast? Read on quickly.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/\" \/>\n<meta property=\"og:site_name\" content=\"Gradient\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-21T15:33:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-12T14:29:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/spreadsheet-g06f2f8c7e_640.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jamil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jamil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/\"},\"author\":{\"name\":\"Jamil\",\"@id\":\"https:\\\/\\\/begradient.com\\\/#\\\/schema\\\/person\\\/87888108ca85cbd14f35cf0692ec8814\"},\"headline\":\"Building advertising campaigns more efficiently with Excel: 7 tips\",\"datePublished\":\"2020-04-21T15:33:00+00:00\",\"dateModified\":\"2022-10-12T14:29:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/\"},\"wordCount\":2402,\"publisher\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/begradient.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/spreadsheet-g06f2f8c7e_640.jpg\",\"articleSection\":[\"Blogpost\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/\",\"url\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/\",\"name\":\"Building advertising campaigns more efficiently with Excel: 7 tips | Gradient\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/begradient.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/spreadsheet-g06f2f8c7e_640.jpg\",\"datePublished\":\"2020-04-21T15:33:00+00:00\",\"dateModified\":\"2022-10-12T14:29:13+00:00\",\"description\":\"7 tips to build advertising campaigns more efficiently with Excel! Are you a techie or Excel enthusiast? Read on quickly.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/#primaryimage\",\"url\":\"https:\\\/\\\/begradient.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/spreadsheet-g06f2f8c7e_640.jpg\",\"contentUrl\":\"https:\\\/\\\/begradient.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/spreadsheet-g06f2f8c7e_640.jpg\",\"width\":640,\"height\":480},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/begradient.com\\\/blog\\\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/begradient.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/begradient.com\\\/category\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Building advertising campaigns more efficiently with Excel: 7 tips\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/begradient.com\\\/#website\",\"url\":\"https:\\\/\\\/begradient.com\\\/\",\"name\":\"Gradient\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/begradient.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/begradient.com\\\/#organization\",\"name\":\"Gradient\",\"url\":\"https:\\\/\\\/begradient.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/begradient.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/begradient.com\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/cropped-cropped-cropped-GRAD_LOGO_green_nobg.png\",\"contentUrl\":\"https:\\\/\\\/begradient.com\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/cropped-cropped-cropped-GRAD_LOGO_green_nobg.png\",\"width\":1500,\"height\":367,\"caption\":\"Gradient\"},\"image\":{\"@id\":\"https:\\\/\\\/begradient.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/gradientb2bmarketing\\\/\",\"https:\\\/\\\/www.instagram.com\\\/begradient\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/begradient.com\\\/#\\\/schema\\\/person\\\/87888108ca85cbd14f35cf0692ec8814\",\"name\":\"Jamil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ee9d449f750d360ba9387a5ff8cb03650666ea4c50672d0d3531ee42aee0580f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ee9d449f750d360ba9387a5ff8cb03650666ea4c50672d0d3531ee42aee0580f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ee9d449f750d360ba9387a5ff8cb03650666ea4c50672d0d3531ee42aee0580f?s=96&d=mm&r=g\",\"caption\":\"Jamil\"},\"description\":\"https:\\\/\\\/jamilflorusse.nl\\\/\",\"sameAs\":[\"https:\\\/\\\/jamilflorusse.nl\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/jamil-florusse\\\/\"],\"url\":\"https:\\\/\\\/begradient.com\\\/en\\\/author\\\/jamil\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Building advertising campaigns more efficiently with Excel: 7 tips | Gradient","description":"7 tips to build advertising campaigns more efficiently with Excel! Are you a techie or Excel enthusiast? Read on quickly.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/","og_locale":"en_US","og_type":"article","og_title":"Building advertising campaigns more efficiently with Excel: 7 tips | Gradient","og_description":"7 tips to build advertising campaigns more efficiently with Excel! Are you a techie or Excel enthusiast? Read on quickly.","og_url":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/","og_site_name":"Gradient","article_published_time":"2020-04-21T15:33:00+00:00","article_modified_time":"2022-10-12T14:29:13+00:00","og_image":[{"width":640,"height":480,"url":"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/spreadsheet-g06f2f8c7e_640.jpg","type":"image\/jpeg"}],"author":"Jamil","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jamil","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#article","isPartOf":{"@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/"},"author":{"name":"Jamil","@id":"https:\/\/begradient.com\/#\/schema\/person\/87888108ca85cbd14f35cf0692ec8814"},"headline":"Building advertising campaigns more efficiently with Excel: 7 tips","datePublished":"2020-04-21T15:33:00+00:00","dateModified":"2022-10-12T14:29:13+00:00","mainEntityOfPage":{"@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/"},"wordCount":2402,"publisher":{"@id":"https:\/\/begradient.com\/#organization"},"image":{"@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#primaryimage"},"thumbnailUrl":"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/spreadsheet-g06f2f8c7e_640.jpg","articleSection":["Blogpost"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/","url":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/","name":"Building advertising campaigns more efficiently with Excel: 7 tips | Gradient","isPartOf":{"@id":"https:\/\/begradient.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#primaryimage"},"image":{"@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#primaryimage"},"thumbnailUrl":"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/spreadsheet-g06f2f8c7e_640.jpg","datePublished":"2020-04-21T15:33:00+00:00","dateModified":"2022-10-12T14:29:13+00:00","description":"7 tips to build advertising campaigns more efficiently with Excel! Are you a techie or Excel enthusiast? Read on quickly.","breadcrumb":{"@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#primaryimage","url":"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/spreadsheet-g06f2f8c7e_640.jpg","contentUrl":"https:\/\/begradient.com\/wp-content\/uploads\/2020\/04\/spreadsheet-g06f2f8c7e_640.jpg","width":640,"height":480},{"@type":"BreadcrumbList","@id":"https:\/\/begradient.com\/blog\/efficienter-advertising-campagnes-bouwen-met-excel-7-tips\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/begradient.com\/"},{"@type":"ListItem","position":2,"name":"Blog","item":"https:\/\/begradient.com\/category\/blog\/"},{"@type":"ListItem","position":3,"name":"Building advertising campaigns more efficiently with Excel: 7 tips"}]},{"@type":"WebSite","@id":"https:\/\/begradient.com\/#website","url":"https:\/\/begradient.com\/","name":"Gradient","description":"","publisher":{"@id":"https:\/\/begradient.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/begradient.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/begradient.com\/#organization","name":"Gradient","url":"https:\/\/begradient.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/begradient.com\/#\/schema\/logo\/image\/","url":"https:\/\/begradient.com\/wp-content\/uploads\/2022\/07\/cropped-cropped-cropped-GRAD_LOGO_green_nobg.png","contentUrl":"https:\/\/begradient.com\/wp-content\/uploads\/2022\/07\/cropped-cropped-cropped-GRAD_LOGO_green_nobg.png","width":1500,"height":367,"caption":"Gradient"},"image":{"@id":"https:\/\/begradient.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/gradientb2bmarketing\/","https:\/\/www.instagram.com\/begradient\/"]},{"@type":"Person","@id":"https:\/\/begradient.com\/#\/schema\/person\/87888108ca85cbd14f35cf0692ec8814","name":"Jamil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ee9d449f750d360ba9387a5ff8cb03650666ea4c50672d0d3531ee42aee0580f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ee9d449f750d360ba9387a5ff8cb03650666ea4c50672d0d3531ee42aee0580f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ee9d449f750d360ba9387a5ff8cb03650666ea4c50672d0d3531ee42aee0580f?s=96&d=mm&r=g","caption":"Jamil"},"description":"https:\/\/jamilflorusse.nl\/","sameAs":["https:\/\/jamilflorusse.nl\/","https:\/\/www.linkedin.com\/in\/jamil-florusse\/"],"url":"https:\/\/begradient.com\/en\/author\/jamil\/"}]}},"_links":{"self":[{"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/posts\/6805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/comments?post=6805"}],"version-history":[{"count":0,"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/posts\/6805\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/media\/6803"}],"wp:attachment":[{"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/media?parent=6805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/categories?post=6805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/begradient.com\/en\/wp-json\/wp\/v2\/tags?post=6805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}