Quantifying the Incremental Impact and Halo of Top Funnel Marketing
Priority Questions to Answer
- How do I quantify the impact of top-funnel channels (OTT, Linear TV, Radio, Direct Mail)?
- How can I identify which bottom-funnel channels are directly impacted by top-funnel marketing?
Analysis Overview | |
---|---|
What You Need to See | -Performance by attribution type for new & existing users (CPA, CPO, and ROAS) -Performance by objective/tactic for new & existing users (CPA, CPO, and ROAS) -% of conversions with channel as a touchpoint -total number and % share of conversions by last touchpoint, filtered against the channel you are analyzing the impact of |
UI View to Utilize | Analytics → Reports → Attribution Report Customers → Paths |
Report to Utilize | Buckets Breakdown Report - see schema and definitions here |
1. How to quantify the impact of top-funnel channels
UI Views to Utilize
A) Reports - Analytics
-
Go to Analytics - Reports
-
Look at Channel, Tactic, or Objective level to identify true efficiency
![606B5BFE-C772-4E91-AFE9-36C153895F18_4_5005_c.jpeg 860](https://files.readme.io/95a1992-606B5BFE-C772-4E91-AFE9-36C153895F18_4_5005_c.jpeg)
- Use Customer Type filter to look at new vs. existing customers
![5AEB537E-B044-4FB2-BD5D-507934578333_4_5005_c.jpeg 276](https://files.readme.io/bbbc735-5AEB537E-B044-4FB2-BD5D-507934578333_4_5005_c.jpeg)
B) Customers - Paths
-
Go to Customers - Paths
-
Add filter for channel in "Where path contains" section on left side
![10C9AF69-9F36-41B4-9124-1444DEA0966B_4_5005_c.jpeg 430](https://files.readme.io/777db13-10C9AF69-9F36-41B4-9124-1444DEA0966B_4_5005_c.jpeg)
3. Use the Summary Stats section to see the total number of conversions with that channel as a touchpoint (overall reach)
![Screen Shot 2021-01-05 at 5.11.46 PM.png 836](https://files.readme.io/c5638dd-Screen_Shot_2021-01-05_at_5.11.46_PM.png)
2. How to identify the halo on bottom-funnel channels
A) UI Views to Utilize
Go to Customers→ Paths and then click on the middle notebook icon
![Screen Shot 2021-01-05 at 5.43.30 PM.png 2044](https://files.readme.io/ab9cad7-Screen_Shot_2021-01-05_at_5.43.30_PM.png)
B) Steps to Analyze
-
Select desired timeframe on the upper right-hand side
-
Select Last Touch from the top bar - this will show attributed conversions by last touch
![Screen Shot 2021-01-05 at 5.58.09 PM.png 1784](https://files.readme.io/df2a4e1-Screen_Shot_2021-01-05_at_5.58.09_PM.png)
- Use the filter function on the left-hand side to create the following views and copy and paste each one to a Google Sheet.
Views to include:
1- Unfiltered - Add NO filter
2- The desired channel analyzing under “where path contains”
3- The desired channel analyzing under “first touch is”
![Screen Shot 2021-01-02 at 4.56.36 PM.png 980](https://files.readme.io/2f80a7a-Screen_Shot_2021-01-02_at_4.56.36_PM.png)
**In the Google Sheet**
Create a new table that includes the conversions (converters) from the 3 three views you created above (via either a v-lookup or new table which you then pivot up)
- Rows = channels
- Columns = each of the 3 views
- Include the % of conversions for each column by totaling each column and taking the %
![7C8A63D9-F17A-450C-882C-23D40B5DBF40_4_5005_c.jpeg 500](https://files.readme.io/0e1c93a-7C8A63D9-F17A-450C-882C-23D40B5DBF40_4_5005_c.jpeg)
Example of what this analysis will look like
Updated over 3 years ago