Ask and discuss

Hi teamHow do I pull a query for all Shopify accounts under our Shopify Partner account?  When I create a query, it only gives me the option to select an individual account (71 accounts total), but I can’t choose the partner account that all the Shopify accounts sit under.  Like with Google ads, I can choose our MCC email account where all the ad accounts sits under. I want to do the same thing for Shopify. Thank you!

 We’re happy to invite you to a panel discussion: Looker Studio for Marketers.  What? Panel discussion: Looker Studio for MarketersWhen? August 14, 2024, at 10 a.m. EDT | 3 p.m. BSTHow to register? 🔗 Click ATTEND hereWill I get a recording? Yes, by registering in advance. In this session, our panelists @Ilkka Sarkio, @arturbensch and Qudees Tariq Kiani will talk about:The best practices to tailor your Looker Studio dashboard. The tips on how to build actionable dashboards. The Looker Studio hacks we all wish we knew sooner. See you there! 

It would be very helpful if I could trigger a refresh all of a google sheets query set via a google sheets script. Has anyone found a way to do this? 

Two weeks ago, we invited you to participate in the Supermetrics Community MVPs Competition by being active and earning points.  During these weeks, we were closely following the leaderboard and now are ready to announce the top 3 Supermetircs Community MVPs. 🥇 The first place goes to @nitinvarghese! You've been an absolute champion, and we're happy to reward you with a $150 gift card. 🥈 The silver medal goes to @gcfmineo! You've been active since the day you joined our Community. We greatly appreciate you, and reward you with a $100 gift card.  🥉 Our third leader is @RickM! Thank you for your active participation in the Community — it means a lot to us. We’ll reward you with a $50 gift card.  We'll contact you all by email soon about the details of rewards. Everyone who climbed the MVPs leaderboard, don’t worry — your points accumulate. So keep earning them and get an advantage in the next MVP competition 😉 

 As a young Community, we value your active participation. Your knowledge, questions, and feedback help us create a supportive and insightful environment.  Thus, we're excited to launch the Supermetrics Community MVPs Competition 🏆 Every action you take in the Community earns you points! Whether that’s from creating new discussion topics or providing helpful answers to questions, you’ll climb our MVPs leaderboard for the chance to win gift cards. The leaderboard is always visible, either on the right-hand side of the Community's main page or here, so you can follow the results in real-time 🍿 But let's get to the point. How do you earn the points?Create a new topic / Ask the Community = 20 points  Reply to a question post = 15 points  Reply to any kind of post = 10 points  Receive a like = 5 points  Give a like = 1 point  Overall, the more active you are in the Community, the more points you'll rack up and the higher you’ll climb on the leaderboard! The top 3 winners on the leaderboar

Looker Studio has added two new calculated field types in the past month: groups and bins. These features make it easy to group dimension values into larger categories or bin values to create histograms. In a recent article, I covered how to use the graphical UI to create bins. Let's also take a quick look at how to create groups.Creating GroupsWhen creating a new field of type "group," you must choose a dimension field and define each group. The options are similar to filters. You can create groups by inclusion or exclusion and use different selection types, such as regular expressions or a new option called "In," which lets you manually select the dimension values.Tip: Country groups can be created using the "In" option A workaround for previously aggregated dataThe article could end here, but there are cases where it isn’t possible to use the graphical interface to create bins. Common use cases involve data from GA4 connectors, where many metrics are pre-aggregated. For example, the

Hi!I am struggling with adding the following metrics from Facebook Insights page to my Power BI report based on SuperMetrics data: Content Interactions (Facebook); 3 second video plays (Facebook); Content Interactions (Instagram).Are you able to help me? I am eaither not able to find these metrics or the metrics are not in line with Facebook Insights page.

Does anyone know how to have creative images show in Looker Studio? -I’v tried these two method and I can’t get it to work. The images don’t show on the tablehttps://help.funnel.io/en/articles/5102984-how-to-show-ad-images-creatives-in-looker-studio

We’re back again with another “Connector of the Month” and this time it’s……. HubSpot!🤖 HubSpot has revolutionized marketing by offering a unified platform for CRM, marketing automation, sales, and customer service. Unlock the full potential of your HubSpot data with our powerful data source connector. With this connector, you can:Centralize all key metrics: pull and analyze different data, such as contacts, leads, amount won, and email engagement from multiple HubSpot accounts in one single view Visualize your full funnel: combine HubSpot data with those from other marketing channels to understand which campaigns are bringing the most leads and the ROI of your overall marketing activities Uncover insights seamlessly: create complex and interactive client-facing dashboards that drill down data on a granular levelYou can try our HubSpot connector free for 14 days, start today. Just click here to get started.Let me know how it goes!😊

With Universal Analytics now officially retired as of July 1st, many marketers are finding themselves in uncharted territory with GA4.  If you're still getting to know GA4, you're not alone. This new version brings many changes and improvements, but it can initially be overwhelming.  Here are our resources to help you navigate the transition smoothly and make the most out of GA4's powerful features! 📖 Read: ‘Google Analytics 4 guide for marketers: How to set up your properties and make the most of your GA4 data’. 📹 Watch: ‘How to visualize your GA4 data in Looker Studio using user journey visualizations’:  📹 Watch: ‘How to check that your GA4 setup is correct with Online Metrics audit tool’   

Google announced last week that it will not proceed with deprecating third party cookies, a stark reversal from its messaging around the topic for the past four years. In a blog post authored by Anthony Chavez, a VP at Google in charge of Privacy Sandbox, the following quote summarizes their position:“[W]e are proposing an updated approach that elevates user choice. Instead of deprecating third-party cookies, we would introduce a new experience in Chrome that lets people make an informed choice that applies across their web browsing, and they’d be able to adjust that choice at any time. We're discussing this new path with regulators, and will engage with the industry as we roll this out.”There’s a lot to unpack. Let’s rewind and take a look back at how we got here. What are third-party cookies used for? Cookies are small pieces of information stored in your browser to personalize your web browsing experience. First-party cookies are set by the domain of the site you’re visiting, while

 Say hello to our connector of the month for June: GA4! To no surprise to anyone, Google Analytics 4 is the most popular web analytics tool out there. The tool allows its users to track website events and analyze how the website is converting visitors. The Supermetrics GA4 connector allows you to export data for further analysis and report multiple properties simultaneously in one report and in a reporting tool of your choice. We’ve put together some useful resources around the topic in our Google Analytics 4 knowledge center: Find everything you need about GA4 migration, including blog posts, video tutorials, and support articles.And don’t forget to try our GA4 connector!

Now and then, Looker Studio sneaks in a new feature before updating the official release notes. The same happened yesterday when a new feature suddenly popped up when one tried to create a new calculated field: "Add bin."If you click this new option in the drop-down menu, you'll see a new interface for easily creating bins.What are bins?Bins in data visualization are like containers that group similar data points, helping to show how data is distributed in a chart, such as a histogram.To create a real-life example, I asked ChatGPT to create a small dataset containing 150 shopping carts with the number of items each cart includes.To visualize such a dataset, you would use a histogram. But before, you would need to "categorize" these numbers. We'd have used CASE statements within a calculated field for this task. Now, we can use a graphical interface.There are two options to create the bins: Equal-sized or custom-sized. Thew new “bin” interface.Once you have created your bins, drop the n

Does anyone have any tips for creating the best useful LinkedIn analytics dashboard for a paid social strategist?

Hi!After a decade in the space, I’m curious to see how others are solving a problem that’s fairly unique to agencies, since we deal with many different types and sizes of budgets. While account team members are responsible for tracking budgets on a project or yearly basis, it’s the traffickers/specialists’ jobs to track budget on a line/campaign/ad set level. However, when teams are in need of growth, capacity issues can make this last bit difficult. One approach I’ve worked on is generating risk reports, which call out which campaign lines are at risk of under-delivery, over-delivery, or ending too soon, which can throw off the campaign. These often come with a column to flag what the issue is, and how big of a risk it might be. For example:Client Campaign Start End Spend Risk Level Issue NuCo Summer 7/1/2024 7/31/2024 $503 High Underpacing BrandB Prospecting 6/3/2024 8/5/2024 $625 Medium Overpacing  From here, the account team will jump in and e

Supermetrics community,A couple of years ago using Supermetrics and Looker Studio, I have always preferred transforming/blending data in Google Sheets before importing to Looker Studio to improve the load times of Looker Studio visualisations.As it’s been a couple of years since I’ve used Supermetrics, and just jumping back in, does anyone have best practice guidelines, or their own processes, to have fast load times in Looker Studio? I used to find the native connectors slow to load, especially if blending was involved.Thanks in advance,Craig

Three weeks ago, I wrote a post linking to a dashboard that tracks the Tour de France's overall standings, featuring the new Supermetrics bump chart. Now that the tour is over, we can see how riders have moved up and down the overall standings. The interesting question in dashboarding is what we can see in a chart and what contextual information we need to add in the form of annotations. During the past three weeks, I have been taking notes about what happened at each stage as long as it impacted the chart. Then, I looked for an efficient way to add these annotations to the dashboard.After evaluating several alternatives, I slightly misused an interactive bar chart and combined it with our Tell Me chart. Report viewers can now click the little green squares to read some contextual information explaining the chart's events.At Supermetrics, we may not focus much on the Tour de France, but the same principle can be applied to tracking ad campaigns. Changes don't just happen for no reason.

Spend more time analysing your data, not pulling it from the platforms!I’ve created a video here to show you exactly how I collate daily data automatically. If you’re like me, managing multiple social media platforms,you know how insightful but time-consuming manual reporting can be.Let me show you how you can use Supermetrics to do this for you..it’s a game-changer!Easily see:video views,profile views,engagement,likes,comments,shares,new followers,and current followers.👉 Use the data to analyse which content performs best and why so you can adjust your future content strategy.👉 Adjust the settings so you have new updated data daily.👉 Enable email notifications for any query failures to ensure your data is always up-to-date.I believe that social media managers shouldn’t spend hours pulling data,—they should spend their time analysing it to gain actionable insights.With automatic updates,you always have the latest data at your fingertips,allowing you to focus on what matters most:👉

Hi team, why would a log in of name@domain.com become namedomaincom@gtempaccount.com? What would be causing this? How do we go about resolving/reconciling this second account login to our actual name@domain.com team?Many thanks!

Hey there, 👋 A little bird told me that many people may not know about the Supermetrics blog and the content we consistently published there. It’s a curated library where you can learn (almost) everything you need to know about marketing analytics and measurement.I thought I could start a series where I share top content from every month. Let’s kick this off with July.How to deal with slow Looker Studio reportsYou’ve probably noticed that Looker Studio (Data Studio) dashboards can sometimes take their sweet time to load 🐢Slow load times are typically a symptom of Looker Studio fetching a large volume of data directly from the original data source. In this article, we’ll discuss two methods you can use to speed up your reports, including:Using Google’s Extract Data connector Using Supermetrics StorageRead the article 🤓Incrementality testing for marketersIn marketing, we often rely heavily on metrics that indicate direct conversions—whether it’s a purchase or an app download. But what

I’m looking into upgrading my free trial to the core subscription. The question I have is how does Data Source Account usage work? It says there are 26 data sources and 8 data source accounts allowed per data source. I only need 1 data source: Facebook Ads, but I have over 50 ad accounts I have access to and need data for. My question is are the data source accounts shared between data sources? Aka if I only use the Facebook Ads data source could I have 208 (26*8) data source accounts connected to it? If I can only have 8 accounts connected to it that would be a deal breaker for me and I will need another solution. If they are shared across like that then I’m all in!