Data Analysis

Google Analytics and other methods of data analysis

Google Optimize

Google new tool Google Optimize Test, adapt, personalize. Learn about Google Optimize and more. Get started with Google Optimize, learn about the updates to Google Data Studio, get inspired by fresh Analytics case studies and more in our latest monthly update. https://optimize.google.com/optimize/home/#/accounts

Google Analytics Data collection and configurations

Organising your Analytics accounts Overview and cross domain tracking. There are a number of different ways to organize your Analytics accounts, properties, and views, depending on how your business is organized. Layout Setting Up Data Collection and Configuration For more information: Example account structures Working with multiple trackers About Roll-Up Reporting About cross domain tracking Organize …

Google Analytics Data collection and configurations Read More »

Core fundamentals of Analytics Data

Dimensions and metrics Understand the building blocks of your reports. In this article: Overview Valid dimension-metric combinations How metrics are calculated Attribution models Overview Every report in Analytics is made up of dimensions and metrics. Dimensions are attributes of your data. For example, the dimension City indicates the city, for example, “Paris” or “New York”, …

Core fundamentals of Analytics Data Read More »

Most common functions in excel

http://www.excel-easy.com/examples/most-frequently-occurring-word.html Most Frequently Occurring Word COUNTIF function to count the number of occurrences of each word. The MATCH function returns the position of a value in a given range. To find the position of the most frequently occurring word (don’t be overwhelmed), we add the MODE function Use this result and the INDEX function to …

Most common functions in excel Read More »