Community

Recently active
Help others
Categories

Shopify Order Transactions / Refunds data with refund timestamp to BigQueryNew

Hello Supermetrics Support,We’re using the Shopify → BigQuery connector. Our current exports include Returns at the order/line level but do not include refund timestamps. As a result, we can only attribute refunds to the order date, which does not match Shopify’s Analytics (which attributes refunds on the refund date). This causes material discrepancies in daily Net Sales and share metrics.We’d like to request a new Transactions / Refunds dataset (or an extension to the existing Shopify schema) with event-level refund rows and the following minimum fields:Required fields order_id (Shopify order ID) transaction_id (if available) transaction_kind (e.g., refund, refund_sale, etc.) processed_at (refund timestamp; created_at also acceptable) amount (refund amount; positive number preferred or documented sign convention) currency (shop currency of the transaction) (optional but helpful) reason, payment_gateway, user_id (who processed it) If there’s an existing way to get this vi

10 hours ago

EdnaAltenwerthNewbie

Ask the Community

Looking for Supermetrics Consultant - Marketing Data Integration & Reporting Optimization

We're looking to optimize our existing or implement new Supermetrics setup and need expert guidance on marketing data best practices. Seeking a consultant with 1-2 weeks availability to help us:Develop comprehensive marketing data integration and pipeline strategies Set up advanced data transformation, blending, and automated reporting frameworks Optimize dashboard creation and cross-platform analytics in preferred visualization tools Implement scalable data management solutions and standardized reporting workflows Train our team on platform best practices and marketing intelligence optimizationExperience with similar Supermetrics implementations and proven marketing analytics expertise preferred.

1 day ago

SahraCommunity Moderator

Getting Started

Supermetrics Connectors ➡ Every Data Source You Can Tap Into 🚰F.A.Q.

To get a complete picture of your marketing performance, you can't rely on just one or two data sources. You need to pull data from every platform, channel, and tool you use. That's the core mission of Supermetrics' connectors. With a massive library of integrations, Supermetrics ensures that you can tap into every data source that matters to your business, bringing all your insights into one unified location. 🤝 More than just connectors, they're your data lifelines 🔗 A Supermetrics connector isn't just a simple link. It's a powerful tool designed to pull granular, ready-to-analyze data from your favorite marketing and sales platforms. This allows you to centralize your reporting and move beyond data silos to get a holistic view of your performance.Our library of connectors spans a wide range of categories, ensuring you'll find the ones you need: Paid Media: From core platforms like Google Ads, Facebook Ads, and Microsoft Advertising to specialized ones like Pinterest Ads, TikTok Ad

2 days ago

AuroraCommunity Moderator

What’s new at Supermetrics in September 2025News

Happy September! 🍂 We've been working hard to make your workflows faster and easier. This month, we're thrilled to introduce a new, AI-powered knowledge base that puts the answers you need right at your fingertips. We've also updated our platform with a refreshed look for data transfers and released new data sources to help you get more from your marketing data.What’s inside:📝 New AI-powered knowledge base: Get instant answers and step-by-step guides for mastering key features. ⚡ Refreshed data transfers UI: A new, cleaner look with a "pro tip" for quickly filtering runs with issues. 📣 New early access data sources: We've launched new connectors, including Walmart Connect, Wix Commerce, Centra, and Eskimi. 💥 Top blog articles: Deep dives on data visualization, data quality, and improving your ad performance. 👫 Upcoming events: We're hitting the road in September! Find us at DMEXCO, Shoptalk Fall, Technology for Marketing, and more.Check out our new knowledge base!You told us what

2190

2 days ago

SebNewbie

TikTok Support Adds to wish list (website) metricNew

Support Adds to wishlist (website) metric

3 days ago

annika.oksanenCommunity Moderator

Introducing the new Supermetrics knowledge baseNews

Find answers faster: Introducing the upgraded Supermetrics knowledge baseEver hit a roadblock in your report and wished you could get instant help without waiting for a support ticket? We’ve all been there. That’s why we’re excited to introduce the completely redesigned Supermetrics knowledge base, your 24/7 source for guides, tutorials, troubleshooting tips, and best practices.Think of it as your new go-to guide, your ultimate cheat sheet, and your personal support team all in one place. We built the knowledge base to help you get the answers you need, exactly when you need them.Say hello to the brand-new, completely redesigned Supermetrics knowledge base! So, what's inside?Here’s a peek at what you’ll find:Step-by-step guides: Whether you're connecting a new data source or exploring an advanced feature for the first time, our walkthroughs will guide you from start to finish. No guesswork needed. Quick-fix troubleshooting articles: Find solutions for the most common issues and error m

180

3 days ago

JoellNewbie

Callrail Text ActivityNew

Hi all,I’ve been using the Callrail connector for Power BI to report on phone call data but I haven’t been able to find out how to pull in text conversation data. Is there a way to do that now? If not, is there a plan to make it available in the future?

7 days ago

Sonja KukkulaCommunity Moderator

Wix Commerce, Centra, and Eskimi are now available in Early Access!News

Wix Commerce, Centra, and Eskimi are now in Early Access. Connect to Wix Commerce to retrieve your sales, orders, and customer data.Orders reports: Fetch detailed data on all orders placed within a certain time frame. Sales trend analysis: Track your sales trends to optimize business and marketing strategies. Unified data view: Combine your Wix Commerce data with paid advertising and marketing data for a centralized view of your performance across multiple storesSee all available fields here.Connect to Centra to retrieve your product sales and order data.Order and return item reports: Measure your product sales and returns over a specific time period. Performance trend analysis: Track your sales trends to optimize business and marketing strategies. Centralized data view: Combine your Centra data with paid advertising and marketing data for a unified view of your performance across multiple stores.See all available fields here. Connect to Eskimi to analyze your programmatic advertisi

7 days ago

SahraCommunity Moderator

Getting Started

Auto-Refresh Google Sheets with Supermetrics: Never Use Stale Data Again 🗓️F.A.Q.

Manually refreshing your reports every morning is a chore no marketer should have to endure. Nothing is worse than making a decision based on stale data. But what if your Google Sheets reports updated themselves automatically while you're away? With Supermetrics, they can! Automated scheduled refreshes are your ticket to always-on, up-to-date marketing reports, ensuring you never miss a beat. ⏰ How to set up a scheduled refresh ➡️ Creating a scheduled refresh for your Supermetrics queries in Google Sheets is straightforward. Open the Supermetrics sidebar: In your Google Sheet, open the Supermetrics add-on and navigate to the Schedules tab. Create a new schedule: Click on Automatic refresh. You will be able to set the frequency for your reports. Depending on your subscription, you can choose a daily, weekly, or even hourly refresh schedule. Manage your schedules: Once created, you can manage all your scheduled refreshes in one place. Simply go to the Schedules tab and click View all

8 days ago

COURTNEY PIERCENewbie

Feature Request – Add Fields to Identify B2B and D2D Orders/Customers in Shopify ConnectorNew

I would like to request an enhancement to the Shopify connector. Currently, it is not possible to clearly identify whether an order or customer belongs to B2B or D2D. Use case:These fields are essential for distinguishing between B2B and D2D sales in reporting. Having this information will allow us to: Segment sales data by customer type Track performance by business model Improve accuracy in sales and operational reporting

170

13 days ago

EdnaAltenwerthNewbie

Ask the Community

Looking for Supermetrics Consultant - Marketing Data Integration & Reporting Optimization

1 day ago

SahraCommunity Moderator

Ask the Community

We Want to Hear from You!

Hey, Supermetrics Community! 👋 Happy Friday! We're back with a quick reminder about our community survey. Your feedback is incredibly valuable and helps us make this a better, more helpful space for everyone. We've got some exciting things planned, and your input is key to making them a success.If you haven't had a chance to fill out the survey yet, please take a moment to do so. It's a great way to tell us what you love, what you'd like to see more of, and what features you'd like to have.As always, feel free to reach out to me or any of the team members with your thoughts. We're here to help and we're so grateful for each and every one of you.Community Survey Cheers to a great weekend! 🚀

13 days ago

Supachai'sNewbie

Ask the Community

Why is there a need for reporting?

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.

Cami-AutographNewbie

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!!

16 days ago

julianadefreitasdiasNewbie

Spreadsheets

Filter queries for GA4 - terms and regex

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,

121

16 days ago

agustonetNewbie

Spreadsheets

Issues with Instagram Insights Reels View

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!

181

16 days ago

MatthiasNewbie

Spreadsheets

Supermetrics for Excel with PowerQuery

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

2 months ago

kfgmarketingNewbie

Data Management

Looker studio for GA4

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.

2 months ago

RG2025Newbie

Ask the Community

Exporting Cohort Data from Appslfyer

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.

231

2 months ago

chrisESNewbie

Ask the Community

Filter queries by network type on Google Ads

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

2 months ago

Ask and discuss

Ask questions from other community members and share knowledge

Data visualization

40 topics

Spreadsheets

28 topics

Storage solutions

2 topics

Data transformations

8 topics

Trends and hot topics

52 topics

Tips and tricks

31 topics

Ask the Community

52 topics

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