This is a useful tool as it allows you to see which advert is providing you with the initial call/enquiry.

This allows you the ability to track your sales made during a period of time, against the calls received on the Service Numbers (dynamic and static) to accurately match all adverts which influenced the sale.

You must be able to extract a Excel output from your own CRM system, the file extension can be csv or any valid Excel format.

The file must include at least one column containing telephone numbers.

If the telephone numbers in the file are from different countries, we would recommend to add all international dialling codes (including UK) in order to maximise matches.

The file you upload should not be password-protected.

How to use Track Sales

Log in to your Mediahawk account 

Click Admin then go to the Integrate > Track Sales.

Step 1. Upload your data spreadsheet

Please ensure the first row of your spreadsheet contains the column headers.

Click Browse to locate your file on your local disk then click Upload

Step 2. Define analysis options

Select the Call Period Start and End: this is the date range that would be checked for possible matches

Advanced Settings: click Show if you would like to make any changes however you should not need to. 

Output file extension: we will match the extension of the uploaded file. Use the drop-down if you would like a different file format.

Show all calls: this is the recommended setup to ensure all calls are matched to your telephone numbers in the file.

Choose whether you want to Match on time and/or Allow time difference, however these can be left as they are (un-selected).

Select which information you would like to see in the output file: some of the below will only populates based on the Mediahawk services you are subscribed to

Show destination number in output file: if you do not wish to see where the call connected in your business, untick this box

Show first visit date in output file & Show first click source/medium: available for dynamic only

Show media owner, Show media channel and Show department: available for static only

Step 3. Map columns

Match the column headers in your spreadsheet to the appropriate fields below: 

At least one phone number column must be identified but all other columns are optional

We can match up to 3 telephone numbers 

Once you have made your selection, click Analyse

When this is completed, click Download results then Open the file or Save File

Please note that the information obtained in the analysis is not stored in Mediahawk, it produces an output only, which you can save on your local disk.

The data obtained for Ad Description will look something like this:

For Dynamic

Last Source: google, Last Medium: organic, First Source: direct, First Medium: direct, Keyword: No keyword, Number Set: Number set name (15/07/2017 - 09:32:43) Destination number: 0123456789 First visit: 05/07/2017 - 11:06:44     

For Static

AdWords BT (05/07/2017 - 09:55:17) Destination number: 0123456789   Media Owner: Google PPC  Media Channel: Online Department: Sales