What's new

SEM (SEO & Paid Search) Mastermind

Welcome to the only entrepreneur forum dedicated to building life-changing wealth.

Build a Fastlane business. Earn real financial freedom. Live your best life.

Tired of paying for dead communities hosted by absent gurus who don't have time for you?

Imagine having a multi-millionaire mentor by your side EVERY. SINGLE. DAY. Since 2007, MJ DeMarco has been a cornerstone of Fastlane, actively contributing on over 99% of days—99.92% to be exact! With more than 39,000 game-changing posts, he's dedicated to helping entrepreneurs achieve their freedom. Join a thriving community of over 90,000 members and access a vast library of over 1,000,000 posts from entrepreneurs around the globe.

Forum membership removes this block.
<div class="bbWrapper">I&#039;m happy to hop on a Zoom with them to be a sounding board - for paid search, agency thoughts, and their landing page offering. <br /> <br /> I&#039;m better at paid search than building an agency (which has never been a goal).<br /> <br /> Me and <a href="https://www.thefastlaneforum.com/community/members/16090/" class="username" data-xf-init="member-tooltip" data-user-id="16090" data-username="@eliquid">@eliquid</a> had a recorded chat many moons ago and dropped it into the forum. I think it was pretty evergreen.</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 23590" data-quote="Andy Black" data-source="post: 1146279" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146279" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146279">Andy Black said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> Me and @eliquid had a recorded chat many moons ago and dropped it into the forum. I think it was pretty evergreen. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> For those who are interested in hearing the call:<br /> <br /> <div class="embed fauxBlockLink" data-embed-content="thread-88694" data-embed-content-url="https://www.thefastlaneforum.com/community/threads/andy-shoots-the-breeze-with-eliquid.88694/"> <div class="embed-container contentRow contentRow--alignMiddle"> <div class="contentRow-figure"> <a href="/community/members/andy-black.23590/" class="avatar avatar--s" data-user-id="23590" data-xf-init="member-tooltip"> <img src="/community/data/avatars/s/23/23590.jpg?1656839584" srcset="/community/data/avatars/m/23/23590.jpg?1656839584 2x" alt="Andy Black" class="avatar-u23590-s" width="48" height="48" loading="lazy" /> </a> </div> <div class="contentRow-main"> <h3 class="contentRow-header"> <span class="label prefixHot" dir="auto">HOT!</span> <a href="/community/threads/andy-shoots-the-breeze-with-eliquid.88694/" class="fauxBlockLink-blockLink u-cloaked">Thread 'Andy shoots the breeze with eliquid'</a> </h3> <div class="contentRow-minor contentRow-minor--hideLinks"> <time class="u-dt" dir="auto" datetime="2019-05-22T18:17:49-0400" data-timestamp="1558563469" data-date="May 22, 2019" data-time="6:17 PM" data-short="May &#039;19" title="May 22, 2019 at 6:17 PM">May 22, 2019</time> </div> </div> </div> <div class="embed-preview"> <div class="bbWrapper">Me and <a href="https://www.thefastlaneforum.com/community/members/16090/" class="username" data-xf-init="member-tooltip" data-user-id="16090" data-username="@eliquid">@eliquid</a> have been meaning to chat for years, and finally got round to it.<br /> <br /> Here&#039;s 90 minutes of us chatting, knowing we&#039;re probably going to drop it into the forum.<br /> <br /> Apologies that at about 30 mins it starts lagging. We turned off our videos and it gets a bit better. There&#039;s some periods in the middle where we lose Jason a bit, but it&#039;s great hearing his counter intuitive ideas about procrastination and other things.<br /> <br /> <br /> <br /> EDIT: 07-Nov-24 ... I got NoteBookLM and ChatGPT to write summaries based on the transcript:<br /> <br /> <b>### NoteBookLM:</b><br /> <h2 class="bbHeading"><a class="u-anchorTarget" name="-lone-wolves-passion-projects-and"></a>Lone Wolves, Passion Projects, and...&#8203;<a class="hoverLink" href="#-lone-wolves-passion-projects-and" title="Permanent link"></a></h2></div> </div> <div class="embed-footer"> <div class="embed-footer-main"> <ul class="listInline listInline--bullet"> <li><a href="/community/members/andy-black.23590/" class="username " dir="auto" data-user-id="23590" data-xf-init="member-tooltip"><span class="username--staff username--moderator">Andy Black</span></a></li> <li> <span class="tagItem tagItem--tag_google-ads" dir="auto"> google ads </span> <span class="tagItem tagItem--tag_procrastination" dir="auto"> procrastination </span> <span class="tagItem tagItem--tag_profiling" dir="auto"> profiling </span> <span class="tagItem tagItem--tag_saas" dir="auto"> saas </span> </li> <li>Replies: 42</li> <li>Forum: <a href="/community/forums/entrepreneur-startup-execution/">General Business Discussion</a></li> </ul> </div> <div class="embed-footer-opposite"> <ul class="reactionSummary"> <li><span class="reaction reaction--small reaction--1" data-reaction-id="1"><i aria-hidden="true"></i><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" loading="lazy" class="reaction-sprite js-reaction" alt="Like" title="Like" /></span></li> </ul> </div> </div> </div></div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 80" data-quote="LightHouse" data-source="post: 1146259" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146259" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146259">LightHouse said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> #1 I have a contact that is in at the ground floor building a paid search company, knowing peers are a shortcut, have you all seen any paid groups where someone with under $10k/mo rev can join to learn and network? </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> I dont know of any Good ones.<br /> <br /> I&#039;ve joined a lot of groups over the years and they all pretty much suck and are horrible.<br /> <br /> No joke.</div>
 
<div class="bbWrapper">Keeping an on this as I&#039;ve just launched a carpet cleaning and restoration business in Utah. Right now I&#039;m interviewing 2 different digital marketing agencies that specialize in home services / restoration. <br /> <br /> I imagine most of the budget initially will go into Google PPC and LSA. They both offer different service packages at different price points, so will have to see where I think I get the most bang for my buck.</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 70298" data-quote="Bones81" data-source="post: 1146742" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146742" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146742">Bones81 said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> Keeping an on this as I&#039;ve just launched a carpet cleaning and restoration business in Utah. Right now I&#039;m interviewing 2 different digital marketing agencies that specialize in home services / restoration.<br /> <br /> I imagine most of the budget initially will go into Google PPC and LSA. They both offer different service packages at different price points, so will have to see where I think I get the most bang for my buck. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> Congrats. I think I remember you starting a thread about buying a business.</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 23590" data-quote="Andy Black" data-source="post: 1146264" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146264" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146264">Andy Black said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> I&#039;m not in any paid groups. Is it the paid search or the agency building they&#039;re most interested in? </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> It&#039;s paid search first as a freelancer but working towards building it up. So to clarify right now it&#039;s getting clients consistently, no need to scale or build at the moment.<br /> <br /> <br /> <blockquote data-attributes="member: 23590" data-quote="Andy Black" data-source="post: 1146264" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146264" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146264">Andy Black said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> Sounds neat actually. Not something I&#039;d use as we developed our own solution that accepts the headline, bullets, and button copy via the ad. As the media buyer I can then test ad/lp combinations without touching the lp code. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> Got it, I think this software could build pages with the variable tags in place as well. Noted on you built something in house, I am wondering if this is the case across the board.<br /> <br /> <br /> <blockquote data-attributes="member: 23590" data-quote="Andy Black" data-source="post: 1146264" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146264" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146264">Andy Black said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> Hmmm. I&#039;ll have a think about that. The time consuming part is finding the angles to test based on keyword research or search term analysis. To date I get the insights when I analyse the data myself. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> This is a great data point as well. Could AI handle the interpretation based on the data, and could it even help build the right logic so you don&#039;t have to do all the thinking to set it up. Very insightful. <br /> <br /> This isn&#039;t my company or my product but you know how exciting solving problems and challenges is <img src="/community/imgs/emoticons/em-smile2.png" class="smilie" loading="lazy" alt=":)" title="Smile :)" data-shortname=":)" /></div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 72777" data-quote="BizyDad" data-source="post: 1146273" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146273" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146273">BizyDad said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> I&#039;ll defer to Andy. <br /> <br /> <br /> <br /> Sounds like? Yes. <br /> <br /> In practice we have our own proprietary CMS and are building/have built tools like this already. <br /> <br /> But I also don&#039;t scale campaigns like Andy does, so he&#039;s more &quot;target market&quot; for this than I. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> I think you will find this interesting. I&#039;ve asked him to make a demo, he can either post it himself here or maybe I can link you two direct after you watch the demo and see what feedback you have. It may be a force multiplier now or could be built into one in the future.</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 16090" data-quote="eliquid" data-source="post: 1146297" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146297" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146297">eliquid said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> I dont know of any Good ones.<br /> <br /> I&#039;ve joined a lot of groups over the years and they all pretty much suck and are horrible.<br /> <br /> No joke. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> Appreciate that. Crazy there isn&#039;t anything reputable or if there is, it&#039;s hard to find. <br /> <br /> BTW I haven&#039;t been on X as much so I haven&#039;t seen your posts, are you cross posting to LinkedIn? (I have found it to be a better platform currently for that type of thought leadership, Andy may reflect this as well)</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 80" data-quote="LightHouse" data-source="post: 1146937" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146937" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146937">LightHouse said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> It&#039;s paid search first as a freelancer but working towards building it up. So to clarify right now it&#039;s getting clients consistently, no need to scale or build at the moment. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote>This might be interesting then:<br /> <div class="embed fauxBlockLink" data-embed-content="thread-109850" data-embed-content-url="https://www.thefastlaneforum.com/community/threads/workshop-replay-selling-google-ads-as-a-service.109850/"> <div class="embed-container contentRow contentRow--alignMiddle"> <div class="contentRow-figure"> <a href="/community/members/andy-black.23590/" class="avatar avatar--s" data-user-id="23590" data-xf-init="member-tooltip"> <img src="/community/data/avatars/s/23/23590.jpg?1656839584" srcset="/community/data/avatars/m/23/23590.jpg?1656839584 2x" alt="Andy Black" class="avatar-u23590-s" width="48" height="48" loading="lazy" /> </a> </div> <div class="contentRow-main"> <h3 class="contentRow-header"> <span class="label label--gray" dir="auto">MARKETING</span> <a href="/community/threads/workshop-replay-selling-google-ads-as-a-service.109850/" class="fauxBlockLink-blockLink u-cloaked">Thread '[Workshop Replay] Selling Google Ads as a Service'</a> </h3> <div class="contentRow-minor contentRow-minor--hideLinks"> <time class="u-dt" dir="auto" datetime="2023-08-02T04:10:36-0400" data-timestamp="1690963836" data-date="Aug 2, 2023" data-time="4:10 AM" data-short="Aug &#039;23" title="Aug 2, 2023 at 4:10 AM">Aug 2, 2023</time> </div> </div> </div> <div class="embed-preview"> <div class="bbWrapper">Here&#039;s a presentation about how I started and am building a business that provides Google Ads as a service to other businesses.<br /> <br /> I did it for <a href="https://www.thefastlaneforum.com/community/members/33771/" class="username" data-xf-init="member-tooltip" data-user-id="33771" data-username="@Fox">@Fox</a> &#039;s paid web design group last year and he&#039;s kindly allowed me to share it.<br /> <br /> It should also help people starting other businesses.<br /> <br /> Let me know what your main takeaways are.<br /> <br /> <br /> <div class="bbMediaWrapper" data-media-site-id="youtube" data-media-key="9kn79FWQAXk"> <div class="bbMediaWrapper-inner"> <iframe src="https://www.youtube.com/embed/9kn79FWQAXk?wmode=opaque" loading="lazy" width="560" height="315" frameborder="0" allowfullscreen="true"></iframe> </div> </div><i><span style="font-size: 10px"><a href="https://youtu.be/9kn79FWQAXk" target="_blank" class="link link--external" rel="noopener">View: https://youtu.be/9kn79FWQAXk</a></span></i><br /> <br /> <br /> EDIT: I pointed Notebook LM at the video and asked what advice I&#039;d give someone starting a different business:<br /> <br /> <b>Initially, be open to various opportunities:</b> Andy mentioned that at the...</div> </div> <div class="embed-footer"> <div class="embed-footer-main"> <ul class="listInline listInline--bullet"> <li><a href="/community/members/andy-black.23590/" class="username " dir="auto" data-user-id="23590" data-xf-init="member-tooltip"><span class="username--staff username--moderator">Andy Black</span></a></li> <li> <span class="tagItem tagItem--tag_b2b" dir="auto"> b2b </span> <span class="tagItem tagItem--tag_b2b-lead-generation" dir="auto"> b2b lead generation </span> <span class="tagItem tagItem--tag_getting-started" dir="auto"> getting started </span> <span class="tagItem tagItem--tag_google-ads" dir="auto"> google ads </span> </li> <li>Replies: 19</li> <li>Forum: <a href="/community/forums/entrepreneur-startup-execution/">General Business Discussion</a></li> </ul> </div> <div class="embed-footer-opposite"> <ul class="reactionSummary"> <li><span class="reaction reaction--small reaction--1" data-reaction-id="1"><i aria-hidden="true"></i><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" loading="lazy" class="reaction-sprite js-reaction" alt="Like" title="Like" /></span></li><li><span class="reaction reaction--small reaction--7" data-reaction-id="7"><i aria-hidden="true"></i><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" loading="lazy" class="reaction-sprite js-reaction" alt="Thank You" title="Thank You" /></span></li><li><span class="reaction reaction--small reaction--2" data-reaction-id="2"><i aria-hidden="true"></i><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" loading="lazy" class="reaction-sprite js-reaction" alt="Love" title="Love" /></span></li> </ul> </div> </div> </div></div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 23590" data-quote="Andy Black" data-source="post: 1146943" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146943" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146943">Andy Black said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> This might be interesting then:<br /> <div class="embed fauxBlockLink" data-embed-content="thread-109850" data-embed-content-url="https://www.thefastlaneforum.com/community/threads/workshop-replay-selling-google-ads-as-a-service.109850/"> <div class="embed-container contentRow contentRow--alignMiddle"> <div class="contentRow-figure"> <a href="/community/members/andy-black.23590/" class="avatar avatar--s" data-user-id="23590" data-xf-init="member-tooltip"> <img src="/community/data/avatars/s/23/23590.jpg?1656839584" srcset="/community/data/avatars/m/23/23590.jpg?1656839584 2x" alt="Andy Black" class="avatar-u23590-s" width="48" height="48" loading="lazy" /> </a> </div> <div class="contentRow-main"> <h3 class="contentRow-header"> <span class="label label--gray" dir="auto">MARKETING</span> <a href="/community/threads/workshop-replay-selling-google-ads-as-a-service.109850/" class="fauxBlockLink-blockLink u-cloaked">Thread '[Workshop Replay] Selling Google Ads as a Service'</a> </h3> <div class="contentRow-minor contentRow-minor--hideLinks"> <time class="u-dt" dir="auto" datetime="2023-08-02T04:10:36-0400" data-timestamp="1690963836" data-date="Aug 2, 2023" data-time="4:10 AM" data-short="Aug &#039;23" title="Aug 2, 2023 at 4:10 AM">Aug 2, 2023</time> </div> </div> </div> <div class="embed-preview"> <div class="bbWrapper">Here&#039;s a presentation about how I started and am building a business that provides Google Ads as a service to other businesses.<br /> <br /> I did it for <a href="https://www.thefastlaneforum.com/community/members/33771/" class="username" data-xf-init="member-tooltip" data-user-id="33771" data-username="@Fox">@Fox</a> &#039;s paid web design group last year and he&#039;s kindly allowed me to share it.<br /> <br /> It should also help people starting other businesses.<br /> <br /> Let me know what your main takeaways are.<br /> <br /> <br /> <div class="bbMediaWrapper" data-media-site-id="youtube" data-media-key="9kn79FWQAXk"> <div class="bbMediaWrapper-inner"> <iframe src="https://www.youtube.com/embed/9kn79FWQAXk?wmode=opaque" loading="lazy" width="560" height="315" frameborder="0" allowfullscreen="true"></iframe> </div> </div><i><span style="font-size: 10px"><a href="https://youtu.be/9kn79FWQAXk" target="_blank" class="link link--external" rel="noopener">View: https://youtu.be/9kn79FWQAXk</a></span></i><br /> <br /> <br /> EDIT: I pointed Notebook LM at the video and asked what advice I&#039;d give someone starting a different business:<br /> <br /> <b>Initially, be open to various opportunities:</b> Andy mentioned that at the...</div> </div> <div class="embed-footer"> <div class="embed-footer-main"> <ul class="listInline listInline--bullet"> <li><a href="/community/members/andy-black.23590/" class="username " dir="auto" data-user-id="23590" data-xf-init="member-tooltip"><span class="username--staff username--moderator">Andy Black</span></a></li> <li> <span class="tagItem tagItem--tag_b2b" dir="auto"> b2b </span> <span class="tagItem tagItem--tag_b2b-lead-generation" dir="auto"> b2b lead generation </span> <span class="tagItem tagItem--tag_getting-started" dir="auto"> getting started </span> <span class="tagItem tagItem--tag_google-ads" dir="auto"> google ads </span> </li> <li>Replies: 19</li> <li>Forum: <a href="/community/forums/entrepreneur-startup-execution/">General Business Discussion</a></li> </ul> </div> <div class="embed-footer-opposite"> <ul class="reactionSummary"> <li><span class="reaction reaction--small reaction--1" data-reaction-id="1"><i aria-hidden="true"></i><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" loading="lazy" class="reaction-sprite js-reaction" alt="Like" title="Like" /></span></li><li><span class="reaction reaction--small reaction--7" data-reaction-id="7"><i aria-hidden="true"></i><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" loading="lazy" class="reaction-sprite js-reaction" alt="Thank You" title="Thank You" /></span></li><li><span class="reaction reaction--small reaction--2" data-reaction-id="2"><i aria-hidden="true"></i><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" loading="lazy" class="reaction-sprite js-reaction" alt="Love" title="Love" /></span></li> </ul> </div> </div> </div> </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> Sent it along, thanks for always putting your thoughts into video and sharing!</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 80" data-quote="LightHouse" data-source="post: 1146946" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1146946" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1146946">LightHouse said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> Sent it along, thanks for always putting your thoughts into video and sharing! </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote>Might be worth checking out the Inbound/Sales braindump in my signature too.<br /> <br /> And maybe watching me bouncing about on LinkedIn? Most of my LinkedIn posts appeal to peers but the occasional prospect DMs me and ends up becoming a client. Also, I treat LinkedIn as a landing page first and foremost - so a word-of-mouth referal who Google&#039;s for me can find my profile and do a deep-dive. I&#039;ve yet to figure out how to post content that generates lots of DMs or email signups. Working on it though.</div>
 
<div class="bbWrapper">I have a client who serves the entire county of Surrey.<br /> <br /> Should I create a landing page for each town / city in Surrey for his services? I feel like that could get me deindexed from Google pretty fast. <b>Besides, if you break it down per city, his services get low search volume.</b><br /> <br /> I&#039;ve opted to create him a landing page aimed at Surrey. I&#039;ve mentioned several towns / cities within Surrey and I think I&#039;ve got a nice edge because his competition hasn&#039;t localised thier pages at all.</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 145549" data-quote="FJ123" data-source="post: 1147135" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1147135" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1147135">FJ123 said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> I have a client who serves the entire county of Surrey.<br /> <br /> Should I create a landing page for each town / city in Surrey for his services? I feel like that could get me deindexed from Google pretty fast. <b>Besides, if you break it down per city, his services get low search volume.</b><br /> <br /> I&#039;ve opted to create him a landing page aimed at Surrey. I&#039;ve mentioned several towns / cities within Surrey and I think I&#039;ve got a nice edge because his competition hasn&#039;t localised thier pages at all. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote> <div class="bbCodeBlock bbCodeBlock--unfurl is-pending is-recrawl js-unfurl fauxBlockLink" data-unfurl="true" data-result-id="430604" data-url="https://www.linkedin.com/posts/andyblackjnr_dynamic-mobile-landing-pages-for-google-activity-7110252685555060736-rASD?utm_source=share&amp;utm_medium=member_android" data-host="www.linkedin.com" data-pending="true"> <div class="contentRow"> <div class="contentRow-figure contentRow-figure--fixedSmall js-unfurl-figure"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fc45fy346jw096z9pbphyyhdz7&amp;hash=b5f75e2019b3565ae669bbb862b70477&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-image" data-onerror="hide-parent"/> </div> <div class="contentRow-main"> <h3 class="contentRow-header js-unfurl-title"> <a href="https://www.linkedin.com/posts/andyblackjnr_dynamic-mobile-landing-pages-for-google-activity-7110252685555060736-rASD?utm_source=share&amp;utm_medium=member_android" class="link link--external fauxBlockLink-blockLink" target="_blank" rel="noopener" data-proxy-href=""> Dynamic Mobile Landing Pages (for Google Ads) | Andy Black | 59 comments </a> </h3> <div class="contentRow-snippet js-unfurl-desc">Here&#039;s how we generate leads for local service businesses using Google Ads and mobile landing pages. The pages are dynamic - meaning we pass different headlines, bullet points, and even button copy to the page via the ad URL. If you&#039;d like a copy of the Google sheet we use to test how ads and...</div> <div class="contentRow-minor contentRow-minor--hideLinks"> <span class="js-unfurl-favicon"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fal2o9zrvru7aqj8e1x2rzsrca&amp;hash=812bbef932ea824a70c5247c1c7959e4&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-icon" data-onerror="hide-parent"/> </span> www.linkedin.com </div> </div> </div> </div></div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 23590" data-quote="Andy Black" data-source="post: 1147136" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1147136" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1147136">Andy Black said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> <div class="bbCodeBlock bbCodeBlock--unfurl is-pending is-recrawl js-unfurl fauxBlockLink" data-unfurl="true" data-result-id="430604" data-url="https://www.linkedin.com/posts/andyblackjnr_dynamic-mobile-landing-pages-for-google-activity-7110252685555060736-rASD?utm_source=share&amp;utm_medium=member_android" data-host="www.linkedin.com" data-pending="true"> <div class="contentRow"> <div class="contentRow-figure contentRow-figure--fixedSmall js-unfurl-figure"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fc45fy346jw096z9pbphyyhdz7&amp;hash=b5f75e2019b3565ae669bbb862b70477&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-image" data-onerror="hide-parent"/> </div> <div class="contentRow-main"> <h3 class="contentRow-header js-unfurl-title"> <a href="https://www.linkedin.com/posts/andyblackjnr_dynamic-mobile-landing-pages-for-google-activity-7110252685555060736-rASD?utm_source=share&amp;utm_medium=member_android" class="link link--external fauxBlockLink-blockLink" target="_blank" rel="nofollow ugc noopener" data-proxy-href=""> Dynamic Mobile Landing Pages (for Google Ads) | Andy Black | 59 comments </a> </h3> <div class="contentRow-snippet js-unfurl-desc">Here&#039;s how we generate leads for local service businesses using Google Ads and mobile landing pages. The pages are dynamic - meaning we pass different headlines, bullet points, and even button copy to the page via the ad URL. If you&#039;d like a copy of the Google sheet we use to test how ads and...</div> <div class="contentRow-minor contentRow-minor--hideLinks"> <span class="js-unfurl-favicon"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fal2o9zrvru7aqj8e1x2rzsrca&amp;hash=812bbef932ea824a70c5247c1c7959e4&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-icon" data-onerror="hide-parent"/> </span> www.linkedin.com </div> </div> </div> </div> </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote>Thanks for that Andy. I should of mentioned that this is for SEO, not ads.</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 145549" data-quote="FJ123" data-source="post: 1147135" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1147135" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1147135">FJ123 said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> I have a client who serves the entire county of Surrey.<br /> <br /> Should I create a landing page for each town / city in Surrey for his services? I feel like that could get me deindexed from Google pretty fast. <b>Besides, if you break it down per city, his services get low search volume.</b><br /> <br /> I&#039;ve opted to create him a landing page aimed at Surrey. I&#039;ve mentioned several towns / cities within Surrey and I think I&#039;ve got a nice edge because his competition hasn&#039;t localised thier pages at all. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> Obviously, I don&#039;t have all the info here. I am assuming he currently doesn&#039;t rank well for anything. <br /> <br /> In that kind of situation, I create a page for each service, and then in the title tag use two cities. Preferably the cities that are closest to his address. <br /> <br /> Once those pages are ranking very well, I might add a third city to those pages, then I might look to add the kinds of pages you&#039;re talking about. <br /> <br /> Also, I would probably use the home page to aim at Surrey...<br /> <br /> Hope that helps</div>
 
<div class="bbWrapper">Interesting. I presume the ads will be triggered by keywords?<br /> <div class="bbCodeBlock bbCodeBlock--unfurl is-pending is-recrawl js-unfurl fauxBlockLink" data-unfurl="true" data-result-id="430623" data-url="https://searchengineland.com/perplexity-begins-testing-ads-448277" data-host="searchengineland.com" data-pending="true"> <div class="contentRow"> <div class="contentRow-figure contentRow-figure--fixedSmall js-unfurl-figure"> <img src="/community/proxy.php?image=https%3A%2F%2Fsearchengineland.com%2Fwp-content%2Fseloads%2F2024%2F11%2FAI-search-engine-1920-800x457.png&amp;hash=85182b8ae413cc0699d2c0ed1dc0cbab&amp;return_error=1" loading="lazy" alt="searchengineland.com" class="bbCodeBlockUnfurl-image" data-onerror="hide-parent"/> </div> <div class="contentRow-main"> <h3 class="contentRow-header js-unfurl-title"> <a href="https://searchengineland.com/perplexity-begins-testing-ads-448277" class="link link--external fauxBlockLink-blockLink" target="_blank" rel="noopener" data-proxy-href=""> Perplexity begins testing ads as sponsored follow-up questions </a> </h3> <div class="contentRow-snippet js-unfurl-desc">U.S. users will start seeing sponsored questions this week. Answers to the questions will be generated by Perplexity, not advertisers.</div> <div class="contentRow-minor contentRow-minor--hideLinks"> <span class="js-unfurl-favicon"> <img src="/community/proxy.php?image=https%3A%2F%2Fsearchengineland.com%2Fapple-touch-icon.png&amp;hash=0045f5cd381d2febf9cf2c0cd27c2140&amp;return_error=1" loading="lazy" alt="searchengineland.com" class="bbCodeBlockUnfurl-icon" data-onerror="hide-parent"/> </span> searchengineland.com </div> </div> </div> </div></div>
 
<div class="bbWrapper">Reviews are crucial for local SEO.<br /> <br /> I made scannable business cards that let customers easily leave reviews. You can send these to your clients (or use them yourself).\<br /> <br /> <div> <a href="https://www.canva.com/design/DAGW2Mbis4Q/smTsBvVqf3h-Oi8CS5yggw/edit?utm_content=DAGW2Mbis4Q&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton" class="link link--external" target="_blank" rel="noopener" data-proxy-href=""> https://www.canva.com/design/DAGW2Mbis4Q/smTsBvVqf3h-Oi8CS5yggw/edit?utm_content=DAGW2Mbis4Q&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton </a> </div> <br /> Happy review gathering <img src="/community/imgs/emoticons/em-thumbsup.png" class="smilie" loading="lazy" alt=":thumbsup:" title="Thumbs Up :thumbsup:" data-shortname=":thumbsup:" /></div>
 
<div class="bbWrapper">This is a little different than traditional SEO, but perplexity (an LLM powered search engine) just released a shopping feature. It&#039;s probably inevitable that ads made their way into some of these new search tools, so I thought that it was worth mentioning.<br /> <br /> <div> <a href="https://www.perplexity.ai/shopping" class="link link--external" target="_blank" rel="noopener" data-proxy-href=""> https://www.perplexity.ai/shopping </a> </div></div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 48368" data-quote="WillHurtDontCare" data-source="post: 1147546" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1147546" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1147546">WillHurtDontCare said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> This is a little different than traditional SEO, but perplexity (an LLM powered search engine) just released a shopping feature. It&#039;s probably inevitable that ads made their way into some of these new search tools, so I thought that it was worth mentioning.<br /> <br /> <div> <a href="https://www.perplexity.ai/shopping" class="link link--external" target="_blank" rel="nofollow ugc noopener" data-proxy-href=""> https://www.perplexity.ai/shopping </a> </div> </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> I do feel like SEO needs to evolve to SO. People do search more than just on search engines...</div>
 
<div class="bbWrapper">Posted this today:<br /> <div class="bbCodeBlock bbCodeBlock--unfurl js-unfurl fauxBlockLink" data-unfurl="true" data-result-id="432400" data-url="https://www.linkedin.com/posts/andyblackjnr_the-ad-preview-tool-activity-7267858252019765248-uzwv?utm_source=share&amp;utm_medium=member_desktop" data-host="www.linkedin.com" data-pending="false"> <div class="contentRow"> <div class="contentRow-figure contentRow-figure--fixedSmall js-unfurl-figure"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fc45fy346jw096z9pbphyyhdz7&amp;hash=b5f75e2019b3565ae669bbb862b70477&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-image" data-onerror="hide-parent"/> </div> <div class="contentRow-main"> <h3 class="contentRow-header js-unfurl-title"> <a href="https://www.linkedin.com/posts/andyblackjnr_the-ad-preview-tool-activity-7267858252019765248-uzwv?utm_source=share&amp;utm_medium=member_desktop" class="link link--external fauxBlockLink-blockLink" target="_blank" rel="noopener" data-proxy-href=""> Andy Black on LinkedIn: The Ad Preview Tool </a> </h3> <div class="contentRow-snippet js-unfurl-desc">We loaded 1,070 keywords and ads last night (that&#039;s one keyword and ad for each of the top 1,000 cities in the UK, the names of all the counties, plus…</div> <div class="contentRow-minor contentRow-minor--hideLinks"> <span class="js-unfurl-favicon"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fal2o9zrvru7aqj8e1x2rzsrca&amp;hash=812bbef932ea824a70c5247c1c7959e4&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-icon" data-onerror="hide-parent"/> </span> www.linkedin.com </div> </div> </div> </div> <br /> Here&#039;s some others I posted. Not sure if I&#039;ve linked to them in here:<br /> <div class="bbCodeBlock bbCodeBlock--unfurl js-unfurl fauxBlockLink" data-unfurl="true" data-result-id="432401" data-url="https://www.linkedin.com/posts/andyblackjnr_a-common-google-ads-mistake-activity-7264250321168691200-CT8e?utm_source=share&amp;utm_medium=member_desktop" data-host="www.linkedin.com" data-pending="false"> <div class="contentRow"> <div class="contentRow-figure contentRow-figure--fixedSmall js-unfurl-figure"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fc45fy346jw096z9pbphyyhdz7&amp;hash=b5f75e2019b3565ae669bbb862b70477&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-image" data-onerror="hide-parent"/> </div> <div class="contentRow-main"> <h3 class="contentRow-header js-unfurl-title"> <a href="https://www.linkedin.com/posts/andyblackjnr_a-common-google-ads-mistake-activity-7264250321168691200-CT8e?utm_source=share&amp;utm_medium=member_desktop" class="link link--external fauxBlockLink-blockLink" target="_blank" rel="noopener" data-proxy-href=""> Andy Black on LinkedIn: A Common Google Ads Mistake </a> </h3> <div class="contentRow-snippet js-unfurl-desc">A common Google Ads mistake is to add multiple keywords and ad headlines into ONE ad group thinking the right headlines show when keywords are…</div> <div class="contentRow-minor contentRow-minor--hideLinks"> <span class="js-unfurl-favicon"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fal2o9zrvru7aqj8e1x2rzsrca&amp;hash=812bbef932ea824a70c5247c1c7959e4&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-icon" data-onerror="hide-parent"/> </span> www.linkedin.com </div> </div> </div> </div> <br /> <div class="bbCodeBlock bbCodeBlock--unfurl is-pending is-recrawl js-unfurl fauxBlockLink" data-unfurl="true" data-result-id="432399" data-url="https://www.linkedin.com/posts/andyblackjnr_some-google-ads-folks-tell-us-phrase-match-activity-7257666346405048321-y5C5?utm_source=share&amp;utm_medium=member_desktop" data-host="www.linkedin.com" data-pending="true"> <div class="contentRow"> <div class="contentRow-figure contentRow-figure--fixedSmall js-unfurl-figure"> <img src="/community/proxy.php?image=https%3A%2F%2Fmedia.licdn.com%2Fdms%2Fimage%2Fv2%2FD4E22AQH3ln18ArM1Vw%2Ffeedshare-shrink_2048_1536%2Ffeedshare-shrink_2048_1536%2F0%2F1730362497096%3Fe%3D2147483647%26v%3Dbeta%26t%3DfTU2WCqPkOtaiNmdnLydP_HcxYI_F2pC0agS2VxzUCI&amp;hash=0ac313f3326a123539bc3853dd3ba298&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-image" data-onerror="hide-parent"/> </div> <div class="contentRow-main"> <h3 class="contentRow-header js-unfurl-title"> <a href="https://www.linkedin.com/posts/andyblackjnr_some-google-ads-folks-tell-us-phrase-match-activity-7257666346405048321-y5C5?utm_source=share&amp;utm_medium=member_desktop" class="link link--external fauxBlockLink-blockLink" target="_blank" rel="noopener" data-proxy-href=""> Some Google Ads folks tell us phrase-match doesn&#039;t work, and others advise… | Andy Black | 61 comments </a> </h3> <div class="contentRow-snippet js-unfurl-desc">Some Google Ads folks tell us phrase-match doesn&#039;t work, and others advise us to just use broad-match because it has other signals/indicators that phrase and exact match don&#039;t have. We tested broad-match and will stick to phrase, thanks. From the screenshot attached: 1️⃣ We don&#039;t want ads...</div> <div class="contentRow-minor contentRow-minor--hideLinks"> <span class="js-unfurl-favicon"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fal2o9zrvru7aqj8e1x2rzsrca&amp;hash=812bbef932ea824a70c5247c1c7959e4&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-icon" data-onerror="hide-parent"/> </span> www.linkedin.com </div> </div> </div> </div></div>
 
<div class="bbWrapper">I was listening to a call on Google ads and got some basic advice that seemed quite useful for running search ads.<br /> <br /> &quot;Email your customers and ask them what they would search in Google to try to find your business.&quot; You could even ask in a survey.<br /> <br /> Obviously it&#039;s better if they just had the search console running for months and you already have the data, but here&#039;s another quick way to get started with businesses that are just starting with Google ads.</div>
 
<div class="bbWrapper">So if any of you want some tricks for reporting, you can upload data visualization images to Claude (Anthropic&#039;s version of ChatGPT - it&#039;s better), then ask it to create a Google ads script that exports ad data to google sheets and creates this heat map.<br /> <br /> Original image (from google image search)<br /> <br /> <b>prompt</b>: write me a google ads script that will export my campaigns data into google sheets, then create a heat map of impressions. I want the hour of the day to be the row, and the day of the week to be the column, and the sum of impressions occurring as the values at the intersection<br /> <br /> <a href="https://www.thefastlaneforum.com/community/attachments/1733162005361-webp.61248/" target="_blank"><img src="https://www.thefastlaneforum.com/community/data/attachments/57/57021-bc0a44b325640a5e449737b5e902699c.jpg?hash=IvH-HFnC7N" class="bbImage " style="" alt="1733162005361.webp" title="1733162005361.webp" width="308" height="200" loading="lazy" /></a><br /> <br /> The first 2 iterations resulted in errors, which I resolved by checking the logs, and copy &amp; pasting the error into Claude.<br /> <br /> <br /> Here is the working script if any of you are interested (though you might need to connect your Google Sheets account to your Google ads account):<br /> <br /> function applyHeatmapGradient(sheet, range, min, max) {<br /> // Define a single gradient rule for the range<br /> var rule = SpreadsheetApp.newConditionalFormatRule()<br /> .setGradientMinpointWithValue(&quot;#F8696B&quot;, SpreadsheetApp.InterpolationType.NUMBER, min.toString()) // Green for the minimum value<br /> .setGradientMidpointWithValue(&quot;#FFEB84&quot;, SpreadsheetApp.InterpolationType.NUMBER, ((min + max) / 2).toString()) // Yellow for the midpoint<br /> .setGradientMaxpointWithValue(&quot;#63BE7B&quot;, SpreadsheetApp.InterpolationType.NUMBER, max.toString()) // Red for the maximum value<br /> .setRanges([range])<br /> .build();<br /> <br /> // Apply the rule to the sheet<br /> sheet.setConditionalFormatRules([rule]);<br /> }<br /> <br /> function main() {<br /> var spreadsheetUrl = &quot;YOUR_SPREADSHEET_URL&quot;;<br /> var ss = SpreadsheetApp.openByUrl(spreadsheetUrl);<br /> var sheet = ss.getSheetByName(&quot;Impressions&quot;) || ss.insertSheet(&quot;Impressions&quot;);<br /> <br /> sheet.clear();<br /> <br /> var hourlyData = Array(24).fill().map(() =&gt; ({<br /> Monday: 0, Tuesday: 0, Wednesday: 0, Thursday: 0,<br /> Friday: 0, Saturday: 0, Sunday: 0<br /> }));<br /> <br /> var report = AdsApp.report(<br /> &quot;SELECT HourOfDay, DayOfWeek, Impressions &quot; +<br /> &quot;FROM CAMPAIGN_PERFORMANCE_REPORT &quot; +<br /> &quot;WHERE Impressions &gt; 0 &quot; +<br /> &quot;DURING LAST_30_DAYS&quot;);<br /> <br /> var rows = report.rows();<br /> while (rows.hasNext()) {<br /> var row = rows.next();<br /> var hour = parseInt(row[&#039;HourOfDay&#039;]);<br /> var day = row[&#039;DayOfWeek&#039;];<br /> var impressions = parseInt(row[&#039;Impressions&#039;]);<br /> hourlyData[hour][day] += impressions;<br /> }<br /> <br /> var headers = [&#039;Hour&#039;, &#039;Monday&#039;, &#039;Tuesday&#039;, &#039;Wednesday&#039;, &#039;Thursday&#039;, &#039;Friday&#039;, &#039;Saturday&#039;, &#039;Sunday&#039;];<br /> sheet.getRange(1, 1, 1, headers.length).setValues([headers]);<br /> <br /> var data = [];<br /> var min = Infinity;<br /> var max = -Infinity;<br /> <br /> for (var hour = 0; hour &lt; 24; hour++) {<br /> var row = [hour];<br /> headers.slice(1).forEach(day =&gt; {<br /> var value = hourlyData[hour][day];<br /> row.push(value);<br /> if (value &lt; min) min = value;<br /> if (value &gt; max) max = value;<br /> });<br /> data.push(row);<br /> }<br /> <br /> var dataRange = sheet.getRange(2, 1, 24, 8);<br /> dataRange.setValues(data);<br /> <br /> var range = sheet.getRange(2, 2, 24, 7);<br /> <br /> var min = 0; // Replace with your minimum value<br /> var max = 100; // Replace with your maximum value<br /> <br /> applyHeatmapGradient(sheet, range, min, max);<br /> <br /> <br /> sheet.getRange(1, 1, sheet.getLastRow(), 1).setHorizontalAlignment(&quot;center&quot;);<br /> <br /> for (var i = 1; i &lt;= 8; i++) {<br /> sheet.autoResizeColumn(i);<br /> }<br /> <br /> var chartRange = sheet.getRange(1, 1, 25, 8);<br /> var chart = sheet.newChart()<br /> .asColumnChart()<br /> .addRange(chartRange)<br /> .setPosition(26, 1, 0, 0)<br /> .setOption(&#039;title&#039;, &#039;Hourly Impressions&#039;)<br /> .build();<br /> <br /> sheet.insertChart(chart);<br /> }<br /> <br /> Edit: here is the result in Google Sheets<br /> <br /> <a href="https://www.thefastlaneforum.com/community/attachments/1733162383012-webp.61250/" target="_blank"><img src="https://www.thefastlaneforum.com/community/data/attachments/57/57022-56a27b2add80f95616487bb8767c9fc0.jpg?hash=FABlm9a2a0" class="bbImage " style="" alt="1733162383012.webp" title="1733162383012.webp" width="200" height="366" loading="lazy" /></a><br /> <br /> Edit 2: Also, it is insane how easy this was to make. Years I spent a few weeks making a heat map report for big corporate (which made them tens of millions in extra profit). This script 1) transformed some data 2) integrated two software platforms and 3) created a visualization off of an image and some really basic prompts</div>
 
Last edited:
<div class="bbWrapper">One of my clients has a niche business - he specializes in spray painting doors, windows, exterior walls, kitchen cabinets, and more. <br /> <br /> Essentially, he offers the same services as a decorator but with a focus on spray painting. I’ve already got him ranking #1 locally for terms like &quot;spray painter [town]&quot; and &quot;UPVC window painter in [town].&quot; But honestly, these keywords bring in little to no traffic.<br /> <br /> Yesterday, we discussed his priorities, and he told me he wants to focus on getting more kitchen spray painting enquiries, as they’re highly profitable. He’s even willing to travel nationally for these jobs because they’re worth the money.<br /> <br /> Now, I’ve never done national SEO before, so this will be a new challenge for me. My plan is to target keywords like &quot;kitchen spray painter&quot; on a national scale, since these terms actually get traffic, unlike the local ones we’ve been ranking for.<br /> <br /> That said, I’m starting to wonder if SEO will even pay off for him in the long run. It’s tough to say if ranking for national terms will bring in enough enquiries to make it worth the effort.</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 145549" data-quote="FJ123" data-source="post: 1149790" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1149790" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1149790">FJ123 said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> One of my clients has a niche business - he specializes in spray painting doors, windows, exterior walls, kitchen cabinets, and more. <br /> <br /> Essentially, he offers the same services as a decorator but with a focus on spray painting. I’ve already got him ranking #1 locally for terms like &quot;spray painter [town]&quot; and &quot;UPVC window painter in [town].&quot; But honestly, these keywords bring in little to no traffic.<br /> <br /> Yesterday, we discussed his priorities, and he told me he wants to focus on getting more kitchen spray painting enquiries, as they’re highly profitable. He’s even willing to travel nationally for these jobs because they’re worth the money.<br /> <br /> Now, I’ve never done national SEO before, so this will be a new challenge for me. My plan is to target keywords like &quot;kitchen spray painter&quot; on a national scale, since these terms actually get traffic, unlike the local ones we’ve been ranking for.<br /> <br /> That said, I’m starting to wonder if SEO will even pay off for him in the long run. It’s tough to say if ranking for national terms will bring in enough enquiries to make it worth the effort. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote>SEO isn&#039;t my thing, but for Google Ads I&#039;d do the following:<br /> <br /> Create a campaign targeting the whole country with keywords of &quot;kitchen spray painters &lt;location&gt;&quot; for the names of all states, counties, cities, subhurbs, towns, and villages. Put the location in the ad and landing page.<br /> <br /> Then create campaigns targeting each county with keywords of &quot;kitchen spray painters near me&quot; and similar. Put the county in the ad and landing page.</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 23590" data-quote="Andy Black" data-source="post: 1149817" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1149817" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1149817">Andy Black said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> SEO isn&#039;t my thing, but for Google Ads I&#039;d do the following:<br /> <br /> Create a campaign targeting the whole country with keywords of &quot;kitchen spray painters &lt;location&gt;&quot; for the names of all states, counties, cities, subhurbs, towns, and villages. Put the location in the ad and landing page.<br /> <br /> Then create campaigns targeting each county with keywords of &quot;kitchen spray painters near me&quot; and similar. Put the county in the ad and landing page. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote>I swear I wrote this up in the forum somewhere, maybe earlier in this thread?<br /> <br /> If not, I posted something about it a couple of weeks ago on LinkedIn:<br /> <br /> <div class="bbCodeBlock bbCodeBlock--unfurl js-unfurl fauxBlockLink" data-unfurl="true" data-result-id="433681" data-url="https://www.linkedin.com/posts/andyblackjnr_a-common-google-ads-mistake-activity-7264250321168691200-CT8e?utm_source=share&amp;utm_medium=member_android" data-host="www.linkedin.com" data-pending="false"> <div class="contentRow"> <div class="contentRow-figure contentRow-figure--fixedSmall js-unfurl-figure"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fc45fy346jw096z9pbphyyhdz7&amp;hash=b5f75e2019b3565ae669bbb862b70477&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-image" data-onerror="hide-parent"/> </div> <div class="contentRow-main"> <h3 class="contentRow-header js-unfurl-title"> <a href="https://www.linkedin.com/posts/andyblackjnr_a-common-google-ads-mistake-activity-7264250321168691200-CT8e?utm_source=share&amp;utm_medium=member_android" class="link link--external fauxBlockLink-blockLink" target="_blank" rel="noopener" data-proxy-href=""> Andy Black on LinkedIn: A Common Google Ads Mistake </a> </h3> <div class="contentRow-snippet js-unfurl-desc">A common Google Ads mistake is to add multiple keywords and ad headlines into ONE ad group thinking the right headlines show when keywords are…</div> <div class="contentRow-minor contentRow-minor--hideLinks"> <span class="js-unfurl-favicon"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fal2o9zrvru7aqj8e1x2rzsrca&amp;hash=812bbef932ea824a70c5247c1c7959e4&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-icon" data-onerror="hide-parent"/> </span> www.linkedin.com </div> </div> </div> </div></div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 145549" data-quote="FJ123" data-source="post: 1149790" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1149790" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1149790">FJ123 said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> One of my clients has a niche business - he specializes in spray painting doors, windows, exterior walls, kitchen cabinets, and more.<br /> <br /> Essentially, he offers the same services as a decorator but with a focus on spray painting. I’ve already got him ranking #1 locally for terms like &quot;spray painter [town]&quot; and &quot;UPVC window painter in [town].&quot; But honestly, these keywords bring in little to no traffic.<br /> <br /> Yesterday, we discussed his priorities, and he told me he wants to focus on getting more kitchen spray painting enquiries, as they’re highly profitable. He’s even willing to travel nationally for these jobs because they’re worth the money.<br /> <br /> Now, I’ve never done national SEO before, so this will be a new challenge for me. My plan is to target keywords like &quot;kitchen spray painter&quot; on a national scale, since these terms actually get traffic, unlike the local ones we’ve been ranking for.<br /> <br /> That said, I’m starting to wonder if SEO will even pay off for him in the long run. It’s tough to say if ranking for national terms will bring in enough enquiries to make it worth the effort. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote>I&#039;ve got a weird feeling ages ago I helped a client like this and there where running facebook ads for this specific niche.<br /> <br /> What you could be seeing is a market that isn&#039;t aware of the solution, and no one is making them solution aware to google it.<br /> <br /> So by running the ads on social media you put the brakes on them like oh crap i got to get the kitchen redone, oh well off to the cabinetmaker I guess. He&#039;s the only option. Then they see the ad and like oh there is a cheaper option, maybe I don&#039;t need to go to all that effort .<br /> <br /> But in saying that you may need to swim upstream on the keyword research to catch them not so problem aware. Lookup Eugene Schwartz five stages of awareness if not aware as could help flesh out some keyword ideas to target</div>
 
<div class="bbWrapper">I&#039;ll just chime in that national SEO for this phrase probably won&#039;t work. &quot; Kitchen spray painter&quot; is not a definitively commercial term based on the search results I&#039;m looking at. <br /> <br /> Now maybe there are better terms, but those terms are going to have a local bias. The odds of him ranking with local companies, okay maybe you can do it...<br /> <br /> But what are the odds that someone will hire him over a local company?<br /> <br /> Focus on ranking it locally in the maps. Try the Google ads strategy or the social strategy at the state level first. <br /> <br /> If you get results from that expand slowly. I doubt your client has the kind of budget to truly run a US nationwide campaign that will actually generate quality leads. <br /> <br /> Build slowly and grow into it. <br /> <br /> And while I&#039;m on the subject, I&#039;m not an expert at it, but if he had some YouTube videos in this space, those are ranking as well. A little SEO shortcut for you.<br /> <br /> Hope that helps.</div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 72777" data-quote="BizyDad" data-source="post: 1149835" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1149835" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1149835">BizyDad said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> I&#039;ll just chime in that national SEO for this phrase probably won&#039;t work. &quot; Kitchen spray painter&quot; is not a definitively commercial term based on the search results I&#039;m looking at.<br /> <br /> Now maybe there are better terms, but those terms are going to have a local bias. The odds of him ranking with local companies, okay maybe you can do it...<br /> <br /> But what are the odds that someone will hire him over a local company?<br /> <br /> Focus on ranking it locally in the maps. Try the Google ads strategy or the social strategy at the state level first.<br /> <br /> If you get results from that expand slowly. I doubt your client has the kind of budget to truly run a US nationwide campaign that will actually generate quality leads.<br /> <br /> Build slowly and grow into it.<br /> <br /> And while I&#039;m on the subject, I&#039;m not an expert at it, but if he had some YouTube videos in this space, those are ranking as well. A little SEO shortcut for you.<br /> <br /> Hope that helps. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote>Nice I totally forgot about YouTube and seo for local great tip for to start doing again</div>
 
<div class="bbWrapper">Posted a couple of days ago:<br /> <div class="bbCodeBlock bbCodeBlock--unfurl js-unfurl fauxBlockLink" data-unfurl="true" data-result-id="433720" data-url="https://www.linkedin.com/posts/andyblackjnr_selling-my-house-with-google-ads-activity-7269625220213137408-FVSg?utm_source=share&amp;utm_medium=member_android" data-host="www.linkedin.com" data-pending="false"> <div class="contentRow"> <div class="contentRow-figure contentRow-figure--fixedSmall js-unfurl-figure"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fc45fy346jw096z9pbphyyhdz7&amp;hash=b5f75e2019b3565ae669bbb862b70477&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-image" data-onerror="hide-parent"/> </div> <div class="contentRow-main"> <h3 class="contentRow-header js-unfurl-title"> <a href="https://www.linkedin.com/posts/andyblackjnr_selling-my-house-with-google-ads-activity-7269625220213137408-FVSg?utm_source=share&amp;utm_medium=member_android" class="link link--external fauxBlockLink-blockLink" target="_blank" rel="noopener" data-proxy-href=""> Andy Black on LinkedIn: Selling my house with Google Ads </a> </h3> <div class="contentRow-snippet js-unfurl-desc">Blimey. I just found the ancient Google Ads accounts I used to help sell my house in the UK after I moved to Ireland. My estate agent had listed the website…</div> <div class="contentRow-minor contentRow-minor--hideLinks"> <span class="js-unfurl-favicon"> <img src="/community/proxy.php?image=https%3A%2F%2Fstatic.licdn.com%2Faero-v1%2Fsc%2Fh%2Fal2o9zrvru7aqj8e1x2rzsrca&amp;hash=812bbef932ea824a70c5247c1c7959e4&amp;return_error=1" loading="lazy" alt="www.linkedin.com" class="bbCodeBlockUnfurl-icon" data-onerror="hide-parent"/> </span> www.linkedin.com </div> </div> </div> </div></div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 72777" data-quote="BizyDad" data-source="post: 1149835" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/community/goto/post?id=1149835" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-1149835">BizyDad said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> I&#039;ll just chime in that national SEO for this phrase probably won&#039;t work. &quot; Kitchen spray painter&quot; is not a definitively commercial term based on the search results I&#039;m looking at.<br /> <br /> Now maybe there are better terms, but those terms are going to have a local bias. The odds of him ranking with local companies, okay maybe you can do it...<br /> <br /> But what are the odds that someone will hire him over a local company?<br /> <br /> Focus on ranking it locally in the maps. Try the Google ads strategy or the social strategy at the state level first.<br /> <br /> If you get results from that expand slowly. I doubt your client has the kind of budget to truly run a US nationwide campaign that will actually generate quality leads.<br /> <br /> Build slowly and grow into it.<br /> <br /> And while I&#039;m on the subject, I&#039;m not an expert at it, but if he had some YouTube videos in this space, those are ranking as well. A little SEO shortcut for you.<br /> <br /> Hope that helps. </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> Thank you, that&#039;s very helpful.<br /> <br /> He is really keen to run facebook ads.<br /> <br /> I&#039;ve got him number 1 on maps for his home town already. So now it&#039;s a waiting game to see if anything results from it.<br /> <br /> I think local SEO won&#039;t really work here. As Mark said, no one knows this service exists. I bet if they knew you could get your kitchen repainted like this, he would get a few takers. I say this because all his customers are from word of mouth and he makes a decent living from it.</div>
 

Welcome to an Entrepreneurial Revolution

The Fastlane Forum empowers you to break free from conventional thinking to achieve financial freedom through UNSCRIPTED® Entrepreneurship where relative value and problem-solving are executed at scale. Living Unscripted® isn’t just a business strategy—it’s a way of life.

Follow MJ DeMarco

Get The Books that Change Lives...

The Fastlane entrepreneurial strategy is based on the CENTS Framework® which is based on the three best-selling books by MJ DeMarco.

mj demarco books
Back
Top Bottom