All the people that we dedicate ourselves to the marketing, we use a lot the heat maps when analyzing data and being able to make decisions in a more visual way. These help us to make it much easier to visualize the data in an intuitive way and are especially good to see how it changes, for example, the buying habits during each hour of the day and the seven days of the week, something almost impossible with a number table.
Over the last few months, we have been analyzing the possibilities of using AdWords Script to improve the management and optimization of our account and today I will tell you how to create a heat map of an AdWords account.
Tabla de contenidos
Very simple, this script automatically obtains the data of our account, according to the period of time that we have selected and analyzes the totals of each hour of the day and of all the days of the week, then shows them in a GOOGLE spreadsheet And it shows us the form of a heat map, the impressions, clicks, conversions and bid modifiers.
For now, take a look at a new way to analyze what is happening in our AdWords account during the 24 of the day. Then I recommend that you select different periods of time, to analyze the evolution of conversions and metrics in general, to evaluate how the account has been changed in recent months. You will also be able to configure, as explained in my last post, a bidding adjustment for every hour of the day so that we can be more efficient in our investment.
This depends a bit on the type of industry and sector in which we are, because in some cases make a comparison Month to month (MoM), however other sectors more seasonal, we should buy the period with the same year before or even Make an income estimation and growth year by year (YoY).
For the script to provide us with aggregate information and with which we can make appropriate decisions, we should have a minimum of 6 to 8 weeks and a high volume of conversions for our industry. If you want, you can do tests with different periods of time and compare the results obtained, to see if there are big differences.
To use the script correctly, you should first make a copy of this document to have it in your Google Drive account and that must be the same one that has administrator or standard access in Google AdWords.
If you are still not familiar with AdWords scripts, I recommend reading the article, where we explain in detail, how to start step by step, with the Different scripts.
After having made a copy of the template, we should enter the script that we have below in our AdWords account and configure the following parameters:
Once the basic configuration is done, you can run the script and you will have your first heat map of your AdWords account.
If you have any question, you can write a comment or contact us and we will help you for free to configure your scripts.
SEM · 20 / 09 / 2016
SEM · 16 / 01 / 2020
Tabla de contenidos1 1. Auction Insights (Comparison of auctions)2 2. SpyFu3 3. SEMRush4 4. iSpionage5 5. KeywordSpy6 6. Moat7 7. Adbeat8 8. Similarweb9 9. Minderest10 10. Boardfy11 11. Prisync12 12. Kompyte13 13. Facebook Ad Library14 14. Google Trends 1. Auction Insights (Comparison of auctions) The first of the SEM tools in the list we have within the Google Ads interface itself. Through the Auction Insights or Comparison of auctions, we […]
SEM · 09 / 01 / 2020
Whether you have just landed in the world of Google Ads (former Adwords) or if you are an experienced Account Manager, it is always good to have a guide with the updated terms of the PPC world at hand. In addition, this Google Ads dictionary will serve as a refreshment and help to understand many […]
SEM · 05 / 12 / 2019
You may think that we still have time to finish the year, but the truth is that we are getting closer to 2020. From what we have seen during this year, which has been full of changes and news, we should pay attention to the SEM trends that will govern in 2020 and the new […]
Send this to a friend