Example
This example provides details on the integration metadata JSON with data source.
PromotionandTacticMeasures
{
"datasources": [
{
"name": "PromotionAndTacticMeasures"
}
],
"dimensions": {
"accountdimension": {
"attributes": [
{
"label": "ExternalId",
"name": "externalid"
},
{
"label": "Name",
"name": "name"
},
{
"label": "AccountNUmber",
"name": "accountnumber"
}
],
"key": "externalid",
"level": ""
},
"productdimension": {
"attributes": [
{
"label": "Description",
"name": "description"
},
{
"label": "ExternalId",
"name": "externalid"
},
{
"label": "Category",
"name": "category"
}
],
"key": "externalid",
"level": "Product"
},
"timedimension": {
"includetotal": false,
"splitweeks": false,
"periodtype": "custom"
},
"kpidimension": {
"measures": [
{
"label": "Incremental Volume",
"name": "ProPlanIncrVolume"
},
{
"label": "Tactic Spend",
"name": "PlanTotalPromoCosts"
},
{
"label": "Lump Sum",
"name": "FixedAmountLumpSum"
}
]
},
"promotiondimension": {
"attributes": [
{
"label": "id",
"name": "id"
},
{
"label": "datefrom",
"name": "datefrom"
},
{
"label": "templateName",
"name": "templateName"
},
{
"label": "accountid",
"name": "accountid"
},
{
"label": "accountplanrelevant",
"name": "accountplanrelevant"
},
{
"label": "accountexternalid",
"name": "accountexternalid"
}
],
"key": "id",
"level": ""
},
"tacticdimension": {
"attributes": [
{
"name": "lifttype",
"label": "lifttype"
},
{
"name": "name",
"label": "name"
},
{
"name": "liftvalue",
"label": "liftvalue"
},
{
"name": "compensationmodel",
"label": "compensationmodel"
}
],
"key": "name",
"level": ""
}
},
"exportsettings": {
"columns": [
"accountdimension.externalid",
"promotiondimension.id",
"promotiondimension.datefrom",
"promotiondimension.templateName",
"tacticdimension.name",
"tacticdimension.compensationmodel",
"productdimension.externalid",
"productdimension.category",
"productdimension.description",
"kpidimension.label",
"kpidimension.measurecode",
"...timedimension.label"
],
"csvseparator": ","
},
"exportfilters": {
"conditions": [
{
"operator": "includes",
"value": [
"Kroger_Atlanta"
],
"attribute": "externalid",
"dimension": "accountdimension",
"name": "cond1"
}
]
}
}