Monday 28 February 2022

How to check Google search results for different locations

how-to-check-search-results-for-different-locations

One of the fundamental truths about SEO is that no two Google searches are the same.

The logic behind it is simple, things you’ve Googled, read and watched are stored for at least three months before your Web & App Activity is deleted, if at all.

This, together with data on devices you use as well as places you go – both in terms of location history and the current IP – lets Google deliver personalized results. While this is convenient, you end up in the infamous “filter bubble”.  

In a world of highly customized SERPs on the one hand, and a host of ranking signals for local search Google uses in its algorithms on the other, pulling relevant ranking data is as challenging as it gets.

Luckily, there are a bunch of ways to pop the filter bubble, targeting the one thing that seems to be dominating personalized search – location.

Not only does it determine what users see in search results, but it also helps business owners address the issue of inconsistent SERP performance across their service areas.

The thing is, doing your local SEO homework doesn’t stop at continuous content improvement and link building, targeted specifically for local search. Poor performance can still be an issue – one that is oftentimes attributed to not having enough of a customer base in a certain location. Therefore, the problem can only be diagnosed by checking SERPs for the entirety of the geographical area covered.

Without further ado, let’s look at how you can fetch rankings for different locations manually and using designated tools – all from the comfort of your home.

Country-level search

First off, decide on the level of localization.

For brands working in multiple countries, pulling nationwide results is more than enough. For local businesses operating within a city, ranking data will differ district by district and street by street.

Check manually

So, say you want to see how well a website performs in country-level search. For that, you’ll need to adjust Google search settings and then specify the region you’d like to run a search for. And yes, you heard it right: simply checking that you have the correct TLD extension is no longer enough since Google stopped serving results on separate country domains a while back.

Now, in order to run a country-specific search manually, locate Search settings in your browser and pick a region from the list available under Region Settings.

google-regional-settings

Alternatively, use a proxy or VPN service – both work for doing a country-wide search.

Use rank tracking software

To automate the job, turn to the rank tracking software of choice, for example, Rank Tracker. The results will pretty much reflect the SERPs you fetched having manually adjusted search settings in the browser.

There you have it – non-geo-sensitive queries and multilingual websites performance tracking are all taken care of.

City-level search

Doing SEO for small or medium-sized business comes with many challenges, not the least of which is making sure your website shows up in local search.

Whether you have a physical store or simply provide services within a specific area, tracking ranking coverage on the city level will ultimately improve findability, and drive leads and customers.

Check manually

To manually run a search limited to a specific city, use the ‘&near=cityname’ search parameter in your Google URL:

As the name suggests, “&near=cityname” lets you pull SERPs near a certain location. While this method is easy to master, many claim that it’s unreliable, with results often delivered for a larger city nearby.

city-level-search-in-google

Still, the trick is nice to have up your sleeve as a quick and sound way of checking city-specific rankings manually.

Another silver bullet of local search that is sure to hit the city target is Google Ads’ Preview and Diagnosis Tool.

The Ad Preview and Diagnosis tool lets you pick a location, specify a language as well as user device – and fetch local SERPs regardless of your current whereabouts.

Use rank tracking software

Pretty much every rank tracking tool out there is able to run a city-specific ranking check.

Rank Tracker, Ahrefs, SEMrush, Whitespark, AccuRanker, BrightLocal – you name it – all boast the functionality and deliver local search results. That said, picking the right software for you and your business is a two-fold process.

First, take the time to look into the supported locations for search, since some of the tools, like Whitespark or SEMrush, have a somewhat limited location catalog. Second, you need to double-check that the software you’re most interested in is using their own database, with results relying on a well-designed and trusted crawler.

Doing this type of research helps you safeguard that you are able to easily see accurate SERPs for the location of your choosing.

In case you’re new to city-level ranking checks and/or baffled by the variety of options on the market, go for a single-dashboard tool: BrightLocal would be a perfect example of clean design and intuitive navigation.

Better yet, all data lives on BrightLocal’s website, which adds to the overall user-friendliness and lets you easily automate the monitoring of top search engines for multiple locations.

Street-level search

Google’s Local Pack is the place to be when running any kind of business. With over half of searches run from mobile devices, a single Local Pack may take up as much as an entire results page on a smartphone.

Both Maps and Local Pack results are extremely location-sensitive. Always keep that in mind while you’re doing your research. In order to verify that your business shows up for the right locations within a city, the search is to be narrowed down to a specific street address.

Check manually

Not to say that you cannot configure an address-specific search by yourself. Even manually, this is still perfectly doable.

However, unlike relying on a toolkit that would basically do the whole process for you, setting up a highly localized search in a browser involves multiple steps and also requires some groundwork.

  1. To start off, you need to get the exact geo-coordinates of the location you’d like to run the search from. When in doubt, use a designated tool.
  2. In your Google Chrome browser, open DevTools: navigate to the top right corner of your browser window and click on Tools > Developer Tools. You can also press Control+Shift+C (on Windows) or Command+Option+C(on Mac).

manually-checking-search-results-using-developer-tools

3. Navigate to the three-dot menu icon in the top right corner: from there, click More Tools > Sensors. This step is also the appropriate time to give yourself some credit for getting that far in Google search configuration.

4. In the Geolocation dropdown, select “Other” and paste your target longitude and latitude coordinates.

5. Run a search and retrieve the SERPs for the exact location you specified.

In case you aren’t particularly excited about a multistep search setup, try the Valentin app, it lets you check search results for any location with no DevTools involved.

Use rank tracking software

If anything, rank tracking for multiple precise locations is the one job you want automated and done for you by a tool that was specifically developed for local search.

There you have the idea behind SEO PowerSuite’s Rank Tracker designed to, among other things, pull hyper-localized SERPs for unlimited locations. Configure as many custom search engines as you wish. On top of that, set up scheduled tasks and have local search results checked autonomously.

Not only do I rely on Rank Tracker because it has been built by my team but also because it’s the only toolkit out there that automates what both Chrome and Valentin app help you configure manually. And of course, ranking data retrieved by the software is precise and easily exportable.

Another tool that lets you visualize – quite literally – any business’ search performance across a service area is Local Falcon. Created for Google Maps, the platform runs a search for up to 225 locations within any area specified.

With an overview of your search performance at hand, you can make better targeting choices while expanding outreach and winning new customers.

Final thoughts

Given that there are as many SERP variations as there are searches, rank tracking may feel utterly discouraging: if no two users get to see quite the exact same results, why bother? Well, the sentiment is totally understandable.

But in fact, it all boils down to understanding the reasons behind tracking rankings in the first place.

Is it to see how quickly your SEO efforts transform into higher positions in SERPs? That’d be one. Is it to make sense of the changes in traffic and sales at every point and in every location? Sure.

Big and small, businesses today simply have to keep tabs on their rankings not just country-wide but even on a street-by-street basis. There is hardly any excuse to ignore a single metric here.

Not just that, in business as well as SEO there is no such thing as an unexplainable dynamic. And more often than not, you have to take a closer look to see the root of any problem.

We all understand that rankings in themselves aren’t the only metric of success. It’s not as straightforward as having more traffic, getting more business is the main goal.

But it shouldn’t in any way undermine the overall importance of tracking rankings as a tried and tested way of checking that your website is served among relevant search results.

Local search is all about making sure your customers see you and get to you. So use it to your best advantage – whether you go for checking manually or using rank tracking software.

Aleh is the Founder and CMO at SEO PowerSuite and Awario. He can be found on Twitter at .

Whitepapers

Related reading

Quick wins for Magento SEO
How to use PPC data to drive more SEO traffic
steps to deliver better technical seo to your clients

This marketing news is not the copyright of Scott.Services – please click here to see the original source of this article. Author: Aleh Barysevich

For more SEO, PPC, internet marketing news please check out https://news.scott.services

Why not check out our SEO, PPC marketing services at https://www.scott.services

We’re also on:
https://www.facebook.com/scottdotservices/
https://twitter.com/scottdsmith
https://plus.google.com/112865305341039147737

The post How to check Google search results for different locations appeared first on Scott.Services Online Marketing News.



source https://news.scott.services/how-to-check-google-search-results-for-different-locations/

Microsoft Frees exFAT Patents to Open Source

One of Microsoft’s remaining system patents, exFAT, has been released to open source for Open Invention Network members.

This marketing news is not the copyright of Scott.Services – please click here to see the original source of this article. Author:

For more SEO, PPC, internet marketing news please check out https://news.scott.services

Why not check out our SEO, PPC marketing services at https://www.scott.services

We’re also on:
https://www.facebook.com/scottdotservices/
https://twitter.com/scottdsmith
https://plus.google.com/112865305341039147737

The post Microsoft Frees exFAT Patents to Open Source appeared first on Scott.Services Online Marketing News.



source https://news.scott.services/microsoft-frees-exfat-patents-to-open-source/

Use Competitor Keywords to Improve Your Digital Strategy in 5 Steps

Use Competitor Keywords to Improve Your Digital Strategy in 5 Steps

Competitor keyword analysis is the process of finding what keywords your competitors rank well for and using this information to level up your strategy. Learn how to find and target competitor keywords to your chances of out-ranking your rivals on the SERPs.

This marketing news is not the copyright of Scott.Services – please click here to see the original source of this article. Author:

For more SEO, PPC, internet marketing news please check out https://news.scott.services

Why not check out our SEO, PPC marketing services at https://www.scott.services

We’re also on:
https://www.facebook.com/scottdotservices/
https://twitter.com/scottdsmith
https://plus.google.com/112865305341039147737

The post Use Competitor Keywords to Improve Your Digital Strategy in 5 Steps appeared first on Scott.Services Online Marketing News.



source https://news.scott.services/use-competitor-keywords-to-improve-your-digital-strategy-in-5-steps/

Google Internal SEO Experts Hosting SEO Workshop – Is That Okay?

David Mihm pointed out on Twitter that Google is hosting a partner workshop event named “Drive Traffic to Your Website with SEO.” The interesting bit is that the workshop says it is “hosted by one of Google’s internal SEO experts, this workshop will give you a behind-the-scenes view into how Google approaches SEO for its own sites.”

This marketing news is not the copyright of Scott.Services – please click here to see the original source of this article. Author: barry@rustybrick.com (Barry Schwartz)

For more SEO, PPC, internet marketing news please check out https://news.scott.services

Why not check out our SEO, PPC marketing services at https://www.scott.services

We’re also on:
https://www.facebook.com/scottdotservices/
https://twitter.com/scottdsmith
https://plus.google.com/112865305341039147737

The post Google Internal SEO Experts Hosting SEO Workshop – Is That Okay? appeared first on Scott.Services Online Marketing News.



source https://news.scott.services/google-internal-seo-experts-hosting-seo-workshop-is-that-okay/

Google Tests Search Bar Filters & Options On Top Right Side

I am seeing multiple reports of Google placing the search bar filters, you know, the bar that says “all, videos, news, images, more, etc” which is normally placed under the search box, is being tested on the right hand side of the search box. It doesn’t look like a bug but Google has had many weird quirks recently.

This marketing news is not the copyright of Scott.Services – please click here to see the original source of this article. Author: barry@rustybrick.com (Barry Schwartz)

For more SEO, PPC, internet marketing news please check out https://news.scott.services

Why not check out our SEO, PPC marketing services at https://www.scott.services

We’re also on:
https://www.facebook.com/scottdotservices/
https://twitter.com/scottdsmith
https://plus.google.com/112865305341039147737

The post Google Tests Search Bar Filters & Options On Top Right Side appeared first on Scott.Services Online Marketing News.



source https://news.scott.services/google-tests-search-bar-filters-options-on-top-right-side/

Google Blocks Search Ads From So-Called Donetsk People’s Republic & Luhansk People’s Republic

Google has posted a new legal requirement policy that blocks search ads related to what is going on with Russia’s invasion of Ukraine. The policy says that entities and individuals who are restricted cannot create or use a Google Ads account or have Google Ads used on their behalf for those who are located in or reside in so-called Donetsk People’s Republic (DNR) and Luhansk People’s Republic (LNR).

This marketing news is not the copyright of Scott.Services – please click here to see the original source of this article. Author: barry@rustybrick.com (Barry Schwartz)

For more SEO, PPC, internet marketing news please check out https://news.scott.services

Why not check out our SEO, PPC marketing services at https://www.scott.services

We’re also on:
https://www.facebook.com/scottdotservices/
https://twitter.com/scottdsmith
https://plus.google.com/112865305341039147737

The post Google Blocks Search Ads From So-Called Donetsk People’s Republic & Luhansk People’s Republic appeared first on Scott.Services Online Marketing News.



source https://news.scott.services/google-blocks-search-ads-from-so-called-donetsk-peoples-republic-luhansk-peoples-republic/

Bing Webmaster Tools Lets You Verify Your Site Using Google Search Console

This seems weird at first site but Bing Webmaster Tools has a beta option to import your sites from Google Search Console. Yes, it seems the two search engines are working together to get more webmasters to verify their web sites in Bing Webmaster Tools.

If you login to Bing Webmaster Tools, you may see an option at the top right that reads “Already verified on Google Search Console?Beta. Skip verification by importing your site.” This is followed by an “import” button. Here is a screen shot:

click for full size

Hat tip to @sunnykujjawal for sending this my way…

Forum discussion at Twitter.

This marketing news is not the copyright of Scott.Services – please click here to see the original source of this article. Author: barry@rustybrick.com (Barry Schwartz)

For more SEO, PPC, internet marketing news please check out https://news.scott.services

Why not check out our SEO, PPC marketing services at https://www.scott.services

We’re also on:
https://www.facebook.com/scottdotservices/
https://twitter.com/scottdsmith
https://plus.google.com/112865305341039147737

The post Bing Webmaster Tools Lets You Verify Your Site Using Google Search Console appeared first on Scott.Services Online Marketing News.



source https://news.scott.services/bing-webmaster-tools-lets-you-verify-your-site-using-google-search-console/

Oakland Raiders Meet Stan, Google’s Dinosaur

Oakland Raiders Meet Stan The Google Dinosaur

The Oakland Raiders have stopped by Google’s main offices, the GooglePlex, numerous times. Here is a photo from the rookie class of the Oakland Raiders meeting the Google’s very own dinosaur, Stan.

Stan has been on the Google campus for over a dozen years, so it makes sense to pay respect.

The photo is on Instagram.

This post is part of our daily Search Photo of the Day column, where we find fun and interesting photos related to the search industry and share them with our readers.

This marketing news is not the copyright of Scott.Services – please click here to see the original source of this article. Author: barry@rustybrick.com (Barry Schwartz)

For more SEO, PPC, internet marketing news please check out https://news.scott.services

Why not check out our SEO, PPC marketing services at https://www.scott.services

We’re also on:
https://www.facebook.com/scottdotservices/
https://twitter.com/scottdsmith
https://plus.google.com/112865305341039147737

The post Oakland Raiders Meet Stan, Google’s Dinosaur appeared first on Scott.Services Online Marketing News.



source https://news.scott.services/oakland-raiders-meet-stan-googles-dinosaur/

Sunday 27 February 2022

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns

If you are the agency employee or marketer in charge of social media, then it is your job to tie social activity back to business results. Period.

But how can you show the real impact of social media? More importantly; how can you do it consistently, without going crazy in the process?

Many unfortunate marketers spend countless, soul-crushing hours retrieving, formatting and spewing “vanity” metrics, that in reality, mean squat for the business.

But you are going to be different, my friend.

You are going to implement a simple, effective data analytics process for your agency or business that lets you show the impact of your work, without any pain involved.

In this article, you are going to get step-by-step instruction and a plug-andplay template you can use to fully automate your Facebook and Instagram data analysis.

By the end, you will have:

1. An understanding of the right social media wall post metrics to report on.

2. An automated system to collect those metrics, straight from their source.

3. A ready-made, automated dashboard to visualize this data and share it with your team.

Alright, let’s begin!

ETL Tools Are Good For Marketers

ETL stands for Extract, Transform, and Load. It is a software tool that helps eliminate the pain involved with retrieving useful data.

As the name implies, ETL tools extract data from their original source, transforms the data while in transit, and then load the data into a target data storage.

As a marketer, why would you need to extract, transform, and load data?

You could manually use the native dashboards that Facebook and Instagram provide. But that process is time-consuming, inefficient, and can lead to incorrect data and affect your decision making going forward. 

Why Relying On Native Facebook and Instagram Dashboards Alone Can Be Problematic

What if you want to compare FB + Instagram campaigns together in one dataset? To really dig into relative performance between the two platforms, you will want to join them up and look at consolidated results.

You can’t do that in a time-effective way without jumping back and forth between platforms. This makes the process more complex and tedious than it has to be when you want to find and analyze information.

Another issue that comes from relying on the native FB and Instagram platforms is that you can’t prioritize the data you really want to see. 

For example, when it comes to analyzing the success of my client campaigns, I prefer to follow Avinash Kaushik’s approach to social media metrics over at Occam’s Razor (one of the best blogs around on data analytics and marketing). 

As he explains it, a lot of marketers focus on “Vanity” Metrics, which look impressive but don’t necessarily drive sales. The problem is, you can’t make business decisions based on those metrics.

So instead, we focus on the key social media metrics Avinash Kaushik recommends:

  • Conversation: comments per post.

  • Amplification: shares per post.

  • Applause: likes or reactions per post.

There are several reasons we prioritize these metrics:

  1. They give us an indication of whether or not people are aware, interested, and ready for the next stage of the journey.

  2. They show us how much value each of the individual ad sets, campaigns, or/and ads contribute.

  3. They give us an idea of which content pieces in the content mix are hitting the mark with your audience from a branding perspective.

  4. Another advantage of these metrics is that they are public information, so you can easily compare your content strategy with any competitor and benchmark on your individual competitive space.

Now, I only want to see the metrics that really matter to me (just the comments, likes, and shares). So, I use an ETL tool that transforms the data I want from the native FB and Instagram dashboards and loads it onto a dashboard that I have created and customized to increase efficiency and to improve analysis and decision making. 

What Is Included In the Customized Dashboard?

We have built a Google Sheets + Data Studio template that allows you to automate the daily process of joining together organic Facebook and Instagram results.

[If you are ready to dive straight into the template, you can access the template here] 

The template’s goal is to provide all the information you need at a glance to make decisions for the Facebook and Instagram pages you manage.  It provides some aggregate metrics, as well as a post-level table for deeper dives. Here is what the template looks like:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 0

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 0

We will get into how you can set this up to analyze and monitor your own FB and Instragam campaigns, but first, let me walk you through how and why I have set it up this way. The three “stars” of the dashboard are the metrics, the median, and the ability to compare Facebook and Instagram in one sheet.

Metrics

You will notice that the metrics I used align with Avinash Kaushik’s approach – Social Engagement, Post Reactions, and Post Comments. 

These are pulled directly from Facebook:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 1

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 1

The Median

Another customization on the dashboard is a section for the median engagement, as well as outlier data for the last 6 months:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 2

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 2

The reason I include the median as a baseline is it acts as a goal metric I aim to surpass.

This baseline is determined from the level of engagement you have received in the past; to find it, we use the median of the reactions for a specific time period. For example, when starting to work with a client, I first want to answer two questions:

  • What is the baseline (median) for post comments, shares, and likes?
  • What does an outlier (successful post) look like?

Including these median baselines in the Data Studio template makes these easy to answer.

How to Make Your Own Custom Dashboard that Automatically Compares FB and Instagram Data

Now that you have some background into why it is set up this way, let’s dive into how to set it up.

Step 1: Copy This Google Sheet

So the first thing you are going to do is click here to make a copy of this Google Sheet. Name it whatever you would like.

This new sheet you have copied is going to be your base file. Use this as a starting point whenever you onboard a new client or whenever you want to make the automation in the report for a new account.

Step 2: Run Supermetrics

If you haven’t downloaded Supermetrics yet, you are definitely going to need that in your toolbox. It is one of the best software products I have downloaded in my career. I highly recommend it. There is a free trial, so there is no downside.

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 3

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 3

Step 3: Duplicate This Sheet for Facebook & Instagram Accounts

Next, you need to duplicate this sheet for your Facebook and Instagram accounts. We are going to do that by clicking “Add Ons” —> “SuperMetrics” (launch it first). 

Once Supermetrics is running, then go to “Supermetrics” —> “Duplicate this file for another account”. 

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 4

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 4

From there, a box will pop up that will allow you to choose your Facebook insights account:

  • Choose the Facebook insights account you want to create the report for (if you are not logged in, it will ask you to log in first).

  • Select the same brand’s Instagram account.

  • Finally, click “Duplicate this file”. 

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 5

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 5

What it is doing now is actually creating a new Google sheet, like a spoke off the main hub sheet that you will have.

Once the files have duplicated successfully, it will refresh all of the Supermetrics queries that are in the base file. This can take some time.

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 6

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 6

Once the refresh is complete, click “here” to access your brand new file. 

Now, as you can see, the new file is named “Copy of Copy of FB/IG | Data Input | 32 Mo – Wheel of Fortune.” You will notice it has the new brand name at the end. Feel free to delete “Copy of Copy of”.

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 7

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 7

Now you have your new data set for the new brand.

Note that I have three separate queries here from Supermetrics:

  • A Facebook posts insights query.

  • An Instagram insights query.

  • And a third tab is a Stacking query where I use the query function to basically stack the Facebook and Instagram post tabs on top of each other.

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 8

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 8

So if you look under “Facebook Posts” you can see that all of the Facebook post data has populated correctly, and it is the same thing under “Instagram Posts”.

The “Stacking Query” tab, the one that is most important to us, is the one that puts Facebook on top of the Instagram table. You can scroll down and confirm that they are both there. 

And it is beautiful…

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 9

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 9

Step 4: Make a Copy of The Data Studio Data Source

Now, head back to the FB/IG | Data Input sheet, to step #4, where you will navigate to the Data Studio Data Source.

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 10

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 10

Make a copy of the data source by clicking on the two rectangular icons in the top right corner, and then choose “Copy data source”:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 11

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 11

Once that is done copying, you can rename the file for the brand you are working on:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 12

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 12

Then click “Edit Connection”: 

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 13

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 13

In the list, you can see the name of the datasheet you just created. Now, this is very important; you need to select “Stacking Query” and then select the blue “Reconnect” button in the top right corner.

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 14

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 14

If you get a pop up like the one below, that is ok, just click “Apply”:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 15

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 15

Now you have your new data source all set and ready to go:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 16

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 16

Step #5: Make a Copy of the Data Studio Report Template

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 17

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 17

Click the link on the FB/IG | Data Input sheet under #5. Once that is open, you will make a copy of the report. Click on the rectangles again and then choose the correct name under “New Data Source”: 

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 18

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 18

Select the same data source you just created:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 19

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 19

Click “Create Report”:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 20

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 20

And BOOM! Here you are, your complete Facebook and Instagram Wall Post Dashboard:

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 21

A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns. Image 21

An ETL for Every Marketer – Data Analysis The Easy Way

From one marketer to another, I know the reality of trying to comb through data, jump from platform to platform to get what I need, and then analyze it. Using an ETL tool along with this customizable dashboard to zero in on the exact data I want to see, in the way I want to see it, has drastically changed the way I work.

Another benefit is that I can give my clients access and they can immediately see, at a glance, the kinds of results and the direction we are taking with their campaigns. 

If you would like to set this up for your campaigns, you can get a copy of the Google Sheets template here and the Google Data Studio template here (no opt-in).

This marketing news is not the copyright of Scott.Services – please click here to see the original source of this article. Author:

For more SEO, PPC, internet marketing news please check out https://news.scott.services

Why not check out our SEO, PPC marketing services at https://www.scott.services

We’re also on:
https://www.facebook.com/scottdotservices/
https://twitter.com/scottdsmith
https://plus.google.com/112865305341039147737

The post A Marketer’s Secret Data Weapon to Analyze Facebook and Instagram Ad Campaigns appeared first on Scott.Services Online Marketing News.



source https://news.scott.services/a-marketers-secret-data-weapon-to-analyze-facebook-and-instagram-ad-campaigns/