LinkedInI don’t like how stock B7 headlights look. Instead my buddy Rice helped me clear corner and black out the existing headlights. As an added touch, I was able to source a set of B6 ecode caps and fit them to the B7 headlights.
March, 2008
26
Mar 08
Google Adwords Updates Display URL Policy
Google recently announced a major update to their display URL policy in AdSense ads in an effort to further incorporate landing page quality to their bid and CTR algorithm which determines what position your ad appears and how relevant the keyword that you are buying is to your landing page.
What do I need to know about the updated display URL policy?
Based on feedback from both our advertisers and users, and consistent with our efforts to present relevant results, we’ll no longer allow certain exceptions to our display URL policy. These include, but aren’t limited to, redirects and vanity URLs. In line with our existing policy, we’ll continue to require that your ad’s display URL matches its destination URL (the URL of your landing page). This policy will be strictly enforced for new ads, regardless of previous exceptions. For more details about the current display URL policy, please visit https://adwords.google.com/support/bin/answer.py?answer=47173
.
Here are some other important aspects of the policy you may want to keep in mind:
Tracking URLs – Your ads will be approved if the URL of your landing page domain matches that of your display URL domain.
For example, the following would be acceptable:
• Display URL: www.google.com/adwords
• Destination URL: www.trackingurl.com/google123
• Landing page URL: www.google.com
However, this example would be unacceptable:
• Display URL: www.google.com/adwords
• Destination URL: www.trackingurl.com/google123
• Landing page URL: www.trackingurl.com
Sub-Domains
The use of sub-domains and additional text within the display will continue to be acceptable, provided the top-level domain matches the URL of your landing page.
For example, the display URLs below would be acceptable for the landing page URL of http://sub.google.com/miscellaneous, as the top-level domains match:
• sub.google.com
• google.com/extratext
• www.google.com/extratext
Quality Score
Note that changing your display URL may affect your ad’s Quality Score and ad position.
Keyword URLs
Keyword URLs are considered your destination URL (the URL of your landing page); your ad’s display URL must match its destination URL.
Next Steps
While no immediate action will be taken on existing ads, we encourage you to make the necessary changes to all ads within your account. This will ensure that your ads run without being disrupted by future disapprovals related to this policy enforcement. Visit https://adwords.google.com/support/bin/answer.py?answer=6272 for step-by-step instructions for editing your display URL.
17
Mar 08
Away until April 2nd
Sorry for the lack of updates, we are working to code complete our latest and largest Rails project: a free online dating site. Until we launch, I likely will not have time to write any blog posts. When I have more time, I have a wealth of things to share with you all!
10
Mar 08
I am a certified AdWords Professional
I qualified last week and am now an AdWords Professional and our company, Add Three, is now an AdWords Qualified Company!
Those of you who are managing AdWords media campaigns should seriously look into the AdWords qualification. The training program offers a plethora of information, some of it will even be information that is new to you! The training program is 9 sections long, encompassing everything from initial signup all the way to the developer API. To become certified, you must meet some prerequisites:
- pass the test with 75% or greater within the 1h 30min test window
- have an account in good standing for t least 90 days
- for an individual, manage a 90 day ad spend of $1,000 or $100,000 in the US (this varies by country)
As an AdWords Professional Google will offer you access to the My Client Center, API access, the Qualified Individual/Company designation, and some other miscellaneous perks.
Learn more about the program at the Google AdWords Professional page.
6
Mar 08
Find your Rails subdomains
Need to find the subdomain of an incoming request? Recently I needed to determine the subdomain of an incoming request to properly format some search queries.
@subdomain =request.subdomains.first
5
Mar 08
View SQLite data with columns
SQLite allows us to quickly and effortlessly get our Rails applications off the ground. Having used MySQL, I was used to formatted data queries . The first time I used a SQLite database, I was in for a little shock.
add3-imac:trunk jon$ sqlite3 db/development.sqlite3
SQLite version 3.4.0
Enter ".help" for instructions
sqlite> SELECT * FROM users;
1|straight|man|Seattle|1@msn.com|1928-03-03|t|2008-02-21 11:40:05|2008-02-21 11:40:05
2|straight|man|Portland|2@msn.com|1928-03-03|t|2008-02-21 11:40:09|2008-02-21 11:40:09
3|straight|woman|Oregon|3@msn.com|1928-03-03|t|2008-02-21 11:40:12|2008-02-21 11:40:12
sqlite>
SQLite version 3.4.0
Enter ".help" for instructions
sqlite> SELECT * FROM users;
1|straight|man|Seattle|1@msn.com|1928-03-03|t|2008-02-21 11:40:05|2008-02-21 11:40:05
2|straight|man|Portland|2@msn.com|1928-03-03|t|2008-02-21 11:40:09|2008-02-21 11:40:09
3|straight|woman|Oregon|3@msn.com|1928-03-03|t|2008-02-21 11:40:12|2008-02-21 11:40:12
sqlite>
That is a little tricky to decipher…let’s try something a little different!
sqlite> .headers on
sqlite> .mode column
sqlite> SELECT * FROM users;
id orientation gender city email birthday subscribed created_at updated_at
---------- ----------- ---------- ---------- ----------- ---------- ---------- ------------------- -------------------
1 straight man Seattle 1@msn.com 1928-03-03 t 2008-02-21 11:40:05 2008-02-21 11:40:05
2 straight man Portland 2@msn.com 1928-03-03 t 2008-02-21 11:40:09 2008-02-21 11:40:09
3 straight woman Oregon 3msn.com 1928-03-03 t 2008-02-21 11:40:12 2008-02-21 11:40:12
sqlite>
sqlite> .mode column
sqlite> SELECT * FROM users;
id orientation gender city email birthday subscribed created_at updated_at
---------- ----------- ---------- ---------- ----------- ---------- ---------- ------------------- -------------------
1 straight man Seattle 1@msn.com 1928-03-03 t 2008-02-21 11:40:05 2008-02-21 11:40:05
2 straight man Portland 2@msn.com 1928-03-03 t 2008-02-21 11:40:09 2008-02-21 11:40:09
3 straight woman Oregon 3msn.com 1928-03-03 t 2008-02-21 11:40:12 2008-02-21 11:40:12
sqlite>
That’s more like it!
4
Mar 08
Seattle Condos and geocoding with geokit
Wanting to be more Google-centric, I’ve reworked the mapping API on Seattle Condos to use Google Maps instead of Yahoo’s mapping API.
Why would I do this? It’s up to debate, but I believe that the more data Google has available to it, the better chance you have to appear in their search listings. Using Google’s API will provide Google with more information than by using Yahoo’s API.
Previously, our geocoding was accomplished with Yahoo’s simple, intuitive API. Supplying an address and zipcode was enough to have Yahoo geocode an address and display it on their map. Switching to Google’s API was not difficult, but required a few small steps.
Google does not allow you to map points using addresses, instead you must provide a latitude and longitude. To accomplish this, I choose to use geokit for rails to geocode our existing addresses. I wrote a script to cycle through our database and geocode each record, then save the new coordinates for future use. After the coordinates were obtained, we could easily map the points using Google’s API,
Here’s is a sample of the code I used with geokit:
@location = YahooGeocoder.geocode("#{@condo.address}, #{@condo.zipcode}")
4
Mar 08
Import a MySQL dumpfile into your database
After you have used MySQL to dump your database, FTP that dump file to an accessible directory on your server.
Once you have uploaded the dump file to your account here, make your way back to command line and get ready to import the file!
Now to import the dump file into MySQL, use the following command at your shell prompt:
# USER is your MySQL username
# DBSERVER is your database servername, not always required
# dbname is your database name# dbname.sql is the dump file you are importing
# -p will prompt for your password
mysql -u USER -p -h DBSERVER dbname < dbname.sql
If your preferences are properly set, the same thing can be accomplished with:
mysql < dbname.sql
Enjoy!
3
Mar 08
Use MySQL to dump databases
Often times you will need to dump your MySQL database from one machine to another. Sometimes you can use utilities like PHPMyAdmin, but it’s always useful to know how to dump your database’s contents manually.
add3-imac:~ jon$ mysqldump -u username -p databasename >/tmp/databasename.sql