How can I see the clicks for all of my active Power URLs?
For the user to see this information, support must create a Custom Report. This is not available in versions prior to 7.1.x.
Please check with your supervisor for the current requirements/rules for charging customers for a Custom Report. When replying to requestor, use the response in the Active PowerURL Clicks related troubleshooting entry.
The following are the settings to create the Custom Report for this request.
** QUERY TAB **
Name: Active PowerURL Clicks
Description: All clicks for Power URLs marked as active sorted by date.
select power_url_id as id, event_date as click_date, group_name, code, url from power_url_data pud, power_urls pu where pu.id = pud.power_url_id and pu.realm_id = %%$realm_id%% and pu.active = 1 order by group_name, code, url, click_date desc
** OBJECTS TAB **
** COLUMNS TAB **
** ASSOCIATIONS TAB **
** FORMATS TAB **
Include header: Yes
Quoted Fields: Yes