ActiveCampaign: Using the Ecomm Integration resources for Shopify
The ActiveCampaign data connector includes three ecommerce resources that you are able to connect to. (For a full description of the resources you can refer to the resource document from page 14 onwards)
These are
- ecomCustomers
- ecomOrderProducts
- ecomOrders
For these to be populated you need to have set up an Ecomm integration within your ActiveCampaign Account. Navigate to the following screen from your ActiveCampaign Account.
https://yourcompany.activehosted.com/app/integrations
Once there you will need to click the "Add Integration" Button. This will give a list of applications to connect to.
We have connected Shopify- You can also connect WooCommerce, Magento and Big Commerce.
Follow the prompts to connect your site. Once connected you can now navigate to Looker Studio and add the three resources as data sources and start building your Dashboards. All monetary values are listed in cents. So you will need to convert these. In the example below our currency is in cents. So to get to a dollar value we divide by 100.
EcommCustomers
This resource provides a summary of customer purchases. Email or CustomerId are unique. All monetary values are listed in cents. So you will need to convert these. In the example below our currency is in cents. So to get to a dollar value we divide by 100.
Calculated fields/flags include
- acceptsMarketing
- totalOrders
- totalProducts
- totalRevenue
- AvgRevenuePerOrder
- avgProductCategory
EcommOrders
This resource provides a summary of your orders. It includes customerid, email, shipping method and is unique by Id or OrderNumber. It also includes abandoned date if an order was not completed. Other fields include currency, Order Date.
Calculated fields include
- discountAmount
- shippingAmount
- taxAmount
- totalPrice
- totalProducts
In the screen shot from this resource you can see a table of orders and also a chart which shows you total number of orders by day of week.
EcommOrderProducts
This resource shows you all of the products that make up an order. All monetary values are listed in cents. So you will need to convert these. In the example below our currency is in cents. So to get to a dollar value we divide by 100.
The resource includes order date and product information includes SKU and the Category it can be found in your store. You will need to join/blend with EcommOrders to get customer details.
Related Articles
Looker Studio: Speed up your dashboards
Have you been in meeting or presentation and wanted to be able to share insight on Looker Studio but were hesitant because you never know how long you will be waiting your dashboard to render? If the answer to to that question is yes. Have you tried ...ActiveCampaign: Creating your first Looker Studio data source to build your custom Dashboard
Build Your Report Adding and authorising Find My Insight ActiveCampaign Connector in Google Data Studio. This guide shows you how to use a Find My Insight Connector for Data Studio, It's pretty simple, just add and then authorize the connector. This ...Looker Studio: Creating a date dimension from a datetimestamp
Often when building a dashboard you will want to group activities (metrics) by a datetime dimension. This could be day, week, month, year etc. Looker studio lets you select any of those attributes once you have dragged this into the chart. However, ...ActiveCampaign: Using resource "Campaign Report Open List"
When you create a data source using the resource 'Campaign Report Open List' you will need to use the date dimensions 'tstamp' and 'tstamp_iso'. It also required the use of a parameter for the 'campaign id' there are several ways to obtain a campaign ...ActiveCampaign: Resource Documentation
For a detailed description of all the ActiveCampaign resources and tips for using the ActiveCampaign connector for Data Studio you can download the document here It lists all resources and contains a description of each dimension or metric in each ...