---
title: "Welcome To Our Robot Overlords: Measuring Brand Visibility In LLMs"
description: A no-code workflow that pipes ChatGPT analysis straight into Looker Studio dashboards. Plus three AI tools worth your attention this week.
image: https://www.johnsteeleconsulting.com/hubfs/JSC%20Linkedin%20OpenGraph%20Image%202.png
---

[Skip to content](https://www.johnsteeleconsulting.com/newsletter/issue-2-chatgpt-looker-studio-integration#main-content)

[![JSC (1200 x 240 px)](https://www.johnsteeleconsulting.com/hs-fs/hubfs/JSC%20(1200%20x%20240%20px).png?width=172&height=34&name=JSC%20(1200%20x%20240%20px).png)](https://www.johnsteeleconsulting.com)

- Services

    - [HubSpot Consulting](https://www.johnsteeleconsulting.com/hubspot-consulting)
    - [Automation & Analytics](https://www.johnsteeleconsulting.com/automation-analytics)
    - [Content Operations](https://www.johnsteeleconsulting.com/content-operations)
    - [Web & Content Development](https://www.johnsteeleconsulting.com/web-content-development)
- [Case Studies](https://www.johnsteeleconsulting.com/case-studies)

    - [WSI](https://www.johnsteeleconsulting.com/case-studies/wsi)
    - [Wiseman, Schwartz, Cioschi & Trama](https://www.johnsteeleconsulting.com/case-studies/wiseman-schwartz-cioschi-trama)
    - [Globe Runner](https://www.johnsteeleconsulting.com/case-studies/globe-runner)
    - [Documint](https://www.johnsteeleconsulting.com/case-studies/documint)
    - [FutureThink](https://www.johnsteeleconsulting.com/case-studies/futurethink)
- [JSC Labs](https://www.johnsteeleconsulting.com/jsc-labs)
- Resources

    - [Blog](https://www.johnsteeleconsulting.com/blog)
    - [Case Studies](https://www.johnsteeleconsulting.com/case-studies)
    - [Funnel Vision Newsletter](https://www.johnsteeleconsulting.com/newsletter)
    - [Funnel Vision Podcast](https://www.johnsteeleconsulting.com/funnel-vision-podcast)

Open main navigation

Close main navigation

- Services

    - [HubSpot Consulting](https://www.johnsteeleconsulting.com/hubspot-consulting)
    - [Automation & Analytics](https://www.johnsteeleconsulting.com/automation-analytics)
    - [Content Operations](https://www.johnsteeleconsulting.com/content-operations)
    - [Web & Content Development](https://www.johnsteeleconsulting.com/web-content-development)
- [Case Studies](https://www.johnsteeleconsulting.com/case-studies)

    - [WSI](https://www.johnsteeleconsulting.com/case-studies/wsi)
    - [Wiseman, Schwartz, Cioschi & Trama](https://www.johnsteeleconsulting.com/case-studies/wiseman-schwartz-cioschi-trama)
    - [Globe Runner](https://www.johnsteeleconsulting.com/case-studies/globe-runner)
    - [Documint](https://www.johnsteeleconsulting.com/case-studies/documint)
    - [FutureThink](https://www.johnsteeleconsulting.com/case-studies/futurethink)
- [JSC Labs](https://www.johnsteeleconsulting.com/jsc-labs)
- Resources

    - [Blog](https://www.johnsteeleconsulting.com/blog)
    - [Case Studies](https://www.johnsteeleconsulting.com/case-studies)
    - [Funnel Vision Newsletter](https://www.johnsteeleconsulting.com/newsletter)
    - [Funnel Vision Podcast](https://www.johnsteeleconsulting.com/funnel-vision-podcast)
- [CONTACT US](https://www.johnsteeleconsulting.com/contact)

[CONTACT US](https://www.johnsteeleconsulting.com/contact)

[All newsletters](https://www.johnsteeleconsulting.com/newsletter/all) August 22, 2025 | Issue 2

Content Operations

# welcome to our robot overlords

Measuring Brand Visibility In LLMs

![Airtable](https://www.johnsteeleconsulting.com/hubfs/62c6e2c47a58a4aa1fb77090-1.png) ![Slack](https://www.johnsteeleconsulting.com/hubfs/minsk-belarus-openai-chatgpt-logo-artifical-chatbot-system-chat-bot-button-web-app-phone-icon-symbol-editorial-vector-275376231%20(1).webp) ![Logo Name Here](https://www.johnsteeleconsulting.com/hubfs/Looker-Studio-Logo.png)

![welcome to our robot overlords](https://www.johnsteeleconsulting.com/hs-fs/hubfs/Blog%20Icons/JSC%20Services%20%20Blog%20Images%20(29).png?width=200&name=JSC%20Services%20%20Blog%20Images%20(29).png "welcome to our robot overlords")

![Picture of John Steele](https://www.johnsteeleconsulting.com/hs-fs/hubfs/1651756967091.jpeg?width=56&height=56&name=1651756967091.jpeg)

By   John Steele ·  1 minute read

For all the hype, you might be surprised to learn that AI’s share of voice in search remains incredibly small--just 5%.

But AI’s user growth in just a few months has been staggering. [83% of users](https://innovatingwithai.com/is-ai-search-replacing-traditional-search/) who have tried it now say they prefer AI search. [61% of GenZ and 53% of millennials](https://searchengineland.com/google-search-less-useful-survey-452700) are using AI search instead of traditional engines.

Numbers like these have left brand and especially smaller insurgents scrambling to find answers: are we visible?

How do we update content?

Where do we stand?

 

![email divider](https://www.johnsteeleconsulting.com/hs-fs/hubfs/email%20divider-1.png?upscale=true&upscale=true&width=796&height=44&name=email%20divider-1.png)

![w2w header](https://www.johnsteeleconsulting.com/hs-fs/hubfs/workflow%20to%20watch%201-1.png?width=327&height=102&name=workflow%20to%20watch%201-1.png)

 

Using largely existing tools and keywords, teams can measure brand visibility in LLMs.

 

![workflow to watch](https://www.johnsteeleconsulting.com/hs-fs/hubfs/JSC%20Email%20Newsletter%20(9).png?width=531&height=58&name=JSC%20Email%20Newsletter%20(9).png)

 

 

![iotw head 1](https://www.johnsteeleconsulting.com/hs-fs/hubfs/iotw%20head%201.png?upscale=true&upscale=true&width=467&height=70&name=iotw%20head%201.png)

Household names and startups alike are desperate to get in on the ground floor of what many believe will be the next phase in search. While LLMs share of voice in the overall search ecosystem is small, the writing is on the wall. People want to know where they stand and how they can compete.

---

 

![iotw head 2](https://www.johnsteeleconsulting.com/hs-fs/hubfs/iotw%20head%202.png?upscale=true&upscale=true&width=406&height=70&name=iotw%20head%202.png)

› The ability to turn existing keywords into LLM prompts.

› Instant brand visibility scoring

› Sentiment analysis of your brand (and that of your competitors).

› On-demand reporting.

 

---

![iotw head 3-1](https://www.johnsteeleconsulting.com/hs-fs/hubfs/iotw%20head%203-1.png?upscale=true&upscale=true&width=407&height=70&name=iotw%20head%203-1.png)  
![iotw head 4](https://www.johnsteeleconsulting.com/hs-fs/hubfs/iotw%20head%204.png?upscale=true&upscale=true&width=374&height=46&name=iotw%20head%204.png)

 

› Place existing keywords and trigger workflow.

› Rewrite the keywords as prompts.

› Query LLM for brand mention and sentiment (if applicable).

› Enhance with data visualization, internal alerts and more.

---

 

![iotw head 5](https://www.johnsteeleconsulting.com/hs-fs/hubfs/iotw%20head%205.png?upscale=true&upscale=true&width=325&height=70&name=iotw%20head%205.png)

What will cost you thousands as a standalone product can be created using tools you may already have, fed by keyword research you’ve already completed. If you are looking for answers for anxious colleagues or just need a little peace of mind yourself, this is the one.

Want to build something like this for your business? [➡️ We can help ➡️](https://calendly.com/johnsteeleconsulting/30min?utm_campaign=17675184-Funnel%20Vision&utm_source=hs_email&utm_medium=email&_hsenc=p2ANqtz-_TUiYcXuThk7oo3A8P0dTF_6yRa3axrKjMgkO05Vs1I1rFRy8RK_7VR5T4S7nrvl9hdc41)

![email divider](https://www.johnsteeleconsulting.com/hs-fs/hubfs/email%20divider-1.png?upscale=true&upscale=true&width=1200&name=email%20divider-1.png)

![itn 7](https://www.johnsteeleconsulting.com/hs-fs/hubfs/itn%207.png?upscale=true&upscale=true&width=776&name=itn%207.png)

[![JSC Email Newsletter (4)](https://www.johnsteeleconsulting.com/hs-fs/hubfs/JSC%20Email%20Newsletter%20(4).png?width=195&height=236&name=JSC%20Email%20Newsletter%20(4).png)](https://www.lifewire.com/metricool-adobe-express-integration-11745266?utm_campaign=17675184-Funnel%20Vision&utm_source=hs_email&utm_medium=email&_hsenc=p2ANqtz-9mZt701yGo7-e3PID6OUU5TixbgjxlISSmvgEXCP2Ss1KMByfq_HTjBjrHMK7gVbfVTvkA)

![Funnel Vision 2\_7](https://www.johnsteeleconsulting.com/hs-fs/hubfs/Funnel%20Vision%202_7.png?width=260&height=68&name=Funnel%20Vision%202_7.png)

Metricool’s integration with Adobe Express brings optimal posting times, engagement trends, hashtag insights, and competitive benchmarks right into the design workflow, empowering smarter content decisions. [Learn more...](https://www.lifewire.com/metricool-adobe-express-integration-11745266?utm_campaign=17675184-Funnel%20Vision&utm_source=hs_email&utm_medium=email&_hsenc=p2ANqtz-9mZt701yGo7-e3PID6OUU5TixbgjxlISSmvgEXCP2Ss1KMByfq_HTjBjrHMK7gVbfVTvkA)

 

[![JSC Email Newsletter (5)](https://www.johnsteeleconsulting.com/hs-fs/hubfs/JSC%20Email%20Newsletter%20(5).png?width=196&height=246&name=JSC%20Email%20Newsletter%20(5).png)](https://martechedge.com/news/sitecore-partners-with-gradial-to-launch-agentic-ai-powered-marketing-automation?utm_campaign=17675184-Funnel%20Vision&utm_source=hs_email&utm_medium=email&_hsenc=p2ANqtz-9mZt701yGo7-e3PID6OUU5TixbgjxlISSmvgEXCP2Ss1KMByfq_HTjBjrHMK7gVbfVTvkA)

 ![Funnel Vision 2\_8](https://www.johnsteeleconsulting.com/hs-fs/hubfs/Funnel%20Vision%202_8.png?width=260&height=65&name=Funnel%20Vision%202_8.png)

Sitecore partners with Gradial to deliver agentic AI--the AI capable of advanced executive functioning--to their enterprise digital experience platform. The DXP that powers L'Oréal, Microsoft and Volvo committing to agentic means ceding more and more control at higher levels. [Learn more...](https://martechedge.com/news/sitecore-partners-with-gradial-to-launch-agentic-ai-powered-marketing-automation?utm_campaign=17675184-Funnel%20Vision&utm_source=hs_email&utm_medium=email&_hsenc=p2ANqtz-9mZt701yGo7-e3PID6OUU5TixbgjxlISSmvgEXCP2Ss1KMByfq_HTjBjrHMK7gVbfVTvkA)

 

[![JSC Email Newsletter (6)](https://www.johnsteeleconsulting.com/hs-fs/hubfs/JSC%20Email%20Newsletter%20(6).png?width=199&height=253&name=JSC%20Email%20Newsletter%20(6).png)](https://martech.org/hubspot-adds-another-crm-connector-this-time-with-claude/?utm_campaign=17675184-Funnel%20Vision&utm_source=hs_email&utm_medium=email&_hsenc=p2ANqtz-9mZt701yGo7-e3PID6OUU5TixbgjxlISSmvgEXCP2Ss1KMByfq_HTjBjrHMK7gVbfVTvkA)

 ![Funnel Vision 2\_9](https://www.johnsteeleconsulting.com/hs-fs/hubfs/Funnel%20Vision%202_9.png?width=260&height=73&name=Funnel%20Vision%202_9.png)

HubSpot now supports Claude in addition to ChatGPT, allowing users to generate and personalize marketing content directly within their CRM using Anthropic’s LLM. [Learn more...](https://martech.org/hubspot-adds-another-crm-connector-this-time-with-claude/?utm_campaign=17675184-Funnel%20Vision&utm_source=hs_email&utm_medium=email&_hsenc=p2ANqtz-9mZt701yGo7-e3PID6OUU5TixbgjxlISSmvgEXCP2Ss1KMByfq_HTjBjrHMK7gVbfVTvkA)

Photo credits: “[Yesterday, I went on my first official tour of the Adobe San Jose HQ…](https://www.flickr.com/photos/41256296@N07/25477032205)” by Lauren\_Hannah, cropped, licensed under [CC BY 2.0](https://creativecommons.org/licenses/by/2.0/)

Share <http://www.linkedin.com/shareArticle?mini=true&url=https://www.johnsteeleconsulting.com/newsletter/issue-2-chatgpt-looker-studio-integration> [mailto:?body=https://www.johnsteeleconsulting.com/newsletter/issue-2-chatgpt-looker-studio-integration](mailto:?body=https://www.johnsteeleconsulting.com/newsletter/issue-2-chatgpt-looker-studio-integration)

 

[![JSC (1200 x 240 px) (3)](https://www.johnsteeleconsulting.com/hs-fs/hubfs/JSC%20(1200%20x%20240%20px)%20(3).png?width=1200&height=240&name=JSC%20(1200%20x%20240%20px)%20(3).png "JSC (1200 x 240 px) (3)")](https://www.johnsteeleconsulting.com)

Grow your startup or small business by exploring the most efficient levers for short-term and long-term growth: Positioning, Content & Automation.

<https://www.linkedin.com/in/johsteele/> <https://www.instagram.com/jsc4you/> <https://www.youtube.com/@johnsteeleconsulting> [mailto:john@johnsteeleconsulting.com](mailto:john@johnsteeleconsulting.com)

pages

[Home](https://www.johnsteeleconsulting.com)

[HubSpot Consulting](https://www.johnsteeleconsulting.com/hubspot-consulting)

[Automation & Analytics](https://www.johnsteeleconsulting.com/automation-analytics)

[Content Operations](https://www.johnsteeleconsulting.com/content-operations)

[Web & Content Development](https://www.johnsteeleconsulting.com/web-content-development)

resources

[Blog](https://www.johnsteeleconsulting.com/blog)

[Case Studies](https://www.johnsteeleconsulting.com/case-studies)

[Funnel Vision Newsletter](https://www.johnsteeleconsulting.com/newsletter)  
[Funnel Vision Podcast](https://www.johnsteeleconsulting.com/funnel-vision-podcast)

 

Copyright © 2023, John Steele Consulting

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "John Steele",
    "url" : "https://www.johnsteeleconsulting.com/newsletter/author/john-steele"
  },
  "dateModified" : "2026-05-21T02:54:28.313Z",
  "datePublished" : "2025-08-22T18:07:24.000Z",
  "headline" : "Welcome To Our Robot Overlords: Measuring Brand Visibility In LLMs",
  "image" : [ "https://www.johnsteeleconsulting.com/hubfs/Blog%20Featured%20Images/37.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://www.johnsteeleconsulting.com/newsletter/issue-2-chatgpt-looker-studio-integration",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.johnsteeleconsulting.com/hubfs/JSC%20(1200%20x%20240%20px).png"
    },
    "name" : "John Steele Consulting"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.johnsteeleconsulting.com/#organization",
  "@type" : "Organization",
  "address" : {
    "@type" : "PostalAddress",
    "addressCountry" : "US",
    "addressLocality" : "Philadelphia",
    "addressRegion" : "PA"
  },
  "alternateName" : [ "JSC", "John Steele Consulting LLC" ],
  "areaServed" : {
    "@type" : "Place",
    "name" : "United States"
  },
  "description" : "Senior digital marketing consultancy for B2B startups and B2B SaaS. HubSpot CRM consulting, marketing automation, content operations, and web development — strategy and execution from one senior operator at $100/hour, project-based, no retainers.",
  "founder" : {
    "@id" : "https://www.johnsteeleconsulting.com/#john-steele"
  },
  "foundingDate" : "2022",
  "hasOfferCatalog" : {
    "@type" : "OfferCatalog",
    "itemListElement" : [ {
      "@type" : "Offer",
      "itemOffered" : {
        "@type" : "Service",
        "description" : "HubSpot CRM cleanup, attribution modeling, workflow automation, and ongoing HubSpot administration.",
        "name" : "HubSpot Consulting",
        "url" : "https://www.johnsteeleconsulting.com/hubspot-consulting"
      }
    }, {
      "@type" : "Offer",
      "itemOffered" : {
        "@type" : "Service",
        "description" : "Marketing automation, GA4/GTM implementation, attribution modeling, and executive dashboards.",
        "name" : "Automation & Analytics",
        "url" : "https://www.johnsteeleconsulting.com/automation-analytics"
      }
    }, {
      "@type" : "Offer",
      "itemOffered" : {
        "@type" : "Service",
        "description" : "Editorial systems, content ROI audits, AEO optimization, and topic strategy for B2B SaaS.",
        "name" : "Content Operations",
        "url" : "https://www.johnsteeleconsulting.com/content-operations"
      }
    }, {
      "@type" : "Offer",
      "itemOffered" : {
        "@type" : "Service",
        "description" : "Web design, custom HubSpot modules, email development, and content production.",
        "name" : "Web & Content Development",
        "url" : "https://www.johnsteeleconsulting.com/web-content-development"
      }
    } ],
    "name" : "JSC Service Lines"
  },
  "image" : "https://www.johnsteeleconsulting.com/hs-fs/hubfs/JSC%20(5)-1.png",
  "knowsAbout" : [ "HubSpot CRM consulting", "HubSpot CMS development", "HubSpot administration", "Marketing automation", "Marketing operations", "Marketing attribution", "GA4 and Google Tag Manager", "B2B SaaS marketing strategy", "Content operations", "Content strategy", "Editorial systems", "Answer Engine Optimization", "AI visibility optimization", "Web design and development", "Email campaign development", "Content production systems", "Lead scoring and routing", "B2B marketing analytics" ],
  "logo" : {
    "@type" : "ImageObject",
    "height" : 35,
    "url" : "https://www.johnsteeleconsulting.com/hs-fs/hubfs/JSC%20(5)-1.png",
    "width" : 175
  },
  "name" : "John Steele Consulting",
  "priceRange" : "$100/hour",
  "sameAs" : [ "https://www.linkedin.com/company/john-steele-consulting", "https://www.linkedin.com/in/johsteele/", "https://www.instagram.com/jsc4you/", "https://www.youtube.com/@johnsteeleconsluting" ],
  "slogan" : "Strategy and execution for B2B startups — built by one senior operator.",
  "url" : "https://www.johnsteeleconsulting.com"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.johnsteeleconsulting.com/#john-steele",
  "@type" : "Person",
  "description" : "12+ year senior digital marketing operator specializing in HubSpot CRM consulting, marketing automation, content operations, and B2B SaaS marketing strategy. Founder of John Steele Consulting and publisher of the Funnel Vision newsletter.",
  "image" : "https://www.johnsteeleconsulting.com/hs-fs/hubfs/1651756967091.jpeg",
  "jobTitle" : "Founder & Principal Consultant",
  "knowsAbout" : [ "HubSpot CRM", "Marketing automation", "Marketing attribution", "B2B SaaS marketing", "Content operations", "Answer Engine Optimization" ],
  "name" : "John Steele",
  "sameAs" : [ "https://www.linkedin.com/in/johsteele/" ],
  "url" : "https://www.johnsteeleconsulting.com",
  "worksFor" : {
    "@id" : "https://www.johnsteeleconsulting.com/#organization"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.johnsteeleconsulting.com/#website",
  "@type" : "WebSite",
  "description" : "Senior B2B marketing consulting — HubSpot, automation, content operations, and web development for B2B startups and SaaS.",
  "inLanguage" : "en-US",
  "name" : "John Steele Consulting",
  "publisher" : {
    "@id" : "https://www.johnsteeleconsulting.com/#organization"
  },
  "url" : "https://www.johnsteeleconsulting.com"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.johnsteeleconsulting.com/newsletter/issue-2-chatgpt-looker-studio-integration#article",
  "@type" : "Article",
  "about" : [ {
    "@type" : "Thing",
    "name" : "Marketing Automation"
  }, {
    "@type" : "Thing",
    "name" : "AI Workflows"
  }, {
    "@type" : "Thing",
    "name" : "Startup Marketing"
  } ],
  "articleSection" : "Marketing Automation",
  "author" : {
    "@id" : "https://www.johnsteeleconsulting.com/#john-steele",
    "@type" : "Person",
    "name" : "John Steele",
    "url" : "https://www.johnsteeleconsulting.com/meet-jsc"
  },
  "breadcrumb" : {
    "@type" : "BreadcrumbList",
    "itemListElement" : [ {
      "@type" : "ListItem",
      "item" : "https://www.johnsteeleconsulting.com",
      "name" : "Home",
      "position" : 1
    }, {
      "@type" : "ListItem",
      "item" : "https://www.johnsteeleconsulting.com/newsletter",
      "name" : "Funnel Vision Newsletter",
      "position" : 2
    }, {
      "@type" : "ListItem",
      "item" : "https://www.johnsteeleconsulting.com/newsletter/issue-2-chatgpt-looker-studio-integration",
      "name" : "Welcome To Our Robot Overlords: Measuring Brand Visibility In LLMs",
      "position" : 3
    } ]
  },
  "dateModified" : "2026-10-07T02:07:30+0000",
  "datePublished" : "2025-08-22T18:07:24+0000",
  "description" : "A no-code workflow that pipes ChatGPT analysis straight into Looker Studio dashboards. Plus three AI tools worth your attention this week.",
  "headline" : "Welcome To Our Robot Overlords: Measuring Brand Visibility In LLMs",
  "image" : {
    "@type" : "ImageObject",
    "height" : 458,
    "url" : "https://www.johnsteeleconsulting.com/hubfs/Blog%20Featured%20Images/37.png",
    "width" : 802
  },
  "inLanguage" : "en-US",
  "isPartOf" : {
    "@id" : "https://www.johnsteeleconsulting.com/newsletter#series",
    "@type" : "CreativeWorkSeries",
    "author" : {
      "@id" : "https://www.johnsteeleconsulting.com/#john-steele"
    },
    "description" : "A newsletter about marketing automation and AI workflows for startups and small businesses",
    "name" : "Funnel Vision Newsletter",
    "publisher" : {
      "@id" : "https://www.johnsteeleconsulting.com/#organization"
    }
  },
  "mainEntityOfPage" : {
    "@id" : "https://www.johnsteeleconsulting.com/newsletter/issue-2-chatgpt-looker-studio-integration",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@id" : "https://www.johnsteeleconsulting.com/#organization"
  }
}
```

```json
{
  "@context" : "http://schema.org",
  "@type" : "Article",
  "author" : {
    "@type" : "Person",
    "name" : [ "John Steele" ]
  },
  "datePublished" : "2025-08-22T18:07:24+0000",
  "description" : "A no-code workflow that pipes ChatGPT analysis straight into Looker Studio dashboards. Plus three AI tools worth your attention this week.",
  "headline" : "welcome to our robot overlords",
  "image" : "https://www.johnsteeleconsulting.com/hubfs/Blog%20Featured%20Images/37.png",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://24216250.fs1.hubspotusercontent-na1.net/hubfs/24216250/JSC%20(1200%20x%20240%20px).png"
    },
    "name" : "John Steele Consulting"
  },
  "url" : "https://www.johnsteeleconsulting.com/newsletter/issue-2-chatgpt-looker-studio-integration"
}
```