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)
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.
Integrate your Shopify with ActiveCampaign for richer customer experiences
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.
Integrate Shopify, WooCommerce, Magento and BigCommerce for more Looker Studio insights
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.
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
View your Ecomm customer history with the Looker Studio Connector by Datagems
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
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.
View your Ecomm Order Summary with the Looker Studio Connector by Datagems
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.
View your Ecomm Order Details with the Looker Studio Connector by Datagems