Content building with the AIDA sales funnel

AIDA sales funnel MODEL

Awareness > Interest > Desire > Action

## Awareness / Attention##

The first hurdle for any piece of writing content is to capture the reader’s attention. To get their attention, you first have to start with a concept that’s deeply relevant and timely to the audience that you’re trying to reach. Here are some questions that you can start to ask yourself when you’re in the planning stages to help write an attention-grabber:
Who is reading this piece?
What kind of solution is this piece offering to their problem? Is it the introduction to an idea that could shift the way that they think about their lives, or a product that they can go out and buy? How, specifically, will it solve their issue?
How does my audience talk about their problems? What are powerful words or concepts that would immediately create resonance?
On that last point, let me give you an example. If you’re selling a skateboard to enthusiasts and you want to capture their attention, it’s important that you understand their internal language and approach. If your audience self identifies as “skater kids,” using that term in your headline or lead could capture their attention immediately.

EG:Search I want ________
Keyword or LSI Keywords

(more…)

Submit your Infographics Overview

Top 20 Free Infographic Directories

There are a lot of options and things to consider when submitting to infographic directories/blogs. There are some that require registration, offer paid options, and more. Is the link follow or no follow? What is the anchor text? Even if the website offers no follow links, it can still help you build traffic. Below are the top 20 free infographic directories along with the answers to some of those questions.

While they are all free, some offer paid options to expedite approval process or for guaranteed placement. Be sure to familiarize yourself with all of your options. For most of the options below, registration is not required, though you will have to provide a contact email.

(more…)

Multi-Channel Funnels paths breakdown

In Analytics, conversions and Ecommerce transactions are credited to the last campaign, search, or ad that referred the user when he or she converted. But what role did prior website referrals, searches, and ads play in that conversion? How much time passed between the user’s initial interest and his or her purchase?

The Multi-Channel Funnels reports answer these questions and others by showing how your marketing channels (i.e., sources of traffic to your website) work together to create sales and conversions.

Conversion paths
The Multi-Channel Funnels reports are generated from conversion paths, the sequences of interactions (i.e., clicks/referrals from channels) that led up to each conversion and transaction. By default, only interactions within the last 30 days are included in conversion paths, but you can adjust this time period from 1-90 days using the Lookback Window selector at the top of each report. Conversion path data include interactions with virtually all digital channels.

These channels include, but are not limited to:

(more…)

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