A integração de dados do Facebook para o Data Warehouse criada pela Kondado possibilita que você tenha acesso aos seus dados de posts, campanhas e anúncios na sua nuvem analítica.
Adicionando o conector
Para automatizar o ETL do Facebook com a Kondado para o seu banco de dados, siga os passos abaixo:
1) Na plataforma da Kondado, vá para a página de adicionar conectores e selecione o conector do Facebook Ads
2) Dê um nome para o seu conector e, clique em “Continue with Facebook”:
ATENÇÃO: Além de bloqueadores de pop-up, alguns antivirus também podem impedir a exibição do botão “Continue with Facebook”. Então, caso você já esteja utilizando o navegador chrome e com uma janela anônima e o botão ainda não esteja aparecendo, desative o seu antivirus por alguns instantes e recarregue a página para que o botão apareça. Reative o seu antivirus após terminar o processo
3) Agora você será direcionado para uma página de login do Facebook, onde deverá informar as suas credenciais:
4) Após fazer login com a sua conta do Facebook vinculada a sua conta do Facebook Ads, você precisará dar permissão à Kondado clicando em “Continuar”:
5) Nesse passo você deve selecionar a conta que você deseja usar para integrar os dados e clique em “Avançar”
6) Na página de permissões, deixe todas as opções marcadas com “Sim” e clique em “Concluir”
Agora basta salvar o conector e começar a integrar os seus dados do Facebook Ads no Data Lake ou Data Warehouse.
Nas integrações listadas abaixo, você pode conferir melhor as permissões e níveis de acesso no facebook que a conta que adicionou o conector na Kondado deve ter
💡Veja aqui o guia das dúvidas mais comuns sobre as integrações do Facebook
Integrações
Índice
- Contas de anúncio
- Detalhes dos anúncios
- Estatísticas de anúncios
- Estatísticas de campanhas
- Estatísticas de grupos de anúncios
- Formulários de leads
- Métricas de Páginas
- Métricas de posts
- Prévia dos anúncios
- Páginas
- Páginas: lista de posts
Gráfico de relacionamento
Clique para ampliar
Estatísticas de anúncios
Objeto principal
| Campo | Tipo | |
|---|---|---|
|
text |
[en] The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing |
|
|
date |
[en] The date to which this row refers to (calculated by Kondado) |
|
|
text |
[en] The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing |
|
|
text |
[en] The unique ID of the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting |
|
|
text |
[en] The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads |
|
|
float |
[en] The average number of times each person saw your ad. This metric is estimated |
|
|
float |
[en] The estimated number of additional people that would remember seeing your ads within 2 days if asked – only available for assets with Brand Awareness objective |
|
|
float |
[en] The rate that an estimated number of additional people that would remember seeing your ads within 2 days if asked – only available for assets with Brand Awareness objective |
|
|
float |
[en] The estimated cost for each additional person that would remember seeing your ads within 2 days if asked – only available for assets with Brand Awareness objective |
|
|
float |
[en] The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window |
|
|
float |
[en] The number of people who performed an inline link click. This metric is estimated |
|
|
float |
[en] The number of times your ads were on screen |
|
|
text |
[en] The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads |
|
|
float |
[en] The number of people who performed a click (all). This metric is estimated |
|
|
text |
[en] The name of the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting |
|
|
text |
[en] The objective reflecting the goal you want to achieve with your advertising. It may be different from the selected objective of the campaign in some cases |
|
|
float |
[en] The number of clicks on your ads |
|
|
text |
[en] The unique ID of the ad you're viewing in reporting |
|
|
float |
[en] The number of people who saw your ads at least once. Reach is different from impressions, which may include multiple views of your ads by the same people. This metric is estimated |
|
|
text |
[en] The name of the ad you're viewing in reporting |
|
|
text |
[en] Currency that is used by your ad account |
|
|
float |
[en] The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window |
|
|
float |
[en] The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated |
|
|
float |
[en] The percentage of times people saw your ad and performed a click (all) |
|
|
float |
[en] The average cost to reach 1,000 people. This metric is estimated |
|
|
float |
[en] The average cost for 1,000 impressions |
|
|
float |
[en] The average cost for each click (all) |
|
|
text |
[en] What the ad set is optimizing for – APP_INSTALLS: Will optimize for people more likely to install your app; ENGAGED_USERS: Will optimize for people more likely to take a particular action in your app; EVENT_RESPONSES: Will optimize for people more likely to attend your event; IMPRESSIONS: Will show the ads as many times as possible; LEAD_GENERATION: Will optimize for people more likely to fill out a lead generation form; LINK_CLICKS: Will optimize for people more likely to click in the link of the ad; OFFER_CLAIMS: Will optimize for people more likely to claim the offer; OFFSITE_CONVERSIONS: Will optimize for people more likely to make a conversion in the site; PAGE_ENGAGEMENT: Will optimize for people more likely to engage with your page; PAGE_LIKES: Will optimize for people more likely to like your page; POST_ENGAGEMENT: Will optimize for people more likely to engage with your post; REACH: Optimize to reach the most unique users of each day or interval specified in frequency_control_specs; SOCIAL_IMPRESSIONS: Increase the number of impressions with social context. For example, with the names of one or more of the user's friends attached to the ad who have already liked the page or installed the app; VALUE: Will optimize for maximum total purchase value within the specified attribution window; THRUPLAY: Will optimize delivery of your ads to people are more likely to play your ad to completion, or play it for at least 15 seconds; AD_RECALL_LIFT: Optimize for people more likely to remember seeing your ads; VISIT_INSTAGRAM_PROFILE: Optimize for visits to the advertiser's instagram profile |
facebook_ad_insights__actions
| Campo | Tipo | |
|---|---|---|
|
date |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
text |
facebook_ad_insights_action_values
| Campo | Tipo | |
|---|---|---|
|
date |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
text |
Para utilizar esta integração da melhor forma, entenda mais sobre actions, detalhamento, período e janela de atualização
Por limitações da API do Facebook, esta integração traz um período máximo de 37 meses (1110 dias) no passado
Estatísticas de grupos de anúncios
Objeto principal
| Campo | Tipo | |
|---|---|---|
|
text |
[en] The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing |
|
|
date |
[en] The date to which this row refers to (calculated by Kondado) |
|
|
text |
[en] The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing |
|
|
text |
[en] The unique ID of the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting |
|
|
text |
[en] The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads |
|
|
float |
[en] The average number of times each person saw your ad. This metric is estimated |
|
|
float |
[en] The estimated number of additional people that would remember seeing your ads within 2 days if asked – only available for assets with Brand Awareness objective |
|
|
float |
[en] The rate that an estimated number of additional people that would remember seeing your ads within 2 days if asked – only available for assets with Brand Awareness objective |
|
|
float |
[en] The estimated cost for each additional person that would remember seeing your ads within 2 days if asked – only available for assets with Brand Awareness objective |
|
|
float |
[en] The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window |
|
|
float |
[en] The number of people who performed an inline link click. This metric is estimated |
|
|
float |
[en] The number of times your ads were on screen |
|
|
text |
[en] The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads |
|
|
float |
[en] The number of people who performed a click (all). This metric is estimated |
|
|
text |
[en] The name of the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting |
|
|
text |
[en] The objective reflecting the goal you want to achieve with your advertising. It may be different from the selected objective of the campaign in some cases |
|
|
float |
[en] The number of clicks on your ads |
|
|
float |
[en] The number of people who saw your ads at least once. Reach is different from impressions, which may include multiple views of your ads by the same people. This metric is estimated |
|
|
text |
[en] Currency that is used by your ad account |
|
|
float |
[en] The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window |
|
|
float |
[en] The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated |
|
|
float |
[en] The percentage of times people saw your ad and performed a click (all) |
|
|
float |
[en] The average cost to reach 1,000 people. This metric is estimated |
|
|
float |
[en] The average cost for 1,000 impressions |
|
|
float |
[en] The average cost for each click (all) |
|
|
text |
[en] What the ad set is optimizing for – APP_INSTALLS: Will optimize for people more likely to install your app; ENGAGED_USERS: Will optimize for people more likely to take a particular action in your app; EVENT_RESPONSES: Will optimize for people more likely to attend your event; IMPRESSIONS: Will show the ads as many times as possible; LEAD_GENERATION: Will optimize for people more likely to fill out a lead generation form; LINK_CLICKS: Will optimize for people more likely to click in the link of the ad; OFFER_CLAIMS: Will optimize for people more likely to claim the offer; OFFSITE_CONVERSIONS: Will optimize for people more likely to make a conversion in the site; PAGE_ENGAGEMENT: Will optimize for people more likely to engage with your page; PAGE_LIKES: Will optimize for people more likely to like your page; POST_ENGAGEMENT: Will optimize for people more likely to engage with your post; REACH: Optimize to reach the most unique users of each day or interval specified in frequency_control_specs; SOCIAL_IMPRESSIONS: Increase the number of impressions with social context. For example, with the names of one or more of the user's friends attached to the ad who have already liked the page or installed the app; VALUE: Will optimize for maximum total purchase value within the specified attribution window; THRUPLAY: Will optimize delivery of your ads to people are more likely to play your ad to completion, or play it for at least 15 seconds; AD_RECALL_LIFT: Optimize for people more likely to remember seeing your ads; VISIT_INSTAGRAM_PROFILE: Optimize for visits to the advertiser's instagram profile |
facebook_adset_insights__actions
| Campo | Tipo | |
|---|---|---|
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
date |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
text |
facebook_adset_insights_action_values
| Campo | Tipo | |
|---|---|---|
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
date |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
text |
Para utilizar esta integração da melhor forma, entenda mais sobre actions, detalhamento, período e janela de atualização
Por limitações da API do Facebook, esta integração traz um período máximo de 37 meses (1110 dias) no passado
Estatísticas de campanhas
Objeto principal
| Campo | Tipo | |
|---|---|---|
|
text |
[en] The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing |
|
|
date |
[en] The date to which this row refers to (calculated by Kondado) |
|
|
text |
[en] The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing |
|
|
text |
[en] The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads |
|
|
float |
[en] The average number of times each person saw your ad. This metric is estimated |
|
|
float |
[en] The estimated number of additional people that would remember seeing your ads within 2 days if asked – only available for assets with Brand Awareness objective |
|
|
float |
[en] The rate that an estimated number of additional people that would remember seeing your ads within 2 days if asked – only available for assets with Brand Awareness objective |
|
|
float |
[en] The estimated cost for each additional person that would remember seeing your ads within 2 days if asked – only available for assets with Brand Awareness objective |
|
|
float |
[en] The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window |
|
|
float |
[en] The number of people who performed an inline link click. This metric is estimated |
|
|
float |
[en] The number of times your ads were on screen |
|
|
text |
[en] The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads |
|
|
float |
[en] The number of people who performed a click (all). This metric is estimated |
|
|
text |
[en] The objective reflecting the goal you want to achieve with your advertising. It may be different from the selected objective of the campaign in some cases |
|
|
float |
[en] The number of clicks on your ads |
|
|
float |
[en] The number of people who saw your ads at least once. Reach is different from impressions, which may include multiple views of your ads by the same people. This metric is estimated |
|
|
text |
[en] Currency that is used by your ad account |
|
|
float |
[en] The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window |
|
|
float |
[en] The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated |
|
|
float |
[en] The percentage of times people saw your ad and performed a click (all) |
|
|
float |
[en] The average cost to reach 1,000 people. This metric is estimated |
|
|
float |
[en] The average cost for 1,000 impressions |
|
|
float |
[en] The average cost for each click (all) |
|
|
text |
[en] What the ad set is optimizing for – APP_INSTALLS: Will optimize for people more likely to install your app; ENGAGED_USERS: Will optimize for people more likely to take a particular action in your app; EVENT_RESPONSES: Will optimize for people more likely to attend your event; IMPRESSIONS: Will show the ads as many times as possible; LEAD_GENERATION: Will optimize for people more likely to fill out a lead generation form; LINK_CLICKS: Will optimize for people more likely to click in the link of the ad; OFFER_CLAIMS: Will optimize for people more likely to claim the offer; OFFSITE_CONVERSIONS: Will optimize for people more likely to make a conversion in the site; PAGE_ENGAGEMENT: Will optimize for people more likely to engage with your page; PAGE_LIKES: Will optimize for people more likely to like your page; POST_ENGAGEMENT: Will optimize for people more likely to engage with your post; REACH: Optimize to reach the most unique users of each day or interval specified in frequency_control_specs; SOCIAL_IMPRESSIONS: Increase the number of impressions with social context. For example, with the names of one or more of the user's friends attached to the ad who have already liked the page or installed the app; VALUE: Will optimize for maximum total purchase value within the specified attribution window; THRUPLAY: Will optimize delivery of your ads to people are more likely to play your ad to completion, or play it for at least 15 seconds; AD_RECALL_LIFT: Optimize for people more likely to remember seeing your ads; VISIT_INSTAGRAM_PROFILE: Optimize for visits to the advertiser's instagram profile |
facebook_campaign_insights__actions
| Campo | Tipo | |
|---|---|---|
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
date |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
text |
facebook_campaign_insights_action_values
| Campo | Tipo | |
|---|---|---|
|
text |
||
|
text |
||
|
text |
||
|
text |
||
|
date |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
float |
||
|
text |
Para utilizar esta integração da melhor forma, entenda mais sobre actions, detalhamento, período e janela de atualização
Por limitações da API do Facebook, esta integração traz um período máximo de 37 meses (1110 dias) no passado
Formulários de leads
Objeto principal
| Campo | Tipo | |
|---|---|---|
|
text |
[en] ID of the lead |
|
|
text |
[en] Ad ID for the Lead Ad |
|
|
text |
[en] Ad name for the Lead Ad |
|
|
text |
[en] Ad Set ID for the Lead Ad |
|
|
text |
[en] Ad Set name for the Lead Ad |
|
|
text |
[en] Campaign ID for the Lead Ad |
|
|
text |
[en] Campaign name for the Lead Ad |
|
|
timestamp |
[en] Time this object was created |
|
|
text |
[en] Form ID used for the Lead Ads |
|
|
boolean |
[en] Indicates whether the lead is organic |
|
|
text |
[en] The platform attributed to the Lead |
facebook_leads__field_data
| Campo | Tipo | |
|---|---|---|
|
text |
[en] ID of the lead (inhrerited from main object) |
|
|
text |
[en] Name of the field of the form data submitted by the user |
|
|
text |
[en] Value of the field of the form data submitted by the user |
Atenção: para que esta integração funcione corretamente, a conta utilizada para criar o conector na Kondado deve ser administrador de página e ter permissão para acessar os leads. Entenda mais clicando aqui e aqui
A permissão para administrar leads é concedida por padrão a todos os administradores de página, mas pode ter sido alterada deste padrão. Ao acessar business.facebook.com > Settings (parte inferior esquerda) > Business Settings > Integrations > Lead Access – caso você encontre uma página similar a imagem abaixo, então o acesso é concedido a todos os administradores de página (padrão):
Entretando caso a página seja similar a esta outra imagem abaixo, será necessário incluir o usuário do facebook que autenticou o conector da Kondado na lista utilizando o botão indicado na imagem 
Por limitações da API do Facebook, esta integração traz um período máximo de 37 meses (1110 dias) no passado
Detalhes dos anúncios
| Campo | Tipo | |
|---|---|---|
|
text |
[en] The ID of the ad |
|
|
text |
[en] The ID of the Ad Account |
|
|
text |
[en] ID of the ad set that contains the ad |
|
|
text |
[en] Name of the ad set that contains this ad |
|
|
text |
[en] ID of the ad campaign that contains this ad |
|
|
text |
[en] Name of the ad campaign that contains this ad |
|
|
timestamp |
[en] Time when the ad was created |
|
|
text |
[en] Name of the ad |
|
|
text |
[en] The source ad id that this ad is copied from (zero if not a copy) |
|
|
text |
[en] The configured status of the ad |
|
|
timestamp |
[en] Time when this ad was updated |
|
|
text |
[en] The actor ID (Page ID) of this creative |
|
|
text |
[en] The body of the ad. Not supported for video post creatives |
|
|
text |
[en] Type of call to action button in your ad. This determines the button text and header text for your ad |
|
|
text |
[en] Unique ID for an ad creative |
|
|
text |
[en] Name of this ad creative as seen in the ad account's library |
|
|
text |
[en] The type of Facebook object you want to advertise. Allowed values are: PAGE, DOMAIN, EVENT, STORE_ITEM (refers to an iTunes or Google Play store destination), SHARE (from a page), PHOTO, STATUS (of a page), VIDEO, APPLICATION (app on Facebook), INVALID (when an invalid object_id was specified such as a deleted object or if we do not have permission to see the object. In very few cases, this field may be empty if Facebook is unable to identify the type of advertised object), PRIVACY_CHECK_FAIL (we are missing the permission to load this object type), POST_DELETED (this object_type has been deleted) |
|
|
text |
[en] URL for a thumbnail image for this ad creative |
|
|
text |
[en] A URL for the image for this creative. We save the image at this URL to the ad account's image library |
|
|
text |
[en] Title for link ad, which does not belong to a page |
Entenda as permissões e níveis de acesso que a conta que foi adicionada na Kondado deve possuir no facebook para essa integração funcione corretamente
Prévia dos anúncios
| Campo | Tipo | |
|---|---|---|
|
text |
[en] The unique ID of the ad you're viewing in reporting |
|
|
text |
[en] Iframe HTML with ad preview |
Por limitações da API do Facebook, esta integração traz um período máximo de 37 meses (1110 dias) no passado
Contas de anúncio
| Campo | Tipo | |
|---|---|---|
|
text |
[en] The string act_{ad_account_id}. |
|
|
text |
[en] The ID of the Ad Account |
|
|
float |
[en] Status of the account: 1 = ACTIVE, 2 = DISABLED, 3 = UNSETTLED, 7 = PENDING_RISK_REVIEW, 8 = PENDING_SETTLEMENT, 9 = IN_GRACE_PERIOD, 100 = PENDING_CLOSURE, 101 = CLOSED, 201 = ANY_ACTIVE, 202 = ANY_CLOSED |
|
|
float |
[en] Amount of time the ad account has been open, in days. |
|
|
float |
[en] Current total amount spent by the account. This can be reset |
|
|
float |
[en] Bill amount due for this Ad Account. |
|
|
text |
[en] City for business address |
|
|
text |
[en] Country code for the business address |
|
|
text |
[en] The business name for the account |
|
|
text |
[en] State abbreviation for business address |
|
|
text |
[en] First line of the business street address for the account |
|
|
text |
[en] Second line of the business street address for the account |
|
|
text |
[en] Zip code for business address |
|
|
boolean |
[en] If we can create a new automated brand lift study under the Ad Account |
|
|
text |
[en] The time the account was created in ISO 8601 format |
|
|
text |
[en] The currency used for the account, based on the corresponding value in the account settings |
|
|
float |
[en] The reason why the account was disabled. Possible reasons are: 0 = NONE, 1 = ADS_INTEGRITY_POLICY, 2 = ADS_IP_REVIEW, 3 = RISK_PAYMENT, 4 = GRAY_ACCOUNT_SHUT_DOWN, 5 = ADS_AFC_REVIEW, 6 = BUSINESS_INTEGRITY_RAR, 7 = PERMANENT_CLOSE, 8 = UNUSED_RESELLER_ACCOUNT, 9 = UNUSED_ACCOUNT, 10 = UMBRELLA_AD_ACCOUNT, 11 = BUSINESS_MANAGER_INTEGRITY_POLICY, 12 = MISREPRESENTED_AD_ACCOUNT, 13 = AOAB_DESHARE_LEGAL_ENTITY, 14 = CTX_THREAD_REVIEW, 15 = COMPROMISED_AD_ACCOUNT |
|
|
text |
[en] The entity the ads will target. Must be a Facebook Page Alias, Facebook Page ID or an Facebook App ID |
|
|
text |
[en] The name of the entity the ads will target |
|
|
float |
[en] The minimum daily budget for this Ad Account |
|
|
text |
[en] Name of the account. If not set, the name of the first admin visible to the user will be returned |
|
|
float |
[en] The maximum amount that can be spent by this Ad Account. When the amount is reached, related Ad Campaigns are paused. A value of 0 means no spending-cap. Setting a new spend cap only applies to spend AFTER the time at which you set it. Value specified in basic unit of the currency, for example 'cents' for USD |
|
|
text |
[en] Tax ID |
|
|
text |
[en] Name for the time zone |
Páginas
Esta integração está em modo beta. Nos avise se encontrar algum resultado inesperado
Objeto principal
| Campo | Tipo | |
|---|---|---|
|
text |
[en] The ID representing a Facebook Page |
|
|
text |
[en] The Page's category. e.g. Product/Service, Computers/Technology |
|
|
text |
[en] tasks on the page, such as ADVERTISE |
|
|
text |
[en] The name of the Page |
|
|
text |
[en] Information about the Page. This value maps to the Description setting in the Edit Page Info user interface |
|
|
text |
[en] Affiliation of this person. Applicable to Pages representing people |
|
|
text |
[en] Artists the band likes. Applicable to Bands |
|
|
text |
[en] Dress code of the business. Applicable to Restaurants or Nightlife. Can be one of Casual, Dressy or Unspecified |
|
|
text |
[en] The awards information of the film. Applicable to Films |
|
|
text |
[en] Band interests. Applicable to Bands |
|
|
text |
[en] Members of the band. Applicable to Bands |
|
|
text |
[en] Biography of the band. Applicable to Bands |
|
|
date |
[en] Birthday of this person. Applicable to Pages representing people |
|
|
text |
[en] Booking agent of the band. Applicable to Bands |
|
|
text |
[en] Year vehicle was built. Applicable to Vehicles |
|
|
boolean |
[en] Whether the Page has checkin functionality enabled |
|
|
float |
[en] Number of checkins at a place represented by a Page |
|
|
float |
[en] If this is a Page in a Global Pages hierarchy, the number of people who are being directed to this Page |
|
|
text |
[en] Culinary team of the business. Applicable to Restaurants or Nightlife |
|
|
text |
[en] Current location of the Page |
|
|
text |
[en] The description of the Page. Note that this value is mapped to the Additional Information setting in the Edit Page Info user interface |
|
|
text |
[en] The director of the film. Applicable to Films |
|
|
text |
[en] Subtext about the Page being viewed |
|
|
text |
[en] Page estimated message response time displayed to user |
|
|
text |
[en] The emails listed in the About section of a Page |
|
|
float |
[en] The number of users who like the Page. For Global Pages this is the count for all Pages across the brand. For New Page Experience Pages, this field will return followers_count |
|
|
text |
[en] Features of the vehicle. Applicable to Vehicles |
|
|
float |
[en] Number of page followers |
|
|
text |
[en] The restaurant's food styles. Applicable to Restaurants |
|
|
int |
[en] When the company was founded. Applicable to Pages in the Company category |
|
|
text |
[en] General information provided by the Page |
|
|
text |
[en] General manager of the business. Applicable to Restaurants or Nightlife |
|
|
text |
[en] The genre of the film. Applicable to Films |
|
|
text |
[en] The name of the Page with country codes appended for Global Pages |
|
|
text |
[en] This brand's global Root ID |
|
|
boolean |
[en] indicates whether a page has transitioned to new page experience or not |
|
|
boolean |
[en] Indicates whether WhatsApp number connected to this page is a WhatsApp business number |
|
|
boolean |
[en] Indicates whether WhatsApp number connected to this page is a WhatsApp number |
|
|
text |
[en] Hometown of the band. Applicable to Bands |
|
|
text |
[en] Time the business opens on Monday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Monday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Monday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Monday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Tuesday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Tuesday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Tuesday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Tuesday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Wednesday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Wednesday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Wednesday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Wednesday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Thursday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Thursday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Thursday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Thursday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Friday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Friday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Friday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Friday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Saturday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Saturday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Saturday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Saturday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Sunday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Sunday (first range). If always open, see is_always_open |
|
|
text |
[en] Time the business opens on Sunday (second range). If always open, see is_always_open |
|
|
text |
[en] Time the business closes on Sunday (second range). If always open, see is_always_open |
|
|
text |
[en] Legal information about the Page publishers |
|
|
text |
[en] Influences on the band. Applicable to Bands |
|
|
boolean |
[en] Indicates whether this location is always open |
|
|
boolean |
[en] Indicates whether location is part of a chain |
|
|
boolean |
[en] Indicates whether the Page is a community Page |
|
|
boolean |
[en] Indicates whether the page is eligible for the branded content tool |
|
|
boolean |
[en] Indicates whether the page is a Messenger Platform Bot with Get Started button enabled |
|
|
boolean |
[en] Indicates whether the page is a Messenger Platform Bot |
|
|
boolean |
[en] Indicates whether Page is owned |
|
|
boolean |
[en] Whether the business corresponding to this Page is permanently closed |
|
|
boolean |
[en] Indicates whether the Page is published and visible to non-admins |
|
|
boolean |
[en] Indicates whether the Page is unclaimed |
|
|
text |
[en] The Page's Facebook URL |
|
|
text |
[en] Members of this org. Applicable to Pages representing Team Orgs |
|
|
text |
[en] The default ice breakers for a certain page |
|
|
text |
[en] The default quick replies for a certain page |
|
|
text |
[en] Indicates what type this page is and we will generate different sets of quick replies based on it. Values include UNKNOWN, PAGE_SHOP, or RETAIL |
|
|
text |
[en] The company mission. Applicable to Companies |
|
|
text |
[en] MPG of the vehicle. Applicable to Vehicles |
|
|
text |
[en] The TV network for the TV show. Applicable to TV Shows |
|
|
float |
[en] Overall page rating based on rating survey from users on a scale of 1-5. This value is normalized and is not guaranteed to be a strict average of user ratings. If there are 0 or a small number of ratings, this field will not be returned |
|
|
text |
[en] Personal information. Applicable to Pages representing People |
|
|
text |
[en] Personal interests. Applicable to Pages representing People |
|
|
text |
[en] Pharmacy safety information. Applicable to Pharmaceutical companies |
|
|
text |
[en] Pharmacy safety information. Applicable to Pharmaceutical companies |
|
|
text |
[en] List of pickup options available at this Page's store location. Values can include CURBSIDE, IN_STORE, and OTHER |
|
|
text |
[en] For places, the category of the place. Value can be CITY, COUNTRY, EVENT, GEO_ENTITY, PLACE, RESIDENCE, STATE_PROVINCE, or TEXT |
|
|
text |
[en] The plot outline of the film. Applicable to Films |
|
|
text |
[en] Press contact information of the band. Applicable to Bands |
|
|
text |
[en] Price range of the business, such as a restaurant or salon. Values can be one of $, $$, $$$, $$$$, Not Applicable, or null if no value is set |
|
|
text |
[en] Privacy url in page info section |
|
|
text |
[en] The productor of the film. Applicable to Films |
|
|
text |
[en] The products of this company. Applicable to Companies |
|
|
text |
[en] Public transit to the business. Applicable to Restaurants or Nightlife |
|
|
int |
[en] Number of ratings for the Page (limited to ratings that are publicly accessible) |
|
|
text |
[en] Record label of the band. Applicable to Bands |
|
|
text |
[en] The film's release date. Applicable to Films |
|
|
text |
[en] The air schedule of the TV show. Applicable to TV Shows |
|
|
text |
[en] The screenwriter of the film. Applicable to Films |
|
|
text |
[en] The season information of the TV Show. Applicable to TV Shows |
|
|
text |
[en] The Page address, if any, in a simple single line format |
|
|
text |
[en] The cast of the film. Applicable to Films |
|
|
text |
[en] Unique store code for this location Page |
|
|
text |
[en] Location Page's store location descriptor |
|
|
text |
[en] Unique store number for this location Page |
|
|
text |
[en] The studio for the film production. Applicable to Films |
|
|
boolean |
[en] Whether the user can add a Donate Button to their Live Videos |
|
|
int |
[en] The number of people talking about this Page |
|
|
text |
[en] Indicates how the business corresponding to this Page is operating differently than usual. Possible values: differently_open, temporarily_closed, operating_as_usual, no_data |
|
|
int |
[en] Unread message count for the Page. Only visible to a page admin |
|
|
int |
[en] Number of unread notifications. Only visible to a page admin |
|
|
int |
[en] Unseen message count for the Page. Only visible to a page admin |
|
|
text |
[en] The alias of the Page. For example, for www.facebook.com/platform the username is 'platform' |
|
|
text |
[en] Showing whether this Page is verified. Value can be blue_verified or gray_verified, which represents that Facebook has confirmed that a Page is the authentic presence of the public figure, celebrity, or global brand it represents, or not_verified |
|
|
text |
[en] The URL of the Page's website |
|
|
int |
[en] The number of visits to this Page's location. If the Page setting Show map, check-ins and star ratings on the Page (under Page Settings > Page Info > Address) is disabled, then this value will also be disabled |
|
|
text |
[en] The Page's WhatsApp number |
|
|
text |
[en] The writer of the TV show. Applicable to TV Shows |
facebook_pages__category_list
Páginas: lista de posts
Esta integração está em modo beta. Nos avise se encontrar algum resultado inesperado
| Campo | Tipo | |
|---|---|---|
|
timestamp |
[en] The time the post was initially published. For a post about a life event, this is the date and time of the life event |
|
|
text |
[en] The status message in the post |
|
|
text |
[en] The name of the Page, group, or event that created the post |
|
|
text |
[en] The id of the Page, group, or event that created the post |
|
|
text |
[en] The ID of the post |
|
|
text |
[en] The id of the Page we used to read the post |
|
|
timestamp |
[en] The time the post was last updated, which occurs when the post was created, edited, or a User comments on a post, expressed as a UNIX timestamp |
Métricas de páginas
Esta integração está em modo beta. Nos avise se encontrar algum resultado inesperado
Veja mais detalhes sobre esta integração e sua configuração clicando aqui
Métricas de posts
Todas as métricas de post são lidas considerando-se todo o período de existência do post. Dessa forma, o número de impressões, por exemplo, irá indicar quantas impressões o post teve em sua existência inteira. Para que seja fácil armazenar o histórico das métricas, nós adicionamos a coluna metric_date, que irá indicar a data que aquela métrica para aquele post foi obtida. Além disso, algumas métricas (como por exemplo, visualizações por país) populam mais de uma linha, desta forma, nós criamos uma tabela secundária (“details”) que irá conter estas métricas multi-linhas. As métricas simples (que retornam apenas uma linha) irão estar contidas na tabela do objeto principal. Uma listagem e descrição das métricas multi-linha que são retornadas pode ser encontrada ao final desta seção
Para evitar que seja feita uma leitura completa de todos os posts a cada execução – e também considerando que posts muito antigos não sofrem mais modificação em suas métricas, já que eles podem nem ser mais exibidos – a integração também permite que você configure uma janela de atualização que indica quantos dias após a criação do post as suas métricas devem continuar sendo atualizadas.
Objeto principal
| Campo | Tipo | |
|---|---|---|
|
date |
[en] The UTC date when this record was read from the API |
|
|
text |
[en] The id of the post |
|
|
text |
[en] The id of the page |
|
|
float |
[en] The number of times people clicked on anywhere in your posts without generating a story |
|
|
float |
[en] The number of times your Page's post entered a person's screen. Posts include statuses, photos, links, videos and more |
|
|
float |
[en] The number of people who had your Page's post enter their screen. Posts include statuses, photos, links, videos and more |
|
|
float |
[en] The number of times your Page's post entered a person's screen through paid distribution such as an ad |
|
|
float |
[en] The number of people who had your Page's post enter their screen through paid distribution such as an ad |
|
|
float |
[en] The number of impressions for your Page post by people who have liked your Page |
|
|
float |
[en] The number of people who have like your Page who saw your Page post |
|
|
float |
[en] The number of times your Page's posts entered a person's screen through unpaid distribution |
|
|
float |
[en] The number of people who had your Page's post enter their screen through unpaid distribution |
|
|
float |
[en] The number of times your Page's post entered a person's screen with social information attached. Social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page |
|
|
float |
[en] The number of people who had your Page's post enter their screen with social information attached. As a form of organic distribution, social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page |
|
|
float |
[en] The number of times your Page's post entered a person's screen. This does not include content created about your Page with social information attached. Social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page |
|
|
float |
[en] The number of people who had your Page's post enter their screen. This does not include content created about your Page with social information attached. As a form of organic distribution, social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page |
|
|
float |
[en] The number of times your videos automatically played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos |
|
|
float |
[en] The number of times your videos played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds, after people clicked play. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos |
|
|
float |
[en] The number of times your videos played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos |
|
|
float |
[en] The number of times your promoted videos played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. Returns 0 for reshared videos |
|
|
float |
[en] The number of people who viewed your videos for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video |
|
|
float |
[en] The average time, in milliseconds, people viewed your videos. Only available for videos created after August 25th 2016. Returns 0 for reshared videos |
|
|
float |
[en] The number of times your videos played from the beginning to 95%, or more, of its length, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos |
|
|
float |
[en] The number of people who viewed your videos from the beginning to 95%, or more, of its length, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos |
|
|
float |
[en] The number of times your promoted videos played from the beginning to 95%, or more, of its length. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. Returns 0 for reshared videos |
|
|
float |
[en] The number of people who viewed your promoted videos from the beginning to 95%, or more, of its length. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video |
|
|
float |
[en] The number of times your videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video |
|
|
float |
[en] The number of people who viewed your videos for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video |
|
|
float |
[en] The number of times your promoted videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video |
|
|
float |
[en] The number of people who viewed your promoted videos for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video |
|
|
float |
[en] The length, in milliseconds, of a video post |
|
|
float |
[en] The number of times your videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. This includes live views |
|
|
float |
[en] The number of people who viewed your videos for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video |
|
|
float |
[en] The number of times your videos automatically played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video |
|
|
float |
[en] The number of times your videos played for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds, after people clicked play. During a single instance of a video playing, we'll exclude any time spent replaying the video |
|
|
float |
[en] The number of times your videos played for at least 15 seconds, or for nearly their total length if they're shorter than 15 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video |
|
|
float |
[en] The number of times your videos played for at least 60 seconds. This metric is counted only for videos that are 60 seconds or longer. During a single instance of a video playing, we'll exclude any time spent replaying the video |
|
|
float |
[en] The number of times your videos played with sound on for at least 3 seconds, or for nearly their total length if they're shorter than 3 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video |
|
|
float |
[en] The total time, in milliseconds, your videos played, including videos played for less than 3 seconds and replays. Returns 0 for reshared videos |
|
|
float |
[en] The total time, in milliseconds, your videos played by organic reach. Returns 0 for reshared videos |
|
|
float |
[en] The number of stories generated about your Page post ('Stories') |
|
|
float |
[en] The total number of times an ad was shown during ad breaks in your videos |
|
|
float |
[en] An estimate of the amount you earned from ad breaks in your videos, based on the number of impressions and CPM of ads shown. Actual payments may differ if there are content ownership claims or other adjustments |
|
|
float |
[en] The average amount paid by advertisers for 1,000 impressions of their ads in your videos. This number also includes the amount paid to Facebook |
facebook_pages_metrics_details
| Campo | Tipo | |
|---|---|---|
|
date |
[en] The UTC date when this record was read from the API |
|
|
text |
[en] The id of the post |
|
|
text |
[en] The id of the page |
|
|
text |
[en] The name of the metric |
|
|
text |
[en] The detail of the metric |
|
|
float |
[en] The value of the detail of the metric |
Métricas multi-linha retornadas em “details”
post_clicks_by_type: The number of times people clicked on anywhere in your posts without generating a story, by consumption type
post_reactions_by_type_total: Total post reactions by type
post_video_retention_graph: The number of times your videos played at each interval as a percentage of all views. Videos are divided into 40 equal intervals. This metric does not count impressions while the video was live. Retention graphs may show more impressions later in the video than at the beginning. People might start the video in the middle, skip ahead, save, and rewatch it from that point, or other similar behaviors
post_video_retention_graph_clicked_to_play: The number of times your videos played at each interval as a percentage of all views, after people clicked play. Videos are divided into 40 equal intervals. This metric does not count impressions while the video was live. Retention graphs may show more impressions later in the video than at the beginning. People might start the video in the middle, skip ahead, save, and rewatch it from that point, or other similar behaviors
post_video_retention_graph_autoplayed: The number of times your videos automatically played at each interval as a percentage of all automatic views. Videos are divided into 40 equal intervals.This metric does not count impressions while the video was live. Retention graphs may show more impressions later in the video than at the beginning. People might start the video in the middle, skip ahead, save, and rewatch it from that point, or other similar behaviors
post_video_view_time_by_age_bucket_and_gender: The total time, in milliseconds, your videos played for your Top Audiences, age and gender
post_video_view_time_by_region_id: The total time, in milliseconds, your videos played for your Top 45 Locations, Region – Country
post_video_views_by_distribution_type: The number of times your videos played by distribution type; page_owned and shared
post_video_view_time_by_distribution_type: The total time, in milliseconds, your videos played by distribution type; page_owned and shared
post_video_view_time_by_country_id: The total number of minutes your videos played for your Top 45 Locations; Country
post_activity_by_action_type: The number of stories created about your Page post, by action type
post_activity_by_action_type_unique: The number of people who created a story about your Page post, by action type
Comentários de posts
Essa integração foi temporariamente desabilitada
Notas
Actions e Action Values
“Actions” são elementos extras às integrações de estatísticas de anúncios que trazem informações adicionais sobre a performance das ações realizadas nos anúncios, como conversões realizadas fora do site e dados sobre compras. As actions serão separadas em 2 tabelas: actions e action_values. A tabela de actions irá representar os dados em formato de contagem (por exemplo, número de compras realizadas no site) enquanto a tabelas de action_values representará os dados de valor (por exemplo, valor das compras realizadas no site).
ATENÇÃO: Não confunda a coluna actions_value da tabela actions com a tabela action_values
As tabelas actions e action_values possuem as mesmas dimensões que a tabela de estatísticas principal (por exemplo, se é uma integração de estatísticas de campanha mensal por região, essa será a granularidade dos registros de actions), além de campos que identificam a ação (colunas actions_action_type e action_values_action_type, respectivamente) e a quantificam (colunas actions_value e action_values_value, respectivamente). Também podem ser encontradas nas tabelas de actions e action_values os seus valores utilizando as várias configurações de atribuição (colunas com final 1d_view, 7d_view, 28d_view, 1d_click, 7d_click, 28d_click), que podem ser utilizadas para consulta no lugar das colunas actions_value e action_values_value (respectivamente) caso você utilize uma configuração de atribuição diferente na sua conta do facebook.
Para saber com certeza se você deve utilizar as colunas actions_value e action_values_value ou alguma das outras colunas de atribuição para que o resultado obtido seja o mesmo que o apresentado no relatório da ferramenta, você pode adicionar ao relatório obtido via facebook a columna de attribution setting. Lembrando que, caso algum indicativo de que a configuração deve ser combinada como “Clique de 7 dias ou Visualização de 1 dia” você deverá somar as respectivas colunas na Kondado para obter o mesmo valor da ferramenta. A nossa recomendação é sempre utilizar actions_value e action_values_value, siga a recomendação acima apenas se quiser que os valores fiquem os mesmos que o relatório padrão da ferramenta
As actions_action_type e action_values_action_type que temos mapeadas são:
- add_to_cart: Adds to Cart
- app_custom_event.fb_mobile_achievement_unlocked: Mobile App Feature Unlocks
- app_custom_event.fb_mobile_activate_app: Mobile App Starts
- app_custom_event.fb_mobile_add_payment_info: Mobile App Payment Details
- app_custom_event.fb_mobile_add_to_cart: Mobile App Adds To Cart
- app_custom_event.fb_mobile_add_to_wishlist: Mobile App Adds to Wishlist
- app_custom_event.fb_mobile_complete_registration: Mobile App Registrations
- app_custom_event.fb_mobile_content_view: Mobile App Content Views
- app_custom_event.fb_mobile_initiated_checkout: Mobile App Checkouts
- app_custom_event.fb_mobile_level_achieved: Mobile App Achievements
- app_custom_event.fb_mobile_purchase: Mobile App Purchases
- app_custom_event.fb_mobile_rate: Mobile App Ratings
- app_custom_event.fb_mobile_search: Mobile App Searchs
- app_custom_event.fb_mobile_spent_credits: Mobile App Credit Spends
- app_custom_event.fb_mobile_tutorial_completion: Mobile App Tutorial Completions
- app_custom_event.other: Other Mobile App Actions
- app_install: App Installs
- app_use: App Uses
- checkin: Check-ins
- comment: Post Comments
- credit_spent: Credit Spends
- games.plays: Game Plays
- initiate_checkout: Initiates Checkout
- interactive_component_tap: Interactive Component Tap
- landing_page_view: Landing Page Views
- lead: All offsite leads plus all On-Facebook leads
- like: Page Likes
- link_click: Link Clicks
- mobile_app_install: Mobile App Installs
- offsite_conversion.custom.: Custom Conversions defined by the advertiser
- offsite_conversion.fb_pixel_add_payment_info: Adds Payment Info
- offsite_conversion.fb_pixel_add_to_cart: Adds To Cart
- offsite_conversion.fb_pixel_add_to_wishlist: Adds To Wishlist
- offsite_conversion.fb_pixel_complete_registration: Completed Registration
- offsite_conversion.fb_pixel_custom: Custom pixel events defined by the advertiser
- offsite_conversion.fb_pixel_initiate_checkout: Initiates Checkout
- offsite_conversion.fb_pixel_lead: Leads
- offsite_conversion.fb_pixel_purchase: Purchases
- offsite_conversion.fb_pixel_search: Searchs
- offsite_conversion.fb_pixel_view_content: Views Content
- omni_add_to_cart: Adds to Cart
- omni_initiated_checkout: Checkouts Initiated
- omni_purchase: Purchases
- omni_view_content: Content Views
- onsite_conversion.flow_complete: On-Facebook Workflow Completions
- onsite_conversion.messaging_block: Blocked Messaging Conversations
- onsite_conversion.messaging_conversation_started_7d: Messaging Conversations Started
- onsite_conversion.messaging_first_reply: New Messaging Conversations
- onsite_conversion.post_save: Post Saves
- onsite_conversion.purchase: On-Facebook Purchases
- outbound_click: Outbound Clicks
- page_engagement: Page Engagement
- photo_view: Page Photo Views
- post: Post Shares
- post_engagement: Post Engagement
- post_reaction: Post Reactions
- purchase: Purchases
- purchase_roas__omni_purchase: The total return on ad spend (ROAS) from purchases. This is based on information received from one or more of your connected Facebook Business Tools and attributed to your ads
- rsvp: Event Responses
- video_p100_watched_actions__video_view: The number of times your video was played at 100% of its length, including plays that skipped to this point
- video_p25_watched_actions__video_view: The number of times your video was played at 25% of its length, including plays that skipped to this point
- video_p50_watched_actions__video_view: The number of times your video was played at 50% of its length, including plays that skipped to this point
- video_p75_watched_actions__video_view: The number of times your video was played at 75% of its length, including plays that skipped to this point
- video_p95_watched_actions__video_view: The number of times your video was played at 95% of its length, including plays that skipped to this point
- video_view: 3-Second Video Views
- view_content: Content Views
- website_purchase_roas__offsite_conversion.fb_pixel_purchase: The total return on ad spend (ROAS) from website purchases. This is based on the value of all conversions recorded by the Facebook pixel on your website and attributed to your ads
Detalhamento
A utilização de detalhamentos pode fazer com que algumas actions (por exemplo, actions do tipo offsite, purchases e video_pXX_watched) deixem de ser retornadas devido à configurações de privacidade que impedem a agregação destas actions entre usuários com regras de privacidade mais restritivas (por exemplo, dispositivos IOS). Caso sua action deixe de ser retornada, você pode verificar o comportamento em uma integração sem detalhamentos
Caso opte por incluir um detalhamento na sua integração, o tipo de detalhamento irá inserir dimensões (colunas) adicionais em integrações de estatísticas e refinar melhor como os dados são retornados. São eles:
Impression device + Device platform + Publisher platform + Platform position (Dispositivo + Plataforma do Dispositivo + Plataforma de publicação + Posição na plataforma)
- publisher_platform (text): Which platform your ad was shown, for example on Facebook, Instagram, or Audience Network
- impression_device (text): The device where your last ad was served to someone on Facebook. For example “iPhone” if someone viewed your ad on an iPhone
- device_platform (text): The type of device, mobile or desktop, used by people when they viewed or clicked on an ad, as shown in ads reporting
- platform_position (text): Where your ad was shown within a platform, for example on Facebook desktop News Feed, or Instagram Mobile News Feed
Region + Country (Região + País)
- region (text): The regions where the people you’ve reached are located. This is based on information such as a person’s hometown, their current city and the geographical location where they tend to be when they visit Facebook
- country (text): The countries where the people you’ve reached are located. This is based on information such as a person’s hometown, their current city and the geographical location where they tend to be when they visit Facebook
Age + Gender (Idade + Gênero)
- age (text): The age range of the people you’ve reached
- gender (text): Gender of people you’ve reached. People who don’t list their gender are shown as ‘not specified’
Hourly by advertiser time zone (Horário do anunciante)
Hourly breakdown aggregated by the time ads were delivered in the advertiser’s time zone. For example, if your ads are scheduled to run from 9 AM to 11 AM, but they reach audiences in multiple time zones, they may deliver from 9 AM to 1 PM in the advertiser’s time zone. Stats will be aggregated into four groups 9 AM – 10 AM, 10 AM – 11 AM, 11 AM – 12 PM, and 12 PM – 1 PM.
Hourly by audience time zone (Horário da audiência)
Hourly breakdown aggregated by the time ads were delivered in the audiences’ time zone. For example, if your ads are scheduled to run from 9 AM to 11 AM but they reach audiences in multiple time zones, they may deliver from 9 AM to 1 PM in the advertiser’s time zone. Stats will be aggregated into two groups 9 AM – 10 AM and 10 AM – 11 AM.
Após algumas alterações de privacidade dos fabricantes de sistemas operacionais (eg: iOS) o Facebook passou a não conseguir mais reportar precisamente actions que acontecem fora das suas plataformas, como aquelas disparadas por pixels. Desta forma, quando é utilizado algum detalhamento, as actions disparadas por pixels irão retornar nulas ou mesmo trazer o valor “unknown” para as colunas de detalhamento. Assim, caso você queira ter a informação de actions realizadas fora das plataformas (ou seja, aquelas que não sejam “impressions”, “like”, “click” e que sejam disparadas por pixels como “purchase” e “conversion”) recomendamos que você não utilize nenhum detalhamento. Veja mais informações na documentação do facebook
Período
O período define a granularidade da coluna metric_date. Ele é útil para melhor mensuração de algumas métricas do tipo “count distinct” que podem ser diferentes em uma somatória mensal (com granularidade mensal) versus somatória dos dias do mês (com granularidade diária), por exemplo unique_clicks – se um mesmo usuário clicou no seu anúncio todos os dias de um mês, ele será contado como um clique por dia em uma granularidade diária, mas se for somado, ele será considerado 30 cliques para um mês. O correto, neste caso, seria considerar apenas 1 clique do usuário no mês, utilizando o período mensal na integração.
Para o período “lifetime” cada execução irá trazer date_start 1110 dias (37 meses) anteriores à leitura
Janela de atribuição/janela de atualização
Este parâmetro indica quandos dias anteriores ao savepoint os dados continuarão sendo atualizados. Isso quer dizer que, com uma integração que tenha janela de 7 dias, a cada execução, serão lidos 7 dias de resultados. Essa janela é útil caso, em algumas situações, os dados do “passado” ainda podem ser alterados. Como é o caso de uma conversão externa por um usuário que foi impactado por um anúncio mas só converteu de fato 3 dias depois – ele é atribuído como uma conversão de 3 dias atrás, alterado o passado. Você deve deixar este parâmetro de acordo com o valor da sua janela de atribuição do facebook e ajustar a frequência de acordo para evitar um consumo excessivo de registros do seu plano.
Permissões e níveis de acesso para Ads
A conta que autoriza o conector do facebook na Kondado deve possuir:
- Ao menos acesso de funcionário com a opção de visualizar performance habilitada para a conta de anúncio a permissão de analista de conta de anúncio também é válida
- Se o perfil for de agência, é necessário permissão de Page Admin
- Se a página for do tipo “Nova experiência”, é necessário “Acesso Parcial” à página
- Entenda como adicionar e gerenciar usuários aqui
- Recomendamos também que sejam dadas as permissões à página descritas aqui
Permissões e níveis de acesso para páginas
- É necessário acesso de Administrador à página
- Se estiver sendo usado o Business Manager, é necessário acesso mínimo de Page editor
- Se a página for do tipo “Nova experiência”, é necessário um “Acesso Parcial” à página
- Se o perfil for de agência, é necessário permissão de Page Admin
- Entenda como adicionar usuários utilizando o Business Manager
- Entenda como gerenciar acesso à sua página