This feature can be used to overcome shortcomings of the data source API not being able to pull older periods of historical data or to help quicken the loading or larger data sets.
In case your query doesn't have Date dimension available, look in to "How Do I Use the "APPEND_RESULTS" Setting?" solution article.
- Set up your query as usual in the Supermetrics sidebar.
- Set the date range settings for as far back as you need data, or as far back as the data source allows for. For simplicity, this example is set to the last week, but you can also do this with the last year or several years.
- Navigate to the Options section and check the box for "Combine new results with old" to enable the feature. Any refresh after this point will append the data to the bottom of the existing data.
- Run the query to populate the data into the sheet.
In this example we have selected our metrics and Date as the Split to rows dimension. Use the Date dimension to clearly see how your new results are appended with old ones.
- Click on any of the cells that have data by this query. When the Query actions menu opens up in the sidebar, click Modify to go back to editing the query you just created.
- Go to the date range setting and update it to a smaller range - one week, last 2-3 days, etc. - whatever is appropriate to update the data in the refresh window you are going to use.
You can also use custom date ranges to set values such as "Today" or "-X days", if you have very specific windows you need to check and need your data to update dynamically.
- Run the query again by clicking on Apply changes. Now each time the query is run in the future it will append the missing data to the end, depending on the time window you set. Note that it should not add duplicate dates/rows, but only append what is new/missing.
- The final step, which is optional, is to set up a refresh schedule so that this is updated automatically! For directions on how to set this up, see Can I schedule my reports to be refreshed or emailed at specific intervals?.
There's a couple of known issues with this setting to be aware of:
- This only works when the "date" dimension is included in the query. Otherwise it's unable to tell what is old versus new data.
- If using this setting with a source that tracks conversions (Facebook Ads, Google Ads, etc.), make sure the minimum date range of the query is as long as the longest conversion window. For example, if using 28-click, you would want the range to be at least 28-days long to ensure those click counts are updated properly.
- We currently do not support the splitting by column instead of row for the date dimension. You have to split by row for now to get it to work properly.
- If you enable the feature after the first run as been completed and there's already data, it may cause unexpected behavior (header row re-added, data offset, etc.) To avoid this, you want to start a new query with the setting already enabled before you run it for the first time. If you missed this, you can still fix it though by deleting all the existing data, enabling the setting and then pulling the old historical data, and then changing the date range to the permanent setting.