To link in Google Analytics to CallPotential for metric tracking
Option 1 - Manually:
- Access the Tracking numbers page
- Find the number that you wish to tie in to Google Analytics
- Click the edit button next to that number
- Put in the Webhook URL and Parameters
- In the Webhook field, paste in the link from Google Analytics: http://www.google-analytics.com/collect?v=1&tid=UA-4472484-1&t=event&ec=Call&an=CallPotentialTracking&ni=1&
- Below that, populate the parameters box
- For the first field, put in the name of the parameter as you wish to define it
- For the second field, select the system variable that this parameter will tie to
Option 2 - SQL:
Add Google Analytics via SQL by setting the Webhook and Webhook parameters in one query for a given tracking number:
Code Block language sql UPDATE trackingnumbers SET webhook_url='http://www.google-analytics.com/collect?v=1&tid=UA-4472484-1&t=event&ec=Call&an=CallPotentialTracking&ni=1&', webhook_params='[{"param_name":"lead","system_variable":"{system.LeadID}"},{"param_name":"el","system_variable":"{system.AdName}"},{"param_name":"cs","system_variable":"{system.AdName}"},{"param_name":"cm","system_variable":"{system.AdName}"},{"param_name":"cid","system_variable":"{system.CustPhone}"},{"param_name":"cd2","system_variable":"{system.LocEmail}"},{"param_name":"ea","system_variable":"{system.LocEmail}"},{"param_name":"cd6","system_variable":"{system.CustPhone}"}]' WHERE call_number=1XXXXXXXXXX