Has anyone had success mapping Tessitura's order model to Google's ecommerce model?
Google Analytics' ecommerce feature collects the following info about an order, which it calls a "transaction":- ID (order no.)- affiliation (name of a partner or store)- total ($)- shipping ($)- tax ($)- products (a list of products)In the list of products, each item has the following properties:- name- SKU- category- price (per unit)- quantity
My most pressing considerations are:
JAMIE O'BRIEN
ASSISTANT DIRECTOR OF DIGITAL SERVICESTHE NEW 42ND STREET229 W 42ND STREET, NEW YORK, NY 10036WWW.NEW42.ORG
Has anyone had success mapping Tessitura's order model to Google's ecommerce model? Google Analytics' ecommerce feature collects the following info about an order, which it calls a "transaction":- ID (order no.)- affiliation (name of a partner or store)- total ($)- shipping ($) - tax ($)- products (a list of products)In the list of products, each item has the following properties:- name- SKU- category- price (per unit)- quantity My most pressing considerations are: What is useful to map to affiliation? We're thinking mode-of-sale. What exactly is a "product" in the Tessitura domain? We're thinking it may be a combination of performance, zone, and price-type. Maybe that's too granular. What is useful to map to category? Perhaps season-number...? This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Google Analytics' ecommerce feature collects the following info about an order, which it calls a "transaction":- ID (order no.)- affiliation (name of a partner or store)- total ($)- shipping ($) - tax ($)- products (a list of products)In the list of products, each item has the following properties:- name- SKU- category- price (per unit)- quantity
I probably went a little overboard when I set this up, but our set up is as follows.
Order Level
Order Number : NT + Tessitura Order NumberAffiliation Store Name : TicketingThis is to allow for Bookshop and Digital integration in the future.
If we can capture Country at this level that would be useful as would Postage/Shipping amount.
Order ItemsOrder Number : NT + Tessitura Order Numberquantity and unit price should be standard
Tickets SKU : TK+’/’+Perf_code (or perf_no if code not available)+’/’+Price in penniesProd Name : Production NameCategory : Performance Date + '/' + Section
Programme Vouchers (and other Ticketed Vouchers)SKU : VC+’/’+Perf_code (or perf_no if code not available)Prod Name : Voucher Type (ie Programme Voucher)Category : Production Name
Membership SKU : ML+’/’+ Three letter membership code (or other unique id)Prod Name : MembershipCategory : memebrship Description (eg Advance UK £15.00)
Gift Certificates SKU : GV/CERTIFICATEProd Name : Gift Certificate
Gift membership SKU : GV/MEMBERProd Name : Gift Membership
Tessitura Merchandise (Fee category 8 - Merchandise)SKU : TM +'/' + fee_idProd Name : Fee Description
There was then some logic that aggregated some of these as Google has requirement that a SKU can only appear once in an order.
Hope that helps
Mark
Mark,
Thanks for your insight into this! Here's what I've settled on for my organization, for performances:
Object
Field
Data type
Mapped Tess. data
Transaction
ID
string
order number
Affiliation
mode of sale
Total
number
order total
Shipping
fee total
Tax
n/a
Product
Name
title + date and time + zone + price type
SKU
perf. code + zone ID + price type ID
Category
season name + season number
Price
amount paid per ticket
Quantity
number of tickets