Europa Analytics 1st Steps Through the Reporting Environment

1. Europa Analytics1st Steps Through the Reporting Environment SAS Web Analytics – Web Report Studio

2. Key words to remember IPG Kiosk Europa Analytics

3. IPG • Information Providers Guide • a handbook webmasters, editors, content providers, web developers …https://webgate.ec.europa.eu/fpfis/mwikis/thinktank/index.php/IPG Google "IPG Europa"

4. Kiosk • Service on the IPG • Predefined reports • No special skills • Content • Reports by DG/Service • Configuration, and Month/Quarter/Year-ly Dashboard • Search DG/Service by url (when unknown DG/Service) • Visits & Page Views for an url (last 40 days)

5. Reporting tool When "Kiosk" cannot do.

6. Why are you here today • Understand the philosophy • Learn • Customisation of reports • Personalisation of the Portal ! Not covered • Creation of new reports • Analysing/Assessment of a website

7. Generate, Print and Export reports Modify and Save reports Search reports Customise reports Personalise your portal(make selected reports available via 1 click) Objectives of the training At the end of this session you will be able to:

8. Log in to the tool (ex. 1) Generate and Save reports while modifying parameters (ex.2-6) Searching reports (ex. 7) Add direct links to the Home page (ex. 8) Advanced modification of reports (ex. 9) Adding new page to your Portal and creating collection of reports (ex. 10) Schedule reports (ex. 11) QA time Coffee break Table of Contents

9. Exercise 1Log in to the tool (1/2) • IPG • A-Z index • "S"(statistics) • Reporting Tool Use LDAP credentials(alias “internet password”)

10. Exercise 2Generate a report Find the major trends for webmart “Commission 2010-2014” The logic behind: • Select the report 1st and then • Select the web-project (webmart) and other parameters Use a DashBoard

11. Exercise 2Generate a report

12. Exercise 2Generate a report • Check “Available data” • SelectQuarterly Dashboard in “Table of content” • Selectperiod (end month of the report – for which data is available!) • Select Site (webmart) • Check that the sub-site is empty

13. Exercise 2Generate a report

14. Exercise 2Generate a report

15. Exercise 2Generate a report

16. Exercise 2Generate a report

17. pdfButton Print > print (read export) to pdf xlsButton Export > exportsto MS Excel Exercise 3Export reports (pdf, Excel) Let’s try them

18. Exercise 4Save the modifications Save the report for later use The logic behind: • The report (in SASWA) is just a query • Save your customised report(s) to re-run them again and again (keeping the same parameters) File > Save As

19. Exercise 4Save the modifications

20. For later use Save to My Folder Change Name Update Description Exercise 4Save the modifications

21. Exercise 5Modify (more) parameters Prepare the report for the major trends on the Barroso (Commission 2010-2014) pages The logic behind: • Modify the parameters of the report • Save it for later use Refresh data & Choose Subsite

22. Exercise 5Modify (more) parameters

23. Exercise 5Modify (more) parameters Now save the report in “My Folder” Give it a “good” and “meaningful” name & description

24. Exercise 6Choose URL Prepare the report for the major trends on the Barroso News Corner (Commission 2010-2014) The logic behind: • Modify the parameters of the report • Narrow the selection for a specific url • Save it for late use Refresh data & Choose URL (… /commission_2010-2014/president/news/ …)

25. Exercise 6Choose URL Wildcard character • can be used in "LIKE" expressions • the percent sign (%) matches zeroor more characters Webmart: Commission 2010-2014Section: Barroso URL: %/news/%(for ec.europa.eu/commission_2010-2014/president/news/…)

26. Exercise 7Search for (customised) reports Re-use the customised reports The logic behind: • Search for saved reports • Execute them Search for a report (content type) (Search link is at the Homepage)

27. Exercise 8Personalise “Home” page Make the customised reports easily available The logic behind: • Add the customised reports into “My collection” at your “Home” page Use the “edit content” at My collection (portlet)

28. Be at the “Portal” Be at the “Home” page in your Portal Click “Edit content” button at the “Home” page Exercise 8Personalise “Home” page

29. Exercise 8Personalise “Home” page Search for ‘SAS report’(Add > Done)

30. Exercise 8Personalise “Home” page • Report(s) now appear(s) at your “Home” page in “My collection” (portlet) • Let’s try the report(s)

32. Review • Customisation of reports • Simple adaptations • Customisation of your “Home” page • Editing collections of reports Save (“save as” in My Folder) Refresh Data (for Reports)Edit content (Portal personalisation)

33. Exercise 9 Advanced customisation of reports • Want to know number of the page views by month • For Commission 2010-2014: Barroso ‘Page Usage Reports’ (collection)Check the Webmart Properties

34. Exercise 9 Advanced customisation of reports

35. Hide useless information(i.e. Server error column) Exercise 9 Advanced customisation of reports

36. Edit report for more changes at once … Exercise 9 Advanced customisation of reports

37. Assign data to the table Exercise 9 Advanced customisation of reports

38. Exercise 9 Advanced customisation of reports • Select all data types and move them to “Hidden” • Move to “Columns” only what you want to display • and save new report for later use Want to know number of the page views (per month)

39. Review • Refresh data - to change some parameters • Hide columns - to keep only relevant • Sort columns - to get right information • Modify/Create report

40. Exercise 10Add new page to your Portal • Add the page • Edit the content • Add the portlet (container of the collection of reports) • Add reports to the portlet

41. Exercise 10Add new page to your Portal click “Add”

42. Exercise 10Add new page to your Portal • Now a new page was added to your Portal • Add a content to it via Options > Edit Page Content • Select Portlet type: Collection Portlet(and “add” then “done”)

43. Exercise 11Scheduled reports • Dashboard reports can be scheduled and sent by email • New scheduled reports can be easily added via 'My scheduled reports' page or via 'Schedule Report' button via Dashboard Reports:

44. Exercise 11Scheduled reports • Add title, select report type, period, webmartand any section and URL to include/exclude… • Type email address (more email addresses can be inserted) • Choose interval and first time date • Save and schedule report

45. Review • Personalisation of your “Portal” • Creating and editing pages • Creating and editing collections of reports • Customisation of reports • Modifying tables, • Modifying texts • Adding new elements (tables, graphs, texts) • Scheduled reports

46. Product philosophy • Customise reports (and save them) • or create new reports (not presented) • Scheduled reports (to be sent at given times) • Personalise the Portal • Organise content by creating collections and pages for easier access

47. Useful links • Practical users' guide: http://www.cc.cec/home/europa-info/documents/europa_analytics/ea_quick_user_guide.pdf • EA on IPG: http://ec.europa.eu/ipg/services/statistics/index_en.htm • EA ThinkTank: https://webgate.ec.europa.eu/fpfis/mwikis/ThinkTank/index.php/Category:Europa_Analytics • Standard reports (kiosk): http://www.cc.cec/home/europa-info/services/statistics/standard-reports_en.htm

48. COMM EUROPA MANAGEMENT Questions?