The dashboard template is provided as part of the MCDM package for a quick start of BI analytics on top of MCDM data.
MCDM Recipes supported:
Required MCDM dashboard templates are provided by Customer Success Manager during onboarding.
Alternatively, you can follow the instruction below:
The first step is to apply the template datasources for Looker Studio from the table below (alternative instruction: link) to your data.
The second step is to apply your new Looker Studio datasources to the dashboard template.
Customer Success Manager provides you with required MCDM dashboard templates during onboarding.
Question: How can I understand what field is used in mapping?
Answer: Depending on specific questions, a search can be started:
After applying proper filters, you can find mcdm_field as the field used in the output mcdm table and the original field as the “raw data” field of a specific data source.
Q: How often and when do MCDM tables are loaded to my DWH?
A: The MCDM table is loaded to the DWH daily after successful daily extraction for all source tables. The source table here is the “raw data” report type of data source used to provide data for MCDM.
Q: How can I understand what data source is the source for this campaign or metric value?
A: There is an MCDM field data source that contains the data source name, so it’s always possible to correlate values to the value of this column.
Q: How can I reuse the Looker Studio dashboard template?
A: The first step is to copy the Looker Studio data source. There is an instruction for it here.
Make sure to connect your data sources to relevant tables in your DWH while copying.
The second step is to copy the dashboard. Please follow this instruction for this step.
Q: What extraction templates should I use to load data for MCDM?
A: Please use extraction templates with MCDM in their name. There might be several templates for each data source as MCDM covers a wide range of granularities, and usually, more than 1 table is needed to provide full coverage.
Q: Will I receive “raw data” tables with MCDM or only MCDM?
A: MCDM is always loaded as an additional set of tables to the “raw data” tables. So you will have both aggregated tables of MCDM and tables containing information on each data source separately.
Improvado team is always happy to help with any other questions you might have! Send us an email.
Contact your Customer Success Manager or raise a request in Improvado Service Desk.