Mailchimp
Outros · DisponívelConsultar via API
GET https://askaner.askan.com.br/api/v1/data/mailchimp?fields=date,account_id&date_preset=last_30d Authorization: Bearer ik_...
Campos (64 métricas, 85 dimensões)
| ID | Tipo | Natureza | Descrição |
|---|---|---|---|
account_id | TEXT | Dimensão | Account ID. |
account_name | TEXT | Dimensão | Account name. |
data_center | TEXT | Dimensão | The data center of the account. |
automation_email_archive_url | TEXT | Dimensão | The URL of the automation email's public archive page. |
automation_email_click_rate | PERCENT | Métrica | The number of subscriber clicks divided by the total number of emails sent for the automation email (bounce data is not available for automations). |
automation_email_clicks | NUMERIC | Métrica | The total number of clicks for the automation email. |
automation_email_emails_sent | NUMERIC | Métrica | The total number of emails sent for the automation email. |
automation_email_id | TEXT | Dimensão | A string that uniquely identifies the email within the automation workflow. |
automation_email_open_rate | PERCENT | Métrica | The number of unique opens divided by the total number of emails sent for the automation email (bounce data is not available for automations). |
automation_email_opens | NUMERIC | Métrica | The total number of opens for the automation email. |
automation_email_position | NUMERIC | Métrica | The position of the email in the automation workflow. |
automation_email_send_time | TIMESTAMP | Dimensão | The date and time the automation email was sent. |
automation_email_status | TEXT | Dimensão | The current status of the automation email. |
automation_email_subject_line | TEXT | Dimensão | The subject line of the automation email. |
automation_email_subscriber_clicks | NUMERIC | Métrica | The total number of subscribers who clicked in the automation email. |
automation_email_title | TEXT | Dimensão | The title of the automation email. |
automation_email_unique_opens | NUMERIC | Métrica | The total number of unique opens for the automation email. |
automation_email_workflow_id | TEXT | Dimensão | A string that uniquely identifies the automation workflow the email belongs to. |
automation_create_time | TIMESTAMP | Dimensão | The date and time the automation was created. |
automation_emails_sent | NUMERIC | Métrica | The total number of emails sent for the automation. |
automation_id | TEXT | Dimensão | A string that uniquely identifies this automation. |
automation_recipients_list_id | TEXT | Dimensão | The unique list id the automation sends to. |
automation_report_summary_click_rate | PERCENT | Métrica | The number of subscriber clicks divided by the total number of emails sent. |
automation_report_summary_clicks | NUMERIC | Métrica | The total number of clicks for the automation. |
automation_report_summary_open_rate | PERCENT | Métrica | The number of unique opens divided by the total number of emails sent. |
automation_report_summary_opens | NUMERIC | Métrica | The total number of opens for the automation. |
automation_report_summary_subscriber_clicks | NUMERIC | Métrica | The total number of subscribers who clicked in the automation. |
automation_report_summary_unique_opens | NUMERIC | Métrica | The total number of unique opens for the automation. |
automation_settings_title | TEXT | Dimensão | The title of the automation. |
automation_status | TEXT | Dimensão | The current status of the automation (save, paused, or sending). |
campaign_archive_url | TEXT | Dimensão | The shortened URL of the campaign's public archive (VIP) page. |
campaign_folder_id | TEXT | Dimensão | The ID of the folder the campaign is stored in. |
campaign_folder_name | TEXT | Dimensão | The name of the folder the campaign is stored in, resolved from the campaign folders endpoint. |
campaign_long_archive_url | TEXT | Dimensão | The original, full-length URL of the campaign's public archive page. |
url | TEXT | Dimensão | The URL for the link in the campaign. |
url_campaign_id | TEXT | Dimensão | A string that uniquely identifies this campaign. |
url_click_percentage | PERCENT | Métrica | The percentage of total clicks a link generated for a campaign. |
url_id | TEXT | Dimensão | The unique id for the link. |
url_last_click | TIMESTAMP | Dimensão | The date and time for the last recorded click for a link. |
url_total_clicks | NUMERIC | Métrica | The number of total clicks for a link. |
url_unique_click_percentage | PERCENT | Métrica | The percentage of unique clicks a link generated for a campaign. |
url_unique_clicks | NUMERIC | Métrica | Number of unique clicks for a link. |
cleaned_count | NUMERIC | Métrica | The number of members cleaned from the list. |
cleaned_count_since_send | NUMERIC | Métrica | The number of members cleaned from the list since the last campaign was sent. |
list_avg_sub_rate | NUMERIC | Métrica | The average number of subscriptions per month for the list (not returned if we haven't calculated it yet). |
list_avg_sub_rate_non_aggregated | NUMERIC | Métrica | (Internal) The average number of subscriptions per month for the list (not returned if we haven't calculated it yet). |
list_avg_unsub_rate | NUMERIC | Métrica | The average number of unsubscriptions per month for the list (not returned if we haven't calculated it yet). |
list_avg_unsub_rate_non_aggregated | NUMERIC | Métrica | (Internal) The average number of unsubscriptions per month for the list (not returned if we haven't calculated it yet). |
list_beamer_address | TEXT | Dimensão | The list's Email Beamer address. |
list_campaign_count | NUMERIC | Métrica | The number of campaigns in any status that use this list. |
list_campaign_defaults_from_email | TEXT | Dimensão | The default from email for campaigns sent to this list. |
list_campaign_defaults_from_name | TEXT | Dimensão | The default from name for campaigns sent to this list. |
list_campaign_defaults_language | TEXT | Dimensão | The default language for this lists's forms. |
list_campaign_defaults_subject | TEXT | Dimensão | The default subject line for campaigns sent to this list. |
list_campaign_last_sent | TIMESTAMP | Dimensão | The date and time the last campaign was sent to this list. This is updated when a campaign is sent to 10 or more recipients. |
list_click_rate | PERCENT | Métrica | The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet). |
list_click_rate_non_aggregated | PERCENT | Métrica | (Internal) The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet). |
list_contact_address1 | TEXT | Dimensão | The street address for the list contact. |
list_contact_address2 | TEXT | Dimensão | The street address for the list contact. |
list_contact_city | CITY | Dimensão | The city for the list contact. |
list_contact_company | TEXT | Dimensão | The company name for the list. |
list_contact_country | COUNTRY | Dimensão | A two-character ISO3166 country code. Defaults to US if invalid. |
list_contact_phone | TEXT | Dimensão | The phone number for the list contact. |
list_contact_state | TEXT | Dimensão | The state for the list contact. |
list_contact_zip | TEXT | Dimensão | The postal or zip code for the list contact. |
list_created | TIMESTAMP | Dimensão | The date and time that this list was created. |
list_double_opt_in | BOOLEAN | Dimensão | Whether or not to require the subscriber to confirm subscription via email. |
list_email_type_option | BOOLEAN | Dimensão | Whether the list supports multiple formats for emails. When set to true, subscribers can choose whether they want to receive HTML or plain-text emails. When set to false, subscribers will receive HTML emails, with a plain-text alternative backup. |
list_has_welcome | BOOLEAN | Dimensão | Whether or not this list has a welcome automation connected. Welcome Automations: welcomeSeries, singleWelcome, emailFollowup. |
list_id | TEXT | Dimensão | A string that uniquely identifies this list. |
list_last_subscribe | TIMESTAMP | Dimensão | The date and time of the last time someone subscribed to this list. |
list_last_unsubscribe | TIMESTAMP | Dimensão | The date and time of the last time someone unsubscribed from this list. |
list_marketing_permissions | BOOLEAN | Dimensão | Whether or not the list has marketing permissions (eg. GDPR) enabled. |
list_merge_field_count | NUMERIC | Métrica | The number of merge fields (audience field) for this list (doesn't include EMAIL). |
list_name | TEXT | Dimensão | The name of the list. |
list_notify_on_subscribe | TEXT | Dimensão | The email address to send subscribe notifications to. |
list_notify_on_unsubscribe | TEXT | Dimensão | The email address to send unsubscribe notifications to. |
list_open_rate | PERCENT | Métrica | The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet). |
list_open_rate_non_aggregated | PERCENT | Métrica | (Internal) The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet). |
list_permission_reminder | TEXT | Dimensão | The permission reminder for the list. |
list_rating | TEXT | Dimensão | An auto-generated activity score for the list (0-5). |
list_subscribe_url_long | TEXT | Dimensão | The full version of this list's subscribe form (host will vary). |
list_subscribe_url_short | TEXT | Dimensão | Our url shortened version of this list's subscribe form. |
list_target_sub_rate | NUMERIC | Métrica | The target number of subscriptions per month for the list to keep it growing (not returned if we haven't calculated it yet). |
list_total_contacts | NUMERIC | Métrica | The number of contacts in the list, including subscribed, unsubscribed, pending, cleaned, deleted, transactional, and those that need to be reconfirmed. |
list_use_archive_bar | BOOLEAN | Dimensão | Whether campaigns for this list use the Archive Bar in archives by default. |
list_web_id | TEXT | Dimensão | The ID used in the Mailchimp web application. View this list in your Mailchimp account at https://{dc}.admin.mailchimp.com/lists/members/?id={web_id}. |
member_count | NUMERIC | Métrica | The number of active members in the list. |
member_count_since_send | NUMERIC | Métrica | The number of active members in the list since the last campaign was sent. |
unsubscribe_count | NUMERIC | Métrica | The number of members who have unsubscribed from the list. |
unsubscribe_count_since_send | NUMERIC | Métrica | The number of members who have unsubscribed since the last campaign was sent. |
abuse_reports | NUMERIC | Métrica | The number of abuse reports generated for this campaign. |
bounce_rate | PERCENT | Métrica | The number of bounces divided by the total number of emails sent. |
bounces | NUMERIC | Métrica | The total number of bounced email addresses. |
campaign | TEXT | Dimensão | The title of the campaign. |
campaign_id | TEXT | Dimensão | A string that uniquely identifies this campaign. |
campaign_title | TEXT | Dimensão | The title of the campaign. |
campaign_type | TEXT | Dimensão | The type of campaign (regular, plain-text, ab_split, rss, automation, variate, or auto). |
click_rate | PERCENT | Métrica | The number of unique clicks divided by the total number of successful deliveries. |
clicks_total | NUMERIC | Métrica | The total number of clicks for the campaign. |
currency_code | TEXT | Dimensão | Currency code for the campaign's ecommerce revenue. |
delivered | NUMERIC | Métrica | The total number of successfully delivered emails. |
emails_sent | NUMERIC | Métrica | The total number of emails sent for this campaign. |
forwards_count | NUMERIC | Métrica | How many times the campaign has been forwarded. |
forwards_opens | NUMERIC | Métrica | How many times the forwarded campaign has been opened. |
hard_bounces | NUMERIC | Métrica | The total number of hard bounced email addresses. |
last_click | TIMESTAMP | Dimensão | The date and time of the last recorded click for the campaign. |
last_open | TIMESTAMP | Dimensão | The date and time of the last recorded open. |
list_is_active | TEXT | Dimensão | The status of the list used, namely if it's deleted or disabled. |
open_rate | PERCENT | Métrica | The number of unique opens divided by the total number of successful deliveries. |
open_rate_excluding_mpp | PERCENT | Métrica | The number of unique opens excluding Apple Mail Privacy Protection divided by the total number of successful deliveries. |
opens_total | NUMERIC | Métrica | The total number of opens for a campaign. |
opens_total_excluding_mpp | NUMERIC | Métrica | The total number of opens for a campaign, excluding opens generated by Apple Mail Privacy Protection. |
preview_text | TEXT | Dimensão | The preview text for the campaign. |
revenue | NUMERIC | Métrica | Total revenue from the campaign's tracked ecommerce orders. |
rss_last_send | TIMESTAMP | Dimensão | For RSS campaigns, the date and time of the last send. |
send_time | TIMESTAMP | Dimensão | The date and time a campaign was sent. |
soft_bounces | NUMERIC | Métrica | The total number of soft bounced email addresses. |
sub_rate | NUMERIC | Métrica | The average number of subscriptions per month for the list. |
sub_rate_non_aggregated | NUMERIC | Métrica | (Internal) The average number of subscriptions per month for the list. |
subject_line | TEXT | Dimensão | The subject line for the campaign. |
syntax_errors | NUMERIC | Métrica | The total number of addresses that were syntax-related bounces. |
total_orders | NUMERIC | Métrica | Total orders attributed to the campaign. |
unique_clicks | NUMERIC | Métrica | The total number of unique clicks for links across a campaign. |
unique_opens | NUMERIC | Métrica | The total number of unique opens. |
unique_opens_excluding_mpp | NUMERIC | Métrica | The total number of unique opens, excluding opens generated by Apple Mail Privacy Protection. |
unique_subscriber_clicks | NUMERIC | Métrica | The total number of subscribers who clicked on a campaign. |
unsub_rate | NUMERIC | Métrica | The average number of unsubscriptions per month for the list. |
unsub_rate_non_aggregated | NUMERIC | Métrica | (Internal) The average number of unsubscriptions per month for the list. |
unsubscribed | NUMERIC | Métrica | The total number of unsubscribed members for this campaign. |
data_fetched_at | TIMESTAMP | Dimensão | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. |
datasource | TEXT | Dimensão | The name of the Windsor connector returning the row |
date | DATE | Dimensão | The date a campaign was sent. |
day_of_month | TEXT | Dimensão | Day of the month |
month | TEXT | Dimensão | Number of the month |
now | TIMESTAMP | Dimensão | Current timestamp |
source | TEXT | Dimensão | The name of the Windsor connector returning the row |
today | DATE | Dimensão | Today's date |
week | TEXT | Dimensão | Week (Sun-Sat). |
week_day | TEXT | Dimensão | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
week_day_iso | TEXT | Dimensão | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
week_iso | TEXT | Dimensão | Week, ISO format (Mon-Sun). |
year | TEXT | Dimensão | Year |
year_month | TEXT | Dimensão | Year and month, e.g. 2024|3 |
year_month_name | TEXT | Dimensão | Year and month with the month name written out, e.g. "Jan 2025". |
year_of_week | TEXT | Dimensão | The year that contains first day of the week (Sun-Sat). |
year_of_week_iso | TEXT | Dimensão | The year that contains first day of the ISO week (Mon-Sun). |
year_week | TEXT | Dimensão | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
year_week_iso | TEXT | Dimensão | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |