Events Matching Validation Report

This report will identify the percentage of events pulled from each of the secondary exchanges that match up to StubHub events.

Author
1. Juvil John Soriano
Presentation Medium
1. SSRS Portal
Fields (Data)
1. Summary
  1. Ticket Exchange
  2. Total Events Count
  3. Total Events Matched
  4. Percentage Matched to StubHub
2. Ticket Exchange
  1. Event ID
  2. Event Name
  3. Venue Name
  4. Event Date
  5. DateTime Last Pulled
Grouping
1. N/a
Intentions for printing vs. online viewing
1. The report is delivered via SSRS
2. This report can be accessed here: TBPortal → SSRS Reports → Events Matching Validation Report
Intended delivery mechanism (run on demand vs. delivered by subscription)
1. On Demand
Future maintenance tasks or manually maintained items
1. N/a

The data source for this report is the STG Database.

Stored Procedure:
[reporting].[GetEventsFromSecondaryExchanges]

Filter Name	Description

Filter Name	Description
Event Name	This field displays a calendar to which you can select the desired starting date.
Venue Name	This field displays a calendar to which you can select the desired ending date.
Event Date From	Lets you input specific PO amount to show.
Event Date To	Lets you input specific PO number to show.
Result Options	Check mark list which lets you choose customize the report to generate. Options includes: Include Matched events, Eibox Office events Only, Seat Geek events Only, Stubhub events only, Ticket Evolution events only

Data Governance