Read Analytics and Data Analysis Blog News

Online Marketing and Net Present Value (NPV) Calculator: Microsoft Excel Template
The Microsoft Excel Net Present Value (NPV) Calculator template will help marketing analysts calculate the payback from an online marketing campaign. The NPV template contains columns into which campaign assumptions may be entered: fixed costs, variable costs, interest rate, and profit per campaign responder. The Microsoft Excel template also includes calculations for incremental revenue, cost-savings and net cash flow that a marketing campaign might generate. An NPV calculation determines whether the profit realized from a marketing campaign over – for example, 5 years – covers the capital costs required to conduct it. This cost includes the compounded interest (eg. based on interest rate) of investing money into the marketing campaign. The Microsoft Excel NPV template is free and compatible with MS Excel 2003 or later.

Get NPV analysis and software marketing tips

Online Marketing and Interactive Business Planner Software
Marketing consultants, marketing specialists and entrepreneurial marketing professionals can build a business plan with an Interactive Business Planner Online Software. The Internet-based software guides a marketing plan writer through the development process with a business plan outline that may be completed section-by-section. Marketing plan sections include space for a Business Overview, Industry Overview and Marketing Strategy into which marketing details and business assumptions may be written. The business planner also provides online templates for doing financial projections, creating financial statements and entering detailed business expenses. There are also business plan samples that a marketing consultant, marketing specialist or marketing entrepreneur may reference to develop their own marketing plan.

Get business plan and software marketing tips

Online Marketing and Marketing ROI Calculator: Direct Mail and E-mail Marketing Campaign ROI
Direct marketers may use the Marketing Today Marketing ROI Calculator to compute a direct marketing campaign’s return on investment (ROI). The calculator contains fields for entering the following data regarding a direct mail or e-mail marketing campaign: number of campaign targets, marketing program costs, campaign response and conversion rates, as well as an average profit per sale value. An overall ‘Marketing ROI’ statistic is automatically calculated after the ‘Calculate’ button is clicked. A reasonable marketing campaign ROI benchmark is 10%, but return is influenced by an organization’s capital costs (eg. cost of borrowing).

Get ROI analysis and software marketing tips

Online Marketing and Survey Monkey: Online Survey Software and Questionnaire Tool
Survey Monkey is on online survey research and data analysis software, and it includes helpful online survey, research and data analysis tutorials. Custom market research surveys may be designed with Survey Monkey’s easy-to-use online forms. Surveys can include a variety of question formats: scaled, attitudinal (eg. 1-10 satisfaction scales), categorical response (eg. gender, income range) and open-ended (eg. text-based answer to a question, box for entering one’s age) questions. A market research professional may view daily reports of how many respondents complete a survey as well as detailed question-by-question statistics. Survey responses may also be exported to Microsoft Excel for further analysis. Lists of survey participants (eg. names, e-mail addresses, market segment flags) may be imported into Survey Monkey. The basic online survey tool is free, but more advanced Survey Monkey features are available for a monthly fee.

Get market research survey and software marketing tips

Online Marketing and Hashtags.org: Online Twitter #Hashtag Search Trend Software
On Hashtags.org, Twitter social media marketers may enter a hashtag keyword – such as #socialmediamarketing, #marketing, or #analytics – in a search box. Hashtags.org will return a time-series chart indicating a hashtag term’s popularity within the Twitter community as well as a list of handles who have recently tweeted on the hashtag subject. Including popular hashtags within a Tweet will increase the Twitter audience base that is likely to read it. The Hashtags.org time-series chart shows the relative popularity of a particular hashtag term versus all other keywords for each day. It does not display the absolute number of daily searches that were conducted for a specific hashtag term.

Get Twitter online software and marketing tips

Online Marketing and Bing Webmaster Tools: Online SEO Web Analysis Software
The Bing Webmaster Tools online SEO software suite includes the former Yahoo! Site Explorer tool for doing external and internal website link analysis. SEO professionals may improve organic search traffic to a client’s website based on keyword research insight about how visitors find it. Bing’s crawl activity, index coverage, and website traffic statistics help web optimizers to understand the frequency with which search engines crawl a website. A sitemap may be uploaded within Bing Webmaster to improve the likelihood that Google, Bing, and Yahoo! search engines crawl a website. There are also settings that allow a web professional to control which pages search engines may crawl and block URLs from being viewable in search engine results pages (SERPs). SEO professionals may sign-up to use Bing Webmaster Tools for free with a Windows Live ID.

Get SEO analysis software and online marketing tips

Online Marketing and 2011 Census: Statistics Canada’s Five-Year Population Profile
Marketing analytics in Canada depends on rich data about the country’s population that is generated every five years by Statistics Canada’s Census: 2011 Census data is now available. The 2011 Census: Population and dwelling counts summarizes population and dwelling counts for provinces and Census Metropolitan Areas (CMAs). It also identifies regions where growth has either increased or decreased. Statistics Canada provides an analysis of Canada’s population and dwelling counts in this data report: The Canadian Population in 2011: Population Counts and Growth. In addition to providing detailed population and dwelling counts, the Census gives insight into consumer spending, income and education levels, and attitudes on topics such as energy conservation.

Get Statistics Canada data analysis and software marketing tips

Online Marketing and Website Optimizer: Google’s Free Web Analytics A/B Research Software
Google’s Website Optimizer A/B web analytics research software allows web analytics professionals to test which web page content and design will generate the most website visitor clicks and purchases. For example, two web pages with the same layout may be tested: each with a different headline (section1), image (section 2) and article (section 3). A web analytics professional may then direct a random sample of visitors to each test web page within Website Optimizer. The time period (eg. days, weeks) for an A/B test is also controllable in thi web analytics tool. When the A/B test period is complete, Website Optimizer creates a report to summarize each test page’s performance – by section. For example, each test page’s section 1 is compared to each other as well as a currently live web page that a web analytics professional is trying to improve. An ‘Observed Improvement’ metric for each page’s section provides a web analytics professional with an overall score of how well it performs: the higher the score for a section, the better it performs against the same section on other test and currently live pages.

Get web landing page design, software and online marketing tips

Online Marketing and Blogger
The Blogger free, online marketing blogging platform lets bloggers create a website landing page to promote content. Content RSS feeds from WordPress, Tumblr, Twitter and other social networking sites may be streamed onto a Blogger landing page. Google Adwords and YouTube videos may also be added in order to generate revenue and retain website visitors. The colour and design of every Blogger page element may be adjusted: un-clicked links, page background and text copy, for example. A Blogger blog may be submitted to Google’s search engine to increase the likelihood that Internet keyword searchers find it. Google Analytics may be linked to a Blogger page so that website visitors may be tracked according to geography, content interest and other data. Blogger is one of Google’s many free, online marketing analytics software tools by which online content marketers may promote and measure interest in articles, videos and images.

Get Blogger online software marketing tips