Parliament votes to dissolve the leadership of a region whose forces are fighting the national army.- Advertisement –
Brisbane Lions player Daniel Merrett and his wife Sarah at their Hawthorne home which they have just listed for sale.Former Brisbane Lions player Daniel Merrett and his wife Sarah are selling their 18 Dover St digs at Hawthorne.The four-bedroom, three-bathroom property is set across two levels on an elevated 405sq m block.18 Dover St, Hawthorne.After living at the property for just over two years, the pair made the decision to downsize and move to the north side of town due to work commitments.“Hawthorne has been such a wonderful suburb to live during Daniel’s late football days with quick access to the city, the Gabba and the airport. However now that Daniel’s work is in Red Hill and Yeronga, there isn’t as great a need to be in Hawthorne anymore,” Sarah said.More from newsMould, age, not enough to stop 17 bidders fighting for this home4 hours agoBuyers ‘crazy’ not to take govt freebies, says 28-yr-old investor4 hours ago18 Dover St, Hawthorne.Footy stars kicking property goals…Video Player is loading.Play VideoPlayNext playlist itemMuteCurrent Time 0:00/Duration 2:13Loaded: 0%Stream Type LIVESeek to live, currently playing liveLIVERemaining Time -2:13 Playback Rate1xChaptersChaptersDescriptionsdescriptions off, selectedCaptionscaptions settings, opens captions settings dialogcaptions off, selectedQuality Levels720p720pHD540p540p360p360p270p270pAutoA, selectedAudio Trackdefault, selectedFullscreenThis is a modal window.Beginning of dialog window. Escape will cancel and close the window.TextColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentBackgroundColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparentWindowColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaqueFont Size50%75%100%125%150%175%200%300%400%Text Edge StyleNoneRaisedDepressedUniformDropshadowFont FamilyProportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall CapsReset restore all settings to the default valuesDoneClose Modal DialogEnd of dialog window.This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.Close Modal DialogThis is a modal window. This modal can be closed by pressing the Escape key or activating the close button.PlayMuteCurrent Time 0:00/Duration 0:00Loaded: 0%Stream Type LIVESeek to live, currently playing liveLIVERemaining Time -0:00 Playback Rate1xFullscreenBraith & Jodi Anasta Episode 102:13 Related videos 02:13Braith & Jodi Anasta Episode 100:38Socceroos star sells Lower Plenty dream home02:33AFL players kicking property goals01:27Crazy about soccer? Check out this collection02:15The ultimate Sydney Swans fan02:37Jimmy & Nadia Bartel Episode 1The couple said they were lucky to purchase the home brand new.“We were the first people to live in it and everything was done when we arrived, even the landscaped gardens. Due to this, it has been such a low maintenance home to live in,” Sarah said.She said they had many memories living at the property which featured a sunlit balcony to entertain friends and a secluded deck with a wet bar concealed by automated shutters.“Our daughter (Matilda) has spent most of her life so far in this home reaching a range of early childhood milestones, as well as birthday parties, socialising with friends and family, barbecues, having one of the young footy players live with us for a year (Josh Schache) and enjoying all that this beautiful suburb has to offer,” Sarah said.18 Dover St, Hawthorne.Sarah said one of her favourite parts of the home was the backyard as she could sit on the back deck and watch Matilda play on the lawn.The property, being marketed by Paul Shelton of McGrath Bulimba — Balmoral, is going to auction on June 24 at 9am.
West London Sport has teamed up with Thomas Cook Sport, official travel partner of Chelsea FC, to offer Blues fans the chance to win a pair of tickets to their next Premier League home game against Bolton Wanderers on Saturday 25 February.André Villas-Boas will be hoping for all three points against the Trotters…and you could be at Stamford Bridge to watch all the action LIVE!We have five pairs of tickets to give away and to be in with a chance of winning, simply answer the following question:AdChoices广告Which recent Chelsea signing previously played for Bolton?a. John Terryb. Gary Cahillc. Ashley ColeE-mail the correct answer to firstname.lastname@example.orgWinners will be randomly selected. The competition closes at 5pm on Monday, 13 February.Thomas Cook Sport is the UK’s leading sports tour operator and official travel partner of Chelsea FC, offering match breaks to Chelsea fans for the 2011/2012 season from £109 per person. This season, choose the winning tactic and book your 2011/12 match break by visiting www.thomascooksport.com or call the sales team on 0844 800 9900.You can also follow us on Twitter @thomascooksport and find us on Facebook at facebook.com/ThomasCookSportUK to keep up-to-date with all the latest competitions, special offers and news.Terms & Conditions1. The prize consists of two tickets (Chelsea end) to the game against Bolton Wanderers on Saturday 25 February 2012, for five winners. Kick-off is at 15.00.2. The package does not include travel to or from the ground or any hospitality at the ground.3. Fans are reminded that tickets are in the Chelsea end and seats are amongst home supporters. Please be aware that any vocal or visual support for the opposition will result in ejection from the stadium without compensation.4. Entrants are reminded that tickets are issued subject to Chelsea FC Regulations and the Conditions of Entry relevant to those tickets.5. Competition open to all UK residents with the exception of employees of Thomas Cook Sport Ltd, Chelsea FC or Hatch Communications, their immediate families, agents or anyone else associated with the administration.6. No cash alternative will be offered.7. The competition closes on 13 February.8. In the event of unforeseen circumstances, the promoter reserves the right to offer an alternative prize of equal or greater value.9. The promoter’s decision is final and no correspondence will be entered into.10. All entrants must be willing to participate in publicity should they be a winner.11. We reserve the right at any time to cancel, modify or supersede the competition if, in our sole discretion, the competition is not capable of being conducted as specified in the competition rules.12. The promoter of this competition is either Thomas Cook Retail Limited, trading as Thomas Cook Sport or Airtrack (for UK departures), or Capitol Holdings Ltd, trading as Thomas Cook Sport (Ireland), for travel arrangements departing from the Republic of Ireland. Thomas Cook Retail Ltd registered office is The Thomas Cook Business Park, Coningsby Road, Peterborough PE3 8SB, and the company registration number is 00102630 England. Capitol Holdings Ltd registered office is 10B Beckett Way, Parkwest Business Park, Dublin 12, and company registration number is 163008. To discover more about Thomas Cook Sport, log on to www.thomascooksport.com
Table of ContentsStep 1: Investigating the Ins and Outs of Your CRM DataStep 2: Grouping the Data TogetherDefining the Units of AnalysisConducting an Exploratory AnalysisStep 3: Mapping Out Your Analyses Setting the Foundation of Your Analysis: Identifying Two Basic ComponentsCommon Types of Analyses You Can Do with CRM DataStep 4: Executing the Analyses and Interpreting the ResultsStep 5: Visually Presenting Your InsightsNotes Regarding this ProcessTools and Quick Alternatives to CRM Data AnalysisOther Types of Research You Can ConductUsing Sales Data Analytics ToolsBuilding Your Own Analytics System by Connecting Your CRM with a Business Analytics PlatformAs I have written in my previous introductory post, CRM data stores contain extremely rich, multi-faceted, and interconnected datasets that are invaluable sources of information on a company’s markets, customers, and sales and marketing operations. These latent treasure troves of data just need to be teased out with the appropriate analyses, but it is extremely important that these analyses be set up as correctly and as optimally as possible from the start. Otherwise, it can be difficult to avoid some nasty data issues, troublesome statistical roadblocks, unanticipated rework, or unnecessary side projects — all of which can pop up if you approach CRM data analysis in an ad hoc manner. Therefore, without further ado, I would like to share the high-level steps in a well-structured CRM data analysis exercise, based on the many projects we have completed for our portfolio companies over the years.Step 1: Investigating the Ins and Outs of Your CRM DataThe first step of effectively mining your CRM for valuable insights and data is to survey the landscape by getting full access to your CRM system as well as any online or onsite backup data storage device where CRM data might also be archived. You should review the setup of the CRM data tables and — if you don’t have a solid understanding of it already — get a good rundown of how your sales and marketing teams have been using the data. The immediate goal is to form an understanding of the following:the types of data availabletheir sources (manually entered, imported, or machine-generated)their formatshow to extract the data out of the current systemsYou should also evaluate the coverage of common and possibly important data fields (the percentage of records that are filled out), and how the different data tables are related to each other (e.g. how accounts are related to contacts, and contacts to activities or opportunities, etc.). Another very important step here is to make sure you understand the pathologies of the data, itself — the number and causes of corrupted records, duplicates, missing values, censored values, etc. Any sufficiently large dataset will contain errors and issues, and CRM data is particularly susceptible because it is mostly manually entered, and is a mixture of structured and unstructured data. Tip: Don’t dive in without investigating the pool. Note that in this step, you are not yet analyzing the data in the traditional sense. Instead, you are really sizing it up first to see exactly how and when you can use it.Step 2: Grouping the Data TogetherTo do anything meaningful with the data, you need to get it together in an easily access place — for example, as a series of spreadsheets, a set of interconnected tables, or a whole relational database that allows you to run queries and reports. Not only will you need to extract the raw data from your CRM, you’ll also need to deal with the data issues that crop up through the standardization of format and normalization of data values. There are a lot of good practices around these steps, so I will just refer you to some good resources below: Data cleaning in ExcelUsing a Spreadsheet to Clean Up a Dataset via School of DataTop 10 Ways to Clean Your Data via MicrosoftUsing Excel to Clean and Prepare Data for Analysis via SIOP.orgData cleaning with other tools (R and Google OpenRefine)An Introduction to Data Cleaning with R via The Comprehensive R Archive NetworkUsing Google Refine to Clean Messy Data via ProPublicaJust as importantly, you need to structure the data around the unit of analysis, be it individual customer account, individual contacts, or — at a higher level — segment of customers. Having defined that, you can then define indices that let you link the data tables in the CRM data together, so that they are all nicely tied around the unit of analysis and let you slice and dice the data in any way you want during the next step.Defining the Units of AnalysisI do want to take a minute here to focus on the idea of the “unit of analysis”, which is central in setting up the data tables in the optimal way. There is a natural hierarchy of records in a modern CRM system, which is really a product of how sales and marketing organizations think about the targets of their efforts — the customers. At the most general level, markets think of “the total addressable market” as the aggregate of all potential customers, who are typically grouped into distinct “market segments”. In each market segment, the customers are supposed to have similar needs and buying behavior, so you can develop “ideal customer” profiles. In B2B markets, the customer is typically a business, so they are not represented by a single individual, but rather there will be several contacts for each customer organization. Each of these contacts fall into a particular “buyer persona” that helps define their distinct needs, etc. There might be one or multiple buyer personas at a customer organization in a given market segment. For each of these contacts, sales and marketing efforts are captured by recording their “activities” and “touchpoints,” and a potential purchase is typically called an “opportunity” by the selling organization. Naturally, there might be multiple sales opportunities associated with a given customer, each of which might be related to one or more contacts. Any of these types of entities can be the object of an analysis. Moreover, you can aggregate analyses of a lower level entity to get to a rich perspective on the higher-level entity. For example, studying behavior of all contacts of customers in a single segment allow you to make broad analysis of the segment, itself. At the same time, you may not have sufficient data to analyze certain types of entities, especially lower-level data. Sometimes, you just need to get a sample of the lower-level entities to support the analysis at a higher level.Conducting an Exploratory AnalysisOnce you have gotten all the data in place, you will want to start doing some data profiling and initial exploratory analysis of the data you have pulled together in order to a) develop a sense of the data; and b) detect any potential issue early on. An exploratory analysis can be done simply using the basic functions in Excel such as AVERAGE(), STDEV(), MAX(), MIN(), MEDIAN(). These functions are flexible enough to ignore blank or erroneous data points, and so are easily applied without requiring a lot of preparatory work. However, keep in mind that you are simply exploring the data to gather initial intelligence, and you are not relying on these analyses to make your final conclusions. Doing light exploratory analysis will also enable you to detect any systematic issue with the data and see what valuable information you might need to append to the data using external sources (for example, in a segmentation analysis, you will need data on potential segmentation variables). Okay, so that’s almost 1,000 words just to get us to the point where the data is pulled together. That seems like quite a lot of work even before we get to analyzing the data! Trust me though, this hard work will pay off handsomely in the end. Image courtesy of Lynn Friedman Step 3: Mapping Out Your Analyses Editor’s note: This is the second post in a series on how to conduct CRM data analysis. To go back to the first post in the series, click here. I hope you are still with me after that arduous step of getting your data pulled together and set up for the big analysis. You’re closer to uncovering a hidden treasure trove of customer insights, but before you dive in you still need to develop your game plan first. In fact, that’s the true secret of high-impact data analysis work — mapping out your results before you even do the work. By this point, you’ve pulled your data together, but you’re still not quite ready to analyze it. First, you need to work on mapping out the analytical steps you are going to perform. Because there are millions of potential analyses you can do on any sufficiently rich datasets, it is important that you limit your focus strictly to the analyses that will contribute to your objectives. Therefore, you should start first by defining the kind of conclusions that you want to get, and work backwards from the expected results to the analyses that will provide those results (or prove otherwise). Free In-Depth Guide You can read more about how we apply this approach to “reverse-engineer” the expected outputs in our in-depth guide to buyer insights research: Setting the Foundation of Your Analysis: Identifying Two Basic ComponentsAt this point, even if you are not 100% sure the exact types of results you want to get with the analysis, it is still beneficial to think about the following:the quantity you are trying to evaluatewhat you are trying to juxtapose it againstThis is generally in the form of “analysis of X over Y”. For example, are you interested in trends over time, or in productivity measures across the sales team, or in segmentation characteristics across the customer base? I mention this type of analysis specifically because it is usually the most common of data analysis (that’s why they built it into the function in Excel called the “Pivot Table”), and it is also a go-to exercise that will help you develop insights or deeper questions for even more valuable analysis. Once you have narrowed your focus on a specific set of possible conclusions, work backwards to build the analytical steps and data setup that will help you produce those outputs. Tip: Do NOT do any extraneous data work or ad hoc analysis, as those will not get you to the answers, and will only suck away your time and attention.Common Types of Analyses You Can Do with CRM DataAs a reference, below I’ve provided a list of analyses that you can do with CRM data. It is in no way exhaustive, but I do hope it can get you thinking about the wide range of analysis and tools you can use. Insights For Unit of Analysis Required Data Typical OutputsMarketing StrategyLeads/Contactsleads/contacts demographic dataactivity datalead/contact conversion dataprevalent characteristics of leads/contactsconversion rateseffectiveness of sales & marketing activities Leads/Contactslead source datalead stage history dataweb traffic datalead volume and conversion rates of each lead sourcelead volume trend over timeMarketing Campaignsleads/contacts associated with campaignsconversion & activities datacampaign costsperformance of campaignsconversion ratescost per opportuntycost per leadavg. time taken per conversionSales OperationsAccounts & Opportunitiesopportunity dataopportunity history dataaccount demographic datasegmentation of opportunities and accounts by demographic and firmographic factorsconversion ratessales cycle stages and lengthsOpportunities & Contactsopportunity history dataassociated contacts and associated activities historybuyer roles and buyer personasOpportunitiesopportunity historyassociated opportunity ownersales rep performance analysisopportunity coverage analysisCustomer Onboarding & Success Accountsaccount demographic informationbilling informationassociated contacts and historycurrent customer segmentationuse case analysisbuyer and user personasSupport Casesactivities datasuccess metricscustomer support Step 4: Executing the Analyses and Interpreting the ResultsOnce you have fully fleshed out your plan and properly prepared, you are finally ready to dive in and start analyzing the data with your powerful toolsets of statistical models and data manipulation scripts. At this point I strongly recommend setting up templates and automation steps, so that when you redo the analysis with a subset of the data or an entirely different dataset, you do not have to start from scratch. Again, for each of these analyses, think of the ultimate answers that you are looking for, and optimize your calculation steps so that you get exactly those answers — no more, no less. The less data you touch, the fewer the steps you carry out, the less error prone your results are, and the easier it is to replicate your work. For each completed analysis, try to stay focused on the evidence that you are trying to get and the hypothesis you are trying to prove or disprove, so that you can sharply evaluate the results and avoid getting bogged down in analysis paralysis.Step 5: Visually Presenting Your InsightsTo really make an impact with your analysis, you will need to pull together all of the disparate results, and most importantly, connect the dots together to form a holistic view and a consistent narrative of the insights that arise. In planning your delivery of this narrative, you should consider your audience — what assumptions do they have, and what tone/approach do you want to take in delivering the story to them? You can choose to be explanatory, educational, contrarian, visionary, or practical, all depending on your objectives and the audience you are working with. There is no lack of visual aids, interactive content, and multimedia platforms to help you get your point across, but they have to be consistent with your narrative and the tone you want to project.Notes Regarding this ProcessThere’s nothing too ground breaking about the steps I described above. If anything surprised you, it’s probably the amount of time I spent describing the setup steps (which all together make up three out of the five steps) rather than describing the far cooler and more exciting data analysis and visualization tools that really bring the data to life. However, I would argue that getting your proverbial data analysis ducks in a row successfully is actually the most important part of doing data analysis. Moreover, I also want to stress the distinction between what this analysis is: a one-time analysis that encompasses the whole (or at least a substantial part) of the data store vs. what it isn’t: a management report/dashboard that is meant to be refreshed regularly and often. Our approach here should apply mostly to one-time/infrequent analysis that helps show a snapshot in time in-depth. It provides an in-depth look at the data from multiple angles and perspectives. Because of its thoroughness, it helps to avoid data errors, seasonality biases, and provides valuable, hidden insights on the customer interaction data such as segmentation, long-term trends, or unexpected correlation between different aspects of the sales process. It is not meant to be repeated regularly to identify trends as they happen, nor to be used as part of a dashboard to manage activities, productivities etc. Those are reports and analyses that help management teams make day-to-day decisions and therefore are more of a check on the pulse of what is going through the CRM on a daily, weekly, and monthly basis. I still think that the overall hypothesis-driven analytical approach applies, but clearly when a report is to be run regularly, requiring all of the standard work involved in cleaning, de-duplication, and normalizing data will be too impractical. Nevertheless, you may still find that this approach is too complicated or time consuming. This is fair, especially if you are tight on resources and time. In the next section, I will be discussing alternatives to this full-on analysis approach that you can still utilize to get some of the insights you are looking for. While every alternative still requires a lot of work, in some cases you can consider software tools or services providers that will help reduce the burden tremendously (not to mention some of them are really cool).Tools and Quick Alternatives to CRM Data Analysis Editor’s note: This is the third post in a series on how to conduct CRM data analysis. To go back to the first post in the series, click here. In the previous sections, I described an approach to planning and structuring CRM data analysis. I placed specific emphasis on the steps of setting up the analysis and preparing the input data. And for good reason — those steps are essential to a successful CRM data analysis project. The approach I described is multi-purpose and versatile, and can be applied to analyze any aspect of the CRM data, for any given operational management and decision making purposes. For example, the process can be used to help optimize demand generation tactics as well as sales and business activities such as benchmarking or customer onboarding and success management. However, it’s worth pointing out that the amount of work required in this approach can be too burdensome for a team with limited time and resources. It also isn’t necessarily the best approach for a team looking for real-time trends and analytics to make quick, reactive decisions. It may also be too involved for an early-stage company, which typically has few sales people and even less CRM data on record, since much of the sales process there happens organically through personal, direct contacts. Before I close out this series, I want to address these concerns by noting alternatives to doing the full-blown CRM analysis. There are definitely many shorter and easier ways to get insights, but do note that they all involve one level of tradeoffs or another. What you will gain in time and effort saved will be counterbalanced by reduced specificity, accuracy, or customization. What is most important is to consider the different options and select one that is most pragmatic for your current level of resources and needs.Other Types of Research You Can ConductYou can commission other research projects to learn about your market, your customers, and your own sales operations. Since you are not analyzing the granular-level, unstructured interactions data, you will want to collect structured data from other sources such as:customer surveyslost customers and prospects surveys/interviewssurveying your own sales teamcommissioning third party research into your customers and prospectsThese projects will provide very insightful quantitative and qualitative insights on your customers and sales engagement models. They also provide an outside-in, unfiltered perspective that you will not necessarily get by analyzing your CRM data alone. However, because surveys and interviews are best conducted with very specific goals in mind, you will need to be very specific about the questions you are trying to answer and form concrete hypotheses for the answers before you actually conduct the surveys. If you haven’t formed such strong hypotheses, it is best to conduct a smaller scale exploratory analysis of the CRM data with the approach I described, because that will still be less time consuming and costly than having to potentially conduct multiple rounds of customer and prospect surveys as you refine your hypotheses.Using Sales Data Analytics ToolsCRM data analysis is important enough that there are vendors who offer fully packaged, out-of-the-box software tools that plug directly into your CRM system and perform the analyses automatically. These tools fall under several categories:Marketing Performance Analysis: examples include KISSMetrics and MixpanelSales Productivity and Performance Analysis: tools such as InsightSquaredPredictive Analysis for Sales Forecasting: tools such as C9 Inc.Customer Success and Experience Management Analytics: examples include Totango, Gainsight, and more.You can find a broader list of many such tools on Docurated blog. 3 Reasons to Consider Using Data Analytics ToolsThey are easy to use and provide real time insights. Because they hook directly into your CRM and marketing automation tools, they constantly ingest data and update the analysis, allowing you to immediately see evolving trends and just in time updates.They are built on best practices and are constantly evolving based on feedback from customers like you, so you do not have to reinvent the wheel by figuring out the right analysis to do, the correct chart to show, etc. For example, InsightSquared has been providing a series of valuable guides for building the most practical sales productivity dashboards.They bring you into a community of like-minded users that can give you valuable support and ideas as you continue developing your organization’s analytics capability.3 Downsides to Using Data Analytics Tools Besides the fact that they are not free:They are often tied to only the most popular CRMs or Marketing Automation platforms, and even for those systems that they support, the integration is not always seamless and smooth, because of the volume and diversity of data that these platforms digest (essentially, the integration process is the equivalent of the data cleaning process in our approach).Because they are meant to be easy to use, they are not always very customizable and flexible in dealing with special data formats or structures, which will invariably arise when as your organization grows and becomes more sophisticated.You do not have full ownership of the analytics that these platforms produce. Not all of them will allow you to export the data that underlie their pretty charts and beautiful reports.Building Your Own Analytics System by Connecting Your CRM with a Business Analytics PlatformThere are many general-purpose business intelligence platforms out there that can process your CRM data to give you the same types of insights and analysis that you will get with either your homegrown analysis or with the sales analytics tools. Birst, Domo, LogiAnalytics and GoodData all come to mind as modern cloud tools that have ready integration with the most popular CRMs such as salesforce.com to serve CRM Analytics needs. With this approach, what you lose in best-practices-driven benchmarks and dashboards provided by the sales analytics vendors, you will gain in customization, access, and ownership of data. However, you should only consider those tools if you have a broader use case for using a BI platform for your business — maybe you have similar needs in other teams that justify getting one of those platforms. Lastly, even though these BI tools are becoming easier to use, they are still very powerful tools that require specialized training and a fair amount of data integration work, and it is worthwhile to consider the cost and benefits of doing that work while weighing it against other options. Are there other resources and tools that you have used for your own CRM analysis? Please share with us and the audience here. Photo by: Binary KoalaAddThis Sharing ButtonsShare to FacebookFacebookShare to TwitterTwitterShare to PrintPrintShare to EmailEmailShare to MoreAddThis16