Using Excel for Data Clean-up and management

Microsoft Excel allows data to be combined many ways. Some techniques are IF statements, the TEXT function, PivotTables and Filtering, Grouping, VLOOKUP, HLOOKUP and MATCH.

IF Statements
For example, this allows you to summarize the data by showing how many questions were asked at the help desks and those that were asked in other customer touch point.

The TEXT function
We might want to calculate the weekday from a date. We would like Excel to tell us automatically which day of the week the transaction took place on, based on the date, to show how reference transactions were distributed over days of the week.

PivotTables and filtering
PivotTables allow you to summarise information from large data sets for analysis quickly. It is possible automatically to count, sum, sort, add, find averages, and/or spot trends, patterns and comparisons.

PivotTables allows you to view the data from different angles by dragging and dropping (pivoting) columns and headings and their related data. PivotTables are also pretty accommodating if one needs to update data, add a new record, or make other changes; the table automatically adjusts to the changes.

PivotTables are especially great for large data sets with hundreds or thousands of rows. Using a PivotTable is immensely more efficient than sorting, counting rows, or doing other manual chugging through data.

Tracking Event in Google Analytics

Track important externals links (like downloads, sign-ups, login, etc) through event tracking. An event is a user interaction with a web page element like videos or external links.

Google Analytics can’t track such events by default as they don’t generate page-views when they occur.

You can set up event tracking in GA by calling _trackEvent() method each time the user interaction you want to track occurs.

Get Optimise Tiered Pricing Model

A reason for doing tiered pricing is not to overwhelm the prospect and give me the opportunity to up-sell. It a Foot-in-the-door technique.

Sometimes prospect don’t know what they need. Tiered pricing guides them along and demystifies a complex multi-stage project.

At the same time, it caters to their growing business needs as they might not need an end-to-end service initially.