Community

Recently active
Help others
Categories

xuchen1987Newbie

the ga4 product does not offer a native bq backfill, therefore, i'd want to understand the exact schema of the data this is offering since supermetrics is doing some "magic" to backfill the data. if it's 100% the same as the native ga4 bq export.

18 hours ago

KennethCommunity Moderator

BigCommerce and Zoho CRM are now available in Early Access!

Connector alert – BigCommerce and Zoho CRM are now in Early Access! 🛒 Unlock the power of your ecommerce data with BigCommerce. Seamlessly pull in your sales, orders, and customer insights from this popular platform to gain a comprehensive view of your online sales.💰 Fetch CRM data from Zoho CRM to optimize marketing campaigns, improve ROI, and accelerate sales. These connectors enable powerful new use cases including:🔍 Analyze sales performance trends to improve your marketing and business strategies. 📊 Combine insights: Combine your sales and marketing data to see how your initiatives are influencing sales. 🎯 Actionable data: Make data-driven decisions and use 1st party customer data to improve your marketing targeting.Try these new connectors now – authenticate in the Supermetrics Hub and start reporting! 🎉

1 day ago

AuroraCommunity Moderator

What's new at Supermetrics November 2024

What’s new at Supermetrics in November 2024A new month means new product updates. In this edition, we’ll talk you through the latest data blending feature, new connectors, the SuperSummit event, and more!Data Blending Joins is now released We’re excited to introduce Data Blending Joins in Supermetrics! While our Data Blending Unions lets you combine similar data sources, Joins takes it further by allowing you to connect data from entirely different platforms—like matching paid media channels with Salesforce to see your ROAS. You can analyze cross-platform performance and customer journeys with a whole new level of depth and create attribution reports more easily than before! 👉How to create a join? Read our support article. Supermetrics recognized in Snowflake's 2025 marketing reportSupermetrics is proud to be featured in Snowflake's 2025 Modern Marketing Data Stack report. This inclusion highlights our dedication to helping marketers maximize the value of their data in Snowflake.We’r

1754

1 day ago

MiljaCommunity Moderator

Tips and tricks

Let’s talk campaign naming conventions!

Hi Supermetrics Community! 👋Ever struggled with campaign names that make your reporting a nightmare? I know the feeling, which is why I recently wrote an article about smart campaign naming conventions to help marketers like us streamline our data analysis.In the article, I cover:✨ Structuring campaign names hierarchically for clarity✨ Key-value pair vs. delimiter-based naming methods✨ How to integrate naming conventions with UTM parametersI also included:✔️ A free campaign naming template✔️ A quick tutorial to help you implement itOne challenge I faced while writing this was striking the right balance between granularity and simplicity—especially at the ad group level. Ultimately, I chose a method that worked for me, but naming conventions are never one-size-fits-all.💡 Now, I want to hear from YOU!How do you approach naming campaigns and ad groups? Do you prefer key-value pair methods for flexibility or delimiter-based ones for simplicity? What’s your biggest challenge (or success)

200

1 day ago

someshNewbie

Ask the Community

Addressing Duplicate Impressions in BigQuery from Google Campaign Manager 360 via Supermetrics

Hi everyone,I wanted to share an issue I encountered with duplicate impressions in BigQuery when using Supermetrics to pull data from Google Campaign Manager 360 (CM360) and DV360. After verifying the Supermetrics logs, everything seemed correct, but duplicates still appeared in the final dataset.Has anyone else encountered similar issues? Would love to hear your experiences and solutions!Thanks!

2 days ago

SahraCommunity Moderator

Ask the Community

SuperSummit APAC is LIVE! 🚀

Who's joining us today from the APAC SuperSummit? 👋Share your favorite thing from the summit or a key takeaway with the community!Raise your hand if you joined the session today to earn the SuperSummit badge! 🏆Why join SuperSummit APAC?Learn from industry leaders like Google, LinkedIn, and more Get actionable insights to boost your marketing strategy Connect with a global community of data-driven marketersDon't miss out! tune in on here!

7810

4 days ago

jessicawSupermetrics Team

Action required: Update to the new outbound proxy IP addressesNews

Whitelist our new IP address range to avoid service disruptions For data warehousing users who are whitelisting our IP addresses, here’s the upcoming change to our outbound proxy IP addresses that may affect you if you're whitelisting our IP addresses. ✋We'll update our outbound proxies' static IP address range to maintain a secure and reliable network infrastructure that meets our customers' needs.Please add the following IP address range to your whitelist in time. The cutover time is 14th January 2025, when the following IP addresses will become active. 18.202.154.254/32 34.255.31.19/32 52.50.123.181/32 54.246.196.255/32 54.73.205.239/32 54.75.114.151/32 34.140.128.0/24 34.48.0.128/26 Don’t forget to add your own IP address. See the support article for a complete list of IP addresses to whitelist: https://support.supermetrics.com/support/solutions/articles/19000143869 We encourage you to take the necessary steps to update your systems as soon as possible in order to avoid service dis

5 days ago

duncan_teepsNewbie

Data visualization

Gather Facebook Comments and its informations

Hello,I was wondering if it is possible to gather the comments of an ad through the Supermetrics API. Specifically, I would like to retrieve the content, its ID, and perhaps its parent ID. Currently, we are only able to get the number of comments.Is there any way to achieve this? If not, is it planned to be added in the future?I couldn’t find the relevant field in the documentation here: https://supermetrics.com/docs/integration-facebook-ads-fields/#fieldThank you very much.

281

6 days ago

LukasNewbie

Tips and tricks

Custom Conversion: Display of conversion value and number of conversions for a specific product in Looker Studio

Hey guys, first question in the community, so I hope I'm putting it in the right place. 👀 We are trying to display a product-specific conversion value and the corresponding conversion number from a META ad campaign in Looker Studio. We are able to do this for the overall conversion value and the total number of conversions for the campaign. However, we are advertising product A, for example, and only want to receive the conversion value and the number of conversions from the sales of product A. The values are displayed in the META ad manager with the help of the corresponding custom conversion. Which parameter/filter can we use to display these values in Looker Studio? The product we use is Supermetrics for Looker Studio, so we don’t use Google Sheets in between. Many thanks in advance for any tips, tricks or anything else that could help us. 😀 Cheers,Lukas

171

6 days ago

MariiaCommunity Moderator

Trends and hot topics

🏆 Share your main SuperSummit 2024 takeaway for a chance to win a prize 🏆 (ended)

We hope you had a chance to join us for the SuperSummit 2024 😍 Don't worry if you couldn't attend live — we saved all the sessions for you here. We’d also like to invite you to take part in our Community Challenge for a chance to win a fabulous gift box full of goodies How to take part in the Challenge?In the replies to this post, share your biggest takeaway from any of the SuperSummit 2024 sessions. Mention which session it was. Give likes for the takeaways shared by other Community members that you find insightful. The person who shares the most upvoted takeaway will be awarded a gift box worth $150. ⏳ This challenge ends on November 14, 2024. Good luck!

51016

6 days ago

xuchen1987Newbie

Data transformations

GA4 to BQ backfill schema

18 hours ago

someshNewbie

Ask the Community

Addressing Duplicate Impressions in BigQuery from Google Campaign Manager 360 via Supermetrics

2 days ago

duncan_teepsNewbie

Data visualization

Gather Facebook Comments and its informations

281

6 days ago

LukasNewbie

Tips and tricks

Custom Conversion: Display of conversion value and number of conversions for a specific product in Looker Studio

171

6 days ago

ExequielDucartNewbie

Spreadsheets

Appsflyer/GoogleSheets - timeout error | Solutions

Hi everyone,I’m facing an issue with an AppsFlyer query in Google Sheets that triggers a timeout error (Error: AppsFlyer failure - Data Source Error: Gateway Timeout). This problem has been ongoing for over a month and is specifically affecting certain accounts, while other AppsFlyer accounts work fine without any issues.Despite following the recommendations provided by the support team and trying shorter date ranges, the error persists. Additionally, I was informed about a 90-day limit for event data, but this doesn't seem to apply in my case, as I’m using the segment for other accounts this year up until the current date.The Supermetrics support team is investigating the issue, but I wanted to ask if anyone in the community has experienced this type of error and if they have any additional suggestions or possible solutions to resolve it, as this is a critical function for our work.Any help or recommendations would be greatly appreciated.Thanks in advance!

110

9 days ago

datamgtNewbie

Spreadsheets

Supermetrics Query Is Not Pulling All the Data From the GA4 platform.

The number of sessions is just a fraction of what it should be. I go to the GA4 and see a higher session count for the Paid Search, Organic Search, Unassigned, Direct, Referral and Organic Social category sessions. The amount in these categories from the SuperMetrics Query into our Google Sheet is underreporting what is in the platform. I tried 2 different accounts and several refreshes. We have no filters that are obvious to me.

452

15 days ago

brittany_LHNewbie

Data visualization

Error extracting email address data from Klaviyo

I’m trying to extract email address data from the Klaviyo connector in Looker Studio, but it keeps failing no matter how few or how many other dimensions/metrics I try. I want to use email address data to blend with other data sources, but without this data from Klaviyo, I can’t do that. I also can’t build a table with the raw data from Klaviyo using the connector either. I initially thought I was just trying too bring in too much data, but now I’m not sure? TIA

201

29 days ago

maryanNewbie

Data visualization

Looker Studio | Instagram Insights Not Working

Hey community!Does anyone know why Instagram Insights are showcasing incorrect data in my Looker Studio doc?Ie. For two different time periods (one last year, one this year) data is staying the exact same. In simple terms I am trying to showcase the increase in account followers across two different time periods. Any help would be greatly appreciated thank you!

472

1 month ago

SenniCommunity Moderator

Tips and tricks

Best resources to get started with Supermetrics?

Hey Community! 👋I've noticed a lot of great resources online for learning how to get the most out of Supermetrics. To help us all level up our skills, I'm creating a thread to collect the best tutorials, tips, and case studies.Let's start with this helpful YouTube video: This video provides practical advice on structuring reports for paid advertising analysis in Facebook & YouTube Ads.What are your favorite Supermetrics resources? Share your tips, tricks, or favorite tutorials below!

483

1 month ago

6clickzNewbie

Spreadsheets

Facebook ads connection error in all recurring reports

I have an issue in all of my reports where I use Facebook ads. I've been using them for months and 2 days ago they all went broke with the same error. Facebook error: User may not have permissions to access account act_336487693. But I can't loose access to all ad acounts at once. I checked that and re-authorized all but nothing works.When I try to edit query and choose ad account I see this message: Invalid appsecret_proof provided in the API argument. What should I do? I can't switch connection in every report.Thanks for the help!

402

1 month ago

Ask and discuss

Ask questions from other community members and share knowledge

Data visualization

32 topics
35 Replies

Spreadsheets

20 topics
30 Replies

Storage solutions

1 topic
0 Replies

Data transformations

4 topics
5 Replies

Trends and hot topics

39 topics
60 Replies

Tips and tricks

24 topics
52 Replies

Ask the Community

34 topics
85 Replies

Welcome guide

Everything you need to know to get started

Ask and discuss

Data visualization

Spreadsheets

Storage solutions

Data transformations

Trends and hot topics

Tips and tricks

Ask the Community

Welcome guide

Getting started with the community

User leaderboard

Earn points by answering questions or starting new conversations

Latest News & Updates

Community

User leaderboard

Earn points by answering questions or starting new conversations

Latest News & Updates

Sign up

Ask questions from other Community members, comment on other people's posts and get access to exclusive Community content by logging in.

Log in to Supermetrics Community

Ask questions from other Community members, comment on other people's posts and get access to exclusive Community content by logging in.

Scanning file for viruses.

This file cannot be downloaded