How to add influencer spending

Getting started

Tutorials and examples

Onboarding guides

Tips and tricks

More information

Attribution models

Bayesian statistics

Frequently asked questions

Metrics overview

User journey tracking

← How to add data sources

How to add influencer spending

To import spend into Admetrics Data Studio, please follow these steps:

Create a copy of this document by going to "File" and selecting "Make a copy". Name the document using your company name followed by "Admetrics Import" (e.g. "ACME - Admetrics Import"), and make sure to share it with the same people.
Go to the "Spend" sheet and input your data. Be sure not to remove any columns and keep empty columns if you don't want campaign or ad_id granularity. Also, ensure that the sheet name is not changed and that only the desired rows are kept.
Ensure that the date column is formatted as day and in the DD/MM/YYYY format and that the currency column is in the ISO_4217 format (https://en.wikipedia.org/wiki/ISO_4217) and the spend columns are numeric (examples of accepted values: '10' or '112.3', not '112,3')
Share the sheet with gsheetimport@adm-shopify.iam.gserviceaccount.com, if it is not already shared.
Add in the Data Studio settings a data source of the type "Google sheet". Copy the spreadsheet URL from your browser's address bar to the "Sheet URL" field in Admetrics, making sure to include the "/edit#gid=0" at the end.
Wait for the synchronization.