Apr 28, 2022
In Welcome to the Forum
Suppose you select a date range of a Special Database week (Monday to Sunday) 3 months ago and find the following number of search terms: Search terms google ads In this account, almost a hundred thousand unique search terms were matched in that week (assuming there are no duplicate search terms). After this, you continue to select the Special Database following week until you encounter an outlier. And believe me, there is often. After 7 weeks, I saw the following number of search terms: Search terms Google Ads In this case, it is a significant outlier downwards. But it can Special Database also be a doubling, for example, which entails extra costs and little or no extra revenue. It may also be that little or nothing has Special Database changed. In that case, usually not much has been changed to the account and you can sleep well tonight. These kinds of fluctuations contain a wealth of insights. But you Special Database will also have to dig for this treasure. So for those who would rather be lazy than tired, here is the step-by-step plan: Download a search term report Download a search term report of x number of days before the drop and x number of days after the drop. For example, you can start with 1 month to see if there are Special Database big differences, and then choose shorter and shorter date ranges. This way you can find the exact day(s) when major changes took place. Match the number of days and Special Database weekdays. So for example Monday to Sunday before the search term change and Monday to Sunday after the search term change. Also take into account any seasonality or sales periods in your industry. Do you work for a large company? Then you can choose to reduce the data size by filtering Special Database on more than 3 impressions. If you don't, Excel will put your patience to the test (and most of us aren't angels at all). After downloading your two search term reports, merge them into an Excel file, as in the example below: Excel Report Getting started with VLOOKUP's After this we will get Special Database started with VLOOKUP's . This allows you to find terms that occurred before the decline in search terms, but not after.