Tech Tools

Using Google Analytics Add-On To Automate Your Reporting

Analytics Digital Marketing SEO Tech Tools

Today we will talk about automating your reports using Google Sheet’s Google Analytics add-on. This nifty tool was formerly known as Google Magic Sheets. The add-on is very simple to implement and will definitely save you time on reporting metrics from Google Analytics.

Getting The Google Analytics Add-On

Google Analytics Add-on

  1. Start a brand new Google Sheet
  2. Select the Add-ons option
  3. Search for the Google Analytics Add-On
  4. Install it to your Google Sheets

Now your Google Sheets have access to your Google Analytics API and can begin pulling data in an organized way for your reporting purposes. Lets try it out.

Using the Google Analytics Add-On

Under your Add-ons, the Google Analytics add-on should be an option now, after you installed it. It should come with 3 dropdown options

  • Create new report
  • Run report
  • Schedule report

Create Report

Click “create report” to get started with using the add-on. You should see options pop up on the right-hand side. This is where you will begin to create your reporting configuration sheet, this sheet will be your hub for telling Google Sheets what exactly you want it to pull from Google Analytics.

Create a new report

To get started you will be told to select the appropriate

  • Account
  • Property
  • View
  • A Metric from a Dimension you want to pull

Click the “Create Report” blue button on the bottom to start having your reporting configuration sheet.

Configuration sheet

Now you have set up Google Analytics automatic reporting on your Google Sheet. On the Report Configuration sheet, you can customize what each sheet will show you based on metrics and dimensions you want. Remember, this sheet can only show you what is possible to show you in Google Analytics, meaning, do not try to see two secondary dimensions on one report, you will have to create a new report using the next column over.

Helpful Points of References for Creating Reports

  • Query Explorer – This is extremely useful because you can test out the configurations here first, and there will be recommendations on what exactly you will need to input in your configurations.
  • Core Reporting API Guide – This will tell you specific functions you can put in to drill down the data to exactly what you need. For example, you can find how to include and exclude just like filters in GA.

Run Report

It is also helpful to note that the add-on will tell you if you inputting the configuration incorrectly. So, after you have put in the data you want Google Sheets to fetch, go back to the add-ons option, go to Google Analytics option, now click the second option “Run Report.”

Report Status

If you have configured your settings incorrectly you will see a reporting error. Fortunately, the report will also tell you exactly which metric was inputted incorrectly. Ex: “unknown metric:” “unknown dimension

Schedule Report

Schedule Reports

The coolest thing about this feature is that you can schedule your reports to run at a certain time. This means you can have your data the instant you need it, maybe at the beginning of the month you need the data for the last 30 days. You can set the add-on to run all the reports the night before the 1st of the month, every month. So, when you come in the morning, everything will be ready for you.

Advice: Creating a Master Reporting Sheet For Consolidation

You should create a master sheet for viewing purposes, or else you will end up going from sheet to sheet to see what you need. So, create a master view sheet and fill in the cells using formulas. For example, if you created a table that will tell you the organic traffic for the month from a specific campaign or the organic traffic for a specific month, just make that cell equal the sheet that is specifically pulling that data for you. The sheets are great because they compile what you needed on the same cell every time you run a new report, so the consolidated master data will always show you what you need from any specific reporting configuration sheet.

Read more

Written by:

Comments (0) /

How to Give an Agency Access to Your Facebook Ad Account

Digital Marketing Tech Tools

Preliminary Question: Do you use Facebook Business Manager?

Before we even start, it’s worth thinking about whether you want to set up Facebook Business Manager. This will help if you have multiple people or agencies working on your page, or if you manage multiple pages. If you ever find yourself overwhelmed by too much clicking through Facebook for business purposes, Business Manager might be for you.

If you decide to use Business Manager or use it already, let your account manager know. We’ll send you our Business ID number, and you can use it to “Assign a Partner” to your ad account.

If you DON’T want to use Business Manger, or if you’re not sure, follow these steps!

Step 1: Go to your business page.


Step 2: Click “Promote” in the top right corner. (If you don’t see this blue Promote button, you can also click on the downward arrow in the far top right corner of Facebook, and click “Create Ads.” Then skip to Step 4.)


Step 3: Click “Go to Ads Manager” at the bottom of the list.



Step 4: If you see the following screen, click “close without saving” at the bottom left. If you DON’T see this screen, skip to the next step.
step 4 close without saving

A screenshot of the Facebook ads interface that prompts you to choose the objective for your campaign. The first item on the list is “boost your posts.” You can navigate away from this page by clicking the link at the bottom called “Close without saving.”

Step 5: You should now be in the Ads Manager. Click “Account Settings” in the top menu. You might have to re-enter your Facebook password to proceed.

step 5 click account settings

step 5a enter password

Step 6: Copy your account number and send it to your agency. They can then request access to your ad account. There will be a notification that pops up

step 6 copy your account id number

Step 7: Make sure to add a payment method! Click “Billing” in the top menu, and then click the green “Add Payment Method” button. Then you can add your information! Choose the credit card.

step 7 add payment method

Important Note: Facebook seems to have a higher-than-average rate of credit cards being declined. They say that this is because the credit card company or bank declines the authorization. If your credit card is declined several times, call your bank and ask them to authorize the card.

Also, be sure to double check that the address is exactly what is listed with your bank. If it’s listed as “Street” instead of “St,” be sure to write it out. If you have talked to your bank and double-checked the address, and your card is still getting declined, please let us know!

Read more

Written by:

Comments (0) /

5 Tools To Help You With Your Keyword Research

Digital Marketing SEO Tech Tools

Keywords, Keywords, Keywords, we just can’t get enough keywords sometimes. Keyword research is an integral part of the SEO process and acts as one of the foundational building blocks when you start any SEO campaign. Keyword research is not just done once but throughout the lifespan of any SEO campaign. They need to be regularly re-tweaked and re-evaluated to drive the kind of results you want in your organic traffic.

Today I am going to talk about five tools I use to nail down my keyword selections and how I tweak my keywords throughout a campaign.

google analytics

Google Analytics

Here is a tool that probably everyone in the world of digital marketing uses, the good ole Google Analytics. This nifty tool offers you a whole plethora of information about your website that is invaluable to any serious digital marketer.

How do I use it? 

I like to get a quick glance of the keyword data in my organic traffic view. This gives me some information on how well some of my targeted keywords are doing. I know the dreaded “not provided” and his evil brother “not set” can be a bummer to any SEO, but it is still a good point of reference to look at the other words popping up in your keyword data list.  I check the list and usually for a timetable of at least one year to get a good sample size of data for how long well my keywords have been doing.  I look to see if the keywords I have been targeting in my campaign appear on this list, and if there are keywords that are being used to find my site’s landing pages that I was not targeting. Both the former and the latter will tell you if you need to tweak

Both the former and the latter will tell you if you need to tweak your selected keywords. If you do not see your targeted keyword show up in a year’s worth of data, then it may be time to change your strategy because that keyword is not gaining you the traffic and results you want. If it was the latter then you already see a better keyword to target your page around, and can make the adjustment accordingly.

You should always look at your landing page data as well. See which pages are getting the most traffic to your site. You can conclude a lot from this pool of data.


  • If a product page is getting the most traffic, you can conclude that this product needs to be emphasized more
  • If a blog post is gaining the most traffic, then you can conclude that blog content is the driving force of traffic to your site
  • If the homepage is the main driving force of traffic, it can be concluded that branded keywords could be the driving force

You can draw these kinds of conclusions to see what has worked and what has not worked for your campaign so far. This will give you a good knowledge bank on how to proceed forward. You can also get more data by setting keyword as your secondary dimension and seeing what pops up. If you see most traffic coming from keywords “not set” and “not provided” then you need to form your conclusions.

Steps Taken: 

Acquisition –> All Traffic –> Channels –> Organic Search –> Primary Dimension: Keyword & Primary Dimension: Landing Pages


Google Webmaster Tools

I like to use Google Webmaster Tools and check out the query data that is available when I have decided to spend a longer period analyzing my keyword data.

Neil Patel has a great article titled: “Know The Difference Between Queries and Keywords and What To Do About It.”

Marketers use Keywords

Users use Queries

You could get this data in Google Analytics if you were able to link your Google Analytics account with its Google Webmaster account you can see your query data using the following steps.

Steps Taken

Google Analytics –> Acquisition –> Search Engine Optimization –> Queries

Here you are given probably a much larger data set than your keyword data. You get a good chest of information here from what searchers are searching for. How I like to look at this information.

  • Impressions: I like to filter down to impressions to see what opportunities exist out there. This will also give me good insight on whether or not people search anything remotely close to the keyword I am targeting. Also taking a gander at some of the longer phrases used in these searches to develop content for blogs, or give more depth to my existing pages.
  • Clicks: This tells me what queries are driving some traffic to my site.
  • Avg. Position: This data is important because when I compare this to my impressions and clicks its good to see how far a user traveled to even get a sight of my URL in search results. If you are noticing people are seeing your URL after going to page 2, then there is opportunity to plan out your keyword strategy. Anyone seeing your URL on page 2 is apparently not getting what they want on page 1.

Use query data to gather insights on how searchers actually search. If you notice longer queries in your analysis than you already have an idea on what content to produce next, and how to beef up your existing content with more information that fits what users are looking for.

Keyword Tool io

Keyword Tool I.O is a cool tool, and I like it because it gives you ideas that tools like keyword planner does not give you.

Keyword Tool will help you discover thousands of the new longtail keywords related to the topic that you specify by automatically generating Google’s auto suggestions. The auto suggestions will be generated based on the Google domain and language that you choose.”

As you can see from their description, the objective is to give you ideas for long-tail keywords. The great thing about this tool is that it puts words before and after your searched term. The results you get from this tool can give you many ideas because you get a whole dataset of words being searched around your term.

How I Like To Use It: 

If you are starting any SEO campaign, you are working with clients who are dealing with some product or service. I like to take a small and broad category from their industry and see what results pop up.


  • If you were working in real estate, a common theme you might deal with is “home mortgage” just throw this broad term into and see what you get.

home mortgage example

The results you get already provides a good bank of information for you to work with. Bare in mind, this snapshot is only from the broad term with the letters “h” and “i” after it. So, from this small list you can already see a few topics you can build content around.

  • Home mortgage how much can I afford
  • Home mortgage interest calculator
  • home mortgage for disabled persons

These three suggestions are already very idea points to think off of. If you have not tried yet, you should give it a shot.



I just started using SEMRush for stuff other than my competitor research and discovered I really enjoyed using their keyword research data. I recently started using keyword planner to tweak my keywords for existing campaigns. I would take my already existing targeted keywords and throw them into SEMRush. From here I would look at the phrase match report and see what shows up. I get a quick snapshot of essential insights to consider like search volume and competitiveness.

After 6-12months I think it is time for any SEO to really evaluate how all their keywords are doing and try to understand what you can do to improve on those keywords. When I first started doing SEO, I was fixated on broad terms and the appeal of huge volume keywords, and I learned the hard way that getting ranked for broad terms on limited resources might not be the best course of action to take due to how competitive it was to rank.

SEMRush’s phrase match report gives you suggestions on how to make your targeted keywords even longer and longer keywords might not have as much search volume but, you might have a better chance of getting some traffic from the longer version of the word and it’s been proven that longer tail keywords convert better.

SEMRush also has a related keywords report available which seem to be a good place to gather even more ideas.


Ahrefs Content Explorer

I am always looking for new tools to use and Ahrefs’ content explorer is becoming a tool I come for reference more often for long tail keywords and big content ideas. It allows you to search using a keyword your type in, and the results will be viral content has been made around the topic you are planning to write about. This gives you a good point of reference for what content has worked and what you are up against if you were to write something similar. If you have not come up with your idea yet, just type in a broad term, and see what has been written about that specific topic that people cared enough about to share on their social media outlets.

Brian Dean wrote a great article about the skyscraper technique and provided a case study that I often reference back to.

3 Steps The Skyscraper Technique

  1. Find Link Worthy Content
  2. Make It Even Better
  3. Reach Out To the Right People’

The previous tools I mentioned already gives you some ideas for long-tail content. If you think any of the suggestions are a winner, throw the long tail term into content explorer and see what already exists on the net about it. Observe the results from content explorer, the headlines of the most shared articles and you can filter by the main social media outlets like Twitter, Facebook, Google + and Linkedin. See which piece of content was the most successful, and piece those together to make an even better article to build around your long-tail keyword.

Read more

Written by:

Comments (0) /

How to Add Review Sites to your CustomerLobby Profile

Digital Marketing Social Media Tech Tools

CustomerLobby is a review solicitation tool that is an excellent source for feedback and customer appreciation. One of the best features of CustomerLobby is that you can send your customers to review sites like Google+, Yelp, AngiesList, and Facebook. Great reviews on heavily trafficked sites will mean plenty of referrals, so let’s get started!

If you are a CustomerLobby customer, there are a few easy steps to ensure your account is setup properly.

  1. Login to your CustomerLobby Account
  2. Click “Reviews” and then “Settings”
  3. Select “Invitation Settings” from the Invites area
  4. Turn your Status to “ON”
  5. Paste your business’ Google+ URL
  6. Paste your business’ Yelp URL
  7. Hit “Save”
  8. Select “Auto Send Email Invitations”

Here is a short video of the whole process:

When you have finished the setup, your customers will see the following options at the welcome screen.

CustomerLobby Write A Review


Read more

Written by:

Comments (0) /

How To Add Facebook Comments to any WordPress Blog

IMA Life Social Media Tech Tools

Facebook is without a doubt the single most popular site that requires a login, allowing nearly 1.3 billion people to potentially be a part of your treasured blog. The benefit of Facebook is that you tend to share your real name and real photo, instead of hiding behind some pseudonym (I’m looking at you MySpace), which allows you to get a sense of just who your customer is, as well as giving voice to those who might be unhappy and need a customer rep to reach out to them.

The beauty of Facebook Comments built directly into your website is that most visitors will not need one more annoying login to leave a comment. If they are logged into Facebook anywhere else on their computer, their profile will automatically be ready to go, hopefully creating one less obstacle to engaging with your customer.

Let’s get started, first things first, you’ll need to login to Facebook!

1. Create a Facebook App by visiting, click Apps in the menu and then Add a New App.

Add a New App menu

2. You’ll get several choices on what App to create, in this example, we will be creating it for a WordPress blog, so choose WWW.

Select WWW for Website

3. Enter a name for your website and the website domain where you will be using the Comments tool.

Type Your Company Name

4. You have completed your Facebook Developer registration, now you are ready to move on to embedding the Facebook Comments code into your blog post.

5. Visit URL,

Here you will get the option of customizing your comments style and URL.

  • URL to comment on: Insert your desired blog post URL
  • Width: Leave it blank to use the default, but 600px is standard as well.
  • Number of Posts: represents the number of comments you will see before a “View more” link appears.
  • Color Scheme: Light or Dark, Good or Evil?
Facebook Style Choice

Paste your blogpost URL

2. Click that “Get Code” button just under the settings. You should be presented with a small screen similar to this.
3. Copy the first section of code. 
4. Go back to WordPress, click the TEXT editor of the post, then paste the code at the top of the page before any text.

Copy the Code

Copy the Code & Embed in your HTML above all text

5. Copy the second piece of code and place the code for your plugin wherever you want the Facebook comments to appear, most likely the very bottom of the post.

Paste Comment Block At Bottom of HTML editor.

Paste Comment Block At Bottom of HTML editor.

6.  Publish your post and check out your changes.

7. That’s it! Love/hate this article? Leave me some feedback in the oh-so-easy Facebook Comments below.
PS: If coding isn’t your thing, there are a ton of amazing plug-ins that automate this process for you. In order of simplicity to complexity, check out, Facebook Comments, Facebook Comments Master, and Ultimate Facebook.

Read more

Written by:

Comments Off on How To Add Facebook Comments to any WordPress Blog /