19- Apr2018
Posted By: DPadmin

Get the most using this SEO guide for small businesses

There is much you will need to do in order to attain satisfactory search engine results and SEO is the way to go.

Whilst most of us tend to relate SEO to big businesses, this is not the case as small businesses also have a portion in the SEO marketplace. If you run a small or local business, there is much you will need to do in order to attain satisfactory search engine results and SEO is the way to go.

The ultimate SEO guide for small business

Yes, we know for sure that no one would wish to start a business that doesn’t grow. In this case, taking care of your SEO is vital in ensuring that your business remains relevantly visible to search engines. This is critical in the sense that it enables your customers to easily find you; hence, improved viewership.

The fact that local page search results on Google are constantly growing and getting better, it is obvious that this topic is long from over. But meanwhile, let us have a look at this ultimate SEO guide for local and small businesses by downloading a free SEO Report PDF.  Let us now follow the steps below to fully understand this:

Accessing your niche

The first step is basically having a good understanding of what your business is all about. Thus, deciding on a particular niche is critically important in relation to both local and small businesses. The moment you understand your niche, you can, therefore, focus on the things that make your service or products exclusive; hence, enhancing your chances of ranking highly for the same.

In the event that you have a highly comprehensive niche, then you have all the reasons to compete regionally with large nationwide brands – regardless of their well-established financial advertising budgets.  The idea here is that you must know your target customers and the terms they use to search for your services or products. This is simply because; they are going to use the same phrases to access your site. These phrases come in handy when it comes to the optimization of your local business SEO by simply adjusting them to long-tail keywords and making them as relevant as possible.

Low-cost branding

This isn’t new as we have mentioned it quite a number of times – for a successful SEO.  Branding must be well taken care of. Well, by mentioning the term branding, we refer to the things such as your tagline and logo. Are they relevant to your business? What do they reveal regarding your values and skills? It all concerns your identification!

Begin by creating stellar content

If you want you to significantly boost your small business SEO, then getting the correct content is necessary. While quite a good number of small business owners may tend to place their products along with their addresses on their sites and leaving them at that, there is actually much to explain and share.

Concentrating on creating an appealing first-impression on your customers is very important in this course. You will need to create stellar content regarding your company, its objectives and how superior you think your services or products are among other related info. You may also choose to talk about market developments or any other dealings relevant to your business.

The trick here is that you must be very realistic regarding the chances of the content you are creating ranking in search results. In case you are operating in a market that is quite competitive, then your content may be perfectly used both as a marketing tool and as social media input even though it may not be enough to move you to the top spot in Google, but it is good.  Just be sure to be in control of your anticipations.

Share your piece on social networks

Even though it is possible to trade your services or goods through social media networks; often, it is considered a good practice making use of the social media platforms for brand advertisement or for redirecting customers to your site for a purchase. As such, social media will help to promote your niche, business as well as your products in order to determine your image and obtain the correct customers to your business’ website. If correctly utilized, social media can greatly boost small business SEO.

Just as we have mentioned above, there are actually several things you may do to help improve your small business SEO. Concentrating on your particular niche and highlighting your exclusivity is basically your starting point. In any given business, gaining visibility is very important and that is actually the work of SEO.

Source: Get the most using this SEO guide for small businesses

26- Sep2017
Posted By: DPadmin

How Your Small Company Can Compete Against Big Brands in PPC

Think the PPC playing field is too uneven to compete? Wrong. Small companies absolutely can compete against big brands. Find out how here.

It isn’t easy to compete against big brand advertisers in PPC. They have deep pockets, large in-house marketing teams, and contracts with high-priced ad agencies.

As a smaller competitor, you might conclude that the advertising playing field is simply too uneven to compete.

While you may not be in a position to buy full page print ads in national newspapers or produce commercials for TV, pay-per-click (PPC) marketing is a channel that still allows small advertisers to play on the same field – if they know how.

In this article, I’ll give you some tips on how to compete against big brands in paid search – using one anonymous advertiser as an example.

1. Monitor the Competition

In the face of overwhelming competition, the tendency is to ignore what your competitors are doing and strike your own path.

Although you won’t necessarily want to go head-to-head with them, you should still have an awareness of what they’re up to, especially in terms of their online promotions.

Let’s take a look at the following example:

Competing Against Big-Brand Advertisers in PPC

As you can see, this search returned four ads. The top ad is for our anonymous garage storage system company, which we’ll call “Small Garage Co.” for simplicity.

The remaining ads are for big brands competitors: California Closets, Lowes, and Home Depot.

From these ads, we see that California Closets is featuring 20 percent off selected finishes. Home Depot is offering 30 percent off its storage solutions.

Judging from its ad, Small Garage Co. isn’t running any promotions. But in fact it is! When you click on the ad and visit its site, we learn that it’s running a summer promotion of $250 off garage cabinets and flooring!

Why isn’t this information included in the ad? Especially when their competitors are running promotions?

This isn’t to say that Small Garage Co. has to match the big brands on discounts or promotions. Ideally, it should offer something. But to do that it needs to know what its competitors are doing and strategize accordingly.

Higher prices and less attractive promotions aren’t necessarily a deal breaker, especially if you’re offering higher quality or better support. A good portion of the market will be willing to pay a higher price to get what they want.

2. Improve Your Messaging

The above example illustrated the importance of monitoring competitors and communicating promotions. Now, let’s take this point further.

Take a closer look at the “Small Garage Co.” ad:

Competing Against Big-Brand Advertisers in PPC

Has the company used its ad real estate wisely? They state that they’re “experts” and “committed to quality.” But in my opinion, that doesn’t carry much weight. (Especially when it’s the company describing itself. It does carry weight when someone else describes the company in those terms.)

They state they have “10+ years of experience.” Again, this might not count for much when competing against well-known brands.

They repeat “garage storage” and “garage flooring” multiple times in the headline, body copy and sitelinks, which is a little redundant.

And their “About Us” and “Contact Us” sitelinks are another wasted opportunity.

What could they have done instead?

They could have communicated their competitive advantages over big box retailers.

By visiting the company’s website, you’ll find many of these advantages, including:

  • They’re a local company (i.e., local to my location near Boston). Many people prefer to support local companies rather than big national retailers.
  • They specialize in garage flooring and storage systems. They don’t offer unrelated services, such as bathroom renovations or heating system replacements.
  • Their products have a lifetime guarantee!
  • They provide a free onsite consultation to measure your space and give recommendations.
  • Installation is done by the company itself. They don’t subcontract the work out.
  • They offer additional garage-related services, such as garage painting, onsite storage units (to store your things during install) and garage lighting.

But unless you clicked on the ad and dig into the company’s site, you would never know these things!

This may seem like a lot of messaging to stuff into one ad. But I’m confident that a skilled PPC team could do it by making smart use of all ad elements, including headline, body, sitelinks, callouts, and structured snippets.

3. Work With a Skilled PPC Ad Agency

Getting the right messaging to compete against big brands isn’t easy. You have to:

  • Know what your competitors are doing.
  • Understand your competitive advantages.
  • Be able to communicate those differences in your ad messaging.
  • Monitor your data and test like crazy to make sure it’s working.

In most cases, I don’t think it’s reasonable to expect a smaller company – especially a company with no in-house marketing team or maybe a team of one or two people – to compete against big brands with high-end digital advertising agencies on their side.

This is especially true with PPC advertising. PPC is in a constant state of change. Strategies and tactics that worked well last year may not work well today.

Lessons learned in different markets or industries may no longer apply. In addition, advertising platforms, such as AdWords, change rapidly too.

You may not have the budget to bring in a big-league advertising agency. But you may have the budget to bring in a smaller PPC agency or specialist and collaborate with them closely. By working together, you may uncover little tricks and tips that give you an edge.

For example, we worked with a client that sells their products both directly and through big retailers. When given a choice, many customers prefer to purchase directly from the company because they know they are experts in their products. (Companies usually prefer this arrangement as well because it cuts out the “big box” middle man.)

Working together, we came up with the idea of using the headline “[Company Name] – Official Site.” At first, I thought this headline too boring to garner many clicks. But to my surprise, the technique worked really well for this client and drove more sales.

This is exactly the kind of little gem that a PPC pro can help you uncover.

4. Give Your Small Website a Big Brand Feel

I can’t stress this point enough. If you want to compete with big brands, your website needs to have the look and feel of a big brand.

You don’t need to deceive anyone. But you are trying to inspire confidence. And to inspire confidence, your site needs to be modern, mobile-friendly, functional, and look good.

If your site hasn’t been updated in some years, now’s the time to do it. And then keep doing it!

Put website updates and redesigns into your budget and keep them there. Today’s top website design will need to be updated in a few years as aesthetic preferences and functions change.

Even if you write a killer ad that draws clicks, you’ll lose conversions – big time – if your site doesn’t build trust. If it sews a seed of doubt, “Who are these guys?” “How big is this company?” “Do they know what they’re doing?” you’ll lose the sale.

In fact, you need to make sure your site has a big brand feel before getting into PPC advertising – even if that means foregoing PPC entirely for a period of time. Yes, you heard me right!

You Can Play With the Big Brands!

I hope I’ve convinced you that your company can compete against big brand PPC advertisers. You simply need to keep an eye on the competition, communicate your competitive advantages (preferably working with a PPC pro), and build a website that inspires confidence.

It all comes down to knowing your market, products and customers — and then finding an edge you can leverage.

Source: How Your Small Company Can Compete Against Big Brands in PPC

12- Sep2017
Posted By: DPadmin

A Guide to Using SEO Effectively for Your Small Business

Improve your ranking with help of these small business SEO techniques and strategies. Drive traffic and enjoy your success!

A Guide to Using SEO Effectively for Your Small Business

Companies providing SEO services today get really popular because of the increased online competition. Businesses are fighting for each potential customer and get as much traffic as possible. Whether you’re a successful online writing agency, such as ukessaynow.com, or an owner of a small online store selling watches, you need to take care of your online presence and search engine optimization in order to survive the competition.
Of course, if you want to get the most effective results, hiring a professional service or at least a freelancer with experience in SEO is a better idea. However, we all know that being a small business owner usually means being limited in budget. That’s why we’ve come up with a few simple but working tips you can start following yourself before or instead of addressing a professional.

Google and Research

The word “Google” is now known not only as a name of the leading search engine on the Web but also as a synonym for the verb “to search”. It’s obviously a good idea to start dealing with SEO by researching what is in trend and who your competitors are in Google. However, don’t make a mistake by limiting yourself only with this search engine. Research Yahoo and Bing too or you risk missing some growth opportunities. Also, when doing your research, take into account where your target audience comes from. In Russia and Asia, there are other search engines you might even have never heard of.

Take care of your presence everywhere

If your target market is the USA, there are dozens of ways to get a local prominence and make people search for your business online.

  • Social media
    People search things not only in Google or Yahoo but also on Facebook, Twitter, Instagram, and other social networking platforms. They have become an important component of all effective SEO strategies. So, if you want to stay up-to-date and build your reputation correctly, get an account on all those popular social media websites. However, don’t overdo here. You need to analyze where your target audience spends more time and focus on promoting on those platforms. For example, if Myspace is not where your customers are, you shouldn’t be there either.
    It’s not the end when you’re done with registration. The key to your success in social media is being active. No one cares about your Facebook account unless you start publishing interesting and useful content. This may include product releases, event advertisements, articles on general topics related to your niche, customer reviews or stories, news about your business and the industry in general, etc.
    Now, simply posting is still not enough. Your customers will soon get bored and unfollow you. A perfect solution is to stay in touch with them. Your followers will definitely enjoy the possibility to get in contact with you, so keep a live conversation going, reply to all comments, and involve people in discussions.
  • Yelp
    Yelp listings are being indexed by all major search engine companies. If you want people to know about you, you need to get into the listings. The profile of your business will contain all the details about it, contacts, photos, customer reviews. It’s not enough just to sign up. You need to take care of your profile just like you take care of your Facebook and Twitter accounts.
    First of all, it means your Yelp profile must look visually attractive so that people wouldn’t leave the page without giving some positive feedback for you. In case you didn’t get it yet, your Yelp ratings depend entirely on the reviews of your customers. So, make sure you have done everything to get a positive review.
    One excellent way to motivate your customers to leave positive feedback is to offer them a discount or give them something for free while they are at your place. You can go a traditional way and use paper flyers for that, or you can get modern and send messages and push notifications via your mobile app.
  • Quora
    Quora is a place where people seek answers to their questions. It’s a search engine for people who need expert opinions, meaning it can become a perfect place for you to engage with your target audience and promote your products or services. But to earn credibility, you need to show that you truly are an expert in your niche, not simply write promotional posts.
    Your SEO strategy for Quora may look like this:

– Search for questions within the area of your expertise.
– Plan your answer and think it over a couple of times to make sure you will offer value to the reader.
– Give valuable information and answer the question itself. Remember that Quora is not designed for “wordy” and “salesy” content.
– Add a bit of promotional style and link to the content on your website or social media profile that gives a more detailed answer to the question or offers a solution to the problem stated in the question.

  • YouTube
    The one platform you must surely have an account on is YouTube. They say seeing is believing, so getting visual with your audience is crucial for building trust. If you sell some products, there are dozens of things you can show to your customers, e.g. visual buying guides, product presentations, promo videos, tutorials on how to use your products, and much more. Put yourself into the shoes of your customer and ask yourself: would you rather read a tutorial or watch a video instead? It’s pretty obvious.
    One thing you should remember for good is that people don’t like being sold to. Yet, they like being educated and feeling appreciated. Therefore, be careful with posting videos that sell and focus on informative video content. Here are just a few more short YouTube recommendations:
    – Don’t make long and boring videos.
    – Take time to write good titles and descriptions.
    – Use tags, annotations, and links in your videos.
    Your YouTube channel will gain popularity if you create a reputation of someone who knows the industry they work in and provide the audience with relevant content.

A few Words to Conclude
Following these steps, you will optimize your online presence and enhance your visibility. If you’ve decided to do your SEO on your own, research as much as you can and educate yourself about it. There are many useful tools you can use online that will help you all the way. Good luck!

Source: A Guide to Using SEO Effectively for Your Small Business

11- Aug2017
Posted By: DPadmin

8 Things Every Business Needs To Know About SEO

Having an online presence in the present digital world is very important for any business. This is because the internet is currently considered as one of the reliable sources of income for businesses, individuals and organizations across the world. SEO is actually an aspect of business that is quite popular since brands are working harder to get ranked higher by search engine. It is therefore crucial to understand what exactly is involved so as to boost the ranking of your business in search engine listings.

The following 8 points will help you get a better understanding about SEO and how it can help you to promote your business brand.

1. SEO is not an expense, but an investment

There is a common misconception that SEO is an expense that needs a huge chunk of money to get started. This is however not the case. Provided you stick by search engine rules and do the right thing, you will be realized that SEO is not that expensive. Nevertheless, the returns on investing in SEO are so encouraging that you need to think about SEO as an expense.

In short, SEO means delivering the best quality content to your target audience using the right keywords that are searched frequently among several other digital marketing strategies.

SEO helps in creating brand awareness through enhanced brand presence and visibility as your website gets ranked better by search engines. In this case, more traffic is experienced when your website appears on the top three spots of the first page, which can be converted into loyal customers in the long run. This way, you will be able to make more sales. The long term returns from investing in SEO is much greater than the onetime expense incurred in getting your business website search engine optimized.

2. The keywords you choose make a huge difference: prioritize long-tail keywords

In order to achieve success in your SEO endeavors, choice of keywords is one of the most crucial considerations to make. Apart from using single words as keywords, it is now advisable to use three to four keyword phrases that are specific to whatever you are talking about.

Using these long-tail keywords will guarantee faster and more access by the target audience to your brand based on the exact value you provide to them. many brands are now keen on personalizing their search engine experience using these types of keywords. A good example is where one brand uses a keyword phrase like “New York Doctor” and another uses “New York Orthopedic Surgeon”; in the phrases, the second phrase tends to be more specific and for that reason can guarantee generation of more quality leads unlike the first one which puts the doctor in direct competition with other doctors in the area.

Learn more on how to build your business through content marketing and how to improve your content marketing strategy to always stay ahead of your competition.

3. On-site optimization: so that the website receives acceptance from both viewers and Google

Onsite optimization is not quite known by many people. However it is quite essential as it ensures a specific websites achieves acceptance by both viewers and search engines.

In order to achieve this, right keywords, website pages’ tags and key phrases need to be considered. These are necessary for search engines like Google to determine how to rank various websites. According to the 2015 Business Buyer’s Guide to SEO, a majority of business leads come from internet sources; referral traffic, direct advertising or online searches. In the case of online searches, search engines need to know the subject matter of your website for it to be recognized using the various web pages finding the topics covered and keywords used.

4. Social media is an essential part of any SEO campaign

Many business brands today are taking advantage of various social media platforms to promote their content. Such platforms as Facebook, Twitter and LinkedIn are commonly use to create a profile for brands.

It is crucial to consider using such platforms to boost online presence and promoting the content on your website. This way, you will not only be able to boost access to your brand products and services from your target audience, but also will boost search engine rankings. Use of a social media channel that is relevant or appropriate in your industry or niche will boost your business a great deal.

5. Fresh content is important: Content is the King

Long are gone days when quality of web content never mattered. Today, it is practically impossible to move your website to the top of search engine results without considering the quality of content published and the keywords used. Search engine algorithms are now smarter than before and you have to stick by the demands to get a better ranking. The quality of content is today considered as the ultimate and most crucial driving factor for top search engine listing.

You need to offer compelling content that even other websites will want to link with which also boosts further the performance of your website.

6. Off-site optimization: getting external links from other quality sites is key

This is basically the opposite of on-site SEO whereby you work on boosting search engine ranking by use of external methods. The more your website is considered as being “most authoritative” or “most important” the better it gets ranked.

The secret to achieving this is by enhancing the quality of content shared and keywords used. This way, other websites in the same industry or niche will tend to link to your website thus qualifying your site as an authoritative site. The more the links you get to your website, the higher it will get ranked by Google.

7. PPC has no effect on SEO

Many businesses are today inclined on to pay-per-click advertising because it is considered as one of the crucial parts of online marketing campaigns. However, this strategy has no direct effect on SEO listings! This is simply because SEO is concerned more by organic search results rather than the paid advertisements.

PPC is however worth the consideration especially during the launch of a website to attract more visitors to a website but not influencing search engines for better ranking.

8. Be aware of not indulging in black hat SEO

Due to a stiff competition in any industry, several businesses turn to various illegal techniques trying to get better search engine rankings. Though such techniques worked previously to some, it is no longer the case since search engine algorithms have become smarter over time. Using the techniques today amounts to breaking of Google’s rules of achieving top organic ranking.

You need to keep off from such techniques as;

· Using invisible texts

· Keyword stuffing

· Creating fake pages with the aim to get more back links

· Page swapping and

· Using doorway pages

Despite the fact that some websites used these illegal techniques some years ago, today, Google can easily get your website banned from organic ranking and this will be detrimental to your digital marketing campaign. Some people may boast of achieving higher ranking using the same techniques but the truth remains that the disadvantages of black hat SEO are too harsh you don’t wish to be associated with.


Any decision you make regarding SEO is crucial in determining the success or failure of your business. Employing the right techniques will enable you to achieve top rankings and enjoy the various advantages that come with it. Modern SEO is characterized by top quality content, quality back links and personalized long tail keyword phrases that are not spammed. This way, search engines are likely to find your content easily and ranking it higher than your competitors.

Source: 8 Things Every Business Needs To Know About SEO | HuffPost

10- Jul2017
Posted By: DPadmin

This script automates adding any AdWords data to a Google spreadsheet

If you’ve ever been frustrated at the amount of time you spend creating PPC reports, you’re not alone. Today, I’ll do my best to help you with a new AdWords script I just finished.

The severity of the reporting problem became very clear to me at a conference I recently attended. Attendees were asked to leave sticky notes describing the most timing-consuming aspects of their jobs. I know it’s not exactly a scientific study, but I found the results fascinating anyway. Here’s what the board looked like:

The orange arrows highlight each note that said “reporting” was the most time-consuming PPC task.

Meetings are another time-consuming task people added to the board several times — but I’m not going to help you fix that with a script, so let me focus on reporting, a topic I’ve covered several times in recent posts here.

When it comes to reporting, you should really try to produce something that gives the stakeholder the data and insights they need, but in such a way that you can easily repeat, and hopefully even automate it. There are plenty of tools that can help with that.

And while automating reports is a reasonable goal, the reality is that there will always be cases where the client wants just one extra piece of data. And because of Murphy’s Law, this will always the one thing your reporting tool doesn’t cover.

Why don’t reporting tools cover everything? By my last count, AdWords has 46 different types of reports available through their API, ranging from common ones like an account performance report to the more obscure, like the keywordless category report:

Reports available through the AdWords API. Screen shot from the Google Developers Site

In all likelihood, the vast majority of people care about just 10 percent of these reports, so engineering resources get assigned to supporting the most commonly requested reports. And even if a tool covers all 46 possible report types, it might not filter the data the way the client wants, or include some of the lesser used metrics, attributes or segments.

So, how do we get custom data from AdWords into virtually any reporting engine? Through a data connector. And one of the most popular places for marketers to store data is in a spreadsheet.

Google Sheets, just like AdWords, can be automated with App Scripts from Google. This means we can write some code to make the spreadsheet connect with a data source of our choosing. Combined with AdWords scripts, which have permission to access your AdWords data, we can create an automation that lets you specify a template for a report, and then automatically add the requested data on a predetermined schedule.

So, here we go! Let’s get you a free tool to put any AdWords data you want into a Google Spreadsheet.

Step 1: Set up the report template in Google Sheets

Copy this spreadsheet into your own Google Drive. This sheet will look very boring when you first load it, but there are about 600 lines of code in the “Script Editor” section where all the magic happens. This will also be moved to your Google Drive when you copy the script into your own account.

Notice that when the spreadsheet finishes loading, you’ll have a custom menu called “AdWords Data Grabber from Optmyzr.”

Select the type of report you’d like to run from this custom menu:

When you select a report type, the spreadsheet connects with AdWords to get the appropriate attributes, metrics and segments for the selected report. It automatically sets up drop-downs in the spreadsheet to let you choose which elements to include in the report and what filters to apply.

Go to the “Settings” tab and choose a date range for your report from the drop-down. Since the goal is to set this report on an automated schedule, the only options are relative date ranges.

Next, select any filters you want to apply to the data. A pretty common one would be to filter for items that have more than 0 impressions. This step is optional.

For things where AdWords expects you to choose from a set list of values, the spreadsheet will present you with a drop-down of valid choices, for example, for campaign status, you could choose “ENABLED.”

Now, go to the “Report” tab and select the data you want to include in each column. Once again, the spreadsheet will already be loaded with the available options for the report type you have selected.

Step 2: Install the AdWords script

Now to automate the data pulls, simply install the following AdWords script code into your account and set it on a reasonable schedule, like weekly or monthly.

// AdWords Script: Put Data From AdWords Report In Google Sheets
// ————————————————————–
// Copyright 2017 Optmyzr Inc., All Rights Reserved
// This script takes a Google spreadsheet as input. Based on the column headers, data filters, and date range specified
// on this sheet, it will generate different reports.
// The goal is to let users create custom automatic reports with AdWords data that they can then include in an automated reporting
// tool like the one offered by Optmyzr.
// For more PPC management tools, visit www.optmyzr.com
var DEBUG = 0; // set to 1 to get more details about what the script does while it runs; default = 0
var REPORT_SHEET_NAME = report; // the name of the tab where the report data should go
var SETTINGS_SHEET_NAME = settings; // the name of the tab where the filters and date range are specified
var SPREADSHEET_URL = https://docs.google.com/spreadsheets/d/1dttJTb547L81XYKdTQ56LcfO9hHhbb9wm06ZY5mKhEo/edit#gid=0; // The URL to the Google spreadsheet with your report template
var EMAIL_ADDRESSES = example@example.com; // Get notified by email at this address when a new report is ready
function main() {
var currentSetting = new Object();
currentSetting.ss = SPREADSHEET_URL;
// Read Settings Sheet
var settingsSheet = SpreadsheetApp.openByUrl(currentSetting.ss).getSheetByName(SETTINGS_SHEET_NAME);
var rows = settingsSheet.getDataRange();
var numRows = rows.getNumRows();
var numCols = rows.getNumColumns();
var values = rows.getValues();
var numSettingsRows = numRows 1;
var sortString = ;
var filters = new Array();
for(var i = 0; i < numRows; i++) {
var row = values[i];
var settingName = row[0];
var settingOperator = row[1];
var settingValue = row[2];
var dataType = row[3];
debug(settingName + + settingOperator + + settingValue);
if(settingName.toLowerCase().indexOf(report type) != 1) {
var reportType = settingValue;
} else if(settingName.toLowerCase().indexOf(date range) != 1) {
var dateRange = settingValue;
} else if(settingName.toLowerCase().indexOf(sort order) != 1) {
var sortDirection = dataType || DESC;
if(settingValue) var sortString = ORDER BY + settingValue + + sortDirection;
var sortColumnIndex = 1;
}else {
if(settingOperator && settingValue) {
if(dataType.toLowerCase().indexOf(long) != 1 || dataType.toLowerCase().indexOf(double) != 1 || dataType.toLowerCase().indexOf(money) != 1 || dataType.toLowerCase().indexOf(integer) != 1) {
var filter = settingName + + settingOperator + + settingValue;
} else {
if(settingValue.indexOf() != 1) {
var filter = settingName + + settingOperator + + settingValue + ;
} else if(settingValue.indexOf() != 1) {
var filter = settingName + + settingOperator + + settingValue + ;
} else {
var filter = settingName + + settingOperator + + settingValue + ;
debug(filter: + filter)
// Process the report sheet and fill in the data
var reportSheet = SpreadsheetApp.openByUrl(currentSetting.ss).getSheetByName(REPORT_SHEET_NAME);
var rows = reportSheet.getDataRange();
var numRows = rows.getNumRows();
var numCols = rows.getNumColumns();
var values = rows.getValues();
var numSettingsRows = numRows 1;
// Read Header Row and match names to settings
var headerNames = new Array();
var row = values[0];
for(var i = 0; i < numCols; i++) {
var value = row[i];
if(reportType.toLowerCase().indexOf(performance) != 1) {
var dateString = DURING + dateRange;
} else {
var dateString = ;
if(filters.length) {
var query = SELECT + headerNames.join(,) + FROM + reportType + WHERE + filters.join( AND ) + dateString + + sortString;
} else {
var query = SELECT + headerNames.join(,) + FROM + reportType + dateString + + sortString;
var report = AdWordsApp.report(query);
try {
var subject = Your + reportType + for + dateRange + for + AdWordsApp.currentAccount().getName() + is ready;
var body = currentSetting.ss<br>You can now add this data to <a href=’https://www.optmyzr.com’>Optmyzr</a> or another reporting system.;
MailApp.sendEmail(EMAIL_ADDRESSES, subject, body);
Logger.log(Your report is ready at + currentSetting.ss);
Logger.log(You can include this in your scheduled Optmyzr reports or another reporting tool.);
} catch (e) {
debug(error: + e);
function debug(text) {
if(DEBUG) Logger.log(text);

In this code, edit lines 17 through 22 with your preferences. The most critical field to update is the one with the URL of the Google spreadsheet we created and modified above.

Now you can preview the script; if your settings are fine, you should see a success message similar to this one:

Your spreadsheet should then contain the requested data and could look something like this:

Note: There are many metrics that cannot be combined in reports, for example, conversion type name cannot be reported at the same type as clicks in the campaign report. Checking for this before attempting to populate the report is tricky, so the script will return an error about your error.

When this happens, simply update the headers in the “Report” tab of the spreadsheet and run the script again until all errors are cleared.

Including the data in a report

You can use the data as-is in Google Sheets, but you can also include it in automatic scheduled reports. In Optmyzr, you would add a reporting widget that points to the URL of the spreadsheet. The tool then pulls in that data and includes it in the report, using the same styling as the native Optmyzr widgets. Your client won’t be able to tell the difference, and you’ll look like a hero for delivering the custom data they want on an automatic schedule.


PPC reporting takes a ton of time. And because clients invariably have some custom requests for their reports, reporting tools often need some custom integrations to deliver the goods. This AdWords script, together with the Google Apps Script in the spreadsheet, lets you bring custom data from AdWords directly into most reporting engines where you can now automate one more thing.

I hope this script helps you get back a little bit of time to do other things. And if you’re anything like the people who left the sticky notes on the board, I hope you’ll enjoy that next meeting!

Source: This script automates adding any AdWords data to a Google spreadsheet

29- Jun2017
Posted By: DPadmin

Don’t Be Fooled by These 9 SEO Lies

We love SEO. And we think it’s hugely important for succeeding in the modern business world. But we also know that there’s a lot of SEO misinformation out there. Sometimes it’s good information that’s old. Sometimes it’s misleading. And sometimes it’s an outright lie from an SEO “expert.”

We love SEO. And we think it’s hugely important for succeeding in the modern business world.

But there’s a lot of SEO misinformation out there. Sometimes it’s good information that’s old. Sometimes it’s misleading. And sometimes it’s an outright lie from an SEO “expert.”

These nine SEO lies might catch you, but don’t be fooled.

1. “I can guarantee you the No. 1 spot.”

This is a big one. Everyone wants to be ranked No. 1. Research has shown that the first link on a results page can get around 30 percent of the traffic for a given search, and that’s massive. Moving from No. 2 to No. 1 could mean a significant increase in visitors.

Similarly, getting onto the first page of Google results can mean a big improvement in how much traffic your site gets via search. The first page gets over 90 percent of clicks. Page two gets a dismal 5 percent.

So getting on the first page is crucial. And a No. 1 spot is extremely valuable.


In their excitement to be ranked No. 1, many people will be taken in by this lie. The reason it’s a lie is simple: because no one can guarantee a No. 1 spot. There are millions of websites out there competing for billions of keywords. New websites are founded every day. Companies change their SEO strategies. Google changes its search algorithms.

There are just too many factors to be able to guarantee the first spot on a results page. Especially on short-tail keywords that have a huge amount of competition. A guarantee of improving your rankings? Sure, that’s fine.

A guarantee of the first page? Maybe. But if someone guarantees you the No. 1 spot, you should run the other way.

There’s a chance that they’re right, especially with long-tail keywords. But there’s also a chance that they’ll either be using black-hat techniques that will get you penalized or they’re overselling their services. Both of which you want to avoid.

2. “SEO is really complicated.”

You might be surprised that this is the second lie on our list. Why would our company exist, and why would a professional SEO be such a huge industry if it wasn’t highly complex? The answer is two-fold.

First, improving your search rankings is – at least in general – pretty simple. There are certain things that Google places a lot of weight on when it’s determining search rankings. Things like usefulness, backlink profile and authority.

Getting all of those things figured out and prioritized isn’t always easy. It takes a lot of experience to understand how to go about the process efficiently.

But if you focus on making your website as useful, easy-to-use and authoritative as possible, you’ve already done a lot of the hard work.

Second, effective SEO takes a lot of time. And not just over the course of a few months or a year. It needs a lot of work over the lifetime of your website. You need to keep track of constant updates, your own content, technical improvements, backlink outreach, your competition and a host of other things.

So as you might imagine, SEO is hard. It’s not super complicated (at least until you get into the extremely fine details), but it takes a lot of work. And if you don’t know how to best apportion your time and effort, you’ll end up wasting both.

That’s where a good SEO expert comes in. They’ll tell you where your efforts are going to get the most return, because they’ve done it before and they stay up on the latest trends.

In short, SEO isn’t complicated. But that doesn’t mean it’s easy.

3. “Social isn’t important for SEO.”

The role of social media in SEO is disputed. Back in 2014, Matt Cutts stated that social signals don’t factor into Google’s rankings. But many SEO experts maintain that those signals do, in fact, affect rankings. There’s been a lot of back and forth.

Let’s consider it from two angles.

Let’s say that social signals, like your follower count and social authority, don’t affect your SEO. If that’s the case, should you still be investing in social media marketing and spending time connecting to people on Twitter and Facebook?



Because it’s not just the effect of links and shares that you’re after. It’s about people and sharing your content with the people who need it. The more people you can help out with the information you provide, the better your site will perform. People will share your content, link to your pages, revisit your site and turn into leads.

Okay, now let’s look at the other possible side of the coin: Let’s say that social signals and links do factor into the Google algorithms. In that case, it’s obvious that you should be spending time promoting your work on social networks.

Links, comments, follows, shares, and every other metric that you usually use to measure your social efficacy will then become directly related to SEO.

Either way, you win.

4. “Having tons of links improves your rank.”

Whether someone’s talking about inbound or outbound links, external or internal, this statement isn’t flat-out wrong, it’s misleading. The number of links you get to your page is important (which is why Brian Dean says that link building is the most important skill in SEO).

What’s more important, however, is where those links are coming from. A link from a high-authority site like Mashable, Moz, AdAge or Wired is going to be very valuable to your SEO efforts for that particular page.

Similarly, linking from your page to high-quality external websites will show Google that your page contains good information and help it figure out exactly what your page is about.

One link from a high-authority domain to your page could provide a big boost, whereas lots of links from low-quality sites might not do anything. In fact, it could even hurt your rankings.

If an SEO firm tells you that you need tons of links, be wary. They may engage in link buying or other nefarious means to get lots of links to your site. And that can result in penalties.

Having many links is good. But only if you have the right kind of links.

5. “It’s all about keywords.”

In the past, keywords were the main focus of SEO. You had to have the right keywords on the right pages, and that was about it. But search engines have become significantly more complex over the past decade or so.

Google now takes around 200 factors into account to determine rankings. And while keywords are still important, there’s a lot more that goes into it (though Search Engine Journal posits that four of those factors stand out above the rest).

Domain age, titles and H1 tags, semantically related keywords, page-loading speed, recency of updates, outbound links, reading level, bullets and lists and even the fact that you have a contact page may affect your rankings.

So while keywords will certainly be an important part of your SEO strategy, there are tons of other factors you need to take into account. And an SEO firm or consultant that’s up to date on how SEO works today will know that.

Be sure to ask about the different tactics that your SEO provider will use to help you improve your rankings. If they place a strong emphasis on keyword density, latent semantic indexing and other keyword-related practices, be a bit wary.

6. “You need a lot of content.”

Let’s get one thing straight right away: Having a lot of content is a good thing. And it will absolutely help your SEO. But it’s not the only way to use content to improve your search engine rankings.

Brian Dean at Backlinko, for example, has less than 40 blog posts on his site. But he’s one of the foremost SEO experts in the world, and his site is insanely popular. How is he able to get this much visibility and SEO with what amounts to a handful of posts?

By writing really great stuff.

Each of Dean’s posts is several thousand words long, contains extremely useful advice and is full of images that help make the content clear to the reader. They’re focused on topics that people want to read about, they’re highly actionable, and they’re very easy to read. Dean also writes in a style that makes it almost impossible to stop reading.

This type of valuable content has gotten Dean a tremendous number of backlinks, guest posts, social shares, comments and other things that boost his SEO.

There’s a key lesson here: Don’t write content to improve your SEO. Write content that’s going to help people. If you’re helping people solve their problems, you’re going to rank well.

It’s that simple.

7. “Our strategy is the best.”

This is only a half-lie. Your provider might believe that their approach to SEO is the best that there is. But this should make you a bit skeptical. First of all, search algorithms are changing constantly, and one of the best qualities an SEO provider can have is that they read a lot and adapt quickly.

Second, the best strategy for SEO largely depends on your industry. Some industries are amenable to Brian-Dean-style 5,000-word posts. Other industries are more interested in 500-word quick tips or company updates.

Your own customers might be more or less interested in a specific type of content, and your SEO provider needs to be open to that possibility as well.

And because there are so many different parts of successful SEO, it’s possible that one company may focus on one thing – link building, say –while a different company focuses on another, like keyword optimization or social.

Every company has a strategy, and most will likely have a slightly different focus from others. That doesn’t mean that one is better than another. It just means that they prioritize different methods of SEO.

Of course, providers are likely to think that their method is the best one. But if they’re brash about it and aren’t open to the possibility of adapting their tactics to your niche, you should be worried.

8. “You should be concerned about Google updates.”

SEO changes all the time. All of the major search engines update their algorithms on a regular basis, and this can have big effects on your rankings. Most updates are very small and we don’t even hear about them.

But some updates are significant and can put a big dent in your traffic (or, if your content is deemed good by the new standards, gives it a boost). If you see a big drop in your search traffic, you should probably take steps to rectify whatever you’ve been penalized for.

Usually, these penalties are from low-quality content. Lots of suspicious-looking links, too many ads, unhelpful articles and so on. In short, they’re things you probably shouldn’t have done in the first place. And you’ll need to take care of that.

But Google updates shouldn’t be a primary concern of your SEO. If you’re engaging in practices that could get you penalized by a future update, you’re doing it wrong. You should be focused on providing maximum value to your visitors, and that’s it.

If you do that, you won’t need to worry about updates, because that’s what Google has always put above everything else: content that’s informative, authoritative, and helpful to readers.

9. “SEO is all you need.”

It’s understandable that an SEO provider might feel this way. And yes, SEO is a big deal; it can make or break your site. But as I’ve mentioned a number of times before, useful content is the core of SEO. And if you’re providing value, you’re going to need a wider focus.

Again, this may depend on your niche. Many companies are able to provide a lot of value to their readers by establishing a solid social media presence. Others curate content in a newsletter. Still others create veritable knowledge databases on their blogs. The way you provide value to your readers will depend on your field.

And that means you’ll need to adapt both your SEO and online non-SEO activities. Maybe you need to focus on content creation. Or up your promotion game. You might need to focus on public relations, or social engagement, or even door-to-door sales.

Almost every business is going to need to use a wide range of tactics to get the customers and sales they need to survive in a competitive market. SEO should definitely be a part of that.

But don’t let anyone tell you that it’s the be-all-and-end-all of business success.

Source: Don’t Be Fooled by These 9 SEO Lies

29- Jun2017
Posted By: DPadmin

Going Local for 2017: Local Search Engine Marketing Strategy

If you know anything about SEO marketing strategies, then you probably know that they’re incredibly fickle. Just as soon as one “best practices” article appears online telling you how to make the most of the latest update, there’s another algorithm ready to go in and mess everything up again.

There are many different strands of SEO to consider, and one that’s often under-estimated is local SEO. As the name might suggest, local SEO is all about appealing to customers in your general area. Perfect for small businesses and brick-and-mortar companies with an online presence, local SEO helps you pinpoint your customers when they need you most – for instance, when they’re searching for somewhere to go for dinner, or a nearby place to buy shoes. After all:

Across the globe, local competition in the digital sphere is heating up, and it’s crucial for businesses to learn how they can improve their search efforts if they want to get ahead of the game this year. Fortunately, there are plenty of ways to do this, from refining your content, to taking social media measures. In this article, we’ll be looking at some of the most-up-to-date, and timeless tips you can follow to enhance your Local SEO marketing strategy.

Tip 1: Your Title and Meta Description Tags are Still Important

Meta description and title tags are elements of HTML that can be customized to outline the content of a webpage. In other words, it’s like a mini-advertisement, a taster of what your consumer can expect when they click onto your page.

Not so long ago, Google increased the width of the primary search engine results area, which meant that description and title tags were able to get a little bit longer. However, keeping things short and simple is often the best way to go.

image: http://cdn2.business2community.com/wp-content/uploads/2017/06/pasted-image-0-8-600×294.png

Take advantage of the space that you have, but use it wisely. Make sure that you double-check to ensure that you’re hitting keywords, and that your titles aren’t getting cut off in the search results. If you’re not sure how your tags are going to look in action, you can use emulators like the Yoast SEO Plugin for extra help.

Tip 2: Use the Local Schema Markup

Local schema markups are basically structured pieces of data that inform search engines of what your business does, and where it does it. These markups are only used by around 31.3% of websites, but when accessed in your marketing strategy, they can be a great way to make your business stand out, and even ensure that you rank higher than your competitors.

Google wants you to make the most of schema markups because it helps their bots to crawl through your website and find out what you’re all about. That’s why they’ve introduced their very own “Structured Data Testing Tool” which will help you to pinpoint errors in your data.

image: http://cdn.business2community.com/wp-content/uploads/2017/06/pasted-image-0-1-1.png

Correctly using a schema markup can raise your local ranking by several positions -yet most businesses still don’t do it. That’s great news for you – since you can take advantage of the benefits other companies in your niche are missing out on.

Tip 3: Optimize “Google my Business”

Google estimates that around 4 in 5 consumers use search engines to conduct their local searches. However, despite this, many small businesses have never claimed a single listing online – which means they’re missing out on some serious opportunities for growth.

One of the most important listings you can organize today is your “Google my Business.” This listing influences search engine users, and some studies show that users who view a complete listing are 30% more likely to visit a store.

If you’re looking for SEO rankings, then it’s worth knowing that Google likes to keep things in-house. In other words, it prefers its own business listings when giving local results to users. Additionally, if you want to make sure that you show up for the most relevant search results in your niche, then you’ll need to optimize your listing, hopefully with a lot of great reviews.

image: http://cdn2.business2community.com/wp-content/uploads/2017/06/pasted-image-0-2-1.png



Webcast, July 6th: Advanced SEO Site Auditing

Tip 4: Publish Plenty of Locally Optimized Content

When you need information, where do you go?

Once upon a time, the answer might have been “a phonebook”, or “a library”, but today, nine times out of ten, you’ll get your information from the internet. Businesses can boost their presence online by providing content that’s connected not only to their business and niche, but their local area too. For instance, it’s the difference between writing a blog called “How to Find Great Shoes”, and “How to Find Great Shoes in New York”.

Since search engines prefer fresh content, it’s a good idea to use your blog to post plenty of copy answering questions that people might have in your industry. Make sure to include your keywords in the title, tags, and headlines consistently, and organically. At the same time, you can expand your content marketing strategy efforts by sharing locally-optimized pieces on social media too.

image: http://cdn.business2community.com/wp-content/uploads/2017/06/pasted-image-0-3-1-600×398.png


Tip 5: Build an Appropriate Link Strategy

Links that span outwards from your company’s website to other websites, and vice versa, are essential to your business marketing strategy. These links help to indicate the authority and credibility of your business to Google, so that it knows where it should rank you. Links are great, but if you try to game the system and fill your pages full of them, you’re just going to end up damaging your reputation in the long-run.

Instead, you need to focus on building strong, reputable links with local companies, brands, and communities. For instance:

  • You could share links on social media to stories from local publications that are relevant to your industry
  • Include links to your website in your email newsletters, and the updates you post for customers
  • Sponsor or host local events that allow you to link out to neighborhood businesses, or ask for guest-spots posting on their blogs

Perhaps the most important part of building an authentic link strategy is to make sure it’s authentic. Ensure you know exactly who you’re linking to, and that the people you connect with are relevant to your business. Also, make sure that you don’t venture out to third-party content providers who claim they can fill your content full of SEO-boosting links. Trust me when I say this could have a disastrous impact on your reputation.

image: http://cdn2.business2community.com/wp-content/uploads/2017/06/pasted-image-0-4-1-600×343.png


Tip 6: Post more Customer Reviews Where They Matter Most

According to recent surveys, around 84% of people trust online reviews just as much as a personal recommendation. In other words, if someone isn’t sure whether they should buy your product, they’ll go elsewhere for advice on what to do.

Google has put a great deal of emphasis on customer reviews lately, showing snippets on the search engine results page with bright golden stars designed to draw attention to your business. Getting those reviews to show up in relation to your business is one of the best ways you can boost your business trust levels, and enhance click-through rates.

The best way to increase your chances of getting great reviews for your company is to offer incredible products or services, and simply ask your customers for what you need. Some people will be so impressed by your product that they’ll be happy to write a testimonial for you without any prompting, whereas others might need the promise of a future discount to get their fingers twitching.

Either way, by adding positive customer reviews to your local SEO marketing strategy, you’re giving people close to your business the information they need, when they need it most. If someone passes your store and wonders whether you’re trustworthy, or worth their money, then all they need to do is look at those golden stars.

Building Local SEO

Obviously, building your local presence is only one aspect of a killer marketing campaign, but it’s one of the best ways to combine your offline and online advertising efforts for more traffic and more customers. If you can give your customers the information they need to find your store, and then offer an incredible experience that links back to your brand, you’ll be on your way to a profit-generating reputation in no time.

Source: Going Local for 2017: Local Search Engine Marketing Strategy

27- Jun2017
Posted By: DPadmin

4 Key Things Small Businesses Should Do to Remain Search Optimized at All Times

With various tactics for quick SEO success, it’s important that businesses stay focused on what works in the long-run.
4 Key Things Small Businesses Should Do to Remain Search Optimized at All Times

Image credit: Twin Design / Shutterstock.com

Source: 4 Key Things Small Businesses Should Do to Remain Search Optimized at All Times

07- Sep2016
Posted By: Guardian Owl

Social Media: A Power Tool In The SEO Toolbox | Dynamic Business – Small Business Advice – Forums | Dynamic Business Australia

For the longest time, many people in the SEO community treated social media and SEO as though they were mutually exclusive. Others made the mistake of conflating the two as one and the same. The truth is: SEO and social media can and should work in tandem as two interconnected cogs in the same machine.

For social media success, brands need top notch content and a strong, compelling brand presence – smart SEO efforts can bolster your social media reach. And on the flipside, a strong social media presence works to improve your site’s visibility in search rankings.

When you stop thinking of social media as a fluffy add-on, and start using it as a tactical tool to support your SEO strategy, the benefits will flow. These five social media tips will help you get perspective and charge up your new power tool.

In the SEO community, we have a long held obsession with cultivating backlinks to boost search ranking. It’s a proven tactic that has outlived many passing digital fads – the more diverse external links you can garner, the greater authority Google bestows upon your brand and the better your website performs in SERPs.

Social media is an ingenious tool for encouraging external sites and followers to link back to your content. When you consistently publish original, valuable, authoritative, top quality content, fans and followers act as satellites, sharing and discussing your ideas, and generating a whole new universe of external link sources. Use hashtags to kick-start your visibility when initiating that syndication process.

A big corporation with millions of Facebook likes, for example, will enjoy a significantly higher ranking bonus than say a brand with a measly 50 Twitter followers. This is not without limitations however. Google can discern the calibre and authenticity of your followers, and will always favour an organically cultivated following over a paid parcel of unengaged proxy followers.

To grow your following organically, develop a unique and consistent authorial voice and engage followers by regularly sharing or publishing valuable content (relevant articles, useful tips, and general conversation starters). Direct customer engagement is the key to building and maintaining a healthy following – it encourages existing followers to come back and help strengthen your authority for potential new followers. Organic followers are typically more engaged because they have a genuine interest in whatever it is that your brand represents.
In addition to news articles and Knowledge Graph entries, Google also favours popular social media updates in the top sections of its SERPs. It’s a significant, albeit rather temporary position that you can achieve by optimising your posts with relevant keywords and images. As trending topics jump off, you can boost your visibility by chiming in and high-jacking the conversation, so to speak with bright, optimised, eye-catching (or crawler-catching, perhaps) content. This is a clever strategy for sprucing up your existing content to get more mileage out of it.

It should come as little surprise that Google would give you a SERPs pat on the back for actively using the Google+ platform. Many digital strategists focus more energy and resources on the big audience platforms, like Twitter and Facebook. If you want to leverage social for firmer SEO results, don’t leave Google+ out of the equation.

As little as one Google+ post per day is sufficient to let Google know that you are active on the platform and elevate your standing in search results. Make sure that any content you post on Google+ contains keywords and concepts that are consistent with your brand and your overall SEO goals. For example, if you post irrelevant daily statements about the weather, it dilutes your brand messaging and sends a signal to Google that you are more interested in (and therefore more of an authority on) the temperature than your core business.
Did you know that the team over at Google HQ now uses Twitter to discover and index new content? As a major repository of content and conversation, Twitter has become something of an ‘indexation shortcut’ for the search giant, shining a digital spotlight on authoritative new content. Google now pays special attention to any content that generates good traction, or ‘trends’, on Twitter.
A viral tweet can be enough to thrust your brand into the search engine spotlight. When Google indexes social content, they factor in the number of retweets, the number of link shares, and the lifespan of the sharing activity. From an SEO point of view, content indexation is crucial because the sooner your content is indexed, the sooner you can enjoy a surge in organic traffic to your website
With the all-pervasive rise of social media over the last decade, naturally the search giants like Google have paid close attention and responded by incorporating social media activity and authority in search rankings. For the brands that factor both social media and SEO tactics into their digital strategies, higher visibility in search results and increased web traffic are virtually guaranteed.


Source: Social Media: A Power Tool In The SEO Toolbox | Dynamic Business – Small Business Advice – Forums | Dynamic Business Australia