Google Sheets - Dema.ai documentation

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

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.

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.

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.

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.

All fields

Required:

Example file

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. Values are normalized automatically — for example, "Facebook" becomes facebook, "Social Paid" becomes social_ppc. Unknown channel values are accepted and stored as-is, but using the canonical IDs listed below ensures correct analytics grouping.

Each accordion below represents a channel group (with its canonical ID in parentheses). The values listed are the available channels for that group.

Affiliate (affiliate)


`actionpay`	`adrecord`	`adtraction`
`adviralmedia`	`awin`	`belboon`
`benify`	`beste.no`	`bezrak`
`billigt_kosttillskott`	`bnpl`	`cashbackPartner`
`cj`	`contentPartner`	`cuponation`
`discountCodePartner`	`double.net`	`editorialPartner`
`epassi`	`frank`	`goodonyou`
`gowish`	`healthtrader`	`impact`
`influencer`	`influencerNetwork`	`klarna`
`linkby`	`linkshare`	`loyaltyPartner`
`maxbounty`	`mecenat`	`mecenat_alumni`
`medicaltime`	`metapic`	`others`
`partnerads`	`playsit`	`recensionsplatsen`
`remember_reward`	`sas_onlineshopping`	`sponsorhuset`
`stepler`	`studentkortet`	`styrkelabbet`
`subNetwork`	`tracdelight`	`tradedoubler`
`tradetracker`	`trumf.no`	`webgains`
`wordseed`	`wrapp`	`zanox`
`zdrave`

AI Organic (ai_organic)


`chatgpt`	`claude`	`copilot`
`deepseek`	`gemini`	`grok`
`meta_ai`	`mistral`	`others`
`perplexity`	`phind`	`poe`
`you_com`

AI Paid (ai_paid)


`chatgpt`	`claude`	`copilot`
`deepseek`	`gemini`	`grok`
`meta_ai`	`mistral`	`others`
`perplexity`	`phind`	`poe`
`you_com`

Backfilled orders (backfilled)


`backfilled`

Branding (branding)


`content`	`event`	`flyers`
`gift_in_order`	`giveaway`	`im_macro`
`im_mini`	`im_nano`	`media_production`
`pr`	`store`

CRM (email)


`automation`	`bounty`	`cart_abandonment`
`clienteling`	`customerservice`	`email`
`engaged`	`external`	`leaflet`
`loyalty_program`	`newsletter`	`onboarding`
`others`	`post_purchase`	`reminder`
`restock_alert`	`sample`	`sms`
`transaction`

Direct (direct)


`direct`

Display (display)


`adform`	`bonnier`	`clearchanneloutdoor`
`criteo`	`delta`	`google`
`loopi`	`mntn`	`nyheter24`
`others`	`rakuten`	`rocketfuel`
`schibstedt`	`shopify_shop`	`stackadapt`
`ve_interactive`

Influencers (influencers)


`apprl`	`athletes`	`beatly`
`contentCreators`	`externalCollaborations`	`independent`
`inzpire`	`metapic`	`pressRelease`
`reech`	`seeding`

Marketplace (marketplace)


`miinto`	`shop_app`

Marketing (marketing)


`tools_external`

Offline (offline)


`event`	`fairs`	`leaflet`
`ooh`	`others`	`partnerships`
`print`	`wholesale`

Onsite (onsite)


`exit_intent`	`others`	`push_notice`
`ve_interactive`

Price comparison (price_comparison)


`google`	`hintaopas`	`idealo`
`kelkoo`	`others`	`price_runner`
`pricepi`	`pricespy`	`prisguiden`
`prisjakt`	`prisvis`	`shopalike`
`shopello`	`spotashop`	`stileo`
`twenga`	`varusok`	`vertaa`

Referral (referral)


`article`	`blocket`	`blog`
`bounty`	`capterra`	`clearpay`
`flashback`	`forum`	`frank`
`google`	`idealo`	`klarna`
`mecenat`	`naver`	`nettavisen`
`onskeskyen`	`others`	`podcast`
`pr`	`reddit`	`redeal`
`shopello`	`stepler`	`studentkortet`
`trustpilot`	`twenga`	`vg`

Retargeting (retargeting)


`adroll`	`criteo`	`facebook`
`google`	`mythings`	`nosto`
`others`	`rakuten`	`rocketfuel`
`rtbhouse`	`sociomantic`	`ve_interactive`

Search organic (organic)


`bing`	`duckduckgo`	`google`
`others`	`yahoo`	`yandex`

Search paid (sem)


`agency`	`baidu`	`bing`
`google`	`naver`	`others`
`shoptimised`	`yahoo`	`yandex`
`youtube`


`facebook`	`google`	`instagram`
`kakao`	`line`	`linkedin`
`others`	`pinterest`	`snapchat`
`threads`	`tiktok`	`twitter`
`vk`	`wechat`	`youtube`

Unknown (unknown)


`dummy`	`unknown`

Whitelisting (whitelisting)


`facebook`	`google`	`influencers`
`instagram`	`linkedin`	`others`
`pinterest`	`quora`	`snapchat`
`tiktok`	`twitter`	`vk`
`youtube`

Processing

Initial import

On the first fetch, we import historical data going back to 2023-01-01. If you have costs before that date, let us know — we recommend at least two years of data.

Ongoing updates

Subsequent updates fetch data from the last 30 days (or 90 days for Awin). Contact your Customer Success Manager if you need a historical re-import.

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.

​Supported data types

Marketing cost

​Prerequisites

​Step-by-step integration guide

​Schema

​Available values

​Channel groups & channels

​Processing

Initial import

Ongoing updates

​Limitations

​Troubleshooting and support

​Additional resources

Supported data types

Prerequisites

Step-by-step integration guide

Schema

Available values

Channel groups & channels

Processing

Limitations

Troubleshooting and support

Additional resources