https://dreamy-stroopwafel-0a96d0.netlify.app/assets/js/3a7fd408.e1fbee7d.js

1"use strict";(self.webpackChunkepilocal_docs=self.webpackChunkepilocal_docs||[]).push([[844],{7162:(e,i,t)=>{t.r(i),t.d(i,{assets:()=>c,contentTitle:()=>m,default:()=>h,frontMatter:()=>r,metadata:()=>p,toc:()=>d});var s=t(4848),n=t(8453),a=t(5917);const o=[{name:"Account Email",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"The email associated with the Mailchimp account"},{name:"Account Name",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"The name of the Mailchimp account"},{name:"Automation Date Created",type:"Dimension",views:"Automations",description:"The date and time the Automation was created"},{name:"Automation Date Started",type:"Dimension",views:"Automations",description:"The date and time the Automation was started"},{name:"Automation ID",type:"Dimension",views:"Automations",description:"A string that identifies the Automation"},{name:"Automation Status",type:"Dimension",views:"Automations",description:'The current status of the Automation. Possible values: "save", "paused", or "sending'},{name:"Automation Title",type:"Dimension",views:"Automations",description:"The title of the Automation"},{name:"Automation Total Click Rate",type:"Metric",views:"Automations",description:"The all-time total click rate for the Automation"},{name:"Automation Total Clicks",type:"Metric",views:"Automations",description:"The all-time total clicks for the Automation"},{name:"Automation Total Emails Sent",type:"Metric",views:"Automations",description:"The all-time total number of emails sent for the Automation"},{name:"Automation Total Open Rate",type:"Metric",views:"Automations",description:"The all-time total open rate for the Automation"},{name:"Automation Total Opens",type:"Metric",views:"Automations",description:"The all-time total opens for the Automation"},{name:"Automation Total Subscriber Opens",type:"Metric",views:"Automations",description:"The all-time total unique subscriber clicks for the Automation"},{name:"Automation Total Unique Opens",type:"Metric",views:"Automations",description:"The all-time total of unique opens for the Automation"},{name:"Automation Type",type:"Dimension",views:"Automations",description:'The type of Automation workflow. Possible values: "abandonedBrowse", "abandonedCart", "api", "bestCustomers", "categoryFollowup", "dateAdded", "emailFollowup", "emailSeries", "groupAdd", "groupRemove", "mandrill", "productFollowup", "purchaseFollowup", "recurringEvent", "specialEvent", "visitUrl", or "welcomeSeries'},{name:"Campaign Abuse Reports",type:"Metric",views:"Campaigns",description:"The number of abuse reports generated for a campaign"},{name:"Campaign Currency Code",type:"Dimension",views:"Campaigns",description:"The currency code for Campaign Revenue and Campaign Spent metrics"},{name:"Campaign Emails Sent",type:"Metric",views:"Campaigns",description:"The total number of emails sent for the campaign"},{name:"Campaign Facebook Likes",type:"Metric",views:"Campaigns",description:"The number of Facebook likes for the campaign"},{name:"Campaign Facebook Recipient Likes",type:"Metric",views:"Campaigns",description:"The number of recipients who liked the campaign on Facebook"},{name:"Campaign Facebook Unique Likes",type:"Metric",views:"Campaigns",description:"The number of unique Facebook likes for the campaign"},{name:"Campaign Forwarded Opens",type:"Metric",views:"Campaigns",description:"How many times the forwarded campaign has been opened"},{name:"Campaign Forwards",type:"Metric",views:"Campaigns",description:"How many times the campaign has been forwarded"},{name:"Campaign Hard Bounces",type:"Metric",views:"Campaigns",description:"The total number of hard bounced email addresses for the campaign"},{name:"Campaign ID",type:"Dimension",views:"Campaigns, Campaign Timeseries, Campaign Link Clicks",description:"The string that uniquely identifies a campaign"},{name:"Campaign Last Click Date",type:"Dimension",views:"Campaigns",description:"The date of the last recorded click for the campaign"},{name:"Campaign Last Open Date",type:"Dimension",views:"Campaigns",description:"The date of the last recorded open for the campaign"},{name:"Campaign Last Sent",type:"Dimension",views:"Campaigns",description:"The date a campaign was last sent"},{name:"Campaign Link ID",type:"Dimension",views:"Campaign Link Clicks",description:"The unique ID of the campaign link"},{name:"Campaign Link Last Click Time",type:"Dimension",views:"Campaign Link Clicks",description:"The date and hour for the last recorded click for a campaign link"},{name:"Campaign Link Total Click Percentage",type:"Metric",views:"Campaign Link Clicks",description:"The percentage of total clicks a link generated for a campaign"},{name:"Campaign Link Total Clicks",type:"Metric",views:"Campaign Link Clicks",description:"The number of total clicks for a campaign link"},{name:"Campaign Link Unique Click Percentage",type:"Metric",views:"Campaign Link Clicks",description:"The percentage of unique clicks a link generated for a campaign"},{name:"Campaign Link Unique Clicks",type:"Metric",views:"Campaign Link Clicks",description:"The number of unique clicks for a campaign link"},{name:"Campaign Link URL",type:"Dimension",views:"Campaign Link Clicks",description:"The url of the campaign link"},{name:"Campaign Opens",type:"Metric",views:"Campaigns",description:"The total number of opens for the campaign"},{name:"Campaign Orders",type:"Metric",views:"Campaigns",description:"The total orders for the campaign"},{name:"Campaign Preview Text",type:"Dimension",views:"Campaigns, Campaign Timeseries, Campaign Link Clicks",description:"The preview text for the campaign"},{name:"Campaign Revenue",type:"Metric",views:"Campaigns",description:"The total revenue for the campaign. Calculated as the sum of all order totals minu

1s shipping and tax totals"},{name:"Campaign RSS Last Sent",type:"Dimension",views:"Campaigns",description:"For RSS campaigns, the date of the last send"},{name:"Campaign Soft Bounces",type:"Metric",views:"Campaigns",description:"The total number of soft bounced email addresses for the campaign"},{name:"Campaign Spent",type:"Metric",views:"Campaigns",description:"The total spent for the campaign. Calculated as the sum of all order totals with no deductions"},{name:"Campaign Subject Line",type:"Dimension",views:"Campaigns, Campaign Timeseries, Campaign Link Clicks",description:"The subject line for the campaign"},{name:"Campaign Subscriber Clicks",type:"Metric",views:"Campaigns",description:"The total number of subscribers who clicked on a campaign"},{name:"Campaign Syntax Errors",type:"Metric",views:"Campaigns",description:"The total number of addresses that were syntax-related bounces for the campaign"},{name:"Campaign Title",type:"Dimension",views:"Campaigns, Campaign Timeseries, Campaign Link Clicks",description:"The title of the campaign"},{name:"Campaign Total Clicks",type:"Metric",views:"Campaigns",description:"The total number of clicks for the campaign"},{name:"Campaign Type",type:"Dimension",views:"Campaigns, Campaign Timeseries, Campaign Link Clicks",description:'The campaign type. Possible values: "regular", "plaintext", "absplit", "rss", or "variate'},{name:"Campaign Unique Click Rate",type:"Metric",views:"Campaigns",description:"The number of unique clicks divided by the total number of successful deliveries for the campaign"},{name:"Campaign Unique Clicks",type:"Metric",views:"Campaigns",description:"The total number of unique clicks for links across a campaign"},{name:"Campaign Unique Open Rate",type:"Metric",views:"Campaigns",description:"The number of unique opens divided by the total number of successful deliveries for the campaign"},{name:"Campaign Unique Opens",type:"Metric",views:"Campaigns",description:"The total number of unique opens for the campaign"},{name:"Campaign Unsubscribes",type:"Metric",views:"Campaigns",description:"The total number of unsubscribed members for the campaign"},{name:"List Avg. Click Rate",type:"Metric",views:"Campaigns, Automations",description:"The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list"},{name:"List Avg. Open Rate",type:"Metric",views:"Campaigns, Automations",description:"The average open rate per campaign for the list"},{name:"List Avg. Subs per Month",type:"Metric",views:"Campaigns, Automations",description:"The average number of subscriptions per month for the list"},{name:"List Avg. Unsubscribes per Month",type:"Metric",views:"Campaigns, Automations",description:"The average number of unsubscriptions per month for the list"},{name:"List Created Date",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"The date this list was created"},{name:"List Growth Cleaned",type:"Metric",views:"List Growth",description:"Newly cleaned (hard-bounced) members on the list for a specific month"},{name:"List Growth Deleted",type:"Metric",views:"List Growth",description:"Newly deleted members on the list for a specific month"},{name:"List Growth Month",type:"Dimension",views:"List Growth",description:"The month that the growth history is describing"},{name:"List Growth Pending",type:"Metric",views:"List Growth",description:"Pending members on the list for a specific month"},{name:"List Growth Reconfirmed",type:"Metric",views:"List Growth",description:"Newly reconfirmed members on the list for a specific month"},{name:"List Growth Total Subscribers",type:"Metric",views:"List Growth",description:"Total subscribed members on the list at the end of the month"},{name:"List Growth Transactional Emails",type:"Metric",views:"List Growth",description:"Subscribers that have been sent transactional emails via Mandrill"},{name:"List Growth Unsubscribed",type:"Metric",views:"List Growth",description:"Newly unsubscribed members on the list for a specific month"},{name:"List Has Double Optin",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"Whether or not the subscriber has to confirm subscription to the list via email"},{name:"List Has Welcome",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"Whether or not this list has a welcome automation connected. Welcome Automations: welcomeSeries, singleWelcome, emailFollowup"},{name:"List ID",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"A string that uniquely identifies the list"},{name:"List is Active",type:"Dimension",views:"Campaigns, Automations",description:"The status of the list used, namely if it's deleted or disabled"},{name:"List Last Campaign Sent Date",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"The date the last campaign was sent to this list"},{name:"List Last Sub Date",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"The date of the last time someone subscribed to the list"},{name:"List Last Unsubscribe Date",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"The date of the last time someone unsubscribed from the list"},{name:"List Members",type:"Metric",views:"Campaigns, Automations",description:"The number of active members in the list"},{name:"List Members Cleaned",type:"Metric",views:"Campaigns, Automations",description:"The number of members cleaned from the list"},{name:"List Members Cleaned Since Last Send",type:"Metric",views:"Campaigns, Automations",description:"The number of members cleaned from the list since the last campaign was sent"},{name:"List Merge Variables",type:"Metric",views:"Campaigns, Automations",description:"The number of merge vars for this list (not EMAIL, which is required)"},{name:"List Name",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"The name of the list"},{name:"List New Members Since Last Send",type:"Metric",views:"Campaigns, Automations",description:"The number of active members in the list since the last campaign was sent"},{name:"List Number of Campaigns",type:"Metric",views:"Campaigns, Automations",description:"The number of campaigns in any status that use this list"},{name:"List Rating",type:"Dimension",views:"Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks",description:"An auto-generated activity score for the list (0-5)"},{name:"List Target Subs per Month",type:"Metric",views:"Campaigns, Automations",description:"The target number of subscriptions per month for the list to keep it growing"},{name:"List Unsubscribes",type:"Metric",views:"Campaigns, Automations",description:"The number of members who have unsubscribed from the list"},{name:"List Unsubscribes Since Last Send",type:"Metric",views:"Campaigns, Automations",description:"The number of members who have unsubscribed since the last campaign was sent"},{name:"Member Avg. Click Rate",type:"Metric",views:"Members",description:"A subscriber's average clickthrough rate"},{name:"Member Avg. Open Rate",type:"Metric",views:"Members",description:"A subscriber's average open rate"},{name:"Member Consents to 1-to-1 Messaging",type:"Dimension",views:"Members",description:"Indicates whether a contact consents to 1:1 messaging"},{name:"Member Contact ID",type:"Dimension",views:"Members",description:"As Mailchimp evolves beyond email, you may eventually have contacts without email addresses. While the id is the MD5 hash of their email address, this contact_id is agnostic of contact\u2019s inclusion of an email address"},{name:"Member Email",type:"Dimension",views:"Members",description:"Email address for a subscriber"},{name:"Member Email Client",type:"Dimension",views:"Members",description:"The list member's email client"},{name:"Member Email Type",type:"Dimension",views:"Members",description:"Type of email this member asked to get ('html' or 'text')"},{name:"Member Full Name",type:"Dimension",views:"Members",description:"The contact's full name"},{name:"Member ID",type:"Dimension",views:"Members",description:"The MD5 hash of the lowercase version of the list member's email address"},{name:"Member Interest Groups",type:"Dimension",views:"Members",description:"Interest groups that subscriber is currently subscribed to"},{name:"Member is VIP",type:"Dimension",views:"Members",description:"Mailchimp VIP status for a subscriber"},{name:"Member Language",type:"Dimension",views:"Members",description:"If set/detected by Mailchimp, the subscriber's language"},{name:"Member Location Country Code",type:"Dimension",views:"Members",description:"The unique code for the location country of a member"},{name:"Member Location DST Offset",type:"Dimension",views:"Members",description:"The offset for timezones where daylight saving time is observed for a member"},{name:"Member Location GMT Offset",type:"Dimension",views:"Members",description:"The time difference in hours from GMT for a member"},{name:"Member Location Lat/Long",type:"Dimension",views:"Members",description:"The combined location latitude and longitude of a member in ISO 6709 format"},{name:"Member Location Latitude",type:"Dimension",views:"Members",description:"The location latitude of a member"},{name:"Member Location Longitude",type:"Dimension",views:"Members",description:"The location longitude of a member"},{name:"Member Location Timezone",type:"Dimension",views:"Members",description:"The timezone for the location of a member"},{name:"Member Opt-in IP Address",type:"Dimension",views:"Members",description:"The IP address the subscriber used to confirm their opt-in status"},{name:"Member Rating",type:"Dimension",views:"Members",description:"Mailchimp generated star rating for this member, between 1 and 5"},{name:"Member Signup IP Address",type:"Dimension",views:"Members",description:"IP address the subscriber signed up from"},{name:"Member Source",type:"Dimension",views:"Members",description:"The source from which the member was added to this list"},{name:"Member Status",type:"Dimension",views:"Members",description:"Subscriber's current status. Possible values: 'subscribed', 'unsubscribed', 'cleaned', 'pending', 'transactional', or 'archived'"},{name:"Member Tags",type:"Dimension",views:"Members",description:"Tags that are applied to the member (supports up to 50 tags)"},{name:"Member Time Last Changed",type:"Dimension",views:"Members",description:"The date and time the member's info was last changed in ISO 8601 format"},{name:"Member Time of Opt-in",type:"Dimension",views:"Members",description:"The date and time the subscribe confirmed their opt-in status in ISO 8601 format"},{name:"Member Time of Signup",type:"Dimension",views:"Members",description:"The date and time the subscriber signed up for the list in ISO 8601 format"},{name:"Member Total Orders",type:"Metric",views:"Members",description:"The total number of orders placed by the list member"},{name:"Member Total Revenue",type:"Metric",views:"Members",description:"The total revenue the list member has brought in"},{name:"Member Total Revenue Currency Code",type:"Dimension",views:"Members",description:"The three-letter ISO 4217 code for the currency that the store accepts"},{name:"Member Unique ID",type:"Dimension",views:"Members",description:"An identifier for the address across all of Mailchimp"},{name:"Member Unsubscribe Reason",type:"Dimension",views:"Members",description:"A subscriber's reason for unsubscribing"},{name:"Member Web ID",type:"Dimension",views:"Members",description:"The ID used in the Mailchimp web application. View this member in your Mailchimp account at https://{dc}.admin.mailchimp.com/lists/members/view?id={web_id}."},{name:"Timeseries Clicks",type:"Metric",views:"Campaign Timeseries",description:"The number of clicks by hour of a campaign"},{name:"Timeseries Date",type:"Dimension",views:"Campaign Timeseries",description:"The date for the 24 hour timeseries after a campaign is started"},{name:"Timeseries Date and Hour",type:"Dimension",views:"Campaign Timeseries",description:"The date and hour for the 24 hour timeseries after a campaign is started"},{name:"Timeseries Emails Sent",type:"Dimension",views:"Campaign Timeseries",description:"The number of emails sent in by hour of a campaign"},{name:"Timeseries Hour of Campaign",type:"Dimension",views:"Campaign Timeseries",description:"The number of hours after a campaign started"},{name:"Timeseries Hour of Day",type:"Dimension",views:"Campaign Timeseries",description:"The hour of the day for the 24 hour timeseries after a campaign is started"},{name:"Timeseries Unique Opens",type:"Dimension",views:"Campaign Timeseries",description:"The number of unique opens by hour of a campaign"}],r={sidebar_position:3.2,description:"Reference for all of the data fields that are available to use in the Mailchimp Looker Studio Connector"},m="Mailchimp Field Reference",p={id:"data-sources/mailchimp/fields",title:"Mailchimp Field Reference",description:"Reference for all of the data fields that are available to use in the Mailchimp Looker Studio Connector",source:"@site/docs/data-sources/mailchimp/fields.md",sourceDirName:"data-sources/mailchimp",slug:"/data-sources/mailchimp/fields",permalink:"/data-sources/mailchimp/fields",draft:!1,unlisted:!1,tags:[],version:"current",sidebarPosition:3.2,frontMatter:{

1sidebar_position:3.2,description:"Reference for all of the data fields that are available to use in the Mailchimp Looker Studio Connector"},sidebar:"tutorialSidebar",previous:{title:"Getting Started with Mailchimp",permalink:"/data-sources/mailchimp/getting-started"},next:{title:"Mailchimp Guides",permalink:"/data-sources/mailchimp/guides"}},c={},d=[];function l(e){const i={h1:"h1",...(0,n.R)(),...e.components};return(0,s.jsxs)(s.Fragment,{children:[(0,s.jsx)(i.h1,{id:"mailchimp-field-reference",children:"Mailchimp Field Reference"}),"\n","\n",(0,s.jsx)(a.A,{fields:o})]})}function h(e={}){const{wrapper:i}={...(0,n.R)(),...e.components};return i?(0,s.jsx)(i,{...e,children:(0,s.jsx)(l,{...e})}):l(e)}},5917:(e,i,t)=>{t.d(i,{A:()=>r});t(6540);const s="fieldsTableContainer_HwAK",n="fieldsTableName_q0J9",a="fieldsTableContent_Uk2C";var o=t(4848);const r=e=>{let{fields:i}=e;return(0,o.jsx)("div",{children:i.map(((e,i)=>(0,o.jsxs)("div",{className:s,style:0===i?{borderTop:"solid 1px grey",borderBottom:"solid 1px grey"}:{borderBottom:"solid 1px grey"},children:[(0,o.jsx)("div",{className:n,children:(0,o.jsx)("p",{style:{fontWeight:"700"},children:e.name})}),(0,o.jsxs)("div",{className:a,children:[(0,o.jsx)("p",{children:e.description}),(0,o.jsxs)("p",{style:{marginBottom:"0"},children:[(0,o.jsx)("span",{style:{fontWeight:"600",marginRight:"5px"},children:"Field Type:"}),e.type]}),e.views&&(0,o.jsxs)("p",{style:{marginBottom:"0"},children:[(0,o.jsx)("span",{style:{fontWeight:"600",marginRight:"5px"},children:"Data Views:"}),e.views]}),e.plans&&(0,o.jsxs)("p",{style:{marginBottom:"0"},children:[(0,o.jsx)("span",{style:{fontWeight:"600",marginRight:"5px"},children:"Plans:"}),e.plans]})]})]},`fields-table-${i}`)))})}},8453:(e,i,t)=>{t.d(i,{R:()=>o,x:()=>r});var s=t(6540);const n={},a=s.createContext(n);function o(e){const i=s.useContext(a);return s.useMemo((function(){return"function"==typeof e?e(i):{...i,...e}}),[i,e])}function r(e){let i;return i=e.disableParentContext?"function"==typeof e.components?e.components(n):e.components||n:o(e.components),s.createElement(a.Provider,{value:i},e.children)}}}]);