Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.dema.ai/llms.txt

Use this file to discover all available pages before exploring further.

​
Supported data types

Marketing cost

Ad spend and performance metrics

​
Prerequisites

  • A Google Sheets document shared with view access to tag@dema.ai
  • The URL of your Google Sheets document

​
Step-by-step integration guide

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

Verify channel 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

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

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

Marketing cost data for campaign tracking and ROI analysis.
The channel and channelGroup fields must match one of the available channel values. Values are case-insensitive.
Required:
date,channel,channelGroup,campaign,cost,country,currency,campaignId
2024-01-15,facebook,social_ppc,Summer Sale 2024,1250.75,US,USD,camp_001
2024-01-15,instagram,social_ppc,Summer Sale 2024,875.50,US,USD,camp_002
2024-01-16,google,sem,Winter Collection,2100.25,GB,GBP,camp_003
2024-01-17,newsletter,email,New Arrivals,350.00,DE,EUR,camp_004

​
Available values

​
Channel groups & channels

All channel and channel group values are case-insensitive. You can use any combination of uppercase and lowercase letters.
Each accordion below represents a channel group (with its code in parentheses). The values listed are the available channels for that group.
actionpayadtractionadviralmedia
awinawin/zanoxbelboon
benifybeste.nobezrak.com
billigt_kosttillskottbnplcashbackPartner
cjcontentPartnercuponation
discountCodePartnerdouble.neteditorialPartner
epassifrankgood_on_you
gowishhealthtraderimpact
influencerinfluencerNetworkklarna
linkbylinkshare/rakutenloyaltyPartner
maxbountymecenatmecenat_alumni
medicaltime.bgmetapicothers
partner-adsplaysitrecensionsplatsen
re:member_rewardsas_onlineshoppingsponsorhuset
steplerstudentkortetstyrkelabbet
subNetworktracdelighttradedoubler
tradetrackertrumf.nowebgains
wordseedwrappzdrave.net
chatgptclaudecopilot
deepseekgeminigrok
meta_aimistralothers
perplexityphindpoe
you_com
chatgptclaudecopilot
deepseekgeminigrok
meta_aimistralothers
perplexityphindpoe
you_com
backfilled_orders
contenteventflyers
gift_in_ordergiveawayim_macro
im_miniim_nanomedia_production
prstore
automationbountycart_abandonment
clientelingcustomer_serviceengaged_subscribers
externalleafletloyalty_program
newsletteronboardingothers
post_purchasereminderrestock_alert
samplesmstransaction
direct
adformbonnierclearchanneloutdoor
criteodeltagoogle
loopimntnnyheter24
othersrakutenrocketfuel
schibstedtve_interactive
apprlathletesbeatly
contentCreatorsexternalCollaborationsindependent
inzpiremetapicpressRelease
reechseeding
miinto
tools_external
eventfairsleaflet
oohotherspartnerships
printwholesale
exit_intentotherspush_notice
ve_interactive
googlehintaopasidealo
kelkooothersprice_runner
pricepipricespyprisguiden
prisjaktprisvisshopalike
shopellospotashopstileo
twengavarusok.severtaa
articleblogblocket
bountycapterraclearpay
flashbackforumfrank
googleidealomecenat
navernettavisenonskeskyen
otherspodcastpr
redditredealshopello
steplerstudentkortettrustpilot
twengavg
adrollcriteofacebook
googlemythingsnosto
othersrakutenrocketfuel
rtbhousesociomanticve_interactive
bingduckduckgogoogle
othersyahooyandex
agencybaidubing
googlenaverothers
shoptimisedyahooyandex
facebookgoogleinstagram
kakaolinelinkedin
otherspinterestsnapchat
tiktoktwittervkontakte
wechatyoutube
facebookgoogleinfluencers
instagramkakaoline
linkedinotherspinterest
quoraredditsnapchat
tiktoktwittervkontakte
wechatyoutube
dummyunknown
facebookgoogleinfluencers
instagramlinkedinothers
pinterestquorasnapchat
tiktoktwittervkontakte
youtube

​
Processing

Initial import

On the first fetch, we import data going back two years

Ongoing updates

Subsequent updates fetch data from the last 30 days only. Older data will not be updated.

​
Limitations

Please ensure your Google Sheet meets these requirements:
  • Data must reside in the first sheet tab
  • 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.