Community

Recently active
Help others
Categories

Enhance "Combine new results with old" by allowing to choose the dimensions to use for itNew

“Combine new results with old” in Google Sheets currently comes with the downside that as soon as something in the dimensions changes – either by design (like with many of the image URL fields) or by circumstances (like fixing a typo in a campaign name or a social media copy), the fields can’t match anymore, leading to duplicates and therefore wrong data.These problems could be solved by letting us choose which of the dimensions we actually want to use for the matching, allowing us to update all other dimensions as well. This would eliminate the need for additional queries and complex workarounds.

131

1 hour ago

Sonja KukkulaCommunity Moderator

Amazon Advertising: New fields are now available!News

Hey Supermetrics Community! 👋We've rolled out some new fields for the Amazon Advertising data source. ✨ These additions should help you dig deeper into your Sponsored Display and Sponsored Product performance. All fields are now live and available in Excel and DWH/API.We have new fields for two report types.Sponsored Display Report:Detail page views Add to cart Add to cart rate Branded searches NTB detail page views Add to cart clicks Branded search clicks NTB detail page view clicks Campaign cost typeSponsored Product Report:Top of search impression shareWe’re constantly working to improve our connectors and give you more flexibility with your data. Let us know how these new fields impact your reporting, and don’t hesitate to reach out if you have any questions!Happy reporting! 📊😎

1 hour ago

4C PredictionsNewbie

Stripe cancellations for subscriptionsNew

Our business incurs monthly subscriptions that we’d like to put into our reports. This data isn’t currently on your platform when pulling into Looker Studio. However, we’d like to see how many cancellations we get on a day/week/month etc. This can be customers that cancelled immediately after payment and their access is revoked, or just that their access to the site will be revoked at the end of their billing cycle.

2 hours ago

IshaCommunity Moderator

Tips and tricks

What does it take to turn scattered campaign data into a streamlined, insight-driven engine in just 6 months?Podcast

In this episode of The Marketing Intelligence Show, Martina Karakoleva, Campaign Insights Manager at Philips Healthcare, walks us through:How Philips automated reporting and improved data trust The role naming conventions played in scaling fast Why centralizing data ownership in marketing is a game-changer How the analyst role is evolving with AI and automation What’s next for Philips’ marketing data journeyIf you're working on improving data workflows, reporting automation, or simply want to hear how a global team transformed its analytics stack—this one’s for you.Tune in now: https://supermetrics.com/podcasts/philips-healthcare-data-transformation Related read: Campaign naming conventions: The key to cleaner and reliable reportingLet us know your favourite takeaway or how you're solving similar challenges in your org!

3 hours ago

ads-optdcomNewbie

Adjust SKAN DataNew

As indicated on Adjust’s support page, SKAdNetwork metrics are available via API. For digital marketers like us — especially those running app campaigns and tracking performance through MMPs, metrics such as SKAN Installs, SKAN Reinstalls and SKAN Conversion Value are extremely important for both reporting and optimization.That’s why having access to these metrics via Supermetrics would be incredibly valuable for all of us.

273

23 hours ago

shin_apexNewbie

Spreadsheets

Google Ads: Auction Insights

Hi everyone!I’m relatively new to SEM—my background has been more focused on social (both organic and paid)—and I’d love some help navigating a current project.I was asked to include auction insights in a recurring report, and while I’ve managed to find metrics like impression share using keyword text as a dimension, I’m stuck on how to include the Display URL domain like we see in the Google Ads UI.From what I understand, this data is only available for selected keywords—and usually through the Google Ads interface—but I’m wondering if anyone here has found a way to pull this info using Supermetrics (whether via Google Sheets, Data Studio, or another connector)? I’d love to either automate or semi-automate this process, rather than manually exporting from the UI every time.If anyone has tackled this or has a creative workaround, I’d really appreciate your advice. Thanks so much!

323

2 days ago

AuroraCommunity Moderator

What’s new at Supermetrics in April 2025News

Happy April! We have a lot of exciting updates to share this month, all designed to make your marketing data work smoother and more insightful:LinkedIn Conversions API: Unlock deeper LinkedIn campaign insights. Simplified Data Blending: Get faster reports with new templates. Power BI Quick Queries: Visualize key data in one click. Lazada Ads Connector: Connect to more data sources. HubSpot Recognition: We're still a top HubSpot app! Customer Success Stories: See how Elbkind Reply and ClimatePartner transformed their reporting. Philips Healthcare Podcast: Learn how they saved 40% of analyst time with automation. Upcoming Events: Join us at Dublin Tech Summit and our Helsinki TableTalks Breakfast.New Product: Supermetrics for LinkedIn Conversions APIUnlock the full potential of your LinkedIn ad campaigns. Many B2B marketers miss crucial conversion data (demos, CRM, deals) that occurs beyond website tracking. Our new integration empowers you to see the bigger picture, optimize performance

390

2 days ago

geo_suNewbie

Data transformations

Amazon Ads Connector - Account ID

Hi everyone,Hope you’re well. I’m working with some clients on Amazon Ads. I connected my Amazon Ads account to Supermetrics to retrieve data and send it to Big Query.My issue is the following : I have a duplication of accounts for my clients with 16-digits ID. It seems to be for each marketplace, but there is no way to identify which ID corresponds to which marketplace. Moreover, when I try to make some previews to find the right account, the query dysfunctions.Anyone had a similar issue ? Found a solution ? Thanks !

232

6 days ago

TONCNewbie

Connection with Joyn.euNew

We want to import data in Lookerstudio via Supermetrics from joyn.eu. Via Joyn we send mails (campaigns) to our database (based on a loyalty card) and want to get this data in a report.

241

7 days ago

naoyawadaNewbie

Ask the Community

Facebook Ads Custom Conversions and Google Sheets

I am running into a problem where Facebook Ads and Google Sheets (via Supermetrics) aren’t matching up. I have created Custom Conversions in Facebook Ads. Once they have been Activated, I was able to use them as a metric in Supermetrics for Google Sheets. I have since created more of them in Facebook Ads (they are active), but I am not seeing them appear in my Supermetrics side panel. I have re-connected the Facebooks Data Source via the Hub, but I am not seeing any changes in what Custom Conversions are available for me to select. Any help/advice would be appreciated. Happy to share more information as needed as well.Thanks!

233

11 days ago

shin_apexNewbie

Spreadsheets

Google Ads: Auction Insights

323

2 days ago

geo_suNewbie

Data transformations

Amazon Ads Connector - Account ID

232

6 days ago

naoyawadaNewbie

Ask the Community

Facebook Ads Custom Conversions and Google Sheets

233

11 days ago

bluerayNewbie

Ask the Community

Reach metric will always be Zero

Hi, We are trying to use Facebook Ads connector to Looker Studiowhen the campaign objective is OUTCOME_SALES then the reach value will always be zero? how to solve this?

191

21 days ago

sarahmNewbie

Storage solutions

Benefits of Data Warehousing

Hoping to hear from some others (especially other agencies) about the benefits of switching to data warehousing for reporting. What improvements have you seen? Was the initial lift easier/harder than expected? Please share your experiences!

312

25 days ago

MarkieCNewbie

Spreadsheets

Why connect 8 account when I can only use 2

Hello everyone,I’m hoping someone will be able to help me. We pay for the Growth account, which allows us to connect 8 accounts to our Google Sheets. However, when I went to use one a few days ago, I received a note saying that I could not get data because it was not one of our prioritized accounts.When I reached out to support, they told me that you can only have 2 prioritized accounts, but I can’t find anywhere to set this. Also, why are we paying for 8 accounts if we can only use 2? It seems a little redundant.Additionally, we have 3 people on our team, and none of us seem to have access to set a priority account. I’m getting a little lost as to what I can do now since support takes a whole day to tell me that we only have 2 prioritized accounts. But if you can only have 2, what’s the point of going above the basic plan?I need help pretty urgently now and can’t really wait another day for support to tell me that I can have 8 accounts but can’t use them.

321

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!

1125

1 month ago

leoarthurNewbie

Ask the Community

What are the Best AI Computing Setups for Handling Large Supermetrics Datasets?

Hi everyone,I’m working with large datasets pulled from Supermetrics, and I’m facing challenges when it comes to processing them efficiently. The datasets are growing, and it's starting to strain my current AI computer setup. I’m wondering what the best AI computing setups are for handling such massive datasets.To give some context, I need a system that can:Handle complex data processing and analysis Scale as the dataset grows Integrate well with AI frameworks (like TensorFlow or PyTorch) Be cost-effectiveWhat hardware and cloud-based solutions do you recommend for this kind of workload? Are there specific GPUs, CPUs, or cloud services that work best for large-scale data analysis?Any insights or recommendations would be greatly appreciated!Thanks!

nikeulNewbie

I want to pull data from Instagram which is older than 28days. But somehow in google looker studio, the data does not work past the 28 days, when i for example choose a custom range. What might be the issue here?

482

1 month ago

marketingNewbie

Spreadsheets

Metrics from query can't generate data from ads manager

I don’t know what’s the problem. But, the metrics usually automatically updateas you can see. The data stop continuously generate since 2nd February 2024. any body have the same problem and can solving this?

251

2 months ago

Ask and discuss

Ask questions from other community members and share knowledge

Data visualization

34 topics

Spreadsheets

25 topics

Storage solutions

2 topics

Data transformations

8 topics

Trends and hot topics

47 topics

Tips and tricks

30 topics

Ask the Community

43 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