@igupta The date ranges can't roll backwards currently, only forwards. So this isn't possible.

There is a limitation with dates ranges when it comes to going backwards. You can go from a fixed date to the present date (rolling forwards), but you can't go from a fixed end with a rolling backwards start date. This is a feature that has been suggested to the product team or not, but we aren't su...

The playlist that @bjoern__koth shared is a great resource! Another one is https://experienceleague.adobe.com/en/playlists/analytics-build-freeform-tables   You can also go to the "learning" tab of the landing page in Workspace, there are guided tutorials in there that can really help walk you throu...

You're on the right track with the exclude, but part of the problem is you have hit level containers, it needs to be visit level for the exclude to apply to the whole visit. I just tested out similar logic using product views, just as an example. The logic I came up with was this, and it appears to ...

Unfortunately, there isn't an easy way to scale. When you're building out metrics/segments, you have to identify the specific component and component value that you want to use. For stuff like this that I need to scale to a lot of different things, I do it outside of workspace using the data feeds. ...

The best thing to do to start is go to the page for the cert exam: https://certification.adobe.com/certification/customer-journey-analytics-business-practitioner-professional?%2Fcertification%2Fcustomer-journey-analytics-business-practitioner-professional   It has links to the exam info, practice te...

Is it possible that something broke when it was relaunched? Was the tracked added the same way? Did someone capitalize/lower case something that made a change? I would check with your marketing team and get a list of the campaign IDs, make sure that they are exactly the same. From there, I would try...

Like @igupta said, seasonality is likely a big factor. Other things I would check: Is your overall site traffic down as well? Basically, could it be something impacting the whole site, or just the campaign. Check other campaigns to see if they have lower traffic now compared to before as well. Has a...

Currently in CJA there are two ways to turn a dimension into a metric - derived fields and component settings.  If you use component settings to turn a dimension into a metric, it will give you a count of many times that dimension fired, like a counter event. There isn't a way to turn it into a nume...

There might be an easier way to do this, but it's been a while since I've had to do SQL regularly. If you want to sum up the values in an array, you need to split out the values of that array, you can do that with the "SPLIT" function, which will put each value on it's own line using a delimiter. Bu...