{"id":1085,"date":"2024-10-02T22:49:00","date_gmt":"2024-10-02T20:49:00","guid":{"rendered":"https:\/\/nilsrooijmans.com\/daily\/?p=1085"},"modified":"2024-10-04T10:49:03","modified_gmt":"2024-10-04T08:49:03","slug":"newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated","status":"publish","type":"post","link":"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated","title":{"rendered":"newsletter ideas based on your trending search terms &#8211; part 2 (fully automated)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Two days ago, I wrote about newsletter ideas based on your trending search terms. (A link to that will be provided below for your convenience).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the email, I posed a challenge to you:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">&#8220;&#8230;you can automate the ChatGPT part Caterina described as well. Simply extend the script with some code to feed the prompt and trending search terms to the ChatGPT API, and have the script send the email with the 10 newsletter ideas.&#8221;<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Guess what?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fellow script fanatic and PPC legend Frederick Vallaeys (Optmyzr) took on the challenge and created the automation for us!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8220;<strong>Blog Ideas from Trending Search Terms in Google Ads&#8221;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">From the script comments:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/*<br>* The script finds search terms that have at least a minimum number of impressions<br>* in the past 7 days and have either increased by a specified multiplier compared to<br>* the previous 7 days or have gone from zero to meeting the minimum impression threshold.<br>* For the top 5 highest-volume trending search terms, it uses the OpenAI GPT API to<br>* generate blog post ideas.<br>* The script then compiles these ideas into an email and sends it to your specified<br>* email address.<br>*\/<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Here&#8217;s the link to the script: <a href=\"https:\/\/gist.github.com\/siliconvallaeys\/0527249a7aee382db6360e50e4d7487a\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/gist.github.com\/siliconvallaeys\/0527249a7aee382db6360e50e4d7487a<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Happy scripting!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8211; Nils<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">P.S. As promised, here&#8217;s a link to part 1: <a href=\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms \">https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Two days ago, I wrote about newsletter ideas based on your trending search terms. (A link to that will be provided below for your convenience). In the email, I posed a challenge to you: &#8220;&#8230;you can automate the ChatGPT part Caterina described as well. Simply extend the script with some code to feed the prompt &hellip; <a href=\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;newsletter ideas based on your trending search terms &#8211; part 2 (fully automated)&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1085","post","type-post","status-publish","format-standard","hentry","category-google-ads"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>newsletter ideas based on your trending search terms - part 2 (fully automated) - Nils Rooijmans<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"newsletter ideas based on your trending search terms - part 2 (fully automated) - Nils Rooijmans\" \/>\n<meta property=\"og:description\" content=\"Two days ago, I wrote about newsletter ideas based on your trending search terms. (A link to that will be provided below for your convenience). In the email, I posed a challenge to you: &#8220;&#8230;you can automate the ChatGPT part Caterina described as well. Simply extend the script with some code to feed the prompt &hellip; Continue reading &quot;newsletter ideas based on your trending search terms &#8211; part 2 (fully automated)&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated\" \/>\n<meta property=\"og:site_name\" content=\"Nils Rooijmans\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-02T20:49:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-04T08:49:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_GreenBG_SQUARE_200x186.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"186\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nils Rooijmans\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nils Rooijmans\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated#article\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated\"},\"author\":{\"name\":\"Nils Rooijmans\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"headline\":\"newsletter ideas based on your trending search terms &#8211; part 2 (fully automated)\",\"datePublished\":\"2024-10-02T20:49:00+00:00\",\"dateModified\":\"2024-10-04T08:49:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated\"},\"wordCount\":158,\"publisher\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"articleSection\":[\"Google Ads\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated\",\"name\":\"newsletter ideas based on your trending search terms - part 2 (fully automated) - Nils Rooijmans\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#website\"},\"datePublished\":\"2024-10-02T20:49:00+00:00\",\"dateModified\":\"2024-10-04T08:49:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/nilsrooijmans.com\/daily\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"newsletter ideas based on your trending search terms &#8211; part 2 (fully automated)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#website\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/\",\"name\":\"Nils Rooijmans Daily Newsletter - Google Ads\",\"description\":\"Daily emails to boost your Google Ads Performance\",\"publisher\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/nilsrooijmans.com\/daily\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\",\"name\":\"Nils Rooijmans\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg\",\"contentUrl\":\"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg\",\"width\":300,\"height\":300,\"caption\":\"Nils Rooijmans\"},\"logo\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/\"},\"description\":\"Google Ads Performance Architect with a passion for PPC Automation &amp; AI, in particular via Google Ads Scripts.\",\"sameAs\":[\"https:\/\/nilsrooijmans.com\/\",\"https:\/\/www.linkedin.com\/in\/nilsrooijmans\/\"],\"url\":\"https:\/\/nilsrooijmans.com\/daily\/author\/nils\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"newsletter ideas based on your trending search terms - part 2 (fully automated) - Nils Rooijmans","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:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated","og_locale":"en_US","og_type":"article","og_title":"newsletter ideas based on your trending search terms - part 2 (fully automated) - Nils Rooijmans","og_description":"Two days ago, I wrote about newsletter ideas based on your trending search terms. (A link to that will be provided below for your convenience). In the email, I posed a challenge to you: &#8220;&#8230;you can automate the ChatGPT part Caterina described as well. Simply extend the script with some code to feed the prompt &hellip; Continue reading \"newsletter ideas based on your trending search terms &#8211; part 2 (fully automated)\"","og_url":"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated","og_site_name":"Nils Rooijmans","article_published_time":"2024-10-02T20:49:00+00:00","article_modified_time":"2024-10-04T08:49:03+00:00","og_image":[{"width":200,"height":186,"url":"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_GreenBG_SQUARE_200x186.jpg","type":"image\/jpeg"}],"author":"Nils Rooijmans","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nils Rooijmans","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated#article","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated"},"author":{"name":"Nils Rooijmans","@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"headline":"newsletter ideas based on your trending search terms &#8211; part 2 (fully automated)","datePublished":"2024-10-02T20:49:00+00:00","dateModified":"2024-10-04T08:49:03+00:00","mainEntityOfPage":{"@id":"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated"},"wordCount":158,"publisher":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"articleSection":["Google Ads"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated","url":"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated","name":"newsletter ideas based on your trending search terms - part 2 (fully automated) - Nils Rooijmans","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#website"},"datePublished":"2024-10-02T20:49:00+00:00","dateModified":"2024-10-04T08:49:03+00:00","breadcrumb":{"@id":"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nilsrooijmans.com\/daily\/newsletter-ideas-based-on-your-trending-search-terms-part-2-fully-automated#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nilsrooijmans.com\/daily"},{"@type":"ListItem","position":2,"name":"newsletter ideas based on your trending search terms &#8211; part 2 (fully automated)"}]},{"@type":"WebSite","@id":"https:\/\/nilsrooijmans.com\/daily\/#website","url":"https:\/\/nilsrooijmans.com\/daily\/","name":"Nils Rooijmans Daily Newsletter - Google Ads","description":"Daily emails to boost your Google Ads Performance","publisher":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nilsrooijmans.com\/daily\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0","name":"Nils Rooijmans","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/","url":"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg","contentUrl":"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg","width":300,"height":300,"caption":"Nils Rooijmans"},"logo":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/"},"description":"Google Ads Performance Architect with a passion for PPC Automation &amp; AI, in particular via Google Ads Scripts.","sameAs":["https:\/\/nilsrooijmans.com\/","https:\/\/www.linkedin.com\/in\/nilsrooijmans\/"],"url":"https:\/\/nilsrooijmans.com\/daily\/author\/nils"}]}},"_links":{"self":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/1085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/comments?post=1085"}],"version-history":[{"count":1,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/1085\/revisions"}],"predecessor-version":[{"id":1086,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/1085\/revisions\/1086"}],"wp:attachment":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/media?parent=1085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/categories?post=1085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/tags?post=1085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}