Posts

Google Ads | Missed Search/Shopping Query Script

Intro As a PPC professional, you may spend a lot of time reviewing search terms in your campaigns, checking Google's recommendations tab for keyword ideas or using a keyword planning tool to look for queries you may be missing. If you're managing both search and shopping campaigns, there's an additional avenue for boosting traffic that you might be overlooking - analyzing whether you're serving shopping ads on queries without corresponding search ads, and vice versa. Google (& Bing) may serve a mix of search and shopping ads for a given query, or just one of these types of ad, so there's likely to be queries in your account that only appear on one ad type. Benefits When using this on an account, I found a whole stream of shopping terms that weren't appearing in search campaigns and was able to build out more keywords to boost my search campaign traffic. Given the nature of shopping campaigns, it was harder to get more queries for the campaign, but it did pro...
Post a Comment
Read more

GA4 Sheets Add-on

 With UA being sunset at the end of June 2023, here is a Google Sheets replacement for the UA Google Analytics Sheets Add-on that runs for GA4: https://docs.google.com/spreadsheets/d/1vlO5XhrYolG6prDA5cpKZhZJY7EcE-Kv0Zr_X5VAmZ0/copy All the code is open source in the Apps Script of the sheet and doesn't share any information to other people (unless you give other people access to the sheet). It uses the Google Analytics Data API, Google Analytics Admin API and Google Sheets API. The 'Config' tab is designed to be similar to the official sheets add-on for UA. The values entered need to use GA4 API values which can be most easily found using https://ga-dev-tools.google/ga4/query-explorer/ To use the sheet: Make a copy of the sheet above Read the 'Config Notes' tab Fill in col B of the 'Config' tab with details for your first report.  Fill from Col C onwards to get additional reports in the same spreadsheet Click the 'Run Reports' menu > 'Refresh...
Post a Comment
Read more