Podcasts about data studio

In this episode we explore the new features of Seqera's Data Studios and Data Explorer, with Phil Ewels, Rob Newman and Rob Syme from Seqera. Discover how to use these tools for troubleshooting Nextflow pipelines, tertiary analysis and Nextflow development. We discuss the pain points that led to the creation of Data Studios and how it's designed to allow scientists to interactively and collaboratively work with data and complex workflows, without having to move large datasets around. Rob Syme wows us with another fantastic practical demonstration, setting up and using Data Studios to write and test a Nextflow pipeline in VSCode running on the cloud in a Data Studio environment, including running the Nextflow CLI with task submission to AWS Batch. We cover features like session persistence to save work states, and upcoming custom container support for your own specialized applications. Learn how these tools can enhance your computational biology projects and make seamless cloud integration a reality. 00:00 Channels Podcast 43: Data Studios 00:26 Introductions 01:54 Data Studios 04:51 Move the compute to the data 06:13 Real-time collaboration 06:47 Data Explorer 09:41 Access to public data 10:45 Data Explorer demo 13:56 Data Studios setup 20:17 Session persistance 22:52 Data Studios RStudio demo 28:24 Nextflow development in Data Studios 36:17 Future development 37:01 Custom containers 40:01 Boston Summit demo 44:01 Lifetime management 47:14 Wrap up

המדריך המלא על חיבור הדטא מאנליטיקס ל- Looker Studio: https://itayverchik.co.il/looker-studio/ במדריך זה, אני מראה לכם איך מחברים את כל הנתונים לדאשבורד אחד באנליטיקס. להרשמה למערכת לקידום אתרים: https://say-v.com/ הצטרפו עכשיו לקהילה של בוני ומקדמי האתרים הטובים בישראל בחינם לגמרי: https://www.facebook.com/groups/israelwp לרכישת אלמנטור פרו, מעצב העמודים בוורדפרס הטוב בעולם:⁠⁠ https://trk.elementor.com/2500⁠⁠ אין לכם עדיין חשבון אחסון אתרים או שאתם לא מרוצים מהאחסון הקיים שלכם? קבלו הנחה לאחסון אתרים קלאודוויז 25% ל-3 חודשים ראשונים: https://platform.cloudways.com/signup?id=314159&coupon=VERCHIK --- Send in a voice message: https://podcasters.spotify.com/pod/show/itay-verchik/message

The Complete Guide On Connecting The Data From Analytics To Looker Studio: https://itayverchik.com/looker-studio/ In this guide, I show you how to connect all the data to one dashboard from Analytics to Looker Studio. To Sign Up For The Keywords Tracking System: https://say-v.com/ Join now the community of Webmasters and SEO Marketers completely free: https://www.facebook.com/groups/itayverchik To purchase Elementor Pro, the world's best WordPress page designer: https://trk.elementor.com/2500 Don't Have A Web Hosting Account Yet Or Are You Just Not Satisfied With Your Existing Hosting? Get A 25% Discount For Cloudways Web Hosting For The First 3 Months: https://platform.cloudways.com/signup?id=314159&coupon=VERCHIK --- Send in a voice message: https://podcasters.spotify.com/pod/show/itay-verchik/message

ohne jeden Tag eine Stunde lang durch diverse Berichte zu klicken

In this special episode, we are featuring That Digital Show. As the electric vehicles (EV) sector accelerates, drivers are finding it a challenge to conveniently access charging points. This has become one of the biggest concerns for EV drivers around the world. Intending to solve this problem, Taiwan-born company ChargesSmith offers EV users an end-to-end charging solution by developing a map for drivers, with the most updated information on location and availability of charging points around the country.  Today, ChargeSmith serves more than 70% of EV users in Taiwan, partnering with various charging point operators to give users a high level of accessibility. Their vision and goal is to organize and share energy with communities, countries, and the earth.  In this episode, ChargeSmith CEO Andy Chen talks about sustainability in the EV market and the growth of EV adoption. As an EV driver himself, Chen shares the issues he faces first-hand, and how ChargeSmith is leveraging data to solve the challenges of today while paving a future for EV drivers of tomorrow. In this episode, we also hear from Alex Kuo of GAIA, who shares how his team collaborates with ChargeSmith to use cloud technology as an enabler in this evolving landscape. Are you ready for a cleaner driving experience? Tune in to find out.  Andy Chen, CEO of ChargeSmith Andy is one of the earliest EV adaptors in Taiwan. With enthusiasm for the EV community, he has led ChargeSmith to build up Taiwan's largest EV charging roaming network. Andy enjoys observing the market's pain points and using data-driven strategies to accelerate the adoption of the product.  Alex Kuo, Sr. Account Manager of GAIA An accomplished sales professional, Alex has led sales teams across the IT industry to success, helping SMB and enterprise clients achieve impressive business growth. With a passion for blockchain technology, Alex enjoys innovating and developing new products and services for clients that ultimately contribute to the growth of the industry. Theo Davies Theo is Head of Cloud Sales Excellence & Productivity at Google Cloud and host of “That Digital Show APAC”. He is a record-breaking salesperson, sales leader, coach and speaker with a 20+ year career beginning in sales. Theo is also the President of the Google Public Speaking Academy. Interview ChargeSmith: https://www.chargesmith.com/ev/ Hosts Theo Davies and Paris Tran

In diesem Webinar bietet Dir Iwen Kuhn vom MarTech-Unternehmen matelso wertvolle Einblicke in die Optimierung Deines Lead-Trackings. Er legt den Fokus darauf, wie Lead-Signale und richtige Leads erfasst, analysiert, bewertet und nahtlos in GA4, Google Ads und Data Studio integriert werden können – und das alles im Einklang mit der DSGVO. Du hast so immer den kompletten Überblick über Deine Conversion-Daten. Der Experte zeigt Dir anhand von Best Practice-Beispielen, wie Du das volle Potenzial Deiner Lead-Daten ausschöpfen kannst. Zudem zeigt Dir Iwen die Herausforderungen, denen Du als B2B- und Lead-Business-Marketer im Bereich Datenschutz gegenüberstehst, und geben nützliche Tipps für eine effiziente und konforme Datenverarbeitung. So bekommst Du das nötige Know-how, um Dein Lead-Tracking zu optimieren und den genauen Wert Deiner Leads zu bestimmen – und diesen im Lead Management-Prozess über GA4, Data Studio und Google Ads noch signifikant zu steigern. Folgendes hast Du nach dem Webinar gelernt: Wie genau können Lead-Signale, Leads und Abschlüsse für das Online Marketing erfasst und greifbar gemacht werden. Integration dieser Lead-Daten in GA4, Google Ads und Data Studio. Verständnis der DSGVO-Anforderungen in Bezug auf die Erfassung und Verarbeitung von Lead-Daten sowie deren Anwendung in der Praxis.

Bruno Aziza – Head of Data and Analytics at Google Cloud – has a unique expert perspective on the data industry  through his work with data executives and visionaries while managing a broad portfolio of products at Google including  BigQuery, Dataflow, Dataproc, Looker, Data Studio, PubSub, Composer, Data Fusion, Catalog, Dataform, Dataprep and Dataplex. In this episode, Bruno we dive into  topics such as the development (and disappointment) of Data Mesh, how it relates to Data Products, along with how data leaders can transform their organizations by first looking inward and transforming one's self.We also speak to why Chief Data Officers are navigating from 'reactive analytics' to data products that are driven by real-time. Follow Bruno Aziza on Linkedin, Twitter, and Medium.What's New In Data is a data thought leadership series hosted by John Kutay who leads data and products at Striim. What's New In Data hosts industry practitioners to discuss latest trends, common patterns for real world data patterns, and analytics success stories.

What impact will AI have on marketing and advertising in 2023? Is Discord a viable marketing channel? What's it take to build a successful podcast? Join Erin Sparks and guest Greg Finn, partner at Cypress North and host of the Marketing O'clock podcast, as they answer these questions and many more on this episode of the EDGE podcast! [00:00:35] Reintroducing Greg Finn [00:01:48] Marketing O'Clock [00:05:38] Discord Community [00:09:42] EDGE of the Web Title Sponsor: Site Strategics [00:11:14] The Discipline of Recording a Podcast [00:13:18] Lessons from the First Year of Podcasting [00:15:56] AI Content and It's Use in Paid Advertising [00:18:29] EDGE of the Web Sponsor: Wix [00:24:37] Data Studio to Looker [00:25:36] EDGE of the Web Sponsor: SE Ranking [00:26:50] 2023 Digital Marketing and AI Predictions [00:29:03] What Excites/Bugs You About Your Industry? Thanks to our sponsors! Site Strategics https://www.edgeofthewebradio.com/site  Wix https://edgeofthewebradio.com/wix SE Ranking https://www.edgeofthewebradio.com/seranking Follow Guest https://www.twitter.com/gregfinn https://cypressnorth.com/ https://marketingoclock.com/ https://searchengineland.com/author/greg-finn https://www.linkedin.com/in/gregfinn/ Would love it if you'd give us a rating on ratethispodcast.com/edge!

What makes a stellar Google Data Studio dashboard? Michele Kiss has the answer. She is a recognised digital analytics leader, with expertise across web, mobile, and marketing analytics. She is a Senior Partner at Analytics Demystified, where she works with clients on analysis, training, and process, to help them draw insight from their digital data. Google Data Studio is Michele's go-to tool, and after hearing about its interactive nature, the visualization options it provides, and the way in which it allows one to craft captivating data stories with relative ease, it's not hard to understand why! >> VIEW SHOW NOTES + RESOURCES  In This Episode, You'll Learn… The multitude of benefits of using Google Data Studio. The different ways in which Google Data Studio dashboards can be optimized. How to make the most of the interactive nature of Data Studio. Her favorite places for finding Google Data Studio templates and best practices. Why Michele opts for more presentation slides with less information on each slide when presenting data. Michele's favorite Data Studio data visualization strategies. The difference between the Data Studio dashboards and Data Studio reports. Why simplification is key when it comes to data presentations and how to do it.  People, Blogs, and Resources Mentioned Looker Studio Blog Google Data Studio Online Course Measure Slack chat Analytics Power Hour My free 30-second online assessment to find out and overcome the #1 silent killer of your data presentation success

We discuss different ways to increase leads on your site through personalization with the Head of Partnerships from Optimonk, Eric Melchor.   Website Personalization is the human-centric approach to CRO that focuses on the customers' needs first. It is about creating more relevant customer journeys that are unique, remarkable, and meaningful on a personal level. A journey that starts with a personalized welcome message, which is improved by relevant product messaging, and ends with an irresistible offer, tailored to each customer. In our Personalization Bootcamp, I'll give you a deep dive into the art and science of website personalization. I'll show you how to use website personalization to grow your subscriber list, get more leads, and boost the ROI of all your marketing activities – all at the same time!   Transcript   [00:00:00] Track 3: Welcome to the using the Whole Whale podcast, where we learn from leaders about new ideas and digital strategies making a difference in the social impact world. This podcast is a proud production of Whole Whale a B Corp digital Agency. Thank you for joining us. Now let's go learn something. [00:00:27] Track 1: This week on the podcast we have Eric Melcor from OptiMonk. And as I understand, OptiMonk helps brands sort of personalize create, custom experiences on this site so that they can, uh, make more relevant content. And he is the partnerships and personalization ambassador. Beyond that, uh, Eric, uh, is big in, uh, European startups as a podcast host. [00:00:57] He is a self-proclaimed mediocre tennis player and also, uh, passed founded fly movement.org. Uh, a nonprofit focused on, uh, I guess youth health and, and tracking them. And this was based in Texas. So Erica, welcome to the podcast. Thanks for. [00:01:16] eric_melchor: Hey, George. Pleasure to be here. Thanks for having. [00:01:20] Yeah. And I will say it was, uh, you know, it's interesting how various guests find their way here, and in this case, I have to hand it to you. Uh, you wore me down on email. [00:01:29] email. [00:01:29] honestly, and the way I'll say this, the way you did it was very clever because, you know, after a number of these, I'll just be honest, they get a lot of random, Hey, look at our software. [00:01:39] George: Look at our software. , you actually did the homework. Listen to a podcast and then ask me, uh, the following [00:01:45] eric_melchor: following [00:01:45] George: how does [00:01:46] eric_melchor: does [00:01:47] George: moon cut his hair? To which I had to see the answer and it was, he eclipses it. Um, perfect. I mean, it's just per, I was like, damn it. He has my attention now. Ah, and clearly that's your job, getting people's attention and then moving that toward a goal, a conversion. [00:02:07] Track 1: Can you tell me a little bit. Your work and your approach. [00:02:13] eric_melchor: Yeah. Well, George, I, I guess a question for you. Have you ever gotten a handwritten letter before? [00:02:19] George: I have gotten a handwritten letter before from not [00:02:22] eric_melchor: not [00:02:22] George: mom, but I have gotten handwritten runs from my mom as well. [00:02:26] eric_melchor: And it pro, you probably felt delighted, right? You probably, it gave you a sense of importance. Right, that feeling. And so with Opti Monk, uh, we try to give marketers the tools that they need to give that feeling of delightfulness and importance to their website visitors in real time. like you mentioned, we are a website personalization platform, uh, that allows you to create different messages for different segments, and those segments can be. like your v i P donors, maybe they are new visitors to your website who, uh, you know nothing about. Maybe they're visitors from a specific channel, maybe like a, a volunteer website or maybe somebody who just made a donation. And so what we do is, uh, give marketers the opportunity and the tools. Very easy to do. By the way, it's mostly a drag and drop interface, and you don't need to have any coding experience, but to just take a step back and, and, and ask yourself, okay, if I was in this visitor's shoes and if I was a person that didn't know about my ngo, what is a good experience for that person? Or if I just made a donation, what would be a. experience for a post donation. and once you have the answers to those questions, then we give you the, uh, the ability to craft that experience, uh, in real time for your website, for those, for your audience, for those visitors. [00:03:50] Track 1: and I'm curious. We'll be shifting our, our conversation to how, how we get those conversions and different tactics, uh, for, for doing that. I'm curious though, how, how that's achieved, given the clamp down on third party cookies and the ability to like, understand who someone is, right? When someone shows up to the site, like, I go there, you don't know that I am George, you know that I am maybe coming from California because of my IP address. [00:04:15] What are the ways that I am beginning to customize somebody? Who they are versus what. [00:04:23] eric_melchor: Yeah. It's all dependent on the type of browser they use. Um, so it's, it's really based on cookies. If they're using Safari, we will recognize that data for. Unfortunately for maybe just seven days, but if they're using Google Chrome, then we can actually know who they are and recognize 'em for up to about a year. so it's dependent on the browser that, the browser that's somebody using, and it's all based on cookies. [00:04:48] Track 1: Gotcha. are, I mean, do you have concerns? We actually just released an episode of how the, you know, cookie apocalypse as we're joking and how cookies are just gonna get mowed over by updates. You know, obviously we've already seen it in Apple and the land of Apple, uh, but they could be coming for browsers like Chrome, you know? [00:05:10] eric_melchor: How [00:05:10] How. [00:05:11] do you view that as, you know, a shift in the landscape of personal. [00:05:16] landscape, uh, we kind of welcome it because we are investing a lot in zero party data and it's, it's really actually, and lemme just take a step back. What is zero party data? Zero party data is the data that's actually based on directly from your visitor. And so if, if you have somebody that comes to your website, you know nothing about them, maybe you just have like a, a nice message for them that just says, Hey, we wanna make this experience as pleasurable as possible for you, can you just let us know? [00:05:47] Are you somebody interested in volunteering? Are you an individual donor? Are you maybe a corporate donor or something else? And once they, they make an answer, then you already know a little bit about that person. and you could probably take 'em to the part of the website that's most valuable to them. But you can also, once they made that answer, you kind of tag them and then put them into a segment that can also be carried over to your email marketing programs and initiatives as well. And so a lot of our, the brands who use Opti Monk really take advantage of our, um, what we call conversational message. And you know this, like I mentioned there, there's different ways to start that conversation, but one of the most popular ways is just have a message that appears, uh, when somebody goes on your website, and again, it's asking. What are you interested in? You know, can you tell us who you are? You know, it's, it's, it's basically like a welcome and, and really trying to hold that person's hand and just take 'em to the part of the website that makes sense for them. And so we're not relying too much on. level data because a lot of this shift has been over towards how do you start that conversation? How do you get that engagement? How do you start those micro engagements so where you can start letting the person know that you're there to educate them, provide value, and ho their hand? [00:07:06] And that's where we're seeing a shift toward a lot of the top e-commerce brands. Start doing that at the very beginning, [00:07:13] Track 1: Gotcha. So it's a chat interface or it's a popup, or it's a form somewhere that says, what are you up to? [00:07:21] eric_melchor: Yeah. Yeah. And I think there's a big opportunity for NGOs because NGOs, in my opinion, most of them are focused on that. Do donate now button. think 99% of NGOs you go to, that's the main call to action. It's donate now and you really have to look for, uh, where to sign up for the newsletter. I, I mean, I was doing a little bit of research this morning, for example, world Wildlife Dot. Had a hard time finding out where to subscribe to. The newsletters. You gotta go at the very bottom and there's like a little text link that says subscribe. Same thing with charity water.org and another, uh, NGO called st baldricks.org. Right? It's like they're hiding it. For some reason, they're hiding that, that part of what could be a really good experience because not everybody just like in the, in the for-profit. everybody is purchase ready. And when it comes to NGOs, not everybody is ready to make a donation right there and then. so I think they're missing out on the opportunity to collect or basically try to get somebody's email so you can continue that conversation, tell them your story, tell them more about you, so when they are ready to make a donation, they can go back to your website and do just that. [00:08:32] So it it. there's very easy things that NGOs can do now to actually grow their subscriber list. Uh, and I could share a few of those, you know, with you during our conversation. [00:08:43] Track 1: Well, that's great. I think we are on the same team when it comes to believing that the, the, the smartest ask the lowest friction, highest yield play for social impact organizations. is around getting that email, that permission to communicate, to borrow from Seth Code. And that permission to communicate list is that first and most important asset because again, not just for the purposes of donation, but for awareness, identity alignment, for social change, you need that communication bridge. [00:09:19] And it's one that you own, you know, as, uh, as far as it goes. You don't own that Twitter. , you don't own that LinkedIn, like you don't own anything built on somebody else's. [00:09:35] eric_melchor: Yeah. Do you know how powerful that email is? And so years ago, God, it's been almost 10 years, but I created an NGO back in Houston, uh, and I ran it for five years. Ended it in 2018, and, um, when I ended it, I stopped sending out emails or updates about the initiative. I, I went back into MailChimp and I looked at my list and I, I was doing something that was related to, to that NGO years ago, and I thought it'd be great to just kind of let people know what I was doing. I sent in a campaign out, literally four weeks ago to that list that I have not communicated with in over five years, and my open rate was above 30. And so it is so powerful where just like you said, it's like those people, they're not necessarily following you on Instagram or maybe Twitter or TikTok, or maybe they are, but whatever you own that, that is like an asset that even if you don't use it, you know, on a consistent basis, you should. [00:10:36] You definitely should, over time you could actually send out a campaign with a thoughtful headline, you know, good educational, valuable content, and you're, you're still gonna get eyeballs. So it's very important. It's the, it's the most important thing you can do, as you said. [00:10:54] All right, So [00:10:55] let's jump into it. Uh, and maybe we can go [00:10:58] can [00:10:58] back and forth with ideas. Cause I really wanted to, to generate a little bit of value for the folks listening in terms of what they should be doing. And I love talking about this in q1, where you should be building your list, you know? Planting, planting the seeds before the tree, digging the well before you're thirsty. [00:11:16] Track 1: Insert metaphor here for here. Give me one of your more clever ideas for acquiring emails as a social impact organization. What do you got? [00:11:28] eric_melchor: Yeah, I mean, this one, this one to me is a no-brainer, and it's called, we call it sort of an exit intent popup. so e-commerce brands use this. If somebody's trying to leave the website and maybe they had something in their cart and it's like a little popup message that reminds them, Hey, you know, these, these are the items that are in your shopping cart, or, Hey, before you leave, you know, here's like a 10, 10% off coupon or something. But if you're a, a nonprofit, can use the same tactic. I mean, anybody. When they leave your website or they hit the uh, uh, the back button on the brows button, uh, just have like a little popup message that just says, Hey, do you wanna stay in the know and get our emails? And just have that little message there, appear when they are trying to leave your website. [00:12:13] And we see on average that that will give you email subscribers anywhere in the range of eight to 12%, which is actually much higher than trying to get somebody's email at the very. When you really don't know anything about them and they haven't even started browsing your website or clicking around. Um, so that's like one thing that I would highly recommend that NGOs start testing or experimenting with. [00:12:38] Track 1: and I love the fact that you put the caveat exit intent. Uh, I get very nervous when I see nonprofits throwing a popup in the, uh, time to first screen and interrupting the content, uh, layout and risking content layout shifts of the site load, which is a fancy way of saying it. Don't. Piss off Google with your pop-ups cuz you'll be hurting more than you are helping. [00:13:03] So yeah, I'm, uh, I'm on board with the exit 10. [00:13:06] eric_melchor: Yeah. Yeah, absolutely. Um, another idea, [00:13:11] Track 1: Go. Oh yeah. What I. [00:13:12] eric_melchor: Okay, another idea. And I'm on, I'm, I'm on the same page with you. I do not wanna show any popups during this entire experience what, what we have in this, in, in, in, in this platform. And I'm sure other platforms have the same thing as, as what we call a teaser. And a teaser is just like a little message that can fit like in the lower left-hand corner of your website. [00:13:33] And it's like a little message that just says, Hey, get our emails to stay in the know, you know? And it. It doesn't, it doesn't really stand out, but it does catch attention. Um, and if somebody wants to, if somebody's curious and they wanna click on that to see more information than they can, and once it's clicked on, then obviously, uh, like a pop-up would appear and it says, you know, you know, get our newsletters to stay in the know. [00:13:59] Please enter your name and email address right there. So that's probably the second thing that I would recommend. After the x and intent popup message, [00:14:08] George: I like it. Uh, well, I think I like it. I want to, I wanna see it, see it in [00:14:12] eric_melchor: For [00:14:12] George: know, it, I feel like there can be a bit of a, , um, malaise that sits in with layout based email asks, right? They're like, oh, just stick it in your foot or stick it in your head or stick it in the sidebar. You know, that that sort of basic block and tackle of like, are, is it around there? [00:14:28] And then like, eventually the, the person that's amazing, they can just sort of have screen blindness to these things. Uh, and so, you know, I feel like some things can get lost. [00:14:36] eric_melchor: screen. [00:14:37] George: Um one I really like that I kind of go to is, uh, uh, various ideas framed around a content locker being. Here is a bit of information for free, but here is the entire list of 101 dma, and if you want the entire list of 101 DMA, hand over your email and we will give it to you right here. [00:14:57] eric_melchor: email. Yeah, I, I mean if that works, then great. You can probably, you know, continue using that. I didn't think of that, of that one for NGOs. Um, but what's important though, I think no matter what is that you have the right message for the right target, right? And so if you have specific landing pages and you know that, hey, on these landing pages, uh, it's probably a good opportunity to try and capture somebody's email address for somebody who is not yet ready to make a donation. but we don't wanna lose them. Um, and so on those specific pages, then you. know, present some sort of content, that could be very appealing, such as, hey, if you wanna get the a hundred list of 101 dalmatians, you know, sign up here and we'll, we'll get it to you. [00:15:41] So I think there's key landing pages that maybe are appropriate for that. [00:15:45] Track 1: All right. What else? [00:15:47] eric_melchor: Um, well, I mean, to be honest, I mean, those are the two tactics that I would try. First obviously donate. Now is, is the main call to action for NGOs, but the exit intent, the teaser pop up, and then the right message will be the other thing that I think is very, very, uh, important and the right message. If an NGO is doing any sort of like paid me to advertising maybe on Facebook ads, and so you have traffic come into your website and you. these people never heard of you and they didn't come in through, you know, organically, but they came in through a paid ad. Then on that landing page would be another opportunity to where you could have very targeted messaging for those visitors dependent on the ad. And so if that ad. That messaging that was on the ad itself make it very appealing and make sure that it's, it's the same sort of messaging or value proposition that's on the headline of that landing page. And I think once you have that, then it's, it's, it's much easier to try and get the, um, the email, uh, the email ask, uh, once you have your ad aligned with your landing page headline. And so that would, that would be the third tactic [00:17:00] Track 1: I'm glad you mentioned the value proposition because along the way you, you mentioned you, you have a new, uh, a newsletter pop up saying like, get the newsletter from us. And that's one of those like, sort of like triggering things for me when I see an organization trying to make their unique selling proposition, Hey, their user. [00:17:20] George: Would you like another email in your in. , do you know? Are people, if you walk around being like, you know what? Do you need me to hit you in the hand with a hammer? Cuz I have one. I'll do it. [00:17:32] You need another email in your inbox? [00:17:33] eric_melchor: inbox. [00:17:34] George: So I like that you said value proposition. Can you tell me [00:17:39] eric_melchor: compensation about [00:17:41] George: approach? [00:17:41] Anything maybe the product does, or what you've seen for message testing [00:17:45] eric_melchor: investing [00:17:46] George: getting away from? I will say the dreaded, like you need another. [00:17:51] eric_melchor: Yeah. Um, humanizing the copy, the brands that we work with, those that tend to have the higher conversion rates in terms of getting email subscribers are the ones where the copy is, uh, is humanized. [00:18:06] And what I mean by that, like off the top of my head, I think really good emails.com, they've gotta. And it says something like, hey, sorry to be an AHO and interrupt your experience here, you know, But I mean, it's just, it's just a really good copy that captures your attention you end up reading the entire message and, uh, you know, it's got this, it's got this humorous component, human touch, you know, that it wasn't like standard copy and paste corporate type messaging. [00:18:36] So if you can do anything. Maybe could put a, make somebody laugh and, uh, you know, that, oh wow, this person, you know, or this organization, uh, they're trying to, you know, human humanize a this approach, this human-centric approach, uh, that works well too. [00:18:55] Track 1: There's a term in, in marketing, communications and copywriting. Um, grabbing a, a swipe file and creating a swipe file. And this is just a, a funny way of saying like, , you should go around and shop for anytime you see something like that, something clever, a good framing in and around, adjacent or even not adjacent communication and, and, and save it and sort of prime your mind with ways of doing that because I think you're, you're right, you need to have something that breaks the third wall. [00:19:29] Something that stops the normal train. Consume and move. Uh, and so, you know, I dare say interrupt, but rather entertain is a, a good framing and a good approach. And, and too often just because a nonprofit works on serious issues doesn't mean they always need to be serious. There, there's a line there. Um, and I think it's possible to skate on both sides. [00:19:59] and you know, your point, I don't know, would work on a, you know, world animal protection being like, sorry to f and interrupt here. You know, we were busy with this tiger, but get on this email. Uh, you know, you wanna be careful. But, uh, when it comes to, when it comes to AB testing though, because we're gonna come up with a clever idea. [00:20:18] Cool. Does it work? Can you tell me a bit about your approach to AB testing messages? [00:20:26] eric_melchor: Yeah, I mean, that's what we recommend for all brands to do. It's very easy, e very easy to do within our platform. Uh, I'm not sure if you knew this, George, but Google is suning Optimizly. I think [00:20:38] George: Ah, don't [00:20:39] Track 1: get me started on the number of things. Google is sunset. That has me infuriated number one, universal analytics, number two. Is optimized like number three is just the fact that they're rebranding Data Studio as Looker, cuz they got Looker and now they're just getting rid of Data Studio. But it's like pretty much the same functionality. [00:20:56] But I'm, you know what, Google, just stop it. [00:21:00] eric_melchor: Yeah. It, yeah. [00:21:02] George: Rant. [00:21:02] Track 1: End. Rant. Continue. [00:21:05] Before I interrupted. [00:21:06] eric_melchor: Yeah, but that, that's the main thing that you should be testing. You could test headlines, you know, with AB testing. With the messaging, like for popups, asking for an email subscriber. You can test different popups that have a different image, different copy, or maybe even the different popup itself, maybe an exit and 10 popup versus another side message popup. [00:21:24] There's all kinds of ab testing that you can do within our platform, and, uh, you can see, you know, the results in real time also with the degree of statistical. Uh, significance as well. You know, if it's at least 90% or better, we show that too. Um, as as well. But, uh, the humorous approach, I mean, how did I get your attention, George? [00:21:45] You know, y I sent an email and I don't think I got a response and I followed up with, uh, with the joke, right? And so it works if that is your person. You know, if that is, if you're being authentic and you're being genuine, it works, right? And so if you're an, or if you're an organization and you're very professional and very corporate, like it's probably not gonna work If you, you tr first of all, it's not even gonna get past compliance and legal. [00:22:14] They're not , they're not even gonna allow that. But it really works. If that is your personality type, and I, I would say that I'm able to get a response back to more than 90% of people that who don't know who I am, but I end up sending them, you know, a code email or something, and I add a touch of humor, because. people under, people wanna work with people they like. And if you can make somebody laugh, then you're, that's, that's half the battle already. They're like, oh wow. You know, this guy put a smile on my face. And it's the same thing works with, we're trying to get somebody's email, maybe even trying to get somebody to donate. [00:22:51] Right. And it's engaging, it's like a fun micro engagement that I don't see brands take advantage of, enough in this day. And. [00:23:03] Track 1: Well, certainly in, in your approach, like look, you're, you are proof, proof to that statement right now, right? You got through I'd say a fairly high barrier of me ignoring the heck out of everything that comes in, uh, to my attention, the. Point though also as, as a tactic, you know, if you are doing that type of cold outreach, which, you know, fundraisers and communications folks do, when you're trying to get the attention of the c s r director at so-and-so, when you're trying to get Yeah, just a conversation at maybe the, the, the grant manager at what you callit trust, I think going back to what is your value proposition and how are you positioning who you are and what it is like humor has. [00:23:47] Um, and it communicates more than maybe we, we realize what I enjoy talking with this person. Does this person both see the cause, see the issue, see the world. And you know, how, you know, how humans really do orient around humor. And I think is, is undersold in, in what I see around social impact communication and certainly just as a tactic. [00:24:09] I think there's a lot to borrow. I think there's a lot to borrow here from, you know, I'll, I'll see this, this tactic more from, you know, folks that are, we'll call it SMILE dialing and emailing [00:24:21] George: for, [00:24:22] Track 1: for attention, but there's a lot I think nonprofits could borrow. What do you think about that? [00:24:28] eric_melchor: Absolutely. Um, when I was at Bonura and people would come on board for like a free trial, you know, all of us, we would try to send, uh, a personal video. And I found that once I started telling people jokes, specifically like cheesy dad jokes, like, Hey, when does a joke become a dad joke? When it becomes apparent, 20% of people would respond with a video of their own and tell me a dad. You know, and , it just, it just really, it just really broke down Barriers started the conversation and the conversion rates compared to just sending anybody a personal video and just saying, Hey, hi, welcome to have you on board. Um, it blew those, you know, through the roof. I mean, significantly higher when you, when you try to add humor. [00:25:14] And I do the same thing on LinkedIn too. When I connect with somebody and it's somebody that I do wanna engage with, you know, if I just send them, uh, a really nice message, even with a little dad joke or whatever. I actually get a lot of responses back. People are sending me jokes as well. So, uh, I think it, if you could put a smile on somebody's face, um, it just really opens the door for further communication, just as it did with you, you and myself here. Um, and that kind of clever, that kind of humorous approach. Really works well for any sort of organization that is trying to start that conversation, that initial conversation, uh, whether it be a customer, a potential donor, maybe somebody that they just wanna continue that communication with in the form of a newsletter or email. [00:25:57] And it works, you know, it, it works. It's been working for me over the past three, four years. And, uh, I've had nothing but great, you know, great results from it and created lots of different friendships, relationships, and contacts, uh, because of that. [00:26:14] Well there you have, we had, we had to get you to minute 26 of this podcast. [00:26:18] podcast. [00:26:19] but there it is. There's the gem for you. You can stop listening. Dad jokes. Dad jokes convert. Simply put, you could stop listening now, or maybe there's more, but there's probably not, uh, I, you're, you're just talking to somebody who has taken great pride in the fact that we index, I think, [00:26:35] think. [00:26:35] positions, whatever, one, two, or three in the top, top few for non-profit jokes. [00:26:42] George: Um, because I thought it was funny and I just put a bunch of dad jokes as non-profit. Simply because, uh, simply because, but getting back to [00:26:52] eric_melchor: getting [00:26:52] George: idea of AB testing, I think this is critical, uh, because just setting it and forgetting it, [00:26:57] eric_melchor: it, [00:26:57] George: uh, is betraying the point of doing the work in the first place. Do you have any stories or anecdotes or testimonies of being like, you know, I did [00:27:07] eric_melchor: I [00:27:07] George: thing and then suddenly the conversion rate doubled. [00:27:10] eric_melchor: Right? That dream of like two x it, because here's the power. and I don't think we, we get it. [00:27:16] it. [00:27:16] When you double a conversion rate, you have doubled your effective ad spend. You have doubled the efficacy of all of the hours of work you put into writing content. You've doubled the downstream net income that comes from the value per email. [00:27:35] Track 1: It, it is so. and it takes sort of so little time, but it is so overlooked and I like, I try to frame it in different ways, but do you have, what is your stump speech on this? Do you have any stories? [00:27:47] eric_melchor: Yeah. Uh, I remember when, again, back to the personal video and welcoming somebody that, that was coming for free trial for Bonura. I, um, I started experimenting with after I said the dad joke, right, where we could tell if it was like a SaaS company or if it was an ngo. Or if it was an e-commerce, uh, company, uh, or if it was like an agency or something else. if we were, if we knew that information, um, we would see it before we would send out the video. And what I would do is the call to action would be specifically for. That specific industry. And we had case studies. So for example, uh, if you were an agency, we had case studies about agency owners who started using bargi and they were able to get more clients and more demo calls, uh, because they were sending out personal videos if you were in the education space. [00:28:42] We had case study on a university that started using uro and uh, they saw that application rates started. Went up like 25% because they were sending out personal videos to potential new students, uh, at the university. And so once I started including a specific call to action that was tied to that industry in the, in the video that I was sending out. the conversion rates, but more than double, I mean, we were seeing clickthrough rates go from, on average, from like 15% to like over 35, 40 5%. And we knew that we had a winner right there just because we recognized who they were. and once we knew, were able to recognize who they were, then, you know, we could insert content that was most appealing for them. [00:29:26] In the case of a. Right. AB testing, you know, different headlines or different value propositions for the different, uh, visitors that are coming in from different segments. And so with a platform, with the personalization platform, it should have the ability to trigger a different headline, a different copy, a different image, or a different graphic. [00:29:50] Based on the source. So if you want to, if you're doing, you know, a lot of visitors, you have a lot of visitors from Instagram or maybe Facebook, you can actually show them a different message, um, on that landing page. But even better do an AB test where you have two different messages trying to appeal to visitor visitors. [00:30:08] Or maybe you don't even want to a ab test the headline. Maybe you just have a regular experience. But for 50% of the visitor, visitor. you're asking them a survey. And on that survey you have a few questions that you're asking them so you can do different things, um, uh, based on the source of where they're coming from. Um, also, you know, based on, um, Uh, the type of visitor. So maybe it's a returning visitor, maybe it's a v i p customer. You already have them in your C R M and you already know who they are. and then also, you know, new visitors as well. You can also ab Tess, um, with those visitors as well, so starting to get carried off there. [00:30:46] But yeah, it's a fun approach. I always, my, my philosophy is you can't really call yourself a marketer if you don't do AP testing. Point, point, break. [00:30:56] Track 1: Well, you can call yourself whatever you want. Can't call yourself a good marketer. [00:31:00] eric_melchor: Yeah. [00:31:01] Track 1: Uh, I think also with, with nonprofits, they have access to other other means, including now limited to the Google Ad Grant, which is 10 K a month in kind of search advertising. now you can tune and fix all day on the top of that funnel and get, you know, after a certain point diminishing returns on, on that traffic. [00:31:21] But looking at the landing pages, looking at what you do with that traffic once it's on your site, like you can then look down the marketing funnel and then remember when you get those improvements, it magnifies the value of that attention because you're converting it, turning it into the permission to talk to somebody. [00:31:39] But it's only through that, that activity. Of AB testing. [00:31:43] George: Alright. [00:31:44] eric_melchor: Yep. [00:31:44] George: Yeah. [00:31:45] eric_melchor: bringing back memories. I remember when I started my nonprofit, I didn't find out about that program till like over a year. And when [00:31:51] George: Oh gosh. [00:31:52] eric_melchor: like, why didn't anybody tell me about this? You know? Yeah. [00:31:58] Track 1: Well, I mean, whole whale. We have, uh, free resources on how to set that grant up to maximize it and what you can get out of it. We spend a lot of time trying to give away that information. Um, we even have a, a trained cohort coming up where, um, you know, that. Nonprofits limited. 25 of 'em can, uh, can be a part of it, uh, because it's such a powerful tool. [00:32:19] But it's also, you know, it, it's important because all that glitters is in gold. There's a diminishing return after maximizing it, and then it's just about managing it efficiently for, uh, what it's good for. So before you run off, if you've never heard of this before, be like, oh my gosh, I'm gonna start a nonprofit just to get this grant and I'm gonna take over the world. [00:32:36] Like, read the article first. [00:32:38] eric_melchor: yeah. Yeah, absolutely. [00:32:41] Alright, Eric, anything else that you wanna leave with our audience as a, a tip or guidance [00:32:47] Guidance? [00:32:48] on the upside of personalization? [00:32:51] Yeah. Website personalization is a bit like Google Analytics and everybody thinks that, oh, I know how to use Google Analytics because they figured out, figured out how to create an account. And get it working. Um, but the thing is, is that you really want to try to go to. Get as much education as you can. [00:33:08] Maybe go to our workshop. We have free workshops, free website, personalization boot camps. I actually conduct those and we walk you through our process we actually show you a lot of, uh, the best practices that top companies do, small and mid-size organizations on how they use website personalization. [00:33:27] And we provide free resources along with like a checklist. And based on that checklist, you actually will uncover, um, top ideas and experiments that you can do that are going to give you the biggest ROI based off the reach, the impact, and um, the expected effort. And so once you have that, then you have an idea in terms of what should be the priorities of what I should focus on next. [00:33:51] And then we also have like playbooks and how you can implement those for, uh, for your website. So, um, that URL. Optum munk.com/bootcamp and that that's the what I highly recommend. That if you wanna learn more about website personalization, then check that out. [00:34:08] George: Well, we normally end our show with rapid fire. I'm going to cherry pick some out of there because typically we're talking to non-profit leaders and focused conversations. But I, I'm gonna throw some random questions at you. Uh, please keep your answers super short and here we go. [00:34:23] eric_melchor: Okay. [00:34:23] George: is one tech tool that you have started using in the past year? [00:34:27] Track 1: We cannot say optimum. What is it? [00:34:30] eric_melchor: One tab. [00:34:31] Track 1: One tab? [00:34:32] eric_melchor: Yeah. Have you heard of this, George? [00:34:35] Track 1: No. What? [00:34:36] eric_melchor: No. So, you know, every marketer has like 50 or 60 tabs open and it makes your website, you know, your, your computer run slow anyway. Um, Uh, for, it's for Google Chrome and you can use it in basically just kind of hides and, and saves in the back, keeps it, keeps it in the back, all those tabs and you can very quickly, uh, find them. [00:34:57] But it just saves a lot of me memory. Um, you know, while you're using Chrome and you don't have to have 50 tabs open, you can just have one or two. It's called Onet tab. [00:35:07] Track 1: what is one tech Dragon Tech problem issue that you are currently battling with? [00:35:13] eric_melchor: Uh, text Expander. This is another third party tool. Um, it's a great tool that allows you to just to type a few different keys in and it'll auto-populate the rest of the message. [00:35:23] George: this a G [00:35:23] Track 1: P T three game? [00:35:25] eric_melchor: no, the problem that I found out is that if you have LinkedIn open at the same time, LinkedIn, um, thanks that you're using it as sort of an automation tool to try and connect with people. Autom messages people on LinkedIn. And so I actually have my LinkedIn account like, like pause for like 24 hours because of this thing. so that's the thing that I'm currently battling. It's called Text Expander. It's a good tool but just can't have LinkedIn open or can't have it open. When you're using LinkedIn, [00:35:57] Track 1: Okay. Uh, what advice did your parents give you that you either followed or didn't? [00:36:03] eric_melchor: uh, I would say the advice, it was not so much like words, the advice, but more of actions and, uh, my dad, when we were kids, he had this like mini Mitsubishi truck and I remember the windshield wipers and stop working and he never replaced them. And so it'd be like raining and he would, you know, be trying to drive out there in the middle of the night. Couldn't see. Couldn't see. And I've always just, it's not necessarily advice, but it's one of those things that you learn from and you, you learn like what not to do as a parent. And now that I'm a parent, it's like that's something, you know, stupid things like that I would never do. [00:36:47] Track 1: Who is the most important mentor that you've had, and how did you come across? [00:36:52] eric_melchor: Oh, uh, my most important mentor would be secondary mentors. And so that's just a lot of different books, everything from, oh God, Napoleon, to, uh, God, I mean even, even and, and different coaches like Pat Summit, Vince Lombardi, um, did a lot of reading when I was younger. I just didn't really have a lot of access to good mentors, um, or people in my family. Um, you know, I'm first college graduate in my family, so, uh, secondary mentors were just a lot of books that I, that I read so many [00:37:30] Track 1: What is something you think you should stop? [00:37:37] eric_melchor: mm. You know, I've, I'm really happy with my life right now and the person that I am, the parent that I am, the father, that I am, the husband that I am. I think of one thing that comes to mind is, um, I haven't written any handwritten letters to my family, I think in over a year. And so that's something that I should start doing, but that's like the first thing that comes to mind. oh, I know what I should stop doing. Eating, eating candy and junk food when I go to. It's 10:00 PM I go to bed and I go grab some, a candy bar, and I'm eating that. That's, that's what I should stop doing. [00:38:11] Track 1: Yeah, you gotta put the Gremlin law into effect. No feeding after a certain period of time. [00:38:15] eric_melchor: Yeah. Yeah. My wife is, uh, to blame for that one. [00:38:19] Track 1: Well,      

איך לחבר את כל הנתונים שלכם מפייסבוק וגוגל אנליטיקס וכל פלטפורמה שהיא אל לוח בקרה אחד Data Studio?! הצטרפו עכשיו לקהילה של בוני ומקדמי האתרים הטובים בישראל בחינם לגמרי: https://www.facebook.com/groups/israelwp --- Send in a voice message: https://podcasters.spotify.com/pod/show/itay-verchik/message

In episode #2308, we discuss the tools we use to track our marketing. The answer is more simple than you think! Tune in to find out what companies are getting wrong when it comes to tracking their marketing and how to strike the ideal tracking balance.  TIME-STAMPED SHOW NOTES: [00:20] Today's topic: what we use to track our marketing. [00:25] Our simple approach: Google Analytics and Data Studio. [00:44] What companies are getting wrong when it comes to tracking their marketing? [01:19] How to optimize tracking with Supermetrics. [01:49] Why we use different tools for social tracking. [01:55] The ideal tracking balance. [02:41] That's it for today! [02:51] Go to marketingschool.io for more resources based on today's topic. Links Mentioned in Today's Episode:   Subscribe to our premium podcast (with tons of goodies!): https://www.marketingschool.io/pro Google Analytics: https://analytics.google.com/ Data Studio: https://datastudio.google.com/ Supermetrics: https://supermetrics.com/   Leave Some Feedback:     What should we talk about next? Please let us know in the comments below Did you enjoy this episode? If so, please leave a short review.     Connect with Us:    Neilpatel.com Quick Sprout  Growth Everywhere Single Grain Twitter @neilpatel  Twitter @ericosiu

Google Anzeigen deiner Konkurrenz sehen, neue Assets, ähnliche Zielgruppen werden abgestellt, YouTube Werbung per Audio, Data Studio heißt nun Looker Studio

Andre Alpar ist Online-Marketing-Experte und beweist in #askAndre seit über 100 Folgen, dass er ein Meister darin ist, Antworten zu finden. Denn in #askAndre dort ihr Andre zu euren Online-Marketing-Problemen ausfragen. Andre zeigt diese Woche wieder einmal, dass er ein echter Fuchs ist und liefert euch die Lösungen zu Fragen rund um Data Analytics, B2B Marketing und Special-Interest-Marketing rund um einen Adventskalender: 1. Maik – Data Analytics In der Agentur, in der ich arbeite, nutzen wir zwar schon länger die Daten aus Google Analytics als Single Source of Truth, jedoch ist die Beurteilung einzelner Ads auf Basis dieser Daten immer ein Recht hoher Zeitaufwand. Um den Prozess einfacher zu machen, würde ich gerne plattform-bezogene Daten aus z.B. Facebook und Conversion-Daten aus GA in eine Tabelle bringen. Mein erster Gedanke war hier Data-Studio - nach einigen Versuchen habe ich jedoch herausgefunden, dass das Blending von Daten auf Anzeigenebene zumindest bei einer größeren Anzahl von Anzeigen nicht vernünftig funktioniert. Hättest du hier eine Empfehlung, wie man die Daten zusammen bringen könnte? Mich würde insbesondere auch interessieren, was hier ein sinnvoller Join Key wäre - bislang habe ich versucht, das über einen Ad ID Platzhalter in einem UTM-Parameter zu lösen und den Wert im UTM-Parameter anschließend mit der Ad ID der Plattform abzugleichen. Der Ad ID Platzhalter löst sich jedoch leider zu oft nicht in die tatsächliche Ad ID auf. 2. Florian – B2B-Marketing Ich habe eine Frage bezüglich Online-Marketing im B2B-Bereich. Unsere Kunden sind Restaurants. Über welche Kanäle kann ich diese am effektivsten kontaktieren? Auf LinkedIn oder Xing sind die ja eher nicht vertreten. Macht es Sinn, diese über Instagram mit einer Direct Message anzusprechen? Für mich wirkt das eher unprofessionell. 3. David – Special-Interest-Marketing Unsere Frage dreht sich um einen dieser Special-Interest-Adventskalender, der in diesem Jahr schon einmal in geringer Stückzahl produziert und vermarktet wurde und in 2022 – da er bei den Käufern gut ankam – nächstes Jahr in größerer Stückzahl erscheinen und vermarktet werden soll: Der Elvis-Presley-Adventskalender (zweisprachig: Deutsch/Englisch). Wichtigster Absatzkanal für die Vermarktung dieses Adventskalenders ist Amazon. Über welche Medien oder Marketingmaßnahmen können wir diese spitze Zielgruppe „Elvis-Fans” erreichen und wie erfahren sie von diesem schönen Adventskalender? Denn wir dürfen natürlich nicht davon ausgehen, dass ein Elvis-Fan eigeninitiativ auf die Idee kommt, nach einem Elvis-Presley-Adventskalender zu suchen. Somit greifen aus meiner Sicht SEA, SEO und Amazon Ads erst im zweiten Schritt, wenn die Nachfrage erst einmal entfacht ist. Über welche Online-Marketing-Maßnahmen würdest du versuchen, Elvis-Fans in Deutschland (und parallel dazu ggf. in den USA) zu erreichen, um sie auf den Elvis-Presley-Adventskalender aufmerksam zu machen? Andre liefert wieder ordentlich ab und gibt neben den Antworten auch detaillierte Erklärungen, die auch dich weiterbringen werden. Jetzt reinhören und lernen! Hast du auch eine Frage an Andre? Schick uns eine Mail an report@omr.com und gewinne einen OMR Report nach Wahl, wenn deine Frage in den Podcast kommt. Abonniere den Kanal und schreibe uns eine Bewertung auf Apple Podcasts, wenn dir OMR Education gefällt!

[Referências do Episódio] - TEMPEST ACADEMY CONFERENCE - https://www.even3.com.br/tempestacademyconference/ - Earth Preta Spear-Phishing Governments Worldwide - https://www.trendmicro.com/en_us/research/22/k/earth-preta-spear-phishing-governments-worldwide.html - Google Search results poisoned with torrent sites via Data Studio - https://www.bleepingcomputer.com/news/security/google-search-results-poisoned-with-torrent-sites-via-data-studio/ - Alert (AA22-321A): #StopRansomware: Hive Ransomware - https://www.cisa.gov/uscert/ncas/alerts/aa22-321a [Ficha técnica] Apresentação: Carlos Cabral Roteiro: Carlos Cabral e Daniel Venzi Edição de áudio: Paulo Arruzzo Narração de encerramento: Bianca Garcia Projeto gráfico: Julian Prieto

W drugim odcinku „Cudne rozmowy o marketingu” porozmawiamy z naszym gościem na temat Consent Mode, czyli trybie uzyskiwania zgody. Wejście w życie przepisów związanych z ochroną prywatności użytkownika oraz przetwarzaniu danych osobowych wymagało reakcji świata digital marketingu i nie tylko. Co za tym idzie, zmienił się również sposób zbierania cookies, które dostarczają nam niezbędne dane o użytkownikach do procesów marketingowych. Rozwiązaniem jest Consent Mode, który pozwala użytkownikom zdecydować o wykorzystywaniu plików cookies. Podczas audycji dowiesz się wielu praktycznych rzeczy, takich jak: ✔️ Czym jest Consent Mode i czy jego wdrożenie jest obowiązkowe? ✔️ Do kiedy trzeba wdrożyć Consent Mode? ✔️ Jakie kary czekają osoby, które nie wdrożą Consent Mode? ✔️ Jakie plusy wdrożenia Consent Mode? ✔️ Jak wygląda proces wdrażania i z jakich narzędzi warto korzystać? ✔️ Jak wdrażamy Consent Mode w Cube Group?

In this episode, Jon will share about the new, renamed, Looker Studio reports. This product, formally called Data Studio, is a great tool to help you see reports of digital ministry activity, and to share those stories with supporters, prayer partners, and more. To watch this training, click here: https://youtu.be/i7d89stwqck

**Suggest a topic or guest by filling out the form https://bit.ly/3MNtPzl, or emailing podcast@measurelab.co.uk to drop Dan and Dara a message directly.** --- Intro 00:00:15 Topic 00:07:03 Wind down 00:31:50 Outro 00:33:40 --- Quote of the episode from JJ: "this Data Studio thing is pretty sweet. Let me spend way too many hours writing some blog posts about how you can use it" Quote of the episode from Dan: "a lot of people don't know that Google isn't doing what it says on the tin" Quote of the episode from Dara: "sometimes people ask for more customisation, but then when you get it you don't necessarily know what to do with it" --- This week Dan and Dara are joined by JJ Reynolds to chat about the recent rebranding of Data Studio to Looker Studio and what it means for the rest of us. They share many 'hot takes' on where they think this change came from, and where they think it'll go in the future. The announcement from Google on the Looker Studio name change is at https://bit.ly/3eIG5Gt. Check out LookerStudio.VIP at https://bit.ly/3COv8Lu, and the (not so) secret page showing all of their traffic, revenue and number of subscribers across all time at https://bit.ly/3eUKrtT. In other news, JJ gets out and about, Dara goes to the cinema and Dan escapes! Follow Measurelab on LinkedIn - https://bit.ly/3Ka513y. Intro music composed by the amazing Confidential - https://spoti.fi/3JnEdg6. If you're like what we're doing here, please show some support and leave a rating on Apple, Spotify, or wherever really. The post #57 Who you Lookering at? (with JJ Reynolds @ LookerStudio.VIP) appeared first on Measurelab.

Debi Cabrera and Stephanie Wong have more great Next content this week as we focus on launches specifically related to data and analytics with guests Bruno Aziza and Maire Newton. We start the episode with a look at current customer trends in data, including tools for increasing efficiency when working with many different types of data. Data governance and security is another area where Bruno sees advances in satisfying customer needs. Maire talks about the steps Google is taking to help customers implement knowledge gained with data, including Looker and new integrations with tools like Looker Studio to easily connect tools for better data access and use. Strategic partnerships with companies like Tableau help accomplish these goals as well. With 21 data and analytics launches at Next, exciting solutions are out there for customers. Bruno and Maire highlight their five favorites, like BigQuery support for unstructured data, allowing analysts working with SQL to do more with more data. To simplify workflows, BigQuery integration with Spark is a new feature that Maire tells us about, and we hear more about BigLake and it's increased format support. Data reaches more people easier now with Connected Sheets available for anyone using Google Workspace, and finally we talk more about Looker. Bruno details the four use cases of business intelligence customers and how Google's suite of data products satisfy their needs for a reasonable price. Bruno Aziza Bruno is head of data and analytics for Google Cloud and leads the outbound product management team. He has more than two decades' of Silicon Valley experience, specializing in scaling businesses, and has written two books on Data Analytics and Enterprise Performance Management. Maire Newton Maire is an Outbound Product Manager at Google Cloud with almost 15 years of experience partnering with organizations to develop data solutions and drive digital transformation. She's passionate about helping customers develop data-driven cultures by using technology to meet users where they are. Cool things of the week Google Cloud Next for data professionals: analytics, databases and business intelligence blog ANA104 How Boeing overcame their on-premises implementation challenges with data & AI site ANA100 What's new in Looker and Data Studio site ANA101 What's new in BigQuery site ANA106 How leading organizations are making open source their super power site Google Cloud Next: top AI and ML sessions blog Interview Building the most open data cloud ecosystem post Data Journeys videos Google Cloud Next ‘22 site Looker site Looker Studio site Tableau site BigLake ste BigQuery site Use the BigQuery connector with Spark docs Connected Sheets docs What's something cool you're working on? Debi is getting married and working on Dataflow Prime. Hosts Stephanie Wong and Debi Cabrera

1. Facebook Retires ‘Instant Articles' - Originally launched in 2015, Instant Articles were designed to provide publishers with a more engaging, fast-loading way to present their articles on Facebook, helping to maximize reader engagement within the app. As reported by Axios, Meta's ending support for Instant Articles as it works to better align with user preferences, which, increasingly, see video being its most engaging content format.2. TikTok Adds Photo Mode - Now TikTok has copied Instagram (perhaps in retaliation for IG copying all of its stuff) and launched  a new ‘Photo Mode' for still images in the app. Photo Mode looks exactly like Instagram, with users able to post carousels of still images that users can scroll through in the app. Per TikTok:“Photo Mode allows you to share carousel posts of still images that automatically display one after another. You can add music to soundtrack the images, which viewers can swipe through at their own pace.”3. YouTube Launches @handles For Channels - YouTube's moving more into line with other social networks with the addition of @handles for channels, which will make it easier to drive traffic to your profile, and promote your channel in the app.“Handles are a new unique identifier (example @youtubecreators) & ALL YouTube channels will have one. Your unique @handle will help people find & interact with you & your YouTube channel. And because handles are unique (unlike channel names), it's easy to confirm if you're engaging with the right person or not.”Your @handle, which will be unique to your channel (unlike Channel names), will directly connect people to your content, like it does on Twitter, TikTok, Instagram, etc. @handles will also function as a unique channel URL, providing another branding opportunity. Up till now, custom channel URLs have only been available to creators with 100 subscriptions, but now, YouTube's making the option available to all users in the app. @handles will also make it easier and faster to mention channels in comments, community posts and video descriptions.“For example, creators can be shouted out in a mention in comments or tagged in the title of a recent collab, helping them increase visibility and reach with new audiences.”Part of the idea here is to better promote channels, in alignment with habitual trends, with a key consideration likely being Shorts and helping to maximize Shorts channel growth by making it easier to follow creators. Another element that YouTube's looking to tackle is the rise of copycat channels, where scammers create channels that look similar to popular YouTubers', often by using the same channel name. By ensuring that each channel has a unique @handle, which they can promote direct, that will make it harder to create replica channels, and trick users with uploads and scams.4. Google Data Studio Is Now Looker Studio - Google launched Data Studio in March 2016 as part of the enterprise Google Analytics 360 suite, with a free version that lets you turn your data into informative, easy-to-read, easy-to-share, and fully customizable dashboards and reports. There are easy-to-use drag-and-drop features to customize reports from various data sources, including Search Console, Google Analytics, Google Ads, and much more. Now Google has renamed the popular analytics and data platform from Google Data Studio to Looker Studio. Google wrote “starting today, Data Studio is now Looker Studio.” “With this complete enterprise business intelligence suite, we will help you go beyond dashboards and infuse your workflows and applications with the intelligence needed to help make data-driven decisions,” Google added.Google also announced a Pro, paid, version of Looker Studio named Looker Studio Pro. Google said that the Pro version will get new enterprise management features, team collaboration capabilities, and SLAs. Google said that is just the first release and the company has “developed a roadmap of capabilities, starting with Dataplex integration for data lineage and metadata visibility, that our enterprise customers have been asking for.”You can learn more about this change on the Google blog.5. Google Swaps Title Tags With Site Names For Mobile Homepage Results - Google is now only showing the generic site name in mobile search results that are for the entire website, such as for the home page. Google is using site names in order to make it easier for users to identify the specific website in the search results. Here is what Google published in the official announcement:  “Today, Search is introducing site names on mobile search results to make it easier to identify the website that's associated with each result…”This new feature is available in the English, French, Japanese, and German languages and will begin showing up in other languages over the next few months. Google is recommending the use of the WebSite structured data type because Google is using the WebSite structured data type, specifically the “name” property, to understand what the site name of a website is. So it is best that your site has the following: WebSite structured data Title tag Headings (H1, H2, etc.) Open Graph Protocol meta data, specifically the og:site_name You can read the official announcement here and the Search Central Documentation here. 6. Google Renames Webmaster Guidelines To Search Essentials & Some Changes - Google has renamed the Google Webmaster Guidelines to Google Search Essentials. The name change is Google's ongoing efforts to remove the term "webmaster" so that these tools and documentation do not narrow the focus to just "webmasters," but expands it to publishers, site owners, developers, creators, and so on. Google also changed the overall format, added clearer terms and examples and also tried to simplify them for easier consumption. Google explained they updated the: Technical requirements: It is a new section to help people understand how to publish content in a format that Google can index and access.  Spam policies: Google updated its guidance for its policies against spam, to help site owners avoid creating content that isn't helpful for people using Google Search. Google explained that most of the content in these spam policies has already existed on Google Search Central in the "Quality Guidelines", Google did make a few additions to provide clearer guidance and concrete examples for issues like deceptive behavior, link spam, online harassment, and scam and fraud.  Key best practices: Google published new guidance with key best practices that people can consider when creating sites, to create content that serves people and will help a site be more easily found through Google Search. 7. Google Announces Search Central Live Conference - Google announced live conference series called Search Central Live previously known as Webmaster Conference. The conference is scheduled for November 24, 2022 in Singapore. Registration for a limited amount of seats is currently open until November 15th, with ticket confirmation set to begin on November 17. Admission to the event is free. Per Google:“Before you buy your transcontinental plane ticket, keep in mind that we do plan to have more of these events in the future, and some might be closer to your base. Stay tuned for these updates on the Search Central Live event page or on Twitter.”Here is the official announcement.8. Microsoft Bing Launches Image Creator - An AI Image Generator - Microsoft has launched Image Creator - an AI image generator to its Bing search engine, which enables users to create digital art from text input. Let's say a picture of a Shiba Inu as an astronaut would go perfectly with a blog post you're writing. You turn to the search engines for a free-to-use image, but you can't find one that matches your criteria. With the new Image Creator tool coming to Microsoft Bing, you can generate the exact image you need by inputting descriptive text.Image Creator is powered by DALL-E 2 image generator technology developed by OpenAI. Microsoft says Image Creator can assist searchers with creating images that don't exist yet.9. Google's Stance On The Use Of AI Images - Google's John Mueller and Lizzi Sassman discussed the topic of using AI Images on your site in Episode 48 of the Search Off The Record podcast. Although autogenerated text content is prohibited/limited for ranking in Google Search, surprisingly there was no similar prohibition or caveat discussed about AI generated images and ranking in Google Images.10. Google Updates Image Structured Data - Google has added three new structured data properties to be used with the ImageObject type in order to add support for credit, copyright and image creator information via structured data. Google's developer support changelog states:“Added support for image credits to the Image Metadata structured data documentation. Previously, you could only provide image credit information with IPTC photo metadata. When you specify image metadata, Google Images can show more details about the image, such as who the creator is, how people can use an image, and credit information. ”This is what the new structured data types are for, according to Schema.org: creditText - Text that can be used to credit person(s) and/or organization(s) associated with a published Creative Work. creator - The creator/author of this CreativeWork. This is the same as the Author property for CreativeWork. copyrightNotice - Text of a notice appropriate for describing the copyright aspects of this Creative Work, ideally indicating the owner of the copyright for the Work.” 11. Google's Advice On How to Write Good Alt Text - The purpose of alternative text (alt text) in images is to provide audiences with screen readers a way to understand the images. In Episode 48 of the Search Off The Record podcast, John Muller and Lizzi Sassman gave the following advice on how to write Good Alt text:“Imagine that you're reading the web page aloud over the phone to someone who needs to understand the page. This should help you decide what (if any) information or function the images have. If they appear to have no informative value and aren't links or buttons, it's probably safe to treat them as decorative.From an SEO point of view, my recommendation is always to provide context for the image as well in the alt text. So if you have a picture of a beach, don't just be like, ‘Oh, this is a photo of a beach.' But rather like, ‘This is the beach before the chemical spill happened.' And… Because it's very different context if someone is searching for a beach for a holiday, it's like, ‘Oh, I want to see a beautiful beach. I'll go there on vacation.' And if you notice, well actually, this is before the chemical spill happened, then it's like, ‘Well, maybe like that would lend itself to different kinds of Search queries.'Because ultimately, when you're talking about Image Search, it's not that people want an image, but rather they want information which is attached to that image. They want kind of to understand a specific topic to find some information. And that additional context is something that you can provide in the alt text. And that's something that they might be searching for. And if they're searching for it, then make it easy for them to find that.”12. 3 New Examples From Google On How To Write Product Reviews - There has been a lot of confusion about the types of sites that may be impacted by the product reviews algorithm updates. This algorithm was designed to look at sites that offer product reviews, not necessarily e-commerce sites that have reviews on the product listing pages. So Google has added three new examples to the top of the “how to write product reviews” help document, clarifying more types of sites that may be impacted by the product reviews algorithm updates. The 3 example are: An expert staff member of a merchant that guides shoppers between competing products. A blogger that provides independent opinions of products. An editorial staff member at a news or other publishing site. These examples provide additional guidance on what types of sites may be impacted by this set of algorithm updates. In short, it is about content where someone is doing a review of a product, either as a comparison or a deeper dive into a specific product. This can include merchant sites, shopper guides, bloggers that share their opinion, news or publishing sites doing reviews, and more.As Alan Kent of Google recently said on Twitter “a merchant's product page with user reviews is not considered a “product review page” in this context.”Google also recently clarified that structured data may help Google identify product review-type content, but it is one of many ways Google identifies such content. Danny Sullivan wrote, “as for structured data, it might help us better identify if something is a product review, but we do not solely depend on it.”13. Google Still Does Not Use HTML Lang Attribute - Google's John Mueller https://twitter.com/JohnMu/status/1577945097693532166re-confirmed that Google Search does not use the HTML lang attribute. He said many screen readers do and Microsoft Bing might use it as well, but Google Search still does not.This is a similar statement to what he said several years ago in a video response - “We don't use that at all. So we use the hreflang links if you have that if you have different language versions. But the language attribute within the HTML markup is something we don't use at all. We've found that this language markup is something that is almost always wrong. So we tend to ignore that.”14. Google: SEO Is A Long Game - We all know that ranking well for competitive terms in Google Search is not as easy, or even a fraction as easy, as it was two decades ago. This is because of many variables including but not limited to Google's algorithms getting better and there being a lot more competition.John Mueller of Google responded to a complaint about SEO being too hard for news businesses to even bother trying. The question was "is SEO dead? I mean, starting with a new website these days it is basically impossible to outrank high authority websites. So many high DA showing up in the SERP. What can we do with a new website?"John's response was solid, he said "If you mean it should be trivial to out-rank long-existing, legitimate businesses with some SEO tricks, then yes, that kind of SEO is long dead. It's not enough to throw some keywords on a page to make it useful to users."But that does not mean SEO is dead or you should give up and not try to start a competing business with others. You just need to take the time and effort to compete. The same logic applies to offline success as it does with online success. You can't just start a new brand of soda and expect to compete with Pepsi or Cola overnight, it takes time, resources, marketing and a good product.15. Google: Do This To Get New Content Indexed Quickly - Google's John Mueller said that pinging Google that your sitemap file has been updated can help Google index your new content quickly. He said it is simply Google practice to ping Google with when your sitemap file is updated.Of course, this does not guarantee indexing. Google still does not index everything, so just because you might ping Google about a new URL, it does not mean Google will index it.John Mueller wrote on Twitter "Pinging a sitemap is a bit different than just providing it in the robots.txt -- by pinging, you're actively flagging a change in the sitemap file. If you're keen on having new content indexed quickly, that's a good practice."According to Google developers guide "Google doesn't check a sitemap every time a site is crawled; a sitemap is checked only the first time that we notice it, and thereafter only when you ping us to let us know that it's changed. Alert Google about a sitemap only when it's new or updated; don't submit or ping unchanged sitemaps multiple times."To use the ping tool, send a GET request in your browser or the command line to google.com, specifying the full URL of the sitemap. Make sure that the sitemap file is accessible. E.g: https://www.google.com/ping?sitemap=FULL_URL_OF_SITEMAP16. Google Ads Launches Content Suitability Center - Google has launched a new content suitability center in Google Ads where you can manage your suitability settings for all campaigns on YouTube and the Google Display Network.Google wrote, “previously, managing suitability settings was done in multiple, segregated sections of Google Ads and the experience differed across Google platforms.” “This led to a time-consuming and cumbersome implementation process, along with misconceptions and misuse of the controls. While exclusions can be helpful tools, brands also want to be mindful of the types of content they choose to exclude. Over-exclusion can negatively impact your cost and reach. It can also unintentionally exclude great, brand-safe content or content relevant to diverse communities,” Google added.When you enter the new suitability center in Google Ads, you can now select one of the three inventory modes. Inventory modes “cater to your preferences for various sensitive themes, such as profanity, sexual suggestiveness and violence,” Google explained. You can fine-tune additional exclusions from that point. Once you have designated your preferences at the account level, Google Ads will now automatically apply these settings to your future campaigns.17. Google Ads Will Remove Some Content Targeting In YouTube Conversion Campaigns In 2023 - A major benefit of YouTube ads has been the powerful targeting options, many of which will now be removed early next year according to a Google Ads help article. The help article, “Optimize your Video campaign for more conversions” contains a content targeting section that recommends avoiding the addition of content targeting (by keywords, topics or placements) in campaigns.These content targeting options are beloved by many advertisers due to the granularity they provide. Placements could target YouTube Channels, specific videos, video lineups, URLs, Apps, or collections.With the current targeting, advertisers could match ads to channels/videos to deliver more customized messages to audiences. This change will effectively put an end to the hyper-targeting that made YouTube so appealing for ad dollars.Another major blow is the loss of keyword targeting on the self-proclaimed 2nd largest search engine in the world. The removal of query targeting on a (video) search engine hurts.While keywords on YouTube haven't historically been as powerful as traditional search, it has been a way for advertisers to help answer queries with their video content. There is no doubt that advertisers will need to get more creative in order to hit their target audience.Advertisers running YouTube content targeting campaigns that leverage keywords, topics or placements will have the targeting removed.If you are running ads using content targeting options, you should stay tuned to updates as those targeting settings will be automatically removed from your campaigns. With less targeting, you'll reach a larger audience and may spend more on less qualified users.

This week on Marketing O'Clock, Look(er) at me now! Google announced that they're unifying their BI products under the Looker umbrella, which means Data Studio is getting a rebrand. Then, Google Ads is putting your money where their mouth is with new tools to actually test their recommendations before applying them to your campaigns. Plus, keywords, and topics, and placements, goodbye! Google is removing some targeting options from YouTube campaigns. Subscribe to us on YouTube and fill out the form below to claim your free PMin Sticker! YouTube.marketingoclock.com - https://forms.gle/mkR53PXdsohTBgWL9 ------------------------------------------------------------------------------------------------------------------------------------------------------- Intro - 00:00 NEWS - 6:15 Take of the Week - 17:35 Lightning Round Paid - 19:40 Lightning Round Organic - 26:57 Lightning Round Social - 39:12 Working Hard or Hardly Working - 51:41 Cool Tool - 54:56 Must Read Marketing Article of the Week - 55:52 Shooting the Heck - 58:56

In this episode Cord & Einar discuss Google changing Data Studio to Google Looker Studio, SEO conferences, Kevin Indig's take on the latest Google updates, previously visited sitelink icons, and the trouble with timestamps.Sources Cited:Search Engine Roundtable: Google Data Studio Is Now Looker StudioSearch Engine Journal: The Best SEO Conferences In 2022-2023 (Virtual And In-Person)Kevin Indig: Google's latest updates leave no room for low-quality contentSearch Engine Roundtable: Google Tests Previously Visited Sitelinks IconsSearch Engine Roundtable: Google Still Working On Getting Timestamps Accurate In Search Results

Welcome to "Ask the Tech Coach," a podcast for Instructional Coaches and Technology Integration Specialists. In this episode of “https://www.teachercast.net/episodes/ask-the-tech-coach/ (Ask the Tech Coach),” Jeff welcomes Lisa Kuhn from Forward-Edge on the podcast to discuss the importance of Data Collection in the daily lives of an Instructional Coach. If you would like to be a part of future podcasts and share your thoughts, https://www.teachercast.net/podcastguestform (please contact the podcast).  We would love to have you join the show. Join the TeacherCast Tech Coaches Network! Are you a Tech Coach or looking to become one this year? Are you searching for support in your position? The https://www.teachercast.net/TCNForm (TeacherCast Tech Coaches Network), is a dynamic Professional Learning Network designed specifically for Tech Coaches and designed to provide weekly support for all Instructional Coaches. https://www.teachercast.net/TCNForm (Click Here to Join!) Question of the Week Our favorite part of recording a live podcast each week is participating in the great conversations that happen on our live chat, on social media, and in our comments section. This week's question is: In what ways should Instructional Coaches be collecting and using Data to support their programs? Get The Support You Need For Your Instructional Coaching Program Today! Are you searching for the best ways to support and grow your Instructional Coaching program this year?  The best way to do that is by joining the TeacherCast Instructional Coaches Network. By joining the TeacherCast Instructional Coaches Network, you will have access to: 3 Distinct Professional Learning Networks designed to help you grow for network other Coaches and Digital Learning Leaders Free Downloadable Templates and Coaching Resources that can be used in your district … tomorrow! Direct access to Jeff Bradbury and all of​f his “offline” content that he creates during the school year. Exclusive TeacherCast and “Ask the Tech Coach” podcast episodes directly relating to the questions that YOU ASK in our PLN groups. Weekly email check-ins to stay connected and discuss your Instructional Coaching program! Monthly invitations to TeacherCast Instructional Coaching Meetings and Webinars … and more! Join The TeacherCast Instructional Coaches Network Today! [convertkit form=3439843] Weekly Topic The importance of understanding the power of Data Collection as Instructional Coaches You either love it or hate it. Data, that is. What types of Data are important to keep Ways to upgrade your "thread count" for interacting with data. How to … and how NOT to keep and collect Data Who needs to see the data? How long should you keep it? When should you start to keep it? Where you should you display it? ISTE Presentations on Data collection and sharing https://docs.google.com/presentation/d/1hYwyMBP521R05lxIXVBYPkO1Ya8rw_tW-env3PuawVo/present (Data Between the Sheets link) How I became interested in Data Studio and sharing it with my teachers. Ways to upgrade your "thread count" for interacting with data. Examples of ways tech coaches might use data as well as ways they can encourage their teachers to use it! Links of Interest https://docs.google.com/presentation/d/1hYwyMBP521R05lxIXVBYPkO1Ya8rw_tW-env3PuawVo/present (Data Between the Sheets link) Podcast: https://www.teachercast.net/captivate-podcast/innovating-classrooms-through-conference-professional-development (Keeping Professional Development in Tune with the Current Educational Climate) Coaching Hashtags to Follow #EduCoachChat #ISTE2022 / ISTELIVE #FECamp22 #FEK12 Accounts to follow @EDUCoachNetwork @ForwardEdgeOH @RRCoachCast Links:...

A lot of search news this week and with Dave on the road in meetings Kristine Shachinger from Sites Without Walls in Las Vegas sat in with Jim to cover it. We started talking about Google's well-named new multi-analytic tag, The Google Tag, and how to properly apply it. Support this podcast at — https://redcircle.com/webcology/donationsAdvertising Inquiries: https://redcircle.com/brandsPrivacy & Opt-Out: https://redcircle.com/privacy

In this supper club episode of Syntax, Wes and Scott talk with Pokey Rule about using his voice to code, and the current state of voice coding software. Stackoverflow Podcast - Sponsor For over a dozen years, the Stack Overflow Podcast has been exploring what it means to be a developer, and how the art and practice of software programming is changing our world. Hosted by Ben Popper, Cassidy Williams, and Ceora Ford, the Stack Overflow Podcast is your home for all things code. Listen to new episodes twice a week, wherever you get your podcasts. directus - Sponsor Directus is an open-source data platform that instantly layers on top of any SQL database. Our Data Engine empowers engineers with dynamic REST+GraphQL APIs, workflow automation, built-in auth, caching, and asset transformations. And the included Data Studio democratizes your database, allowing even non-technical users to browse, manage, and visualize database content through a no-code data collaboration app. Get started in minutes with a free Directus Community Cloud project. Show Notes 00:33 Welcome 01:35 Guest introduction Con 2021 - Cursorless: keyboards and mice are sooo last year!! by Pokey Rule Emily Shea 05:12 How does coding with your voice work? Talon Voice Cursorless Talon 09:45 How do you handle triggering wrong words? 11:41 Sponsor: The Stack Overflow Podcast 12:26 Example of voice coding Parrot 14:21 What are the noises you make for? 24:29 Working on multiple lines at the same time 27:37 How do you decide where the hats go? 31:18 Sponsor: directus 32:59 What is the community of users like for this? Tree Sitter “Incremental, zero-config Code Nav using stack graphs” by Douglas Creager 35:20 Does eye tracking work? 36:48 What kind of mic do you use? DPA Microphone The Voice Book 39:25 Supper Club questions Dark Abyss VS Code theme Kinesis Freestyle 2 Charybdis Nano keyboard Nexstand Arxiv Sanity Subvocal Recognition Imagen Research Midjourney 54:11 ××× SIIIIICK ××× PIIIICKS ××× ××× SIIIIICK ××× PIIIICKS ××× Git Imerge Shameless Plugs Scott: LevelUp Tutorials Wes: Wes Bos Tutorials Pokey: YouTube channel, Sponsor Pokey on GitHub Tweet us your tasty treats Scott's Instagram LevelUpTutorials Instagram Wes' Instagram Wes' Twitter Wes' Facebook Scott's Twitter Make sure to include @SyntaxFM in your tweets

Show Resources Here were the resources we covered in the episode: Data Studio dashboard that Anna Shutko and AJ created together @AnnaShutko on twitter Marketing Analytics Show LinkedIN: Send DM and posting NEW LinkedIn Learning course about LinkedIn Ads by AJ Wilcox Contact us at Podcast@B2Linked.com with ideas for what you'd like AJ to cover.   Show Transcript Have you heard of Supermetrics? If you're a LinkedIn advertiser, it's your new best friend. We're covering the capabilities on this week's episode of the LinkedIn Ads Show. Welcome to the LinkedIn Ads Show. Here's your host, AJ Wilcox. AJ Wilcox Hey there LinkedIn Ads fanatics. So we're highlighting another tool today in the LinkedIn advertisers arsenal. We're discussing a tool that I've been using now for years. It's absolutely indispensable for our team, because we're managing so many different accounts. And we're dealing with so much data. That tool is called Super metrics. And it's a very simple way of getting all of your ads data into a spreadsheet, or visualization tool for better reporting and analysis. I'm excited to welcome Anna Shutko from Supermetrics to answer my questions, and give you the inside scoop on what's coming. Anna and I go way back. And we've even collaborated on a free dashboard for LinkedIn advertisers, that you'll all get here in the show notes and I think you'll enjoy it. Without further ado, let's jump into the interview. Okay, I'm really excited here to have Anna Shutko from Supermetrics. She is the Brand Strategist at Supermetrics. She's also host of the awesome podcast, The Marketing Analytics Show, make sure you go and subscribe to that right now,if you're not already. She is based in Helsinki, Finland. And she was number seven on the Supermetrics team. She has been there over five and a half years she is one of the OGs for sure. She's also an avid cyclist and skier. Anna, I'm so excited to have you on the show. We've been friends for a long time. Thanks so much for joining us. Anna Shutko 1:42 I know, right?! Thank you so so much for having me. I'm super excited to be on the show. AJ Wilcox 1:49 I'm just as excited to have you I have so many great questions for you. Well, I'm the host. And so if I say that they're great, it's a little bit biased, but didn't really have some questions I think are gonna be really good for you. And for those of us who are listening, tell us anything about yourself that you want anything I may not have covered in your intro. Anna Shutko 2:05 Yeah, sure. So I think you nailed my bio. So I did a piece of furniture with Supermetrics. As I like to joke about it. I've been at the company for quite a while now more than five years. Wow. It's crazy when you think about it. So what people usually find interesting because I sometimes go in client calls and then when my colleagues introduce me, they're like, yeah, she's been here with us for such a long time. And people who knows Supermetrics are very, very surprised, because I guess not so many people like me have been with the company for a long time. We were a tiny team back then. Now we've grown fantastically. And we've grown so fast. Now we're over 250 people. It's crazy. So yeah, it's been a wild ride. And yeah, like I said, I've been moving between different areas of marketing between different departments. So I started as a growth marketer, then I went on to become a product marketing manager. I was also product manager, I was managing the relays and different connectors. And then I moved on to brand marketing. And now I'm super excited about my new role. So I'm building the brand measurement system, and I'm pretty sure we're gonna hear more about it. But yeah, that's a little bit about me. So many different areas. It's super exciting to see the company grow. It's super exciting to change all these different roles and learn more about connectors, including or favorite LinkedIn connectors. So that's a bit of a thing. AJ Wilcox 3:39 Oh, beautiful. And I am a fan of the LinkedIn connectors for sure. So thank you for your great work on those. Let's go ahead and start in here on the first question. So for those who are not already familiar with Supermetrics, what are the challenges that Supermetrics solve. Why is Supermetrics originally in business? Anna Shutko 3:58 Yeah, definitely. So Supermetrics essentially, is a data pipeline tool, as I like to call it. So we transfer data from a variety of different data sources or connectors, how we call them interchangeably. And these are LinkedIn Ads, Facebook Ads, Google Analytics, HubSpot, e-commerce platforms like Shopify. We cover over 80 different platforms. And like I said, literally any most popular and big marketing platform, you name it. And we transfer all this data to set up different data destinations. So we have sub categorized them into spreadsheets. So these are your Google Sheets and your Excel. Then there are different data visualization tools like Google Data Studio, or Power BI, Tableau, so data analytics/data visualization tools. And the third group is our data warehousing clusters. So we transfer data to different data warehouses like Azure, Google BigQuery, etc., etc., etc., And data links so you can combine your all your data in one place and store it securely. So that's a little bit about Supermetrics. So because we cover a lot of data destinations, and we connect to many different platforms and transfer the data, we cover a variety of different scenarios here. And this is actually historically has been the challenging part within product marketing, which also makes it very, very interesting that because we have so many products, we can help you cover multiple scenarios of what you want to do with your data. So you can have your reporting and dashboarding. So these are your client facing reports for agencies. And if you're an in house marketer, you can create your so called boss pacing reports, you have to create within your team. So these can be done in tools like Google Sheets, there are lots of writers who take advantage of Google Sheets and Excel and the formulas they can create there. And also, of course, do the visualization tools like Google Data Studio, super easy to add connectors there, it's super easy to create beautiful reports there and share them with your team. Then there are some cases of ad hoc analyses. And these are usually related to the questions you need to answer right now. So for example, why is my LinkedIn Ad spend so high and I have not seen the results? Or why does target audience A perform better than target audience B? So if you have this question and you really want to quickly acquire your data to answer the specific question, Supermetrics for Google Sheets can be a really good tool because we have the sideboard technology where you can select the metrics and dimensions you want to pick, and then it will pull the data into the spreadsheet, so that you can quickly answer very pressing questions. And another use case we have is the data warehousing use case where you can tie data across multiple different sources. So instead of just looking at one or two, or three or five data sources, you can create really complex models. But in order to create these models, you need to store your data in one place in order to join all this data. So here, you can pull all the data into your Google big query and then visualize it with a helpful view. But you can also perform the necessary data transformations within this data warehouse. So for example, you can compare the performance of your ad networks such as Google versus Facebook, again, you can segment and test different audiences, you can join data in the way you want to see sequel. And also you can report on the whole user journey. So for example, your clients started by clicking on your LinkedIn ads campaign, and they went to your website. And then you capture their website behavior with Google Analytics, maybe some of this data is coming from your CRM. And then with the help of a data warehouse, you can store all these data and then inquiry to connect the pieces together and see the whole user journey. So here are our most popular use cases. AJ Wilcox 8:20 Okay, so just out of curiosity for being able to track the whole buyer journey. What sort of software or tools do you need in place in order to I guess, get that journey across all the different platforms? Is that requiring that they're in a CRM or something that's already natively tracking all of that? Anna Shutko 8:36 Yeah, so usually depends on the company. Some companies might not necessarily have the budget or the need for a CRM. Of course, having a CRM is ideal. So if you have something like HubSpot, or it's Salesforce, it's really, really good also because their API's are so robust. They allow you to create custom dimensions and custom metrics to track your unique use cases. So for example, your users have, like I said, clicked on your LinkedIn Ads, and then they land on a website. And then they have to fill in a form. And the form might be somewhere, like on a different website, maybe it's an event and you're hosting a registration on Eventbrite, say for example. So when they put their data into Eventbrite or somewhere else, you also need to somehow capture this data within your CRM. So an alternative solution here could be to build a web page there where they would fill all their details. And then you can store all this data within the server ad. And then at the same time, you can combine it with the data coming from LinkedIn Ads. So it really depends. I would recommend starting with a combination of like ad networks, and reporting on that data and then combining it with data from Google Analytics. This can be the easiest when you're using a CRM, but at the same time, you can already start seeing a better overview of your user journey, and then connect to your CRM and then build on top these custom goals and metrics to create more of a reporting system. AJ Wilcox 10:16 Very cool. This is a topic that's been really top of mind for me, as I'm thinking about, as cookie apocalypse continues, and we losing our dependence on third party cookies. How effective are we as marketers going to be being able to track someone across the whole user journey when we know that, that cookies disappearing? This is fascinating to me So thanks for helping us out with that. So those are the problems that Supermetrics solves. Why is Supermetrics in such a good position to solve this problem? Why not, you know, Google themselves, just replace you with having a simple tool that just spits out their data. Same thing with LinkedIn? Like, why is Supermetrics solving this problem and not anyone else? Anna Shutko 10:57 Yeah, that's definitely a really, really good question. I can talk about this for hours. But we only have a limited amount of time, I guess. So first of all, Google is one of our partners. So Google, of course, is a massive, massive company and they have an amazing set of tools, but they are not the whole ecosystem. So there are lots of other players like Facebook, like LinkedIn, like Twitter, like HubSpot. And they also provide a set of really, really good API's, which allow you to export the data on the campaigns that are run. So super metrics, like mentioned, helps combine all this data and then we push this data to a number of different destinations. These are not just Google Sheets, these are Excel, for example. So for example, if your company is using Microsoft and you are required to use the office space, then Supermetrics can be a real really good tool because we can help push this data to your Excel desktop, say you set up your inquiries, and then you go offline completely. And then you can analyze your data using Excel. So like I said, we don't only connect to Google platforms. We help connect different players within the ecosystem together. And another good example is our Data Studio product. So Google Data Studio is a free data visualization tool for those of you who do not know. And they have native integrations with Google Analytics, Google Ads and other Google platforms, that is true. But for example, many marketers use Supermetrics to get data from Facebook or LinkedIn to the same data visualization tool. And if you're running ads on multiple different platforms, it would be a little bit silly to just analyze your Google Ads data without analyzing what you're doing on your LinkedIn as a platform, kind of like together. So we help marketers gain a very holistic view of their performance in the tools they already know, in the tools they already can use in the tools they already know how to use. So for example, if you know how to use Google Sheets, you can just install Supermetrics add on. And then you can continue using your favorite tool without this learning curve without the need to learn a new tool, and just query the data from the platform you want, say LinkedIn Ads, and just create the reports there. Or you can use these tools in combination. So we have a native Data Studio connector for our required products, for example, you've combined the data from multiple different sources in your inquiry project, and then you want to visualize this data. So you can use our Data Studio connector to do this. And the names of metrics and dimensions will have clear descriptions to to be very easy for you to understand what kind of metric you're visualizing, and how you can create a better report using all these tools together. AJ Wilcox 13:54 Oh, I like it. Alright, thanks for sharing that. I definitely think I'm of the same opinion you are that any of the other networks or channels could easily come out with a product that allows easier access to the data they have. But the Supermetrics advantage here is just being able to aggregate from all of these different connectors, regardless of whether or not any of them come out with an easier way for us to do it ourselves. Tell us about your relationship with LinkedIn, as well as the other platforms. What do you get from that partnership? How long have you been partners, that kind of thing? Anna Shutko 14:26 Yeah, sure, definitely. So with LinkedIn, we've been partners for quite some time. And there are many, many marketers, 1000s of marketers, is what we're talking about that reported their LinkedIn Ads. And then concrete budget pacing reports with Supermetrics. So we've recently demoed our product to your team. And like I said, we have really, really good and close collaboration there. And in addition to LinkedIn, we partner with Stack Adapt, HubSpot, Google, like I mentioned, AdRoll and many, many other data source and data destination companies. So when we partner with a company, we try to create the best possible value for the end user, of course. So we love creating templates for Data Studio especially. We've created some with the HubSpot. So we sit together with their product managers and think, Okay, what kind of metrics would be great to visualize for users. And we create completely free reporting templates with all the needed metrics and dimensions that our user can use as they are, or they can just take them as a blueprint for their own reports, they can tweak the metrics, they can tweak dimensions they can do that they want. And it's really amazing to partner with these companies, because we can combine the best of both both worlds so to say, so we have the reporting and analytics and data consolidation expertise, and the platform's bring their own know how, their knowledge to the table. So AJ you and I created this really, really good LinkedIn Ads dashboard. And this is one very good example of how your know how or some platform managers know how can be combined with Supermetrics know how. AJ Wilcox 16:20 Which is beautiful, we are going to link to that dashboard down below in the show notes so everyone can get access to it. But, Anna I'm so glad you brought this up. Because this has been a couple years ago, or a few years ago now. But we worked for about six months, I think on creating this dashboard, we call it the ultimate LinkedIn Ads dashboard. It's in Data Studio, it's totally free, like you mentioned, and anyone out there can go and get really complex analysis of their LinkedIn Ads. And that was because of you and I working so hard on that. I'm a big fan, I hope everyone goes and grabs that. Just to make it clear as to what Supermetrics is doing for LinkedIn advertisers. I mean, it's it's cool that you guys aggregate all of the different data and channels together into one spot. I think marketers who are responsible for more than one channel would love that. But for LinkedIn, specifically, you advertisers who are listening, you know how hard it is to get data out of LinkedIn. If every time you want to do a report, you have to go and click the export feature inside of campaign manager, and then put it into Excel, and then you know, do whatever formatting changes, you need to do, create pivot tables, then all of a sudden, all of that data is it's a snapshot of it, you can't do anything else with it. And so the next time your boss asks for a report, you're going and doing it again. What Supermetrics does is it will take, even on a schedule, this is my favorite part about it, you can say I want this data going into Excel or into Google Sheets, and I want it every day at 2am. I want it to go pull the next day's data. And then it's always there any report any pivot table that you build, all you have to do is just refresh. And now you'd never have to build that same report ever again. So, so cool. We'll talk about more of my favorite features of Supermetrics here a little bit later. But I just wanted everyone to know like, this is why it's so valuable for you. This is why I'm doing this tool spotlight on Supermetrics. Because there just is no other way to do with LinkedIn, what Supermetrics does. So I want to hear from you. What are the capabilities of Supermetrics, especially as it pertains to LinkedIn advertisers? Anna Shutko 18:28 Yeah, definitely. So I've mentioned a couple of capabilities. And like I said, because we have a product umbrella, it allows us to help customers solve multiple reporting and reporting related issues. So we have your ad hoc reporting, where we can acquire the data on the fly. And this is your Google Sheets, Excel products. We help with the data consolidation. These are your data warehousing products, building beautiful data visualizations, or you can have little exploration in Looker or Tableau or Power BI. Another really interesting thing I'd like to highlight here is that as you know, LinkedIn ads API constantly changes will always constantly change. LinkedIn is always coming up with new features. And he was right, you mentioned that it's challenging to export the data out of LinkedIn Ads. And this is something we're really help with, but it will also help you export this data in the right format. And we can help you create reports with really, really high data granularity. So what it means in practice is that you can test and report on many different pieces of a LinkedIn Ads campaign audiences. You have your campaign types, creatives, objectives, and you can break down your campaign into different pieces, pass these pieces individually or perform an AB test, and then make really, really smart optimizations. So this is one thing that I really, really like and would like to highlight here. And typically, we help achieve this with our Google Sheets product. And one very precise example is, again, the dashboard AJ and I have built. Belt. So you can report on not one, but four different types of spend. So there are formulas that help you calculate your total spend, projected spend, goal spend, as in the amount of you have to spend without under over spending. And then the cumulative spend to something you've spent overall. And here, we've taken one metric, which is spend, and then your budget goal, and then transformed into four different kinds of spend. And this brings me to my earlier point about data granularity, you can report on really granular data. So you can break down your spend by day, you know, Google Sheet, then create these calculations to have these four different types of spends. And then think about it holistically for not one, but four different viewpoints. And then create your budget pacer that can help you allocate budgets. Because LinkedIn Ads is a very costly platform, as we all know. So having these different types of spend calculating these different types of spend is really, really helpful. And the same thing goes with audiences and can campaign types. You can break all these spend down by multiple different dimensions, like what kind of audience brings the best ROI, what kind of campaign type performs better than the other campaign types. What kind of creative helps me get more clicks? So you can get really, really nerdy with your data. And this is something I really, really love. And another beautiful thing is that you can then combine this data. So if you don't want to look at it in a very granular way, you can also combine all this data in Google Data Studio report. And again, this is something that we've tried and tested, and it worked. So after you've analyzed all these types of spend, you can push them into the to see the dashboard to see bigger trends. So for example, you've noticed that your projected spend during this month is higher than your projected spend over the last couple of months. And you can start thinking, why you can understand what might be like bigger drivers behind this change. And in addition to this, you can add all different types of other data. For example, you can add your data on AB testing to see which campaigns have performed better historically. Or you can even add your data from LinkedIn Pages. Because if you use LinkedIn Ads and LinkedIn Pages in combination with can be a very, very powerful duo. It can help you uncover many sides on your audience. So there are a lot of different ways in which Supermetrics can help you slice and dice your LinkedIn Ads data. But also create really, really good reports that can help you get a general overview. AJ Wilcox 23:02 I love this, there's no data that you can get from campaign manager that you can't get within Supermetrics. And you own the data, you get to do whatever you want with it. So just like what Anna was talking about, with the ability to break down your spend by ad type and by audience, all these things are fantastic. But then you realize you could have a Google sheet or a page in your Data Studio dashboard that allows you to see the AB tests you're running, and another page that might show you just your budget, like what Anna was talking about. And another one that could be just your metrics at a glance like, hey, how are my general click through rates, or my general conversion rates, all of this you can do, it's super easy. And just in the dashboard that Anna and I built for you here a couple years ago, all of that is like already set up for you. So very, very cool. Anything else you want to share about the capabilities that we should go over? Anna Shutko 23:58 Yeah, definitely. Also, we have real really nice use cases. There is a tab on our website where you can read more about what other clients are doing. And I know it's useful for a fact because our customer success managers have found it very useful. So you can also learn from other people and you can check what some other guys are doing with their Facebook Ads campaign and apply the same ideas to your LinkedIn Ads reporting, which I think is super super exciting, because understand and basically steal ideas in the best possible way. Understand how others are running their reports. Another really, really good feature is the automated way of reporting. For example, once you've set your LinkedIn Ads budget tracker in spreadsheet, you can say, hey, I want to update my data and if my spend increases, and if it crosses you know the threshold to XYZ amount, send me an email. There is literally no human error unless you set up the query correctly. So you can easily get the data you want, whenever you want. And you can also set up rules and get customized alerts whenever something goes wrong. So you don't need to monitor your ad campaign on a daily basis. You don't need to worry about this, you set the report once, and then you forget about it. And then you can think about creatives, audience testing, whatever you want, whatever is on your table. So that allows you to focus on more interesting problems, which has always been the case for me, for example, when I'm using Supermetrics, I noticed that every single time I'm able to automate something, I can use this time on something else, which is something more exciting. And also, you can report in your campaigns faster, which of course, is a great thing, since you save a lot of time and then can spend it on something else. And yeah, like I said, we help cover pretty much a variety of reporting use cases, we also have a template gallery. So you can check it out on Supermetrics.com. We have our Google Sheets template gallery, we have our Data Studio template gallery, and we're gonna link to the dashboard AJ and I created so you can see how you can visualize your LinkedIn Ads data. AJ Wilcox 26:17 Oh, I love it. Thanks for sharing those. So what are some of the results that your customers have seen for their LinkedIn Ads because they are using Supermetrics? Anna Shutko 26:26 Yeah, definitely. So first of all, they are seeing improved targeting. Like I mentioned, once are able to really select your data in a variety of different ways. You can dig deeper into it, and then understand what exactly is working and what exactly is not working. So imagine, if you're diagnosing a patient, and you have only one, two, or maybe tools, that's not really going to give you enough information into what's wrong. And a campaign cannot really tell you what's wrong about it. So once you have a whole tool set being maybe Supermetrics for Google Sheets, data warehousing, etc, etc. You can slice and dice your data in a variety of different ways. Now you can diagnose your patient much better. You can pinpoint exactly what's wrong, whether it's the campaign type, or the spend, or the audience, or maybe creative, or maybe something else. And then you can really, really understand how exactly we're going to go about this. So of course, all that leads to increase ROI, time saved, and improved communication. What we've seen within the teams, because instead of arguing, you know, oh, you've adjusted this spend in a wrong way, no we should have increased these bids, you have much more intelligent conversations. And hopefully your team dynamic improves, because you can just look at the numbers. And this is something we also use internally. We just pull up a dashboard, we just check the numbers and the numbers never lie, and then they tell you the direction you need to take. And we just go from there. So it's very, very cool to use data to your advantage. AJ Wilcox 28:16 Amen to that. And how much does Supermetrics cost for these advertisers who want to use it for their LinkedIn campaigns and haven't used it before? Anna Shutko 28:24 Yeah, definitely. So it really depends on the product. So I don't want to provide inaccurate information. So the best way to check it is to go to Supetmetrics.com and then check the data destinations you want to use. And then check how you want to report on your LinkedIn Ads campaigns. So the price for Google Sheets is of course different from the price you are going to have for your data warehouse. But if you need a custom solution, our sales team is of course happy to help you. So you can select not just LinkedIn Ads, but a variety of different connectors. And this is what I normally would recommend. So don't just pick LinkedIn Ads, you can pick Google Analytics, or LinkedIn Ads, and LinkedIn Pages, for example. You can combine these data with our ad data plus google analytics connector for our Google Data Studio destination. There is a massive combination, all different data sources and the different data destinations you can potentially have so the price of course depends on that. And also, the pricing is relatively simple. You know, it might not sound as simple when I'm trying to describe it. But once you pick your destination, once you pick your connectors, you just pick the number of your accounts and how often you want to refresh your data. But that's about it. Once you know all these factors, once you understand which one wants to go with, then it's pretty simple. AJ Wilcox 29:54 And it is really reasonably priced. I've been using the tool now for years. Absolutely love. That's why I'm doing a tool spotlight on Supermetrics when there are plenty of other LinkedIn tools that I'm probably not going to cover. So thanks for providing such an awesome tool at good pricing. All right, here's a quick sponsor break, and then we'll dive right back in the LinkedIn Speaker 4 30:13 The LinkedIn Ads Show is proudly brought to you by B2Linked. com, the LinkedIn Ads experts. AJ Wilcox 30:22 If the performance of your LinkedIn Ads is important to you, B2Linked is the partner agency you'll want to work with. We've spent over $150 million on LinkedIn Ads, and no one outperforms us on getting you the lowest cost per lead and the utmost scale. We're official LinkedIn partners, and you'll deal only with LinkedIn Ads experts from day one. Fill out the contact form on any page of B2Linked.com to chat about your campaigns, and we'd absolutely love the opportunity to get to work with you. AJ Wilcox 30:51 Alright, let's jump right back into the interview. Let me ask you, we've talked a lot about the capabilities of the platform and the company. What's your favorite feature of Supermetrics? Like, you're obviously a marketer yourself and a dang good one? What is the most helpful aspect of it to you? Anna Shutko 31:06 Yeah, sure. So first of all, I really, really love that we collaborate with our data destination partners very closely. And that allows us to develop product which sits within a data destination so to say, in most cases. Not all our products need data destinations, but most do. And I'm talking about all our Google Data Studio we co developed together with Google's team, working very closely with their engineers. So you can go to Google Data Studio, you can create any kind of report with Supermetrics, without ever leaving Google Data Studio. And this is amazing. You don't have to go from one page to another page to the next page. You just go to your Data Studio, you select LinkedIn Ads as a connector, where you connect it to your dashboard. And that's it. You can basically query data and create beautiful reports. So the experience is very, very intuitive. It's very smooth. And same thing applies to our Excel and Google Sheet product. So we have a sidebar, where you can take metrics and dimensions you want to pull. And then some magic happens here and your data just appears within a spreadsheet. So the adoption is very, very fast. I remember when I first saw our Google Sheets product, I fell in love it it instant, and it happened more than five years ago. But it's still remember it because the experience was so good, even back then. And another really, really useful feature is perhaps the ability to pull data from and report on multiple accounts easily. So I'm not talking about data sources here. But accounts, for example, you are an agency, and you're running campaigns on 50,60, 70, 100, different LinkedIn Ads accounts. And you have a really, really big client. And then they have 70 accounts. And imagine connecting these accounts one by one to your dashboard would be a complete nightmare. With Supermetrics, you can just select them all at once or then pull them all into the same spreadsheet all into one database, to a one to one Data Studio report. And then with the drop down selection, you can just take which accounts you want to see date the data from and this data will appear. It's very, very, very helpful for our agency friends over there. And the same thing happens with all the other data sources. So Google's accounts and if you want to combine your LinkedIn Ads with Google Analytics data, it's very, very easy to report on. AJ Wilcox 33:55 Very nice, I'll tell you, I have several things that I absolutely love about Super metrics. I've played with a lot inside of Data Studio. And what I love is number one, it's fast. When you're in Data Studio, and you're using Supermetrics as your data source, the pages just load nearly instantly. It's super, super fast. It's also really easy to use, like I use LinkedIn API. And I know what that's like to be looking at these metrics on the back end that have a name, and you're going I don't know what that name is. Supermetrics calls them things like every column, every source, every metric, every KPI, they're all named in ways that even just a very, very basic marketer, like brand new to the industry could still understand what it was they were building. If you've ever tried to take data directly from LinkedIn. So you export it to a CSV, and then you try to put that into Data Studio. What you'll notice is the columns aren't of the right data types, and you have to keep going into your spreadsheet and making changes when you use Data Studio or Google Sheets, but especially Data Studio with the Supermetrics connector, everything already comes in and exactly the right data types, you're never going to have to worry about, oh, my dates aren't showing up because Excel didn't recognize it was a date. And then Data Studio didn't recognize that it was either, you never have to worry about that. Something else that I love, let's say you go into campaign manager, you do an export to CSV. And it's a, let's say, an ADS report or campaigns report, when you look at that column of like, click through rate or cost per click, as soon as you try to combine that or do some kind of like an average, those averages don't mean anything. If you try to do an average of a whole bunch of percentages, it will make some kind of an average, but it'll be wrong. And Supermetrics fixes all those like every time we export something with Supermetrics. All of the columns are accurate all the time in a way that they wouldn't be from LinkedIn directly. I'll also mention one more thing, which is there was a metric that I wanted to see inside of super metrics that I knew LinkedIn had access to it was a new one. And I mentioned something to you, Anna. And you said, Oh, let me message the engineering team. And I want to say it was within like, a couple hours, you've messaged me back and said, Hey, check it, we should have that data available now. And so it's fast, like Supermetrics is always on top of new changes. Anna Shutko 36:23 I think we should definitely hire you, AJ, if you're ready to move to Helsinki, just know, just let me know, I have a spot for you on the team. AJ Wilcox 36:32 I am very good in cold weather. So we should talk about it. Let me ask what's coming up in the future that you're super excited about with Supermetrics? Anna Shutko 36:40 Yeah, so there are so many things that are coming up. First of all, we have multiple new data warehousing destinations for all of you data nerds out there. So you can store your LinkedIn Ads data in more places. And also, we are always developing our data sources, and then pattern paths for now. So you can then combine this one connects data with a variety of data sources. And that's been on the product side. I am always very excited about the new product developments. But also, I'm very exciting about The Marketing Analytics Show. This is the podcast that I host. We're gonna interview really, really cool guest. You're going to hear more about the first party data. So something AJ and I briefly talked about at the beginning of this podcast, and how you can tag your data correctly before you cleanse your data warehouse, and many, many other cool topics. And every single time I talk to these guests on super, super excited because the share very interesting viewpoint about this industry. AJ Wilcox 37:52 I love it. I'm a subscriber of the podcast, make sure you all go back and listen to episode four, because yours truly was on there. Just kidding. You don't have to listen to that particular episode, go listen to something that you don't already know super well. If you're listening to the show, you probably get everything that we talked about. Something that you mentioned, that I think is so helpful is that if you're making all of your decisions, from the data that you get directly from LinkedIn, you will find that you're making the wrong decisions. What I mean by that is like the data you get from LinkedIn on things like even conversions, leads, means next to nothing, until you find out whether those are qualified leads, whether those leads are actually turning into sales. And so Anna, what you mentioned that is so cool is this direction of moving into the data warehousing solutions. So now you have access to what LinkedIn has. But then with other CRMs and other data partners and data warehouses, you're able to then combine that with the data that you can find only from your CRM, or other sources that can report to you on number of qualified leads and other elements of lead quality, how many proposals sent, closed deals, what the deal closed for, and you can actually report on what really matters. So that makes me really excited. So final question. This might be something you've already answered. But what are you most excited about either personally or professionally, yourself? Anna Shutko 39:15 Yeah, sure. I am excited about a few things in general. And like mentioned, there have been really, really exciting product developments at Supermetrics. But one thing I wanted to pinpoint is that right now I'm building the brand measurement system. And this is basically a series of data transformations and dashboards that help combine all the data about our brand and how it's performing. And I'd like to say we drink our own champagne, it's a Supermetrics. So of course, we're using Supermetrics to consolidate all this data. So it's really exciting to work in this project. And it's really exciting to see how our product works from the client perspective. And of course, whenever I'm ready, I'm happy to share all the insights and all the learnings. AJ Wilcox 40:09 Wonderful. Well, as you're coming out with that stuff, how can people follow you? How can people obviously I would say, make sure you subscribe to The Marketing Analytics Show. But how else can people find out this stuff as you're releasing it? Anna Shutko 40:21 Yeah, sure. So I am on Twitter. So it's @AnnaShutko on Twitter. And you can just follow me there. I promise you, I really promise that I will post more and I will post more updates on the podcast and insights that are learned after building this system. And another way to connect with me is to follow me on LinkedIn, you can connect with me there, you can send me a DM and I will also be posting some of the updates there. AJ Wilcox 40:54 Oh, I love it. Okay, we'll put all those links here in the show notes below. So make sure you do follow Anna, reach out to her if you have questions. Anna, thanks so much for coming on the show. I think it's very obvious that I'm a huge Supermetrics fan. I really just appreciate our collaboration in the past, and everything you've shared. Is there anything else that you want to share with us before we jump off? Anna Shutko 41:15 Yeah, sure. Thank you so much, AJ, for inviting me, it was a very, very interesting conversation, great questions. And I love being interviewed by fellow podcast host. So one more thing before we leave. So I'll ask AJ to link the article we co-wrote in the show notes. So you can follow how exactly we came up with these four different types of spend you can monitor, and how you can report on AB test for your LinkedIn Ads campaign, there was a lot of good stuff there. So also, this article contains really practical instructions and how you can connect your LinkedIn Ads, and then create this superpower spreadsheet and then connect that spreadsheet to Data Studio dashboards so you can also use different charts and visualizations. So not only will you learn how to approach LinkedIn Ad spend reporting. You will also learn a bunch of different tools, hopefully. So check it out. I really hope you enjoy it. If you have any questions, don't hesitate to reach out to us. And I'm really, really happy to be part of this LinkedIn Ads community. AJ Wilcox 42:27 Wonderful. Well, thanks, Anna. I will definitely link to all of that. And just a big shout out to you everything that you're building is awesome for us marketers. So a huge thank you from the LinkedIn Ads community. Anna Shutko 42:37 Thank you so much. I'm so happy you are enjoying. AJ Wilcox 42:39 All right, I've got the episode resources for you coming right up. So stick around Speaker 4 42:49 Thank you for listening to the LinkedIn Ads Show. Hungry for more AJ Wilcox, take it away. AJ Wilcox 43:00 Okay, like we talked about during the show, I have the Data Studio dashboard that Anna Shutko and I created together. So check the link there in the show notes, you'll absolutely love that I'm sure. There's a killer template for budget tracking inside of Google Sheets, as well as the full Data Studio dashboard that we created together. You'll also see the link to Anna Shutko on Twitter, as well as her LinkedIn profile. So as she said, send her a DM, follow her, connect with her all that good stuff. She's also the host of The Marketing Analytics Show so you will see a link to that. Because all of you are podcast listeners, obviously, you'll definitely want to go check that out and get subscribed. Any of you who are looking to learn more about LinkedIn Ads, or maybe you have a colleague that you're training or something like that, check out the course that I did with LinkedIn on LinkedIn Learning. It's by far the least expensive and the best quality training out there and it's next to no dollars. It's pretty cheap compared to any other training. You'll enjoy it. Please do look down whatever podcast player you're listening on and make sure you hit that subscribe button. We'd love to have you back here next week. Also, please rate and review the podcast. Honestly, I say it way too much. But it really means a lot. It makes a difference to me. So please, please, please go leave us a review. We'd love that with any suggestions, questions, feedback, anything like that. Reach out to us at Podcast@B2Linked.com. And with that being said, we'll see you back here next week, cheering you on in your LinkedIn Ads initiatives.

This week Dan and Dara talk more about the announcement from Google on sunsetting Universal Analytics in 2023. They discuss what the timeframes really mean, and what you'd need to be doing at each stage. The key takeaway is DO NOT PANIC! Just focus on getting GA4 setup up to a good level before 1st July 2022, and we can think about how to get at the UA data after 1st July 2023. The PIVOT framework to help get GA4 set up - https://bit.ly/38w00Vx. And check out episode #7 for the deep-dive of PIVOT with the author George Mendham. Details on the Data Studio update to have up to 50,000 rows in tables - https://bit.ly/3NMljCn. Simo's 4 recommended Custom Dimensions to be able to pull out the hit-level data from UA (from 2015... damn I feel old) - https://bit.ly/3sEwNPI. They also mention a few tool such as Funnel (https://bit.ly/3uOUy7q), Stitch (https://bit.ly/3u81MED) and Fivetran (https://bit.ly/3x2z5dZ) to help aid in transferring data out of your analytics and marketing tools into a data warehouse or dashboard. Check out on LinkedIn: - Dan - https://bit.ly/3JQKHEb - Dara - https://bit.ly/3vzV0bO - Measurelab - https://bit.ly/3Ka513y Music from Confidential, check out more of their lofi beats on Spotify at https://spoti.fi/3JnEdg6 and on Instagram at https://bit.ly/3u3skWp. Please leave a rating and review in the places one leaves ratings and reviews. If you want to join Dan and Dara on the podcast and talk about something in the analytics industry you have an opinion about (or just want to suggest a topic for them to chit-chat about), email podcast@measurelab.co.uk or find them on LinkedIn and drop them a message. Full show notes and transcript over at https://bit.ly/3NOL1WR. The post #33 What to do as the sun is setting on Universal Analytics appeared first on Measurelab.

Here were the resources we covered in the episode: Email the guest: jon@shape.io Coupon Code on Shape.io: B2 NEW LinkedIn Learning course about LinkedIn Ads by AJ Wilcox Contact us at Podcast@B2Linked.com with ideas for what you'd like AJ to cover.   Show Transcript AJ Wilcox Managing budgets on LinkedIn Ads is so hard. Help! Well, not when you're using one specific tool. Stay tuned to hear all about it on this episode of the LinkedIn Ads Show. Welcome to the LinkedIn Ads Show. Here's your host, AJ Wilcox. AJ Wilcox Hey there LinkedIn Ads fanatics. So the LinkedIn Ads partner ecosystem is still pretty thin, especially when we compare it with those super robust partner ecosystems across all the other ad platforms. So we want to start shining a spotlight on some of the most valuable and useful tools that us advertisers can get used to and get to use for better performance. Today's episode is covering a LinkedIn Ads tool that you may not have heard of, Shape.io. It's a tool for budget reporting, budget prediction, and even budget management. It's a very niche offering, but the things that it does, it does very, very well and it's priced very reasonably. Most advertisers I've talked to haven't heard of the tool, so I wanted to introduce it a little bit to you. Now this episode is not meant to be an ad for Shape.io. I'm a longtime user, for sure, and I do gush a bit in the episode about just how useful we found the app. The recommendations that I make here, though, are my own and shape didn't compensate us to be featured here. Alright, with that out of the way. Let's jump into the interview with Jon. AJ Wilcox All right, Jon Davis. Jon is a co-founder of Shape. He spent seven years as a PPC consultant, an agency analyst, and a department manager before leaving to build useful apps for other PPC analysts. The origins of shape come from problems Jon saw firsthand in our industry, he focuses on product direction, customer service, and sales for the company. Jon, anything I missed here in the intro? Jon Davis Yeah, well, AJ, first off, thanks a lot for having me, I'd say a little, maybe just a little bit more about where our company is Bend, Oregon. Really cool town, if you're into mountain biking, or skiing, snowboarding. Or if you'd like to play golf, like I do golf more my favorite hobbies. I've got two little boys that are four and six years old, that take up a lot of my time and not too much else really, truly interesting about me to be honest. My wife is pretty interesting. She is a former professional cyclist for about 10 years. Raced for team USA, has climbed every mountain in Europe on her bike, and has a lot of really cool stories. She ran track at University of Oregon, which is a really big deal for us out here that live in Oregon. So that's a little bit about the personal life and if you want to hear anything really interesting, get my wife on maybe if she ever gets into digital marketing. AJ Wilcox Love it! Well, I can't say any way that I would have like come across your wife because I have not climbed every mountain in Europe. I was just skiing this last weekend. So that is super cool. I will have to make my way up there to Bend. Jon Davis Yeah, we're about let's see from our office here about 25 minutes from the bottom of the lift at Mount Bachelor, which is our local mountain here that has a lot of great terrain and a little bit of a bummer this year, low on the snow here in Oregon this year. But Bend is a great town to come in the summertime. Really great weather, no humidity. And I could go on and on and sound like a tourist worker for the City of Bend, but if you like high elevation mountain towns, you should come check out Bend for sure. AJ Wilcox I do. I like how high elevation and I especially love the no humidity thing. I'm on my way now. Jon Davis Yeah, I lived in Georgia for about 10 years so I'm ready to never go back to humidity ever again. AJ Wilcox Oh, I get that. Cool. Well, obviously, I want to have you on here as a tool spotlight because Shape is I think the only tool I know of for LinkedIn ads that does what it does. So do you want to tell us a little bit about what the challenges are that advertisers face and how shapes solves them? Jon Davis Sure. First off, I'd be really curious. How would you describe what Shape does? As a customer? Are we allowed to say that? AJ Wilcox Yeah, we totally get you. Okay, so I probably will have said this in the intro. But I've been a longtime user of Shape, right, as soon as you guys got access to LinkedIn's API. I think I was one of the first if not the first user and I'm a big fan. So that being said, yeah. What Shape does it from my experience here is its budget tracking and its budget prediction. You know, for all of our clients, let's say we have 50 clients all advertising right now, at any given time, we can be getting alerts of like, hey, we've spent 48% of our month's budget on like, halfway through the month, and I'll know I'm on track, or we can have it automatically pause campaigns, if it's three days till the end of the month, and we've already spent all of the budget. So it's pretty much an insurance policy against like, spending a client's budget incorrectly. What would you add to that? Jon Davis Yeah, good job. Are you interested in SDR role or anything here at Shape? That's really our focus is budgeting and helping PPC analysts budget at scale. My background, like you said is in PPC, working as an outside consultant to agency analysts to managing a department of eight analysts at an agency and my background was working specifically in industries like self storage, multifamily housing, senior living communities. Our clients had lots of different budgets in lots of different places, all with managers at that apartment community that had a vested interest in how their budget was being spent. They had a lot of stakeholders. One thing I always say is, nobody has overspent more PPC budgets than me and my career back when I was an analyst. I got promoted to a manager role, but was still trying to manage budgets, and was over my head and things were slipping through the cracks. For me, it always felt like man, this shouldn't be this hard. And that is, you know, really where Shape tries to step in and help. The first version of shape was really focused on, like you were saying, just a pure alerting out to you, hey, you're about to run out of your budget, here's an email alert. Phase two of shape was allowing you to from the interface, when you got that alert went in, saw, oh, man, I need to pause these campaigns, or I need to raise the budget, whatever it is to do that right from Shape and be able to push those edits. So to move out from just being that reporting and alerting tool and then the phase that we're still living in today with Shape is to do a lot of that through automations and layering different automations on there, if you choose. So let's say you've got a PPC client with a $500 a month budget, you've got 10 campaigns across Google, LinkedIn, Facebook, all these places, feeding off that $500 budget, link those campaigns into that budget and when our system detects, you've hit that $500, like you see, will shut those campaigns down, pause them for the rest of the month, wait either to the beginning of the next month, or for more budget to be added and turn those campaigns back on. So really automating a lot of that manual work. I've seen every budgeting spreadsheet template you could imagine working in this space over the years and there's just no substitute for software coming in checking it every hour, every half hour for spend providing predictions, like you say, to help you kind of predict where you're going as well. We really primarily sell to agencies because they're facing that scale problem more than an in house team. We have a few in house customers, which we say are like in house teams with agency dynamics. So maybe they have a lot of franchises they're managing or something like that. But for us, really, we found that PPC agencies are where we have the most product market fit and where people find the most value. Our original name was Steady Budget, before we change to Shape and rebranded. So we've really been focused on budgeting since we released this product. AJ Wilcox Alright, so this might be leading the witness a little bit, but I'm curious to hear from you. Why is this an important problem to solve? What's the downsides or risks to overspending a budget? Jon Davis Sure. Yeah, I speak from my experience as an analyst. I knew the client would like kind of care maybe about what the cost per click was, I knew they at least have some interest in click through rate to see like how well their ads were responding. But I knew for sure, they cared about how much they spent at the end of that month, or the end of that cycle. And so for me, budgeting has always been one of those core things that really, clients are really focused on. I've really view a lot of PPC really kind of circles around three main pillars. There's the client, there's the analyst that they've hired, and there's the budget that they both agreed to. And that budget, client, customer, analyst relationship is one that kind of rotates around almost every PPC campaign, I think out there and by kind of like keeping that at the core and organizing all your data in Shape around those budgets, I think it works really well for agencies that that's really the first goal, okay, let's make sure we spend the budget accurately. You've got that confidence with your client and customer that hey, they said they're gonna spend $600 bucks they spend $600 bucks, we can trust them to do that. Now let's focus on more deeper agency client relationship things through communication and writing new ad copy and getting new test set up. AJ Wilcox I love it. I just want to add on to that. When I very first started B2Linked as an ad agency, I went out and I had to get business insurance and looked at all kinds of different insurances. I realized the most important thing, the worst thing that I could end up doing to a client is overspending their budget. This is spending money that they did not give us permission to spend. So I talked to several insurance agents at the time, not a single one of the policies I was looking at would cover overspending. So I realized I am on my own, it only took one overspending a client's budget before I went, Ah, I get this. This leaves me legally liable here. I think I need Shape. Jon Davis Yeah, we've been there too. We've researched the same thing from our end, like, hey, let's say servers went out, stuff that goes crazy early on, and there's a hiccup can we get insurance for that? Really it doesn't exist. Early on in Steady Budget Shape history in 2014-2015, I definitely stayed up at night a little worried about that. Now six, seven years in, if we ever get a support ticket, that's like a Shape overspent by budget or there's, you know, some fire like that that comes up, I know for sure that shape did what it was supposed to do, because that's our number one priority as a software. We have to be that insurance policy and every single time somebody or client or customer comes to us, you know, they believe in overspend occurred in Shape, it's every single time user error, or some setting they didn't get changed maybe the way they were supposed to. We really view that as our responsibility to help educate them on that, but from our perspective, I now sleep soundly knowing that we pause the campaigns when we're supposed to pause them, we turn them on when we're just supposed to turn them on. The code is as bulletproof as it could possibly be because we are out there. You know, we're out on the limb saying we're not going to overspend these budgets. Shape processes over a billion dollars a year in ad spend for our customers. And I promise you, we don't have a billion dollars in our bank account right now to potentially cover that overspend. So one thing that we believe 100% is the logic is rock solid because it has to be. AJ Wilcox Very cool. One technical question I've got for you. I wonder how much will Shape allow a campaign or an account to overspend? And also having API access to LinkedIn Ads myself, I know that the API is kind of weak, it's limited, at least in the past, LinkedIn has limited us to say, you are not allowed to request the same information more than four times per day or something. So realizing that you can only inquire from LinkedIn's API every so often, how much exposure does that allow you or kind of force Shape to not have noticed and overspend since the last time it requested? Jon Davis Sure, yeah, the good thing is working with them like on the tech side as a software provider, that's then going to license your software out to other providers, as you get a little different parameters and a little bit more often than maybe, you know, going as an individual through the API for your own account. So we have the ability, we're pulling in to make sure that no overspends occur. On a platform like LinkedIn where you're seeing pretty high cost per clicks and, you know, if you get a setting wrong, you can get away from you quick, we're able to really check on that spend at least once an hour through the day. AJ Wilcox Great. Is there any sort of logic to say, it looks like we're getting close to a budget so we're gonna start checking more often? We're gonna check every 15 minutes rather than every hour? Jon Davis Yeah, great question. And we do. So as we like, see that percentage of budget remaining kind of tightening up it, those types of budgets will float a little higher up into the queue priority that we have run it through and our logic that's just constantly churning through all the budgets on our platform. So we're trying to check that a little more often as we can as it gets kind of down closer. The other thing is, we've got a lot of previous data on how rapidly the those campaigns can spend so we can make a judgment around, okay, well, we don't have to start dialing up that check just yet, because we got a really good feel for how much this is going to spend based on historical data and with some of our automations we've got a little built in buffer on the underspend side of a couple percent, to make sure that if we err one way or another, we're going to make sure we under spend that budget by a percent or half percent then over spend it by a percent or half percent. AJ Wilcox I love it. That's fantastic. We've mentioned a little bit about this, but tell us about your relationship with LinkedIn, as well as the other ad platforms. Who do you support? What's your relationship like all that? Jon Davis Well, my personal relationship with LinkedIn is mostly as a user, somebody out there trying to promote my B2B software, putting How To videos up. It's really been, for our company, one of our most powerful channels to getting new product releases out there, getting some engagement on videos. I've run LinkedIn campaigns for myself and others and have some experience in there, but my primary professional background is with Google Search Ads. That's where I spent the majority of my career before leaving to work on software to solve PPC problems. I graduated college in 2006. In about mid 2007 was learning more about, I was in marketing, I was working in sales making 100 outbound calls a day. I thought hmmm, it'd be a lot easier if people called me and started working on our company website to get optimized for some SEO basics, which back then you could send almost anything to page one with a few easy tweaks, it was a magical time to be in digital marketing. From that time of like 2007, when I realized that these are people searching for products. Here's, you know, this search engine serving up ads for people that want to be shown to those people, it really did feel like magic to me, and I've been in PPC for the last 15 years ever since. So my relationship kind of goes back through the agency world every way you kind of touched the various platforms and Shape in particular, we sync with Google, Microsoft, Facebook, LinkedIn, Twitter, along with the Facebook, you get instagram along with Google, there's YouTube. So for those real main platforms, we go really deep with our integrations, there may be other PPC platforms out there or reporting platforms that have 500 data connections with every possible place, you can imagine pulling in a piece of data, we've really honed in on the top five, eight places that be placing ads for your clients and focused on really deep integrations with those where instead of just reporting on that data, we're pushing back out a lot of automations to all these platforms that we can. And so I think I've tended to live a lot in the search world, so one of the big reason Shape exists is combining search and social kind of into one budget. You know, a lot of these ad platforms don't have too much incentive to really integrate with other data. I don't think it's going to be too soon to where Google is going to be pulling in LinkedIn data. And LinkedIn is going to be allowing them to make like two way changes on a lot of campaigns through their tool. Through the years, there's maybe like backdoor ways in platforms have done it, and you're seeing Microsoft maybe take some steps. But none of the products are really enterprise or agency scale level, they're really meant to kind of help the individual advertiser manage, you know, a few campaigns, not the agency manage 1,000s of campaigns. So that's where one of the big things that Shape allows you to do is pull in all those campaigns from different places, put it under one client, micro group those in the budgets, and feel really good. You're spending your budget allocation where you want to be spending it. Jon Davis Love it. Any future plans for other platforms, like are you thinking Snap, or TikTok or any of those that you might want to support in the future? Jon Davis Yeah, so we're always getting requests, for sure. Really, that those are, you named a lot of the next big ones that we're looking at. Snap, Pinterest, TikTok are on our list, and really focused on bringing in new types of Google campaigns that they're finally allowing through the API. So really, where we run into more friction with our customers isn't necessarily bring on a new outside, like TikTok type, but not being able to pull in Google campaigns that they don't allow through the API. So up until like six days ago, you couldn't get any local service ads from Google out of their API and now it's just in beta and we're able to run testing. We're also exploring, there's some kind of data aggregation tools out there like Airbyte, and some other places where you can normalize a bunch of data and we could offer a lot more integrations. We're quickly kind of using that as a middleman, but right now Pinterest, TikTok, Snapchat, definitely the ones that we're targeting the most right now in terms of moving into those platforms and really as somebody that thinks a lot about our product direction, that's the one thing I really feel good about is a lot of our feature requests aren't necessarily like, hey, we need shape to do this new thing around budget management, it's more, hey, can you bring in these other campaigns and have them do for us what shape does for these other platforms? AJ Wilcox How mean is that of Google to be like, hey, we'll pass through the API, any information about your spend, except this one ad format, or this one objective? And all of a sudden, you're like, hey, of course, we want to be able to support all this, but the platform itself doesn't let us like, oh, you know, gets my goat. Sorry about that. Jon Davis Yeah, that's right. And that's one thing that we kind of, look at it. And in terms of we like to kind of look at ourselves as sort of a speedometer that can like accept any spend from any platform and give you, you know, the analyst a really good idea of what speed everything's spending at and moving at, and being able to pull in more channels there is key. Without that data feed and without Google allowing everything to be pulled in, you know, it's a struggle for us to add value. But the new Google Ads API know we're focused on LinkedIn, but the new Google Ads API that just has finally come out of beta and has been released has been a real huge thing for third party software's like us. It's been a lot of work to change every single call over to the new ads API, but Google, I think, can be slow to react in this case, they're finally give it understanding that, hey, if these third party software's like ours are supporting these clients, we need to give them the ability to pull all their spend in these tools because they're building workflows and systems around them. AJ Wilcox Totally. Alright, what strategies have you seen advertisers use and see great results because of using Shape? Jon Davis Yeah, I think really, the best way that we help analysts deliver better results is saving them a lot of time budgeting. Time that can be better spent, you know, thinking about how to improve those results, not just how do I spend $22 a day on this campaign or $38 a day? How do I get back on pace? Freeing up that time that you're not exporting a download into Google Sheets, reformatting, emailing, putting a CSV together and emailing out to the customer. Those are really places where we've seen the big savings. Within the app, we've got tools like Budget Pacer, that help people to see maybe opportunities to put more spend into a certain campaign with a lower CPA or a higher return on investment, whatever data you're pulling into Shape. With Budget Pacer, your there's a lot of different tools and dials you can turn to give you sort of like, hey, I want to prioritize CPA or I want to prioritize just raw conversions and get different predictions on what daily budget you should be saying at the campaign level based on those parameters. We see a lot of customers getting great results with Budget Pacer, We will see changes come through that are, you know, so and so changed daily budget to $38.12. And I'm like, Well, I know that was a Budget Pacer change, because I don't think they calculate, you know, $38.12. So we really see good results there from helping people one save a lot of time that they were previously doing manual work out of spreadsheets and workflows that were brutal. You know, as an analyst, I knew like the beginning of the month was always rough for us, because it was like, Okay, this is reporting time, I'm going to go, I'm going to be downloading a bunch of stuff, I'm entering in all these spreadsheets, and, you know, to kind of have a tool that would break that I kind of always wanted when I was in that scenario sort of break out of that kind of cycle and focus on more of the creative side. That's where we've seen the most positive results. And, you know, I think our core feature of pausing campaigns before they overspend is one that kind of eventually gets people don't even think about it anymore. They're they're not even worried about overspending a campaign ever again, where before they came to us a lot of customers that was like you were saying one of their chief concerns that the company was not overspending these budgets they've been trusted with? AJ Wilcox Yeah, I see what you mean by time savings, can't tell you the number of times that past companies, the CMO would come to me and say, Hey, are we on budget? Like, what number are we going to hit by the end of the month? And if I would have had Shape back then, I could have just looked at the graph and said, but instead I had to export everything by day. And, you know, plot spend by day and figure out how many days left in the month and do a trend line to show it. I'm decent at Excel, but I'm not a wizard. So that kind of report might take me 20, 30 minutes to put together whereas Shape tells you exactly what you're shooting towards. So I love that. AJ Wilcox All right, here's a quick sponsor break and then we'll dive right back into Shape. The LinkedIn Ads Show is proudly brought to you by B2Linked.com, the LinkedIn Ads experts. AJ Wilcox If the performance of your LinkedIn Ads is important to you, B2Linked as the agency you'll want to work with. We've spent over $150 million on LinkedIn Ads, and no one outperforms us on getting you the lowest cost per lead and the most scale. We're official LinkedIn partners. And you'll deal only with LinkedIn Ads experts from day one. Fill out the contact form on any page of B2Linked.com to chat about your campaigns, We'd absolutely love to work with you. All right, now, let's jump back into it. AJ Wilcox What are some of the results that your advertisers have seen in doing business with you? Have you had any like case studies or anecdotal evidence where they come to you and say, Thanks, you saved my bacon? Or this helped us so much? Or what are some of those? Jon Davis Yeah, well, I think, you know, most people out there thinking about LinkedIn are focused on LinkedIn. We've got a case study on our site. I don't know if it's company you've heard of, it's called B2Linked? Haha! When we talked to your team about what was life like before Shape or after Shape? What we really found was like just what we were saying your team estimated about 70% of their time that they previously spent on budgeting, which is hours and hours and hours a week. Now, it's just gone. And what we see really across the board with people that are trying to manage a lot of budgets is once everything's on boarded, set up, immediately, all that time that was spent budgeting is now freed up for other things. It's not uncommon for me to hear from an analyst like, Oh, I've got 10 hours in my week back, 15 hours in a week back. Working with larger agencies, we interact with a lot of accounting teams too that are responsible for reconciling ad platform spend at the end of the month. Just last week, an accountant sent me a thing, it's like we've just on boarded shape and now I need to pick up a new hobby because I don't have to spend as much time in the evenings manually entering ad spend that's getting reported on from PPC. Those are really fun for me to hear, because I was that analyst spending hours a day in Excel. To know that now they're able to think about the landing page they're sending the ads to, think about testing this new Google campaign type, and just pulling it into shape and not worrying that it's going to go crazy spend. Those are the things that I think are really fun about PPC and will keep better and smarter people in the industry for longer. AJ Wilcox Totally. That definitely resounds with me. If we as creative professionals and technical marketers are spending all of our time doing mind numbing, like crap work, busy work, rather than doing what we should be doing, which is developing good offers and good creative and managing the platform. I think it's a great thing. I'm curious. I know Google was famous early on for allowing you to spend more than your daily budget. And now LinkedIn has followed suit, depending on the objective you choose. They can overspend your daily budget by 20 to 100%. Have you found a situation where Shape has caught an overspend and been able to pause it before even the platform itself could do it? Jon Davis Yes. So one of our core features is really based around protecting against just that from the ad platforms. We have a feature called autopilot and there's two different settings on that. The first setting is let's give a budget a $1,000, here's the 10 campaigns. Let's turn on autopilot and let's say it's a monthly budget, we hit the $1,000 this month, turn it off, wait for the first day ofthe next month, turn it back on. Another version of that autopilot is daily autopilot. What that does is it takes the amount of budget you've got left divided by the number of days and sets a daily budget for those campaigns and when we see that daily budget reached, we take action to pause those campaigns within that day, wait for the midnight start of the next day, and then turn it back on. So let's say you've got your daily budget set at $50. Okay, Google and LinkedIn, they were rubbing their hands are like, alright, 50 bucks, that means 100, I'm ready to go. At about, 1:00 or 2:00 in the afternoon, you spent your 50 bucks, Shape comes through does the data update says well, you've hit your daily 50 bucks your campaigns off. Now Google and LinkedIn, they can't spend on a paused campaign for the rest of that day and that's been a really powerful thing for us to offer our customers you know, that gives you the ability to go into LinkedIn and even set just like a lifetime budget. And then make sure you've got daily autopilot involved and you're gonna pace on that daily budget for the life of that budget without needing to change those micro parameters from within LinkedIn along the way. So you can change any type of budget into a daily budget if you want to using those systems And that's again, where we view ourselves as that like speedometer, you're saying, hey, Google, hey, LinkedIn, I only want you to take this car 50 miles per hour, I'm not approving you to go 100 miles per hour, like you say, in your conditions, I want you to go 50 miles an hour, we make sure your cruise controlled to hang right there. Jon Davis That always makes me laugh when platforms act like they can't pause a campaign when it's overspending. Like, oh, we need allowance to spend 20% or 50% or 100% over because, you know, we're gonna throw a whole bunch of ads out there. And we have no idea how many of those are going to get clicked on? Yeah, maybe if you're spending millions of dollars per month, I get it. Like you're gonna have a lot out there. But especially for LinkedIn, where the majority of advertisers I'm guessing, are paying on CPM. It's like, the second your campaign is shown that 1,000th time and you know, it's spent that amount, the platform should be able to stop on a dime. It seems ridiculous, but I'm so glad that there's a tool like Shape that will allow us to override that. Jon Davis Yeah, I can see where the product design is there. And I can see how and why they can genuinely believe that, hey, giving us that freedom will get you better results at the end of this 30 or 60 day period because we've identified something in this moment, that means we should be spending more, but ut I think that doesn't always make it really easy on the analyst communicate that back through to their clients. And I think as clients sometimes are willing to sacrifice maybe that last morsel of performance to have some predictability around what is this gonna spend on a daily basis, when you know, about the same amount is going to be spent at the beginning of the month, that's going to be spent at the end of the month. And I think in a lot of cases, there's still value to that kind of predictability and to be able to set a setting on budget and have the platform stick to that budget should be an option. AJ Wilcox I totally agree. And with Google, I totally expect the platform to be able to say, hey, if we overspend right now we'll get you better performance. And I'm okay with that. I don't even think that LinkedIn does claim that if they overspend your budgets, because it's going to perform well. Yeah, I'm pretty sure it's just, we don't have faith in our platform being able to shut it off on time. That's what it seems like to me anyway. Tell me about some of the nuances with budgeting, either with Shape or without on LinkedIn Ads specifically. Like any nuances with the platform that we should know about as advertisers, what can you teach us? Jon Davis Yeah, I mean, I think, from my perspective, I probably have no grand insights there. But I think the one unique thing about LinkedIn versus some of the other platforms is just the sheer cost per click in some scenarios and that can be really challenging when it comes to budget management. If four or five clicks are costing you $10 to $20 a click, especially if you're working with a smaller business, that's a big chunk of change really fast. And, you know, I don't think that's a surprise, obviously, to anybody out there that's been running LinkedIn campaigns, and I think is one of the bigger barriers like to entry for people, you know, making the leap and getting into LinkedIn campaigns. But I think really, what I see in terms of like the nuances around on LinkedIn is just paying a lot of attention to how that bid is affecting your positioning. The magic part for me around LinkedIn is really being able to focus on that bid, get the amount of impressions, make sure you're not like two impressions a day, or 2 million a day, finding that sort of sweet spot in your bids so that you don't necessarily have to always CPA or CPM bid, you can bid more for performance and kind of enter that auction where I think you've got, you know, Google Ads guy in my background, I'm kind of an auction believer, in some cases there. I think if you're able to bid, obviously CPM, you're still involved in that auction somewhere, but you've got a little bit more of a finger on the dial there. So I think being able to kind of set up to make sure you're not overspending and then really kind of hone in where that bid needs to be, is where we see kind of the nuance and LinkedIn over maybe some of the other platforms. AJ Wilcox Oh, very well said. I love that explanation. So what's your favorite aspect of shape? Just some area of the product that you are really excited about or you think makes the biggest difference? Jon Davis For me, I still get really excited about the core thing we set out to solve in 2014, 2015 when we were launching the product, and that is, I've got a budget for this month and within shape, you can set a budget for any duration, it doesn't have to be monthly, it can be a one time, it can be a 17 day recurring budget for whatever crazy reason you might need it, but for me, I still get really excited about the fact that, let's say I set up campaigns, and I set a $500 a month budget, I set those campaigns that could run for the rest of time. and I know it's going to spend $500 a month as long as the volume in those campaigns will get the clicks and Google keeps showing the ads, you know, the quality scores don't go down too low or LinkedIn keeps showing those ads, I know in some ways Shape would just manage that likeRobots should. On, off when it should, pace the budget when it should. That kind of core features still leads every one of our sales calls, it still is the core of a lot of our marketing material that we talk about. I think as we've seen a lot of third party software in our space that started around the 2010 to 2015 zone, they were really focused on optimizing your campaigns and how can you spend your $500 a month more effectively, within the search engines are the ad platforms like LinkedIn, where we kind of thought the market was going back in 2014 2015, was that eventually all the ad networks are going to be way better at all that then third party software would ever be. We need to focus on building solutions where the ad networks weren't as excited about solving those problems, like limiting your budget, or bringing in data from multiple channels into one place. So I think, luckily, we haven't had to chase too much on the product and really just continuing to do our core function of pacing and managing PPC budgets, and removing all the manual work and staying kind of laser focused on that. One thing I've admired about B2Linked has been like your focus as a company and being able to really succinctly kind of say, Hey, we're the best and LinkedIn Ads in the world. That's our Jim Collins hedgehog concept. You know, that's our one thing we do great. I feel really lucky to have a company where I can, you know, say we do PPC budgeting, PPC management, budget management X scale better than any other platform out there. That's been a real focus of ours is to stay in that budgeting world and not chase, you know, the next AI algorithm because Google has, you know, I don't even know 5,000 engineers thinking about exactly that one thing and all the data in the world you could imagine and they're just not going to release enough of that data to third parties for us to make better recommendations than they could. So solving those problems and kind of filling in those cracks that the platform's leave open is something that gets me really excited about Shape. New campaign types getting pulled into shape gets me really excited. Being able to now add a lot of these new Google campaigns as LinkedIn keeps testing new types of campaigns and falls a lot of the same way. I get excited when each of those new campaign types get pulled in there. Because it means people now are pulling it in, not worrying about budgeting, focusing on like, okay, is this campaign type the best place or the best channel for me to be putting my clients money? AJ Wilcox Love it, if I can share my favorite feature? It's the fact that you can create a specific budget. It's not just like, one of our clients per month, we get to know are they going to spend or understand or whatever their budget, but it's the fact that we can group individual campaigns by name and give them their own budgets. So for instance, if we're running ABM campaigns, we could take their three ABM campaigns, group them into one budget on Shape and say, Hey, tell us how we're pacing here. Are we going to spend our ABM budget versus the overall account level budget? So that's one that I think is really cool. I just don't ever see any of the platforms releasing the ability to do this. I feel like you're on solid ground where the platforms aren't going to compete with you to try to take your business. Jon Davis Yeah. And that's been a real conscious decision on our end. And it's another one of the reasons we haven't really chased super in depth like reporting solutions. Instead, we have a one click integration with Data Studio where that's, you know, your reporting place now to go because everybody's working with data studio now. And they've got every little dial you could ever imagine. We'd be coding on just some new reporting dashboard for the next four years to get up to what Data Studio and some of these other tools are doing today. So instead of like fighting the battle on the reporting front, fighting the battle on the optimization front, all areas where big teams, big companies have a lot of incentive playing both those games, we want to be where they don't want to play. And they don't really want to play and project management and building tools to make it easier on a PPC agency to manage a lot of clients, you know, in a lot of the ad platforms mind, you know, the agency is really just a management fee that's taking more ad spend that could be going to the platform. And so a lot of their products aren't designed with the agency in mind. Our third party software, we can design specifically for the agencies and solve problems in that way that we just haven't seen the ad networks really take on that challenge yet. And it makes sense why they wouldn't. Their focus is on building tools so that an individual advertiser feels like you know what, I can run my own LinkedIn Ads campaigns, I don't need to go to be to links and, you know, pay for them. I think it's good enough, I can turn these few dials and LinkedIn will handle it. You know, that's really the problems they're trying to solve and focused on not how do we help B2Linked to manage 10,000 clients at the same time? AJ Wilcox Totally, it doesn't seem like it's in the platform's best interest to give their clients tools like that. I would argue that if you're having a good experience with the platform, if the platform feels like it's taking care of your money, they're a steward of it, that you probably want to spend more, you probably want to come back. But hey, you know, Google is one of the biggest companies in the world and they should have enough data to analyze. If they feel like it's still okay, to overspend a budget, then they must get more money out of it, it must be a good business decision. So I like the business you're in, keeping them honest. Jon Davis I don't think you can ever go too wrong if you just follow the money in the decisions and the product. They're beholden to stakeholders and it makes sense why they're doing what they do, but I think that leaves a lot of opportunity for third party software and companies like ours to fill in those cracks and add value. AJ Wilcox So true. Give us an idea. We've been talking about the product, give us an idea on pricing. What can any of our listeners expect to spend to get access to these features? Jon Davis Sure, well, first off, you can get complete feel of Shape, all our automations through a free trial. You can manage up to 20 budget on our free trial for as long as you want to get a feel for it. If you feel like that's limiting you in any way reach out to me personally, I'll help you do a little bigger trial, if you need it. During that time, they let your team get a feel for it. After the free trial, our lowest tier is $299 a month. $299 a month and for that you can manage up to $100,000 of ad spend through your accounts. From there it progresses, you know, every $250,000 in ad spend goes up roughly about $500 a month. It works out to be anywhere from like, .1% to .2% of your ad spend is roughly the Shape fee you could ballpark expect to spend. AJ Wilcox It's really reasonable. As longtime clients, I can I can attest to that. Not that this is meant to be an ad or anything, but honestly, I want to share the partner ecosystem and I want to highlight which tools we actually think are worth paying for and which aren't. Shape definitely fits squarely in our bucket of yeah, this is definitely worth paying for. We like it. Jon Davis Thanks. That means a lot for me coming from you and to hear that.From our perspective, we work with small, medium, large agencies, all of them are fighting a battle against smaller margins over the last 5, 10 years, you know, management fees are dropping, clients expect more, for less, and that's where we've tried to keep our Shape software fee as a pretty minor percentage of your overall adspend. We did also set up a coupon code for anybody listening. If you go through the free trial and you decide that hey, shape is for me, coupon code just B2. So B2 and get you 50% off your first three months. AJ Wilcox Love it. Thanks for creating a custom code for us. That's awesome. I know you'll treat our listeners. Great. So everyone who's considering definitely take Jonn up on that offer. Jon Davis Yeah, if you submit a support ticket, it will either be me or Nicole, one of my colleagues here answering it so you can reach me jon@shape.io. Don't hesitate to reach out and answer any questions or I can give a more in depth demo for anybody interested in Shape. AJ Wilcox Beautiful. Alright, so away from business here or this could include business, too, but I'm curious, what are you most excited about either professionally or personally coming up? Like what's getting you out of bed in the morning? Jon Davis Yeah, I mean, I think professionally for us, it's really now we've made it through a lot of the hard startup years, the beginning years. We're seven years now and we have a really good belief in our product market fit. And for an entrepreneur, there's no better feeling to get you out of bed than feeling like you've got product market fit. And I think that's the one thing that is really nobody can ever predict if you're going to get it. Nobody knows if you have it before you have it. And the only way to get it is to really try and go out there and knowing that we're building a product 1,000s of people use every day, that's an easy reason to get out of bed and make sure that we're helping them with their jobs. You know, when my kids asked, What do you do? It's kind of hard to explain to a four year old what being a co-founder of PPC management software startup is, but I pretty much just say I help make tools that live in the computer that help make people's jobs easier and more fun. And I think that's really the core of what helps me get out of bed professionally. Just hanging out with my kiddos and seeing what they're going to get into next. We've been doing a bunch of skiing this year and hoping maybe this is the summer they pick up golf a little bit more. And let's see my old 1994 Land Cruiser that I just picked up a little while ago helps get me out of bed to figure out what I'm going to fix up on that next or build that up next for the trail. AJ Wilcox Sweet. You're speaking my language. I'm just headed out on our side by side the end of this week doing some off roading. I'm not handy enough to fix up my own Land Cruiser, but I'll play in the side by side. That'll be fun. Jon Davis We'll have to connect up on that! AJ Wilcox Yeah, it'd be fun. Jon, thanks so much for joining us, sharing about your product, giving us some insights, teaching us about budgeting on LinkedIn and the other platform. So sincerely, thanks for coming on. Anything else you want to share with us or anything else or anything else we should know? Jon Davis No, I think that'll do it. Thanks so much for having me. I feel like I've gotten to have like a 40 minute plug here so I don't need to plug anything else. Most important thing is if you want to talk to me or reach me about anything PPC related, jon@shape.io and I'll be happy to talk to anybody that has any questions. It's really fun to get to talk to new PPC analysts see how new teams are doing stuff and if Shape can help them. AJ Wilcox Perfect. Thanks so much, Jon. Sure appreciate having you on! Jon Davis Thanks a bunch, AJ. AJ Wilcox All right, I've got the episode resources for you coming right up. So stick around Thank you for listening to the LinkedIn Ads Show. Hungry for more? AJ Wilcox, take it away. AJ Wilcox Alright, I've got the episode resources for you here. So first off, Jon was so generous in giving us his email address. So if you want to email him directly to ask any question about anything we've covered here, it's jon@shape.io. You'll also see that down below in the show notes. Next, if you do decide to sign up for Shape, use the coupon code on shape.io of just the letter B and the number 2, that's also going to be in the show notes as well. As a reminder, if you have any colleagues or even you yourself are new to LinkedIn Ads, and you're trying to learn it, definitely check out the course that I did with LinkedIn Learning. The link is in the show notes below and it is by far the most comprehensive, as well as one of the cheapest courses you can find out there and LinkedIn stands behind it. On whatever podcast player you're listening to this on, if you like what you've heard, please hit that subscribe button so you can hear all of our future episodes as we come out with them. You may want to go back and binge a few along the way as well. I'm not judging. If you do like what you've heard, please do review the podcast. Most of those reviews happen on Apple podcasts. But I've heard that reviews are starting to happen on Spotify as well. But really anywhere that you listen, anywhere you find reviews, I would absolutely love to see your review and I'll totally shout you out as well. With any suggestions or corrections. You can reach out to us at Podcast@B2Linked.com. And with that being said, we'll see you back here next week. Cheering you on in your LinkedIn Ads initiatives.

Guests Leigha Jarett and Debi Cabrera from the Looker team join Mark Mirchandani this week to talk about this powerful tool. Looker, Google's data analytics platform, was built to provide enterprise companies with customizable analytics tools that allow anyone to get the data they need when they need it. This facilitates better business decisions. Leigha talks about how Looker and LookML keep data consistent among data analysts no matter where they pull data from or what they do with it. Data is more trustworthy, fostering a positive data-driven business. She details how LookML works, from database connection to metric creation, and tells us how easy it is for non-data engineers to work with as well. Robust data analysis based on trusted data points used to drive decision making is how Looker builds an environment of business intelligence rather than simple reporting. By offering easy integration into other Google tools like Data Studio and BigQuery, Looker is easy to set up, learn, and use. Our guests help listeners navigate Looker's Explore From Here functionality and explain how it could help them answer important business questions. With advanced admin permissioning, Looker also helps limit the chaos that comes with multiple people accessing the same data. Later, we hear real-world examples of companies taking the Looker journey. Our guests offer advice based on these experiences with clients and talk about how client feedback has influenced new Looker tools, like the Looker Tableau Connector that's coming soon. We hear about the relationship between BigQuery and Looker and suggestions for companies newly embarking on their data journey. Leigha Jarett Leigha is a Product Manager for Looker's application platform. She focuses on making Looker both simple and powerful for developers. Debi Cabrera Debi recently became a Developer Advocate after being at Looker for three years as an Engagement Manager and StratOps PgM. You can find her on Linkedin Cool things of the week Introducing a Google Cloud architecture diagramming tool blog Black History Month: Celebrating the success of Black founders with Google Cloud: DOSS blog Interview Looker site LookML site Data Studio site Looker Connect site Looker Documentation docs Looker Products Page site Tableau site Google Cloud Training site Google Cloud Skills Boost site Looker and BigQuery Important Considerations whitepaper BigQuery Playlist videos Data Analytics Playlist videos Looker Channel videos Contact Google Cloud Support site Request a Free Trial site What's something cool you're working on? Debi is planning her wedding! Hosts Mark Mirchandani and Debi Cabrera

Στο Digital Jam Podcast 118 έχουμε Newsfeeed by Grow-Digital και τα νέα είναι HUGE! Η Google ανακοίνωσε αλλαγές στο Privacy των Android που θυμίζουν iOS και η Facebook έχει κάθε λόγο να ανησυχεί Στο twitter η Performance max έφαγε κράξιμο και η Google έδωσε καποιες απαντήσεις H Skroutz προχώρησε σε αυξήσεις προμήθειας Τα Web Stories ίσως γίνουν το επόμενο AMP Το Linkedin έβαλε newsletters Το Data Studio έκανε updates και πλέον υποστηρίζει και την Performance Max Στο Digital Jam Podcast συζητάμε μικρά & μεγάλα θέματα σχετικά με το digital marketing, το PPC και τα social media κάθε βδομάδα. Κάνε subscribe στο podcast για να λαμβάνεις τα νέα επεισόδια. Spotify: https://spoti.fi/2DKFSQ0 Apple Podcasts: https://apple.co/3gGp2k0 Google Podcasts: https://bit.ly/31CEg2T https://digitaljam.gr Follow us: Facebook: @DigitalJam.gr Linkedin: https://b.link/yuuhq Instagram: @digitaljam.gr Dimitris Zacharakis: https://b.link/dzacha Dimitris Kalaitzis: https://b.link/dkalaitz Stavros Theodoratos: https://b.link/stheod --- Send in a voice message: https://anchor.fm/digitaljam/message

Von der Definition der Zieltabelle über die Abfrage aus den Daten Tabellen die im Data Warehouse liegen bis hin zur Visualisierung mit BI Tools wie Tableau, Power BI, Data Studio etc.

Spotify doubles down on podcasting — and that's probably not great news for the industry... Google brings Stories to Data Studio... TikTok, for a change, steals from Facebook... while YouTube puts more pressure on the popular app... the big Amazon war is over... You can now pull business calls into your CRM platform...Go Premium! No ads, more stories, audio chapters, and extended weekend episodes — https://todayindigital.com/premiumADVERTISING as low as $20: https://todayindigital.com/ads JOIN OUR SLACK! https://todayindigital.com/slackFOLLOW US: https://todayindigital.com/socialmedia (TikTok, LinkedIn, Twitter, Facebook, and Reddit) ENJOYING THE SHOW?- Please tweet about us! https://b.link/pod-tweet- Rate and review us: https://todayindigital.com/rateus- Leave a voicemail: https://b.link/pod-voicemail FOLLOW TOD:- TikTok: https://b.link/pod-tiktok- Twitter: https://b.link/pod-twitter- LinkedIn: https://b.link/pod-linkedin Today in Digital Marketing is hosted by Tod Maffin (https://b.link/pod-todsite) and produced by engageQ digital (https://b.link/pod-engageq). Subscribe at https://TodayInDigital.com or wherever you get your podcasts. (Theme music by Mark Blevis. All other music licensed by Source Audio.)Does your brand need a podcast? Let us help: https://engageQ.com/podcastsPrivacy & Opt-Out: https://redcircle.com/privacy

In this episode of Bite Size SEO News, I talk about today's top stories you need to know:Story 1: Google releases Data Studio Dashboard for Web StoriesStory 2: Google plans privacy change similar to Apple'sStory 3: Spotify is acquiring two major podcast tech platformsIf you'd like to learn more about me, visit https://richungseo.comDon't forget to rate the show!-----------------------------------------------Follow me on:InstagramTwitter-----------------------------------------------Rich Ung San Jose SEO 80 Descanso Dr #2315 San Jose, CA 95134 (408) 752-2947 © Copyright 2022 Rich Ung SEO All Rights Reserved

On the show this week, Mark Mirchandani and Stephanie Wong share two popular episodes of Bruno Aziza's YouTube series Data Journeys. First up, Bruno talks with Aaron Biller of Postmates about their triangle of complex data that includes customer, courier, and merchant. He details their data storage and analytics structure, describing it as a reverse pyramid of tons of data with few engineers to manage and analyze it. To handle this, Postmates takes a stay-out-of-the-way approach by providing good data and letting the analysts do what they do best without micromanaging. Aaron talks about this data architecture, including the use of BigQuery as data lakes to keep data storage simple, and how Google collaboration tools streamline access and authorization tasks. Communication and flexibility are important, Aaron tells us, and he offers other advice for companies designing data systems. Feedback loops, dedicated training, and an open environment with no silos also help foster a productive, healthy data workplace. Matteo of Delivery Hero speaks to Bruno next. With the goal of increasing their global reach and offerings, it's important that Delivery Hero has a smooth data system. Matteo outlines the new data structure they've built to ease onboarding of new companies and territories and describes different use cases for their data. From determining the number of delivery people necessary in each area to offering personalized customer recommendations, Delivery Hero uses Google offerings like Google Analytics and BigQuery to interpret collected data. Matteo details how they tailor data infrastructures for each use case and offers tips to help companies think through their data infrastructure design. Don't work in a bubble, Matteo stresses, and focus on thorough onboarding of team members and clear communication with colleagues and customers. Bruno Aziza Bruno is the Head of Data & Analytics at Google Cloud. He specializes in everything data, from data analytics, to business intelligence, data science, and artificial intelligence. Before working at Google, he worked at companies like Business Objects when it went IPO and Oracle, where his team led a big turnarounds in the business analytics industry. Bruno also had the opportunity to help launch startups like Alpine Data (now part of Tibco). Sisense and AtScale and helped Microsoft grow its Data unit into a $1B business. He has been educated in the US, France, the UK, and Germany and has written two books on Data Analytics and Performance Management. In his spare time, Bruno writes a monthly column on Forbes.com on everything Data, AI and Analytics. Aaron Biller Aaron is the Manager of Data Engineering at Postmates. Matteo Fava Matteo is Senior Director of Global Data Products and Analytics at Delivery Hero. Cool things of the week Celebrating National Muffin Day with machine learning blog Managed Istio-based service mesh on our managed GKE clusters: Anthos Service Mesh comes to GKE Autopilot blog Interview Data Journeys videos Episode 12: How Postmates delivers on data needs with just six data engineers video Episode 5: How Delivery Hero uses data to deliver meals video BigQuery site Google Workspace site Dataproc site Pub/Sub site Google Analytics site Looker site Tableau site Data Studio site GCP Podcast Episode 266: Data Analytics Launches with Bruno Aziza and Eric Schmidt podcast GCP Podcast Episode 281: Google Cloud Next Data, Analytics, and AI Launches with Eric Schmidt and Bruno Aziza podcast What's something cool you're working on? Steph is working on the next Ask Google Cloud event and she wants your Kubernetes questions! Hosts Mark Mirchandani and Stephanie Wong

Getting around Facebook's ban on "before and after" ads... Microsoft gets cozier with Google's site tools... The scary warning message that's showing up on Facebook's ad platform... Google is changing more title tags again — way more than you think... Performance Max data is coming to Data Studio... and more.Go Premium! No ads, more stories, and extended deep-dive weekend episodes — https://todayindigital.com/premiumADVERTISING as low as $20: https://todayindigital.com/ads JOIN OUR SLACK! https://todayindigital.com/slackFOLLOW US: https://todayindigital.com/socialmedia(TikTok, LinkedIn, Twitter, Facebook, and Reddit) ENJOYING THE SHOW?- Please tweet about us! https://b.link/pod-tweet- Rate and review us: https://todayindigital.com/rateus- Leave a voicemail: https://b.link/pod-voicemail FOLLOW TOD:- TikTok: https://b.link/pod-tiktok- Twitter: https://b.link/pod-twitter- LinkedIn: https://b.link/pod-linkedin Today in Digital Marketing is hosted by Tod Maffin (https://b.link/pod-todsite) and produced by engageQ digital (https://b.link/pod-engageq). Subscribe at https://TodayInDigital.com or wherever you get your podcasts. (Theme music by Mark Blevis. All other music licensed by Source Audio.)Does your brand need a podcast? Let us help: https://engageQ.com/podcastsPrivacy & Opt-Out: https://redcircle.com/privacy

This week Dan and Dara discuss where they think the future of Google Analytics is heading. Spoiler alert - like it or not, it's all GA4. The Google Analytics for Firebase upgrade to Google Analytics 4 has until the 15th February 2022 before data is deleted, and 17th January 2022 before new data stops being processed https://bit.ly/3CLTF2u. Check out the announcement from Looker back in November 2021 stating they are rolling in the Data Studio team into their own https://bit.ly/3r6V2Fv. Grab yourself a ticket to MeasureFest on 6th April 2022 and come see Dan do his talk on "the role of GA in the future MarTech stack" IRL https://bit.ly/3HaiHdE. In other news, Dan and Dara top up on some TV! Please leave a rating and review in the places one leaves ratings and reviews. If you want to join Dan and Dara on the podcast and talk about something in the analytics industry you have an opinion about (or just want to suggest a topic for them to chit-chat about), email podcast@measurelab.co.uk or find them on LinkedIn and drop them a message. The post #24 What will the role of GA be in the future? appeared first on Measurelab.

In this week's episode, we chat with Laura Hogan, Owner of Sweet Digital Agency, about running and scaling an agency. Where to find Laura: https://www.linkedin.com/in/lauralouseo/ (LinkedIn) https://twitter.com/lauralouise90 (Twitter) https://www.sweetdigital.co.uk/ (Website) Resources from the episode: https://www.searchenginejournal.com/ (Search Engine Journal) https://searchengineland.com/ (Search Engine Land) --- Episode Sponsor: This season is sponsored by Screaming Frog. Screaming Frog develop crawling and log file analysis software for the SEO industry, and wanted to support the WTSPodcast as listeners to the show. They've just released version 16 of their SEO Spider software, which includes - improved JavaScript crawling to help you identify dependencies, such as JavaScript content and links, automated crawl reports for Data Studio integration, advanced search and filtering, and the app is now available in Spanish, French, German and Italian. You can check out the latest version at Screaming Frog's website (screamingfrog.co.uk). Where to find Screaming Frog: https://www.screamingfrog.co.uk/ (Website) https://www.linkedin.com/company/screaming-frog/ (LinkedIn) https://twitter.com/screamingfrog (Twitter) https://www.youtube.com/c/ScreamingFrogSEO (YouTube) https://www.facebook.com/screamingfrog/ (Facebook) --- Episode Transcript: Areej AbuAli: Hey, everyone. Welcome to a new episode of the Women in Tech SEO Podcast. I'm Areej AbuAli and I'm the founder of Women in Tech SEO and I am your host today. Today's episode is all about running and scaling an agency and joining me is the brilliant Laura Hogan, who is the founder of Sweet Digital. Hey Laura? Laura Hogan: Hey, are you all right? Areej: Yes, I'm good. Thanks. How are you? Laura: Good, thank you so much for having me on. Areej: Yes. Thank you so much for joining. I'm really, really excited about today's episode. We've worked together before through Women in Techs SEO initiatives so thank you for jumping on the podcast with us. Laura: Not a problem. Hopefully, I can give some useful information to people. Areej: I'm sure you will. Can you give a little bit of an overview about yourself and what you do and everything we want to know about Sweet Digital? Laura: Yes, so I launched Sweet two, two and a half, three years ago now. It started just me in my kitchen with my dog, and we're just under 10 people today. We've had some really lovely growth over the last couple of years. We're pretty much a full-service digital marketing agency. We have team members in the UK. One of our team members moved to Spain last year and then we've got a team in South Africa as well. Basically, anybody who's really good who wants a role, we don't really care where you live, which is brilliant. Areej: I Love that. Laura: Yes. It's so much fun. Areej: I remember a few-- I think maybe it was right before COVID, you were definitely much smaller then. How was COVID for you with the agency growth and how did that go? Laura: I think like every agency when it first hit and the UK closed down, there were definitely a few days of tears and a lot of panicking initially about what might happen. But you know what, I just put my big girl pants on and we knuckled down. There was only three of us in the company at the time that COVID first hit and we just knuckled down, and really worked on the sales, really worked on the partnerships that we had and really worked on making sure that we retained the client base that we did have. When COVID hit, our biggest clients were in leisure and hospitality and travel, which were probably- Areej: Oh no. Laura: -the hardest hit industries but we just supported our clients. I think that was the key thing. Nobody cancelled a contract with us, which we're so fortunate of. We worked with them to scale down their retainers for a bit, and to be there as that support for them. Obviously, in the meantime, we were working to...

In this week's episode, we chat with Levi Williams-Clucas, SEO Specialist at StrategiQ, about local SEO and the importance of reputation, reviews and trust. Where to find Levi: https://www.linkedin.com/in/leviwilliamsclucas/ (LinkedIn) https://twitter.com/Femkepants (Twitter) Resources from the episode: https://academy.brightlocal.com/ (BrightLocal Academy) BrightLocal blog https://strategiq.co/strategiq-hub/learn/ (StrategiQ blog) --- Episode Sponsor: This season is sponsored by Screaming Frog. Screaming Frog develop crawling and log file analysis software for the SEO industry, and wanted to support the WTSPodcast as listeners to the show. They've just released version 16 of their SEO Spider software, which includes - improved JavaScript crawling to help you identify dependencies, such as JavaScript content and links, automated crawl reports for Data Studio integration, advanced search and filtering, and the app is now available in Spanish, French, German and Italian. You can check out the latest version at Screaming Frog's website (screamingfrog.co.uk). Where to find Screaming Frog: https://www.screamingfrog.co.uk/ (Website) https://www.linkedin.com/company/screaming-frog/ (LinkedIn) https://twitter.com/screamingfrog (Twitter) https://www.youtube.com/c/ScreamingFrogSEO (YouTube) https://www.facebook.com/screamingfrog/ (Facebook) --- Episode Transcript: Sarah: Hello, and a very warm welcome to the Women in Tech SEO Podcast. I am Sarah McDowell, an SEO content executive, and I will be your host for today. Joining me I have the wonderful Levi Williams-Clucas, who is an SEO specialist at StrategiQ, and they will be talking to us today about Local SEO. Welcome to the show, Levi. Levi: Hello, hello. Thank you for having me. Sarah: Thank you for giving up your time and agreeing to spend Wednesday afternoon with me. Have you had a good day? Levi: I've had a great day. Yes, it's been nice and sunny outside, and I've been able to pet my cats today, so very happy. Sarah: Sounds like a wonderful, wonderful Wednesday. To kick things off, I want to ask you how you got into this wonderful world of SEO, and how you ended up being an SEO specialist at the agency StrategiQ? Levi: I've always been into marketing, and I did my degree in marketing and was ready to go as soon as I came out of uni. It didn't work that way and I ended up having a bunch of random temp jobs, and then got my first proper agency job at StrategiQ as a Digital PR. I decided it wasn't for me and thankfully my manager noticed an interest in me for SEO and suggested it and shout out to Chris Green if anybody knows him. He suggested, "Would you like to move into SEO?" I thought, "Yes, I'm going to give that a crack." I've been happy as a pig in the mud ever since really. It's my calling. Sarah: I love that saying "Happy as a pig in mud," I've not heard that one before. Levi: Oh, that's one of my favorites. Sarah: That's awesome that within your agency, then someone who worked with you was able to identify a whole area that you would be interested in. I think that's really cool. Levi: Yes. Sarah: Cool. What one bit of advice would you give other women starting out in the industry? Levi: I had to go think about this, because there's a lot of things that I think I would like to give as advice to women in the industry, but I think my main one is not to change who you are or what you believe in, to fit into something that other people say you should be or should believe in. How you look, sound, how you identify, really doesn't have any impact on how good you are at your job, and how well you can learn what you need to do to succeed in your role. You should really remind yourself of that when you feel like you've been treated otherwise, and prove those people wrong. I have, I'm here, I'm covered in tattoos and piercings, and I have a very successful career despite being judged on a regular basis about things like that, so...

Data has emerged as arguably the most valuable asset class in the global economy and is becoming increasingly available across industries, including financial services.  In this episode, Stephen Marshall, Head of Data Studio, Data & Analytics Solutions at BNY Mellon, discusses products helping BNY clients analyze their data from different vantage points and make better decisions. Included in this episode:[2:29] The zero code BNY Mellon Data Studio [7:00] Shifting from data as a byproduct to data as a service [15:00] Combatting data fatigue and paralysis[17:15] A look at the next 10 years; IoT and upping your business model[20:30] Differentiating yourself within a data heavy market

In this episode, we are discussing how to effectively collaborate with your colleagues using a variety of virtual tools. Collaboration is key in education, so we want to make sure that you have some great ideas and strategies to help you collaborate with other educators in this crazy school year. We'll dive into video conferencing and communication tools, whiteboard tools, resource curation and storage, and sharing and finding new ideas and tools.If you like what you hear, we would love it if you could share this episode with a colleague or friend. And make sure you subscribe so that you don't miss out on any new content! And consider supporting the show by buying us a coffee or two!We would love to hear from you – leave a comment on our website OR check out our FLIPGRID!News and UpdatesBitmoji and Flipgrid Integration announcementSetting up Friendmoji in the Bitmoji appNEW Blur Tool in Screencastify Edit announcementFeatured ContentVideo Conferencing/Communication ToolsGather.town - PD, social events, unconferences and PricingGoogle Meet, Zoom and other video conferencing toolsGoogle Chat, Slack, WhatsApp, and other text messaging appsGoogle Groups - check out our Imposter Syndrome EpisodeStreamyard (more one-way but chat in YouTube is good)Whiteboard ToolsPadletGoogle JamboardMindomo or other mind-mapping toolsWhiteboard.chat or whiteboard in Gather TownResource Curation/StorageBook CreatorWakelet - Spaces are great for collaboration!Shared Drives vs Traditional DrivesGoogle Site (course teams)Data Studio (a little more involved)Global GEG tutorial on Data StudioSharing/Finding New Ideas/ToolsTwitter or other social media platformsKatie's profileRachel's profileEduGals' profileFacebook Groups MCP Teacher Collaboration GroupGoogle Groups or Google CurrentsWakeletSupport the show (https://www.buymeacoffee.com/edugals)

Le STUDIO PROUVÉ donne la parole à une génération émergente d'architectes, d'ingénieurs et de critiques afin de questionner l'espace au regard de la conception technique de Jean Prouvé, de ses procédés de fabrication, de sa structure et de sa mise en oeuvre. Quatrième des huit intervenants : Léonard Lassagne et Colin Reynier, de l'agence DATA architectes. "Dans tout le travail de Jean-Prouvé, il y a une forme de pensée constructive très forte qui est le liant qu'il érige comme une ligne de conduite autour de la logique de fabrication et de la fonctionnalité. En résulte une forme d'esthétique assez simple, sans artifice et en définitive évidente, voire essentielle." Conférence enregistrée en public depuis l'école « nomade » conçue par Jean Prouvé et réinstallée Place de la Concorde par la galerie Patrick Seguin, dans le cadre de la FIAC 2018.

(December 12, 2018) Rick and Minhaz (Google Data Studio) discuss the challenges of visualizing data at scale and how to use Google Data Studio to connect, visualize, and share big data on the web. Data Studio → https://goo.gle/2XxjGiw  CrUX Dashboard → https://goo.gle/3eowbnj  World Cup Dashboard → https://goo.gle/2A8NSsh  Firebase Realtime Database → https://goo.gle/3elYPFN  Data World → https://goo.gle/3gqefdP  Socrata → https://goo.gle/2M2MhXR 

Vicky Harp joins Scott Hanselman to show how Azure Data Studio combined the simple and robust SQL query editing experience of tools like SSMS with the flexibility and collaboration of Jupyter Notebooks. The November 2019 release of Azure Data Studio included SQL Server 2019 Guide as a Jupyter Book, which provides a richer troubleshooting experience.[0:04:00] - DemoAnnouncing Jupyter Book support blog postDownload and install Azure Data Studiomicrosoft/azuredatastudio GitHub repoLatest news on the SQL Server BlogCreate a free account (Azure)

Vicky Harp joins Scott Hanselman to show how Azure Data Studio combined the simple and robust SQL query editing experience of tools like SSMS with the flexibility and collaboration of Jupyter Notebooks. The November 2019 release of Azure Data Studio included SQL Server 2019 Guide as a Jupyter Book, which provides a richer troubleshooting experience.[0:04:00] - DemoAnnouncing Jupyter Book support blog postDownload and install Azure Data Studiomicrosoft/azuredatastudio GitHub repoLatest news on the SQL Server BlogCreate a free account (Azure)

Data Studio updates + developer features - how to use it to visualize and create dashboard for your data.

Are they reading our reports? Do they understand them? Stop spending days creating complex reports nobody is going to read or understand! This talk will provide the answers you have been waiting for on what should be included in a monthly, quarterly or annual digital marketing report. By using Data Studio, Supermetrics and Funnel as SEOs we can keep the Board, Head of Digital and the marketing team happy.

Sydney Smith joins Scott Hanselman to show the rich editing experience provided by the PowerShell extension in Azure Data Studio by creating a SQL Server in a Linux Docker container with external storage—all using PowerShell Core in Azure Data Studio.To get started with the notebook used in the episode check out: PowerShell/vscode-powershell[00:01:36] Demo - Getting started - installing modules[00:04:45] Demo - Creating a new editor filePowerShell Editor Support for Azure Data StudioThe PowerShell Extension is now in the Azure Data Studio MarketplaceWhat is Azure Data Studio?Create a SQL Server on Linux Container with 5 Lines of CodeBuild Docker Containers with External Storage on Your DesktopCreate a free account (Azure)

Sydney Smith joins Scott Hanselman to show the rich editing experience provided by the PowerShell extension in Azure Data Studio by creating a SQL Server in a Linux Docker container with external storage—all using PowerShell Core in Azure Data Studio.To get started with the notebook used in the episode check out: PowerShell/vscode-powershell[00:01:36] Demo - Getting started - installing modules[00:04:45] Demo - Creating a new editor filePowerShell Editor Support for Azure Data StudioThe PowerShell Extension is now in the Azure Data Studio MarketplaceWhat is Azure Data Studio?Create a SQL Server on Linux Container with 5 Lines of CodeBuild Docker Containers with External Storage on Your DesktopCreate a free account (Azure)

  Even if you're not a numbers person, you need to understand the math behind your marketing.  The good news is that this is not nearly as complex as it seems.    This does NOT mean you need to be a math wiz kid, or a coder, or a master of analytics.  But you do need to know the story your data is telling you.     Chris Mercer (known mostly as Mercer) is one of the smartest analytics guys I know.  But more than just understanding the technical side of analytics, Mercer knows how to find actionable data.   That's what understanding the math behind your marketing is all about…finding what needs to be fixed or improved to help you grow.     In this episode we discuss: - Go to Google Analytics with a specific question in mind.  This is important.  Most people pop open their Google Analytics account and just wander around.  You need to go to the data asking a specific question.   - Learn to ask good questions of your data.  Often you don't take the right action, because you aren't asking the right questions. - Why averages are worthless, but segmentation is key - Understand the usefulness behind Mercer's Mantras "Find the truth in the trend" and "the power is in the pattern". - Why properly tagging your traffic may be the most important data cleanup step you take - How Google Analytics, Data Studio, and Google Tag Manager fit together - Plus more!   Check out these great resources from Mercer: https://measurementmarketing.io/