🎁 Share your data transformation story for a chance to win a prize 🎁
Ask questions, get answers and engage with your peers
im trying to load profile info from instagram public data, and the query is based in a list.a big list. sometimes the profiles dont exist or are restricted. i need the query to bypass this, ignore the invalid profiles and deliver me the results of the valids. because i cant check one by one if they exist.the bot delivered me this solution:To make your Instagram Public Data query automatically skip restricted and non-existent profiles, add the "exclude_invalid_accounts=true" parameter to your query's Advanced settings:Open the Supermetrics sidebarEdit your Instagram Public Data queryGo to OptionsIn the Advanced settings field, type: exclude_invalid_accounts=trueThis setting will automatically remove problematic accounts from your query results when errors occur while trying to access them, allowing your query to continue with the valid profiles.For Google Sheets, you might also find a checkbox option:Open the Supermetrics sidebarEdit your queryGo to OptionsLook for a checkbox labeled "E
In today's privacy-focused world, traditional tracking methods are becoming less effective. That's where Conversions API (CAPI) comes in.But only 20% of marketers are looking into API-based data exchanges like CAPI to prepare for a privacy-first future.That creates a major opportunity to outsmart your competition.We joined forces with LinkedIn to create a Guide to LinkedIn Conversions API. It's your essential resource for understanding and implementing CAPI. Simply put, the LinkedIn CAPI allows you to send your valuable first-party conversion data (think demo requests, CRM updates, offline sales) directly from your systems to LinkedIn. This server-side approach means more reliable tracking, even when browser pixels fall short.The benefits?Improved measurement: Get a clearer picture of your true ROI, with an average 31% increase in attributed conversions (according to LinkedIn). Enhanced targeting: Feed LinkedIn's algorithm richer, more accurate data to build higher-intent matched and p
We want to hear your data transformation stories! In our recent webinar, we shared how to use custom fields and data blending, but now we want to learn from you. Share your favorite use cases for custom fields or data blending in the comments below 👇 Tell us:What problem does it solve? What data sources you blend? Or what custom field you created? What's the outcome?Not using the data transformations yet? Share your ideas for how you would use them. We'll award the most upvoted response with $/€50 Amazon gift card 🎁✨ ⏳ The challenge ends on June 17, 2025. Supermetrics team example: Previously, our marketing team faced the challenge of tracking region-level ad performance.Since we include region codes in our ad campaign names, with custom fields we can easily extract those codes, save it as a new custom field and use as a new dimension in the reports.This allows us to quickly break down performance by region, giving us valuable insights for optimization. Let's learn from each other!
We are updating the API version our Google Ads data source is using from version 18 to version 19, to ensure our data source has the latest features and continues to fetch accurate data. As part of the version update to Google Ads API v19, Google is retiring the “Feed Item” report, which means certain feed and ad extension fields will stop returning results starting June 18, 2025. Affected fields and next stepsThe following fields will be deprecated on June 18, 2025, and will no longer return results after that date:Extension type Attribute values Extension status Feed ID Feed item IDWhile including these fields in queries/reports won't break them, we recommend removing them from your reporting.These fields have several replacement options within the asset dimensions we have available. You can find the full list of fields here. Unfortunately, we are not able to give specific recommendations for the replacement fields as the asset fields to use depend on the ad type and assets you are u
Hi thereWould it be possible to allow the GA4 dimension `user_pseudo_id` to be selected in the Table Manager?We are using Supermetrics Storage to store GA4 data and are exeperiencing issues when summing non-aggreagatable user metrics over dynamic date rages in Looker Studio.I have read that `user_pseudo_id` can assist with accurately calculating non-aggregatable user metrics.ThanksLuke
We change blends, tables and transfers often. Sometimes we notice later that a change caused issues with data. It’s not always easy to remember which changes were made to backtrack the problem.Therefore it would be great if blends, tables, and transfers would automatically create a change history where you can see all changes in configurations, e.g. added/removed metrics and dimensions, changed settings and so on.
Hi, I was wondering if Supermetrics has a readily available connector for Seznam.cz (Sklik)? I used to see this listed under work in progress in the roadmap but I couldn’t find the roadmap anymore and I don’t see this listed within Supermetrics hub. Any knowledge on this is greatly appreciated!Br,
Action required: Get your GraphQL API key We are upgrading to the new StackAdapt GraphQL API, and some actions are required to prepare for the change. We have a detailed support article with all the steps you need to take and a list of new fields that will become available in the new version.As soon as possible, talk to your StackAdapt account manager to request specifically a GraphQL API key. After June 3, 2025, at 16:00 EEST, update your StackAdapt connection to use the new GraphQL key using the instructions in this support article. Make sure not to update your StackAdapt connection until the time mentioned, and don't wait too long after June 3, 16:00 EEST, else there may be disruptions for queries due to mismatched keys. If you received an email with a different date and time, please make the changes based on the date and time in the email.
At Instagram Insights it is possible to see the percentage of followers that have viewed your post/reel vs the percentage of non-followers that viewed it. Since we have a new brand it is very interesting to know how many non-followers we are reaching. We want to set a target on it. Is it possible to add this in Supermetrics so that we are able to use it in our data?
Hi,I would love to have public data from tiktok (engagement) to compare some accounts - as I can do this with Facebook and Instagram.
Hi! Looking to see if anyone has any examples of exceptional slides for higher edSpecifically examples for funnel slides for higher ed
Hi,i want to get the total sum of sold products having a certain product tag. I am realy struggling wwiwth getting this to work. In shopify itselfe it is a super easy thing, but somehow the google looker studio ↔ supermetrics connector is struggling wiwth this request since i am not getting it to work. would there be any help?
hi everyone,i’m struggling to find a metrics from Facebook called “Profile Visit”, it’s not available when i tried to pull report from Supermetrics’ extension. Can anyone let me know how to pull this specific metric?Many thanks,Tommy
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!
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?
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!
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.
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!
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!
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?
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.