ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Field NameField FormatField ValuesField TypeField Description
2
account_idintegerdimensionThe account id
3
fb_account_idintegerdimensionThe Facebook account id
4
idstringdimensionThe id for the metric
5
ig_idintegerdimensionThe ig id
6
media_typestringCAROUSEL_ALBUM
IMAGE
VIDEO		dimensionThe type of media
7
media_urlstringdimensionThe url for the media item
8
owner_idbigint
9
permalinkvarchardimensionThe Instagram permanent link to a media item
10
shortcodevarchardimensionThe shortcode for the media item
11
timestamptimestampdimensionThe timestamp for the media item
12
captionstringdimensionUser generated text related to a posted media item. Can include hashtags.
13
thumbnail_urlstringdimensionThe thumbnail url for the media item
14
ob_datedatesystemA system generated field representing the date that was used in the request to retrieve data from source.
15
ob_transaction_idstringsystemA system generated unique id based on the hash of all field values for each row of data
16
ob_file_namestringsystemA system generated field including the s3 path and file name from which the data was loaded.
17
ob_processed_atstringsystemA system generated field representing the timestamp that file processing started.
18
ob_modified_datedatesystemA system generated field representing the timestamp that file processing started.
19
20
Note: Instagram story insights data is only available for 24 hours after a story is posted and is ephemeral in nature. We capture snapshots of the data on an hourly basis and store the most recent data
21
for each media id. Becuase of its ephemeral nature, historical data is not available for Instagram stories and any data gaps caused by upstream issues with the Instagram API cannot be back-filled.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100