Skip to main content

Solved

27 Topics
EdY
EdYNewbie
asked in Data visualization
question Campaign delivery

How can I access or calculate the 'Campaign Delivery' metric for Facebook Ads in Supermetrics?

182
Sahra
20 days ago
LudivineAvell
LudivineAvellNewbie
asked in Ask the Community
Shopify x Google Sheets: How to Track SKU Quantities Sold?

Hi,I want to create a dashboard in Google Sheets using Shopify as the data source.I'd like to show the sales evolution of SKU groups in terms of quantities sold, not number of orders. Which metric should I select? I used "item" but I'm not getting the same data as in Shopify.Thank you in advance for your help

473
LudivineAvell
27 days ago
AmitPPP
AmitPPPNewbie
asked in Ask the Community
Supermetrics Connector

Hello, I am working with one client and he has meta ads connector and it is paid version, successfully fetched the data in Google sheets, no problem at all But do I need to buy another connector if I am connecting Google My Business supermetrics connector to looker studio Because it is showing the message that free version is expired...  The Admin in the supermetrics is SAME person for Meta ads and Google my business connector, no difference in this...  So my question isDo supermetrics charge for each connector? Do they have any packages that includes Meta ads + Google My Business Please help me out

241
Sahra
1 month ago
L
LukasNewbie
asked in 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

712
L
1 month ago
N
NassratNewbie
asked in Data visualization
Facebook insights Video views, 15s and 60s views

 Hi everyone,I am trying to have the same metrics and chart as it is on Facebook insights using Facebook connector. When trying to bring same metrics to the chart, it returns the error “Can't fetch the post_video_views_60s_excludes_shorter metric, when splitting by video-level dimensions” When asked the support team, they said the 15 and 60s are post level metrics but the total video view is something called “dynamic” metric that can work as page and post level. I can not understand the responses. Anyone found similar issue? Any help?  

461
jessiebrock
1 month ago
Paul Turzynski
Paul TurzynskiNewbie
asked in Tips and tricks
Data comparaison with same day last year on lookerstudio

Hello , I was wondering if someone knows how can we compare data with last year same day comparaison instead of just last year ? (really needed for the retail sector)  (e.g Monday 19 August 2024 vs Monday 21 August 2023 instead of the 19/08/24 vs 19/08/23 dafault comparaison window) If seen some stuff online but honestly it wasn’t work on my side ! Thanks for your help :D  Paul T 

1678
dataviz
2 months ago
KarenR
KarenRNewbie
asked in Data visualization
Google Ads - Ad Creative Reporting

Hey there! Has anyone figured out a good way to pull into a Looker Studio chart Google Ads ad creative so the correct ad group with the various images, headline text, etc., pull in under that ad group? Did you break out each Google Ads channel separately (search, YouTube, RDA, etc.)? We run a lot of responsive ads, and would love to build a client-friendly dashboard to show which creative image and text copy performs best by Ad Group on responsive ads. Thanks in advance for your help! Best, Karen

591
Milja
2 months ago
mnatanasabapathy
mnatanasabapathyNewbie
asked in Ask the Community
AD or creative name for google ads

What is the equivalent dimension for “ad” in google ads platform to supermetrics dimension for google ads connector. I am trying to get the ad or creative name for GDN/Youtube ads in google ads using supermetrics. Please let me know. Thanks.

843
Milja
2 months ago
msacco
msaccoNewbie
asked in Data visualization
Calculate Days Difference in Date Range

In a Looker Studio Dashbaord I want to just count the number of days in a selected Date Range.  I’ve seen threads to use DATE_DIFF(MAX(Day),MIN(Day)) Not working. any suggestions appreciated

251
michaelkloet
3 months ago
Jaspreet
JaspreetNewbie
asked in Ask the Community
Can we get the data from Facebook Marketplace using Supermetrics?

We are in process of doing the Rental market analysis and we see that a lot of house rental ads are there on FB marketplace only.While we do have the connector to the Facebook from Supermetrics but we are not able to get a handle to the FB Marketplace data.Any insights or suggestions would be helpful. Thanks.

371
Merenparras
3 months ago
KarenR
KarenRNewbie
asked in Ask the Community
Basis DSP >< SM Connector

Hey there! Does anyone else use Basis DSP and is having issues with the connector? Our primary issue is that SM isn’t pulling in all the data that Basis DSP API is providing; only the very high-level ‘Line’ item level data is available, with Group and Tactic level data completely missing (even though it’s available in the Basis DSP API). Support told me to submit an “Idea” which I’ve done now twice with no update. This is a HUGE missing for us, and wondering if anyone else is experiencing the same thing?

512
Kenneth
3 months ago
ryanmio
ryanmioNewbie
asked in Ask the Community
New Trade Desk failure: Trade Desk refresh failed because "background import in progress"

“Background report import is in progress. Please try again later. If the problem remains after 24 hours, please contact our support.”

934
jmar
3 months ago
haynesy
haynesyNewbie
asked in Spreadsheets
Dynamically pulling in values into the "Value" field in google sheet query

I want the value in the ‘Value’ field to be pulled in from a cell in my sheet (e.g. E2) that would contain the Product Title i want to filter from.Is this possible?   

1325
haynesy
4 months ago
phdigital
phdigitalNewbie
asked in Spreadsheets
Query to pull month to date compared to same dates a month ago

Hi team, I was wondering if there was a way to modify the query dates to compare the same dates a month ago. There is only an option for same dates a year ago. ie Compare 1-14th Aug 2024 to 1-14 Jul 2024.Thank you!  

792
phdigital
4 months ago
nitinvarghese
nitinvargheseCurious Mind
asked in Ask the Community
Looking for Power Point Slides from the NYC SuperSummit Conference

good morning! I was wondering if anyone knew where I can access the presentation slides from the SuperSummit Conference in NYC back on 6/27? Thank you so much in advance

826
Sahra
4 months ago
nitinvarghese
nitinvargheseCurious Mind
asked in Ask the Community
What challenges have SuperMetrics helped you overcome?

What has everyone had a problem with and how was SuperMetrics able to help you? Curious and would love to hear everyone's experiences

684
Sahra
4 months ago
Robin_Shukla
Robin_ShuklaNewbie
asked in Data visualization
Issue with Stacking Multiple Columns in Looker Studio Using Supermetrics Connector for Google Ads

Hi everyone,Objective: Stack multiple headline columns (Headline 1 to Headline 15) into a single column in Looker Studio. Challenge: Looker Studio doesn’t natively support this transformation. Data Source: Using the Supermetrics connector for Google Ads, which lacks a built-in feature for stacking columns vertically. Need: A workaround or best practices to achieve this within Looker Studio.Has anyone faced a similar issue or found a solution? Any advice would be greatly appreciated!Thanks in advance!

953
Kathy
4 months ago
phdigital
phdigitalNewbie
asked in Ask the Community
Query to pull all Shopify accounts under Partner account

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!

521
xinfu
5 months ago
tomek_chwaja
tomek_chwajaNewbie
asked in Ask the Community
Facebook and instagram insights data

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.

972
Milja
5 months ago
nitinvarghese
nitinvargheseCurious Mind
asked in Ask the Community
Best useful LinkedIn analytics dashboard

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

613
nitinvarghese
5 months ago
CraigIsAlwaysLearning
CraigIsAlwaysLearningNewbie
asked in Data visualization
Transforming/Blending data for Looker Studio - visualisation speed load times

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

402
CraigIsAlwaysLearning
5 months ago
Nicholas
NicholasSupermetrics Team
asked in Ask the Community
Email becoming gtempaccount?

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!

2442
nitinvarghese
5 months ago
CraigIsAlwaysLearning
CraigIsAlwaysLearningNewbie
asked in Spreadsheets
Show Facebook Post Name by date and engagement metrics

Hey Supermetrics community,I’m trying to import a daily breakdown of Facebook &amp; InstagramAccount name Post date Organic reach Organic impressionsThe aim is to blend this data with GA4 to understand what posts did and did not drive traffic to our website. Unfortunately, this query loads no data. If I remove post date and account name, then the query shows the daily breakdown for organic reach/impressions.Any ideas as to what I am doing wrong? Thanks in advance.

864
CraigIsAlwaysLearning
5 months ago
atem
atemNewbie
asked in Ask the Community
How can I guage follower growth from Facebook Ads

I’m running ads on Facebook and Instagram, Is there a metric in the Facebook Ads connector that allows me to see how many followers I gained from my ads? Or do I have to use “Page Likes” ?

841
annashutko
5 months ago
Reetu
ReetuNewbie
asked in Ask the Community
No link for Product Updates july 2024

hi SM team, i didn’t receive the attend link for product updates happening now?

606
Senni
6 months ago
Terms & ConditionsCookie settings