power query 调用百度推广 api 查看搜索词报告

经常需要下载百度推广搜索词报告比较麻烦，因此想通过百度推广api直接下载数据然后通过回写回传到数据库进行分析

百度推广api地址

https://dev2.baidu.com/content?sceneType=0&pageId=100700&nodeId=543&subhead=%E8%BF%94%E5%9B%9E%E4%BF%A1%E6%81%AF

M函数

let
   content="{
    ""header"": {
        ""token"": ""xxx"",
        ""username"": ""xxx"",
        ""password"":""xxx""
    },
    ""body"": {
        ""realTimeQueryRequestType"":{
        ""performanceData"":[
            ""cost"",
            ""cpc"",
            ""click"",
            ""impression"",
            ""trans"",
            ""bridgetrans"",
            ""mixWmatchEnum"",
            ""wMatchId"",
            ""querystatus""
        ],
        ""startDate"":""2021-07-20"",
        ""endDate"":""2021-07-20"",
        ""levelOfDetails"":12,
        ""statRange"":2,
        ""reportType"":6,
        ""unitOfTime"":5,
        ""attributes"":[
            {

            }
        ]
    }
            }

        }
    }
}",

  Source = Json.Document(Web.Contents("https://api.baidu.com/json/sms/service/ReportService/getRealTimeQueryData",[Content = Text.ToBinary(content) 
             ]   
        )),
    body = Source[body],
    data = body[data],
    table = Table.FromRecords(data),
    已添加自定义 = Table.AddColumn(table, "自定义", each Record.FromList([queryInfo],{"帐户名称","计划名称","单元名称","关键词","创意标题","创意描述","创意描述2","创意URL","推广渠道","-"})),
    已添加自定义1 = Table.AddColumn(已添加自定义, "自定义.1", each Record.FromList([kpis],{"花费","平均点击价格","展现","点击","点击率","网页转化","商桥转化","匹配模式","账户添加状态"})),
    删除的列 = Table.RemoveColumns(已添加自定义1,{"queryInfo", "kpis"}),
    #"展开的“自定义”" = Table.ExpandRecordColumn(删除的列, "自定义", {"帐户名称", "计划名称", "单元名称", "关键词", "创意标题", "创意描述", "创意描述2", "创意URL", "推广渠道", "-"}, {"帐户名称", "计划名称", "单元名称", "关键词", "创意标题", "创意描述", "创意描述2", "创意URL", "推广渠道", "-"}),
    #"展开的“自定义.1”" = Table.ExpandRecordColumn(#"展开的“自定义”", "自定义.1", {"花费", "平均点击价格", "展现", "点击", "点击率", "网页转化", "商桥转化", "匹配模式", "账户添加状态"}, {"花费", "平均点击价格", "展现", "点击", "点击率", "网页转化", "商桥转化", "匹配模式", "账户添加状态"})
in
    #"展开的“自定义.1”"

 

百度推广整体api接口都是想当完善，可以直接通过调用api接口获取数据，同理如果你需要营销通的数据也可以通过api接口调取

重点M函数解析

Web.Contents（API接口地址，[header：xxxx，body：xxxx]）

注意事项

接口位置，以及power bi 有2个“”