I want to find a way to create separate tables and reports for individual operational units?

Hi all,

I currently have a single report generated for the whole organisation which consists of 12 BUs. I want to filter the report for each BU. I've opted for csv format which allows me to filter and recreate individual tables and graphs for each BU. At the moment this can take 3 days or more, :o(
Is the only solution to create a profile for each BU or is there another better option?
1 person has
this question
+1
Reply
  • The simplest way is indeed to create separate profile for each BU.

    Another way is to create custom tables in Options > Report > Tables. The question here is what tables you wish to generate separately for each BU. Creating separate table(s) for each BU will be very time consuming, but you may create a grouped table similar to the "Browsers > Browser and OS" and "Referrers > Engines and Phrases" ones, that can allow you to get statistics separately for each BU.

    If you provide more information on what tables you need and how BUs can be recognized in the reports (IPs, URLs, etc), I'll post more specific instructions on how to create these tables.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Hi Michael,

    I think creating grouped tables could work, the custom table is currently how it is being done manually from the csv report. The grouped will be a more permanent solution. I need Pages, Files and Documents tables. Each BU is recognised by
    the third field in the url path e.g. http://thetestsite.co.uk/first level path/BU and the same for documents e.g. http://thetestsite.co.uk/ documents/BU/

    Please let me know if you need more information.
    Thanks in advance.

    Steve
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • You can create the tables you need in Options > Report > Tables (it requires the Professional or Enterprise edition). The simplest way to create a table is to copy an existing one. E.g. you can select the Access Statistics > Most Popular Pages table, and click the "More > Copy table" command.

    On the first page you can change the table name. On the second page ("Data") you need to choose "Directory" as "group by" data. In this case files will be grouped by directory. However, as you need to group not by full directory but by BU name, you need to click the "Custom..." button to the right of the "Group by" combo box.

    Here you can specify the rules to transform the directory names. There are several rules modes supported, including simple match, wildcards and regular expressions. You can find detailed description of the modes by clicking the Help button in this dialog or at http://www.weblogexpert.com/help/wlex.... The regular expression mode is the most complex but also the most flexible. E.g. you can enable the modification rules and enter the following ones:

    ^/documents/(.*?)/.* ~= \1

    You also need to enable the "Show file names instead of full names" in the same window to show BU names not as URLs.

    The expression above works if the top-level folder is "documents". If you wish to make it working for any first-level folder, you can use the following expression instead:

    ^/.*?/(.*?)/.* ~= \1

    Please let me know if you need more information on creating tables that will let you get information you need without necessity to use external tools to post-process it.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • I created custom tables as suggested with a few tweaks, I have a table for docs and html for each BU.

    Thanks for your help.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned