Consider Figure 28.13, which shows the frequency of a brand`s purchases and inventory over four time periods. The brand has an in-stock distribution in January and February and an out-of-stock distribution (OOS) in March. The brand lost its distribution in April because there were no sales, no purchases and no inventory – it didn`t exist in store at any time of the month. Unless otherwise specified, the distribution is weighted according to the value of sales by category. Defined as a percentage of the money spent on the product category, it reflects the quality of distribution. The split function handles the zero split error. The base measure (initial value) is last year`s cumulative revenue. Considering that the weighted distribution of brand X (50%) is lower than the digital distribution (75%), it can be concluded that the quality of the brand`s distribution is relatively low. In comparison, the Z brand is treated with 50% digital distribution and 70% weighted stores contributing more to category sales. Usually calculated monthly, this means that June 2010 MAT sales include sales from July 1, 2009 to June 30, 2010 and July 2010 MAT sales include sales from August 2009 to July 2010.
At the end of each month, you add up that month`s sales and delete the corresponding sales from the same month from the previous year. Another advantage is that when the MAT sales of companies in an industry are compared (e.g. pharmaceutical industry or newspaper circulation), we have a better basis for comparing the performance of the companies being compared. A derivative of this comparison are the MAT sales rankings. MAT sales eliminate seasonal fluctuations from comparisons, making two groups of MAT sales more conducive to comparison. shows only Business & Finance definitions (show all 92 definitions) MAT is for sales in the last 12 months, comparing two MAT data points compensates for fluctuations. To automate annual revenue, set the following metric in Power BI: Annual moving total (MAT) is the total value of a variable, such as sales of a product, over the past 12 months. This is a rolling annual total, so changes change at the end of each month, adding the new month`s data to the total and removing the first month`s data from the period. Simply put, this is the turnover/turnover of the last 12 months. For example, sales from February 2014 to January 2015 are referred to as February 2015 MAT sales.
There are separate organizations to track, compile and evaluate these figures. These results are used for the formulation and implementation of sales and product management strategies. Because it captures the most basic market information, retail tracking data is essential for formulating marketing strategies and sales plans. The scope includes all of the following areas: The topic should be relevant to your customer`s product and industry, while helping consumers solve a common challenge that applies to their daily lives. The item should also avoid sales messages and minimize brand mentions. Read these 10 proven tips for creating and distributing a successful version of MAT. To get year-to-date sales for the same period as last year: Consider Figure 28.12 as an example. Brand X is served by stores A, B and C; Its digital distribution is therefore three out of four or 75%.
Its weighted distribution is the total weight of stores A, B and C in terms of sales by category, which is equal to 50% (5 + 20 + 25). Also note that the weighted distribution of the brand (50%) is the same as the commercial share of stores A, B and C that deal with brand X. The task is to make sales from year to year for this year and from year to year at the same time of the previous year. Finally, compare the percentage difference between the two. The analysis and interpretation of these data in the context of sales is the subject of the Sales and Distribution chapter. A rolling annual total (MAT) calculates the total value for the last 12 months. This can be calculated day by day, month by month, or quarter by quarter, depending on how you aggregate your data. If you report sales figures by month, the MAT changes from month to month to reflect sales for the last 12 months.
If you have seasonality in your data, where sales are particularly high in some months and low in others, then a MAT will eliminate these seasonal effects. You can then plot this number to predict or predict trends. Year-to-date is the sum of the volume or value of sales from the beginning of the year to the last period. On the other hand, the annual moving total (MAT) is the sum of the volume or total value of sales for the 12 months ending with the last period. Sometimes categories are weighted based on the annual value of products (i.e., the value of sales of all categories sold per store). This is advisable for small new/growing categories with few brands. For these categories, the annual value-weighted distribution better reflects the quality of the distribution. Total Rolling Annual (MAT) Total sales figures for the last 12 months. Is this store still considered a non-distributor in April? MAT publications are considered paid media, which are a form of controlled media. With MAT versions, you can control what you`re talking about, shaping the narrative of your brand or product. Since then, MAT publishing has evolved into other forms of sponsored content.
For example, Brandpoint provides creative and distribution services for traditional MAT articles, as well as infographics, slideshows, and videos with in-house text and design services. Overall, a press release is a learned media tactic written for an audience of journalists and editors, while a MAT publication is a paid tactic to ensure media coverage and the article is written for a consumer audience. Note that this formula is almost identical to YTD this year. Simply replace CalendarDate[Date] with SAMEPERIODLASTYEAR(CalendarDate[Date]). The SAMEPERIODLASTYEAR function shifts all data by one year. Can a MAT version help you achieve your goals? If you`re like most companies, from small startups to Fortune 500 companies, the answer is a resounding yes. MAT JUNE 2015 = JULY-2014+AUGUST-2014+……….+MAY-2015+JUNE 2015 A MAT version, on the other hand, is a paid tactic that guarantees media coverage to a network of publishers working with a MAT publishing provider. The MAT publication is a consumer-focused article that focuses on providing useful information rather than brand-centric text like a press release.
Now, let`s say there were closing stocks in March and, as before, no purchases in April and no inventory until the end of April. In this case (Appendix 28.13b), the status changes from OOS distribution to stock distribution in March. Retail tracking data is essentially in 3 dimensions – product, market, and time (see Figure 28.11), and each dimension has a hierarchical structure. For example, the product dimension can be broken down by category, segment, sub-segment, manufacturer, brand, variant, and item. If your MAT is widely distributed and published, it is worldwide for consumers to share on social media or for other journalists to review and write. When you distribute a MAT publication with Brandpoint, your article will also be published in Brandpointcontent.com, where publishers will find articles to fill the gap in their publications, giving brands more opportunities for earned media. Formatting your article with numbers or bullet points and adding additional images will improve readability and draw more attention to the article. MAT publication, matte publication, syndicated content, advertorial – whatever your spelling or say it, this PR tool meets the needs of the changing landscape of American newspapers and media. Similar to a MAT, a monthly moving total (MMT) is more granular in terms of time. Data up to a month old is returned. (i.e.
On February 15, a monthly moving total reports all data from January 15 to February 15 To find the percentage difference from last year, use the percentage difference formula: Paid: The MAT version is primarily paid media placement. MAT publishing providers (such as Brandpoint) work closely with hundreds of PR agencies and brands to create and distribute high-quality MAT publications to secure digital and print placements in some of the country`s top publications and media sites. Similar to a MAT. A rolling quarterly total dates back to one quarter earlier. Returns all dates in a specified time period at the most recent date on which the data exists.