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:

Organize your Analytics account

 

(more…)

Core fundamentals of Analytics Data

Dimensions and metrics

Understand the building blocks of your reports.

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”, from which a session originates. The dimension Page indicates the URL of a page that is viewed.

Metrics are quantitative measurements. The metric Sessions is the total number of sessions. The metric Pages/Session is the average number of pages viewed per session.

The tables in most Analytics reports organize dimension values into rows, and metrics into columns. For example, this table shows one dimension (City) and two metrics (Sessions and Pages/Session).

https://support.google.com/analytics/answer/1033861

 

 


(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 return the 2nd word in the range A1:A7, the most frequently occurring word.

Two-column Lookup

This example teaches you how to perform a two-column lookup in Excel. See the example below. We want to look up the salary of James Clark, not James Smith, not James Anderson.

1. To join strings, use the & operator.

Excel formula tutorial: How to use COUNTIF, SUMIF, or AVERAGEIF functions

Introduction
1. Formula and Function Tips and Shortcuts
2. Formula and Function Tools
3. IF and Related Functions
4. Lookup and Reference Functions
5. Power Functions
6. Statistical Functions
7. Math Functions
8. Date and Time Functions
9. Array Formulas and Functions
10. Reference Functions
11. Text Functions
12. Information Functions
Conclusion

Keyword Tools

Cool Keyword tools to link relative other keywords

My favourite are:

http://answerthepublic.com/ : Keyword tools – UK visual keyword research

http://lsigraph.com    Start generating Latent Semantic Indexing (LSI) Keywords for your SEO needs with our free LSI Keyword Generator tool.

https://app.kwfinder.com/      KW Finder is a keyword research and analysis tool generating hundreds of long tail keywords with low SEO difficulty

https://keywordseverywhere.com/ A browser addon that will get you FREE search volume, CPC & competition data for almost all the keyword research tools out there!

https://www.semrush.com  All-in-one Marketing Toolkit
https://ahrefs.com/keywords-explorer

https://adwords.google.com/KeywordPlanner   Keyword Research & Strategy with Keyword Planner

https://serps.com/tools/keyword-research/   magically fast & free keyword research and suggestion tool (formally Keywordini).

________

https://ubersuggest.io/ Ubersuggest’s Free Keyword Tool, Generate More Suggestions

https://moz.com/products/pro/keyword-explorer    By MOZ One tool to discover and prioritize the best keywords to target.

http://keywordtool.io/  Autocomplete to generate hundreds of relevant long-tail keywords for any topic

Optimise Local Search Rankings

10  Strategies to Boost Your Local Search Rankings

1. Update Your Business’ Information
2. Fill Out the Local Listings
3. Create Some Buzz About Your Establishment
4. Get the Right Local Keywords and Make Good Use of Them
5. Ensure Your Website is Compatible with All Devices
6. Interact with Your Customers; Ask for Reviews
7. Make Good Use of Social Media
8. Visual Content is Important
9. Strictly Abide by Your Hours
10. Invest in a Mobile App

https://is.gd/vZwDvL

Understanding Google Analytics

Understanding Google Analytics for SEO

Keywords
Geo data
Referal urls
Time spent on site
Bounce rate

E-commerce
E-commerce Conversion Rate
Ecommerce Transactions & Transaction IDs
Revenue
Average Order Value
Unique Purchases
Quantity
Average Quantity
Average Price
Product Revenue
Per Session Value

Ecommerce Data

The ecommerce data is made up of transaction data and item data.
Transaction Data
Transaction Data provide details about users’ transactions like:
Transaction ID (or order ID).
Store or affiliation name.
Total revenue generated from the transaction (can also include shipping cost and taxes)
Total tax associated with the transaction.
Total shipping cost associated with the transaction

E-Commerce Tracking in Google Analytics – Complete Guide

(more…)