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.aiaccount. - 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 name | Type | Description | Optional |
|---|---|---|---|
| campaign | |||
| campaignId | Yes | ||
| cost | |||
| No | |||
| currency |
Available Values
All channel and channel group values are case-insensitive. You can use any combination of uppercase and lowercase letters.
Channel Groups & Channels
Each card title represents a channel group (with its code in parentheses), and the values inside each card are the available channels for that group.Affiliate (affiliate)
actionpayadtractionadviralawin/zanoxbelboonbenifybeste.nobezrak.combilligt_kosttillskottcjcuponationdouble.netepassifrankgood_on_yougowishhealthtraderinfluencerklarnalinkbylinkshare/rakutenmaxbountymecenatmecenat_alumnimedicaltime.bgmetapicotherpartner-adsplaysitrecensionsplatsenre:member_rewardsas_onlineshoppingsponsorhusetsteplerstudentkortetstyrkelabbettracdelighttradedoublertradetrackertrumf.nowebgainswordseedwrappzdrave.net
Backfilled Orders (backfilled)
backfilled_orders
Branding (branding)
contenteventflyersgift_in_ordergiveawayim_macroim_miniim_nanomedia_productionpr
CRM (email)
automationbountycart_abandonmentclientelingcustomer_serviceengaged_subscribersexternalleafletloyalty_programnewsletteronboardingotherpost_purchasereminderrestock_alertsmstransaction
Direct (direct)
direct
Display (display)
adformbonnierclearchanneldeltagoogleloopinyheter24otherrakutenrocket_fuelschibstedtve_interactive
Influencers (influencers)
apprlbeatlyindependentinzpirereechseeding
Marketplace (marketplace)
miinto
Offline (offline)
eventleafletoohotherprint
Onsite (onsite)
exit_intentotherpush_noticeve_interactive
Price Comparison (price_comparison)
googlehintaopasidealokelkoootherprice_runnerpricepipricespyprisguidenprisjaktprisvisshopalikeshopellospotashopstileotwengavarusok.severtaa
Referral (referral)
articleblogblocketbountycapterraflashbackforumfrankgoogleidealomecenatnavernettavisenonskeskyenotherpodcastprredditredealshopellosteplerstudentkortettrustpilottwengavg
Retargeting (retargeting)
adrollcriteofacebookgooglemythingsnostootherrakutenrocket_fuelrtbhousesociomanticve_interactive
Search Organic (organic)
bingduckduckgogoogleotheryahooyandex
Search Paid (sem)
agencybaidubinggooglenaverotheryahooyandex
Social Organic (social_organic)
facebookgoogleinstagramkakaolinelinkedinotherpinterestsnapchattiktoktwittervkontaktewechatyoutube
Social Paid (social_ppc)
facebookgoogleinfluencersinstagramkakaolinelinkedinotherpinterestquorasnapchattiktoktwittervkontaktewechatyoutube
Unknown (unknown)
dummyunknown
Whitelisting (whitelisting)
facebookgoogleinfluencersinstagramlinkedinotherpinterestquorasnapchattiktoktwittervkontakteyoutube
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.