Ask and discuss

I’m wondering what sources do you all use / follow to keep in track with all of the latest marketing news?For me coming from an media agency background I of course try to keep in touch with especially topics related to that. I use a combination of free and paid sources.LinkedIn in general but also especially a few experts in their field:Dan White for a range of marketing theories and topics with very clearly illustrated pictures Karen Nelson-Field who is one of the main experts in Attention metrics Paul Stringer who is the managing editor of WARC and shares the latest news of their research and studies Les Binet, Head of Effectiveness at adam&eveDDB and author of the famous “The Long and the Short of it” with Pieter Field  Asbjørn Moe who is the Nordic Paid Media Lead at Vipps MobilePay and shares a lot about creativity, attention, digital marketing and how all of that can improve effectiveness of mediaSites / newsletters:Digiday AdweekOverall sources for trends:WARC Think with Goo

What are your thoughts around this? Even though Google keeps delaying removing third-party cookies, it’ll come eventually. I’d love to hear:Has your organization prepare for cookieless? What are the alternatives you’re using or planning to use? What’s your plan for first-party data?We’re planning an article around cookieless tracking so it would be great to understand what our community cares about.

We love Looker Studio for data visualization!Turning data into visuals using suitable graphs and charts is a great way to monitor your campaign performance and communicate the results with different stakeholders.This week, we’re bringing over resources to help speed up your dashboards (we see you, we hear you!), and how to build awesome Looker Studio dashboards with data blending. Dig in! 📖 Read:‘How to deal with slow Looker Studio reports’. 📹 Watch: ‘10 Must-know Looker Studio Tips for Marketers’  📹 Watch: ‘Building a Multi-Channel Dashboard in Looker Studio: The Dos and the Don'ts’  

Hey Supermetrics community,I’m trying to import a daily breakdown of Facebook & InstagramAccount name Post date Organic reach Organic impressionsThe aim is to blend this data with GA4 to understand what posts did and did not drive traffic to our website. Unfortunately, this query loads no data. If I remove post date and account name, then the query shows the daily breakdown for organic reach/impressions.Any ideas as to what I am doing wrong? Thanks in advance.

I was recently asked if it's possible to use Tell Me to gain insight into how certain dimension values compare to the dataset's average.Getting the data right is less a chart problem, but a typical "Level of Detail" or "LOD" case. From my designer perspective, it's one of the hardest things to understand. It took me many hours to learn how to do this in Tableau, and I wondered if it could also be achieved natively in Looker Studio without using BigQuery.The short answer is yes, it's possible. Let's look at the following result:  A very simple insight that compares row-level information with an aggregated value of the complete dataset.How can row-level data be compared with aggregated values of the dataset?The solution isn't trivial, and we need to use a Looker Studio technique called "self-join."A self-join is a data blend where both datasets have the same source. To achieve the desired outcome, we need to create a cross-join, which doesn't require any join conditions.On the left side,

I’m running ads on Facebook and Instagram, Is there a metric in the Facebook Ads connector that allows me to see how many followers I gained from my ads? Or do I have to use “Page Likes” ?

What’s up SM community! 👋It’s Edward here from The Marketing Intelligence Show - and we need your questions…We’re going to do a community-led AMA episode on our podcast where we’ll answer questions exclusively submitted by you, our community members.Do you have any questions on marketing analytics, data, AI, the future of marketing measurement, or anything else?Drop your question here in this thread and we’ll answer it live on our podcast and give you a shout out.Over to you...

Looking to start a discussion with the community to exchange knowledge and best practices around PowerBI! Using Supermetrics in combination with the PowerBI platform enables a large variety of insights and visualization capabilities, especially when utilizing the transformation functions each has to offer! See below for some of our favorite features within each platform for transforming data  -  Some transformations are better done in Supermetrics...UNION data blending: While a union is relatively simple to perform utilizing the native capabilities of PowerBI, Supermetrics offers an additional layer of flexibility at the individual field level when mapping data sources together, making custom use cases and workflows much easier and more scalable.  Custom Fields: The ability to transform individual data points into new metrics and dimensions isn’t unique to Supermetrics. However, the simple UI makes it straightforward for non-technical marketers to transform individual data points. Addi

This week, we launched a new Supermetrics for GA4 template that includes tips and tricks on how to use Supermetrics. It is perfect for anyone who wants to see clear examples of how Supermetrics for Google Sheets is used in practice and learn about useful features. On the template, you’ll find:Hints about the Supermetrics features used Clear color coding to differentiate queries from formulas The AI Summary feature, which provides practical strategies from your data to drive growth and success An instructions page with lots of relevant contentThe template should work well for anyone who is just getting started with GA4 and Supermetrics, but we're are also keen in hearing feedback from more advanced Supermetrics users. Is this something you could imagine using for your organisation?

Time for another connector of the month, and this time it’s…. *drum roll* - TikTok Ads!💃🏻 TikTok isn't just for dance trends anymore. Marketers are taking the platform by storm. If you haven't tried our TikTok Ads connector yet, now would be a pretty good time I think. With our TikTok Ads connector you can:Track all key ad metrics: Impressions, clicks, conversions, costs, and more. Granular reporting: Slice data by campaign, ad, time (including hourly!), and demographics. Detailed conversions: Analyze in-app and page event conversions.Have a go, try our TikTok Ads connector here:  https://supermetrics.com/connectors/tiktok-adsOh and we also have a template that you can try for Looker Studio here.Let me know how it goes🎉

Want to unlock even more data in Supermetrics?In this short video, @Valter Andersson explains the new File Import feature. With File Import, you can:Combine data from anywhere: Import data from offline sources or those without a dedicated Supermetrics connector. Consolidate your reporting: Get a holistic view of your marketing performance by bringing all your data together in one place.Ready to try it out? Join our exclusive community group to gain early access to the File Import Beta!  

Last week, I had the privilege of attending one of the most revered events in the advertising industry: the Cannes Lions International Festival of Creativity. Generally known as just “Cannes”, this tentpole event brings over 20,000 industry professionals to the sunny south of France every June to celebrate great works of advertising.  What is Cannes? This trip was a personal milestone for me for several reasons. I first became aware of Cannes when I started at Wieden + Kennedy just six years ago. Walking the hallowed halls of W+K filled with portraits of iconic creative leaders, I quickly picked up on the prestige emanating from the discussions surrounding Cannes. To me as a data analyst, it was an exclusive event reserved for our executives, the business development team and any of the creative teams fortunate enough to have their hard work earn a coveted nomination for a Cannes Lion award.  As I’ve grown in my career, I’ve learned that, for many in the industry, Cannes is a polarizin

Now, with just a few days left before the Universal Analytics API deprecation, I am wondering how everyone dealt with the GA4 transition in their reporting. Did you keep using bounce rate, or did you switch to looking at engagement rate and engaged sessions?This has been a tricky line to navigate while re-creating our old Universal Analytics templates with GA4. Do we keep the metrics just as they were in Universal Analytics? Do we use a mix of both the old and the new metrics? Or do we embrace the change and use the new GA4 metrics exclusively?I'm curious to hear your thoughts.

hi SM team, i didn’t receive the attend link for product updates happening now?

Anybody else getting a 403 error when trying to create a new Moz query in Google Sheets? I’m wondering if it’s related to their recent API updates.

Hey,I'm calling out for help here 👋🏼We’re seeing that the Shopify connector is trending amongst our Supermetrics customers, but I have a feeling that we’re not doing a great job in enabling our customers on use-cases and best practises with this connector. Could you help me understand the value of this connector a bit better?What are the most important use-cases with the Shopify connector? What are things that you can do with the connector vs. in the native platform? How do you use this connector together with other connectors, such as Google Ads, Meta and Klaviyo? Is there anything else that we should take into account when planning for enabling materials?We’re planning to build an e-commerce specific onboarding path for our customers, and your insights will help us to do a better job! 

Marketers typically make 4 types of decisions…1. Tactical decisionsFrequently made decisions using low volumes of data. Things like campaign budget allocation, keyword targeting, or reach and frequency monitoring to optimize ROI.2. Optimization decisionsLess-frequently made decisions using low volumes of data. Things like A/B testing, CRO experimentation, or on-page SEO performance.3. Operational decisionsFrequently made decisions using high volumes of data. Things like outlier detection, inventory based advertising, or internal historical benchmarking.4. Strategic decisionsLess-frequently made decisions using high volumes of data. Things like audience segmentation, demand forecasting, and annual budget allocation.For the first two types of decisions, you need on-demand data that is accessible in raw format. This is typically low data volumes in a spreadsheet or dashboard.For the second two types of decisions, you need centralized data for longer-term historical and seasonal analysis.

Is it still a useful measurement framework or is this the end of the marketing funnel?We’ve been discussing this a lot lately.Marketers have used the funnel to simplify the buying journey and measure marketing effectiveness at each step as prospects got closer to a purchase.But the buying journey is messy. It’s not linear. And they vary wildly from one customer to another.I’d love to know, what do you think? Is it still a useful measurement framework/metaphor or is time to use something else?

This is meant as an open question to maybe get some knowledge exchange going on the topic of dbt and Supermetrics working together.In my team, we have been using dbt for around 3 years now to write data models and schedule update job runs on data warehouses which we are building for our services clients. It quickly became one of my favourite data tools that I genuinely enjoy using 90% of the time (10% not, when I’m frustrated about the UI freaking out).The other week I’ve used Google’s Dataform for the first time and got some ‘we have dbt at home’ vibes from it, although it has pretty good feature parity with dbt.Is anyone here also using one of these? If so, what’s your approach in case you’re using it on top of Supermetrics data? Should we look into publishing dbt model templates and recipes that leverage either custom queries or our standard table groups?

Hi Data Friends, Does anyone know if we can pull Shopify conversion summary data into google sheets? I want to see how many sessions in took some one to convert. Please see screenshot.   

Sure, marketing data is important — but how you present your data is what makes it shine! ✨Whether you’re presenting data to internal stakeholders, analyzing it to aid decision-making, or even communicating data to your customers — what’s important is presenting it in a manner that’s easy to digest and understand.Here’s a roundup of our best data visualization resources to help you really tell the story of your data! 📖 Read: ‘How to build an ecommerce dashboard in Google Data Studio’.  📖 Read: ‘Data visualization for marketers: 6 steps to present data visually’.   📹 Watch: ‘Data visualization in Looker Studio: Better dashboards with Supermetrics Charts’:  

If that’s the case, what’s your #1 must know spreadsheet tip for marketers?To get the ball rolling, here are 10 (yes 10) Google Sheets tips for marketers from a webinar we did last year...  Can’t wait to hear all your spreadsheet tips! 📈🙌

Have you noticed all the cool stuff the Google Sheets team at Supermetrics has been adding to the sidebar?From suggested queries to quick access to reporting templates, the Supermetrics for Google Sheets sidebar has experienced a massive facelift.Check out the video below to see a quick before and after and take it for a spin! Also, let us know kind of suggested queries or other functionality you'd like to have added 👀