So, you wanna be able to identify traffic from Google My Business when you’re looking at your stats in Google Analytics. But you also happen to be using Yext. And, of course, Yext appends a parameter (y_source) to your URL in order to be able to track the traffic not only from your Google My Business listing but from all other sites in the Yext network, as well.
Google Analytics: Get Back ISP, Service Provider, and Network Domain
In Google Analytics, you used to be able to see the “service provider” and “network domain” (also referred to as …
Google Ads: Dynamic Retargeting for Automotive Dealers (with Google Tag Manager)
There are eight steps to setting up a dynamic retargeting campaign in Google Ads. Create an inventory feed Upload your …
The Ultimate Google Sheets Formula to Join Two Tables
If you were stranded on a desert island, this is the Google Sheets formula you’d want to have with you. …
Search Ads 360: How to Change a Recurring Budget Plan
How do you change a recurring budget plan in Search Ads 360’s Budget Management tool? What if you want to make a temporary change to a budget plan? What happens if you make a change to next month’s budget plan? If you’re struggling as I did to wrap your head around SA360’s recurring budget plans, perhaps this post will help.
Google Analytics: Filter Facebook Ads Bot Traffic from Irvine, CA
Got Facebook Ads traffic coming from Irvine, California? Chances are you’re being hit by a bot. Here’s how to exclude that traffic from Analytics.
Google Sheets: How to Remove Headers from QUERY Result
The Google Sheets function “QUERY” is one of the handiest functions in a Google Sheets wizard’s toolbox. And one of the great things about QUERY is that it can interpret the first row of data as a header row. But what if you don’t want the header row at all?
How to Name a Column in Google Sheets
Yes, you can absolutely name a column and use the column name in your formulas instead of the the usual A1-style column reference. Here’s how.
Google Sheets: Combine Multiple Ranges / Sheets into a Single Range / Sheet
Sometimes you’ll have multiple separate ranges or columns or even entire sheets that you’ll want to “stack” on top of each other (i.e. append one or more to another) so that you end up with a single huge master range. Here’s how you achieve this.