This article provides details on Talent Card downloads, including information about who downloaded their talent card (country, position title, name of employee) and when they downloaded it.

From the Analytics DB - profile_v1 table, use the following query:

SELECT
    l.viewer_profile_id downloaded_by_profile_id,
    ev.employee_email downloaded_by_email,
    ev.first_name downloaded_by_first_name,
    ev.last_name downloaded_by_last_name,
    ev.location downloaded_by_employee_location,
    ev.title downloaded_by_employee_title,
    et.location talent_card_employee_location,
    et.title talent_card_employee_title,
    et.first_name talent_card_employee_first_name,
    et.last_name talent_card_employee_last_name,
    l.t_create download_at

FROM
    (SELECT * FROM datashare_log.public.www_server_log WHERE group_id = 'groupid') l
    JOIN groupid_analytics.groupid_employee ev ON l.viewer_profile_id = ev.profile_id
    JOIN groupid_analytics.groupid_profile pt ON split_part(request_path, '/', 6) = pt.enc_profile_id
    JOIN groupid_analytics.groupid_employee et ON pt.profile_id = et.profile_id 


WHERE
    l.namespace = 'career_hub'
    AND l.event = 'download_talent_card'

Example query for above : Talent card download details