Hello Lee and Matt,
So it’s going to take me the rest of the day to port over the reports sections to the new solution.
In the mean time I have outlined below the URLs that you will be calling and have included a JSON file you should be targeting.
You should try to program against this JSON object and stub out the actual call to the backend, once the port is complete you can fill out the stub to go directly to the back end and you will receive the same expected JSON.
For advertiser reporting :
/api/reports/advertiser?productType=socialViews&queryType=order&queryId=100& start=04-08-2014&end=04-14-2014&breakout=daily&page=1&limit=25
For publisher reporting :
/api/reports/publisher?productType=socialFlex&queryId=100& start=04-08-2014&end=04-14-2014&breakout=daily&page=1&limit=25
Both publisher and advertiser routes will return the same JSON structure.
These routes are the same ones used by both the reporting sections and the dashboard sections of the current PX.
This is the general outline:
In this structure the first node is a summary of all of the records below it. The next node is an array of all of the corresponding records. Each record will represent a grouping based on the time duration you specified in the breakout query parameter, its either daily, weekly or monthly. The last nodes Total and interval let you know how many total records there are and what breakout you choose as part of the query. The total helps for paging purposes, if you passed a limit of say 100 and there was a total returned of 300, then you know that there are still 2 more pages you can query data for which you specify with the page query string parameter.
{
Summary : [
{"TotalReach":0,"TotalDuration":4305,"TotalSessions":226,
"VisibilityBrixCount":241,"VisibilityStandardCount":268,
"VisibilityBrixRate":0.7700,"VisibilityStandardRate":0.8562,
"Frequency":0,"ProductType":"socialFlex","TotalUniques":0,"TotalOpportunities":0,
"Opportunity":0,"TotalInitiatedUsers":0,"TotalImpressions":618,"AvgTimeSpent":19.0487,
"TotalClicksToSite":53,"TotalVidStarts":273,"TotalVid25Quartile":231,
"TotalVid50Quartile":149,"TotalVid75Quartile":115,"TotalVidCompletes":108,
"TotalRewardConfirmsYes":0,"Vid25QuartileRate":0.8462,"Vid50QuartileRate":0.5458,
"Vid75QuartileRate":0.4212,"VidCompleteRate":0.3956,"CTR":0.0858,"OptInRate":0,
"TotalVideoInteractions":0,"TotalVideoPause":0,"TotalVideoReplay":0,"TotalVideoPlay":0,
"TotalVideoFullscreen":0,"TotalVideoMute":0,"TotalShares":0,"ShareRate":0,
"TotalFacebookShares":0,"TotalLinkedInShares":0,"TotalPintrestShares":0,"TotalTwitterShares":0,
"TotalSocialClicks":0,"SocialClickRate":0,"TotalYouTubePages":0,"TotalTwitterPages":0,
"TotalEngagements":0,"EngagementRate":0,"TotalSocialEngagements":0,"SocialEngagementRate":0,
"TotalVideoEngagements":0,"VideoEngagementRate":0,"TotalPollViews":0,"TotalPollAnswers":0,
"TotalUndefinedPollAnswered":0,"PollRate":0,"TotalPollAnswered1":0,"TotalPollAnswered2":0,
"TotalPollAnswered3":0,"TotalPollAnswered4":0,"TotalPollAnswered5":0,"TotalFeedbackViewed":0,
"TotalFeedbackPanelViewed":0,"TotalFeedbackPageViewed":0,"TotalFeedbackClosed":0,"TotalRewardConfirmsNo":0,
"TotalVideoViewed":0,"TotalVideoPageViewed":0,"TotalVideoPanelViewed":0,"TotalVideoClosed":585,
"TotalDataCapViewed":0,"TotalCalendarClicks":0,"IndustryNotViewable":45,"MediaBrixNotViewable":72,
"TotalVastRedirects":0}
],
Records : [
{ "ExLineItemId":167884416, "OrderName":"Campbell's 2014 FY14 V-Fusion+ Energy","LineItemName":"Campbells2014FY14VFE-000882-Flex-Woblet",
"ZoneName":"colorzen_flex","Product":"socialFlex","TotalDuration":0,"TotalSessions":0,"VisibilityBrixCount":5,"VisibilityStandardCount":6,
"VisibilityBrixRate":0.8333,"VisibilityStandardRate":1.0000,"TotalReach":0,"Frequency":0,"TotalUniques":0,"TotalOpportunities":0,"Opportunity":0,"TotalInitiatedUsers":0,
"TotalImpressions":6,"AvgTimeSpent":0,"TotalClicksToSite":0,"TotalVidStarts":5,"TotalVid25Quartile":5,"TotalVid50Quartile":5,"TotalVid75Quartile":2,"TotalVidCompletes":2,
"TotalRewardConfirmsYes":0,"Vid25QuartileRate":1.0000,"Vid50QuartileRate":1.0000,"Vid75QuartileRate":0.4000,"VidCompleteRate":0.4000,"CTR":0.0000,"TotalVideoInteractions":0,
"TotalVideoPause":0,"TotalVideoReplay":0,"TotalVideoPlay":0,"TotalVideoFullscreen":0,"TotalVideoMute":0,"TotalShares":0,"ShareRate":0,"TotalFacebookShares":0,
"TotalLinkedInShares":0,"TotalPintrestShares":0,"TotalTwitterShares":0,"TotalSocialClicks":0,"SocialClickRate":0,"TotalYouTubePages":0,"TotalTwitterPages":0,
"TotalEngagements":0,"EngagementRate":0,"TotalSocialEngagements":0,"SocialEngagementRate":0,"TotalVideoEngagements":0,"VideoEngagementRate":0,"TotalPollViews":0,
"TotalPollAnswers":0,"TotalUndefinedPollAnswered":0,"PollRate":0,"TotalPollAnswered1":0,"TotalPollAnswered2":0,"TotalPollAnswered3":0,"TotalPollAnswered4":0,
"TotalPollAnswered5":0,"TotalFeedbackViewed":0,"TotalFeedbackPanelViewed":0,"TotalFeedbackPageViewed":0,"TotalFeedbackClosed":0,"TotalRewardConfirmsNo":0,
"TotalVideoViewed":0,"TotalVideoPageViewed":0,"TotalVideoPanelViewed":0,"TotalVideoClosed":6,"TotalDataCapViewed":0,"TotalCalendarClicks":0,"IndustryNotViewable":0,
"MediaBrixNotViewable":1,"TotalVastRedirects":0,"Hour":0,"Day":8,"Week":1,"Month":4,"Year":2014,"FromDate":"\/Date(1396929600000-0400)\/","Date":"4/8/2014"},
{},
.
.
],
Total : 0,
Interval : “Daily”
}