Building Reports: Blended Reports

Follow these instructions to build a blended report:

  1. Click on “Custom Reports” under the “Reports” section on the left sidebar

  2. On the “Reports” page, click on the “Blended” tab in the top navigation panel

  3. Click on the “Actions” button in the top left section, to the left of the search box. On the drop down menu that appears, select “Create blended report” 

  4. On the “New Blended Report” screen that appears, enter the following:

  5. Step 1 of 3:
    1. Report name - Enter a report name
    2. Select reports - You will need at least two reports to create a blended report. The ordering of the reports is important for determining the connector type.
      1. Report type - Select the report type from the drop down menu.
      2. Report name - Copy and paste the source report.
    3. Click the purple “Continue” button.
  6. Step 2 of 3:
    1. For each of the selected source reports, click to select the columns you’d like to be included in the final blended report. Once you have clicked the column header name, it should change from a white to a gray button color.
      1. Optional: You may also choose to add “Filters” if needed.
      2. Repeat for each source report.
    2. Connections:
      1. Join - Select the join type
      2. Select the columns to join from each of the reports. Click on “Add Connector” to add more connectors between the reports.
      3. Note: Depending on the connector type, you may need to merge columns. For example, if you want to use a “Full Join” and the two reports both contain a month column, you’d want to define a merge.
        1. Click “Add merge pair”
        2. Select the column from report 1 in the first drop down
        3. Select the column from report 2 in the second drop down
        4. In the text box to the right of that 2nd drop down, enter a new column name. This will be what you select when you define columns in Step 3.
      4. Repeat for each connection to be defined.
      5. Click the purple “Continue” button.
  7. Step 3 of 3:
    1. Extraction / Grouping - In this section you’ll be selecting the columns you’d like to include in your derived report and applying data transformations as needed.
      1. Name - Select the column from the data source 
      2. Process - Select the data transformation you’d like to apply to your selected column. Here are the various types of data transformations:
        1. No process - Default
        2. Querystring extraction - Extract a part of the string value found in the selected column
        3. Substring - Extract a part of the string value found in the selected column
        4. Substring replace - Basically a find and replace transformation, enter the starting value to find and velue to be replaced with in the selected column
        5. Values - Enter the text value (in quotes) to be counted in the selected column
        6. URL path
        7. Date - Transforms and extracts only the date of the value in the selected column
        8. Date/Time - Transforms and extracts only the date and time of the value in the selected column
        9. Time - Transforms and extracts only the time of the value in the selected column
        10. Year - Transforms and extracts only the year of the value in the selected column
        11. Month - Transforms and extracts only the month of the value in the selected column
        12. Week - Transforms and extracts only the week of the value in the selected column
        13. Json parameter - Enter the parameter name for the value to be extracted 
        14. Avg - Averages the values of the selected column
        15. Min - Displays the minimum value of the selected column
        16. Max - Displays the maximum value of the selected column
        17. Sum - Aggregates the numeric values of the selected column
        18. Count - Counts the entries of the selected column
        19. Cardinality
    2. Metrics - In this section you’ll be defining calculated metrics
      1. Name - Enter the name of the calculated metric
      2. Calculation - Enter the column names and the formula. Use the following:
        1. Addition: +
        2. Subtraction: -
        3. Multiplication: *
        4. Division: /
  8. Click "Save" to generate the report.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us