Set Up Your SourceMedium MTA Dashboard

Confirm your data is ready

Copy the template and select your data sources

On the template, open the three-dot menu at the top right and select Make a copy.

For each Original Data Source on the left, pick the New Data Source from your warehouse with the same table name.

Your warehouse tables appear under Available data sources, not Added data sources.

If a matching data source is not listed, create it in the next step. Otherwise skip to step 4.

Create missing data sources

Click Create data source.

Select the BigQuery connector.

Then select:

• Project: SM Managed - Your Company Name
• Dataset: sm_experimental
• Table: obt_purchase_journeys_with_mta_models or rpt_ad_attribution_performance_daily

Click Connect, then Add to Report.

Repeat this for both tables. The dashboard needs both data sources.

Personalize your copy

Click Copy Report. Looker Studio opens your new dashboard in edit mode.Rename the report in the top left. Remove Copy of and replace Demo with your company name.

Replace the demo date filter. Delete the clear rectangle that covers the date filter, delete the text box that reads (fixed date range for demo), then click the date range filter and set your default range.

Delete the clear rectangle

Delete the text box

Change the default date range

To replace the SourceMedium logo, click it, then click the file name in the Image Properties panel and choose your own file. The logo is shared across pages, so you only do this once.

To change colors and layout, right-click any blank area and select Theme and layout, or use File > Theme and layout.

Start analyzing