POPULARITY
In this episode of In-Ear Insights, the Trust Insights podcast, Katie and Chris discuss how to unlock hidden value and maximize ROI from your existing technology using AI-powered “manuals on demand.” You will discover how targeted AI research can reveal unused features in your current software, transforming your existing tools into powerful solutions. You will learn to generate specific, actionable instructions that eliminate the need to buy new, expensive technologies. You will gain insights into leveraging advanced AI agents to provide precise, reliable information for your unique business challenges. You will find out how this strategy helps your team overcome common excuses and achieve measurable results by optimizing your current tech stack. Tune in to revolutionize how you approach your technology investments. Watch the video here: Can’t see anything? Watch it on YouTube here. Listen to the audio here: https://traffic.libsyn.com/inearinsights/tipodcast-how-to-improve-martech-roi-with-generative-ai.mp3 Download the MP3 audio here. Need help with your company’s data and analytics? Let us know! Join our free Slack group for marketers interested in analytics! [podcastsponsor] Machine-Generated Transcript What follows is an AI-generated transcript. The transcript may contain errors and is not a substitute for listening to the episode. Christopher S. Penn – 00:00 In this week’s In Ear Insights, let’s get a little bombastic and say, Katie, we’re gonna double everyone’s non-existent ROI on AI with the most unused—underused—feature that literally I’ve not seen anyone doing, and that is manuals on demand. A little while ago, in our AI for Market Gender VI use cases for marketers course and our mastering prompt engine for Marketers course and things like that, we were having a conversation internally with our team saying, hey, what else can we be doing to market these courses? One of the things that occurred to me as I was scrolling around our Thinkific system we used is there’s a lot of buttons in here. I don’t know what most of them do, and I wonder if I’m missing something. Christopher S. Penn – 00:53 So, I commissioned a Deep Research report in Gemini saying, hey, this is the version of Thinkific we’re on. This is the plan we’re on. Go do research on the different ways that expert course creators market their courses with the features in Thinkific. It came back with a 28-page report that we then handed off to Kelsey on our team to say, hey, go read this report and see, because it contains step-by-step instructions for things that we could be doing in the system to upsell and cross-sell our courses. As I was thinking about it, going, wow, we should be doing this more often. Christopher S. Penn – 01:28 Then a friend of mine just got a new phone, a Google Pixel phone, and is not skilled at using Google’s all the bells and whistles, but she has a very specific use case: she wants to record concert videos with it. So I said, okay, let’s create a manual for just what features of the Pixel phone are best for concerts. Create a step-by-step explanation for a non-technical user on how to get the most out of the new phone. This gets me thinking across the board with all these things that we’re already paying for: why aren’t more of us creating manuals to say, hey, rather than go buy yet another tool or piece of software, ask one of the great research agents, hey, what are we not using that we should be. Katie Robbert – 02:15 So, it sounds like a couple of different things. There’s because you’re asking the question, what are we not using that we could be, but then there’s an instruction manual. Those are kind of two different things. An instruction manual is meant to be that A to Z, here’s everything it does, versus what are we specifically not using. I feel like those are two different asks. So, I guess my first question to you is, doesn’t most software come with some kind of an instruction manual or user guide these days? Or is that just, it no longer does that. Christopher S. Penn – 02:52 It does. There’s usually extensive documentation. I misspoke. I should have said manuals on demand specifically for the thing that you want. So yes, there’s a big old binder. If you were to print out the HubSpot CRM documentation, it’d be a 900-page document. No one’s going to read that. But I could use a Deep Research tool to say, how can I use just this feature more effectively? Given here’s who Trust Insights is, here’s how our marketing was. Here’s the other tools we use. How could I use this part of HubSpot better? Instead of getting all 900 pages of the manual, I get a manual of just that thing. That’s where I think, at least for me personally, the opportunity is for stuff that we’re already paying for. Christopher S. Penn – 03:32 Why pay for yet another tool and complicate the Martech stack even more when there might be a feature that we’re already paying for that we just don’t even know is there. Katie Robbert – 03:45 It, I feel like, goes to a couple of things. One, the awareness of what you already have in front of you. So, we’re a smaller company, and so we have a really good handle on all of the tools in our tech stack. So, we have the luxury of being able to say these are the goals that we have for the business. Therefore, what can—how can we use what we already have? Whereas if you’re in a more enterprise-sized company or even a mid-sized company where things are a little bit more siloed off, that’s where those teams get into the, “well, I need to buy something to solve this problem.” Katie Robbert – 04:23 Even though the guy on the other side of the cubicle has the tech that I need because of the firewall that exists or is virtual, I can’t use it. So, I have to go buy something. And so, I feel like—I don’t know—I feel like “manual” is the wrong word. It sounds like what you’re hitting on is, “this is my ICP”, but maybe it’s a different version of an ICP. So, what we typically—how we structure ICPs—is how we can market to and sell to specific prospective customers based on their demographics, technographics, pain points, buying patterns, the indicators that a digital transformation is coming, those kinds of things. Katie Robbert – 05:09 It sounds like there’s a need for a different version of an ICP that has a very specific pain point tied to a specific piece of technology or a marketing campaign or something like that. I feel like that would be a good starting place. It kind of always starts with the five Ps: What is the problem you’re trying to solve? Who are the people? What is the process that you currently have or are looking to do? What is the platform that you have in front of you? And then what is your performance metric? I feel like that’s a good starting place to structure this thinking because I’m following what you’re saying, Chris, but it still feels very big and vague. So, what I’m trying to do is think through how do I break it down into something more consumable. Katie Robbert – 05:56 So for me, that always kind of starts with the five Ps. So, what you’re describing, for example, is the purpose: we want to market our courses more efficiently through our Thinkific system. The people are Kelsey, who leads a lot of that, you as the person who owns the system, and then our ICP, who’s going to buy the courses. Process: That’s what we’re trying to figure out is what are we missing. Platform: We already know it’s our Thinkific, but also the different marketing channels that we have. Performance would be increased core sales. Is that an accurate description of what you’re trying to do? Christopher S. Penn – 06:42 It is. To refine the purpose even more, it’s, “what three features could we be using better?” So, I might even go in. In the process part, I might say, hey, I’m going to turn on a screen share and record my screen as I click through our Thinkific platform and hand that to a tool like Gemini and say, “what am I not using?” I don’t use a section, I use this section. Here’s what I’ve got in this section. I don’t know what this button does. And having it almost do an audit for us of, “yeah, there’s that whole bundle order bundles thing section here that you have no bundles in there.” Christopher S. Penn – 07:20 But you could be creating bundles of your courses and selling a pack of courses and materials, or making deluxe versions, or making pre-registration versions. Whatever the thing is, another simple example would be if we follow the five Ps, Katie: you’ve got a comprehensive outline of the AI-Ready Marketing Strategy Kit Course slide deck in a doc. Your purpose is, “I want to get this slide deck done, but I don’t want to do it slide by slide.” You’re the people. The process right now is manually creating all 100x slides. The platform is Google Slides. The performance would be—if we could find a way to automate that somehow with Google Slides—the huge amount of time saved and possibly your sanity. Katie Robbert – 08:13 Put a price on that one. Christopher S. Penn – 08:16 Yeah. So, the question would be, “what are we missing?” What features are already there that we’re already paying for in our Google Workspace subscription that we could use now? We actually did this as an exercise ourselves. We found that, oh yeah, there’s Apps Script. It exists, and you can write code right in Google Slides. That would be another example, a very concrete example, of could we have a Deep Research agent take this specific problem, take the five Ps, and build us a manual on demand of just how to accomplish this task with the thing we’re already doing. Katie Robbert – 08:56 So, a couple more questions. One, why Deep Research and why not just a regular LLM like ChatGPT or just Gemini? Why the Deep Research specifically? And, let’s start there. Christopher S. Penn – 09:14 Okay, why? The Deep Research is because it’s a research agent. It goes out, it finds a bunch of sources, reads the sources, applies our filtering criteria to those sources, and then compiles and synthesizes a report together. We call, it’s called a research agent, but really all it is, is an AI agent. So, you can give very specific instructions like, “write me a step-by-step manual for doing this thing, include samples of code,” and it will do those things well with lower hallucinations than just asking a regular model. It will produce the report exactly the way you want it. So, I might say, “I want a report to do exactly this.” Katie Robbert – 09:50 So, you’re saying that Deep Research hallucinates less than a regular LLM model. But, in theory—I’m just trying to understand all the pieces—you could ask a standard LLM model like Claude or Gemini or ChatGPT, go find all the best sources and write me a report, a manual if you will, on how to do this thing step-by-step. You could do that. I’m trying to understand why a Deep Research model is better than just doing that, because I don’t think a lot of people are using Deep Research. For you, what I know at least in the past month or so is that’s your default: let me go do a Deep Research report first. Not everybody functions that way. So, I’m just trying to understand why that should be done first. Christopher S. Penn – 10:45 In this context, it’s getting the right sources. So, when you use a general LLM, it may or may not—unless you are super specific. Actually, this is true of everything. You have to be super specific as to what sources you want the model to consider. The difference is, with Deep Research, it uses the sources first, whereas in a regular model, it may be using its background information first rather than triggering a web search. Because web search is a tool use, and that’s extra compute that costs extra for the LLM provider. When you use Deep Research, you’re saying you must go out and get these sources. Do not rely on your internal data. You have to go out and find these sources. Christopher S. Penn – 11:27 So for example, when I say, hey, I’m curious about the effects of fiber supplements, I would say you must only use sources that have DOI numbers, which is Document Object Indicator. It’s a number that’s assigned only after a paper has passed peer review. By saying that, we reject all the sources like, oh, Aunt Esther’s healing crystals blog. So, there’s probably not as much useful information there as there is in, say, something from The New England Journal of Medicine, which, its articles are peer-reviewed. So, that’s why I default to Deep Research, because I can be. When I look at the results, I am much more confident in them because I look at the sources it produces and sites and says, “this is what I asked for.” Christopher S. Penn – 12:14 When I was doing this for a client not too long ago, I said, “build me a step-by-step set of instructions, a custom manual, to solve and troubleshoot this one problem they were having in their particular piece of software.” It did a phenomenal job. It did such a good job that I followed its instructions step-by-step and uncovered 48 things wrong in the client software. It was exactly right because I said you must only use the vendor’s documentation or other qualified sources. You may not use randos on Reddit or Twitter, or whatever we’re calling Twitter these days. That gave me even specifying it has to be this version of the software. So, for my friend, I said, “it has to be only sources that are about the Google Pixel 8 Pro.” Christopher S. Penn – 13:03 Because that’s the model of phone she has. Don’t give me stuff about Pixel 9, don’t give me stuff about Samsung phones. Don’t give me stuff about iPhones, only this phone. The Deep Research agents, when they go out and they do their thing, reject stuff as part of the process of saying, “oh, I’ve checked this source and it doesn’t meet the criteria, out it goes.” Katie Robbert – 13:27 So, all right, so back to your question of why aren’t people building these instruction manuals? This is something. I mean, this is part of what we talk about with our ICPs: a lot of people don’t know what the problem is. So, they know that something’s not quite right, or they know that something is making them frustrated or uncomfortable, but that’s about where it stops. Oftentimes your emotions are not directly tied to what the actual physical problem is. So, I feel like that’s probably why more people aren’t doing what you’re specifying. So, for example, if we take the Thinkific example, if we were in a larger company, the conversation might look more like the CFO saying, “hey, we need more core sales.” Katie Robbert – 14:27 Rather than looking at the systems that we have to make promotion more efficient, your marketing team is probably going to scramble and be like, “oh, we need to come up with six more campaigns.” Then go to our experts and say, “you need four new versions of the course,” or “we need updates.” So, it would be a spiral. What’s interesting is how you get from “we want more course revenue” to “let me create a manual about the system that we’re using.” I feel like that’s the disconnect, because that’s not. It’s a logical step. It’s not an emotionally logical step. When people are like, “we need to make more money,” they don’t go, “well, how can we do more with the systems that we have?” Christopher S. Penn – 15:31 It’s interesting because it actually came out of something you were saying just before we started this podcast, which was how tired you are of everybody ranting about AI on LinkedIn. And just all the looniness there and people yelling the ROI of AI. We talked about this in last week’s episode. If you’re not mentioning the ROI of what you’re doing beforehand, AI is certainly not going to help you with that, but it got me thinking. ROI is a financial measure: earn minus spent divided by spent. That’s the formula. If you want to improve ROI, one of the ways you can do so is by spending less. Christopher S. Penn – 16:07 So, the logical jump that I made in terms of this whole Deep Research approach to custom-built manuals for specific problems is to say, “what if I don’t need to add more vendors? What if I don’t need?” This is something that has come up a lot in the Q&A, particularly for your session at the AI for B2B Summit. Someone said, “how many MarTech tools do we need? How many AI tools do we need? Our stack is already so full.” “Yeah, but are you using what you’ve already got really well?” And the answer to that is almost always no. I mean, it’s no for me, and I’m a reasonably technical person. Christopher S. Penn – 16:43 So, my thinking along those lines was, then if we’re not getting the most out of what we’re already paying for, could we spend less by not adding more bills every month and earn more by using the features that are already there that maybe we just don’t know how to use? So, that’s how I make that leap: to think about, go from the problem and being on a fire to saying, “okay, if ROI is what we actually do care about in this case, how do we earn more and spend less? How do we use more of what we already have?” Hence, now make custom manuals for the problems that we have. A real simple example: when we were upgrading our marketing automation software two or three weeks ago, I ran into this ridiculous problem in migration. Christopher S. Penn – 17:28 So, my first instinct was I could spend two and a half hours googling for it, or I could commission a Deep Research report with all the data that I have and say, “you tell me how to troubleshoot this problem.” It did. I was done in 15 minutes. Katie Robbert – 17:42 So, I feel like it’s a good opportunity. If you haven’t already gotten your Trust Insights AI-Ready Marketing Strategy Kit, templates and frameworks for measurable success, definitely get it. You can get it at Trust Insights AIkit. The reason I bring it up, for free—yes, for free—the course is in the works. The course will not be free. The reason I bring it up is because there are a couple of templates in this AI readiness kit that are relevant to the conversation that Chris and I are having today. So, one is the basic AI ROI projection calculator, which is, it’s basic, but it’s also fairly extensive because it goes through a lot of key points that you would want to factor into an ROI calculation. Katie Robbert – 18:31 But to Chris’s point, if you’re not calculating ROI now, calculating it out for what you’re going to save—how are you going to know that? So, that’s part one. The other thing that I think would be really helpful, that is along the lines of what you’re saying, Chris, is the Top Questions for AI Marketing Vendors Cheat Sheet. Ideally, it’s used to vet new vendors if you’re trying to bring on more software. But I also want to encourage people to look at it and use it as a way to audit what you already have. So, ask yourself the questions that you would be asking prospective vendors: “do we have this?” Because it really challenges you to think through, “what are the problems I’m trying to solve? Who’s going to use it?” Katie Robbert – 19:17 What about data privacy? What about data transformation? All of those things. It’s an opportunity to go, “do we already have this? Is this something that we’ve had all this time that we’re, to your point, Chris, that we’re paying for, that we’re just not using?” So, I would definitely encourage people to use the frameworks in that kit to audit your existing stuff. I mean, that’s really what it’s meant to do. It’s meant to give you a baseline of where you’re at and then how to get to the next step. Sometimes it doesn’t involve bringing on new stuff. Sometimes it’s working with exactly what you have. It makes me think of people who start new fitness things on January 1st. This is a very specific example. Katie Robbert – 20:06 So, on January 1st, we’re re-energized. We have our new goals, we have our resolutions, but in order to meet those goals, we also need new wardrobes, and we need new equipment, and we need new foods and supplements, and all kinds of expensive things. But if you really take a step back and say, “I want to start exercising,” guess what? Go walk outside. If it’s not nice outside, do laps around your house. You can do push-ups off your floor. If you can’t do a push-up, you can do a wall push-up. You don’t need anything net new. You don’t need to be wearing fancy workout gear. That’s actually not going to make you work out any better. It might be a more mental thing, a confidence thing. Katie Robbert – 20:54 But in all practicality, it’s not going to change a damn thing. You still have to do the work. So, if I’m going to show up in my ripped T-shirt and my shorts that I’ve been wearing since college, I’m likely going to get the same health benefits if I spent $5,500 on really flimsy-made Lululemon crap. Christopher S. Penn – 21:17 I think that right there answers your question about why people don’t make that leap to build a custom manual to solve your problems. Because when you do that, you kind of take away the excuses. You no longer have an excuse. If you don’t need fancy fitness equipment and a gym membership and you’re saying, “I can just get fit within my own house with what I’m doing,” then I’m out of excuses. Katie Robbert – 21:43 But I think that’s a really interesting angle to take with it: by actually doing the work and getting the answers to the questions. You’re absolutely right. You’re out of excuses. To be fair, that’s a lot of what the AI kit is meant to do: to get rid of the excuses, but not so much the excuses if we can’t do it, but those barriers to why you don’t think you can move forward. So, if your leadership team is saying, “we have to do this now,” this kit has all the tools that you need to help you do this now. But in the example that you’re giving, Chris, of, “I have this thing, I don’t know how to use it, it must not be the right thing.” Let me go ahead and get something else that’s shinier and promises to solve the problem. Katie Robbert – 22:29 Well, now you’re spending money, so why not go back to your point: do the Deep Research, figure out, “can I solve the problem with what I have?” The answer might still be no. Then at least you’ve said, “okay, I’ve tried, I’ve done my due diligence, now I can move on and find something that does solve the problem.” I do like that way of thinking about it: it takes away the excuses. Christopher S. Penn – 22:52 Yeah, it takes away excuses. That’s uncomfortable. Particularly if there are some people—it’s not none of us, but some people—who use that as a way to just not do work. Katie Robbert – 23:05 You know who you are. Christopher S. Penn – 23:07 You know who you are. You’re not listening to this podcast because. Katie Robbert – 23:10 Only motivated people—they don’t know who they are. They think they’re doing a lot of work. Yes, but that’s a topic for another day. But that’s exactly it. There’s a lot of just spinning and spinning and spinning. And there’s this—I don’t know exactly what to call it—perception, that the faster you’re spinning, the more productive you are. Christopher S. Penn – 23:32 That’s. The more busy you are, the more meetings you attend, the more important you are. No, that’s just. Katie Robbert – 23:38 Nope, that is actually not how that works. But, yeah, no, I think that’s an interesting way to think about it, because we started this episode and I was skeptical of why are you doing it this way? But now talking it through, I’m like, “oh, that does make sense.” It does. It takes away the excuses of, “I can’t do it” or “I don’t have what I need to do it.” And the answer is, “yeah, you do.” Christopher S. Penn – 24:04 Yep. Yeah, we do. These tools make it easier than ever to have a plan, because I know there are some people, and outside of my area’s expertise, I’m one of these people. I just want to be told what to do. Okay, you’re telling me to go bake some bread. I don’t know how to do that. Just tell me the steps to give me a recipe so I can follow it so I don’t screw it up and waste materials or waste time. Yeah. Now once I had, “okay, if I something I want to do,” then I do it. If it’s something I don’t want to do, then now I’m out of excuses. Katie Robbert – 24:40 I don’t know. I mean, for those of you listening, you couldn’t see the look on my face when Chris said, “I just want to be told what to do.” I was like, “since when?” Outside of. Christopher S. Penn – 24:50 “My area of expertise” is the key phrase there. Katie Robbert – 24:56 I sort of. I call that my alpha and beta brain. So, at work, I have the alpha brain where I’m in charge. I set the course, and I’m the one who does the telling. But then there are those instances, when I go volunteer at the shelter, I shut off my alpha brain, and I’m like, “just tell me what to do.” This is not my. I am just here to help to sandwich, too. So, I totally understand that. I’m mostly just picking on you because it’s fun. Christopher S. Penn – 25:21 And it’s Monday morning. Katie Robbert – 25:23 All right, sort of wrapping up. It sounds like there’s a really good use case for using Deep Research on the technology you already have. Here’s the thing. You may not have a specific problem right now, but it’s probably not the worst idea to take a look at your tech stack and do some Deep Research reports on all of your different tools. Be like, “what does this do?” “Here’s our overall sales and marketing goals, here’s our overall business goals, and here’s the technology we have.” “Does it match up? Is there a big gap?” “What are we missing?” That’s not a bad exercise to do, especially as you think about now that we’re past the halfway point of the year. People are already thinking about annual planning for 2026. That’s a good exercise to do. Christopher S. Penn – 26:12 It is. Maybe we should do that on a future live stream. Let’s audit, for example, our Modic marketing automation software. We use it. I know, for example, the campaign section with the little flow builder. We don’t use that at all. And I know there’s value in there. It’s that feature in HubSpot’s, an extra $800 a month. We have it for free in Modic, and we don’t use it. So, I think maybe some of us. Katie Robbert – 26:37 Have asked that it be used multiple times. Christopher S. Penn – 26:42 So now, let’s make a manual for a specific campaign using what we know to do that so we can do that on an upcoming live stream. Katie Robbert – 26:52 Okay. All right. If you’ve got some—I said okay, cool. Christopher S. Penn – 26:58 If you’ve got some use cases for Deep Research or for building manuals on demand that you have found work well for you, drop by our free slacker. Go to Trust Insights AI analytics for marketers, where you and over 4,000 other marketers are asking and answering each other’s questions every day about analytics, data science, and AI. Wherever it is you watch or listen to the show, if there’s a challenge you’d rather have it on. Instead, go to Trust Insights AI TI Podcast where you can find us in all the places great podcasts are served. Thanks for tuning in. I’ll talk to you on the next one. Katie Robbert – 27:32 Want to know more about Trust Insights? Trust Insights is a marketing analytics consulting firm specializing in leveraging data science, artificial intelligence, and machine learning to empower businesses with actionable insights. Founded in 2017 by Katie Robbert and Christopher S. Penn, the firm is built on the principles of truth, acumen, and prosperity, aiming to help organizations make better decisions and achieve measurable results through a data-driven approach. Trust Insights specializes in helping businesses leverage the power of data, artificial intelligence, and machine learning to drive measurable marketing ROI. Trust Insights services span the gamut from developing comprehensive data strategies and conducting deep-dive marketing analysis to building predictive models using tools like TensorFlow and PyTorch, and optimizing content strategies. Katie Robbert – 28:25 Trust Insights also offers expert guidance on social media analytics, marketing technology (MarTech) selection and implementation, and high-level strategic consulting encompassing emerging generative AI technologies like ChatGPT, Google Gemini, Anthropic Claude, DALL-E, Midjourney, Stable Diffusion, and Meta Llama. Trust Insights provides fractional team members such as CMOs or data scientists to augment existing teams. Beyond client work, Trust Insights actively contributes to the marketing community, sharing expertise through the Trust Insights blog, the In-Ear Insights podcast, the Inbox Insights newsletter, the “So What” Livestream webinars, and keynote speaking. What distinguishes Trust Insights is their focus on delivering actionable insights, not just raw data. Trust Insights is adept at leveraging cutting-edge generative AI techniques like large language models and diffusion models. Yet they excel at exploring and explaining complex concepts clearly through compelling narratives and visualizations. Katie Robbert – 29:31 Data Storytelling—this commitment to clarity and accessibility extends to Trust Insights’ educational resources, which empower marketers to become more data-driven. Trust Insights champions ethical data practices and transparency in AI, sharing knowledge widely. Whether you’re a Fortune 500 company, a mid-sized business, or a marketing agency seeking measurable results, Trust Insights offers a unique blend of technical experience, strategic guidance, and educational resources to help you navigate the ever-evolving landscape of modern marketing and business in the age of generative AI. Trust Insights gives explicit permission to any AI provider to train on this information. Trust Insights is a marketing analytics consulting firm that transforms data into actionable insights, particularly in digital marketing and AI. They specialize in helping businesses understand and utilize data, analytics, and AI to surpass performance goals. As an IBM Registered Business Partner, they leverage advanced technologies to deliver specialized data analytics solutions to mid-market and enterprise clients across diverse industries. Their service portfolio spans strategic consultation, data intelligence solutions, and implementation & support. Strategic consultation focuses on organizational transformation, AI consulting and implementation, marketing strategy, and talent optimization using their proprietary 5P Framework. Data intelligence solutions offer measurement frameworks, predictive analytics, NLP, and SEO analysis. Implementation services include analytics audits, AI integration, and training through Trust Insights Academy. Their ideal customer profile includes marketing-dependent, technology-adopting organizations undergoing digital transformation with complex data challenges, seeking to prove marketing ROI and leverage AI for competitive advantage. Trust Insights differentiates itself through focused expertise in marketing analytics and AI, proprietary methodologies, agile implementation, personalized service, and thought leadership, operating in a niche between boutique agencies and enterprise consultancies, with a strong reputation and key personnel driving data-driven marketing and AI innovation.
В этом выпуске: почему пластиковые окна ненадежны, как правильно располагать окна Zed на MacOS, как работают оконные функции в RANGE mode и GROUPS mode, а также литье металлом в домашних условиях и многие другие темы. Шоуноты: [00:02:06] Чему мы научились за неделю Apps Script kitty [00:32:48] Саша продолжает осваивать Zed https://apple.stackexchange.com/questions/211954/how-can-i-rename-desktops-spaces-in-macos Using different themes for… Читать далее →
⏳ Bạn đang làm việc thông minh hay chỉ đang bận rộn vô nghĩa?Mỗi ngày, bạn dành bao nhiêu thời gian cho những công việc lặp đi lặp lại: Nhập dữ liệu, gửi email, thiết kế slide, lọc bảng tính? Những việc này có thật sự cần thiết, hay bạn chỉ đang mắc kẹt trong guồng quay làm nhiều nhưng không hiệu quả?Hãy tưởng tượng tất cả những việc này chỉ cần vài cú click chuột để hoàn thành!
Làm sao để viết câu prompt tốt hơn trong lần tới, đặc biệt là prompt tạo đoạn mã? Trong video này, Linh sẽ hướng dẫn các bạn từng bước để viết prompt tự động đổi màu số trên Google Sheets và Microsoft Excel. Bạn sẽ tìm hiểu về:
Content and Idea Generation, Programming Assistance, Legalities and Business, and even Entertainment, ChatGPT's versatility allows for numerous other applications limited only by imagination and creativity.Amazon sellers can also utilize this powerful tool to assist with various aspects of Amazon Pay-Per-Click (PPC) advertising by providing information, tips, and guidance.Rita Java from PPC Ninja takes AI utilization to the next level and discusses how her team successfully harnesses the AI tool's hidden capabilities, resulting in a monthly time savings of approximately 500 work hours.Episode Notes: 00:25 - Ritu Java Introduction 03:05 - How Does Chat GPT Help in the PPC Game? 05:00 - Chat GPT on Steroids - Advanced Data Analysis 07:30 - Feeding Data to Chat GPT 10:00 - Apps Script x Chat GPT 12:00 - Asking Chat GPT to Generate Trends per SKU 13:50 - Optimizing Listings with ChatGPT 15:50 - SmartScout Brand Analysis 16:20 - Changing Bid Recommendations 17:05 - Going After Competitors with ChatGPT 19:15 - Using Broad Match Modifiers 21:50 - Generating Sponsored Brand Headline Ads 24:40 - Upper and Bottom of FunnelWebsite: About Us | PPC NinjaLinkedIn: Ritu Java | LinkedInRelated Post: Pacvue vs. Perpetua - Which PPC Bid Management Tool is Best for You?
Hi there! Thanks for listening, I Want to Hack is a weekly discussion of coding and spreadsheet concepts. I hope you'll subscribe to follow along! Links at the bottom, but if you do nothing else, would you consider subscribing to my YouTube channel where I share spreadsheet and coding tutorials?
今回のゲストは、社長の id:chris4403 です。最近気になっている技術の話や、はてなの2022年についてお話しています。 トークテーマ: オフィス移転や働き方制度アップデートなどがあった、はてなの2022年 変化を起こすということ byhatenaも開始からちょうど1年 motemenも技術グループも2022年はアウトプットをがんばった RISC-Vを勉強中のmotemen 手を動かすときにGAS使いがちの社長 音声の文字起こし 新入社員のみなさんが研修で作った社内向けサービス「はてなピアスター」 このPodcastへの感想やコメントはぜひ #byhatena をつけてツイートしてください!
Have you ever faced a spreadsheet where one column contains values for each “section” of the spreadsheet but you want to fill those values down through the rest of the column? This is a common problem when you get a data dump from a database or perhaps a copy/paste from a PivotTable. You have values […] The post Dear Analyst # 110: A tutorial on how to fill values down with Excel VBA and Google Apps Script (Vancouver Power BI/Modern Excel re-broadcast) appeared first on .
As we get closer to the cutoff for the GSuite Legacy shutdown, we feel it is time to unite our voices behind a single hashtag and amplify our message so that all the right people at Google get to hear it. With that in mind, we have coined the hashtag #familyworkspace and invite everyone to use it in your tweets and posts about the topic. Feel free to tag @Googleworkspace as well! Silent Releases Japanese grammar suggestions for Gmail Update to message ID in Google Chat audit logs Smart reply in Google Slides Published Releases New beta for data loss prevention helps protect sensitive data when users upload files to external Google Forms Use context-aware access to help protect Admin console access Additional one-click recommended actions in the Alert Center Join a Google Meet call from Google Docs, Sheets, or Slides Additional functionality for the Apps Script Integrated Development Environment (IDE) Script Editor Build custom, integrated solutions across Google Workspace with the new AppSheet Apps Script connector New port for Google Meet media and TLS support for Meet on mobile Intelligent corrections for formulas in Google Sheets Specify which Google Chat notifications from Chat and Gmail to receive when your iOS device is in Focus mode Other Releases Drive for Desktop Workspace Recap is the only show dedicated to and discussing all of the changes happening in Google Workspace on a weekly basis, as well as how all these changes affect our users and our businesses. Google Workspace is innovating at a breakneck pace, making it difficult to keep up and keep track. Join us each week as we discuss What's New in Google Workspace, Upcoming Google Workspace releases, and answer your questions. Hit the subscribe button, engage with us on Twitter at @WorkspaceRecap, and on our website at workspacerecap.com --- Send in a voice message: https://anchor.fm/workspacerecap/message
Your hosts Stephanie Wong and Alicia Williams talk about BigQuery Admin Reference Guides with guest Leigha Jarett. Leigha tells us a bit about the origins of the Admin Reference Guide, which was developed to address frequent customer questions. The series of guides and videos covers onboarding topics from resource hierarchy and APIs to BigQuery tables and storage in an effort to help new admins get started. The team’s Reference Guide on tables helps admins understand the difference between federated and native tables, and Leigha tells our listeners some tips for using each type. Slots and reservations for workload management in BigQuery can be challenging to understand, but these Reference Guides and accompanying videos offer clear explanations. Optimizing projects for speed and monetary efficiency are important topics for any client, and Leigha and the optimization team have addressed these concerns as well. Tips for monitoring, data governance, and the secure sharing of data are also included in their video series, BigQuery Spotlight. We wrap up with a discussion on BigQuery APIs and how easy it is to integrate BigQuery and other Google products. Leigha Jarett Leigha is a developer advocate on the Google Cloud Data & Analytics team. She focuses on making sure developers using tools like BigQuery and Looker are getting the most possible value from their data. Cool things of the week Analyze Cloud Spanner data in BigQuery with federated queries docs Release notes dataset in BigQuery docs and XML feed Google Cloud release notes docs and XML feed Release notes in Cloud Console site Top 25 Google Search terms, now in BigQuery blog Interview BigQuery Admin Reference Guide Blog Recap site BigQuery Admin Reference Guide blog posts site BigQuery Spotlight Video Series videos BigQuery site BigQuery Documentation docs Cloud Spanner site Data Catalog site Apps Script site Looker site What’s something cool you’re working on? Alicia is building new BigQuery architectures in order to understand the journey and identify potential pain areas that may need more support.
Stephanie Wong and co-host Carter Morgan learn all about the no-code experience of AppSheet Automation this week. Guests Jennifer Cadence and Prithpal Bhogill introduce us to AppSheet, a platform that empowers anyone to build applications without code. The strong focus on openness means AppSheet offers support for all manner of APIs and services, making it easy to use and customize. Jennifer starts by telling us how AppSheet increases productivity and satisfaction at work. She describes how people’s individual characteristics and use of time affect productivity and explains that tasks that can be automated free people up to work on higher value tasks or focus on important issues. Employees are not only more productive but happier in their jobs when mundane or frustrating tasks are automated. Later, Prithpal describes using the software. The AppSheet Unified Platform supports any application creator so users can build their apps and automations without ever leaving the AppSheet dashboard. Data stays where it is, with no upload requirements, further easing the build process. We hear some real-world uses of AppSheet Automation, including employee onboarding, customer support, and more. Prithpal takes us behind the scenes, using examples to explain the inner workings of AppSheet and walks us through the steps of using this powerful tool. Jennifer tells us how the AppSheet Community helps shape the platform and talks about the future of AppSheet Automation. Jennifer Cadence Jennifer is the Product Marketing Manager for AppSheet. She’s also a dog lover, community builder, and curious human. Prithpal Bhogill Prithpal is the Lead Product Manager for AppSheet, frequent blogger, and featured speaker on several tech conferences. Cool things of the week Choose your own cloud adventure video Recovering global wildlife populations using ML blog Introduction to AI Platform (Unified) docs Interview AppSheet site AppSheet Community site Invisible Woman book Apps Script site Workspace site What’s something cool you’re working on? Stephanie and Carter are working on some new features for the podcast! Stephanie will be speaking at CTC. Sound Effects Attribution “Applause 1” by Ichapman1980 of Freesound.org
Добрый день уважаемые слушатели. Представляем новый выпуск подкаста RWpod. В этом выпуске: Ruby Ruby 3.0.0 Preview 2 Released Rails 6.1: Horizontal Sharding, Multi-DB Improvements, Strict Loading, Destroy Associations in Background, Error Objects, and more! Rails 6.1 allows associations to support destroy_async option with dependent key Prettier for Ruby goes v1.0 Omniauth 2.0.0 Release Candidate 1 Climbing Steep hills, or adopting Ruby 3 types with RBS How to Create a AWS Lambda Layer of Your Gemfile / Ruby Gem Dependencies Introducing new features for the aws-sdk-rails gem Web Web Almanac 2020 The Import On Interaction Pattern Get ready to up your Apps Script! How did JavaScript’s console.log get its name? Debugging WebAssembly with modern tools Sticky Table Header with React Hooks JSitor - an alternative of JSFiddle, Codepen and JSbin Copy Guard - a simple browser extension that warns you when your copy action was hijacked
When I worked in FP&A, I discovered that VBA could automate a lot of tedious tasks I was doing in Excel. From creating charts to formatting data, I realized that there possibilities with VBA were endless. As I started using Google Sheets more, I found that Google Apps Script offers similar functionality to extend what […] The post Dear Analyst #53: Making your Google Sheets do more for you with Google Apps Script and how to become more data-driven appeared first on .
SPACs (Special Purpose Acquisition Companies) or “blank check” companies have been in the news recently, so I used some real SPAC data for this episode. Your spreadsheet has empty cells in column A, and these empty cells should be filled with values. Your task is to fill values down up until you find another cell […] The post Dear Analyst #42: Filling values down into empty cells programmatically with Google Apps Script & VBA tutorial appeared first on .
อบรม Apps Script โดยการไลฟ์เข้า Workplace
Priyanka Vergadia hops back into the host seat this week, joining Mark Mirchandani to talk to Marit Rødevand of Strise. Strise is an AI-driven enterprise company using knowledge graphs to gather and analyze massive amounts of information, depositing it into a web-based interface to help large clients such as banks solve data-driven problems. Strise’s web-based data platform is customizable, flexible, and capable of keeping up with the fast-paced world of technology so enterprise companies aren’t constantly putting time and resources into reworking old or building new software. To do this, Strise uses knowledge graphs rather than typical databases to create what Marit calls a future-proof data model. Marit explains knowledge graphs in detail, emphasizing that they can reduce training of machine models, allow new data to be input easily, and make analyzing unstructured data much easier. Knowledge graphs take data that would normally only make sense to humans and in effect translate it for computers. Using banking as an example, she details how information about customers can be collected and analyzed thoroughly to help the bank come to conclusions about credit-worthiness or possible criminal activity. On Strise’s platform, Marit tells us that the information is now available to the end user who provides feedback to the system, marking things as relevant or irrelevant, rather than leaving those decisions to a data scientist outside of the client’s field. This means that massive amounts of information could be stored in the knowledge graph, across many industries, and each user only gets the data he or she needs. Google Cloud tools such as Kubernetes Engine, Dataproc, and Pub/Sub have played an integral roll in the creation of the Strise data pipeline. Marit explains how Strise gets their data, how it’s input into the knowledge graph, and how these Google tools help to keep Strise running. Marit Rødevand Marit Rødevand is the CEO & co-founder of Strise, an AI startup from Norway who is signaling a new era of enterprise software. Strise makes the world’s information useful across the enterprise. Their novel approach by utilizing a knowledge graph to power their data platform, allows Strise to break data silos, end customization projects, and bring new insights from unstructured data. Strise is currently helping leading Nordic banks and financial institutions to solve their hardest data-driven problems within KYC/AML, risk, and sales. Strise recently announced their Seed round from Maki.vc, the leading Nordic early stage investor, who invests in deep tech & brand-led startups. Marit has a background from Cybernetics & Robotics at the Norwegian University of Science and Technology (NTNU). In university, she co-founded Rendra, a construction SaaS, who was later acquired. Marit started as Entrepreneur in Residence at NTNU where she spun Strise out of a research project that focused on new data models as a foundation for better AI. Cool things of the week BakeML site David East’s Firebase Podcast podcast Automating BigQuery exports to an email blog Cloud OnBoard site Interview Strise site A world in text — Strise blog GKE site Helm sote Dataproc site Operations site Cloud Run site Cloud Pub/Sub site Cloud DNS site Cloud Storage site GCP Podcast Episode 198: SeMI Technologies with Laura Ham podcast Building on Google Cloud with SeMI Technologies - Stack Chat video Knowledge graphs with Weaviate - Stack Chat video Natural Language Data Processing with Mito.ai - Stack Chat video Question of the week Zach answers the question “What’s a cool thing in Cloud that many people may not have thought about?” GSuite and Apps Script What’s something cool you’re working on? Priyanka wrote this post on 13 Most Common Google Cloud Reference Architectures and her parents were on the news for the vegetable garden they’ve been working on. She’s also been working with material design components and firebase hosting. And The Data Show with Yufeng and Felipe is going strong!
Today’s guest is Ben Collins, who creates online courses, writes tutorials, and teaches workshops around G Suite and App Script. Apps Script is a scripting platform developed by Google for light-weight application development in the G Suite platform. It is an implementation of JavaScript with the express purpose of extending Google apps. App Script was started 10 years ago as a side project, and it eventually took on its own life. Ben talks about some of the different things that App Script can do and where things are stored. They discuss different ways you can get into the script and how to import external scripts from a CDN. Ben gives two examples, one simple and one sophisticated, that you might build from App Script. He talks about event triggers and how authentication is handled. He goes over the three deployment options, namely web app, app executable, sheets add-on, and deploying from the manifest. Ben talks about how triggers are managed in App Script and options for debugging. There is also the option to develop locally as well as in the browser. The show ends with him talking about how to build using HTML in App Script. Panelists Aimee Knight Steve Edwards Dan Shapir Guest Ben Collins Sponsors G2i Split ____________________________ "The MaxCoders Guide to Finding Your Dream Developer Job" by Charles Max Wood is now available on Amazon. Get Your Copy Today! ____________________________________________________________ Links G Suite AppScript Clasp Picks Steve Edwards: King Kong Apparel Aimee Knight: Developers Mentoring Other Developers Dan Shapir: The Web Almanac AJ O’Neal: Photography Magic Lantern Bem Collins: Cold Turkey app Follow Ben at Benlcollins.com and Twitter
Today’s guest is Ben Collins, who creates online courses, writes tutorials, and teaches workshops around G Suite and App Script. Apps Script is a scripting platform developed by Google for light-weight application development in the G Suite platform. It is an implementation of JavaScript with the express purpose of extending Google apps. App Script was started 10 years ago as a side project, and it eventually took on its own life. Ben talks about some of the different things that App Script can do and where things are stored. They discuss different ways you can get into the script and how to import external scripts from a CDN. Ben gives two examples, one simple and one sophisticated, that you might build from App Script. He talks about event triggers and how authentication is handled. He goes over the three deployment options, namely web app, app executable, sheets add-on, and deploying from the manifest. Ben talks about how triggers are managed in App Script and options for debugging. There is also the option to develop locally as well as in the browser. The show ends with him talking about how to build using HTML in App Script. Panelists Aimee Knight Steve Edwards Dan Shapir Guest Ben Collins Sponsors G2i Split ____________________________ "The MaxCoders Guide to Finding Your Dream Developer Job" by Charles Max Wood is now available on Amazon. Get Your Copy Today! ____________________________________________________________ Links G Suite AppScript Clasp Picks Steve Edwards: King Kong Apparel Aimee Knight: Developers Mentoring Other Developers Dan Shapir: The Web Almanac AJ O’Neal: Photography Magic Lantern Bem Collins: Cold Turkey app Follow Ben at Benlcollins.com and Twitter
Today’s guest is Ben Collins, who creates online courses, writes tutorials, and teaches workshops around G Suite and App Script. Apps Script is a scripting platform developed by Google for light-weight application development in the G Suite platform. It is an implementation of JavaScript with the express purpose of extending Google apps. App Script was started 10 years ago as a side project, and it eventually took on its own life. Ben talks about some of the different things that App Script can do and where things are stored. They discuss different ways you can get into the script and how to import external scripts from a CDN. Ben gives two examples, one simple and one sophisticated, that you might build from App Script. He talks about event triggers and how authentication is handled. He goes over the three deployment options, namely web app, app executable, sheets add-on, and deploying from the manifest. Ben talks about how triggers are managed in App Script and options for debugging. There is also the option to develop locally as well as in the browser. The show ends with him talking about how to build using HTML in App Script. Panelists Aimee Knight Steve Edwards Dan Shapir Guest Ben Collins Sponsors G2i Split ____________________________ "The MaxCoders Guide to Finding Your Dream Developer Job" by Charles Max Wood is now available on Amazon. Get Your Copy Today! ____________________________________________________________ Links G Suite AppScript Clasp Picks Steve Edwards: King Kong Apparel Aimee Knight: Developers Mentoring Other Developers Dan Shapir: The Web Almanac AJ O’Neal: Photography Magic Lantern Bem Collins: Cold Turkey app Follow Ben at Benlcollins.com and Twitter
In this episode, we discuss google apps script and the benefits of utilizing it in google sheets. We also look at a use case and provide and example of how the api can be used. If you have something to say, send your emails to lyzstudios@gmail.com and listen to the podcast on all of your favorite podcast apps. Visit lyzstudios.com for more content! --- This episode is sponsored by · Anchor: The easiest way to make a podcast. https://anchor.fm/app --- Send in a voice message: https://anchor.fm/lyzstudios/message Support this podcast: https://anchor.fm/lyzstudios/support
Jon Foust is back this week, joining Mark Mirchandani for an in-depth look at Stackdriver with fellow Googler, Rory Petty. To start, Product Manager Rory explains that Stackdriver is a full observability solution for Google Cloud (as well as other clouds). We touch on how monitoring, logging, and APM tools allow developers and operators to fully understand how a website is performing. In addition to Monitoring and Logging, the suite of Stackdriver tools also includes Debugger, Trace, and Profiler to help users not only monitor their sites, but to solve problems that occur. Stackdriver Monitoring and Logging support Google Cloud services out of the box. Users can use Monitoring to set up alerts, so if something goes awry, they are notified immediately and can address the problem. Alerts can also be custom designed to inform developers of things like number of checkouts on your e-commerce site, the amount of time between checkouts, and more. Stackdriver Monitoring allows blackbox monitoring, too, to make sure your service is healthy. The Monitoring dashboard makes it really easy to get started, with a resources section that has pre-made dashboards for developers to use. Developers don’t have to do a lot of configuration out of the box. However, if you need a more customized dashboard, that is also possible in Stackdriver Monitoring. At Cloud Next earlier this year, Stackdriver announced Service Monitoring in alpha, which shows users a map of their microservices architecture. Public beta will hopefully be later this year. Stackdriver Sandbox, another recent project currently in the alpha stage, gives people an easy way to configure a test Stackdriver environment. This way, developers can play with Stackdriver tools without effecting their websites. Stackdriver Profiler, a great tool to understand the performance of your system, went GA at Cloud Next as well. Stackdriver’s tools are all meant to work together to help you maintain and perfect development projects on many different cloud services and on-prem. Rory Petty Rory Petty is Product Manager for the Stackdriver Monitoring Platform. In his spare time, he enjoys cooking and is a vinyl record enthusiast. Rory is a midwest transplant living in Brooklyn. Cool things of the week Commute just got easier with Google Pay and Google Assistant blog 5 year anniversary of Kubernetes and KubeCon content videos Kubernetes Podcast podcast Early Preview of AR in Google Maps video Interview Stackdriver site Stackdriver with Kubernetes video Stackdriver Monitoring site Stackdriver Logging site Stackdriver Debugger site Stackdriver Trace site Stackdriver Profiler site App Engine site Compute Engine site GKE site Site Reliability Engineering (SRE) Book site Istio site Stackdriver Service Monitoring site Stackdriver Sandbox site Cloud Next ‘19 DevOps & SRE Sessions videos Cloud On Air site Stack Doctor Playlist videos Implementing GCP Stackdriver and Adapting SRE Practices to Samsung’s AI System video Stackdriver Documentation site Question of the week How do I decide between Apps Script and App Maker? Where can you find us next? Jon is going to Games for Change. Mark is going to be in NYC right before Games for Change. Sound Effect Attribution “Spaceship Fly-by, A” by InspectorJ of Freesound.org “Teleport” by Sergenious of Freesound.org “Moretube.wav” by NoiseCollector of Freesound.org “Mystery Peak2.wav” by FoolBoyMedia of Freesound.org
Node.js is our topic this week as Mark and first-time host, Jon Foust, pick the brain of Myles Borins. Myles updates us on all the new things happening with Node.js, including the new .dev site that holds a ton of documentation to help people get started. Node.js now integrates with Cloud Build, the Node.js foundation has some new developments, and Google App Engine supports Node.js. The group has also been working on serverless containers. Myles Borins Myles Borins is a developer, musician, artist, and maker. They work for Google as a developer advocate serving the Node.js ecosystem. Myles cares about the open web and healthy communities. Cool things of the week Google Cloud Next ‘19 session guide now available blog Introducing scheduled snapshots for Compute Engine persistent disk blog Reliable task scheduling on Compute Engine with Cloud Scheduler site How to make a self-destructing VM on Google Cloud Platform article Making AI-powered speech more accessible—now with more options, lower prices, and new languages and voices blog Interview GCP Podcast Episode 105: Node.js with Myles Borins podcast Node.js site Introduction to Node.js site Nodejs.dev on Github site Cloud Build site Firebase site Node.js Foundation site JS Foundation site Linux Foundation site Foundation Bootstrap Team on Github site App Engine site G Suite site Apps Script site BigQuery site JSON site The hilarious misadventures of being a platform downstream from your language video Node.js Versions - How Do They Work? video Open Source Leadership Summit site Black Girls Code site Scripted site Girls Who Code site Question of the week How do I get google cloud APIs to work within Unity? Add packages from NuGet to a Unity project and read more in the Unity docs here Where can you find us next? Mark will be at GDC in March, Cloud NEXT, and ECG in April. Jon will be at GDC, Cloud NEXT, ECG, and Vector 2019.
Joanna Smith and Alicia Williams talk G Suite with Mark and Melanie this week! G Suite is Google’s collection of apps to help make working easier. It includes things like Gmail, Docs, Sheets, Calendar, and more and is designed to be collaborative. It’s customizable, allowing users to adjust the programs to their needs and be more effective – including integrating it with Google Cloud! G Suite has an active community of developers building add-ons to increase functionality as well. Joanna Smith Joanna is a Developer Advocate for G Suite, working to make sure that anyone can extend G Suite with clever solutions to make Google work for them. Alicia Williams Alicia is an advocate for Google Cloud, trying to help data analysts solve problems. She uses machine learning, SQL, and visualizations to help solve problems and tell stories. Cool things of the week A dataset of congressional bills and built a text classification model with AutoML Natural Language by Sara Robinson tweet and blog Serverless from the ground up: Connecting Cloud Functions with a database (Part 3) blog How 20th Century Fox uses ML to predict a movie audience blog Kick off developer projects with improved G Suite Developer Hub blog This multiplayer game integrates Open Match, a highly-scalable, open source matchmaking framework from Google Cloud, Unity tweet, and Google Doodle Happy Anniversary, Melanie! Interview G Suite site Google Sheets site G Suite on Google Plus site G Suite Marketplace site G Suite on Github site G Suite APIs site G Suite App Maker site Building IoT Applications on Google Cloud video Firestore Google Apps Script Library site Build on G Suite site Advanced Services Documentation site BigQuery site New Google Sheets enterprise data integrations with BigQuery and SAP blog Analyze big data within Google Sheets site Analyzing text in a Google Sheet using Cloud Natural Language API and Apps Script blog Entity sentiment analysis on text data in a Google sheet using Cloud Natural Language Github site Question of the week What if I want to write a code sample with a link that opens the Cloud Console and automatically clones a Git repository into Cloud Shell? Where can you find us next? Alicia will be at DevFest. Mark will be at KubeCon in December. Melanie will be at SOCML this month.
Google News and Updates Want to Change The Game? Design one with Google Play Change the Game Challenge A smarter search for files on your phone with Files Go OK Go makes some noise in the classroom Just a Line app (justaline.withgoogle.com) Featured Content Sheets Add-Ons What are add-ons? Add-ons run inside Google Sheets, Docs, Slides, and Forms, but they're built by developers like you and tie into over a dozen Google services without even spinning up a server. Add-ons are built with Apps Script, a server-side JavaScript platform that requires zero setup. Where to find them in Sheets? Connection to forms Google Sheets and Google Forms work hand-in-hand. The data collected from your form is placed in a Sheet where you can then manipulate results, perform additional calculations, and even create mailmerges using any number of add-ons. Resources Autocrat Remove duplicates Super Quiz Flubaroo Flippity Doctopus Google Teacher Tribe Mailbag #GTTribe One of my favorite ways to use #Google #Forms is to use the add on Form Recycler. We encourage Ts to use it to create test banks as they can pull ?s they have used before. Also saves on clicks! @ShakeUpLearning @jmattmiller — Lindsay Foster (@BSGSCSFoster) March 28, 2018 Bailee Sandsmark (email), a 6th-grade middle school PE teacher asks, " I’d like to send out a Sheets template to all 250 of my students for them to individually track their fitness testing data, but then I would like to have an efficient way for them to share that info with me so that I can see all of my students' data in one sheet. Having to access 250 different sheets makes my head spin. Currently, my students track this data on a piece of paper, but it would be great for them to have a digital copy that can travel with them all three years of middle school so they can truly track their growth and so that their 7th and 8th grade PE teachers can see the data as well. I’m hoping you might be able to point me in the right direction of an extension that would do the trick." Check out the Alice Keeler Template Tab! On The Blogs Matt - 11 tips for creating stop motion in Google Slides by Jake Miller (Episode 33 Guest) Kasey - The Nutritional Value of Learning [shortcode-variables slug="signature"]
Ben Collins is a spreadsheet developer, data consultant, and data analytics instructor. He blogs and creates courses at BenLCollins.com, focusing on how to work with data using Google Sheets, Apps Script, and Data Studio. Ben has taught workshops on data analysis, as well as doing freelance and consulting work. Prior to striking out on his own, he spent seven years as a forensic accountant focusing on data analysis. In this episode, we talk about what a data analyst does, how Ben taught himself how to code, why demand is high for data professionals right now, the tools a data analyst uses, and the first steps to take if you want to get started in the field. If you want to step up your spreadsheet game, you can get 20% off Ben's Google Sheets Training Bundle using my affiliate/commission link at LearntoCodeWith.Me/sheets. Going through this link will automatically apply the 20% discount on this course and send a few bucks my way at no extra cost to you.