際際滷

際際滷Share a Scribd company logo
who doesnt want to
believe in magic?
kate matsudaira | @katemats
Wednesday, May 29, 13
happiness
Wednesday, May 29, 13
happiness
Life would be so
much better if there
were pi単atas
strategically placed
throughout the day.
Wednesday, May 29, 13
flow happiness
Wednesday, May 29, 13
challenges
skills
anxiety
boredom
flow
diagram from the book: Flow: The Psychology of Optimal Experience (1990)
Wednesday, May 29, 13
happiness is a way of travel,
not a destination
http://occasionallego.files.wordpress.com/2013/02/feb_02_2013.jpg
Wednesday, May 29, 13
flow happinessmastery
Wednesday, May 29, 13
Image source: http://satellite.tpub.com/TM-11-5895-846-14/TM-11-5895-846-140401im.jpg
Wednesday, May 29, 13
Image source: http://pixelperfectdigital.com/photo/5/computer-circuits.html
Wednesday, May 29, 13
Image source: wallpaperstock.net -
Wednesday, May 29, 13
Image source: www.balsas.lt - -
Wednesday, May 29, 13
Wednesday, May 29, 13
Image source: http://jochenebmeier.blogspot.com/2011/07/arkanum-die-remystifizerung-des-wissens.html
Wednesday, May 29, 13
Image source:http://etsy.com
Wednesday, May 29, 13
SPDY
Wednesday, May 29, 13
Source: http://www.sencha.com/blog/the-making-of-fastbook-an-html5-love-story
Wednesday, May 29, 13
mysql>	
 油SELECT	
 油`campaign_active_rankings`.*	
 油FROM	
 油`campaign_active_rankings`	
 油WHERE	
 油
(campaign_id	
 油=	
 油3	
 油and	
 油engine_id	
 油=	
 油96)	
 油AND	
 油(latest_rank	
 油=	
 油min_rank	
 油AND	
 油latest_rank	
 油<	
 油
max_rank)	
 油ORDER	
 油BY	
 油beta	
 油DESC	
 油LIMIT	
 油3;
Wednesday, May 29, 13
Here's the underlying view SQL:
campaign_active_rankings
select	
 油`campaign_tracked_rankings`.`campaign_id`	
 油AS	
 油`campaign_id`,`campaign_tracked_rankings`.`engine_id`	
 油AS	
 油
`engine_id`,`campaign_tracked_rankings`.`keyword_id`	
 油AS	
 油`keyword_id`,`campaign_tracked_rankings`.`keyword_labels`	
 油AS	
 油
`keyword_labels`,max(`campaign_tracked_rankings`.`rank`)	
 油AS	
 油`latest_rank`,max(`chained_domain_ranks_by_week`.`rank`)	
 油
AS	
 油`max_rank`,min(`chained_domain_ranks_by_week`.`rank`)	
 油AS	
 油`min_rank`,(max(`chained_domain_ranks_by_week`.`rank`)	
 油-足	
 油
min(`chained_domain_ranks_by_week`.`rank`))	
 油AS	
 油`spread`,pow(exp(sum(log(coalesce((case	
 油when	
 油
(`chained_domain_ranks_by_week`.`delta`	
 油<>	
 油0)	
 油then	
 油abs(`chained_domain_ranks_by_week`.`delta`)	
 油end),0.5)))),(1	
 油/	
 油
count(0)))	
 油AS	
 油`beta`,avg(abs(`chained_domain_ranks_by_week`.`delta`))	
 油AS	
 油`avg_delta_mag`	
 油from	
 油((`campaigns`	
 油join	
 油
`campaign_tracked_rankings`	
 油on(((`campaigns`.`id`	
 油=	
 油`campaign_tracked_rankings`.`campaign_id`)	
 油and	
 油
(`campaigns`.`domain_host`	
 油=	
 油`campaign_tracked_rankings`.`domain_host`))))	
 油join	
 油`chained_domain_ranks_by_week`	
 油
on(((`campaign_tracked_rankings`.`keyword_id`	
 油=	
 油`chained_domain_ranks_by_week`.`keyword_id`)	
 油and	
 油
(`campaign_tracked_rankings`.`engine_id`	
 油=	
 油`chained_domain_ranks_by_week`.`engine_id`)	
 油and	
 油
(`campaign_tracked_rankings`.`domain_host`	
 油=	
 油`chained_domain_ranks_by_week`.`domain_host`)	
 油and	
 油
(`chained_domain_ranks_by_week`.`week`	
 油in	
 油(`campaign_tracked_rankings`.`week`,(`campaign_tracked_rankings`.`week`	
 油-足	
 油
interval	
 油1	
 油week),(`campaign_tracked_rankings`.`week`	
 油-足	
 油interval	
 油2	
 油week),(`campaign_tracked_rankings`.`week`	
 油-足	
 油
interval	
 油3	
 油week))))))	
 油group	
 油by	
 油
`campaign_tracked_rankings`.`campaign_id`,`campaign_tracked_rankings`.`engine_id`,`campaign_tracked_rankings`.`keywor
d_id`
Wednesday, May 29, 13
chained_searches_by_week
select	
 油`engine_keyword_week_latest_search`.`week`	
 油AS	
 油`week`,`engine_keyword_week_latest_search`.`search_id`	
 油AS	
 油`search_id`,`engine_keyword_week_latest_search`.`engine_id`	
 油AS	
 油
`engine_id`,`engine_keyword_week_latest_search`.`keyword_id`	
 油AS	
 油`keyword_id`,`engine_keyword_week_latest_search`.`search_date`	
 油AS	
 油`search_date`,`engine_keyword_week_latest_search`.`search_state`	
 油AS	
 油
`search_state`,`prior_week`.`search_id`	
 油AS	
 油`prior_search_id`,`prior_week`.`search_date`	
 油AS	
 油`prior_search_date`,`prior_week`.`search_state`	
 油AS	
 油`prior_search_state`	
 油from	
 油
(`engine_keyword_week_latest_search`	
 油left	
 油join	
 油`engine_keyword_week_latest_search`	
 油`prior_week`	
 油on(((`engine_keyword_week_latest_search`.`engine_id`	
 油=	
 油`prior_week`.`engine_id`)	
 油and	
 油
(`engine_keyword_week_latest_search`.`keyword_id`	
 油=	
 油`prior_week`.`keyword_id`)	
 油and	
 油(`engine_keyword_week_latest_search`.`week`	
 油=	
 油(`prior_week`.`week`	
 油+	
 油interval	
 油1	
 油week)))))
engine_keyword_week_latest_search
select	
 油`searches`.`engine_id`	
 油AS	
 油`engine_id`,`searches`.`keyword_id`	
 油AS	
 油`keyword_id`,`searches`.`week`	
 油AS	
 油`week`,`searches`.`state`	
 油AS	
 油`search_state`,`searches`.`date`	
 油AS	
 油`search_date`,`searches`.`id`	
 油
AS	
 油`search_id`	
 油from	
 油(`searches`	
 油left	
 油join	
 油`searches`	
 油`better_search`	
 油on(((`searches`.`engine_id`	
 油=	
 油`better_search`.`engine_id`)	
 油and	
 油(`searches`.`keyword_id`	
 油=	
 油`better_search`.`keyword_id`)	
 油and	
 油
(`searches`.`week`	
 油=	
 油`better_search`.`week`)	
 油and	
 油(`better_search`.`state`	
 油=	
 油2)	
 油and	
 油(`searches`.`date`	
 油<	
 油`better_search`.`date`))))	
 油where	
 油((`searches`.`state`	
 油=	
 油2)	
 油and	
 油isnull(`better_search`.`id`))
search_domain_rank
select	
 油`pages_urls`.`search_id`	
 油AS	
 油`search_id`,`pages_urls`.`host`	
 油AS	
 油`domain_host`,`pages_urls`.`rank`	
 油AS	
 油`rank`,`pages_urls`.`url_id`	
 油AS	
 油`url_id`	
 油from	
 油(`pages_urls`	
 油left	
 油join	
 油`pages_urls`	
 油
`better_pages_urls`	
 油on(((`better_pages_urls`.`host`	
 油=	
 油`pages_urls`.`host`)	
 油and	
 油(`better_pages_urls`.`search_id`	
 油=	
 油`pages_urls`.`search_id`)	
 油and	
 油(`better_pages_urls`.`rank`	
 油<	
 油`pages_urls`.`rank`))))	
 油
where	
 油isnull(`better_pages_urls`.`id`)
campaign_trackings
select	
 油`campaign_engines`.`campaign_id`	
 油AS	
 油`campaign_id`,`campaign_engines`.`engine_id`	
 油AS	
 油`engine_id`,`campaign_keywords`.`keyword_id`	
 油AS	
 油`keyword_id`,`campaign_keywords`.`labels`	
 油AS	
 油
`keyword_labels`,`campaign_domains`.`domain_host`	
 油AS	
 油`domain_host`	
 油from	
 油((`campaign_engines`	
 油join	
 油`campaign_domains`	
 油on((`campaign_engines`.`campaign_id`	
 油=	
 油`campaign_domains`.`campaign_id`)))	
 油join	
 油
`campaign_keywords`	
 油on((`campaign_engines`.`campaign_id`	
 油=	
 油`campaign_keywords`.`campaign_id`)))
campaign_tracked_rankings
select	
 油`campaign_trackings`.`campaign_id`	
 油AS	
 油`campaign_id`,`campaign_trackings`.`engine_id`	
 油AS	
 油`engine_id`,`campaign_trackings`.`keyword_id`	
 油AS	
 油`keyword_id`,`campaign_trackings`.`keyword_labels`	
 油AS	
 油
`keyword_labels`,`campaign_trackings`.`domain_host`	
 油AS	
 油`domain_host`,`engine_keyword_latest_search`.`search_id`	
 油AS	
 油`search_id`,`engine_keyword_latest_search`.`search_date`	
 油AS	
 油
`search_date`,`engine_keyword_latest_search`.`search_state`	
 油AS	
 油`search_state`,`engine_keyword_latest_search`.`week`	
 油AS	
 油`week`,`domain_ranking_summaries`.`rank`	
 油AS	
 油
`rank`,`domain_ranking_summaries`.`prior_rank`	
 油AS	
 油`prior_rank`,`domain_ranking_summaries`.`delta`	
 油AS	
 油`delta`	
 油from	
 油((`campaign_trackings`	
 油left	
 油join	
 油`engine_keyword_latest_search`	
 油
on(((`campaign_trackings`.`engine_id`	
 油=	
 油`engine_keyword_latest_search`.`engine_id`)	
 油and	
 油(`campaign_trackings`.`keyword_id`	
 油=	
 油`engine_keyword_latest_search`.`keyword_id`))))	
 油left	
 油join	
 油
`domain_ranking_summaries`	
 油on(((`engine_keyword_latest_search`.`search_id`	
 油=	
 油`domain_ranking_summaries`.`search_id`)	
 油and	
 油(`campaign_trackings`.`domain_host`	
 油=	
 油
`domain_ranking_summaries`.`domain_host`))))
chained_domain_ranks_by_week
select	
 油`chained_searches_by_week`.`search_id`	
 油AS	
 油`search_id`,`chained_searches_by_week`.`engine_id`	
 油AS	
 油`engine_id`,`chained_searches_by_week`.`keyword_id`	
 油AS	
 油
`keyword_id`,`chained_searches_by_week`.`week`	
 油AS	
 油`week`,`chained_searches_by_week`.`search_date`	
 油AS	
 油`search_date`,`search_domain_rank`.`domain_host`	
 油AS	
 油`domain_host`,`search_domain_rank`.`rank`	
 油AS	
 油
`rank`,`prior_search_domain_rank`.`rank`	
 油AS	
 油`prior_rank`,(`prior_search_domain_rank`.`rank`	
 油-足	
 油`search_domain_rank`.`rank`)	
 油AS	
 油`delta`	
 油from	
 油((`chained_searches_by_week`	
 油join	
 油`search_domain_rank`	
 油
on((`chained_searches_by_week`.`search_id`	
 油=	
 油`search_domain_rank`.`search_id`)))	
 油left	
 油join	
 油`search_domain_rank`	
 油`prior_search_domain_rank`	
 油on(((`chained_searches_by_week`.`prior_search_id`	
 油=	
 油
`prior_search_domain_rank`.`search_id`)	
 油and	
 油(`search_domain_rank`.`domain_host`	
 油=	
 油`prior_search_domain_rank`.`domain_host`))))
domain_ranking_summaries
select	
 油`engine_keyword_latest_search`.`engine_id`	
 油AS	
 油`engine_id`,`engine_keyword_latest_search`.`keyword_id`	
 油AS	
 油`keyword_id`,`engine_keyword_latest_search`.`search_id`	
 油AS	
 油`search_id`,`urls`.`host`	
 油AS	
 油
`domain_host`,max(`engine_keyword_latest_search`.`search_date`)	
 油AS	
 油`search_date`,max(`engine_keyword_latest_search`.`search_state`)	
 油AS	
 油`search_state`,min(`chained_url_ranks_by_week`.`rank`)	
 油AS	
 油
`rank`,min(`chained_url_ranks_by_week`.`prior_rank`)	
 油AS	
 油`prior_rank`,(min(`chained_url_ranks_by_week`.`prior_rank`)	
 油-足	
 油min(`chained_url_ranks_by_week`.`rank`))	
 油AS	
 油`delta`	
 油from	
 油
((`engine_keyword_latest_search`	
 油join	
 油`chained_url_ranks_by_week`	
 油on((`engine_keyword_latest_search`.`search_id`	
 油=	
 油`chained_url_ranks_by_week`.`search_id`)))	
 油join	
 油`urls`	
 油
on((`chained_url_ranks_by_week`.`url_id`	
 油=	
 油`urls`.`id`)))	
 油group	
 油by	
 油`engine_keyword_latest_search`.`engine_id`,`engine_keyword_latest_search`.`keyword_id`,`urls`.`host`
chained_url_ranks_by_week
select	
 油`chained_searches_by_week`.`search_id`	
 油AS	
 油`search_id`,`chained_searches_by_week`.`engine_id`	
 油AS	
 油`engine_id`,`chained_searches_by_week`.`keyword_id`	
 油AS	
 油
`keyword_id`,`chained_searches_by_week`.`week`	
 油AS	
 油`week`,`pages_urls`.`url_id`	
 油AS	
 油`url_id`,`pages_urls`.`rank`	
 油AS	
 油`rank`,`pages_urls`.`page_number`	
 油AS	
 油`page_number`,`pages_urls`.`position`	
 油AS	
 油
`position`,`prior_pages_urls`.`rank`	
 油AS	
 油`prior_rank`,(case	
 油when	
 油(`prior_pages_urls`.`rank`	
 油is	
 油not	
 油null)	
 油then	
 油-足((`pages_urls`.`rank`	
 油-足	
 油`prior_pages_urls`.`rank`))	
 油else	
 油NULL	
 油end)	
 油AS	
 油`delta`	
 油from	
 油
((`chained_searches_by_week`	
 油join	
 油`pages_urls`	
 油on((`pages_urls`.`search_id`	
 油=	
 油`chained_searches_by_week`.`search_id`)))	
 油left	
 油join	
 油`pages_urls`	
 油`prior_pages_urls`	
 油on(((`prior_pages_urls`.`search_id`	
 油=	
 油
`chained_searches_by_week`.`prior_search_id`)	
 油and	
 油(`prior_pages_urls`.`url_id`	
 油=	
 油`pages_urls`.`url_id`))))
Wednesday, May 29, 13
Image source: http://static.fjcdn.com/pictures/pear_ff99e0_3037113.jpg
what is in
that black
box?
Wednesday, May 29, 13
Image source: htto://www.amazon.com
Wednesday, May 29, 13
flow happinessmastery
Wednesday, May 29, 13
cause
&
effect
Wednesday, May 29, 13
Wednesday, May 29, 13
I may not be there today,
but I am closer than I was yesterday.
Wednesday, May 29, 13
we are defined
by what we
make time to do
Wednesday, May 29, 13
Wednesday, May 29, 13
thank you
presentation by:
kate matsudaira
popforms
Wednesday, May 29, 13

More Related Content

Viewers also liked (10)

Indie authors speed date!
Indie authors speed date!Indie authors speed date!
Indie authors speed date!
Derek Murphy
Responsive Branding: Making Your Brand Interactive on the Web
Responsive Branding: Making Your Brand Interactive on the Web Responsive Branding: Making Your Brand Interactive on the Web
Responsive Branding: Making Your Brand Interactive on the Web
Kate Matsudaira
Black magic
Black magicBlack magic
Black magic
Muhammad Hamza
It's all about the coffee
It's all about the coffeeIt's all about the coffee
It's all about the coffee
James Clay
Want To Believe It
Want To Believe ItWant To Believe It
Want To Believe It
Krystal C
Conversation Ice Breakers: 3 Awesome Ways To Start A Great Conversation
Conversation Ice Breakers: 3 Awesome Ways To Start A Great ConversationConversation Ice Breakers: 3 Awesome Ways To Start A Great Conversation
Conversation Ice Breakers: 3 Awesome Ways To Start A Great Conversation
Michael Lee
5 things audiences hate about presentations
5 things audiences hate about presentations5 things audiences hate about presentations
5 things audiences hate about presentations
Arthur Sevenstern
The Science of a Great Career in Data Science
The Science of a Great Career in Data ScienceThe Science of a Great Career in Data Science
The Science of a Great Career in Data Science
Kate Matsudaira
5 Tips for Becoming a Better Listener
5 Tips for Becoming a Better Listener5 Tips for Becoming a Better Listener
5 Tips for Becoming a Better Listener
Gretchen Rubin
Your Career Success Formula
Your Career Success FormulaYour Career Success Formula
Your Career Success Formula
Kate Matsudaira
Indie authors speed date!
Indie authors speed date!Indie authors speed date!
Indie authors speed date!
Derek Murphy
Responsive Branding: Making Your Brand Interactive on the Web
Responsive Branding: Making Your Brand Interactive on the Web Responsive Branding: Making Your Brand Interactive on the Web
Responsive Branding: Making Your Brand Interactive on the Web
Kate Matsudaira
It's all about the coffee
It's all about the coffeeIt's all about the coffee
It's all about the coffee
James Clay
Want To Believe It
Want To Believe ItWant To Believe It
Want To Believe It
Krystal C
Conversation Ice Breakers: 3 Awesome Ways To Start A Great Conversation
Conversation Ice Breakers: 3 Awesome Ways To Start A Great ConversationConversation Ice Breakers: 3 Awesome Ways To Start A Great Conversation
Conversation Ice Breakers: 3 Awesome Ways To Start A Great Conversation
Michael Lee
5 things audiences hate about presentations
5 things audiences hate about presentations5 things audiences hate about presentations
5 things audiences hate about presentations
Arthur Sevenstern
The Science of a Great Career in Data Science
The Science of a Great Career in Data ScienceThe Science of a Great Career in Data Science
The Science of a Great Career in Data Science
Kate Matsudaira
5 Tips for Becoming a Better Listener
5 Tips for Becoming a Better Listener5 Tips for Becoming a Better Listener
5 Tips for Becoming a Better Listener
Gretchen Rubin
Your Career Success Formula
Your Career Success FormulaYour Career Success Formula
Your Career Success Formula
Kate Matsudaira

Recently uploaded (20)

2025-02-27 Tech & Play_ Fun, UX, and Community.pdf
2025-02-27 Tech & Play_ Fun, UX, and Community.pdf2025-02-27 Tech & Play_ Fun, UX, and Community.pdf
2025-02-27 Tech & Play_ Fun, UX, and Community.pdf
katalinjordans1
THE BIG TEN BIOPHARMACEUTICAL MNCs: GLOBAL CAPABILITY CENTERS IN INDIA
THE BIG TEN BIOPHARMACEUTICAL MNCs: GLOBAL CAPABILITY CENTERS IN INDIATHE BIG TEN BIOPHARMACEUTICAL MNCs: GLOBAL CAPABILITY CENTERS IN INDIA
THE BIG TEN BIOPHARMACEUTICAL MNCs: GLOBAL CAPABILITY CENTERS IN INDIA
Srivaanchi Nathan
Artificial Intelligence Quick Research Guide by Arthur Morgan
Artificial Intelligence Quick Research Guide by Arthur MorganArtificial Intelligence Quick Research Guide by Arthur Morgan
Artificial Intelligence Quick Research Guide by Arthur Morgan
Arthur Morgan
GDG Cloud Southlake #40: Brandon Stokes: How to Build a Great Product
GDG Cloud Southlake #40: Brandon Stokes: How to Build a Great ProductGDG Cloud Southlake #40: Brandon Stokes: How to Build a Great Product
GDG Cloud Southlake #40: Brandon Stokes: How to Build a Great Product
James Anderson
Big Data Analytics Quick Research Guide by Arthur Morgan (PREVIEW)
Big Data Analytics Quick Research Guide by Arthur Morgan (PREVIEW)Big Data Analytics Quick Research Guide by Arthur Morgan (PREVIEW)
Big Data Analytics Quick Research Guide by Arthur Morgan (PREVIEW)
Arthur Morgan
Mastering ChatGPT & LLMs for Practical Applications: Tips, Tricks, and Use Cases
Mastering ChatGPT & LLMs for Practical Applications: Tips, Tricks, and Use CasesMastering ChatGPT & LLMs for Practical Applications: Tips, Tricks, and Use Cases
Mastering ChatGPT & LLMs for Practical Applications: Tips, Tricks, and Use Cases
Sanjay Willie
UiPath Automation Developer Associate Training Series 2025 - Session 1
UiPath Automation Developer Associate Training Series 2025 - Session 1UiPath Automation Developer Associate Training Series 2025 - Session 1
UiPath Automation Developer Associate Training Series 2025 - Session 1
DianaGray10
Getting Started with AWS - Enterprise Landing Zone for Terraform Learning & D...
Getting Started with AWS - Enterprise Landing Zone for Terraform Learning & D...Getting Started with AWS - Enterprise Landing Zone for Terraform Learning & D...
Getting Started with AWS - Enterprise Landing Zone for Terraform Learning & D...
Chris Wahl
Leadership u automatizaciji: RPA prie iz prakse!
Leadership u automatizaciji: RPA prie iz prakse!Leadership u automatizaciji: RPA prie iz prakse!
Leadership u automatizaciji: RPA prie iz prakse!
UiPathCommunity
Benchmark Testing Demystified: Your Roadmap to Peak Performance
Benchmark Testing Demystified: Your Roadmap to Peak PerformanceBenchmark Testing Demystified: Your Roadmap to Peak Performance
Benchmark Testing Demystified: Your Roadmap to Peak Performance
Shubham Joshi
Bedrock Data Automation (Preview): Simplifying Unstructured Data Processing
Bedrock Data Automation (Preview): Simplifying Unstructured Data ProcessingBedrock Data Automation (Preview): Simplifying Unstructured Data Processing
Bedrock Data Automation (Preview): Simplifying Unstructured Data Processing
Zilliz
SB7 Mobile Ltd: Simplified & Secure Services
SB7 Mobile Ltd: Simplified & Secure ServicesSB7 Mobile Ltd: Simplified & Secure Services
SB7 Mobile Ltd: Simplified & Secure Services
Reuben Jasper
William Maclyn Murphy McRae - A Seasoned Professional Renowned
William Maclyn Murphy McRae - A Seasoned Professional RenownedWilliam Maclyn Murphy McRae - A Seasoned Professional Renowned
William Maclyn Murphy McRae - A Seasoned Professional Renowned
William Maclyn Murphy McRae
5 Must-Use AI Tools to Supercharge Your Productivity
5 Must-Use AI Tools to Supercharge Your Productivity5 Must-Use AI Tools to Supercharge Your Productivity
5 Must-Use AI Tools to Supercharge Your Productivity
cryptouniversityoffi
Blockchain for Businesses Practical Use Cases & Benefits.pdf
Blockchain for Businesses Practical Use Cases & Benefits.pdfBlockchain for Businesses Practical Use Cases & Benefits.pdf
Blockchain for Businesses Practical Use Cases & Benefits.pdf
Yodaplus Technologies Private Limited
Data-Driven Public Safety: Reliable Data When Every Second Counts
Data-Driven Public Safety: Reliable Data When Every Second CountsData-Driven Public Safety: Reliable Data When Every Second Counts
Data-Driven Public Safety: Reliable Data When Every Second Counts
Safe Software
NSFW AI Chatbot Development Costs: What You Need to Know
NSFW AI Chatbot Development Costs: What You Need to KnowNSFW AI Chatbot Development Costs: What You Need to Know
NSFW AI Chatbot Development Costs: What You Need to Know
Soulmaite
Combining Lexical and Semantic Search with Milvus 2.5
Combining Lexical and Semantic Search with Milvus 2.5Combining Lexical and Semantic Search with Milvus 2.5
Combining Lexical and Semantic Search with Milvus 2.5
Zilliz
10 FinTech Solutions Every Business Should Know!.pdf
10 FinTech Solutions Every Business Should Know!.pdf10 FinTech Solutions Every Business Should Know!.pdf
10 FinTech Solutions Every Business Should Know!.pdf
Yodaplus Technologies Private Limited
AI Trends and Fun Demos Sothebys Rehoboth Presentation
AI Trends and Fun Demos  Sothebys Rehoboth PresentationAI Trends and Fun Demos  Sothebys Rehoboth Presentation
AI Trends and Fun Demos Sothebys Rehoboth Presentation
Ethan Holland
2025-02-27 Tech & Play_ Fun, UX, and Community.pdf
2025-02-27 Tech & Play_ Fun, UX, and Community.pdf2025-02-27 Tech & Play_ Fun, UX, and Community.pdf
2025-02-27 Tech & Play_ Fun, UX, and Community.pdf
katalinjordans1
THE BIG TEN BIOPHARMACEUTICAL MNCs: GLOBAL CAPABILITY CENTERS IN INDIA
THE BIG TEN BIOPHARMACEUTICAL MNCs: GLOBAL CAPABILITY CENTERS IN INDIATHE BIG TEN BIOPHARMACEUTICAL MNCs: GLOBAL CAPABILITY CENTERS IN INDIA
THE BIG TEN BIOPHARMACEUTICAL MNCs: GLOBAL CAPABILITY CENTERS IN INDIA
Srivaanchi Nathan
Artificial Intelligence Quick Research Guide by Arthur Morgan
Artificial Intelligence Quick Research Guide by Arthur MorganArtificial Intelligence Quick Research Guide by Arthur Morgan
Artificial Intelligence Quick Research Guide by Arthur Morgan
Arthur Morgan
GDG Cloud Southlake #40: Brandon Stokes: How to Build a Great Product
GDG Cloud Southlake #40: Brandon Stokes: How to Build a Great ProductGDG Cloud Southlake #40: Brandon Stokes: How to Build a Great Product
GDG Cloud Southlake #40: Brandon Stokes: How to Build a Great Product
James Anderson
Big Data Analytics Quick Research Guide by Arthur Morgan (PREVIEW)
Big Data Analytics Quick Research Guide by Arthur Morgan (PREVIEW)Big Data Analytics Quick Research Guide by Arthur Morgan (PREVIEW)
Big Data Analytics Quick Research Guide by Arthur Morgan (PREVIEW)
Arthur Morgan
Mastering ChatGPT & LLMs for Practical Applications: Tips, Tricks, and Use Cases
Mastering ChatGPT & LLMs for Practical Applications: Tips, Tricks, and Use CasesMastering ChatGPT & LLMs for Practical Applications: Tips, Tricks, and Use Cases
Mastering ChatGPT & LLMs for Practical Applications: Tips, Tricks, and Use Cases
Sanjay Willie
UiPath Automation Developer Associate Training Series 2025 - Session 1
UiPath Automation Developer Associate Training Series 2025 - Session 1UiPath Automation Developer Associate Training Series 2025 - Session 1
UiPath Automation Developer Associate Training Series 2025 - Session 1
DianaGray10
Getting Started with AWS - Enterprise Landing Zone for Terraform Learning & D...
Getting Started with AWS - Enterprise Landing Zone for Terraform Learning & D...Getting Started with AWS - Enterprise Landing Zone for Terraform Learning & D...
Getting Started with AWS - Enterprise Landing Zone for Terraform Learning & D...
Chris Wahl
Leadership u automatizaciji: RPA prie iz prakse!
Leadership u automatizaciji: RPA prie iz prakse!Leadership u automatizaciji: RPA prie iz prakse!
Leadership u automatizaciji: RPA prie iz prakse!
UiPathCommunity
Benchmark Testing Demystified: Your Roadmap to Peak Performance
Benchmark Testing Demystified: Your Roadmap to Peak PerformanceBenchmark Testing Demystified: Your Roadmap to Peak Performance
Benchmark Testing Demystified: Your Roadmap to Peak Performance
Shubham Joshi
Bedrock Data Automation (Preview): Simplifying Unstructured Data Processing
Bedrock Data Automation (Preview): Simplifying Unstructured Data ProcessingBedrock Data Automation (Preview): Simplifying Unstructured Data Processing
Bedrock Data Automation (Preview): Simplifying Unstructured Data Processing
Zilliz
SB7 Mobile Ltd: Simplified & Secure Services
SB7 Mobile Ltd: Simplified & Secure ServicesSB7 Mobile Ltd: Simplified & Secure Services
SB7 Mobile Ltd: Simplified & Secure Services
Reuben Jasper
William Maclyn Murphy McRae - A Seasoned Professional Renowned
William Maclyn Murphy McRae - A Seasoned Professional RenownedWilliam Maclyn Murphy McRae - A Seasoned Professional Renowned
William Maclyn Murphy McRae - A Seasoned Professional Renowned
William Maclyn Murphy McRae
5 Must-Use AI Tools to Supercharge Your Productivity
5 Must-Use AI Tools to Supercharge Your Productivity5 Must-Use AI Tools to Supercharge Your Productivity
5 Must-Use AI Tools to Supercharge Your Productivity
cryptouniversityoffi
Data-Driven Public Safety: Reliable Data When Every Second Counts
Data-Driven Public Safety: Reliable Data When Every Second CountsData-Driven Public Safety: Reliable Data When Every Second Counts
Data-Driven Public Safety: Reliable Data When Every Second Counts
Safe Software
NSFW AI Chatbot Development Costs: What You Need to Know
NSFW AI Chatbot Development Costs: What You Need to KnowNSFW AI Chatbot Development Costs: What You Need to Know
NSFW AI Chatbot Development Costs: What You Need to Know
Soulmaite
Combining Lexical and Semantic Search with Milvus 2.5
Combining Lexical and Semantic Search with Milvus 2.5Combining Lexical and Semantic Search with Milvus 2.5
Combining Lexical and Semantic Search with Milvus 2.5
Zilliz
AI Trends and Fun Demos Sothebys Rehoboth Presentation
AI Trends and Fun Demos  Sothebys Rehoboth PresentationAI Trends and Fun Demos  Sothebys Rehoboth Presentation
AI Trends and Fun Demos Sothebys Rehoboth Presentation
Ethan Holland

Who Doesn't Want to Believe in Magic?

  • 1. who doesnt want to believe in magic? kate matsudaira | @katemats Wednesday, May 29, 13
  • 3. happiness Life would be so much better if there were pi単atas strategically placed throughout the day. Wednesday, May 29, 13
  • 5. challenges skills anxiety boredom flow diagram from the book: Flow: The Psychology of Optimal Experience (1990) Wednesday, May 29, 13
  • 6. happiness is a way of travel, not a destination http://occasionallego.files.wordpress.com/2013/02/feb_02_2013.jpg Wednesday, May 29, 13
  • 10. Image source: wallpaperstock.net - Wednesday, May 29, 13
  • 11. Image source: www.balsas.lt - - Wednesday, May 29, 13
  • 17. mysql> 油SELECT 油`campaign_active_rankings`.* 油FROM 油`campaign_active_rankings` 油WHERE 油 (campaign_id 油= 油3 油and 油engine_id 油= 油96) 油AND 油(latest_rank 油= 油min_rank 油AND 油latest_rank 油< 油 max_rank) 油ORDER 油BY 油beta 油DESC 油LIMIT 油3; Wednesday, May 29, 13
  • 18. Here's the underlying view SQL: campaign_active_rankings select 油`campaign_tracked_rankings`.`campaign_id` 油AS 油`campaign_id`,`campaign_tracked_rankings`.`engine_id` 油AS 油 `engine_id`,`campaign_tracked_rankings`.`keyword_id` 油AS 油`keyword_id`,`campaign_tracked_rankings`.`keyword_labels` 油AS 油 `keyword_labels`,max(`campaign_tracked_rankings`.`rank`) 油AS 油`latest_rank`,max(`chained_domain_ranks_by_week`.`rank`) 油 AS 油`max_rank`,min(`chained_domain_ranks_by_week`.`rank`) 油AS 油`min_rank`,(max(`chained_domain_ranks_by_week`.`rank`) 油-足 油 min(`chained_domain_ranks_by_week`.`rank`)) 油AS 油`spread`,pow(exp(sum(log(coalesce((case 油when 油 (`chained_domain_ranks_by_week`.`delta` 油<> 油0) 油then 油abs(`chained_domain_ranks_by_week`.`delta`) 油end),0.5)))),(1 油/ 油 count(0))) 油AS 油`beta`,avg(abs(`chained_domain_ranks_by_week`.`delta`)) 油AS 油`avg_delta_mag` 油from 油((`campaigns` 油join 油 `campaign_tracked_rankings` 油on(((`campaigns`.`id` 油= 油`campaign_tracked_rankings`.`campaign_id`) 油and 油 (`campaigns`.`domain_host` 油= 油`campaign_tracked_rankings`.`domain_host`)))) 油join 油`chained_domain_ranks_by_week` 油 on(((`campaign_tracked_rankings`.`keyword_id` 油= 油`chained_domain_ranks_by_week`.`keyword_id`) 油and 油 (`campaign_tracked_rankings`.`engine_id` 油= 油`chained_domain_ranks_by_week`.`engine_id`) 油and 油 (`campaign_tracked_rankings`.`domain_host` 油= 油`chained_domain_ranks_by_week`.`domain_host`) 油and 油 (`chained_domain_ranks_by_week`.`week` 油in 油(`campaign_tracked_rankings`.`week`,(`campaign_tracked_rankings`.`week` 油-足 油 interval 油1 油week),(`campaign_tracked_rankings`.`week` 油-足 油interval 油2 油week),(`campaign_tracked_rankings`.`week` 油-足 油 interval 油3 油week)))))) 油group 油by 油 `campaign_tracked_rankings`.`campaign_id`,`campaign_tracked_rankings`.`engine_id`,`campaign_tracked_rankings`.`keywor d_id` Wednesday, May 29, 13
  • 19. chained_searches_by_week select 油`engine_keyword_week_latest_search`.`week` 油AS 油`week`,`engine_keyword_week_latest_search`.`search_id` 油AS 油`search_id`,`engine_keyword_week_latest_search`.`engine_id` 油AS 油 `engine_id`,`engine_keyword_week_latest_search`.`keyword_id` 油AS 油`keyword_id`,`engine_keyword_week_latest_search`.`search_date` 油AS 油`search_date`,`engine_keyword_week_latest_search`.`search_state` 油AS 油 `search_state`,`prior_week`.`search_id` 油AS 油`prior_search_id`,`prior_week`.`search_date` 油AS 油`prior_search_date`,`prior_week`.`search_state` 油AS 油`prior_search_state` 油from 油 (`engine_keyword_week_latest_search` 油left 油join 油`engine_keyword_week_latest_search` 油`prior_week` 油on(((`engine_keyword_week_latest_search`.`engine_id` 油= 油`prior_week`.`engine_id`) 油and 油 (`engine_keyword_week_latest_search`.`keyword_id` 油= 油`prior_week`.`keyword_id`) 油and 油(`engine_keyword_week_latest_search`.`week` 油= 油(`prior_week`.`week` 油+ 油interval 油1 油week))))) engine_keyword_week_latest_search select 油`searches`.`engine_id` 油AS 油`engine_id`,`searches`.`keyword_id` 油AS 油`keyword_id`,`searches`.`week` 油AS 油`week`,`searches`.`state` 油AS 油`search_state`,`searches`.`date` 油AS 油`search_date`,`searches`.`id` 油 AS 油`search_id` 油from 油(`searches` 油left 油join 油`searches` 油`better_search` 油on(((`searches`.`engine_id` 油= 油`better_search`.`engine_id`) 油and 油(`searches`.`keyword_id` 油= 油`better_search`.`keyword_id`) 油and 油 (`searches`.`week` 油= 油`better_search`.`week`) 油and 油(`better_search`.`state` 油= 油2) 油and 油(`searches`.`date` 油< 油`better_search`.`date`)))) 油where 油((`searches`.`state` 油= 油2) 油and 油isnull(`better_search`.`id`)) search_domain_rank select 油`pages_urls`.`search_id` 油AS 油`search_id`,`pages_urls`.`host` 油AS 油`domain_host`,`pages_urls`.`rank` 油AS 油`rank`,`pages_urls`.`url_id` 油AS 油`url_id` 油from 油(`pages_urls` 油left 油join 油`pages_urls` 油 `better_pages_urls` 油on(((`better_pages_urls`.`host` 油= 油`pages_urls`.`host`) 油and 油(`better_pages_urls`.`search_id` 油= 油`pages_urls`.`search_id`) 油and 油(`better_pages_urls`.`rank` 油< 油`pages_urls`.`rank`)))) 油 where 油isnull(`better_pages_urls`.`id`) campaign_trackings select 油`campaign_engines`.`campaign_id` 油AS 油`campaign_id`,`campaign_engines`.`engine_id` 油AS 油`engine_id`,`campaign_keywords`.`keyword_id` 油AS 油`keyword_id`,`campaign_keywords`.`labels` 油AS 油 `keyword_labels`,`campaign_domains`.`domain_host` 油AS 油`domain_host` 油from 油((`campaign_engines` 油join 油`campaign_domains` 油on((`campaign_engines`.`campaign_id` 油= 油`campaign_domains`.`campaign_id`))) 油join 油 `campaign_keywords` 油on((`campaign_engines`.`campaign_id` 油= 油`campaign_keywords`.`campaign_id`))) campaign_tracked_rankings select 油`campaign_trackings`.`campaign_id` 油AS 油`campaign_id`,`campaign_trackings`.`engine_id` 油AS 油`engine_id`,`campaign_trackings`.`keyword_id` 油AS 油`keyword_id`,`campaign_trackings`.`keyword_labels` 油AS 油 `keyword_labels`,`campaign_trackings`.`domain_host` 油AS 油`domain_host`,`engine_keyword_latest_search`.`search_id` 油AS 油`search_id`,`engine_keyword_latest_search`.`search_date` 油AS 油 `search_date`,`engine_keyword_latest_search`.`search_state` 油AS 油`search_state`,`engine_keyword_latest_search`.`week` 油AS 油`week`,`domain_ranking_summaries`.`rank` 油AS 油 `rank`,`domain_ranking_summaries`.`prior_rank` 油AS 油`prior_rank`,`domain_ranking_summaries`.`delta` 油AS 油`delta` 油from 油((`campaign_trackings` 油left 油join 油`engine_keyword_latest_search` 油 on(((`campaign_trackings`.`engine_id` 油= 油`engine_keyword_latest_search`.`engine_id`) 油and 油(`campaign_trackings`.`keyword_id` 油= 油`engine_keyword_latest_search`.`keyword_id`)))) 油left 油join 油 `domain_ranking_summaries` 油on(((`engine_keyword_latest_search`.`search_id` 油= 油`domain_ranking_summaries`.`search_id`) 油and 油(`campaign_trackings`.`domain_host` 油= 油 `domain_ranking_summaries`.`domain_host`)))) chained_domain_ranks_by_week select 油`chained_searches_by_week`.`search_id` 油AS 油`search_id`,`chained_searches_by_week`.`engine_id` 油AS 油`engine_id`,`chained_searches_by_week`.`keyword_id` 油AS 油 `keyword_id`,`chained_searches_by_week`.`week` 油AS 油`week`,`chained_searches_by_week`.`search_date` 油AS 油`search_date`,`search_domain_rank`.`domain_host` 油AS 油`domain_host`,`search_domain_rank`.`rank` 油AS 油 `rank`,`prior_search_domain_rank`.`rank` 油AS 油`prior_rank`,(`prior_search_domain_rank`.`rank` 油-足 油`search_domain_rank`.`rank`) 油AS 油`delta` 油from 油((`chained_searches_by_week` 油join 油`search_domain_rank` 油 on((`chained_searches_by_week`.`search_id` 油= 油`search_domain_rank`.`search_id`))) 油left 油join 油`search_domain_rank` 油`prior_search_domain_rank` 油on(((`chained_searches_by_week`.`prior_search_id` 油= 油 `prior_search_domain_rank`.`search_id`) 油and 油(`search_domain_rank`.`domain_host` 油= 油`prior_search_domain_rank`.`domain_host`)))) domain_ranking_summaries select 油`engine_keyword_latest_search`.`engine_id` 油AS 油`engine_id`,`engine_keyword_latest_search`.`keyword_id` 油AS 油`keyword_id`,`engine_keyword_latest_search`.`search_id` 油AS 油`search_id`,`urls`.`host` 油AS 油 `domain_host`,max(`engine_keyword_latest_search`.`search_date`) 油AS 油`search_date`,max(`engine_keyword_latest_search`.`search_state`) 油AS 油`search_state`,min(`chained_url_ranks_by_week`.`rank`) 油AS 油 `rank`,min(`chained_url_ranks_by_week`.`prior_rank`) 油AS 油`prior_rank`,(min(`chained_url_ranks_by_week`.`prior_rank`) 油-足 油min(`chained_url_ranks_by_week`.`rank`)) 油AS 油`delta` 油from 油 ((`engine_keyword_latest_search` 油join 油`chained_url_ranks_by_week` 油on((`engine_keyword_latest_search`.`search_id` 油= 油`chained_url_ranks_by_week`.`search_id`))) 油join 油`urls` 油 on((`chained_url_ranks_by_week`.`url_id` 油= 油`urls`.`id`))) 油group 油by 油`engine_keyword_latest_search`.`engine_id`,`engine_keyword_latest_search`.`keyword_id`,`urls`.`host` chained_url_ranks_by_week select 油`chained_searches_by_week`.`search_id` 油AS 油`search_id`,`chained_searches_by_week`.`engine_id` 油AS 油`engine_id`,`chained_searches_by_week`.`keyword_id` 油AS 油 `keyword_id`,`chained_searches_by_week`.`week` 油AS 油`week`,`pages_urls`.`url_id` 油AS 油`url_id`,`pages_urls`.`rank` 油AS 油`rank`,`pages_urls`.`page_number` 油AS 油`page_number`,`pages_urls`.`position` 油AS 油 `position`,`prior_pages_urls`.`rank` 油AS 油`prior_rank`,(case 油when 油(`prior_pages_urls`.`rank` 油is 油not 油null) 油then 油-足((`pages_urls`.`rank` 油-足 油`prior_pages_urls`.`rank`)) 油else 油NULL 油end) 油AS 油`delta` 油from 油 ((`chained_searches_by_week` 油join 油`pages_urls` 油on((`pages_urls`.`search_id` 油= 油`chained_searches_by_week`.`search_id`))) 油left 油join 油`pages_urls` 油`prior_pages_urls` 油on(((`prior_pages_urls`.`search_id` 油= 油 `chained_searches_by_week`.`prior_search_id`) 油and 油(`prior_pages_urls`.`url_id` 油= 油`pages_urls`.`url_id`)))) Wednesday, May 29, 13
  • 25. I may not be there today, but I am closer than I was yesterday. Wednesday, May 29, 13
  • 26. we are defined by what we make time to do Wednesday, May 29, 13
  • 28. thank you presentation by: kate matsudaira popforms Wednesday, May 29, 13