![Page 1: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/1.jpg)
Measuring Your SEO InsightsTori Cushing | @toricushing
bit.ly/tori-smx-deck
![Page 2: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/2.jpg)
Why is showing ROI so hard for marketers?
@toricushing bit.ly/tori-smx-deck
![Page 3: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/3.jpg)
How do we solve this problem?
Bad Communication
@toricushing bit.ly/tori-smx-deck
![Page 4: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/4.jpg)
Solution? Reporting.
@toricushing bit.ly/tori-smx-deck
![Page 5: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/5.jpg)
More specifically,
Solution? Reporting.
@toricushing bit.ly/tori-smx-deck
![Page 6: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/6.jpg)
More specifically, reporting with clear metrics that support the goals of your company/brand.
Solution? Reporting.
@toricushing bit.ly/tori-smx-deck
![Page 7: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/7.jpg)
Goals
@toricushing bit.ly/tori-smx-deck
![Page 8: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/8.jpg)
What are your goals?
@toricushing bit.ly/tori-smx-deck
![Page 9: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/9.jpg)
v Increase traffic to the blog by 30% in 2015
Specific Goals
@toricushing bit.ly/tori-smx-deck
![Page 10: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/10.jpg)
v Increase traffic to the blog by 30% in 2015
v Increase Free Trial Signups by 15% in 2015
Specific Goals
@toricushing bit.ly/tori-smx-deck
![Page 11: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/11.jpg)
Pre-Data Analysis
@toricushing bit.ly/tori-smx-deck
![Page 12: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/12.jpg)
What data do we need?
@toricushing bit.ly/tori-smx-deck
![Page 13: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/13.jpg)
What data do we need? What pages/topics on Moz are better for our visitors?
@toricushing bit.ly/tori-smx-deck
![Page 14: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/14.jpg)
What data do we need? What pages/topics on Moz are better for our visitors?
@toricushing bit.ly/tori-smx-deck
![Page 15: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/15.jpg)
Dig for the Data Google Analytics First…
@toricushing bit.ly/tori-smx-deck
![Page 16: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/16.jpg)
Google Analytics: Landing PageGA wants you to:Campaigns >Organic KWs >Landing Page
@toricushing bit.ly/tori-smx-deck
![Page 17: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/17.jpg)
Google Analytics: Landing PageBut then you get sampling… (8.98% of Sessions)
@toricushing bit.ly/tori-smx-deck
![Page 18: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/18.jpg)
@toricushing bit.ly/tori-smx-deck
![Page 19: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/19.jpg)
Google Analytics: Landing PageAcquisition > Channels > Organic Search
@toricushing bit.ly/tori-smx-deck
![Page 20: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/20.jpg)
Google Analytics: Landing PageLanding Page Report
@toricushing bit.ly/tori-smx-deck
![Page 21: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/21.jpg)
Google Analytics: Landing PageChange the Date Range
@toricushing bit.ly/tori-smx-deck
![Page 22: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/22.jpg)
Google Analytics: Landing PageChange show rows to how many you want to export
@toricushing bit.ly/tori-smx-deck
![Page 23: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/23.jpg)
Google Analytics: Landing PageExport to Google Docs
@toricushing bit.ly/tori-smx-deck
![Page 24: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/24.jpg)
Google Analytics: Landing PageExport to Google Docs
@toricushing bit.ly/tori-smx-deck
![Page 25: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/25.jpg)
Dig for Moar Data SemRush
@toricushing bit.ly/tori-smx-deck
![Page 26: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/26.jpg)
SEMRush: Organic KeywordsEnter Domain:Positions >Organic Keywords
@toricushing bit.ly/tori-smx-deck
![Page 27: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/27.jpg)
SEMRush: Organic KeywordsHistorical Data:April 2015
@toricushing bit.ly/tori-smx-deck
![Page 28: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/28.jpg)
SEMRush: Organic KeywordsOrganic Search Positions:Export
@toricushing bit.ly/tori-smx-deck
![Page 29: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/29.jpg)
SEMRush: Organic KeywordsExport Data >Copy into our GA Google Sheet
@toricushing bit.ly/tori-smx-deck
![Page 30: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/30.jpg)
@toricushing
SEMRush: Organic Keywords
bit.ly/tori-smx-deck
![Page 31: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/31.jpg)
@toricushing
SEMRush: Organic KeywordsUsually, GA exports URI … We pull in the host name, so it’s a bit different for us.
You may need to find and replace you domain.
bit.ly/tori-smx-deck
![Page 32: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/32.jpg)
SEMRush: Organic KeywordsTa-da!
@toricushing bit.ly/tori-smx-deck
![Page 33: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/33.jpg)
v Raw data tabs: back, back, back it up
@toricushing
SEMRush: Organic Keywords
bit.ly/tori-smx-deck
![Page 34: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/34.jpg)
Marrying the Data
@toricushing
bit.ly/moz-reporting-doc
bit.ly/tori-smx-deck
![Page 35: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/35.jpg)
@toricushing bit.ly/tori-smx-deck
![Page 36: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/36.jpg)
Google Sheets: Reporting
Chocolate Vanilla
Google Analytics SEMRush
@toricushing bit.ly/tori-smx-deck
![Page 37: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/37.jpg)
@toricushing bit.ly/tori-smx-deck
![Page 38: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/38.jpg)
Google Sheets: ReportingBeautiful Marble Ice Cream!
@toricushing bit.ly/tori-smx-deck
![Page 39: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/39.jpg)
Google Sheets: ReportingMad skillz needed for learnage:
v Pivot Tables v Index Match v Formatting
@toricushing bit.ly/tori-smx-deck
![Page 40: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/40.jpg)
@toricushing bit.ly/tori-smx-deck
![Page 41: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/41.jpg)
Google Sheets: ReportingGet rid of baggage. Delete:
v CPC v Traffic % v Traffic Cost % v Trends v Timestamp
@toricushing
Google Analyticsv New Users v Avg. Sessions v Ecommerce Conversion Rate v Transactions v Revenue
SEMRush
bit.ly/tori-smx-deck
![Page 42: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/42.jpg)
Google Sheets: Format
@toricushing
v Business logo v Data Labels v Date Range
My formatting best practices:
v Branded colors v Table formatting v Sections marked
bit.ly/tori-smx-deck
![Page 43: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/43.jpg)
Google Sheets: Reporting
@toricushing
Title, Manager, Context, Date, Brand Logo
bit.ly/tori-smx-deck
![Page 44: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/44.jpg)
Google Sheets: Reporting
@toricushing
Sections Marker (part 1) and pasting in data
bit.ly/tori-smx-deck
![Page 45: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/45.jpg)
Google Sheets: FormatHack Google Sheets: Table Formatting
@toricushing bit.ly/tori-smx-deck
![Page 46: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/46.jpg)
Google Sheets: FormatHack Google Sheets: Table Formatting
@toricushing
Bold the text on title row, and turn it white. Then add a branded color solid background.
bit.ly/tori-smx-deck
![Page 47: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/47.jpg)
Google Sheets: FormatHack Google Sheets: Table Formatting
@toricushing bit.ly/tori-smx-deck
![Page 48: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/48.jpg)
Google Sheets: FormatHack Google Sheets: Table Formatting
@toricushing
Add borders as an outline and the middle row. In the branded color, of course.
bit.ly/tori-smx-deck
![Page 49: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/49.jpg)
Google Analytics, not as easy...
@toricushing bit.ly/tori-smx-deck
![Page 50: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/50.jpg)
Google Sheets: Reporting
@toricushing bit.ly/tori-smx-deck
![Page 51: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/51.jpg)
Google Sheets: Reporting
=IFERROR(INDEX(column to return value from, MATCH( $lookup value, $column to look against, 0), “”))
@toricushing bit.ly/tori-smx-deck
![Page 52: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/52.jpg)
Google Sheets: Reporting=IFERROR( INDEX( column to return value from, MATCH( $lookup value, $column to look against, 0), “”))
@toricushing bit.ly/tori-smx-deck
![Page 53: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/53.jpg)
@toricushing bit.ly/tori-smx-deck
![Page 54: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/54.jpg)
Google Sheets: Reporting=IFERROR( INDEX( column to return value from, MATCH( $lookup value, $column to look against, 0), “”))
@toricushing bit.ly/tori-smx-deck
![Page 55: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/55.jpg)
@toricushing bit.ly/tori-smx-deck
![Page 56: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/56.jpg)
@toricushing bit.ly/tori-smx-deck
![Page 57: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/57.jpg)
Google Sheets: Reporting=IFERROR( INDEX( column to return value from, MATCH( $lookup value, $column to look against, 0), “”))
@toricushing bit.ly/tori-smx-deck
![Page 58: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/58.jpg)
Google Sheets: Reporting=IFERROR( INDEX( column to return value from, MATCH( $lookup value, $column to look against, 0), “”))
Exact Match
@toricushing bit.ly/tori-smx-deck
![Page 59: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/59.jpg)
Google Sheets: Reporting=IFERROR( INDEX( column to return value from, MATCH( $lookup value, $column to look against, 0), “”))
@toricushing bit.ly/tori-smx-deck
![Page 60: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/60.jpg)
@toricushing bit.ly/tori-smx-deck
![Page 61: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/61.jpg)
@toricushing bit.ly/tori-smx-deck
![Page 62: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/62.jpg)
@toricushing
Google Sheets: %∆ Change
bit.ly/tori-smx-deck
![Page 63: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/63.jpg)
Google Sheets: Reporting
@toricushing bit.ly/tori-smx-deck
![Page 64: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/64.jpg)
Google Sheets: %∆ Change
@toricushing
=(New – Old)/Old
bit.ly/tori-smx-deck
![Page 65: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/65.jpg)
But wait… there’s more!
@toricushing bit.ly/tori-smx-deck
![Page 66: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/66.jpg)
Google Sheets: Pivot Tables
@toricushing bit.ly/tori-smx-deck
![Page 67: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/67.jpg)
Google Sheets: Pivot Tables
@toricushing bit.ly/tori-smx-deck
![Page 68: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/68.jpg)
Google Sheets: Pivot Tables
@toricushing bit.ly/tori-smx-deck
![Page 69: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/69.jpg)
Google Sheets: Pivot Tables
@toricushing bit.ly/tori-smx-deck
![Page 70: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/70.jpg)
Google Sheets: Pivot Tables
@toricushing
Order by sessions:
bit.ly/tori-smx-deck
![Page 71: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/71.jpg)
Moar formatting!
@toricushing bit.ly/tori-smx-deck
![Page 72: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/72.jpg)
Google Sheets: Pivot Formatting
@toricushing bit.ly/tori-smx-deck
![Page 73: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/73.jpg)
Google Sheets: Pivot Formatting
@toricushing bit.ly/tori-smx-deck
![Page 74: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/74.jpg)
Google Sheets: Pivot Formatting
@toricushing bit.ly/tori-smx-deck
![Page 75: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/75.jpg)
Google Sheets: Pivot Formatting
@toricushing bit.ly/tori-smx-deck
![Page 76: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/76.jpg)
Google Sheets: Pivot Formatting
@toricushing bit.ly/tori-smx-deck
![Page 77: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/77.jpg)
Google Sheets: Pivot Formatting
@toricushing bit.ly/tori-smx-deck
![Page 78: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/78.jpg)
Post Analysis
@toricushing bit.ly/tori-smx-deck
![Page 79: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/79.jpg)
Annotations
@toricushing
KPIs for Landing Page Analysis:
bit.ly/tori-smx-deck
![Page 80: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/80.jpg)
Annotations
@toricushing
KPIs for Landing Page Analysis:v New users love “how to” posts and tutorials
bit.ly/tori-smx-deck
![Page 81: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/81.jpg)
Annotations
@toricushing
KPIs for Landing Page Analysis:v New users love “how to” posts and tutorials
v Large amount of our traffic is from beginner SEOs
bit.ly/tori-smx-deck
![Page 82: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/82.jpg)
Annotations
@toricushing
KPIs for Landing Page Analysis:v New users love “how to” posts and tutorials
v Large amount of our traffic is from beginner SEOs
v Users love OSE and stay on the site for a while because of it.
bit.ly/tori-smx-deck
![Page 83: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/83.jpg)
Annotations
@toricushing
KPIs for Landing Page Analysis:v New users love “how to” posts and tutorials
v Large amount of our traffic is from beginner SEOs
v Users love OSE and stay on the site for a while because of it.
v Users like moz.com/learn/seo for keywords and meta descriptions
bit.ly/tori-smx-deck
![Page 84: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/84.jpg)
Strategy
@toricushing
What now?
bit.ly/tori-smx-deck
![Page 85: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/85.jpg)
Strategy
@toricushing
What now?v Create “how to” posts and walkthroughs of beginner SEO
tasks.
bit.ly/tori-smx-deck
![Page 86: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/86.jpg)
Strategy
@toricushing
What now?v Create “how to” posts and walkthroughs of beginner SEO
tasks.
v Build out a beginners guide to link building for Open Site Explorer
bit.ly/tori-smx-deck
![Page 87: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/87.jpg)
Strategy
@toricushing
What now?v Create “how to” posts and walkthroughs of beginner SEO
tasks.
v Build out a beginners guide to link building for Open Site Explorer
v Video tutorials for keyword research in Rank Tracker
bit.ly/tori-smx-deck
![Page 88: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/88.jpg)
Strategy
@toricushing
What now?v Create “how to” posts and walkthroughs of beginner SEO
tasks.
v Build out a beginners guide to link building for Open Site Explorer
v Video tutorials for keyword research in Rank Tracker
v Video tutorials for checking meta descriptions in Crawl Test
bit.ly/tori-smx-deck
![Page 89: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/89.jpg)
That’s it!
@toricushing bit.ly/tori-smx-deck
![Page 90: Tori Cushing - Actionable SEO Insights - SMX 2015](https://reader031.vdocuments.us/reader031/viewer/2022021921/58f9a9a9760da3da068b70ed/html5/thumbnails/90.jpg)
@toricushing bit.ly/tori-smx-deck