Anita Owens

View Original

How to heatmap PPC keyword data in R

If you work at a company that uses Search Engine Marketing (SEM) for traffic acquisition, then the most important aspect of your work is analyzing how your ads perform. The success of your campaigns rely on the keywords customers are searching for.

If you want to optimize your Pay-Per-Click (PPC) ads, you need to track which keywords are performing well. I found that heatmapping my top performing keywords was super helpful. Visualizing your data can quickly give you a birds-eye view of how well your keywords are converting in relation to impressions, cost, cost-per-conversion, etc... 

So, here we go.

See this content in the original post
See this content in the original post

NOTE: If your keywords report spans across multiple campaigns that use the same keywords, you can use the make.names() function to make each row unique like so:

row.names(keywords)<-make.names(keywords$keyword, unique = TRUE)

See this content in the original post
See this content in the original post
See this content in the original post

Now you have your keyword data heat mapped! Happy analyzing!