Get More From Your Content: Embrace Your Inner Geek.

If you like this presentation – show it...

Slide 0

Get More From Your Content: Embrace Your Inner Geek. by Matt Beswick, aged 31 and a half.

Slide 1

I have a confession. @mattbeswick

Slide 2

My friends and family have known this for a LONG time. @mattbeswick

Slide 3

I’m a geek. @mattbeswick

Slide 4

From building crap batch programs when I was 12... @mattbeswick

Slide 5

To being part of a text-based game when I was 15... @mattbeswick

Slide 6

To a hacked together Facebook game that changed my life. @mattbeswick

Slide 7

A Story of Growth... @mattbeswick

Slide 8

... and ridiculous levels of engagement. @mattbeswick

Slide 9

I’m a FAKE geek.

Slide 10

SELECT * FROM table WHERE username LIKE ‘%$username%’ @mattbeswick

Slide 11

Google Apps Scripts: Confusing. @mattbeswick

Slide 12

Eventually I make stuff work. @mattbeswick

Slide 13

So don’t be scared… @mattbeswick

Slide 14

THIS IS MY CALL TO ARMS @mattbeswick

Slide 15

Being a geek helps make life easier. @mattbeswick

Slide 16

Being a geek saves you huge amounts of time. @mattbeswick

Slide 17

But more importantly helps you get noticed. @mattbeswick

Slide 18

First. Imagine… @mattbeswick

Slide 19

#searchloveselfie @mattbeswick

Slide 20

We’ll come back to that later @mattbeswick

Slide 21

Here We Go! @mattbeswick

Slide 22

Crafting Stories @mattbeswick

Slide 23

Get Links @mattbeswick

Slide 24

Get Noticed @mattbeswick

Slide 25

Surveys FTW @mattbeswick

Slide 26

Single vs. Multiple @mattbeswick

Slide 27

@mattbeswick A List of Answers

Slide 28

@mattbeswick Multiple Questions = Crosstabs

Slide 29

It’s all about the idea, and the story. @mattbeswick

Slide 30

@mattbeswick Take The Answers & Look For Trends

Slide 31

@mattbeswick Create a list of the most interesting findings

Slide 32

Finally, get your creatives to do their thing @mattbeswick

Slide 33

Finally, get your creatives to do their thing

Slide 34


Slide 35

This is the post. BBC? TV Coverage??

Slide 36

Lessons Learned @mattbeswick

Slide 37

1. Unique data is great for outreach @mattbeswick

Slide 38

2. You’re looking for a story @mattbeswick

Slide 39

3. Where possible, include the data @mattbeswick

Slide 40

4.Follow @staceycav @mattbeswick

Slide 41

Scraping @mattbeswick

Slide 42

Disclaimer: Google Don’t Like You Doing This @mattbeswick

Slide 43

Stealing Is Naughty @mattbeswick

Slide 44

Slide 45


Slide 46

http://www.targetlocal.co.uk/tools/simple-serp-scraper/ You could use software… @mattbeswick

Slide 47

Where’s the fun in that? @mattbeswick

Slide 48

It’s Geek Time! @mattbeswick

Slide 49

PHP == Good @mattbeswick

Slide 50

http://www.google.com/search?hl=en&pws=0&q=searchlove 1. Google URL @mattbeswick

Slide 51

$html = file_get_contents($url_check); 2. Get the HTML @mattbeswick

Slide 52

@$dom->loadHTML($html); 3. Load the HTML @mattbeswick

Slide 53

$xpath = new DOMXPath($dom); 4. Convert to XPath @mattbeswick

Slide 54

$xpath->evaluate("//div[@id='search']//h3/a/@href"); 5. Grab the Results @mattbeswick

Slide 55

Success!? http://www.shutterstock.com/gallery-667657p1.html?cr=00&pl=edit-00 @mattbeswick

Slide 56

Cue Tumbleweed… @mattbeswick

Slide 57

The power comes when you do it en-masse @mattbeswick

Slide 58

“Online Share Trading” Example:

Slide 59

1. Take the top keywords for your client / site @mattbeswick

Slide 60

best online share trading online share trading online share trading uk share trading share trading account share trading online shares trading trade shares online trading shares trading shares online uk share trading @mattbeswick

Slide 61

2. Scrape page 1 for each of these phrases @mattbeswick

Slide 62


Slide 63

3. Get an overall view of who your competitors really are @mattbeswick

Slide 64


Slide 65

You now know who you’re up against @mattbeswick

Slide 66

Let’s Take 5… @mattbeswick

Slide 67

… Seconds @mattbeswick

Slide 68


Slide 69

This could get messy @mattbeswick

Slide 70

Some Data Your Code Cool Stuff APIs (over) Simplified @mattbeswick

Slide 71

Not just for geeks* @mattbeswick *Knowing how to code helps.

Slide 72

@mattbeswick Get your learning on…

Slide 73

Building a Request @mattbeswick

Slide 74

Here’s what you get…

Slide 75

Which is the same as this @mattbeswick

Slide 76

http://api.sharedcount.com/?url=http://www.distilled.net Social Data? No Problem @mattbeswick

Slide 77

Here’s What We Get @mattbeswick

Slide 78

Again, doing this for one URL isn’t very powerful… http://i.dailymail.co.uk/i/pix/2010/12/20/article-1340131-0C8A6AA5000005DC-966_634x421.jpg @mattbeswick

Slide 79

… but when you do it for the masses you start to learn things. http://www.shutterstock.com/gallery-667393p1.html?cr=00&pl=edit-00 @mattbeswick

Slide 80

Twitter API – Get Tweets by Search – e.g. “SearchLove” @mattbeswick

Slide 81

How about we do this for the speakers? @mattbeswick

Slide 82

Here’s some top level data for them… @mattbeswick

Slide 83

What are they reading? @mattbeswick

Slide 84

And look for sites that we should be publishing on. @mattbeswick

Slide 85

Suggested Viewing – Richard Baxter http://www.slideshare.net/seogadget/really-targeted-outreach-from-richard-baxter-seogadget

Slide 86

Everything else basically involves stealing stuff. @mattbeswick

Slide 87

Let’s steal some keywords @mattbeswick

Slide 88

Take our list of competitors from earlier… Only use NICHE competitors tddirectinvesting.co.uk money.co.uk iii.co.uk hl.co.uk thisismoney.co.uk selftrade.co.uk @mattbeswick

Slide 89

Use the SEMRush API to grab their paid and organic keywords @mattbeswick

Slide 90

http://api.semrush.com/ ?type=domain_organic &key=YOUR_API_KEY &display_limit=500 &export_columns=Ph,Po,Nq,Cp,Ur &domain=selftrade.co.uk &database=uk In the background we’re doing this… @mattbeswick

Slide 91

Which gives us this… @mattbeswick

Slide 92

And in the end we have a spreadsheet! @mattbeswick

Slide 93

Let’s order by ‘total competitors’ @mattbeswick

Slide 94

Or by landing page to identify groupings @mattbeswick

Slide 95

Want to take it a step further? @mattbeswick

Slide 96

Drop those landing pages into URLProfiler

Slide 97

Generate Screenshots @mattbeswick

Slide 98

You now know what they’re bidding on… … and their landing pages

Slide 99

If that doesn’t generate ideas, nothing will. @mattbeswick

Slide 100

Flick Through & Pick Out Great Landing Pages More Tumbleweeds? @mattbeswick

Slide 101

“We’re just here for the links” @mattbeswick

Slide 102

Let’s steal those too then. @mattbeswick

Slide 103

*Knowing how to code helps. http://moz.com/products/api http://developer-support.majesticseo.com/ Our Heroes!

Slide 104

Take our list of competitors again… @mattbeswick

Slide 105

In the background $parameters["item"] = $url; $parameters["datasource"] = "fresh”; $parameters["Mode"] = 1; $parameters["Count"] = 10000; $parameters["MaxSourceURLsPerRefDomain"] = 1; $parameters["MaxSameSourceURLs"] = 1; @mattbeswick

Slide 106

In the background $api_service = new APIService(MAJESTIC_APP_API_KEY, MAJESTICSEO_ENDPOINT); $response = $api_service->executeOpenAppRequest("GetBackLinkData", $parameters, MAJESTIC_ACCESS_TOKEN); @mattbeswick

Slide 107

We get a nice big list…

Slide 108

But there’s LOADS of crap @mattbeswick

Slide 109

@mattbeswick Export to Excel & Filter

Slide 110

So we can now steal their keywords, and their links...

Slide 111

@mattbeswick Let’s talk about the bigger picture

Slide 112

@mattbeswick It’s that word again

Slide 113

@mattbeswick This is what Google wants http://www.shutterstock.com/gallery-790342p1.html?cr=00&pl=edit-00

Slide 114

@mattbeswick Being a liar isn’t an option any more

Slide 115

@mattbeswick Combining all of the above helps you build networks to build your brand.

Slide 116

One Last Bright Idea

Slide 117

Analyse a page for topics Get that list and store it Use it as a basis for outreach

Slide 118

An example Textwise Response…

Slide 119

Don’t Forget Your Spider @mattbeswick

Slide 120

Keep on crawlin’! Build up a searchable database of sites Use that db as a basis for outreach … and also check who they link to. Crawl each of those sites and check for topics… Start with a ‘seed’ list of sites

Slide 121

… here’s an example of what you get... @mattbeswick

Slide 122

One Problem…

Slide 123

Textbroker = $1000+/mth @mattbeswick

Slide 124

#searchloveselfie @mattbeswick

Slide 125

API Examples http://www.mattbeswick.co.uk/big-list-of-apis/

Slide 126

Matt Beswick Hidden Pixel @mattbeswick matt@hiddenpixel.com FREE STUFF! http://www.hiddenpixel.com/SL2014/