Sum up campaigns with RegEx

One last task has been assigned to you by the digital marketing director. The digital marketing director would like a report of all the campaigns, regardless of source or ad group.

Aggregating campaign totals using regular expressions is so useful because of the variety of sources that campaigns can come from. For example, you may be looking at two different digital marketing firms: one for search engines (Google & Bing), and the other for social media (Facebook). All of this data would be entered by the two different parties into a single table.

In this exercise, we will explore how to get the total cost and cost-per-click (CPC) for each campaign, regardless of source.