ROI Models Data Export
intercept.csv
The intercept is the non-marketing driven sales (sometimes called organic), or a prediction of "what would our volume be if we turned all marketing off." It models yearly seasonality to account for typical sales cycles in the business.
Use cases:
- Compare marketing-driven vs. non-marketing-driven sales at different periods in time
Rows:
- One row for each day in the model's historical dataset
Columns:
- date: The date
- channel: always "intercept"
p
columns: median estimate and confidence interval for the intercept in the same units as your outcome variable (e.g. new subscribers)
roi.csv
ROI is the estimated average incremental return on investment for each channel on each day. Days with no spend will have missing values. It will be impacted by how much money is spent on that channel (i.e., it incorporates the effect of saturation).
Use cases:
- See historical performance of channels
- Calculate the ROI for a channel, both present day and historically
Rows:
- One row for each day and each channel in the historical dataset
Columns:
- date: The date
- channel: The spend channel
roi_p
columns: Median estimate and confidence interval for the incremental return on investment in dollars.
me.csv
The ME is the estimated marginal effectiveness, or the return on the last dollar spent in a given channel on a given day. Because of channel saturation, this return will always be the same as or lower than the average ROI given in the roi.csv file.
Use cases:
- Calculate the return for an extra dollar spent, given a certain amount of saturation
Rows:
- One row for each day and each channel in the historical dataset
Columns:
- date: The date
- channel: The spend channel
mroi_p
columns: Median estimate and confidence interval the incremental marginal return on investment in dollars.
in_period_effect.csv
The in-period effect is the estimated amount of revenue attributable to a given channel on that day. It takes account of the time shift, so if you spent a lot of money in a channel yesterday, but none today, the in-period effect will be greater than zero to represent the revenue that was driven from spend yesterday but didn't happen until today.
Use cases:
- Assign credit to a channel for driving a certain amount of revenue in a time frame
Rows:
- One row per day, per channel
Columns:
- date: The date
- channel: The marketing channel
in_period_effect_p
: The median and confidence interval for the amount of revenue attributable to that channel on that day
cumulative_shift_curves.csv
The cumulative shift curves summarize how long it takes to realize the return from money spent on a given day. For each channel we estimate how much return has been realized within a given number of days of spending the money. These estimates are a percentage of the total realization, so will always be at or below 100%.
Use cases:
- Estimate how long you will need to wait to see signal from spend in a given channel
Rows:
- For each channel, a certain number of days after the original spend (so
days=3
indicates what percent of sales are realized on or before the third day after the money was sent).
Columns:
- channel_name: The channel
- days: Number of days after original spend
p
columns: Median estimate and confidence interval for the total percentage realized by that point in time
Note: Our default is to include 180 days out.
shift_curves.csv
The shift curves summarize how much return we expect to realize on a given day after the money has been spent into a channel. For a given channel, these numbers represent the % of the total realized gains that we will see on a particular day.
Use cases:
- Calculate the additional sales you can expect x days after spending into a channel.
Rows:
- For each channel, the number of days after the original spend (so
days=3
indicates what percent of sales are realized on the third day after the money is spent).
Columns:
- channel_name: The channel
- days: Number of days after original spend
average_effect
: the percentage of sales we expect to be realized that day if the return on investment happens about as fast as we expectslow_roi_effect
: the percentage of sales we expect to be realized that day if the return on investment is on the slow end of what we expectfast_roi_effect
: the percentage of sales we expect to be realized that day if the return on investment is on the fast end of what we expect
Note: We include days until the return realized on a given day is below 0.1%.
predicted.csv
The predicted value for the outcome variable from the model for each day in the historical dataset
Use cases:
- Compare the model's fit to what actually happened on a given day
Rows:
- Each day in the historical dataset
Columns:
- date: The date
p
columns: the median and confidence interval for our prediction on a given day
clean_data.csv
The data fed into the model, including the outcome variable and the channel spend variables
Use cases:
- Compare what data was used in the model to external sources for validation
Rows:
- Each day in the historical dataset
Columns:
- date: The date
- Outcome Variable: the name of your specific outcome variable
- Channel names: The names of your specific marketing channels
spike_summaries.csv
A summary of the estimated effect of a spike in the model. Spikes can be anything that has a large effect on sales, typically a sale or a holiday that effects normal business operations. Spikes can have a positive component by increasing sales, and a negative component by cannibalizing sales both before and after the spike. The spike summary can be thought of as the difference between what did happen and what would have happened if the special event never happened, but your marketing spend stayed the same.
Use cases:
- See whether a sales event positively contributed to revenue
Rows:
- One row for each spike in the model
Columns:
- date: The "central" day of the spike, typically the day where sales jumped the most.
spike_group
: The numerical group the spike belongs tospike_group_name
: The name of the spike groupp
columns: the median and confidence interval for the effect of the spike on the outcome variable (in the same units as the outcome variable).
spike_group_summaries.csv
A summary of the estimated average effect for a group of spikes in the model. Spikes can be grouped if we expect multiple spikes to have similar behavior (for example, reoccurring 20% off sales). The summary indicates what effect an average spike in this group will have on the outcome variable, holding marketing spend constant.
Use cases:
- Rank different types of sales events by their impact on sales
Rows:
- Each spike group
Columns:
spike_group
: An ID for that groupspike_group_name
: The name of that spike groupmean
column: The mean estimate for the average effect of that group on the outcome variablep
columns: A median estimate and confidence interval for the average effect of that group on the outcome variable- dates: the dates of the spikes in that spike group
spike_series.csv
The spike series describes how the effect of spikes happen over time. Each spike can have an effect leading up to the spike and in the days after the spike. This dataset shows whether that effect was positive, negative, or zero for each day.
Use cases:
- Visualize the effect of a spike event
Rows:
- One row for each day, for each spike
Columns:
spike_date
: The date of the spike that the row is summarizingspike_group
: The numerical group the spike belongs tospike_group_name
: The name of the spike group- date: The date we're estimating the effect for
daily_p
columns: The effect (median + confidence interval) on the outcome variable for that spike on that daycumulative_p
columns: The cumulative effect of the spike for all days up to and including that day
response_impact.csv
An estimate of the impact on the outcome variable if you spend a certain amount of money in a certain channel. This is an estimate at the current (non-historical) channel performance only and summarizes how much new revenue you will obtain for a given level of spend. It demonstrates the effect of saturation, so as spending increases the estimated response's growth will slow. The impact is how much return you will receive in total, not on the first day of spend or any specific number of days of spend.
Use cases:
- Plan how you can scale a channel to achieve marketing goals
Rows:
- One row for each channel, at each spend level. Each channel has 100 rows, with spend levels chosen so that they're in the same range as your historical spend.
Columns:
- channel: The channel
- spend: An amount of daily spend that could be spent in the channel
p
columns: The median and confidence interval of the return you can expect from that spend.
response_roi.csv
An estimate of the average ROI if you spend a certain amount of money in a certain channel. This is an estimate at the current (non-historical) channel performance only, and summarizes how much your average ROI will be for different levels of spend. It demonstrates the effect of saturation, so as spending increases the estimated ROI will decrease.
Use cases:
- Identify how much you can scale a channel while maintaining a certain ROI
Rows:
- One row for each channel, at each spend level. Each channel has 100 rows, with spend levels chosen so that they're in the same range as your historical spend.
Columns:
- channel: The channel
- spend: An amount of daily spend that could be spent in the channel
p
columns: The median and confidence interval of the ROI you can expect at that spend level
response_mroi.csv
An estimate of the marginal ROI (effectiveness of the last dollar spent) if you spend a certain amount of money in a certain channel. This is an estimate at the current (non-historical) channel performance only, and summarizes the return on investment for your last dollar spent. It demonstrates the effect of saturation, so as spending increases the estimated marginal ROI will decrease.
Use cases:
- Identify which channels can be scaled to grow revenue at the lowest price.
Rows:
- One row for each channel, at each spend level. Each channel has 100 rows, with spend levels chosen so that they're in the same range as your historical spend.
Columns:
- channel: The channel
- spend: An amount of daily spend that could be spent in the channel
p
columns: The median and confidence interval of the marginal ROI you can expect at that spend level
marginal_effectiveness.csv
This file is a little different from the other files in that itโs not raw data from the model, but rather a helpful summary of your current state. To increase return on marketing investment, you want to shift money from low marginal ROI channels to those with high marginal ROI. This sheet ranks your currently active channels to highlight which ones you should be moving money into.
Use cases:
- Identify which channels should be receiving a larger investment
Rows
- One row for each channel that is currently active
Columns
- channel: The channel
me_p columns
: The median and confidence interval on the average marginal ROI over the last 30 days.last_30_spend
: How much money youโve spent in that channel in the last 30 daysbetter_than_median
: A flag for whether that channel is better than your average channelupper_funnel_channel
: A flag for whether itโs an upper funnel or lower funnel channel (Note: if you do not have lower funnel channels, all channels will be upper funnel channels)
Updated 4 months ago