How does Report Builder Rank variables with time breakdowns (e.g. Hour, Day, Week)? If you build a request for top 10 (i.e. pages) broken down by a time granularity (hour, day, week etc.) then report builder will return the top 10 pages over the total time period you’ve selected, rather than the top 10 in […]

Metrics Available Demand: Store In-Stock Message When using these metrics please remember they are the raw metric. If somebody  has already localised then the event will fire; on product page load, store locator load, trolley load. Instead I’d usually recommend using a Visit which is de-duplicated, with a segment for one of these metrics happened. […]

The standard way of measuring the success of or tying sales back to a customer behaviour, piece of content or site feature is most recent, or ‘last click wins’. So the last search term entered, last banner clicked, or last promotional page viewed before a purchase will have the sale credited to it. Merchandising Variables […]

  UPDATE : This page has been migrated to Confluence :  https://confluence.sainsburysargos.io/display/DIS/Digital+Product+KPI%27s     WEB PRODUCT KPI’S KPI Metric Name in Adobe Calculation Definition Conversion  [Digital Plan] – Site Conversion %   = Orders / Visits     Conversion rate   RPV [Digital Plan] – RPV = Revenue (incl Delivery) / Visits   Revenue Per […]

VBA macros, also known as Visual Basic Macros, allow you to manipulate workbooks in ways Microsoft Excel alone cannot. Visual Basic has access to the workbook, Excel, and even Windows. As of March 21 2013, VBA can call three report builder API methods. To use these API calls, ensure that the latest version of report […]

Following some of the recent issues with the Internet Lost Sales feed I wanted to reiterate the process when there’s an incident and share some of the original documentation for reference. There are two key parts to the process: Adobe have an automated process that pulls some data, does some processing and is then pushed […]

We’ve listed the most common questions and issues we get asked about on Report Builder below. Hopefully this will help with your problem but if not please still ask us! I can’t login I have Report Builder installed but the ‘Add-ins’ tab isn’t visible in my Excel toolbar Error Messages I can’t find a metric in […]

So you’ve seen “Low Traffic” in a report? It might look something like: When looking at Adobe Reports & Analytics if there are too many unique values for a dimension they won’t all be shown in reporting. That doesn’t mean to say the data is lost as our data warehouse will still store them all. Adobe […]

Mobile participation tells you the proportion of sales, for example, that were made on a mobile device. Another common measure is to look at the proportion of traffic to digital channels that came through on mobile devices. It is important to monitor and understand this metric as mobile behaviour and the customer’s mind set and […]

Store (Demand) (eVar16) Reports & Analytics Location: Store → Store (Demand) The Store (Demand) report captures the stores that customers stock check at on the product details page, trolley list page and store locator. The store data is captured whether the message is in-stock, out of stock or a lead time. It fires when a customer […]