Documentación de tablas de Facebook Insights en BigQuery
Al importar datos de Facebook Insights a BigQuery mediante Dataslayer, puede aparecer un error de "invalid parameters combination" si seleccionas determinadas dimensiones y métricas que no pueden utilizarse juntas.
El error "invalid parameters combination " proviene de la API nativa de la fuente de datos, no de Dataslayer.
Para evitar este error, puedes importar las siguientes tablas:
Interacción avanzada
Esta tabla contiene el engagement avanzado de tus posts y páginas en Facebook.
Ejemplo:
| Interacción avanzada |
| Métricas |
| Post Engagements |
| Total Post Reactions |
| Post Shares |
| Post Comments |
| Total Video Views |
| Total Impressions |
| Total Reach |
| Engaged users |
| Dimensiones |
| Date |
| Post Type |
| Post Creation Time |
| Post ID |
| Post Name |
| Post Description |
| Post Status Type |
| Post thumbnail URL |
| Post Image URL |
| Post Image |
| Post Message |
| Page Name |
| Page ID |
Insights de tu público
Esta tabla contiene información para obtener insights sobre tu audiencia.
Ejemplo:
| Insights de tu público |
| Métricas |
| Total Likes |
| Page Post Engagements |
| Total impressions |
| Total Reach |
| Total Page Views |
| Page Followers |
| Page comments |
| Page shares |
| Clicks |
| Organic reach |
| Organic impressions |
| Paid impressions |
| Paid reach |
| Unlikes |
| Engaged users |
| Viral impressions |
| Viral reach |
| Viral impressions of posts |
| Viral reach of posts |
| Non-viral impressions |
| Non-viral reach |
| Non-viral reach of posts |
| Non-viral impressions of posts |
| Total impressions of posts |
| Paid impressions of posts |
| Total reach of posts |
| Paid reach of posts |
| Organic impressions of posts |
| Organic reach of posts |
| Negative actions |
| Positive actions |
| Check-ins |
| Check-ins using mobile |
| People checking in |
| People checking in using mobile |
| People visiting your page |
| Dimensiones |
| Date |
| Page Name |
| Page ID |
Interacción con las publicaciones
Esta tabla contiene información completa sobre el engagement de tus publicaciones en Facebook.
Ejemplo:
| Interacción con las publicaciones |
|---|
| Métricas |
| Metrics |
| Post shares |
| Post link clicks |
| Post unique link clicks |
| Post other clicks |
| Post unique other clicks |
| Post reactions: angry |
| Post reactions: haha |
| Post reactions: like |
| Post reactions: love |
| Post reactions: sad |
| Post reactions: wow |
| Total post reactions |
| Dimensiones |
| Date |
| Post creation time |
| Post description |
| Post image URL |
| Post ID |
| Post shared link |
| Link to post |
| Post message |
| Post name |
| Post object ID |
| Post thumbnail URL |
| Post privacy |
| Post status type |
| Post story |
| Post type |
| Page name |
| Page ID |
Comentarios de posts
Esta tabla contiene información sobre los comentarios de tus publicaciones en Facebook.
Ejemplo:
| Comentarios de posts |
| Métricas |
| Post Comments |
| Dimensiones |
| Date |
| Post comment author |
| Post comment date |
| Post comment text |
| Post comment time |
| Post ID |
| Post name |
| Page ID |
| Page name |
Interacción con los videos
Esta tabla contiene información completa sobre el engagement de tus videos en Facebook.
Ejemplo:
| Interacción con los videos |
|---|
| Métricas |
| Total video view time (s) |
| Total video views |
| Unique video views |
| Paid video views |
| Auto-played video views |
| Clicked to play video views |
| Total 10s video views |
| Unique 10s video views |
| Organic 10s video views |
| Paid 10s video views |
| Auto-played 10s video views |
| Clicked to play 10s video views |
| 10s video views with sound on |
| Total video views with sound on |
| Total 30s video views |
| Unique 30s video views |
| Organic 30s video views |
| Paid 30s video views |
| Auto-played 30s video views |
| Clicked to play 30s video views |
| Total video reactions |
| Video reactions: like |
| Video reactions: love |
| Video reactions: wow |
| Video reactions: haha |
| Video reactions: sad |
| Video reactions: angry |
| Dimensiones |
| Date |
| Video length (s) |
| Video title |
| Universal video ID |
| Video ID |
| Video description |
| Video content category |
| Video live status |
| Video post publish status |
| Video image URL |
| Video source URL |
| Video permalink URL |
| Video embeddable |
| Video embed HTML |
| Is crossposting eligibility |
| Is Instagram eligibility |
| Video creation time of the day |
| Video backdated time |
| Page ID |
| Page name |
Interacción con los Reels
Esta tabla contiene información completa sobre el engagement de tus reels en Facebook.
Ejemplo:
| Interacción con los Reels |
| Métricas |
| Reels play count |
| Reels Unique Impressions |
| Reels average video time watched |
| Reels likes |
| Reels Shares |
| Reels total view time |
| Dimensions |
| Date |
| Video length (s) |
| Video title |
| Universal video ID |
| Video ID |
| Video description |
| Video content category |
| Video live status |
| Video post publish status |
| Video image URL |
| Video source URL |
| Video permalink URL |
| Video embeddable |
| Video embed HTML |
| Is crossposting eligibility |
| Is Instagram eligibility |
| Video creation time of the day |
| Video backdated time |
| Video backdated time granularity |
| Page ID |
| Page name |
Insights de ubicación
Esta tabla contiene información de la ubicación de tu audiencia en Facebook. Puedes hacer esta tabla con la dimensión País (Country) o Ciudad (City).
Ejemplo:
| Insights de ubicación - País |
| Dimensiones |
| Date |
| Country |
| Page name |
| Page ID |
| Métricas |
| Total likes |
| Total reach |
| Insights de ubicación - Ciudad |
| Dimensiones |
| Date |
| City |
| Page name |
| Page ID |
| Métricas |
| Total likes |
| Total reach |
Insights demográficos
Esta tabla contiene información demográfica sobre tu audiencia en Facebook.
Ejemplo:
| Insights demográficos |
| Dimensiones |
| Date |
| Age |
| Gender |
| Gender Age |
| Page name |
| Page ID |
| Métricas |
| Total likes |
| Total reach |
Si sigues teniendo dudas o preguntas no dudes en ponerte en contacto con nosotros a través del chat en directo de nuestro sitio web o por correo electrónico. ¡Estaremos encantados de ayudarte!