 |
|
|
| Advertisement Status For Multiple Advertisement IDs |
|
|
|
By: Don Hite
Posted On: 6/26/2008
This SQL query will allow you to retrieve Advertisement information for multiple advertisement ID’s.
SQL Query:
Select
OfferName Name,
Recieved,
Failures,
ProgramsStarted Started,
ProgramsFailure Errors,
ProgramsSuccess Success,
OfferID 'Advertisement ID'
From vOfferStatusSummarizerRoot
Where ScheduleToken = '0001128000080008'
And OfferID In ('XXX12345', 'XXX67890')
Order by OfferName
|
|
|
|
|
