10 Excel Tools And Time Savers For PPC Ad Writing

Be Kind And Share :)

Search engine gurus who manage multiple accounts, or campaigns, often times have an interesting time writing ads that are too lengthy or have not enough negative keywords attached to the campaign.? With time-saving programs like Microsoft Excel, and ingenuity, you can create preformatted sheets which have formulas embedded to handle title length of ad, total ad copy word count, keywords, desired CPC and everything you see in an AdWords campaign.

Aside from normal trickery, we?ll investigate some fine intricacies of PPC ad writing and how using spreadsheets can streamline the process, while tossing in some useful tools which can be implemented into your Microsoft Excel ad writing barrage.? We?ll go beyond the =LEN and =IF formulas for simplification of your PPC copywriting duties.? First, let?s examine the tips:

Setting Ad Titles To Ad Groups

It simplifies your ad writing when the titles of your advertisement equal the group which it belongs to.? If you label your campaign ?Car Tires? and your ad group is ?Michelin Tires,? you simply can =B2 the ad group to copy that over to title, as AdWords will read this the same.? Using this feature allows your advertisement copy to each have predefined titles for easier tracking altogether.

Use Of Control F

After you?ve filled out most of your keywords and ad grouping verbiage, make sure color coding is established for the various headings Google shall read.? Basically, quick color formatting is taking the last color completed and utilizing Control+F to open the formatting option, where you can then change color schema at will.? You can continue this as you develop each group.

Templation

For those PPC campaigns with slightly higher levels of complexity, you should consider templation which is like prepping your oven before baking, per se.? This works well if you have numerous products or services that need numerous adjectives to describe them.? First, to assure you won?t go over character limits, you?ll need to head towards the ?Data? tab and allow the data validation length parameters to be set at 0-35 or 0-25, depending on whether you?ll write numerous titles or headlines.

From there you can simply create the various product headings and assign numerical values to each and use the Control+F formatting feature to assign the correct color format to each for separation.? Once you?ve uploaded your ad copy to Google AdWords campaign, save the template for future use since the formatting, in general, will remain the same across numerous ads written.

Testing

When writing PPC ad copy, you may want to test calls to action against each other to assure you?re maximizing click revenue.? You can simply create a Description 1 and 2 heading and fill them both in.? This allows you to perfect one or the other; simply delete the row you don?t want to keep and assign Description 1 to the one you will be keeping.? Internal competition of this nature effectively weeds out potentially derogatory ad copy and allows changes to be implemented before uploading into your AdWords campaign.

Increasing Quality Score

Every PPC professional knows that raising quality score means you can spend less per click.? Taking this fact to our Excel PPC ad writing campaigns, we can add an adjective along with our description line in formula mode (something like Awesome ?&C2&?) to append adjectives to prewritten description lines.? It speeds up the process and gives our ad copy the chance to increase its quality score.

Now that we went over the tricks, let?s get to the tools of the copywriting trade:

Concatenate

A nifty tool, which allows PPC ad writers to either conjoin two groups of text, or even allows for URL tracking, is concatenation. First, we?ll create our punchy headline in Cell A.? Next, well append the =CONCATENATE function into the B column and make it look like this:

Headline	Output
Hot Wheels Cars	=CONCATENATE(?New?, A2)

?

This will allow the output to put ?New? in front of Hot Wheels Cars.? You can use Column C for =LEN value to assure that your titles aren?t amassing the allowed character count in Google.? You can also use concatenation for your broad matching keywords by adding + sign before those keywords, although it will only qualify the first token within the keyword.? Finally, using this tool also provides a helpful means to add words you may have forgotten at the beginning of your title, description or extra keyword helpers.

Capitalize

If you?re not always typing with proper first letter capitalization, another useful function when writing ad copy is the =PROPER function which will increase the case of the first letter in each sentence or title. Since each value will appear in the next cell to the right, you will need to copy/paste the formula into the heading containing the row which you wish to manipulate capitalization within.? It may seem tricky at first, yet can save hours of editing if you engage the formula from the beginning.? You can use the same function to capitalize words spaced apart.

Use Of Conditional Formatting Feature

Since thousands of conditional formatting features are available to PPC ad copywriters, the two more commonly used features are the greater than and less than.? Since we know headlines cannot exceed 25 characters, you can perform a quick check once you?ve completed your spreadsheet.? By highlighting the cell and selecting Conditional Formatting > Greater Than, you can set the entire column to be equal to 25 characters.

Once you click ?ok?, any overly written titles will be highlighted red.? This feature works well with Less Than as well, since you?ll want to leverage every available character to your advantage.? The most useful conditional formatting function for those wanting unambiguous keyword usage is the Duplicate Value, which can be set to fetch repetitious wording you wish to avoid throughout your advertisement copy.

Problem Detection

Going along with some previous tools mentioned is the =IF function, which acts as problem detection for excessively lengthy ads. Appending something to adjudicate your writing as correct or problematic can simplify uploading the final document into your AdWords account and finding out later that ads were rejected.? ?A? can be your description lines, ?B? can act as your =LEN indicator and ?C? can contain your =IF >25 or >35,?Long?,?? value which means the space will either be blank or contain a red flag.? Use this formula if you know time isn?t on your side and numerous ad copies need to be written simultaneously.

Ad Copy Alternative

If you simply want something already made up for you to write aggressive ad copy for numerous accounts, the Mass Ad Copy Creator was invented to allow you to plug in several titles, descriptions and keywords, while receiving outputs of hundreds of variations.? Sure, it does come with a price; everything quick and automated in your life does, however, and this could be an invaluable tool for those who manage several dozen accounts simultaneously.

However, for those of you wanting to save a few bucks and write the entire campaign out yourself, the tools above are already in Excel for you to use.? Simplification of repetitive tasks in writing PPC ad copy requires knowledge of specific functions available to check, append and cross-reference text written, which we?ve provided above.

About The Author: Tim Wilson works as content manager for HostPapa, a website hosting company serving over 100,000 customers around the world. Since launching in 2006, HostPapa has offered reliable, budget-friendly, easy-to-use web hosting solutions for small to medium-sized businesses.

?

http://www.gravatar.com/avatar/2fa73c71012970a61cabaf8459282de0.png

Social Profiles:

http://www.facebook.com/hostpapa

http://www.twitter.com/hostpapa

https://plus.google.com/114315129431047860825?prsrc=3

Related articles

3 Weird Marketing Tricks

This Is How You Get People To Buy From You (And You Will Love It)

Your Privacy is SAFE, Spam Sucks I wouldn't insult you that way :)

Tagged as: adwords, Google, Google AdWords, Keywords, Microsoft Excel, Pay per click, Quality Score, Uniform Resource Locator

Source: http://profitonknowledge.com/internet-marketing-strategies/10-excel-tools-and-time-savers-for-ppc-ad-writing/

charles manson al sharpton actuary elon musk fox mole manson bubba watson

UK police sorry for using stun gun on blind man

LONDON (Reuters) - British police apologized on Wednesday for using a stun gun on a blind man after officers mistook his white cane for a samurai sword.

Officers were responding to "a number of reports that a man was walking through Chorley armed with a samurai sword", when they confronted Colin Farmer, who was on his way to meet friends in a pub last Friday, in the northern English town.

When Farmer, 61, did not respond to their calls to stop, one of the officers used his taser stun gun, which delivers a 50,000 volt shock.

"I certainly didn't know they were police - and I certainly didn't know they were shouting at me. I thought I was going to be attacked by some hooligans," Farmer told the Lancashire Evening Post newspaper.

Despite pleading with the police and telling them he was blind, he was handcuffed.

"It then became apparent that this man was not the person we were looking for and officers attended to him straight away," said Chief Superintendent Stuart Williams in a statement, adding the innocent man was taken to hospital for treatment.

"Lancashire Constabulary deeply regrets what has happened. We have clearly put this man through a traumatic experience and we are extremely sorry for that."

Police later arrested a 27-year old man in connection with the sword reports but released him without charge.

The incident has now been referred to the independent police watchdog for further investigation.

(Reporting by Michael Holden; Editing by Elaine Hardcastle)

Source: http://news.yahoo.com/uk-police-sorry-using-stun-gun-blind-man-210411522.html

giuliana rancic giuliana rancic temptations work hard play hard tim ferriss wmt human nature

Greetings From Hanover (Powerlineblog)

Share With Friends: | | Politics - Top Stories Stories, RSS and RSS Feed via Feedzilla.

Source: http://news.feedzilla.com/en_us/stories/politics/top-stories/255450250?client_source=feed&format=rss

kat dennings Steve Sabol Yom Kippur 2012 detroit lions Aaron Paul mumford and sons packers

Brawl Between Two Wedding Parties in Philly Results in One Death, Three Arrests [Video]

A massive brawl broke out between two separate wedding parties in a Philadelphia hotel last night. One wedding guest, the uncle of a bride, died afterwards of a heart attack, and three other guests were arrested. As you can tell from the video above, it was quite the drunken shit show.

"There was an issue with a lot of alcohol fueling the fight," said police spokesman Lt. Ray Evers.

The fight started in the bar at the appropriately named Sheraton Society Hill Hotel and soon spread to the lobby. According to always reliable YouTube commenters, the altercation was triggered when one wedding party, which had a pay bar, attempted to crash the open bar of the other party, which, if true, is as good a reason as any to fight.

Seven police officers can been seen in the video, including one who beats the hell out of an unruly guest with his baton. Police were so overwhelmed that, according their report, they had to call for backup twice. About halfway into the clip, one of the brides enters the fray and appears to go down, perhaps from contact from police. Eventually, she's escorted out.

The video was caught on camera by Matt Schultz, who was celebrating his 15th birthday at the hotel.

"I was up on the second floor watching. It was bedlam, out of hand." Schultz said.

Two guests were cited with counts of disorderly contact and a third, apparently the one getting beat with a baton, was charged with assaulting a police officer. The man who died was also celebrating his 57th birthday and was reportedly not directly involved in the fight.

Source: http://feeds.gawker.com/~r/gawker/full/~3/V6VVqq9vN9E/brawl-between-two-wedding-parties-in-philly-results-in-one-death-three-arrests

ann curry nhl obamacare Nexus 7 euro 2012 dominion power Colorado Springs

Pearl.com, The Professional Q&A Site Formerly Named JustAnswer, Lands $25.7 Million Series B Funding

Pearl.com, the Q&A site formerly known as JustAnswer, has raised $25.7 million in a Series B funding round. The San Francisco-based company plans to use the money to expand its product globally, build out its mobile presence, and grow its current staff of 300-some employees, half of whom are full-time. Its first new hire with the new funding is Erik Zech, the executive who previously took Real Goods Solar public, who will serve as Pearl.com's first-ever CFO.

Source: http://feedproxy.google.com/~r/Techcrunch/~3/2Lar3Zta7vI/

sag aftra merger dj am bully bohemian rhapsody bohemian rhapsody spike lee carson daly

Hillary Clinton drops hint that Al Qaeda was behind Libya attack

Secretary of State Hillary Rodham Clinton on Wednesday suggested a link between Al Qaeda and the Sept. 11 attack on the US consulate in Benghazi, Libya, going further than other Obama administration officials have previously in asserting that the deadly attack involved terrorists.

Speaking at a special United Nations meeting on instability in the Sahel ? the African region that includes Mali, where Islamist extremists control the north of the country ? Secretary Clinton cited the Libya attack as an example of the kind of action the region?s growing extremist groups are carrying out.

"What is happening inside Mali is augmented by the rising threat from violent extremism across the region,? Clinton said, adding that groups including Al Qaeda in the Islamic Maghreb have launched attacks from northern Mali into neighboring countries. These same groups, she added, ?are working with other violent extremists to undermine the democratic transitions underway in North Africa, as we tragically saw in Benghazi.?

RECOMMENDED: Six reasons this UN General Assembly is must-see TV

The White House last week said it was ?self-evident? that the Benghazi attack was ?terrorism,? but Republican critics have said the administration for too long attributed the attack to a spontaneous and unorganized mob. The firebombing of the poorly secured consulate resulted in the death of four US diplomats, including the US ambassador to Libya, Chris Stevens.

The head of the US National Counterterrorism Center, Matthew Olsen, also said in congressional testimony last week that the attack was ?terrorism,? and he cited Al Qaeda. But he said only that information suggested individuals involved in the attack might have had some level of contact with Al Qaeda and its affiliates ? in particular, Al Qaeda in the Islamic Maghreb (AQIM).

In his speech to the UN General Assembly Tuesday, President Obama said the attack on Benghazi was an attack ?on America," and he said the US would be ?relentless in tracking down the killers and bringing them to justice," but he provided no insight into who the killers were.

In her comments Wednesday, Clinton said the US is working with a number of countries including Libya to find the perpetrators of the attack, while also ?stepping up our counterterrorism efforts across the Maghreb and Sahel.?

Some intelligence specialists have suggested that the attack could have been the work of Ansar al-Sharia, a Libyan jihadist group. During the chaotic period following Libya?s revolution, the group could have had access to the heavier arms used in the consulate attack.

Libya?s president, Mohamed Magariaf, has insisted that the attack was the work of AQIM. The Al Qaeda affiliate originated in Algeria, but intelligence officials say it has been expanding eastward and southward as instability has seized North Africa and the Sahel.

Clinton made clear in her remarks Wednesday that US concerns about the spread of Islamist extremism in the region predate the Benghazi attack.

The US, she said, is ?expanding our counterterrorism partnerships to help countries meet their own growing threats.? She added that the US is ?taking aim at the support structure of Al Qaeda and its affiliates ? closing safe havens, cutting off finances, countering their ideology and denying them recruits.?

RECOMMENDED: Six reasons this UN General Assembly is must-see TV

Related stories

Read this story at csmonitor.com

Become a part of the Monitor community

Source: http://news.yahoo.com/hillary-clinton-drops-strong-hint-al-qaeda-behind-225651180.html

martin scorsese sacha baron cohen best picture nominees 2012 academy awards 2012 albert nobbs a star is born oscar nominees

Emma Watson: 'I've Had Bad Relationships' ? Showbiz Spy ...

Emma Watson: ?I?ve Had Bad Relationships?

Posted by Adam

Sunday September 23, 2012

EMMA Watson admits she has had bad relationships.

The British actress ? who?s dating student Will Adamowicz ? used to believe love was ?pain?, but had a ?revelation? that relationships could be happy.

?When I started dating, I had this kind of Romeo and Juliet, fateful, romantic idea about love,? she said. ?It was almost that you were a victim ? that there was a lot of pain involved and that was how it should be.

?Shakespeare said the course of true love never did run smooth and I had a sense it had to be painful. It was such a revelation to realize it shouldn?t be that way and you get to choose who you love and who you give your heart to.

?It sounds like a cliche but I also learned that you?re not going to fall for the right person until you love? yourself and feel good about how you are.

?The sad thing is you only learn from experience, so as much as someone can tell you things, you have to go out there and make your own mistakes in order to learn.

It?s difficult on my dating life. Anyone I get photographed with is automatically my boyfriend. So it makes it look as if I?ve had, like, 6000 boyfriends.?

Tags: emma watson

Source: http://www.showbizspy.com/article/252102/emma-watson-ive-had-bad-relationships.html

chuck series finale welcome back kotter 2001 a space odyssey barefoot bandit polar bear plunge lovelace antioch