Format json file #8
Description
{
"info": {
"UserName": "",
"Brand": "Shutterfly",
"StartingTime": "2014-07",
"PlanMonths": "2",
"EndingTime": "2014-08",
"RevenueAttribution": "Last Touch",
"Algorithm": "2",
"AlgStartingTime": "2015-05-14 15:51:55",
"AlgEndingTime": "2015-05-14 15:56:43",
"AlgDuration": "4.795458 mins"
},
"SEM-Cards":{
"LowerBound":199150,
"Min":0,
"Max":0,
"UpperBound":1916740,
"ScalingFactor":1.0,
"SpendRecommendtion":777880,
"SpendMin":199150,
"SpendMax":1916740,
"ActualsSpend":777880,
"ActualsRevenue":"-",
"AdjustedSpend":825967
},
"SEM-Band":{
"LowerBound":88588,
"Min":0,
"Max":0,
"UpperBound":1376980,
"ScalingFactor":1.0,
"SpendRecommendtion":822988,
"SpendMin":88588,
"SpendMax":1376980,
"ActualsSpend":822988,
"ActualsRevenue":"-",
"AdjustedSpend":849911
},
"SEM-Photobook":{
"LowerBound":136091,
"Min":0,
"Max":0,
"UpperBound":1093607,
"ScalingFactor":1.0,
"SpendRecommendtion":205072,
"SpendMin":136091,
"SpendMax":1093607,
"ActualsSpend":205072,
"ActualsRevenue":"-",
"AdjustedSpend":291532
},
"SEM-Others":{
"LowerBound":61030,
"Min":0,
"Max":0,
"UpperBound":591786,
"ScalingFactor":1.0,
"SpendRecommendtion":174763,
"SpendMin":61030,
"SpendMax":591786,
"ActualsSpend":174763,
"ActualsRevenue":"-",
"AdjustedSpend":174763
},
"Display":{
"LowerBound":275231,
"Min":0,
"Max":0,
"UpperBound":2632482,
"ScalingFactor":1.0,
"SpendRecommendtion":1143773,
"ProjectedRevenue":5002230,
"SpendMin":275231,
"SpendMax":2632482,
"ActualsSpend":1143773,
"ActualsRevenue":5115539,
"AdjustedSpend":1224254,
"AdjustedRevenue":5115539
},
"Social":{
"LowerBound":28837,
"Min":0,
"Max":0,
"UpperBound":1389035,
"ScalingFactor":1.0,
"SpendRecommendtion":67214,
"ProjectedRevenue":363474,
"SpendMin":28837,
"SpendMax":1389035,
"ActualsSpend":67214,
"ActualsRevenue":886397,
"AdjustedSpend":223151,
"AdjustedRevenue":886397
},
"Affiliates":{
"LowerBound":52390,
"Min":0,
"Max":0,
"UpperBound":628556,
"ScalingFactor":1.0,
"SpendRecommendtion":220074,
"ProjectedRevenue":2006106,
"SpendMin":52390,
"SpendMax":628556,
"ActualsSpend":220074,
"ActualsRevenue":2081898,
"AdjustedSpend":254422,
"AdjustedRevenue":2081898
},
"Partners":{
"LowerBound":389081,
"Min":0,
"Max":0,
"UpperBound":4931604,
"ScalingFactor":1.0,
"SpendRecommendtion":1651889,
"ProjectedRevenue":4777637,
"SpendMin":389081,
"SpendMax":4931604,
"ActualsSpend":1651889,
"ActualsRevenue":3743169,
"AdjustedSpend":1156000,
"AdjustedRevenue":3743169
},
"TV":{
"BeginDate":"",
"EndDate":"",
"Spend":0,
"Impressions":0
}
}/////////////////////////////////////////////////////////////////
Notes:
{
"info": {
"UserName": "UserName",
"Brand": "Brand",
"StartingTime": "StartingTime",
"PlanMonths": "EndingTime - StartingTime",
"EndingTime": "EndingTime",
"RevenueAttribution": "lmTouch",
"Algorithm": "Algorithm",
"AlgStartingTime": "AlgStartingTime",
"AlgEndingTime": "AlgEndingTime",
"AlgDuration": "AlgDuration"
},
"SEM-Cards":{
"LowerBound":"semCLB",
"Min":"semCMin",
"Max":"semCMax",
"UpperBound":"semCUB",
"ScalingFactor":"semCSF",
"SpendRecommendtion":"semCSR" (semCSlide),
"SpendMin":"semCSlideLeft" (semCLB, semCSlideDivMin),
"SpendMax":"semCSlideRight" (semCUB, semCSlideDivMax),
"ActualsSpend":"semCSR", // Actual spend and recommendtion are the same. In new version there's no reommendtion
"ActualsRevenue":"-",
"AdjustedSpend":"semCAS" (semSlide)
},
"Display":{
"LowerBound":"disLB",
"Min":"disMin",
"Max":"disMax",
"UpperBound":"disUB",
"ScalingFactor":"disSF",
"SpendRecommendtion":"disSR",
"ProjectedRevenue":"disPR",
"SpendMin":"disSlideLeft" (disLb, disSlideDivMin),
"SpendMax":"disSlideRight" (disUb, disSlideDivMax),
"ActualsSpend":"disSR",
"ActualsRevenue":"disAR", // ??? not sure.
"AdjustedSpend":"disAS",
"AdjustedRevenue":"disAR" (disSlide)
},
"TV":{
"BeginDate":"tvBeginDate",
"EndDate":"tvEndDate",
"Spend":"tvSpend",
"Impressions":"tvImpressions"
}
}
///////////////////////////////////////////////////////////////////
This is the temp json. some data are mismatch between old version and new version. We can discuss about the data structure.