Week 2
Week 2
Unless indicated otherwise, the copyright of these educational materials belongs to the
Erasmus University Rotterdam.
These educational materials may not be reproduced, stored in an automated data file or
made public in any form whatsoever, either electronically, by photocopying, recording or
in any other way without the prior written permission of the EUR.
Contents
4 Exam questions 16
Page 1
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
Part II
Multivariate models for sales and market
shares
1 Last week’s material
Slide 2 Expectation of the log-normal
Given: Z ∼ N (µ, σ 2 ), calculate E[exp(Z)].
1 (z − µ)2
Z Z
1
E[exp(Z)] = exp(z)ϕ(z; µ, σ 2 )dz = exp(z) √ exp(− )dz
σ 2π 2 σ2
1 (z − µ)2 − 2σ 2 z
Z
1
= √ exp(− )dz
σ 2π 2 σ2
Intermezzo:
(z − µ)2 − 2σ 2 z = z 2 − 2(µ + σ 2 )z + µ2
want to rewrite this as (z − a)2 + b = z 2 − 2az + a2 + b
a = µ + σ2
b = µ2 − a2 = µ2 − (µ + σ 2 )2 = −2σ 2 (µ + 12 σ 2 )
1 (z − µ)2 − 2zσ 2
Z
1
E[exp(Z)] = √ exp(− )dz
σ 2π 2 σ2
1 (z − (µ + σ 2 ))2 − 2σ 2 (µ + 21 σ 2 )
Z
1
= √ exp(− )dz
σ 2π 2 σ2
1 (z − (µ + σ 2 ))2
Z
1 1
= √ exp(− ) exp(µ + σ 2 )dz
σ 2π 2 σ2 2
1 (z − (µ + σ 2 ))2
Z
1 2 1
= exp(µ + σ ) √ exp(− )dz
2 σ 2π 2 σ2
| {z }
=1
1
= exp(µ + σ 2 )
2
Programming exercise?
Videos ok?
New questions
1: True or false? + Motivation
Consider the model yi = α + βDi + γxi + εi , where Di is a dummy which equals 1 if individual i is
female and 0 otherwise. Next, xi is a vector of individual characteristics. The parameter β represents
the difference in expected value of yi between females and males.
Page 2
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
Even if there are no cross-effects, simultaneously considering all equations is more efficient
Page 3
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
2.1 Specification
Slide 7 Allowing for competitive effects
Denote the sales of brand i in week t by Sit , i = 1, . . . , J
Notation:
βji denotes the cross-effect of the price of brand j on the sales of brand i, and βii denotes the own
effect.
Disturbance terms εt = (ε1t , . . . , εJt )′ are probably correlated, we assume εt ∼ N (0, Σ).
βji = βjcross for all i ̸= j (=common effect of price of j on all other brands)
etc.
2.2 Interpretation
Slide 9 Cross-effects
The cross parameters can be interpreted similarly as the own effects (last week).
Cross-display effect
E[Sit |Pt , Dt , Djt = 1, Ft ]
= γji
E[Sit |Pt , Dt , Djt = 0, Ft ]
We expect γji < 1.
Page 4
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
2.3 Estimation
Slide 10 Estimation
Again consider the log-linearized form
J
X
log Sit = α̃i + (βji log Pjt + γ̃ji Djt + δ̃ji Fjt ) + εit
j=1
Stack all observations over time: log Si = Xθi +εi where X = (ι, log P1 , . . . , log PJ , D1 , . . . , DJ , F1 , . . . , FJ )
Slide 11 Estimation
log S = Zθ + ε, with ε ∼ N (0, Σ ⊗ IT )
Estimation of θ and Σ can be done by Feasible Generalized Least Squares [FGLS] (=Seemingly Unrelated
Regressions [SUR])
3. ei = log Si − X θ̂i
4. et = (e1t , . . . , eJt )′
5. Σ̂ = T1 t et e′t
P
Examples:
some cross-effects are not included for some brands
In this case construct the Z matrix properly and perform FGLS (̸= OLS)
Page 5
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
– 0 ≤ Mi,t ≤ 1
PI
– i=1 Mi,t = 1
Page 6
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
Slide 17 Attractions
Bell et al. (JMR, 1975) introduce an attraction specification.
The only determinant of market share is the attraction (Ai,t ) consumers feel toward each available brand.
Axioms:
PI
1. Ai,t ≥ 0, i=1 Ai,t > 0
2. Ai,t = 0 ⇒ Mi,t = 0
3. Ai,t = Aj,t ⇒ Mi,t = Mj,t
4. The change in Mi,t due to change in Aj,t (j ̸= i) does not depend on j.
Page 7
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
The attraction for brand i now contains marketing instruments of all I brands and the βk parameters
are different across brands.
Slide 22 Restrictions
The fully extended [FE] model contains many parameters. In practice we will want to impose (and test)
various restrictions:
Restricted competition [RC]
The attraction of brand i only depends on the explanatory variables concerning brand i.
Restricted effects [RE]
RC + equal parameters across brands
Restricted covariance matrix [RCM]
No correlations between attraction shocks (diagonal covariance matrix Σ)
Page 8
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
Slide 23 Restrictions
Restrictions #Parameters #Restrictions
FE MCI – KI(I − 1) –
RC βk,j,i = 0 for j ̸= i KI KI(I − 2) (vs. FE)
RE βk,i = βk K K(I − 1) (vs. RC)
1 2
FCM – 2 [(I − 1) + (I − 1)] –
1
RCM Σij = 0 if i ̸= j I 2 (I − 1)(I − 2) − 1
then
σ12 + σ42 σ42 σ42
∗
Σ = σ42 σ2 + σ42
2
σ42
σ42 σ42 2
σ3 + σ42
RE
K
Y
Ai,t = exp(µi + εi,t ) xβk,i,t
k
k=1
K
X
ln Mi,t − ln MI,t = µi − µI + βk (ln xk,i,t − ln xk,I,t ) +εi,t − εI,t
k=1
| {z }
eg. log relative price
3.3 Estimation
Slide 25 Estimation
Linearized model can each time be written as:
′ ′
y1,t = w1,t b1 + z1,t a + η1,t
′ ′
y2,t = w2,t b2 + z2,t a + η2,t
.. .. .. .
. = . + . + ..
′
yI−1,t = wI−1,t bI−1 + zI−1,t a + ηI−1,t
where
Page 9
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
Slide 26 Estimation
Define for i = 1, . . . , I − 1
yi = (yi,1 , . . . , yi,T )′
Wi = (wi,1 , . . . , wi,T )′ ,
Zi = (zi,1 , . . . , zi,T )′
ηi = (ηi,1 , . . . , ηi,T )′
Matrix notation
y1 W1 0 ... 0 Z1 b1 η1
y2 0 W2 ... 0 Z2 .. η2
.. =
.. .. .. .. ..
. +
..
. . . . . . bI−1 .
yI−1 0 0 ... WI−1 ZI−1 a ηI−1
or
y = Xb + η
∗
with η ∼ N(0, (Σ ⊗ IT )), where ⊗ denotes the Kronecker product.
Slide 27 Estimation
In the special cases
Σ∗ is a diagonal matrix and zi,t = 0 ∀i, t or
same regressors per equation (wi,t = wj,t and zi,t = 0 ∀i, j, t)
the OLS estimator is efficient PT
→ β̂OLS = (X ′ X)−1 X ′ y and Σ̂∗ = 1
T t=1 η̂t η̂t′ where η̂ = y − X β̂OLS .
3.4 Dynamics
Slide 28 Dynamics
The fully extended MCI model in this form does not allow for dynamic effects.
→ Marketing efforts in period t do not have an effect on the market shares in period t + 1.
Examples
The effect of an promotion can last for more than 1 period
A small market share in period t often implies a small market share in period t + 1.
αp,j,i : the effect of the p-periods lagged market share of brand j on the attraction of brand i
The fact that the attraction of brand i can depend on the lagged market shares of all other brands
leads to a very general dynamic specification. (more on the interpretation of dynamic effects in the next
lecture)
Page 10
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
I Y
K P
β α
Y Y
k,j,i p,i
Ai,t = exp(µi + εi,t ) xk,j,t Mi,t−p
j=1 k=1 p=1
I X
X K P
X
ln Mi,t − ln MI,t = µ∗i + ∗
βk,j,i ln xk,j,t + (αp,i ln Mi,t−p − αp,I ln MI,t−p ) + ηi,t
j=1 k=1 p=1
CD
K
I Y P
β γ
Y Y
k,j,i p
Ai,t = exp(µi + εi,t ) xk,j,t Mi,t−p
j=1 k=1 p=1
X K
I X P
X
ln Mi,t − ln MI,t = µ∗i + ∗
βk,j,i ln xk,j,t + γp (ln Mi,t−p − ln MI,t−p ) + ηi,t
j=1 k=1 p=1
where
ℓ(·): log-likelihood function
(b̂0 , Σ̂∗0 ), (b̂a , Σ̂∗a ): ML estimates under H0 or Ha
ν: number of parameter restrictions
Page 11
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
3.6 Interpretation
Slide 34 Interpreting parameter estimates
Interpretation of parameters is often difficult:
Only a reduced form model can be estimated.
Estimated parameters in the fully specified model only give the effect on relative market shares.
Just “looking” at estimated parameters does not lead to much insight in models with many brands.
Slide 35 Interpretation
Simplified model:
I
β
Y
Ai,t = exp(µi + εi,t ) pj,tj,i
j=1
Partial effect of price on market share (omitting the conditional expectations in the notation)
I
∂Mi,t X ∂Mi,t ∂Ak,t
=
∂pi,t ∂Ak,t ∂pi,t
k=1
where
∂Ak,t βi,k
= Ak,t
∂pi,t pi,t
∂Mi,t 1−Mi,t ∂Mi,t −M
= PI and = PI i,t for (k ̸= i) such that
∂Ai,t j=1 Aj,t
∂Ak,t j=1 Aj,t
I
∂Mi,t Mi,t X
= (βi,i − βi,k Mk,t )
∂pi,t pi,t
k=1
This seems reasonable because when your market share approaches one the elasticity goes to zero.
Under Restricted Competition
βi,k = 0, i ̸= k
∂Mi,t pi,t
∂pi,t Mi,t = βi,i (1 − Mi,t )
Elasticities are the same for each brand when they have the same market share.
Page 12
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
3.7 Forecasting
Slide 37 Forecasting relative market shares
Denote relative market shares (Mi,t /MI,t , i = 1, . . . , I − 1) by mi,t .
The reduced form of the MCI model is
ln mi,t = ln Mi,t − ln MI,t
I X
X K P X
X I
= µ∗i + ∗
βk,j,i ln xk,j,t + ∗
αp,j,i ln Mj,t−p + ηi,t
j=1 k=1 p=1 j=1
= λi,t + ηi,t
Therefore
b i,t = E(mi,t ) = exp(λi,t + 1/2Σ∗i,i ), i = 1, . . . , I − 1
m
E[Mi,t+1 |Xt+1 , Mt ]
with
Xt+1 : information on explanatory variables up to period t + 1
Mt : information on market shares up to period t
The estimated coefficients in a MCI model refer to ln mi,t . Forecasts for the market shares are therefore
not easy to make.
In fact it turns out that it is not possible to get an expression for an unbiased forecast. We therefore
will have to use simulation to calculate the forecasts.
Page 13
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
3. E[Y ] ≈ N1 i ỹi
P
Decompose Σb ∗ using the Choleski decomposition. This means: find a (lower-triangular) matrix P such
′ b∗
that P P = Σ
Note that
Cov(Z) = I
Cov(P Z) = P IP ′ = P P ′ = Σ
b∗
b ∗)
P Z is therefore a draw from N (0, Σ
Page 14
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
3.8 Illustration
Slide 44 Interpreting an empirical model (Detergent example)
Available data
Market share Mi,t
Relative price Pi,t
Relative distribution Di,t
Promotion indicator P ri,t
132 weekly observations of a 5 brand detergent market
Table 1: Data hara teristi s 5-brand detergent data
Brand
1 2 3 4 5
Average market shares (%) 24.49 22.22 22.62 8.22 22.45
Average relative pri e 1.12 1.09 1.10 1.09 1.11
Average relative distribution 0.85 0.91 0.93 0.78 0.94
Fra tion of promotions 0.27 0.21 0.39 0.34 0.10
Fra tion of 132 weeks in whi h the brand is on promotion.
Page 15
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
Inter ept 1.308 (0.69) 2.136 (0.898) 1.121 (0.941) 1.387 (0.894)
P1;t -7.828 (1.139) -2.220 (1.481) -0.274 (1.554) -2.647 (1.476)
P2;t 0.054 (0.404) -3.345 (0.526) 0.003 (0.552) -0.254 (0.524)
P3;t -0.186 (0.555) -0.072 (0.722) -5.241 (0.758) 0.207 (0.72)
P4;t -0.196 (0.796) 2.487 (1.035) -0.465 (1.085) -6.682 (1.031)
P5;t 7.419 (1.329) 3.987 (1.729) 5.243 (1.813) 8.887 (1.722)
D1;t 0.081 (0.288) 0.157 (0.374) -0.080 (0.392) -0.428 (0.373)
D2;t 0.014 (0.162) 1.124 (0.211) -0.367 (0.221) 0.104 (0.21)
D3;t 0.330 (0.363) -0.068 (0.472) 1.466 (0.495) -0.584 (0.47)
D4;t 0.027 (0.113) 0.137 (0.147) -0.084 (0.154) 1.015 (0.146)
D5;t -0.224 (0.402) -1.535 (0.523) -1.042 (0.548) 0.174 (0.521)
exp(P r1 ;t ) 0.070 (0.039) 0.080 (0.051) 0.047 (0.054) -0.064 (0.051)
exp(P r2 ;t ) -0.012 (0.051) 0.149 (0.067) -0.047 (0.07) 0.020 (0.066)
exp(P r3 ;t ) 0.037 (0.038) -0.004 (0.05) 0.094 (0.052) 0.001 (0.05)
exp(P r4 ;t ) -0.076 (0.044) 0.010 (0.058) -0.091 (0.06) -0.007 (0.057)
exp(P r5 ;t ) -0.012 (0.063) -0.225 (0.083) -0.097 (0.087) -0.014 (0.082)
M1 ;t 1 0.394 (0.113) 0.118 (0.147) 0.143 (0.155) 0.212 (0.147)
M2 ;t 1 0.127 (0.107) 0.558 (0.139) 0.193 (0.146) 0.276 (0.139)
M3 ;t 1 0.180 (0.141) 0.567 (0.183) 0.384 (0.192) 0.621 (0.182)
M4 ;t 1 0.129 (0.061) 0.084 (0.079) 0.091 (0.083) 0.400 (0.079)
M5 1 -0.192 (0.138) 0.081 (0.179) -0.103 (0.188) -0.229 (0.179)
02 2 2 1 0 1
;t
Forecast the last half year (given prices etc) and compare the forecasting performance of a naive
forecast to the simulation-based forecast
4 Exam questions
Slide 48 Question 1
True or false? Give a short motivation:
Page 16
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
One does not need simulation to calculate unbiased forecasts of relative market shares in the market
share attraction model.
Slide 49 Question 2
Consider the following market share attraction model
α
Ait = exp(αi + εit ) exp(Dit )γi exp(Fit )δ Ij=1 Pjtji ,
Q
for i = 1, . . . , I , t = 1, . . . , T and where Dit and Fit are 0/1 indicators for display and feature of brand i at time
2
σ1
2
σ2
t, Pit is the price of brand i at time t, and finally (ε1t , . . . , εIt ) ∼ N (0, Σ) with Σ = .
..
.
σI2
4a) Give one reason why one would consider to model market shares instead of sales.
4b) Explain why the exponential transformations of display and feature have to be used.
4c) For each model component (display effect, feature effect, price effect, and the error terms) give the name of
the specification or the restrictions imposed.
4d) Give the expression for the reduced form model, that is, the model that can be used to estimate the parameters.
4e) Specify which (functions) of the parameters are identified.
Slide 50 Question 3
To explain the development of the market shares of 3 brands, a researcher specifies a market share attraction
model. He specifies a reduced form model for the log relative market share of brand 1 and brand 2 relative to
brand 3. As explanatory variables he uses an intercept and the log prices of all three brands for both equations.
Denote the market share of brand i at time t by Mit and the price of brand i at time t by Pit .
a) Give the complete attraction specification that corresponds to this reduced form model. Use (Greek) letters
for the parameters.
The researcher obtains the following parameter estimates for the reduced form model
log M1t − log M3t = 1.05 − 2.45 log P1t + 0.75 log P2t + 0.25 log P3t + η1t
log M2t − log M3t = 0.75 + 0.45 log P1t − 1.95 log P2t + 0.89 log P3t + η2t
b) Suppose that in general the prices equal e2.71. Which brand will have the largest market share, and which
brand will have the smallest?
c) Give an interpretation to each of the three price effects in the equation for log M1t − log M3t .
d) Another researcher claims that it is better to take brand 2 as the base brand. Give the reduced form model
and the estimated parameter values for this case. Can it be true that this reduced form model is better? Motivate
your answer.
Slide 51 Literature
Background info:
Kumar (1994)
References
Bell, David E., Ralph L. Keeney, and John D. C. Little (1975), “A Market Share Theorem”,
Journal of Marketing Research, 12, 136–141.
Cooper, Lee G. and M. Nakanishi (1988), Market Share Analysis: Evaluating Competitive Marketing Effectiveness,
Kluwer Academic Publishers, Boston.
Fok, Dennis, Philip Hans Franses, and Richard Paap (2002), “Econometric Analysis of the Market Share
Attraction Model”, in P. H. Franses and A. L. Montgomery (eds.), Advances in Econometrics, vol. 16,
chap. 10, JAI Press, pp. 223–256.
Page 17
Advanced Marketing Models 2023-2024 ©Erasmus School of Economics
Klapper, D. and H. Herwartz (2000), “Forecasting Market Share Using Predicited Values of Competitor
Behavior: Further Empirical Results”, International Journal of Forecasting, 16, 399–421.
Kumar, V. (1994), “Forecasting Performance of Market Share Models: An Assessment, Additional In-
sights, and Guidelines”, International Journal of Forecasting, 10, 295–312.
Page 18