​
Overview

​
Introduction

Integrating Google Sheets with our platform allows you to seamlessly import and analyze marketing cost data. This guide outlines the requirements and step-by-step process for setting up the integration.

​
Available Data Types

  • Marketing cost

​
Prerequisites

  • A Google Sheets document shared with tag@dema.ai account.
  • The Spreadsheet URL of the Google Sheets document.

​
Step-by-Step Integration Guide

1

Step 1: Create the Google Sheet

Create your Google Sheet according to the required schema. Ensure that all necessary data fields are accurately populated in the correct format.

For reference, you can review and follow the structure of this example Google Sheet.

2

Step 2: Ensure Correct Channel and Channel Group Values

Before sharing the sheet, ensure that the values in the “channel” and “channel group” columns match the available options listed in our available values section. These values are not case-sensitive.

3

Step 3: Share the Google Sheet

Once your Google Sheet is set up according to the schema and the “channel” and “channel group” values are correctly populated, share the sheet with view access to tag@dema.ai.

4

Step 4: Send the Spreadsheet URL

Copy the Spreadsheet URL and send it to your Customer Success Manager or support team. This URL will be used to integrate your Google Sheets data with our platform.

​
Schema

​
Required Schema

Column nameTypeDescriptionOptional
campaign
cost
currency

​
Available Values

​
Channel Available Values (not case sensitive)

Organic: google, yahoo, bing, yandex, duckduckgo, others

Social Organic: google, meta, facebook, tiktok, snapchat, vk, instagram, pinterest, linkedin, youtube, twitter, others

Display: google, adform, ve_interactive, rakuten, rocketfuel, nyheter24, bonnier, schibstedt, loopi, clearchanneloutdoor, others

Social Paid: twitter, meta, facebook, tiktok, snapchat, pinterest, vk, instagram, youtube, google, linkedin, quora, influencers, others

Search Paid: google, yahoo, yandex, bing, others

Price Comparison: pricespy, shopalike, price_runner, kelkoo, stileo, prisvis, pricepi, twenga, varusok, prisjakt, google, shopello, spotashop, prisguiden, idealo, others

Affiliate: double.net, tradedoubler, adrecord, webgains, adviralmedia, cj, zanox, tradetracker, adtraction, linkshare, playsit, zdrave, bezrak, medicaltime, wrapp, healthtrader, belboon, maxbounty, actionpay, partnerads, wordseed, others

Referral: bounty, reddit, flashback, naver, article, blog, forum, twenga, redeal, trustpilot, blocket, klarna, onskeskyen, capterra, google, shopello, studentkortet, nettavisen, vg, idealo, others

Influencers: apprl, independent, beatly, reech, inzpire

Email: newsletter, transaction, external, automation, cart_abandonment, bounty, engaged, sms, reminder, customerservice, leaflet, others, onboarding, restock_alert, post_purchase, loyalty_program

Offline: leaflet, others

Direct: direct

Retargeting: google, criteo, adroll, mythings, sociomantic, nosto, ve_interactive, rakuten, facebook, rocketfuel, rtbhouse, others

​
Channel Group Available Values (not case sensitive)

  • organic
  • social organic
  • display
  • social paid
  • search paid
  • affiliate
  • price comparison
  • referral
  • influencers
  • email
  • offline
  • direct
  • unknown
  • retargeting
  • onsite
  • backfilled

​
Processing

  • On the initial fetch, we import data going back two years.
  • For subsequent updates, we only fetch data from the last 30 days. Older data will not be updated.

​
Limitations

  • The data must reside in the first sheet tab of the Google Sheet.
  • Headers must be in the first row.
  • Only columns A-AZ are read.

​
Troubleshooting and Support

If you encounter any issues during the integration process or have questions regarding data processing, please contact our support team for assistance.

​
Additional Resources

For further information on managing your Google Sheets and understanding data formats, visit the Google Sheets Help Center.

Google tag manager