Skip to main content

How to set up the Black Friday report

Written by Jonas Østergård Bæk

The Black Friday report focuses specifically on analysing the performance of marketing campaigns and sales during the Black Friday period. The report is updated hourly during business hours (7–23 CEST), providing timely insights to support the decision-making process.

Last year (LY) metrics and year-over-year percentages compare to the same weekday in the prior year’s Black Week period, not the same calendar date (for example, this year’s Friday vs the Friday 52 weeks earlier). Rows are aligned on day of week, not on matching month and day last year.

This article covers how to set up your Black Friday report. For more information on configuring hourly budgets and targets, please refer to this article.
​
To set up your Black Friday report in Alvie:

  1. Go to Data Insights → Reporting solutions

  2. Click on Create new report.

  3. Start by giving your report a name.

Step 1. Select the report

Select Black Friday Report as the report type.

Step 2. Select the data sources and choose custom groupings

Keep the following points in mind when setting up the Precis starter report:

1. Data sources: You have the flexibility to select any combination of your configured Analytics, Paid Media and other data sources.

2. Custom grouping: Custom grouping is important in the Black Friday report. The report is aggregated based on Date and Custom groupings, including market and channel grouping levels. This allows for accurate data integration from different platforms and relevant datasets. For instance, you can join Google Analytics data with budget data to address specific cases.
​

Step 3. Define data target properties

In this step, you will find the basic settings, which require you to define the Google Cloud project and BigQuery output dataset. For detailed instructions on how to correctly fill in this data, please refer to the documentation provided here.

Additionally, this step includes a required advanced setting to define the suffix used in the BigQuery output table name. The suffix is pre-filled by default but can be edited as needed. It should be descriptive and must not contain spaces.

Step 4. Other settings

This final step allows you to define the Target currency. More information can be found here.

Step 5. Activate the report

If you have finished configuring the settings, you can activate the report. However, if you still need to make adjustments to the settings, you can choose to save without activating.

For more detailed information on report activation and setting up the Looker studio dashboard, please refer to the documentation provided here.

Did this answer your question?