This Google Sheets add-on integrates with SEOmonitor’s APIs and allows you to easily import SEOmonitor data directly into your documents, while also organizing and formatting the data.
How does this work?
In the Google Workspace Marketplace, you’ll find the SEOmonitor add-on for Sheets:
Once you install it, you’ll find it directly in Sheets, under Extensions:
You’re prompted to insert your SEOmonitor API key – just for the first time, as it is then saved in Sheets (until you remove it).
You then select the campaign and the type of data you need to have extracted:
You can also create scheduled updates on your reports using the Extension. For all the reports with a date range timeframe, you can choose daily, weekly, or monthly updates. At the time of creation, you can see when the subsequent updates will be. For instance, the below report is set to be updated with the data of the last 30 days, every Wednesday.
Objective/Forecast - gives you the month-over-month breakdown of the estimation versus the actual performance;
Organic Traffic Performance - daily traffic data for the selected timeframe, for both branded and non-branded segments;
Keywords Ranks - daily ranks, for both desktop and mobile, over the selected timeframe;
Keyword Competitors - top 100 ranking landing pages (desktop or mobile) for the chosen day, on a given keyword;
Competitors' Rankings - ranks and changes in the selected timeframe, on any competitor;
Group Performance - gives you the current Visibility and the trend, for either a specific group or across the full list of groups in the campaign;
Daily Visibility - for the selected groups, in the given timeframe, on the chosen device; also provides the annotations, if any;
Competitors' Daily Visibility - visibility and chart annotations, on any competitor, on the selected device.
Each data set comes with its own set of options, like the timeframe, the device, or the keyword groups. If you still want to go through the platform interface and selectors, you can read more about the direct CSV exports in this article.
Sometimes you want to further process the data from the platform in spreadsheets, with the tools offered by this kind of product – filters, sorting, pivots, etc – or to merge it with data from other sources.
You will also be able to run scheduled reports, based on your own automation.