Portfolio
Mita Web Application
Details
- Category
- Application Development
- URL
- TBD
- Content Management System
- WordPress - Custom PHP Application
- Year Completed
- 2012
Briefing
The application is going to be a selection based contract creator utilizing the modified preorder tree traversal algorithm. The contract will be created based on the input selection of a form. It will query the backend by passing the selections to a script that will choose what to include in the contract. This will save a lot of man power and time.
MPTT is a fast algorithm for storing hierarchical data (like categories and their subcategories) in a relational database. This is a problem that most of us have had to deal with, and for which we’ve used an adjacency list, where each item in the table contains a pointer to its parent and where performance will naturally degrade with each level added as more queries need to be run in order to fetch a subtree of records.
The aim of the modified preorder tree traversal algorithm is to make retrieval operations very efficient. With it you can fetch an arbitrary subtree from the database using just two queries. The first one is for fetching details for the root node of the subtree, while the second one is for fetching all the children and grandchildren of the root node.
The tradeoff for this efficiency is that updating, deleting and inserting records is more expensive, as there’s some extra work required to keep the tree structure in a good state at all times. Also, the modified preorder tree traversal approach is less intuitive than the adjacency list approach because of its algorithmic flavour.
The Michigan Infrastructure and Transportation Association (MITA) is a statewide construction trade association that consists of nearly 600 Michigan companies representing construction disciplines such as road and bridge, sewer and water, utility, railroad, excavation and specialty construction throughout the state of Michigan.
Bee for the Day
Details
- Category
- SEO & Pay per click
- Search Engine
- Google Adwords
- Year Completed
- 2011-Present
Briefing
We first optimized her website for 3 keywords: wedding planner, wedding planning, wedding coordinator. Locally she ranked for wedding coordinator well. Our goal is to get her ranking well for the other two terms, but more importantly drive business and interest with these other two words. So, for short term we have decided to take advantage of the PPC ads.
The campaign run in December has generated an increased interest in Bee for the Day and it has even lead to contract leads, aka conversions. The success of this campaign has lead to an increased interest in Adwords and we will be running them again in February.
Clicks - 39
Click Through Rate (CTR) - 1.15%
Average Cost per Click - $2.81
Cost/Total Spend - $109.63
Clicks - 50
Click Through Rate (CTR) - 1.49%
Average Cost per Click - $2.07
Cost/Total Spend - $103.67
Clicks - 39
Click Through Rate (CTR) - 1.37%
Average Cost per Click - $2.56
Cost/Total Spend - $99.99
Clicks - 51
Click Through Rate (CTR) - 1.64%
Average Cost per Click - $2.04
Cost/Total Spend - $104.18
Clicks - 48
Click Through Rate (CTR) - 0.90%
Average Cost per Click - $2.08
Cost/Total Spend - $99.87
The Image Group
Details
- Category
- HTML & SEO
- Search Engine
- Google, Yahoo, MSN
- Year Completed
- 2010-2011
Briefing
Initial
- Google: Promotional Products Toledo: 37
- Google: Cleveland Promotional Products: 14
- Google: Ann Arbor Promotional Products: 9
- Bing: Promotional Products Toledo: 28
- Bing: Cleveland Promotional Products: N/A
- Bing: Ann Arbor Promotional Products: 5
- Yahoo: Promotional Products Toledo: 19
- Yahoo: Cleveland Promotional Products: 29
- Yahoo: Ann Arbor Promotional Products: 16
- Ask: Promotional Products Toledo: 8
- Ask: Cleveland Promotional Products: N/A
- Ask: Ann Arbor Promotional Products: 4
After 3 Months
- Google: Promotional Products Toledo: 1
- Google: Cleveland Promotional Products: 13
- Google: Ann Arbor Promotional Products: 1
- Bing: Promotional Products Toledo: 26
- Bing: Cleveland Promotional Products: 43
- Bing: Ann Arbor Promotional Products: 16
- Yahoo: Promotional Products Toledo: 12
- Yahoo: Cleveland Promotional Products: 16
- Yahoo: Ann Arbor Promotional Products: 8
- Ask: Promotional Products Toledo: 1
- Ask: Cleveland Promotional Products: 21
- Ask: Ann Arbor Promotional Products: 1
*Unfortunately when the migration occured, the links were never 301 redirected to the new location so all of the SEO strength over the past 2 years was gone.
Nunovo
Details
- Category
- Pay per click
- Search Engine
- Google Adwords
- Year Completed
- 2012
Briefing
As a thank you for the work contracted to me, I ran an Adwords campaign for them both in Michigan and in Colorado. The results of both traffic and PPC campaign are displayed below. The campaign for Michigan went extremely well. I expected to get about 1/5 or 1/6 of the results that we received. Getting 327 click throughs was quite an impressive feat. It taught me a lot about how to handle a PPC campaign and if extra time is taken how effective it can be. They gave me access to view their analytics so I can view the impact it had overall on their web presence. I will be updating February traffic in early March to see the final effect of traffic from the exposure. I ran the campaign from January 28th through February 9th.
Clicks - 327
Click Through Rate (CTR) - 0.11%
Average Cost per Click - $0.30
Cost/Total Spend - $99.56
Clicks - 70
Click Through Rate (CTR) - 0..06%
Average Cost per Click - $1.42
Cost/Total Spend - $99.47
College Kids Need Money
Details
- Category
- WordPress
- Content Management System
- WordPress
- Year Completed
- 2011
Briefing
Lincoln Electric
Details
- Category
- Ecommerce
- Content Management System
- Custom
- Year Completed
- 2011
Briefing
St Julians Fitness
Details
- Category
- SEO & Pay per click
- Search Engine
- Google Adwords
- Year Completed
- 2011
Briefing
Campaign December 2011
Clicks - 61
Click Through Rate (CTR) - 0.19%
Average Cost per Click - $1.80
Cost/Total Spend - $109.83
Metro State
Details
- Category
- Application Development
- URL
- TBD
- Content Management System
- Custom PHP Application
- Year Completed
- 2012
Briefing
Metro State is a comprehensive college offering bachelor's and master's degrees on the Auraria Campus in downtown Denver.
Founded in 1965, Metro State has grown to more than 24,000 students and educates more undergraduate Coloradans than anyone else in the state. Since nearly 80 percent of our alumni live and work in Denver and the state, you could say we specialize in fostering homegrown talent for the challenges of a new century.
Advanced DG
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2011
Briefing
Xunlight Corporation
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2009
Briefing
Solscient Energy LLC
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2010
Briefing
Perrysburg Electric
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2011
Briefing
Denbro Plastics
Details
- Category
- SEO
- Search Engine
- Google, Yahoo, MSN
- Year Completed
- 2011
Briefing
- Custom Nameplates: 136
- Three Dimensional Nameplates: 9
- Plastic Nameplates: 32
- Logo Nameplates: 30
- Automotive Nameplates: 9
- Industrial Nameplates: 47
After the initial SEO, Denbro went from invisible to being ranked in the top 100 with two keywords ranking on the first page!
Just Look Up
Details
- Category
- Pay per click
- Search Engine
- Google Adwords
- Year Completed
- 2011
Briefing
Campaign Cyber Monday - 2011
Clicks - 135
Click Through Rate (CTR) - 1.34%
Average Cost per Click - $1.38
Cost/Total Spend - $186.73
Sylvania Braces SEO
Details
- Category
- SEO
- Search Engine
- Google, Yahoo, MSN
- Year Completed
- 2011-2012
Briefing
Initial
- Sylvania Orthodontics: N/A
- Sylvania Braces: N/A
- Sylvania Invisalign: N/A
- Toledo Orthodontics: N/A
- Toledo Braces: N/A
- Toledo Invisalign: N/A
After 1 month
- Sylvania Orthodontics: 46
- *Sylvania Braces: 1
- Sylvania Invisalign: 18
- Toledo Orthodontics: 24
- *Toledo Braces: 10
- Toledo Invisalign: 43
*We focused on these two keywords most. The domain name helped significantly with Sylvania Braces.
After the initial SEO, Sylvania Braces went from invisible to being ranked in the top 50 with two keywords ranking on the first page!
All Square
Details
- Category
- Pay per click
- Search Engine
- Google Adwords
- Year Completed
- 2012
Briefing
The name says it all: The Leading from the Heart Workshop teaches leaders at all levels how to lead with heartfelt principles. This three-day workshop provides a unique opportunity to explore values-based leadership with Vital Integrities author George Brymer in an intimate, small group setting. By balancing information with experiential exercises that are both practical and memorable, George ensures that the lessons you learn will endure long after the workshop ends.
The campaign ran in Michigan, Ohio, and Indiana. Even with that wide spread area, I was able to work to get a good cost per click price.
Campaign Cyber Monday - 2011
Clicks - 28
Click Through Rate (CTR) - 0.16%
Average Cost per Click - $2.21
Cost/Total Spend - $101.84
Stikii
Details
- Category
- eCommerce
- Content Management System
- WordPress - Jigoshop
- Year Completed
- 2011
Briefing
Expandability – In the future, there may be new shipping methods, coupons, shipping locations, or taxes. These things need to be covered thoroughly before begginning to think about how to approach the project.
Speed – The loading speed and the checkout speed. First the checkout speed. A user should be able to do a guest checkout where an account is not created unless the user wants too. Guest checkout enables a more streamlined process. As far as loading, you want the pages to load quickly, the products to be displayed in an attractive and trust way, but the bottom line is people won’t way to see something pretty. They want it instant. 5 Seconds is too long to wait. Most people will cancel it and find another place to buy.
Maintenance – This one is key for any project expanding rapidly or with a lot of changes. The easier it is to maintain the less work that you as the developer will have to do in the long run. You will be able to keep some time and cost down, even if it is slightly more to begin with.
Integration – One of the most important pieces of any Ecommerce website is to make the user feel as comfortable as possible. This means integrating with a card processor and some form of SSL certificate to process this. The next best method is to utilize an all in one solution like Google Checkout or Paypal. These services are offered, but take out a higher service fee which leaves you scratching the bottom of the barrel for profit. They are great until you start getting consistent orders.
The Manage Cloud CMS
Details
- Category
- CMS
- Content Management System
- Custom
- Year Completed
- 2011
Briefing
Elizabeth Sankowski
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2010
Briefing
Computer Savvy
Details
- Category
- CMS
- URL
- TBD
- Content Management System
- WordPress
- Year Completed
- 2012
Briefing
Busy Bodies LLC
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2011
Briefing
She possesses a unique gift for working with young children and her energy is endless!
Valor Group
Details
- Category
- HTML / CSS
- URL
- TBD
- Search Engine
- N/A
- Year Completed
- 2012
Briefing
100k Entrepreneur
Details
- Category
- HTML / CSS
- URL
- the100kentrepreneur.com/
- Content Management System
- Minor PHP
- Year Completed
- 2011
Briefing
Originally the idea was for 50,000 spaces and sold for $2 each, but the graphics people wanted to use fit better into a grid format that allowed 10 spaces @ $10 rather than 5 spaces @ $10 assuming $1 and $2 per ad respectively. The website had a complete redesign after reflecting the million dollar website too closely. It utilized minor PHP where the ad space left would auto decrement based upon the ads sold. It also allowed for brief customizations in text with the header where specials could be run.
Update: Looking for a screen shot of the newer design.
Stikii Blog
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2011
Briefing
Durk Music Beats
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2010
Briefing
Driftwood Cottages
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2010
Briefing
CSR Ecommerce
Details
- Category
- Ecommerce
- URL
- Not Available - See Below
- Content Management System
- Joomla - VirtueMart
- Year Completed
- 2010
Briefing
The Repository
Details
- Category
- Ecommerce
- URL
- Being Updated
- Content Management System
- Magento
- Year Completed
- 2011
Briefing
A E Wedding
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2012
Briefing
First Baptist Church Galatia
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2009
Briefing
The Manage Cloud
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2011
Briefing
Melissa Lechlak
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2010
Briefing
Scottish Premeire
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2011
Briefing
66wfan
Details
- Category
- CMS
- Content Management System
- VBulletin
- Year Completed
- 2010
Briefing
Aaron Lechlak
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2011
Briefing
Homework Haven
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2011
Briefing
Brooklyn Ancestry
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2010
Briefing
If you are old enough you have undoubtedly seen many changes within the community you lived in as a child. But what will it look like in 120 years from now?
Clicks - 48
Click Through Rate (CTR) - 0.90%
Average Cost per Click - $2.08
Cost/Total Spend - $99.87
Landing Pages
Details
- Category
- CMS
- URL
- See Description
- Content Management System
- None
- Year Completed
- 2011
Briefing
Castaway Cottages
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2010
Briefing
Dark Portfolio
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2011
Briefing
Drapes by Sue
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2009
Briefing
Estons Bakery
Details
- Category
- CMS
- Content Management System
- WordPress
- Year Completed
- 2010
Briefing
Excessive Amperage
Details
- Category
- CMS
- Content Management System
- Joomla
- Year Completed
- 2009
Briefing
Smiles
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2011
Briefing
Sylvania Braces
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2010
Briefing
Wolfpack Audio
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2008
Briefing
Runnning both SEO and PPC gave Bill a lot more traffic and resulted in a number of conversions for him.
Campaign June 2010
Clicks - 83
Click Through Rate (CTR) - 4.15%
Average Cost per Click - $0.81
Cost/Total Spend - $67.23
Richards Health Care System
Details
- Category
- HTML / CSS
- URL
- No Longer Exists
- Content Management System
- None
- Year Completed
- 2009
Briefing
Gillians Italian Ice
Details
- Category
- HTML / CSS
- URL
- Hosting Transfer
- Content Management System
- None
- Year Completed
- 2011
Briefing
Flash Portfolio
Details
- Category
- HTML / CSS
- Content Management System
- XML - Custom
- Year Completed
- 2010
Briefing
Loopy Dudes
Details
- Category
- HTML / CSS
- URL
- TBD
- Content Management System
- None
- Year Completed
- 2010
Briefing
Falling Apart Peacefully
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2010
Briefing
As most of you probably know, we now have our very own =FAP= Clan public BFBC2 server. This means a little bit to everybody, but especially a lot to our newer members. Rewind back to CoD4, when our clan at the time, PFA, ran a successful and popular server that was a big hit with the community. It's time to get back to the COMMUNITY, something that MW2 ripped away without a second thought.
As most of you probably know, we now have our very own =FAP= Clan public BFBC2 server. This means a little bit to everybody, but especially a lot to our newer members. Rewind back to CoD4, when our clan at the time, PFA, ran a successful and popular server that was a big hit with the community. It's time to get back to the COMMUNITY, something that MW2 ripped away without a second thought.
Mobile Car Audio
Details
- Category
- HTML / CSS
- Content Management System
- PHPBB
- Year Completed
- 2010
Briefing
Molly Kujawa
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2009
Briefing
Mid West Car Audio
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2010
Briefing
Reed Funeral Chapel
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2010
Briefing
Sin Arms
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2009
Briefing
Tree Berry Productions
Details
- Category
- HTML / CSS
- URL
- No Longer Exists
- Content Management System
- None
- Year Completed
- 2009
Briefing
Lawton Gaming
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2010
Briefing
Potter Computer Consulting Inc
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2009
Briefing
Pure PC Power
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2009
Briefing
Steves Wildlife Removal
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2009
Briefing
Werdna EFX
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2008
Briefing
Kataphractoi
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2009
Briefing
This website design was created for a guild in a computer game known as Saga.
Werdna FX v2
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2009
Briefing
Werdna FX v1
Details
- Category
- HTML / CSS
- Content Management System
- None
- Year Completed
- 2009
Briefing
About Me
Introduction
Hello World. My name is Andrew Lechlak - a web designer and developer in the wonderful state of Ohio.
I began programming for fun in 2000 with practice in TRUCK and BASIC. After some classes in highschool, an internship at Xunlight Corporation, and a need to pay my tuition, I began broadcasting myself as a web developer.
2008 marked my beginnings as a freelance web designer. I first did a website for a wildlife removal company in Chicago, a solar panel company, and a PC consulting company.
After getting a few projects under my belt, I joined a few forums and designed and developed my own portfolio. This brought in more business from areas around The United States, Tasmania, and Australia. I have gained a lot of marketing and business experience dealing with clients in different areas of the world.
Since 2008 I have developed 49 commercial websites on different platforms including Joomla, WordPress, Zen Cart, Magento, and my own custom content management system, The Manage Cloud. I guarantee that my website quality will beat your expectations while remaining within your budget.
A little update here. I am moving toward becoming a digital branding company so my first priority of business is launching a Toledo SEO campaign where I can target local businesses and help them increase their profit to help stimulate the economy. Toledo has been hit exceptionally hard and I would like to do my part with SEO and help them get stronger.
Downloads
Contact Me
Contact Information
- me@lechlak.com
- Address
- Toledo, Ohio 43623