data driven-conversion-optimization

32
DATA-DRIVEN CONVERSION OPTIMIZATION An insight into the data-driven approach of intensive optimization of landing pages at InnoGames. [PHP-Usergroup Hamburg, Dec. 6 th 2015]

Upload: jost-kuenzel

Post on 12-Apr-2017

362 views

Category:

Technology


0 download

TRANSCRIPT

Page 1: Data driven-conversion-optimization

DATA-DRIVEN CONVERSION OPTIMIZATIONAninsightintothedata-drivenapproachofintensiveoptimizationoflandingpagesatInnoGames.

[PHP-UsergroupHamburg,Dec.6th2015]

Page 2: Data driven-conversion-optimization

MYSELF

JostKünzelTeamLeadSoftwareDeveloperCorporateSystems/ConversionTeamSince6y@InnoGames

Youarewelcometohaveachatwithme:)

Page 3: Data driven-conversion-optimization

3

2

1

3

4

5

Essentials

TheCycle

LandingPages,Visitors,Events

Events,BusinessIntelligence

Decisions,A/BTests,LandingPages

Page 4: Data driven-conversion-optimization

1 ESSENTIALS

4

Page 5: Data driven-conversion-optimization

5

Page 6: Data driven-conversion-optimization

6

⬢ Games Currently6browsergames

⬢ Markets~30e.g.fr,ar,pl,de,us,..

⬢ Marketing PartnersBringtraffictoourlandingpages ~250e.g.goo,msn,psg,..

GAMES, MARKETS, PARTNERS

Page 7: Data driven-conversion-optimization

7

⬢ Conversion„istheactorprocessofchangingfromoneform,state,etc.,toanother“(http://www.merriam-webster.com/dictionary/conversion)

⬢ Avisitorsignsupforagame⬢ Aplayermakesapayment⬢ Aplayerlogsinasecondtime

CONVERSION / CONVERSION RATE

Visitor Playersignsup

Page 8: Data driven-conversion-optimization

8

CONVERSION / CONVERSION RATE

Page 9: Data driven-conversion-optimization

9

⬢ ConversionRateOptimization=CRO

⬢ InthistalkwefocusonA/B testing of landingpages designs, graphics, wordings, UI tweaks, functionality

⬢ Notinscope⬢ Pagesspeedoptimization⬢ Multivariatetesting⬢ Devicematching⬢ Targeting

CONVERSION OPTIMIZATION

Page 10: Data driven-conversion-optimization

10

⬢ Evidencebaseddecisionmaking⬢ Collecteddata is evidence⬢ Decisions:whatpageisbestforconversionrate⬢ Testing,butnotrelyingon

⬢ Intuition⬢ Personalexperience⬢ Belief⬢ „BestPractices“

DATA-DRIVEN

Page 11: Data driven-conversion-optimization

11

ARCHITECTURE

Page 12: Data driven-conversion-optimization

GaleraReplication

ARCHITECTURE

delivery delivery delivery

mysql mysql mysql adminmysql

mysqlapi mysqlmysqlapiapi

12

CDN

Page 13: Data driven-conversion-optimization

2 THE CYCLE

Page 14: Data driven-conversion-optimization

14

Landing Pages

EventstriggerVisitorsvisitedby

Decisionsbasisfor A/B TestscontrolBusiness

Intelligence

areloadedinto

delivervariantsof

THE CYCLE

Page 15: Data driven-conversion-optimization

3 LANDING PAGES, VISITORS, EVENTS

Landing Pages

EventstriggerVisitorsvisitedby

Page 16: Data driven-conversion-optimization

16

!

!

!

!

!

Page 17: Data driven-conversion-optimization

17

$ curl -v https://lps-pixel.innogames.de/t.gif

Page 18: Data driven-conversion-optimization

18

$ curl -v https://lps-pixel.innogames.de/t.gif … > GET /t.gif HTTP/1.1 > Host: lps-pixel.innogames.de > User-Agent: curl/7.43.0 > Accept: */* > < HTTP/1.1 200 OK < Server: nginx/1.6.2 < Date: Sat, 07 Dec 2015 20:17:27 GMT < Content-Type: image/gif < Content-Length: 43 < Last-Modified: Mon, 28 Sep 1970 06:00:00 GMT < Connection: keep-alive < * Connection #0 to host lps-pixel.innogames.de left intact GIF89a⊠⊠⊠⊠!⊠,L;%

Page 19: Data driven-conversion-optimization

19

server {

access_log /www/lps-tracking/access.log tracking_json;

location ~* ^/t.gif$ { empty_gif; }

}

Page 20: Data driven-conversion-optimization

20

{ "connection": "1675278", "forwarder": "-", "http_referrer": "https://om.elvenar.com/ox/fr/?ref=adm_fr_fr&pid=466721&external_param=S0008066&ce_cid=21.swb0T1sHT1rXS1qiC2a1A2MgY000.", "remote_address": "77.196.246.14", "request": "GET /t.gif?data=eyJpZCI6IjlmMjU2ZDkxLTdjMDAtNDk4MC05NTA4LTYwM2RlMzIwOGJjMiIsInZlcnNpb24iOiIwLjAuMSIsImNhdGVnb3J5IjoibHBzIiwibmFtZSI6InBhZ2UtdW5sb2FkIiwiY3JlYXRlZF9hdCI6IjIwMTUtMTEtMjhUMjA6Mzk6MTYuMjM3WiIsImNvbnRleHQiOnsiZ2FtZV9pZCI6Im94IiwibWFya2V0X2lkIjoiZnIiLCJwYXJ0bmVyX3ByZWZpeCI6ImFkbSIsImNhbXBhaWduX2lkIjoiYWRtX2ZyX2ZyIiwiYmlkIjpudWxsLCJjaWQiOm51bGwsInBpZCI6IjQ2NjcyMSIsImxhbmRpbmdfcGFnZV9pZCI6Im0zMDhhIiwidmlzaXRvcl9pZCI6IjA2ZWNkMjBkLWMxNjEtNDE3OC04ZDJkLTFiNDFiYTFiYTI3YyIsImZpbmdlcnByaW50IjoxMzk4MTE3NTgzLCJ0aW1lem9uZSI6LTF9LCJkYXRhIjp7InN1Yl90eXBlIjoicGFnZS11bmxvYWQiLCJ0aW1pbmciOnsibmF2aWdhdGlvblN0YXJ0IjoxNDQ4NzQzMTQ2ODU4LCJ1bmxvYWRFdmVudFN0YXJ0IjowLCJ1bmxvYWRFdmVudEVuZCI6MCwicmVkaXJlY3RTdGFydCI6MCwicmVkaXJlY3RFbmQiOjAsImZldGNoU3RhcnQiOjE0NDg3NDMxNDc1MjQsImRvbWFpbkxvb2t1cFN0YXJ0IjoxNDQ4NzQzMTQ3NTI1LCJkb21haW5Mb29rdXBFbmQiOjE0NDg3NDMxNDc1NzgsImNvbm5lY3RTdGFydCI6MTQ0ODc0MzE0NzU3OCwiY29ubmVjdEVuZCI6MTQ0ODc0MzE0OTE4NCwic2VjdXJlQ29ubmVjdGlvblN0YXJ0IjoxNDQ4NzQzMTQ3ODQ4LCJyZXF1ZXN0U3RhcnQiOjE0NDg3NDMxNDkxODQsInJlc3BvbnNlU3RhcnQiOjE0NDg3NDMxNDk2NTEsInJlc3BvbnNlRW5kIjoxNDQ4NzQzMTQ5NjUyLCJkb21Mb2FkaW5nIjoxNDQ4NzQzMTQ5NjYwLCJkb21JbnRlcmFjdGl2ZSI6MTQ0ODc0MzE1MDY1NiwiZG9tQ29udGVudExvYWRlZEV2ZW50U3RhcnQiOjE0NDg3NDMxNTA2NTYsImRvbUNvbnRlbnRMb2FkZWRFdmVudEVuZCI6MTQ0ODc0MzE1MDY5NiwiZG9tQ29tcGxldGUiOjE0NDg3NDMxNTQyMTUsImxvYWRFdmVudFN0YXJ0IjoxNDQ4NzQzMTU0MjE1LCJsb2FkRXZlbnRFbmQiOjE0NDg3NDMxNTQyMTh9LCJkdXJhdGlvbiI6NTU4MC45OTUwMDAwMDAwMDF9fQ== HTTP/1.1", "request_length": "1890", "request_time": "0.000", "status": "200", "time": "1448743157.264", "time_iso": "2015-11-28T20:39:17+00:00", "user_agent": "Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36" }

Page 21: Data driven-conversion-optimization

21

{ "category": "lps", "context": { "bid": null, "campaign_id": "adm_fr_fr", "cid": null, "fingerprint": 1398117583, "game_id": "ox", "landing_page_id": "m308a", "market_id": "fr", "partner_prefix": "adm", "pid": "466721", "timezone": -1, "visitor_id": "06afd20d-c165-4178-8d2d-1b41ba1ba27c" }, "created_at": "2015-11-28T20:39:16.237Z", "data": { "duration": 5580.995000000001 }, "id": "9f256d91-7c00-4980-9508-603de3208bc2", "name": "page-unload", "version": "0.0.1" }

Page 22: Data driven-conversion-optimization

4 EVENTS, BUSINESS INTELLIGENCE

Events Business Intelligenceareloadedinto

Page 23: Data driven-conversion-optimization

23

⬢ Itisaboutunderstandinghowbusinessisrunning⬢ Largeamountsofrawbusiness datafromdisparate systemslike

⬢ players⬢ payments⬢ events

⬢ Combineddata,giveitmeaning⟶data warehouse⬢ Toolstomakeinterpretationpossible⬢ Ontop:MicrosoftExcel

BUSINESS INTELLIGENCE

Page 24: Data driven-conversion-optimization

⬢ postrotatemovesaccesslogsintoHadoopspace⬢ BI

⬢ loadsincrementaldatadailyfromHadoop(HIVEquery)⬢ combinesotherdatafromBIdatawarehousee.g.paymenthistory⬢ buildsthe„ConversionCube“

24

ACCESS LOGS – EXCEL

Hadoop SQL ServerLoadbyAccess Log logrotate.d ODBC

Page 25: Data driven-conversion-optimization

⬢ Dimensions ⬢ Date⬢ Game/Market⬢ Campaign⬢ ViewPort⬢ andother

25

CUBE

⬢ Measures ⬢ ConversionRate⬢ Visitors:uniquepage

views,returningvisitors⬢ Logins⬢ LiveTimeValue⬢ Revenue⬢ andother

Page 26: Data driven-conversion-optimization

5 DECISIONS, A/B TESTS, LANDING PAGES

Landing Pages

Decisions A/B Testscontrol delivervariantsof

Page 27: Data driven-conversion-optimization

27

⬢ CROManagers,ProductMarketingManagers,Artists,FrontendDevelopers

⬢ Everyonecanpresenthypothesis⬢ Ratingandvoting⟶Priority

„I believe the ‚play‘ button in green would motivate the visitors more, because the color green is perceived in a more positive way“

CONVERSION BOARD

Page 28: Data driven-conversion-optimization

28

Page 29: Data driven-conversion-optimization

29

EXAMPLE - „BATTLE SCENE VIDEO“

VS

https://om.tribalwars2.com/tw2/de?ref=igfm1https://om.tribalwars2.com/tw2/de

A full screen background video is a strong medium to grab a user's attention and increase the engagement of him because he will take a longer look at the page. At the same time the "aggressive" battle scene shown in the video will appeal to the "fighter/killer" gamer. The risen engagement as well as the appealing character/story of the video will lead to higher registration rates.

Page 30: Data driven-conversion-optimization

30

CONVERSION RATE

8,2%

8,4%

8,6%

8,8%

9%

9,2%

9,4%

Fr.27.11.

Sa.28.11.

So.29.11.

Mo.30.11.

Di.01.12.

Mi.02.12.

Do.03.12.

Fr.04.12.

Sa.05.12.

So.06.12.

Control Variant

Page 31: Data driven-conversion-optimization

31

ACTIVE PLAYER RATE

12%

12,5%

13%

13,5%

14%

14,5%

15%

Fr.27.11.

Sa.28.11.

So.29.11.

Mo.30.11.

Di.01.12.

Mi.02.12.

Do.03.12.

Fr.04.12.

Sa.05.12.

So.06.12.

Control Variant

Page 32: Data driven-conversion-optimization

QUESTIONS ? / THANK YOU #