Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Kevin Meilander 78 posts 384 karma points c-trib
    Nov 04, 2020 @ 20:59
    Kevin Meilander
    0

    uMarketingSuite using Azure SQL

    I'm trying to setup uMarketingSuite using an Azure SQL database and ran into an issue when I tried to setup my database.

    It looks like there are a few COLUMNSTORE indexes that are part of some of the analytics tables, however the version of SQL server doesn't appear to support that feature. That feature is only supported in Azure SQL Database Premium tiers, Standard tiers - S3 and above, and all vCore tiers

    Does this mean I need to use this level of database to use uMarketingSuite, or will it still work without this SQL feature?

    Also it looks like the columnstores are in the the Analytics tables, if I just wanted to use the personalization and not care about the analytics, could I use a lower tier database?

  • Kevin Meilander 78 posts 384 karma points c-trib
    Nov 04, 2020 @ 23:32
    Kevin Meilander
    0

    I read a little bit more about what this would be doing and it looks like the database should still "work" with out the columnstore indexes, it just may be slow and is more likely to timeout.

    Since I'm using this just to demo things right now and so will have very little data, I think it should be fine. But for a production site, I'll be sure to use a more powerful DB to make sure this feature is available.

  • [email protected] 406 posts 2135 karma points MVP 7x c-trib
    Nov 07, 2020 @ 15:02
    jeffrey@umarketingsuite.com
    0

    Hi Kevin,

    thanks for your question and we weren't aware that there was a difference between the Azure SQL Databases.

    We already created a fallback in our migration for SQL Server 2016 and earlier, so I guess it's should be an easy job to do that for some specific Azure SQL versions as well. And as you posted in your second comment; it's indeed "just" a performance optimization that can also be done by regular indexes (but their a bit slower).

    Maybe you can help me out with two things:

    1. Did your installation complete, or did it fail? Hope that it completed and you can use the uMarketingSuite for demo purposes... If not, let me know and I will see how we can create a workaround to get the uMarketingSuite up and running for you
    2. Which version of Azure SQL Database did you try to use?

    Thanks for the answers,

    kindest regards and a wonderful weekend,

    Jeffrey

    enter image description here

  • Lachlann 344 posts 626 karma points
    Nov 11, 2020 @ 16:38
    Lachlann
    0

    Hey guys

    I have a setup that sounds very similar to this one I didn't notice any problems with the install process but running locally on a dev licence I do not get any analytics results coming through

  • Lachlann 344 posts 626 karma points
    Nov 12, 2020 @ 11:07
    Lachlann
    0

    Okay I think this might be related to our CSP setup.

    It looks like uMarketingSuite outputs some JS at the foot of the page:

    <script>typeof uMarketingSuite!=="undefined"&&uMarketingSuite.analytics&&uMarketingSuite.analytics.init("60f0cb6d-b848-4d1e-8ab5-11ae038bcb40")</script>

    but the GUID in the init statement chnages on page load meaning that I cannot whitelist a hash for the script.

    Any ideas? L

  • [email protected] 406 posts 2135 karma points MVP 7x c-trib
    Nov 15, 2020 @ 14:00
    jeffrey@umarketingsuite.com
    100

    Hi Kevin & Lachlann,

    first question is

    1) Which version of the uMarketingSuite are you using?

    2) To debug the Analytics tracking you can best take a look at the table "uMarketingSuiteAnalyticsRawPageview". Each pageview should be stored in this table.

    If no row are stored in that table:

    1. Check you license. Does this include the domain that you are now working on?

    2. Check whether your IP address is not filtered (see the tab "IP Filters)

    If rows are stored for each pageview:

    1. Check the columns processingStarted, processingFinished, processingMachine, processingFailed and exception. Are these filled?

    Can you let me know what you find out :)

    3) The javascript that is outputted on the page is only to make sure that clientside events can be linked to the correct pageview. These clientside event can be tracked automatically. See https://documentation.umarketingsuite.com/analytics/clientside-events-and-additional-javascript-files/additional-measurements-with-our-ums-analytics-scripts/.

    The default tracking should work even if this script is not run / rendered.

    Let's debug this together :),

    Jeffrey

    enter image description here

  • Lachlann 344 posts 626 karma points
    Nov 16, 2020 @ 15:50
    Lachlann
    0

    Hey Jeffrrey

    Thanks for your response.

    I am on version 1.6.0 at the moment.

    I can see that there is no data in the Raw pageview table

    In terms of the license I have this site running locally on the domain "da.localhost" and am using the dev license which just has the single 'localhost' domain configured.

    I can confirm there are no IP filters setup.

    I hope this helps

    Cheers L

  • [email protected] 406 posts 2135 karma points MVP 7x c-trib
    Nov 16, 2020 @ 16:52
    jeffrey@umarketingsuite.com
    0

    Aaah, then that is exactly the problem. If the domain 'localhost' is only configured for localhost, it will only track that domain. No subdomains or anything else.

    I've added da.localhost to your dev license as well. If you restart the website it will normally download the new license and then this should work. If not; please redownload the license from your uMarketingSuite profile.

    Let me know if that works!

    Kind regards, Jeffrey

    enter image description here

  • Lachlann 344 posts 626 karma points
    Nov 17, 2020 @ 09:03
    Lachlann
    0

    Oh amazing i will give this a go and let you know how it goes.

    Thanks Jeffrey!

  • Kevin Meilander 78 posts 384 karma points c-trib
    Nov 17, 2020 @ 13:53
    Kevin Meilander
    0
    1. I'm using 1.6
    2. I see Analytic data in uMarketingSuiteAnalyticsRawPageview and the processing columns are filled in.

    So far I haven't come across any issues or errors and it appear that everything is working as expected, but I mainly only tested the personalization part.

  • [email protected] 406 posts 2135 karma points MVP 7x c-trib
    Nov 17, 2020 @ 16:28
    jeffrey@umarketingsuite.com
    0

    Aaah, that sounds perfect... I think it also works; maybe a bit slower overtime, but we can fix that at that moment.

    Thanks for the feedback!

  • Damien Holley 179 posts 540 karma points
    Jan 19, 2021 @ 22:53
    Damien Holley
    0

    Hi I know this is an older query but couldn't see any newer and wanted it 'in one spot'.

    I am running on localhost, and analytics shows no pageviews either total or on the node itself.

    Rawpageviews has data, all fields you mentioned above have data in them here's an example line:

    url ipAddress   userAgent   statusCode  referrer    tampered    headers processingStarted   processingFinished  processingMachine
    https://localhost:44366/blog/my-blog-post/  ::  Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36  200 https://localhost:44366/blog/   0   Connection=close&Accept=text%2fhtml%2capplication%2fxhtml%2bxml%2capplication%2fxml%3bq%3d0.9%2cimage%2favif%2cimage%2fwebp%2cimage%2fapng%2c*%2f*%3bq%3d0.8%2capplication%2fsigned-exchange%3bv%3db3%3bq%3d0.9&Accept-Encoding=gzip%2c+deflate%2c+br&Accept-Language=en-GB%2cen-US%3bq%3d0.9%2cen%3bq%3d0.8&Cookie=uMarketingSuiteAnalyticsVisitorId%3dEFbQYNyAtG%2fw%2bkgJV4GT95WF%2fepOtyWUbpw6xhevzWNM%2bvEzT9KCD8vlcjz2YTERjX14UfOjVsWBtAt75s3vFEzGXQ6QWcs033k0vrkxrnecJZlsIIXrJYaSCna%2fw2nG&Host=localhost%3a44366&Referer=https%3a%2f%2flocalhost%3a44366%2fblog%2f&User-Agent=Mozilla%2f5.0+(Windows+NT+10.0%3b+Win64%3b+x64)+AppleWebKit%2f537.36+(KHTML%2c+like+Gecko)+Chrome%2f88.0.4324.96+Safari%2f537.36&sec-ch-ua=%22Chromium%22%3bv%3d%2288%22%2c+%22Google+Chrome%22%3bv%3d%2288%22%2c+%22%3bNot+A+Brand%22%3bv%3d%2299%22&sec-ch-ua-mobile=%3f0&upgrade-insecure-requests=1&sec-fetch-site=same-origin&sec-fetch-mode=navigate&sec-fetch-user=%3f1&sec-fetch-dest=document   2021-01-19 22:45:27.920 2021-01-19 22:45:27.933 DESKTOP-65A7075
    
  • [email protected] 406 posts 2135 karma points MVP 7x c-trib
    Jan 21, 2021 @ 06:58
    jeffrey@umarketingsuite.com
    0

    Hi Damien,

    in the last columns of this table (processingstarted & processingfinished) you see that the processing has been finished.

    Debugging step 2 is to look at the processed tables and see if there's any info in there. You could take a look at uMarketingSuiteAnalyticsPageview, uMarketingSuiteAnalyticsPage and uMarketingSuiteAnalyticsSession. If there's no information there we need to find out why these are empty.

    If there is information in these tables then you should look at the date range settings of your Analytics reporting. By default "Today" is not shown so that could be why you're not seeing the data:

    enter image description here

    Let me know whether this helps!

    Jeffrey Schoemaker

    enter image description here

  • Damien Holley 179 posts 540 karma points
    Jan 21, 2021 @ 07:18
    Damien Holley
    0

    Yup, thanks Jeffry. I took a look and the pageviews from yesterday are now showing, I didn't notice that today wasn't being shown.

  • [email protected] 406 posts 2135 karma points MVP 7x c-trib
    Jan 29, 2021 @ 08:06
    jeffrey@umarketingsuite.com
    0

    For future troubleshooting I've written some documentation about Troubleshooting your Analytics-setup: https://documentation.umarketingsuite.com/analytics/troubleshooting-analytics/

    If you have any thoughts, or parts that I'm missing, please let me know!

    Kind regards,

    Jeffrey

    enter image description here

Please Sign in or register to post replies

Write your reply to:

Draft