Supermetrics Support Forum

Solved

Supermetrics Too Slow

Supermetrics Too Slow. 1 minute to get 1 query?

  • Hi José,

    seems that you may have very heavy queries if it takes that long to load. Please note that the completion speed depends on the data source API, not Supermetrics. You can try splitting your query in to a couple lighter ones.



    Best regards,

    Jouni Hyötylä

    supermetrics.com


    Twitter: @Supermetrics 

    Support forum: support.supermetrics.com

  • We are having the same issues.  Some data sources seem slower than others too.  Facebook Ads, for instance, regularly takes more than 1 min, even for small queries.  Large queries will sometimes not load at all or they may partially load across some widgets and not others.  We can sometimes fix the widgets with errors by refreshing the page, but this can sometimes cause other widgets to fail too.


    Is there something Supermetrics can do to combat this, like breaking up queries into smaller ones that will load more quickly?

  • Hi,


    this is the best trick to lighten up your queries:


    1.) Run the query so that you’ll see all the results that you wanted

    2.) Click on any of the cells containing results from that query

    3.) That query should be now open in the sidebar —> Click “modify”

    4.) Change the date range to last 7 days (excluding today)

    5.) Turn on “Combine new results with old” from Options dropdown in the sidebar

    6.) Click “Apply changes”

    7.) Make sure that you have set your trigger to refresh your queries in this file every day



    Best regards,

    -Supermetrics Team

Login to post a comment