Skip to main content

​
Supported data types

Marketing cost

Ad spend and performance metrics

​
Prerequisites

  • A Google Sheets document shared with view access to [email protected]
  • 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 [email protected].
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
date
required
Date of the campaign data (YYYY-MM-DD according to ISO8601).

Format: ISO 8601
Example: 2025-02-20
​
channel
string
required
Marketing channel used.

Example: Facebook
​
channelGroup
string
required
Group classification of the channel.

Example: Social paid
​
cost
number
required
Total cost associated with the campaign.

Example: 1500
​
country
string
required
Targeted country (2 letters).

Format: ISO 3166
Example: SE
​
currency
string
required
Currency of the cost data (3 letters).

Format: ISO 4217
Example: SEK
​
campaign
string
Name of the campaign.

Example: Summer Sale 2025
​
campaignId
string
Unique identifier for the campaign.

Example: camp_12345
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
awin/zanoxbelboonbenify
beste.nobezrak.combilligt_kosttillskott
cjcuponationdouble.net
epassifrankgood_on_you
gowishhealthtraderinfluencer
klarnalinkbylinkshare/rakuten
maxbountymecenatmecenat_alumni
medicaltime.bgmetapicothers
partner-adsplaysitrecensionsplatsen
re:member_rewardsas_onlineshoppingsponsorhuset
steplerstudentkortetstyrkelabbet
tracdelighttradedoublertradetracker
trumf.nowebgainswordseed
wrappzdrave.net
backfilled_orders
contenteventflyers
gift_in_ordergiveawayim_macro
im_miniim_nanomedia_production
pr
automationbountycart_abandonment
clientelingcustomer_serviceengaged_subscribers
externalleafletloyalty_program
newsletteronboardingothers
post_purchasereminderrestock_alert
smstransaction
direct
adformbonnierclearchanneloutdoor
deltagoogleloopi
nyheter24othersrakuten
rocketfuelschibstedtve_interactive
apprlathletesbeatly
externalCollaborationsindependentinzpire
pressReleasereechseeding
miinto
tools_external
eventfairsleaflet
oohotherspartnerships
print
exit_intentotherspush_notice
ve_interactive
googlehintaopasidealo
kelkooothersprice_runner
pricepipricespyprisguiden
prisjaktprisvisshopalike
shopellospotashopstileo
twengavarusok.severtaa
articleblogblocket
bountycapterraflashback
forumfrankgoogle
idealomecenatnaver
nettavisenonskeskyenothers
podcastprreddit
redealshopellostepler
studentkortettrustpilottwenga
vg
adrollcriteofacebook
googlemythingsnosto
othersrakutenrocketfuel
rtbhousesociomanticve_interactive
bingduckduckgogoogle
othersyahooyandex
agencybaidubing
googlenaverothers
yahooyandex
facebookgoogleinstagram
kakaolinelinkedin
otherspinterestsnapchat
tiktoktwittervkontakte
wechatyoutube
facebookgoogleinfluencers
instagramkakaoline
linkedinotherspinterest
quorasnapchattiktok
twittervkontaktewechat
youtube
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.