Sunday, May 11, 2014

Excel as a powerful reporting tool for digital marketing

In my previous, opening post I announced the launch of Loganis.com so it may feel like an abrupt change of topic to talk about Excel's role in digital marketing. Still I believe Excel is worth a post being the unsung hero of analysts worldwide, be it market research firms or financial analysts and of course digital analysts/data scientists.

Digital marketing opened up the possibility to get detailed statistics into how the campaign budget is spent and how to spend it better. With Google's acquisition of Urchin Google Analytics (GA) was born; this has spurred an entirely new breed of people into action who were less programmers and more familiar with numbers. More and more people started using GA in the industry looking at a variety of graphs and specialisation occurred: data scientists entered the offices of PPC and digital marketing firms and analytical marketing was born.

Then came services like Loganis that offer a simplified way of looking at, exporting and analysing web data and with them Excel came back into the picture.

Excel is a great tool due to the unparalleled flexibility to process and visualize data. 

Let me give you a real-life example to underline this point. Suppose you want focus your spending on the medium (organic search, ppc, etc.) that performs best. A measure of what good performance is, of course, a bit subjective, assume you are interested in engagement for now and plan to quantify it as sessions with high conversion rates and pages viewed. So what you are interested in is

conversion rate and average number of pageviews per session by medium type.

Wait a second: what about highly engaging mediums that bring in almost no visitors? We need another metric, the raw number of conversions. Our query now consists of 3 metrics and 1 dimension. This looks quite complicated, indeed so much so that it will not be possible to get the numbers out of Analytics via logging into it.

Loganis, on the other hand allows one to harvest the data quickly. One can simply open the Loganis example Excel sheet, and type in the query

{
:met "ch0:ga:visits,ch0:ga:pageviews,ch0:ga:goalCompletionsAll"
:dim "ga:medium"
:per "last_60_days"
}

into the Generic Query tab, press Refresh and get the raw data. Then all is left to get Excel to transform pageview into average pageviews, goal completions into goal completions per visit (i.e. conversion rate) and plot a chart, for example a bubble chart like this one:


The query above looks admittedly daunting for the uninitiated. For those not wanting to learn this language (which is, by the way based on the GA API, see an intro here) there is always the possibility to use one of the pre-defined dashboard templates and copy queries from there.

As this example highlights using Excel and Loganis one can focus on Information instead of data and spend time not on creating reports for customers but gaining actionable insights that reduce wasteful spending in campaigns.

Another exciting feature of Excel is its pivot table functionality which allows one to manipulate complex data on the fly. I will discuss this in the context of multi-dimensional web data analysis in my next post. 

7 comments:

  1. I really want to thank the author for such a nice blog that helped me to understand why it is important. Mexico Export Data

    ReplyDelete
  2. one of the best US import data We are give best quality services in vey low prices we are give free demo

    ReplyDelete
  3. We are best Import export data give a vest best quality services and free demo

    ReplyDelete
  4. Weight rely is an American time period referring to the whole value of coins or tokens faraway from a slot machine's drop bucket or drop field for counting by the casino's onerous rely group through the use of thecasinosource.com of} a weigh scale. Taste is a reference to the small quantity usually paid out to keep a player seated and continuously betting. Only rarely will machines fail to pay even the minimum out over the course of quantity of} pulls. Carousel refers to a grouping of slot machines, often in a circle or oval formation. With ghoulish graphics to accompany the horrifying sound effects, console your self with the data that you can land the lucrative Lightning Re-Spin characteristic at any time whereas taking part in} Lightning Horseman. You may withdraw money from your account through Card, Bank Transfer, and Check.

    ReplyDelete
  5. When half in} slot machines, really have} retained patterns over the years. Slot producers use one other trick to provide the feeling of probably successful and bet365 lacking out on the final couple of reels. Bonuses are what make half in} at a web-based on line casino a lot fun. With so many unique video games and promotions, you'll be able to|you probably can} take pleasure in a wholly new gaming expertise with out breaking the financial institution. Whether you’re in search of traditional 3-reel slots, trendy 3D slots, or progressive 5-reel slots video games that supply huge jackpots, we’ve received them listed here.

    ReplyDelete
  6. The advances in drugs are arguably among a few of the the} most enjoyable, with scientists able to to} create prosthetics and implants by way of 3D printing. They also can create precise body components like ears from stem cells, collagen and structural proteins in the human body known as fibrin; this process recognized as|is called|is named} bioprinting, though a lot of it's nonetheless in the testing phases. Additionally, researchers can take a look at prescribed drugs easily and ethically with tissue red shower curtains created from 3D printers. When you print your creation on a 3D printer, it comes out in slices. Each small layer sticks collectively to type a single object from the underside up.

    ReplyDelete
  7. To illustrate, an estimated 53% of on line casino gamers in English-speaking countries get pleasure from slots, and this game type additionally occurs to have the very best retention rate. A slot game with more than the traditional three reels is called as} a multi-reel slot. Since HoF offers solely free slot machines with bonus rounds, you will not win or lose any actual money, however you WILL loosen up, sit back, and have fun. Did we mention that enjoying in} House of Fun online on line casino slot machines is FREE? You will get a welcome reward of free cash or free spins to get you began after which there are nice deal of} ways to maintain amassing free cash as you play. I obtained to the 200s stage because 온라인카지노 of|as a end result of} I was profitable bigger payouts betting conservatively.

    ReplyDelete