Friday, June 12, 2015

Flipkart's Adobe Analytics Tracking and "Whats Missing"

Flipkart uses an s_code version lesser than h.25.3 code and fails to take advantage of first party cookie (s_fid) set by js code while using a third party cookie.

Paying huge sum to Adobe and failing to take advantage of this fall back method :-( in an online world which experiences a higher rejection rate for third party cookies ?????

Adobe used user agent and IP address to track the user while s_vi cannot be SET in version lesses than H.23.5 which only means many people in a single network is treated as one visitor :-(

Why on earth do you want to track your visitor statistics in such a way!!!!

Saturday, June 6, 2015

Automated dashboard building tip using Adobe Analytics Report Builder!

Preserving the required metrics/dimensions in a certain order while creating reports using Report Builder, and saving the templates by naming it properly is the key to build automated dashboards. Keep the raw the data in one sheet (don't forget to set the preserved order), and the formatted one in other (just apply the formula once - connect the data with charts).

Every time you refresh the report with a different date range or different RSIDs due to preserved order set in the raw data sheet, the formulas applied in the formatted sheet connecting the raw data works superbly.

Thursday, June 4, 2015

YouTube Embedded Video Tracking using Adobe Analytics (SiteCatalyst) - Download Codes here

YouTube Embedded video tracking with any analytical tools require
bit of code to be added - first, to bring the video details out of the iframe over an API - second configure Adobe Analytics media module milestone tracking in AppMeasurment.js (configure video reporting in RSID)

- That's it!!!!
Download the full set of ready-made codes here in a folder, open one of the html file in a browser, put the debugger on, play with the video + watch the image request firing up for the actions made on the video smile emoticon
Pack contains 
- Configured AppMeasurement.js
- Single YouTube Video tracking (HTML)
- Multiple YouTube Video tracking (HTML)

Friday, April 10, 2015

Linear Allocation (visit based) and Exaggerated Numbers while using Calculated Metrics - Exact Reason

Adobe Analytics// Issue with calculated metrics!!!
Wrong calculation when one of the value used in the calculation is zero. For example: Whenever the order value is zero and revenue has some value, the AOV calculated metrics divides revenue/orders. Ideally the output should be zero; it throws up wrong value here.
I saw this across Client RSIDs; whenever the order value is zero and revenue has some numbers, the value is calculated wrongly.
Need help!


02:19 PM
Hi Kamal,
Standard metric attribution for the Site Content> Pages report is linear therefore (see reference info linked below) even though it appears the Orders metric is 0 in the report it actually is a small fraction. Therefore when the calculation is made you have a very high # (Revenue) divided by a fraction (.10 fraction values of Orders for example) which produces a very high 'non-sensical' value. You can verify yourself by creating a calculated metric for orders that allows for decimal places. If it were the case that the Orders metric was truly zero than your calculated metric value would be an error DIV/O since you cannot divide a number by zero.
What analysis question are you trying to evaluate Site Content> Pages? My main question would be what is the intent behind using AOV against linear allocation metrics within the pages report? Since linear allocation is variable depending on the count of pages within a given visitors conversion visit it is very likely not what you are looking to review.
Reference Link:
When linear allocation is selected, success events are evenly divided across all variable values seen in the visit. For numeric and currency events such as Revenue, the monetary amount is divided. For counter events such as Orders, a fraction of the event is awarded to each variable value in the visit. These fractions in reporting are summed, then rounded to the nearest integer in reporting.
For example, in a visit where four pages are visited prior to a success event, each page would receive credit for 25% of the event. If, in the same visit, campaign had two values, each campaign value would receive 50% of the credit for the event.

    01:15 PM
      Dear Brain
      Thank you very much. Great answer!!!
      We are trying to understand the effectiveness of each page that contributes to the conversion. I had recommended participation revenue metrics instead of measuring this way. Believe even participation metrics are based on per visit, and perhaps a better one.
      Do you want to suggest on any other way to understand the role of each page in producing conversions.
      Best Regards
      Kamal Chembath
        01:18 PM
          Dear Brian,
          Cross Visit Participation should work across visits right. Will this be an ideal choice for the purpose.
          Best Regards
          Kamal Chembath
            02:10 PM
            Hi Kamal,
            Participation metrics are great for analyzing site content influence on conversion events since it attributes whole end conversion event values to a given page over a visit. I would recommend leveraging the Orders and Revenue metric with participation.
              02:49 PM
                Dear Brain
                Thanks a ton . One more final clarification.
                Does regular participation metrics traverse more than a visit or only cross visit participation keep track of multiple visits?
                Best Regards
                Kamal Chembath
                  02:53 PM
                  In R&A participation metrics are tied for a given visit only. If you have access to Ad Hoc Analysis (formerly Discover) there is a Visitor Participation metric option:
                    11:09 PM
                      Thank a ton Brian, very helpful answers.
                      -Kamal Chembath

                        Thursday, April 9, 2015

                        Tracking Lost Revenue & Lost Units in SiteCatalyst - scAdd do not Track Count of Multiple Units Added at Once

                        Adobe Analytics// 

                        Passing units and revenue unnecessarily in s.products in pages other than purchase page is not a best practice, and will not be reported in analytics report. Solely relying on scAdd to track units added to the cart is definitely misleading. One can add multiple products at to keep track of units added to shopping cart in a separate variable + one more variable to track the revenue; preferably in the product string would be great. This will allow you yo calculate lost revenue vs actual revenue and actual units sold vs added units. 

                        "The Revenue and Unit parameters are only valid when used in combination with the Purchase Success Event. They will be ignored in all other cases."

                        I posted to confirm on my understanding on Adobe forum - The great Adam chose to reply for it.

                        Reply from Adam - I am not sure what your specific question is here, but you can certainly track Units added to cart, add to cart revenue, checkout revenue, etc.  You just can't do it using the Purchase event, but rather you need to use custom variables for this.  The following old blog post of mine should explain most of what you need to know:

                        My reply - 

                        Dear Adam
                        I am fan of you, thank you very much for your reply.
                        In one of my recent Client site they have coded s.product string with units and revenue ( ;PROD26676;1;45.5 without custom variables / event incrementor) from product page till the final purchase page. On the final page the purchase event is triggered, and hence I believe we get the count of orders, revenue and units sold. Is coding units and products (;PROD26676;1;45.5) in pages other than purchase page send the the units and revenue data to analytics report that too without purchase event. I guess it won't. Please confirm on this.
                        Other clarification; if I add 10 quantities of the same product will scAdd track 10 units or 1 shopping cart addition as the image request fires only once. Please advise here.
                        So without a separate event incrementor is it not possible to track number of units (added to cart but not purchased) through scAdd in product pages (product detail page, check out) other than purchase page where purchase events tracks the actual purchase.
                        Best Regards

                        Reply from Adam - Now I get your question.  You are correct that you cannot use the first few slots of the purchase string when not coupled with the Purchase event.
                        To see # of Units added to cart and the Revenue added to cart, here is what you would put on the Cart Add page if you assume someone added 10 units worth $500:
                        s.products=;[PRODUCT ID];;;eventA=10|eventB=500
                        If you also wanted to see how many units and how much $$$ was brought to the checkout step, you would repeat this.  Let's say that the same user decided to remove 2 units and $100 by the time they reached the checkout step.  The coding might look like this:
                        s.products=;[PRODUCT ID];;;eventX=8|eventY=400
                        Then you would set the Purchase event normally so you get Orders and Revenue and you would open the Products report and see 3 columns for each product:
                        Cart Add Revenue
                        Checkout Revenue
                        Then you can create calculated metrics between them as you'd like...Just keep in mind that you's want to make success events A & X numeric events and events B & Y Currency events in the admin console...
                        Adam Greco