Community Newsletter - July 2025
Ask questions, get answers and engage with your peers
Hi! So right now I have a problem with Bing Ads, that when I select All Accounts, some account are invalid, so query gets error. And solution, to manually select accounts, isn't really a solution for a dynamic Advertising Company, where accounts can come and go.I know this is possible, considering Google Ads has that option already, as well as trying to connect to the Bing Ads through API, I can set a trigger to skip inactive ad account. This is BTW, idea for everything, Google Sheets and Looker Studio, and for all connectors.
My suggestion is to add a connector/data source to Pxsol (pxsol.com), an hotel booking motor, popular in Argentina and other Latin American countries.
TikTok Shop has gained some popularity in our country, and the system currently supports creating ads for TikTok Shop. Additionally, there are specific events related to TikTok Shop that are not yet visible in Supermetrics. Having access to these metrics would be highly beneficial, as it would help us optimize media performance and guide our business decisions regarding budget allocation and overall strategy.Examples of the metrics we would like to see in this data source include: Purchase (Shop), Purchase Value (Shop), Average Revenue per Purchase (Shop), and others.
There is existing functionality to add Facebook’s Ad Name into my Supermetrics blend, but there isn’t an equivalent for Adword’s Ad Name (see below). What i want is the name of the ad (not the ad set name, not ad group name, not ad set name) . And that’s possible according to Google (see below).The link to their documentation is here
Encountering a "You do not have access to Google Docs" error when using Supermetrics can be frustrating, especially when you're trying to pull vital data! This specific error message typically means that your organisation's Google Workspace administrator hasn't granted the necessary access to documents within your Workspace environment. Don't worry, the fix is straightforward! 💪 Understanding the issue 🤔 The error message "We are sorry, but you do not have access to Google Docs. Please log in to your Admin console to enable Google docs." directly points to a permissions issue at the Google Workspace level. Essentially, for Supermetrics to interact with your Google Docs (including Google Sheets), the overall Google Docs service needs to be enabled for users in your organisation by an administrator. The simple fix for administrators 🛠️ If you are a Google Workspace administrator for your organisation, you can resolve this error quickly by following these steps: Log in: First, log in a
To improve your Snowflake data source user experience, we have released a new Snowflake data source. The new Snowflake data source is available in all of our destinations.With the new Snowflake data source, you can:Easily fetch data from your Snowflake tables with a few clicks – no SQL required. Transfer data from Snowflake to all of Supermetrics’ supported destinations, including data visualization tools, spreadsheets and data warehouses. Combine data from Snowflake with other platforms using data transformation features like Data Blending. Pull 1st-party customer data from Snowflake to be activated in marketing platforms.The existing Snowflake data source is now named Snowflake (Legacy), and the new Snowflake data source is called Snowflake.We recommend switching to the new Snowflake data source for a better user experience.To do this, search for the Snowflake data source in your Supermetrics destination, connect your account, and re-create your queries.If you have any questions, don
Things that seem out of place or problematic, sometimes only the user can find the clues or cause of the problem, so reporting what happened can help to resolve the issue faster and more accurately depending on the user's report.
I've noticed that there are few messaging fields missing from your facebook ads connector - mainly2 message exchanges and 3 message exchanges, ect.When do you expect this fields to be added to your Facebook ads connector?Thank you in advance
Tired of scattered data and incomplete insights? Supermetrics Custom Data Import is your secret weapon! 💪 It's a game-changer for bringing all your marketing data together, giving you a crystal-clear, holistic view of your performance. Whether it's offline campaign stats, CRM nuggets, or even those crucial seasonal sales figures, Custom Data Import effortlessly blends it with your existing Supermetrics data. Say goodbye to data silos and hello to unified understanding! 👋 Getting started is a breeze! 🌬️ Leveraging the power of Custom Data Import is a straightforward journey on the Supermetrics Hub. Here's your quick guide: 1. Configure your data import 🛠️ This is where you set the stage for your data flow. It's all about telling Supermetrics what to expect: Upload an example file: 📂 First things first, drop in a sample CSV, TSV, XLS, XLSX, or ODS file. This helps Supermetrics understand your data's unique structure. Define data types: 📏 Tell us if each field is a metric (a numb
How about adding source/medium metrics to the Matomo connector in Looker studio? It’ll be very useful for more in depth analysis.
Hey all! I’m having issues with the Reddit Ads Supermetrics Looker Studio connector - I am tracking custom events but can’t seem to find any guides on how to make sure these are getting pulled in my reports. Can someone please help? Thank you!!
Hi! Im filtering my data and would like to know how to you use here: Filter________________________IS there a boolean for this?example: “SOURCE OR SELL OR LIKE”________________________ And if I use this regex “contains” or “doenst contains”: do we have some kind of character limits or prohibited? Thanks,
Hello all, Any of you have been experiencing issues when you try to run a query in Instagram Insights for Views and filter by product type REELS? It gives me zero results even if I have thousands of reel interactions and you can see the video has million of video views. Thanks!
Hello,is it possible to run a supermetrics query directly with PowerQuery inside of Excel? It seems I can only return the query results to an Excel sheet but not into PowerQuery. But maybe there is a workaround?Thanks!Matthias
We have just recently subscribed and setup our GA4. Under the Campaign Performance tab, we are not able to see conversions. Maybe because it is now called events? We are not technical people and have little to zero background on GA4 and Looker.
Hello,Would like to understand how can we pull the Cohort data into Supermetrics from Appsflyer. This is basically to calculate the ROAS and LTV for D3, D7, D28 etc for better campaign management.
I swear I had this working, and now all of a sudden now I can’t get it to work.I have google ads for video, display, and search. How do I pull a query for only Search etc? I did the network type (with and without search partners) and tried “contains” or “matches regex” etc and can’t get the query to pull. It will just keep giving me an error
Hi,I’m wanting to query for asset_group_asset in Google Sheets. Is there a way to do this today, or any plan to add this capability? More info here: https://developers.google.com/google-ads/api/performance-max/reporting#asset_performancety
Currently, I always create the following manually: I download all keywords that are neither excluded nor added to an ad group and then create a pivot table to display all search terms with more than X clicks. The pivot table is therefore relevant because search terms are only displayed once - Google usually displays them more than once.Can I do this automatically via Supermetrics in looker studio? So far, I have only found “Matched Search Terms” in Supermetrics, which are exactly the search terms I don't want.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.