Categories
Analytics GTM

Using GTM to fire Tags in Legacy Pages but not in WordPress

Issue: Make the GTM recognize if you are on a wordpress page and if you are not then fire a tag

 

Step #1: Create a DOM Variable in GTM to store the information of whether a page is built with WordPress or not.



I have identified that the pages in my wordpress site all have a class in Elementor named “wp-page”. So I use CSS Selector and get it with [data-elementor-type=”wp-page”].

 

Step #2 Build a DOM Ready Trigger and use as trigger the above DOM variable.

This triggers works as the lever of the whole process. If the DOM – Element WordPress is not “null” (meaning that the page I currently am is WordPress), then don’t fire.

If the page is legacy then the DOM – Element WordPress is “null” meaning that the trigger should fire.



Step #3 Attach the trigger to a tag

Categories
Analytics Tips & Tricks

Identify CRO Opportunities by comparing Page Types with Pivot Tables

In this guide you will learn how to use basic data analysis to find optimization opportunities using your analytics data and pivot tables from spreadsheets.

I will compare the website page types (namely product pages, product categories & brands) in order to find which type performs best.

Now let’s dive in.

Step #1: Download your Landing Page data from Google Analytics

That’s the easy part. Go to your Google Analytics > Behavior > Site Content > Landing Pages and export them as .csv or export them to Google Sheets (I prefer google sheets over Excel but it’s just my personal preference)

Step #2: Load your data into Google Sheets to modify them

After you load your data on your spreadsheets, it’s time to clean them. At the end the only columns you should have will be:

  • Landing Pages
  • Sessions
  • Transactions
  • and Revenue

Keep it nice and simple.

Final Data Sheet

Step #3: Use the landing Page URL structure to put your landing pages into Category Groups

This is very important, because it will group together landing pages with similar attributes (products with products, brands with brand and product categories with product categories).

The process is simple: If the URL contains XXX then the Category Column Should have the YYY value

if the Url Containsthen the Category column will be
/category-page/Product Category
/προϊόν/Product Page
/brands/Brands
if the url is equal to “/”Homepage
everything elseOthers

At the end data should be something like this:

The data sheet with the new categorization

*Below you can find a video on how I did it and use the same process for your own analysis:

—–> VIDEO <—-

Step #4: Use Pivot Tables to find insights

The biggest hidden secret for data-driven marketing is the use of Pivot Tables. With Pivot Tables you can find very useful insights.

If you master Pivot Tables you will be ahead of 99% of the competition.

Keep in mind that if you want to learn the art of data-driven marketing you need to focus on how to read the data you have.

Here is a video explaining why Pivot Tables are sooooooo important

In order to create a Pivot Table get all your cleaned data with “CTR+A” and go to Data > Pivot Tables

Then do Pivot Table > New Sheet

After that you will be presented with a new empty sheet like the one below.

Now we need to add the data.

  1. Go to Rows and add the Category
  2. Go to Values and add the Sessions
  3. Go to Values and add the Transactions
  4. Go to Values and add the Revenue
Add the Rows & Values in the Pivot Table.

Now we have a nice and small table.

As we said before keep it simple.

We have our table but still it’s not very clear which page type performs best. So we need to add:

  1. Conversion Rate%. In order to see which Page Type converts better
  2. Average Order Value. In order to see which Page Type creates higher value transactions

To do this we need to add those metrics as custom columns (see the gif below).

  • The Conversion Rate formula is Sessions (column B) / Transactions (column C)
  • The Average Order Value formula is Revenue (Column D) / Transactions (Column C)
The Process of Adding the 2 Custom Columns in Pivot Tables

Final Pivot Table

Final Pivot Table

All righty! Now we have all the data we need and with just one look we can understand which page type performs best.

InsightsActions
Brands Pages out perform Product & Product Category Pages both in CR and in Avg. Basket Value
  1. Drive more traffic to Brands Pages
  2. Find ways to improve the user experience in Product and Product Category Pages
Homepage has Great CR and Avg. Basket Value
  1. Find ways to increase your brand presence
Others” have suspiciously high CR
  1. Find which pages are in the “Others” bucket and determine why the CR is so high (my experience says that they are the Cart Pages that by default have very high CR% because their traffic is usually from remarketing

Now it’s your turn to find and answer deep and meaningful business questions.

Categories
Analytics PPC Uncategorized

Smart Shopping Ads Optimization

In this piece we will talk about how to optimize the black box that Smart Shopping Campaigns are.

As we all know Smart Shopping Ads (SSA) are very profitable and very easy to implement. All you need is a Google Merchant Center, a product feed and you are ready to go.

When you set them up the only thing you need to setup is Budget and ROAS target (keep in mind that if you don’t put anything on it it will automatically target 200% ROAS.

Roas Target

 

In Smart Shopping Ads there are no search terms (thus you can’t use negative keywords) and you also don’t have visibility on which products you sold. It’s basically a black box, you give it a feed, a budget and a target it tries to reach the goal.

The only thing you can is exclude products or product groups much like a normal shopping ad. But since you have no visibility in the product’s performance you don’t know what to exclude and what to keep.

Oh but you can! You just need another tool

You need… Google Analytics (or whatever analytics tool you are currently using).

Do the following steps:

  1. You go to Behavior > Site Content > Landing Pages
  2. Have as Primary Dimension: Landing Page
  3. Put the Secondary Dimension: Campaign
  4. Then go to the Advance Filter and use Include > Campaign > *The smart shopping campaign name*
    Google Analytics Filter
  5.  Press Save

You should have a view like the one below

Final Analytics Report

Now you are ready to do some serious analysis that will also come some serious optimization.

Short by Sessions and identify the landing pages that have high volumes and 0% or very low Conversion Rate

Smart Shopping Optimization

These landing pages are the first candidates to exclude/remove from my feed. Why? Because if these landing pages have traffic that means that you pay for this traffic but it does not convert so you are losing money.

After finding these landing pages, find which product they have and from there you can:

  1. Go to Google Ads > Campaigns > Smart Shopping Campaign > Product Group and exclude them from the product group
  2. or Ask your developers to remove this product from your feed.

Why you need to do this: By cutting off the high spending low performing products you give more room to the ones that perform. If you spend 15% of your budget on non converting/high spending items with this technique you force google to re-allocate your spending into more profitable items.

Till next time 😀

Categories
Analytics Facebook Ads PPC Tips & Tricks

How to Combine UTMs with your Google Analytics to get some super tricks to optimize your PPC efforts

How to Combine UTMs with your Google Analytics to get some super tricks to optimize your PPC efforts

 

When I run Product Catalog Ads I use the prefix “DPA when I name the Campaigns. You will se why in a minute.

 

 

On your Dynamic Facebook Campaign Name always use an indicator (mine is "DPA")
On your Dynamic Facebook Campaign Name always use an indicator (mine is “DPA”)

 

 

In these ads the UTM parameters I use is this:

?utm_source=Facebook&utm_medium=cpc&utm_campaign={{campaign.name}}&utm_content={{ad.name}}

So the final URL where the prospect lands is this:

 

https://example.com/?utm_source=Facebook&utm_medium=cpc&utm_campaign={{campaign.name}}&utm_content={{ad.name}}

 

Now I go to my Google Analytics Account to spot the bad performers that waste my budget in order to exclude them from my catalog.

Go to Behavior > Site Content > Landing Pages

 

 

google analytics report behavior site content landing pages
Google analytics > Behavior > Site Content > Landing Pages

 

 

Then on the page that will load go to Secondary Dimension and choose Campaign

 

 

Landing Page Report > Secondary Dimension
Landing Page Report > Secondary Dimension

 

 

After that go to Advanced > Include > Campaign > containing > DPA

And press Apply

 

 

Put "DPA" on your Advanced Filtering
Put “DPA” on your Advanced Filtering

 

 

And now we have the gold report :D!

So what do we see here?

 

 

landing page report filtered by "DPA"
Landing Pages Report report filtered by “DPA”

 

 

We see landing pages that we send traffic through our Product Catalog Ads (“DPA” stands for “Dynamic Product Ads”).

We also see the Sessions, Transactions, Revenue & Conversion Rate.

(Exercise for you) In this report can you spot the worst performing landing page (row number)?

 

 

Yes! It’s the line 8.

Why?  Because we have 205 Sessions but 0% conversion Rate.

Meaning that we spend budget to drive traffic to that page but they do not convert!

We need to investigate why this is happening and either fix the landing page or exclude this product from our Facebook Product Catalog.

Amazing stuff! That’s the power of the UTMs

(Exercice for you #2) Can you spot some, less obvious, landing pages that underperform?

Yeap! You guessed it again!

 

 

Line 1 & Line 4

Why? Because the overall Conversion Rate for this campaign is 2.10% and they have 1.29% & 0.96%. So we need to investigate why this is happening. Since we have conversions the approach here is different, one way to proceed is to check if the pricing is correct and if the offer is easy to understand for the customer.

Now is your Turn! Harness the power of UTMs and Google Analytics!

Share with us what you found in the comments below.

👇 👇 👇

Categories
Analytics PPC Tips & Tricks

2 Reasons to have UTMs in your ads

2 Reasons to have UTMs in your ads

Reason #1: It shows you what marketing channel works and what doesn’t.

Then you can draw insights, and then you can do actions to fix or scale.

Let’s look at the data below.

 

 

source / medium Report on Google Analytics
source / medium Report on Google Analytics

 

 

This is the data from 15/11/2020.

Since we used UTMs in our ads, every Session, Transaction and Revenue that came from the Ads is attributed in the Facebook / cpc

Everything else (organic posts for example) is attributed into the other sources / mediums that end with the /referral.

This gives us clarity on data and we can draw insights from this report.

  • Why is the ads conversion rate so low? Maybe we need to check where we send traffic (landing pages)
  • Why is our revenue so high on organic posts (referral)? Should we ramp up our efforts there and create more content?

On the other hand let’s look at an account that does not uses proper UTMs

 

 

source / medium Report on Google Analytics only Facebook filter
source / medium Report on Google Analytics only Facebook filter

 

 

As you can see everything in the Source / Medium is attributed to referral (although the client runs ads).

With this we are not sure if these 2 Transactions came from ads or organic posts thus we are unable to take actions and as a result we cannot fix or scale anything.

Reason #2: Enables you to some high level Performance Marketing Tactics that are only able when you use UTMs

Let me give you an example from one of my campaigns:

If you run Catalog Sales Campaigns on Facebook you can argue that they are some of the most profitable campaigns you can run.

You upload a Facebook Product Catalog and the algorithm shows the products to prospects (or Website Visitors if you can installed the Facebook Pixel and used Remarketing Audiences)

But the downside is that you don’t know which products are shown!😨

So if the campaign has profitable ROAS that’s great news 👍! (still you don’t know which products sell better, so you can’t optimize)

But if the campaign has un-profitable ROAS you still don’t know which products perform poorly in order to exclude them 👎.

So what do you do?

You guessed it! You use UTMs

Let me show how.

How to Combine UTMs with your Google Analytics to get some super tricks to optimize your PPC efforts