• Replies 1 reply
  • Subscribers 168 subscribers
  • Views 248 views
  • Users 0 members are here
Options
Related

Analytics & Attributes

Celia Beer
$organization

Hi all

Is there a way of using Attribute information in Analytics? For example, when our Members submit their priority booking form it logs an attribute for us. I'd like to be able to report on this is possible! 

Thanks
Celia

  • $organization

    Hi Celia,

    You can us a Custom Category constituent element in TX_ANALYTICS_DIVISION_ELEMENTS to pull this into Analytics. You can find more detail in this section of the help system and in Part 2 at 11m:30s of this video.

    To find the details of the Attribute, reference the T_KEYWORD System Table, filtered for the name of the attribute. 

    For the element, in TX_ANALYTICS_DIVISION_ELEMENT, one would update one of the Custom Category by setting:

    • data_select: MIN(key_value)  --or whatever column is referenced in the T_KEYWORD Detail Col field (without any "!.")
    • data_from: dbo.TX_CUST_KEYWORD q --or whatever is in the Detail Tbl column of T_KEYWORD
    • data_where: keyword_no=123 --updated to the Keyword No from T_KEYWORD

    Then on the day after configuring this with a successful Analytics load overnight, you'd be able to filter your Analytics dashboards, widgets, and formulas by this Custom Category in the context of any data source.

    Best,
    Chris