Below are two Excels used in one of the tutorials. The first one is the exact Excel used in the video with sample data. The second is a blank template, with headings and room for you to add your own data.
NOTE: If videos seem slow to start, your browser may be trying to download the whole video before playing. Be patient – we host on Amazon S3 – the biggest and fastest cloud network on the Internet. Rest assured, the videos will load!
Total Video Runtime: Approximately 2 hours 10 minutes
Part 2.1 – Intro to Google AdWords
Video Length: 10:08
Part 2.2 – Core Targeting & Strategy
Video Length: 12:52
Part 2.3 – Getting Started with AdWords
- Ad Copy
The main focus is on Campaigns, AdGroups and AdCopy. Keywords are covered deeply in the next video.
Video Length: 14:00
Part 2.4 – AdWords Keywords
Video Length: 17:17
Part 2.5 – Launching a Campaign
For larger campaigns, it is easier to ad Keywords, Ads and AdGroups using a desktop software tool in a later video called AdWords Editor. However, you still need to know how to use https://adwords.google.com for some of the finer adjustments and small edits.
Video Length: 2:56
Part 2.6 – Building Campaigns, AdGroups & Keywords in Excel
While we forgot to mention it in the video, one of the nice things about an Excel is you can design your account with Campaigns, AdGroups, Ads & Keywords, and give the Excel to your IRB to review and approve.
Once approved, you can then take that info and add it to your account via the browser interface at https://adwords.google.com or using AdWords Editor software.
Video Length: 15:02
Part 2.7 – Building Ad Text (Creatives) in Excel
The Excel we provide you (at the top of this page) is formatted with the columns you will need. It also includes extra columns to count the length of the headlines and description lines to make sure you comply with Google’s limits:
- Titles (aka Headlines): 25 Character Maximum
- Description Line 1 : 35 Character Maximum
- Description Line 2 : 35 Character Maximum
Video Length: 08:46
Part 2.8 – Adding Your Keywords and Ads to Adwords via Browser and AdWords Editor
Part 1: Uploading & Configuring Information @ AdWords Website – Video Length: 20:20
Part 2: Using AdWords Editor (Desktop Software) – Video Length: 24:17
Part 2.9 – Bidding & Optimization Tips
Video Length: 15:17
Q&A Session Week 2
Approximately 35 minutes