We have developed a new solution for fetching pay-per-call advertising data from the Marchex API to Excel with a set of VBA functions. This provides a great deal of flexibility for pay-per-call campaign analysis, as you are no longer tied to the built-in Marchex reports. It’s also simple to combine the campaign metrics with data from other sources (for example, Google Analytics data, or sales data from your internal systems).
- Number of Calls
- Unique Leads
- Domain Referrals
- Ad List
- My Numbers
The data can be split by various dimensions; for example, you can fetch the number of calls by date and by campaign. There are many other dimensions available too, such as:
- Call status (answered, hang-up, etc.)
- Caller name & number
The functions are used in the same manner as our Google Analytics and AdWords functions – they can be used directly on the worksheet like any of Excel’s built-in functions. This makes it very easy to build dashboards that combine pay-per-call data with other metrics such as web analytics or PPC data – all that is required is some basic Excel skills (no VBA knowledge is necessary).
You can test the functions using this file (there’s a free 14 trial)