Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

CDR - DID Tracking

Discussion in 'Ideas' started by Futureweb, Dec 10, 2015.

CDR - DID Tracking 5 5 7votes
5/5, 7 votes

  1. Futureweb

    Futureweb New Member

    Joined:
    Jun 29, 2015
    Messages:
    163
    Likes Received:
    17
    For CDR - please add a Field "to-did" - would be important for Tracking Marketing effectiveness.
    As described here: post175796.html

    Feature Description:
    We need to track DIDs for Marketing Effectiveness Tracking.
    Every Advertisement we do got its own DID.
    Within 3CX incoming Rules are configured 012345678* (Number + *) - so all of those Marketing DIDs are Routed to the same Queue.
    Now my Problem is that I don't see the called DID (called Number) within the CDR nor within the LOGs ... it just shows me the Extension of the reached Queue/Phone which picked the call - but never the *called number* / *called DID*
    We can't create an incoming Rule/Extension for every DID used for Marketing as they change to often / are way too much / often are not known outside Marketing Dept. (Thousands/Ten Thousands of Numbers ...)


    Thank you
    Andreas Schnederle-Wagner
     
    scsllc likes this.
  2. Futureweb

    Futureweb New Member

    Joined:
    Jun 29, 2015
    Messages:
    163
    Likes Received:
    17
    to be a bit more specific - we would need "Request Line URI : User Part" somewhere in the CDRs ...
     
  3. Hellkeeper

    Joined:
    Dec 10, 2015
    Messages:
    1
    Likes Received:
    0
    We would also need this Feature to track the success of our Google AdWord Campaigns ... different Campaigns got different Phone Numbers + unique DIDs ... but now with 3CX we are not able to log those calls anymore ... which was no Problem with out old PBX ... would all be solved if "Request Line URI : User Part" could be added to CDRs.
     
  4. Cadonline

    Joined:
    Dec 25, 2015
    Messages:
    2
    Likes Received:
    0
    Would be a welcome Extension! Right now we get a List of called (inbound) Numbers from our SIP Provider for this - Once a month.
     
  5. ManuelR

    Joined:
    Jan 21, 2016
    Messages:
    4
    Likes Received:
    0
    Hello,
    we use this kind of functionality within our current hardware-based PBX.
    As we evaluate 3CX for replacement to our old PBX this is a Feature which is crucial if we want to Switch!
    Manuel
     
  6. Futureweb

    Futureweb New Member

    Joined:
    Jun 29, 2015
    Messages:
    163
    Likes Received:
    17
    For now we "emulate" this Behaviour ... on Trunk Settings Page - Parameters for incoming Connections --> "CallerName" caller's name (default: From->display name) set to "Request Line URI: User Part"
    Then the Number called can be found within CDR Logs ...
    But it would be better to have an own Field for that Information ...

    Andreas
     
  7. ManuelR

    Joined:
    Jan 21, 2016
    Messages:
    4
    Likes Received:
    0
    @Futureweb: tried your workaround and it's working like a charm!
    Just had to reprovision all Yealink Phones so they don't show the called number that big (that's the downside of this workaround)

    But I still hope they will add "Request Line URI : User Part" Field to CDR.

    Manuel
     
  8. dig1234

    Joined:
    Jun 1, 2015
    Messages:
    75
    Likes Received:
    0
    The other way to gather this information currently is thru the API with your own logging system..
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. Futureweb

    Futureweb New Member

    Joined:
    Jun 29, 2015
    Messages:
    163
    Likes Received:
    17
    @dig1234: How would you do this in V14? Could you post some Details?

    Andreas
     
  10. dig1234

    Joined:
    Jun 1, 2015
    Messages:
    75
    Likes Received:
    0
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. Futureweb

    Futureweb New Member

    Joined:
    Jun 29, 2015
    Messages:
    163
    Likes Received:
    17
    alright - thx for information ... but way to complicated ...
    I hope they add it to CDR Output .... guess this is a matter of minutes to implement ...

    Andreas
     
  12. dig1234

    Joined:
    Jun 1, 2015
    Messages:
    75
    Likes Received:
    0
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  13. ManuelR

    Joined:
    Jan 21, 2016
    Messages:
    4
    Likes Received:
    0
    This would require a whole .NET/C# Project - that's way to complicated for a requirement like this - none of our customers would pay for that!
    It's really a shame there is no way to do this with 3cx! (without workarounds like the one Futureweb posted)
     
  14. Futureweb

    Futureweb New Member

    Joined:
    Jun 29, 2015
    Messages:
    163
    Likes Received:
    17
    Just noticed a major Problem with this workaround ... if the caller number is already within 3CX phonebook - CDR won't show the called number - but instead it will show the name from the phonebook ...
    This renders this workaround useless for already known numbers ...

    Andreas
     
  15. ManuelR

    Joined:
    Jan 21, 2016
    Messages:
    4
    Likes Received:
    0
    Did you find any solution for this problem?
     
  16. Futureweb

    Futureweb New Member

    Joined:
    Jun 29, 2015
    Messages:
    163
    Likes Received:
    17
    Unfortunately no really Solution on this Problem! We just stopped using the 3CX Phonebook ...
    Only using the Yealink Phonebooks anymore ...

    I'm still hoping 3CX will implement "Request Line URI : User Part" within CDR Output ... guess it would be a matter of Minutes for them ...

    Andreas
     
  17. 3CXusername

    3CXusername New Member

    Joined:
    Jul 31, 2014
    Messages:
    183
    Likes Received:
    16
    i'm still on 12.5 but looking to upgrade to v14 shortly. Could someone post a sample v14.x CDR output so I could compare?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  18. Futureweb

    Futureweb New Member

    Joined:
    Jun 29, 2015
    Messages:
    163
    Likes Received:
    17
    You can find all information about CDR in V14 here: http://www.3cx.com/docs/cdr-call-data-records/
    It's simply a CSV File or Stream you can use

    Sample Output: Call 18982,00000BE960FE3D85_12261,0.00:00:23,2016.01.11 10:42:40,2016.01.11 10:42:48,2016.01.11 10:43:12,TerminatedBySrc,Ext.7400,06601010101,7400,10000,06601010101,,,,,0,1,0,04,ÖSTERREICH-Mob,Chain: Ext.7400;06601010101;,Extension,Line,,Andreas,06601010101,

    Unfortunately not all needed informations are included ... that's why this Ticket exists ...

    Andreas
     
  19. Futureweb

    Futureweb New Member

    Joined:
    Jun 29, 2015
    Messages:
    163
    Likes Received:
    17
    any chances "to-did" will be added to CDR?!?
     
  20. kbx81x

    Joined:
    Dec 15, 2015
    Messages:
    3
    Likes Received:
    0
    ^^^ I second (third? fourth?) all this. We are also looking for this information in the CDRs. Similar to the others, the information is needed for marketing data tracking purposes...